[Otikeu]

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.