The Arcive of vBulletin Modifications Site. |
|
![]() |
|||||||||||||||||||||||||
This is where all questions are answered. You are obliged to read the FAQ, because any question that are answered in the FAQ will be ignored.
I do still work on the hack. I don't have any plans of ever abandoning the hack. Slow, maybe. Gone? Never! ![]()
Code:
Database error in vBulletin 3.0.5: Invalid SQL: SELECT post.*, post.username AS postusername, post.ipaddress AS ip, user.*, userfield.*, usertextfield.*, user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,rpg_battle_options.namefield,rpg_battle_options.exprate,rpg_battle_options.p rivacy AS battleprivacy,rpg_items_user.*,rpg_battle_stats.*,rpg_rpg_race.name AS rpgracename,rpg_rpg_race.alignment AS rpgalignmentname,rpg_rpg_classf.name AS fclassname, rpg_rpg_classf.folder AS fclassfolder,rpg_rpg_classm.name AS mclassname,rpg_rpg_classm.folder AS mclassfolder,rpg_rpg_element.name AS elename, icon.title as icontitle, icon.iconpath, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid ,avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline ,level, NOT ISNULL(deletionlog.primaryid) AS isdeleted, post_parsed.pagetext_html, post_parsed.hasimages FROM post AS post, rpg_battle_options, rpg_items_options LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid) LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post') LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid) WHERE post.postid = 12117 mysql error: Column: 'type' in on clause is ambiguous mysql error number: 1052 Well then, all you have to do is delete the "AND type = 'post'", then it will go away. But I really suggest to upgrade to the latest version, as this query appears to come from an outdated and unsupported version.
Code:
Database error in vBulletin 3.0.8: Invalid SQL: SELECT post.*, post.username AS postusername, post.ipaddress AS ip, user.*, userfield.*, usertextfield.*, userfield.field 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, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, post_parsed.pagetext_html, post_parsed.hasimages, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM Forumspost AS post LEFT JOIN Forumsuser AS user ON(user.userid = post.userid) LEFT JOIN Forumsuserfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN Forumsusertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN Forumsicon AS icon ON(icon.iconid = post.iconid) LEFT JOIN Forumsavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN Forumscustomavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN Forumsdeletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post') LEFT JOIN Forumseditlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN Forumspost_parsed AS post_parsed ON(post_parsed.postid = post.postid) LEFT JOIN Forumsrpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid) LEFT JOIN Forumsrpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid) LEFT JOIN Forumsrpg_class AS rpg_class ON(rpg_class.id=user.rpgclass) LEFT JOIN Forumsrpg_element AS rpg_element ON(rpg_element.elementid=user.element) LEFT JOIN Forumsrpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan) LEFT JOIN Forumsrpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace) AND rpg_race.alignmentid=user.alignment WHERE post.postid IN (0,47,48,50,51,55,57,59,60,113) ORDER BY dateline mysql error: Unknown column 'userfield.field' in 'field list' mysql error number: 1054 Have a question you feel should be added here? PM me ![]() Show Your Support
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|