[Bitsys]

See if you are experiencing one of the following symptoms:

• All of my users are being labeled as "Guest" in the postbit template.
• No posts are showing up.
• None of the RPG variables will display in the postbit. The element/gender/class images are broken.
• I get database errors when I go to showthread.php

If you are experiencing one or more of the above problems, then your showthread.php file was not edited correctly by the installer. This problem usually occurs on boards with other hacks installed that modify the queries in showthread.php. Please do the following:

In showthread.php, find the following code 2 times:

PHP Code:

attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter 


and AFTER it, add the following (ONLY IF IT IS NOT THERE ALREADY):

PHP Code:

,
user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,items_options.pointfield,items_options.lesanestore,battle_options.namefield,battle_options.exprate,battle_options.privacy AS battleprivacy,items_user.*,battle_stats.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
        rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename 


(Yes, the comma at the very top is there on purpose. Do not forget to place the comma in showthread.php or else you will get database errors.)

In showthread.php, find the following code 2 times:

PHP Code:

FROM post
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')." 


and CHANGE it to the following (ONLY IF IT DOES NOT LOOK LIKE THIS ALREADY):

PHP Code:

FROM post, battle_options, items_options
".iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')." 


In showthread.php, find the following code 2 times:

PHP Code:

LEFT JOIN userfield ON userfield.userid=user.userid 


and BELOW it, add the following (ONLY IF IT DOES NOT LOOK LIKE THIS ALREADY):

PHP Code:

LEFT JOIN items_user ON items_user.userid=user.userid
LEFT JOIN battle_stats ON battle_stats.userid=user.userid
LEFT JOIN rpg_classf ON rpg_classf.id=user.rpgclass
LEFT JOIN rpg_classm ON rpg_classm.id=user.rpgclass
LEFT JOIN rpg_element ON rpg_element.elementid=user.element
LEFT JOIN rpg_race ON rpg_race.raceid=user.rpgrace AND rpg_race.alignmentid=user.alignment 


Do not forget to do ALL of the above edits 2 times!

After doing all of this, run DB Fix.

If all of the code is there, then you may have a different problem. However, doing the above edits will rectify problems in 95% of the cases.