I've started getting database errors now when some users do something I don't know:
Database error in vBulletin 3.0.3:
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_option s.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,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
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 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 editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,1229,1234)
ORDER BY dateline
mysql error: Got error -1 from table handler
mysql error number: 1030
Date: Monday 18th of October 2004 08:53:13 PM
Script:
http://www.burnleyweb.com/forum/show...ted=1#post1234
Referer:
http://www.burnleyweb.com/forum/show...=1229#post1229
Username: dellym
IP Address: XX.XX.XXX.XXX
I've had a few of these e-mails now concerning different members. I have the uCash / uShop hack installed too.