Version: , by cyberxp9
Developer Last Online: Dec 2006
Version: Unknown
Rating:
Released: 07-15-2005
Last Update: Never
Installs: 0
No support by the author.
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'"
Quote:
Originally Posted by cyberxp9
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
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
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
Hey 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.
k sorry, but I have vb 3.07 do you know what is wrong?
Quote:
Originally Posted by cyberxp9
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'
<a href="https://vborg.vbsupport.ru/showthread.php?t=91924" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=91924</a>
Should take care of that.
And no, I don't hate you. I just think you should have some patience for the future.
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
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.