[how-to] Cache some table

[Milad]

How to cache a table and insert it into datastore table or in datastor file?

like forumcache

thanks in advance

[Nullifi3d]

Are you asking how to store a table's fields in a php variable? as $vbulletin->userinfo stores the user table?

[Milad]

No
Something like $vbulletin->cacheforum

[Nullifi3d]

Sorry, I'm not quite sure what you're referring to. Maybe someone else will know.

[Milad]

$vbulletin->forumcache exactly

thank you

[Nullifi3d]

What do you want to cache? A mysql table (as you said in your first post) or a forum?

[Milad]

Now I'm working on a hack for vBulletin and I want to cache my categories to deal easily with them.

Of course categories are in new table

[Nullifi3d]

In that case you use php code like this:

PHP Code:

$tableinfo = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "tablename WHERE userid = " . $_REQUEST['userid']); 


You would change tablename to the name of the mysql table that is storing you hack's data. the * tells mysql to store (cache) each row in that table in the variable $tableinfo (which you can name this whatever you want). This way if you have a row/field named username that stores the usernames for everyone the username for $_REQUEST['userid'] would be called with $tablename['username'];
If you need anymore help let me know.

[Milad]

Dear
This isn't caching, caching makes you avoid this query, I think.

thank you

[Nullifi3d]

Ohh, well I don't know then, sorry.