[trafix]

Today at 02:57 PM DPoole said this in Post #48
I have now just installed this to a test board - no store installed and only did the first part of the hack and left out the store integration - Also turned store off in Admin CP as well

Note the following error :

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT storename,pointname,ban FROM storeadmin
mysql error: Table 'testboard.storeadmin' doesn't exist

mysql error number: 1146

so whys it askin for store when it aint installed and the option is set to No in admin CP

ooooops....try this ....find

PHP Code:

$yesstore = $DB_site->query_first("SELECT storename,pointname,ban FROM storeadmin");
$jukeboxadmin=$DB_site->query_first("SELECT * FROM jukeboxadmin WHERE event='1'");
$caniplay=$jukeboxadmin[playtype];
$isstore=$jukeboxadmin[storehack]; 


replace with

PHP Code:

$jukeboxadmin=$DB_site->query_first("SELECT * FROM jukeboxadmin WHERE event='1'");
$caniplay=$jukeboxadmin[playtype];

if($jukeboxadmin[storehack]=="1") {
$yesstore = $DB_site->query_first("SELECT storename,pointname,ban FROM storeadmin");
$isstore=$jukeboxadmin[storehack];
} 


sorry