PDA

View Full Version : Need Help Badly


cyberxp9
15 Jul 2005, 14:14
In this thing the RPG hack i got that long sql error
he says
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.
______________________________________________________--
Ok i got to questions for that,
#1 My thing is up to date so whats wrong
#2 where do I delete "AND type = 'post'"

In this thing the RPG hack i got that long sql error
he says
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.
______________________________________________________--
Ok i got to questions for that,
#1 My thing is up to date so whats wrong
#2 where do I delete "AND type = 'post'"

man noone ever reads my posts

Chris M
15 Jul 2005, 14:35
You need to post this in the hack thread or in the General Modification Discussions forum :)

Satan

Revan
15 Jul 2005, 14:48
In this thing the RPG hack i got that long sql error
he says
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.
______________________________________________________--
Ok i got to questions for that,
#1 My thing is up to date so whats wrong
#2 where do I delete "AND type = 'post'"



man noone ever reads my postsHey mate if I missed your post, then just bloody bump it after 24h. If it hasnt been 24h yet, then know I have a life outside this forum too.
And I remember a post like this, I beleive I answered "You delete it from the file that gives you the query error", be it showthread or showpost.

Zachery
15 Jul 2005, 15:19
Moved to the corret place

cyberxp9
15 Jul 2005, 21:43
Moved to the corret place

k sorry, but I have vb 3.07 do you know what is wrong?

k sorry, but I have vb 3.07 do you know what is wrong?

just got same error see
Database error in vBulletin 3.0.7:

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 post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
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 deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
LEFT JOIN rpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid)
LEFT JOIN rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid)
LEFT JOIN rpg_class AS rpg_class ON(rpg_class.id=user.rpgclass)
LEFT JOIN rpg_element AS rpg_element ON(rpg_element.elementid=user.element)
LEFT JOIN rpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan)
LEFT JOIN rpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace)
AND rpg_race.alignmentid=user.alignment

WHERE post.postid IN (0,182)
ORDER BY dateline

mysql error: Unknown column 'userfield.field' in 'field list'

mysql error number: 1054

Revan
15 Jul 2005, 23:39
http://www.vbulletin.org/forum/showthread.php?t=91924
Should take care of that.
And no, I don't hate you. I just think you should have some patience for the future.

cyberxp9
16 Jul 2005, 00:24
k but where do I go to admincp>battle,edit options, then were cause i dont know what u mean by the point field, what is that, can you give a better explanation, sorry if im acting stupid

Revan
16 Jul 2005, 11:08
admincp>battle,edit options is correct, make sure the Point Field setting is the same as what you find further down in the Profile Field manager.
If the Profile Field id is 5, then the Point Field setting should be "field5" without the quotes.

cyberxp9
17 Jul 2005, 21:01
Thanks :) :) :)