What Does TABLE_PREFIX means?

[White_Snake]

well i been looking this on some mods that requiere mySQL operations, but im not sure what does TABLE_PREFIX means so i would be good if someone can tell me what does it means?

btw im looking this on vb 3.5.0 RC2

[Adrian Schneider]

It's the table prefix you used on all your vbulletin tables... you specify it when installing.

If you installed using "vb3_" then

PHP Code:

$db->query_read("
    SELECT *
    FROM " . TABLE_PREFIX . "user
    WHERE userid = '" . $vbulletin->userinfo['userid'] . "'
    LIMIT 1
"); 


would query the correct table, whereas

PHP Code:

$db->query_read("
    SELECT *
    FROM user
    WHERE userid = '" . $vbulletin->userinfo['userid'] . "'
    LIMIT 1
"); 


would not, because the table is called "vb3_user", not "user".

If you don't have table prefixes, it won't affect anything (because the constant is equal to "").

[White_Snake]

i see, thanks a lot that was quick and a very clear explained too thank you again

[Come2Daddy]

I came here by searching, very good answer
Thank you