This hack has been working great on 3.0.3 and 3.0.4
Just upgraded to vbulletin 3.0.5 and have now started getting this error :-
I've checked and re-checked all the file edits & all are correct.
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.privacy 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