| Otikeu |
07-29-2005 07:48 PM |
Quote:
Originally Posted by tamarian
Try changing this line in showpost:
PHP Code:
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
To this:
PHP Code:
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
|
I can't find this line of code in showpost.php, is that the wrong file?
This is the only code the instructions told me to input into showpost.php
PHP Code:
// rpg
$sqlplug1 = "userfield.$vboptions[rpg_namefield] AS rpgname,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,
rpg_items_user.*,
rpg_battle_stats.*,
rpg_race.name AS rpgracename,
rpg_race.alignment AS rpgalignmentname,
rpg_class.name AS classname,
rpg_class.folder AS classfolder,
rpg_element.name AS elename,
rpg_clan.title AS clantitle,
";
$sqlplug2 = "LEFT JOIN " . TABLE_PREFIX . "rpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid)
LEFT JOIN " . TABLE_PREFIX . "rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid)
LEFT JOIN " . TABLE_PREFIX . "rpg_class AS rpg_class ON(rpg_class.id=user.rpgclass)
LEFT JOIN " . TABLE_PREFIX . "rpg_element AS rpg_element ON(rpg_element.elementid=user.element)
LEFT JOIN " . TABLE_PREFIX . "rpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan)
LEFT JOIN " . TABLE_PREFIX . "rpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace)
AND rpg_race.alignmentid=user.alignment
";
$totalcats = $DB_site->query_first("SELECT COUNT(*) AS countcats FROM " . TABLE_PREFIX . "rpg_items_cats");
of which I do not find
PHP Code:
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
inside of the code and outside. I am using the latest version since i just downloaded yesterday. |
More Information