Some queries and plugin help
 

I am making a plugin and just wondered, what should I use to call data from the database? i.e. what should replace mysql_query() and mysql_result()

Thanks

This page from the manual should help - SQL Query Syntax

Okay a few questions. I have been using similar things but I get this error:

Then what is the difference between query_read and query_first?

And how can I do mysql_result?

query_first means you don't have to do a fetch_array after doing the query - it is for when you only expect one row from your query.

Take a look at the vbulletin code in your files. There are lots and lots of examples in there.

Your error is most likely from a plugin. Look at line 265 in class_postbit. My guess is it is a hook and thus you have an error in a plugin that uses that hook location.

Inside vBulletin classes, you must access the vBulletin registry object (which contains the database object) via because $vbulletin and $db are not in scope. Your code would be something like this,

Perfect :)

And, I seem to be using $vbulletin ..... instead of $this :)