RPG Integration Hack v3

RPG Integration Hack v3

RPG Integration Hack (RPG hack for short) v3 is the latest version of the wBB convert of Bitsys' hack with the same name. For those that are unfamiliar with any of what I mentioned above, heres a quick rundown of what this hack is and does.
The RPG hack adds a whole new level of fun to a forum, by allowing uses to duke it out in a fierce battle. Use items to turn the tide of the battle, or use powerful spells to bring down an opponent. Or you can just rely on the good old sword to cut your enemy down to size!
Create or join a clan to amass an army and conquer the boards.
Patch yourself up after a hard battle.
Feeling lucky? Go bet on the lottery!

No RPG forum should be without. Administrator controls every single aspect of how the hack works, right down to every item and an user's level/stat gains.



Requirements/Limitations:
You NEED the uCS hack (uCash & uShop) installed for this hack to work.


Included there is a Features List, which contains a basic lowdown on the current features, so no need for me to list them all here.

Credits:

• Original vB2 code
• Bitsys
  
  RPG CP hack
• DeMiNe0
  
  wBB Conversion (with permission)
• Metal Gear/Tidus-X
  
  vB3 Conversion (with permission)
• NeoRevan
  
  ClanCP Hack
• Omega/Michael Cox
  
  Lottery Hack
• Omega/Michael Cox
  
  uCash/uShop
• GeekyDesigns
  
  Converter's Thanks
• Everyone that clicks install!
  
  Special Thanks To
• DeMiNe0 - For helping me tons with errors and features for the hack

IMPORTANT NOTICE!
Due to the Edit Thread Title time has run out, I will use the last number in the Mod Version to indicate Beta and/or Minor build number. I will also indicate what the current version is in the Post Title.


IMPORTANT NOTICE #2!
The way the RPG Stats are calculated changed radically for this version.
Your settings will most likely not work as you expect.
Please enter your AdminCP, then Edit Options under Battle, and change the Modifier to something else.
Recommended values:

• Power level modifier = 2.5
• HP Modifier = 15
• MP Modifier = 1
• PP Modifier = 0.5

The future
I am currently working on v4 of this hack, as revealed in my signature. I have chosen to brand it v4 because it will be a major recode of the core functions of this hack. Not only will it contain all the features listed in the Feature Suggestions thread corresponding to this version, but it will (as the next major vB) be more OOP oriented. If this doesn't make sense to you, then don't worry. For you, the end-user, this will only mean a faster and more feature packed RPG Integration Hack.
I have chosen to set its ETA that far off into the future because I personally have a problem with deadlines for coding projects, especially one as expansive as this. Secondly, it would only be worse if I set it to "Summer 2005" and then fail to deliver, or have to deliver a half-finished, half-featured product. I have every reason to believe I will be able to keep this deadline, because so far, the development is going great.
This version will also contain majorly tweaked templates, as I have recently severely improved my template skills.

The announcement of this development means that with each proceeding file, my ability to provide support for v3 of this file will be lessened. So I suggest you go find those last bugs ASAP
If the onslaught of bugs that are still to be found proves to be larger than what I expect, I will make a "middle-release" branded 3.5, which would contain no new features.
How this plays out, is yet to be seen.



What's new in v3?

• Settings moved to $vboptions for query efficiency
• Multiple exploits in heal.php fixed
• Multiple exploits in Battle Arena fixed
• Advanced installer, capable of:
  • Preserving even your carefully tuned settings into the new version
  • Automatically insert phrases and templates from an .xml file
  • Repair certain parts of your installation (Query Repair currently not working)
  • Examine your version info, and detect if you can upgrade your version (does NOT include any "call home" functions - feel free to check all you want)
  • Uninstall everything concerning databases, NO trace of the hack will remain.
• Query load SEVERELY reduced, especially in showthread.php
• Stat calculations revamped, they are way more fair to newbies now
• And probably something else I forgot at the moment.

Last Update of this hack: 26th June 2005 12:32 GMT+1
Changelog


For support, please visit the RPG Integration Hack Support Forums
All support queries in this thread will be ignored by me.

If you use this mod,

Click it!

If you wish to support me in the development of the hack,

Your donations are most appreciated

[TTG]

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.

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

[Revan]

This is not the support thread.
I will also add a FAQ entry for this error.

[SHARKY]

where do we go for support?

i cant get the battleinstall.php to run and also not all users have the stats and stuff under thier name in thier post

can someone atleast point me in the right direction please

very nice hack by the way.... ty

[TTG]

Any news on an update for the above bug ?

[Revan]

If people would check its supportforum, under the Premium Modifications forum, they would see this bug has been added to the FAQ listings just as I said.

[TTG]

Originally Posted by Revan

Well then, all you have to do is delete the "AND type = 'post'", then it will go away.

Might be a good idea to tell we mere mortals which file edit needs to be ammended to 'make it go away'

[bozzy]

SPELLS STILL DO NOT WORK

I added a spell category, added some spells, gave each a buff, and they still do not work.

I gave buffs to potions and those still do not work.

I have reached the conclusion that this hack does not work.

You are also no help. All I ever get is "it works for us, you're doing something wrong" when I am NOT doing anything wrong. The hack just does not work.

Also if you try to wager more money than your opponent has, you lose that money.

I'm going to be uninstalling this hack.

[bozzy]

Originally Posted by Revan

If people would check its supportforum, under the Premium Modifications forum, they would see this bug has been added to the FAQ listings just as I said.

what support forum? this is the only thread about this hack.

[Slybone]

Originally Posted by bozzy

what support forum? this is the only thread about this hack.

https://vborg.vbsupport.ru/forumdisplay.php?f=102