[[GetLastMyBBPosts]] - Etomite snippet

[DennisTT]

This is a snippet for Etomite to retrieve the last 10 posts from MyBB. It wasn't meant to be a released code so you will have to dig into the code if you wish to modify something (which you will have to do to get it working if your database name is not `dennistt` )

[tsakalos]

mysql_connect($etomite->dbConfig['host'], $etomite->dbConfig['user'], $etomite->dbConfig['pass']) or die(mysql_error());

is this the place to add the mybb database ? give me an example to see how i can edit it thx

[DennisTT]

It's on the line below that,

PHP Code:

mysql_select_db('dennistt'); 


change that to whatever your database name is

[tsakalos]

i changed the denisstt with mybb database but it didnt work. shall i edit anything more? user pass or anything? should the mubb and etomite be in the same db for it to work ? cause i use 2 different dbs

[DennisTT]

Sorry, I forgot to mention that you have to change the table prefix to match yours in every single query.

[tsakalos]

what do u mean? which table prefix and should mybb db and etomite db be in the same db ?

[DennisTT]

tsakalos Wrote:what do u mean? which table prefix

PHP Code:

$result = mysql_query("SELECT canview FROM [b][u]mybbforum_[/b][/u]usergroups WHERE gid = 1") or die(mysql_error()); 


You have to search for all those mybbforum_ and change that to whatever your MyBB table prefix is (usually mybb_ )

tsakalos Wrote:and should mybb db and etomite db be in the same db ?

It doesn't matter as long as your settings are correct.

[tsakalos]

Access denied for user 'greek_etu'@'localhost' to database 'greek_mybb'

[DennisTT]

Oh sorry, if you are not using your etomite database, you should change

Code:

mysql_connect($etomite->dbConfig['host'], $etomite->dbConfig['user'], $etomite->dbConfig['pass']) or die(mysql_error());

to

Code:

mysql_connect('localhost', 'yourdbuser', 'yourdbpass') or die(mysql_error());

[zaher1988]

hey there

ihavent looked yet at the code, but from what i read, i have a question,can't that exceed the number of 10 last posts?? can we make it more.

and what do u mean by last posts , will it show the posts as u see them in view new posts, or show the title of the thread and u see it in the index or any category (such the one they have in msgplus.net "get latest posts"!)

thx in advance
chaw