Quote:
|
Originally Posted by FASherman
When is this hack going to support prefixed tables?
|
I'll answer my own question: NOW.
Instructions to make this hack work with prefixed tables.
1. EDIT THE INSTALL SCRIPT (admincp/vbug_install.php)
--------------------------------------
FIND:
PHP Code:
$DB_site->query("INSERT INTO datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:10:\"statusname\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:10:\"statusname\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:10:\"statusname\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:10:\"statusname\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:10:\"statusname\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:10:\"statusname\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:10:\"statusname\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:10:\"statusname\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:10:\"statusname\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:10:\"statusname\";s:9:\"Won\'t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:10:\"statusname\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:12:\"severityname\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:12:\"severityname\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:12:\"severityname\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:12:\"severityname\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:8:\"typename\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:8:\"typename\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:11;a:2:{s:8:\"typename\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:12;a:2:{s:8:\"typename\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:13;a:2:{s:8:\"typename\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:14;a:2:{s:8:\"typename\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:15;a:2:{s:8:\"typename\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:16;a:2:{s:8:\"typename\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:17;a:2:{s:8:\"typename\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:18;a:2:{s:8:\"typename\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:19;a:2:{s:8:\"typename\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:20;a:2:{s:8:\"typename\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:11:\"versionname\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");
REPLACE WITH
PHP Code:
$DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('bugcache', 'a:4:{s:6:\"status\";a:12:{i:1;a:2:{s:10:\"statusname\";s:11:\"Unconfirmed\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:10:\"statusname\";s:9:\"Confirmed\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:10:\"statusname\";s:14:\"Closed (Fixed)\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:10:\"statusname\";s:9:\"Duplicate\";s:12:\"displayorder\";s:1:\"4\";}i:5;a:2:{s:10:\"statusname\";s:17:\"Awaiting Feedback\";s:12:\"displayorder\";s:1:\"5\";}i:6;a:2:{s:10:\"statusname\";s:5:\"Bogus\";s:12:\"displayorder\";s:1:\"6\";}i:7;a:2:{s:10:\"statusname\";s:20:\"Closed (No Response)\";s:12:\"displayorder\";s:1:\"7\";}i:8;a:2:{s:10:\"statusname\";s:19:\"Working As Designed\";s:12:\"displayorder\";s:1:\"8\";}i:9;a:2:{s:10:\"statusname\";s:17:\"Browser Bug/Issue\";s:12:\"displayorder\";s:1:\"9\";}i:10;a:2:{s:10:\"statusname\";s:9:\"Won\'t Fix\";s:12:\"displayorder\";s:2:\"10\";}i:11;a:2:{s:10:\"statusname\";s:12:\"Design Issue\";s:12:\"displayorder\";s:2:\"11\";}i:12;a:2:{s:10:\"statusname\";s:11:\"Style Issue\";s:12:\"displayorder\";s:2:\"12\";}}s:8:\"severity\";a:4:{i:1;a:2:{s:12:\"severityname\";s:7:\"Trivial\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:12:\"severityname\";s:5:\"Minor\";s:12:\"displayorder\";s:1:\"2\";}i:3;a:2:{s:12:\"severityname\";s:5:\"Major\";s:12:\"displayorder\";s:1:\"3\";}i:4;a:2:{s:12:\"severityname\";s:8:\"Critical\";s:12:\"displayorder\";s:1:\"4\";}}s:4:\"type\";a:12:{i:1;a:2:{s:8:\"typename\";s:3:\"Bug\";s:12:\"displayorder\";s:1:\"1\";}i:2;a:2:{s:8:\"typename\";s:4:\"ToDo\";s:12:\"displayorder\";s:1:\"2\";}i:11;a:2:{s:8:\"typename\";s:15:\"Feature-Request\";s:12:\"displayorder\";s:1:\"3\";}i:12;a:2:{s:8:\"typename\";s:8:\"Admin CP\";s:12:\"displayorder\";s:1:\"4\";}i:13;a:2:{s:8:\"typename\";s:28:\"Integration (Calendar/Forum)\";s:12:\"displayorder\";s:1:\"5\";}i:14;a:2:{s:8:\"typename\";s:20:\"Installation/Upgrade\";s:12:\"displayorder\";s:1:\"6\";}i:15;a:2:{s:8:\"typename\";s:17:\"Language/Phrasing\";s:12:\"displayorder\";s:1:\"7\";}i:16;a:2:{s:8:\"typename\";s:9:\"Templates\";s:12:\"displayorder\";s:1:\"8\";}i:17;a:2:{s:8:\"typename\";s:9:\"Leader CP\";s:12:\"displayorder\";s:1:\"9\";}i:18;a:2:{s:8:\"typename\";s:15:\"General/Unknown\";s:12:\"displayorder\";s:2:\"10\";}i:19;a:2:{s:8:\"typename\";s:5:\"Email\";s:12:\"displayorder\";s:2:\"11\";}i:20;a:2:{s:8:\"typename\";s:10:\"Suggestion\";s:12:\"displayorder\";s:2:\"12\";}}s:7:\"version\";a:1:{i:1;a:2:{s:11:\"versionname\";s:4:\"Test\";s:12:\"displayorder\";s:1:\"1\";}}}')");
-------------------------------------
FIND:
PHP Code:
$DB_site->query("INSERT INTO datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')");
REPLACE WITH:
PHP Code:
$DB_site->query("INSERT INTO ".TABLE_PREFIX."datastore VALUES ('vbugs_version', 's:5:\"1.0.2\"')");
SAVE INSTALL SCRIPT
================================================== ========
2. EDIT vbugs.php
---------------------------------
FIND:
PHP Code:
SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbugs
LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)
REPLACE WITH:
PHP Code:
SELECT DISTINCT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname, vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbugs
LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)
----------------------------------
FIND:
PHP Code:
SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbugs
LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user ON (vbugs.userid = user.userid)
REPLACE WITH:
PHP Code:
SELECT vbug_severity.severityname, vbug_type.typename, vbug_version.versionname, vbug_status.statusname ,vbugs.*, admin.username AS adminname, user.username, user.usertitle, lastreply.username AS lastreplyname
FROM vbugs
LEFT JOIN vbug_status ON (vbugs.vbug_statusid = vbug_status.vbug_statusid)
LEFT JOIN " . TABLE_PREFIX . "user AS admin ON (vbugs.adminid = admin.userid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (vbugs.userid = user.userid)
SAVE vbugs.php
================================================== ========
3. Follow the instructions contained in the install.txt file
More Information