RPG Integration Hack /w Battle (BETA)

RPG Integration Hack BETA by Bitsys
(vBulletin versions 2.2.6?, 2.2.7, 2.2.8, 2.2.9, and 2.3.0)

This hack combines several RPG hacks into one and adds a battle hack. The hacks included in this hack are:

• Zajako's Ultimate HP/MP Stats Hack -----(https://vborg.vbsupport.ru/showthrea...threadid=37720)
• Zajako's RPG Elements Hack -----(https://vborg.vbsupport.ru/showthrea...threadid=35318)
• Zajako's In battle hack -----(https://vborg.vbsupport.ru/showthrea...threadid=42715)
• Zajako's RPname hack -----(https://vborg.vbsupport.ru/showthrea...threadid=43651)
• DV class hack used with permission of J2K (aka the RPG Class Hack v3.3) ----- (https://vborg.vbsupport.ru/showthrea...threadid=43558)
• Mewtwo's/Rake's Original Itemshop v5 -----(https://vborg.vbsupport.ru/showthrea...threadid=38090)

In addition to re-releasing thse hacks, I have added features to all of them (or else there would be no point in re-releasing).

• The RPG hacks are now all editable via the admin control panel.
• The itemshop has been somewhat optimized and some fixes are included that reduce queries in showthread.php and itemshop.php . Also, Lesane's Store Hack has been integrated with the Itemshop. This can be toggled in the admin cp.

This means that the RPG hacks are database driven and have been partially integrated with the Itemshop. This was necessary in order to make a battle hack, which is also included.

Since most people are familiar with the RPG and Itemshop hacks, I will give a brief description of the Battle hack. If you want more information about either of the other two hacks, then refer to their original posts or download the .zip file and read the "readme.txt". If you are a visual learner, then you can scroll down to the second post in this thread, which contains the pictures of all of these hacks.


Battle Features:

• The battle format is turn-based.
• HP, AP, PP, and MA are automatically deducted based on what action a user takes, the damage dealt to an opponent, etc.
• Opponents in battle can use spells, one-handed weapons, two-handed weapons, shields, potions, or their fists.
• A battle is over when a combatant dies, retreats, or there is a draw. Battles can also be ended via the admin control panel.
• A wager can be set on a battle. Whoever wins the battle recieves the amount of money as specified in the wager. Outside bets are not supported yet.
• Battles can be either public or private, as determined by the admin control panel. If private, battles require a password and battles can not be browsed. If public, then any user can view any battle, but only the original combatants can fight.
• The results of a battle can be posted into a designated "Battle" forum, as specified in the admin control panel.
• Inactive battles can be pruned.

Getting started with the battle hack:

• In order to get items to disply in the item shop, you must select which items go with which RPG Type in the "Edit Item Type" Menu of the admin cp.
• In order to assign which weapon categories do what kind of damage in battle, you must go to the "Edit Category" link located in the "Edit Items" menu of the admin cp. Select a Battle type for the category and save changes.
• In order to do damage to your opponent when in battle, you must assign the amount of damage each weapon does in the "Edit Items" menu of the admin cp. The default damage is set to 0. The same principle goes for armor, potions, spells, shields, etc.

Please refer to the screenshots or "readme.txt" for more information.


Why is this a BETA hack?

I have tested the installation of this hack on vBulletin versions 2.2.7, 2.2.8, 2.2.9, and 2.3.0. However, because of the scale of this hack, there is plenty of room for errors. Therefore I am making the following disclaimer while this hack is in the BETA stage:


WARNINGS:

• Do not install this hack on a production board. Please keep this hack, while in the BETA stage, to a test board. The reason for not installing this on a production board is that I cannot provide upgrade instructions for going from one version of the beta hack to the next version of the beta hack. Also, this hack does not have an un-install script yet. So please remember, if you decide to install this on a production board, you are doing so at your own risk.
  
• Do not apply this hack if you already have ANY of the included hacks installed. Please refer to the list at the top to see if you have any of the conflicting hacks installed. Since I am asking that you install this on a test board right now, this should not be a problem since you can re-install a fresh copy of vBulletin in under 5 minutes, as a test board of course.
  
• There is currently no upgrade script for installing this over any of the included hacks. I will make one when this beta is completed.
  
• If you choose to install the postbit features, then an additional query will be added to showthread.php. This query is a SELECT COUNT(*) query and adds around .001 seconds to the page generation. If you don't like the idea of adding an additional query to showthread.php, then you have the option of not installing that part of the hack. See the install file for more information.

Miscellaneous:

The beta of this hack is free. The full/final release will also be free.

All installation instructions and credits are included in the attachment. If you find a bug or have problems, feel free to post them here and I will try to fix them. Please read the included readme file if you have questions. If you can't find the answer, then post your question here and I will answer it.

All hacks included in this hack have been re-released with permission of their original creators.

Screenshots are in the second post of this thread.


Installation:

Installation instructions are included in the .zip file.


ACKK! I NEED HELP!!!

If you are having trouble and need some help, please refer to the help documentation included in the .zip file. It is located in the "extra" directory.

If you need help and you have already installed the hack, make sure you check the RPG Manual link in the admin cp. Also, make sure you read the FAQ included with the manual.

MY THREADS STOPPED DISPLAYING CORRECTLY!!!
See if you are experiencing one of the following symptoms:

• All of my users are being labeled as "Guest" in the postbit template.
• No posts are showing up.
• None of the RPG variables will display in the postbit. The element/gender/class images are broken.
• I get database errors when I go to showthread.php

If you are experiencing one or more of the above problems, then your showthread.php file was not edited correctly by the installer. This problem usually occurs on boards with other hacks installed that modify the queries in showthread.php. Please go to https://vborg.vbsupport.ru/showpost....postcount=2261 and follow the instructions there.


Add-ons:
The following add-ons are not included in the default installation. You must apply these add-ons after you have installed the hack successfully.

Member profile add-on
This add-on let's you display the user's RPG Stats in their member profile. See the .zip file for the add-on. It is located in the "Member Profile Add-on" directory.

Auto-update stats after posting
This add-on automatically updates the user's stats after they make a post, instead of having to click on the update stats button in the user cp. This add-on involves 2 file edits. The add-on is located at https://vborg.vbsupport.ru/showthrea...452#post356452

Donation Queue by Darkwaltz4
Moderate all Donations. See Who is Donating to Who. All Donations go through Admins or Mods. The add-on is located at https://vborg.vbsupport.ru/showthrea...652#post408652

Battle Background Midi System by Darkwaltz4
Full control over the music that plays during your battles! The add-on is located at https://vborg.vbsupport.ru/showthrea...530#post410530

Randomized First Turn Addon by Moreliator
"The following code gives the challenger a 33% chance to start the battle and the challenged person a 66% chance. Works quite well. I also included instructions on how to display "Determining..." on the battle.php browse page, that way people won't decline a challenge if they see they aren't going first. ". The add-on is located at https://vborg.vbsupport.ru/showthrea...614#post410614

Lock RPG Options at a Specified Level Addon by Moreliator
This addon allows you to lock all users' RPG options in their USER CP when they reach a certain level. This add-on is located at https://vborg.vbsupport.ru/showthrea...111#post411111

Personal Shop Items Have Battle Bonuses by Triade
The original personal shop, allows to have an item the don't do nothing in battle. With this add-on, you can build items with bonus in battle (the bonus is in the attack now). This add-on is located at https://vborg.vbsupport.ru/showthrea...328#post426328

Challengable Option by Darkwaltz4
Allows users to set themselves against recieving battle challenges. This add-on can be found at https://vborg.vbsupport.ru/showthrea...143#post411143


Contact Info:
Bitsys
Email: bitsys AT mail DOT com
PM me for a faster response. I prefer PMs.

~~~~~~~~~~~~
Update 09/04/03 @ 1:46pm
v0.68c

Battle debug messages were accidentally left on.
Minor shield bug was fixed in battlefight.php (Thanks Telchar).

Re-upload battleupdate.php and battlefight.php.

The new .zip file is located at the bottom of this post.


Finally, here is the .zip file (v0.68c):

[slashboy]

- when i try to edit an item from the itemshop admin like the price or something... i get this error.


Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE items_user SET item4='', points4='0', description4='', icon4='' WHERE itid4=71
mysql error: Unknown column 'itid4' in 'where clause'

mysql error number: 1054

Date: Saturday 22nd of March 2003 02:14:58 PM
Script: http://xlash.org/forums/forums/admin/itemadmin.php
Referer: http://xlash.org/forums/admin/itemadmin.php?action=edit


- for a personal item shop... there is no option to add your own icons..

- when you add categories to the itemshop. it don't show on the main itemshop page.

[chrisz]

When this hack is bug free I have made about 50 battle scenes.
They are top of the range and I can pics if requested.
I have also tweaked the templates an aweful lot.
If anyone is interested just post, and if you like what u see bitsys then I will glady give you everything so you can add it to the hack.
I am not good at all the tech stuff but I can at least help with what I have made.

[kaotic]

Hey man, that's great. I was just thinking that it could use more battle scenes. I'll be looking forward to the official release of this hack.

[Kernel]

Ya post your custom stuff.

[Bitsys]

Yesterday at 02:05 AM slashboy said this in Post #1277
Magic has to be learnt, where do we learn it anyway..??

You just buy magic spells. You can't "learn" them, per se.

Yesterday at 04:03 AM Kernel said this in Post #1278
I installed the member profile everything works fine but one thing
when i go to donate gives me an erro mysql error

strange thing is it works in my forum but the members section.
and i even copyed the code for the forums

can you pls help me fix thi last little error

pls help and thx

What is the exact error?

Yesterday at 08:05 AM Jitway1 said this in Post #1279


This is what the db fix said... Populating items_user database
No IDs were inserted.
Done with the items_user database.
Populating battle_stats database
No IDs were inserted.
Done with the battle_stats database.
Fix done.

And here is the database user_id info I am the first one user_id1


userid bankval btime item0 points0 description0 icon0 itid0 item1 points1 description1 icon1 itid1 item2 points2 description2 icon2 itid2 item3 points3 description3 icon3 itid3 item4 points4 description4 icon4 itid4 item5 points5 description5 icon5 itid5 item6 points6 description6 icon6 itid6 item7 points7 description7 icon7 itid7 item8 points8 description8 icon8 itid8 item9 points9 description9 icon9 itid9 item12 points12 description12 icon12 itid12 item13 points13 description13 icon13 itid13 item14 points14 description14 icon14 itid14 item21 points21 description21 icon21 itid21
Edit Delete 1 2280 1048254599 No Item 0 No Description Available 0 Mythril Sword 1300 Sword made out of mythril sword 12 Bronze Armor 650 Armor made of bronze armor 30 No Item 0 No Description Available 0 0 0 0 0 0 0 0 No Description Available No Item 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0 No Item 0 No Description Available 0

What does the screen look like after you buy an item?

Today at 12:17 AM slashboy said this in Post #1281
- when i try to edit an item from the itemshop admin like the price or something... i get this error.


Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE items_user SET item4='', points4='0', description4='', icon4='' WHERE itid4=71
mysql error: Unknown column 'itid4' in 'where clause'

mysql error number: 1054

Date: Saturday 22nd of March 2003 02:14:58 PM
Script: http://xlash.org/forums/forums/admin/itemadmin.php
Referer: http://xlash.org/forums/admin/itemadmin.php?action=edit

What is the structure of your items_user table?

Today at 12:17 AM slashboy said this in Post #1281
- for a personal item shop... there is no option to add your own icons..

User's cannot upload their own pictures.

Today at 12:17 AM slashboy said this in Post #1281
- when you add categories to the itemshop. it don't show on the main itemshop page.

Did you go to Edit Item Types and assign the items a particular class type?

If a category doesn't have any items in it, then it won't show up.

[chrisz]

I will post about 5 of the battle scenes I made to see what people think.
I also have about 150 different item icons.
-Post back soon

[slashboy]

Yesterday at 10:28 PM Bitsys said this in Post #1285

You just buy magic spells. You can't "learn" them, per se.

so u kind of just add them as items up to the itemshop?

Yesterday at 10:28 PM Bitsys said this in Post #1285

What is the structure of your items_user table?

mysql> show columns from items_user;
+--------------+------------------+------+-----+--------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+--------------------------+-------+
| userid | int(10) unsigned | | PRI | 0 | |
| bankval | int(10) unsigned | | | 0 | |
| btime | int(11) | | | 0 | |
| item0 | char(250) | | | No Item | |
| points0 | int(5) | | | 0 | |
| description0 | char(250) | | | No Description Available | |
| icon0 | char(250) | | | | |
| itid0 | int(11) | | | 0 | |
| item1 | char(250) | | | No Item | |
| points1 | int(5) | | | 0 | |
| description1 | char(250) | | | No Description Available | |
| icon1 | char(250) | | | | |
| itid1 | int(11) | | | 0 | |
| item2 | char(250) | | | No Item | |
| points2 | int(5) | | | 0 | |
| description2 | char(250) | | | No Description Available | |
| icon2 | char(250) | | | | |
| itid2 | int(11) | | | 0 | |
| item3 | char(250) | | | No Item | |
| points3 | int(5) | | | 0 | |
| description3 | char(250) | | | No Description Available | |
| icon3 | char(250) | | | | |
| itid3 | int(11) | | | 0 | |
| item9 | char(250) | | | No Item | |
| points9 | int(5) | | | 0 | |
| description9 | char(250) | | | No Description Available | |
| icon9 | char(250) | | | | |
| itid9 | int(5) | | | 0 | |
+--------------+------------------+------+-----+--------------------------+-------+
28 rows in set (0.00 sec)

Yesterday at 10:28 PM Bitsys said this in Post #1285

Did you go to Edit Item Types and assign the items a particular class type?

If a category doesn't have any items in it, then it won't show up.

ah thx... it worked... now in your current status right at the top of the screen... it do not show the item u just bought from the new category

and again... thanks for replying all the questions =)

[Bitsys]

Today at 08:30 PM slashboy said this in Post #1287


so u kind of just add them as items up to the itemshop?

Yes.

Today at 08:30 PM slashboy said this in Post #1287
mysql> show columns from items_user;
+--------------+------------------+------+-----+--------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+--------------------------+-------+
| userid | int(10) unsigned | | PRI | 0 | |
| bankval | int(10) unsigned | | | 0 | |
| btime | int(11) | | | 0 | |
| item0 | char(250) | | | No Item | |
| points0 | int(5) | | | 0 | |
| description0 | char(250) | | | No Description Available | |
| icon0 | char(250) | | | | |
| itid0 | int(11) | | | 0 | |
| item1 | char(250) | | | No Item | |
| points1 | int(5) | | | 0 | |
| description1 | char(250) | | | No Description Available | |
| icon1 | char(250) | | | | |
| itid1 | int(11) | | | 0 | |
| item2 | char(250) | | | No Item | |
| points2 | int(5) | | | 0 | |
| description2 | char(250) | | | No Description Available | |
| icon2 | char(250) | | | | |
| itid2 | int(11) | | | 0 | |
| item3 | char(250) | | | No Item | |
| points3 | int(5) | | | 0 | |
| description3 | char(250) | | | No Description Available | |
| icon3 | char(250) | | | | |
| itid3 | int(11) | | | 0 | |
| item9 | char(250) | | | No Item | |
| points9 | int(5) | | | 0 | |
| description9 | char(250) | | | No Description Available | |
| icon9 | char(250) | | | | |
| itid9 | int(5) | | | 0 | |
+--------------+------------------+------+-----+--------------------------+-------+
28 rows in set (0.00 sec)





ah thx... it worked... now in your current status right at the top of the screen... it do not show the item u just bought from the new category

and again... thanks for replying all the questions =)

Which userid is that information from? Is it the same userid that you took the pic with?

[slashboy]

Today at 03:19 AM Bitsys said this in Post #1288

Which userid is that information from? Is it the same userid that you took the pic with?

yes

[Bitsys]

slashboy, What are the values of all the IDs from the items_cats table? Also, do you have any presonal itemshops?

I have been able to reproduce the error artificially, so I think I know how to fix it after the error occurs. However, I still have not located the bug that causes the error.