Quote:
which parts exactly do you edit? say my prefix is called x_y
|
Open xml file in text editor find
PHP Code:
$count = $db->query_first("
SELECT
count(postid) AS count
FROM reputation
WHERE reputation.userid = " . $vbulletin->userinfo['userid'] . "
");
change to
PHP Code:
$count = $db->query_first("
SELECT
count(postid) AS count
FROM x_yreputation
WHERE x_yreputation.userid = " . $vbulletin->userinfo['userid'] . "
");
Basically add your prefix in front the 2 instances of reputation, after FROM and WHERE.
OOPS must of posted at the same time.