PDA

View Full Version : RPG Hack FAQ


Revan
06 Jan 2005, 18:17
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.




My items/weapons/spells/armor won't work in battle! Help!

Enter your Admin Control Panel, click on "Edit Items", then next to the category of the stuff that does not work in battle click on "Edit", then from the Battle Type dropdown, select the appropriate Battle Type. Then click Save.



I tried the above, but my items/weapons/spells/armor STILL won't work in battle!

Enter your Admin Control Panel, click on "Edit Items", then find the category you want to fix, and change the "Buff" value of the item, then save it.



"Buff"? Hey Revan, speak English!

Haha, ok. Buff controls alot of things.

If the Battle Type is Spells, it controls the Damage dealt/healed.
If the Battle Type is Items, it controls the Damage healed.
If the Battle Type is Weapons, it controls the Attack Power.
If the Battle Type is Armor, it controls the Defence Power.
If the Battle Type is Shields, it controls the amount of damage Shielded when used in battle.




When will the next version be released?

When it's ready. I admit, I'm not working 100% on it. I got school, friends on MSN, and I play online games like Final Fantasy XI and Lineage II (which I'm addicted to).
I do still work on the hack. I don't have any plans of ever abandoning the hack. Slow, maybe. Gone? Never! :)



When I try to view a thread, I get this long SQL error!

It wouldn't happen to look something like this:
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
eh?
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.


That wasn't my error, but I still have a MySQL error!

What about this one? 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: 1054Then you have to enter the AdminCP -> Battle -> Edit Battle Options -> RPG Name Field. Make sure this matches what field ID you see in the Profile Field Manager.



Have a question you feel should be added here? PM me :)