Retrieving Data from other Tables

[byon]

Hi

I've spent two days looking for good examples (mods) on how they would insert/update data from the other customised tables. I can't find any examples good for my vBB 3.6.5.

I'm trying to display couple of information in a table in relation to the userid of the user from this board.

I've been able to hack it into SMF easily but ain't able to figure out on this board i purchased yet. If possible please guide me to the right examples.


Thank you!

[Dismounted]

Are the tables in the same database? If so, use the vBulletin Database Class:

PHP Code:

$vbulletin->db->query_read("SELECT ......");
$vbulletin->db->query_write("UPDATE ......"); 


[byon]

Originally Posted by Dismounted

Are the tables in the same database? If so, use the vBulletin Database Class:

PHP Code:

$vbulletin->db->query_read("SELECT ......");
$vbulletin->db->query_write("UPDATE ......"); 


thanks dismounted.

yup.
some are. what about the other tables which are not in the same database?

secondly, how do i go about fetching these stuffs printed? or making it integrated like, $post[customdata], alike to how we fetch usernames with $post[musername]?

im in the midst of reading, http://www.vbulletin.com/docs/html/c...ards_sql_query,

thanks

[Dismounted]

All fields in the user table are fetched for each user's posts. For example, if you make a `car` field in the user table, each user's `car` field will be available using $post[car] in the postbit templates.

[byon]

oh. okay.
just wondering, can the templates found under admincp also be found as a template file?

[Dismounted]

No, templates are stored in the database.

[byon]

Originally Posted by Dismounted

No, templates are stored in the database.

thanks.

[Eikinskjaldi]

Originally Posted by byon

thanks dismounted.

yup.
some are. what about the other tables which are not in the same database?

prepend the table with the database name.


select blah from databae1.table1, database2.table2....

You can join tables from different databases, or just use the different database. MySQL does not care which databases tables live in, and accessing different databases has no effect on system performance.

[byon]

Originally Posted by Eikinskjaldi

prepend the table with the database name.


select blah from databae1.table1, database2.table2....

You can join tables from different databases, or just use the different database. MySQL does not care which databases tables live in, and accessing different databases has no effect on system performance.

Greetings,
This helps!

Thanks!