The Arcive of Official vBulletin Modifications Site.

RPG Integration Hack · **Released**: 02-23-2006

[high]

RPG Integration Hack v3.5.1 Patch Level 2

[/high]
RPG Integration Hack (RPG hack for short) v3.5.1 is the first step into the next generation of the classic hack compiled by Bitsys. 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.

[high]Important Notices:[/high]

You need an external Cash mod installed for this mod to function properly.
- uCash/uShop or vBPlaza, either will do
- The Cash mod need to use the `user` table
- You need to configure a setting in the RPG Integration Hack - Cash Options after install/upgrade

[high]Known Issues:[/high]

Regular postbit doesn't contain RPG info
RPG Manual is still outdated

These are all issues that will be addressed in upcoming versions.

[high]Upgrading Users:[/high]
What's new in v3.5?

OOP coding for query efficiency
Revamped templates
New Battle formulas (Thanks to Decado)
Works with AJAX Quick Reply/Quick Edit
Reoccurring Lotteries
Improved Healing Center
Inventory feature for the ability to carry multiple items from same item category
RPG Info no longer changeable on the fly
And last, but not least: [high]NO FILE EDITS![/high]

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

vbreal · #**342** 04-18-2006, 02:06 PM

PHP Code:


			
Database error in vBulletin 3.5.4: Invalid SQL:
UPDATE tdrpg_user SET
 ap = 0,
 maxhp = 165,
 maxmp = 33,
 maxpp = 33,
 hp = 0,
 mp = 33,
 pp = 33,
 xp = 1930,
 level = 11
WHERE userid = 3; MySQL Error  : Can't open file: 'tdrpg_user.InnoDB'. (errno: 1)
Error Number : 1016
Date         : Tuesday, April 18th 2006 @ 09:56:21 AM
Script       : http://www.trudaily.com/newreply.php
Referrer     : http://www.trudaily.com/showthread.php?t=1636&page=2
IP Address   : 192.91.173.36
Username     : MrDaily
Classname    : vb_database

i have been getting this error all day

also how do i turn the hack off till this problem is fixed

thanks in advance

MakZF · #**343** 04-18-2006, 04:25 PM

Quote:

Originally Posted by Revan

Edit the Modifiers in your vBulletin Options under RPG Integration Hack - General Options.

My final exams are coming up, as well as working on the new stat system, so I won't have much time to come here and give updates.
Just thought Id let you knwo

I already did that, modifiers are set but stats still are not increasing per level gain.

SupremeWeapon · #**344** 04-18-2006, 04:29 PM

few things. First i want to add links to the RPG nav that you have included. So it has the BANK and store mods for the cash mod I have installed (ubbux)

I tried adding the stuff but no go it doesnt add to the nav.

also.

Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `rpg_clans`
(
`clanid` int(10) UNSIGNED NOT NULL auto_increment,
`title` varchar(50) NOT NULL DEFAULT '',
`leader` int(10) UNSIGNED NOT NULL DEFAULT '0',
`clanpoints` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`logo` varchar(100) NOT NULL DEFAULT '',
`signature` VARCHAR( 255 ) NOT NULL DEFAULT '',
`ally` MEDIUMTEXT NOT NULL,
`enemy` MEDIUMTEXT NOT NULL,
`members` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1',
`maxmem` tinyint(3) UNSIGNED NOT NULL DEFAULT '5',
`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',
`col1` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col2` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col3` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col4` int(10) UNSIGNED NOT NULL DEFAULT '0',
`cm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`ci_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`rm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`midiurl` varchar(100) NOT NULL DEFAULT '',
`rank` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`clanid`)
) TYPE=InnoDB;

MySQL Error : BLOB/TEXT column 'invite' can't have a default value
Error Number : 1101

going to try a fix posted for another table. Figured you should know about this error so you can fix it. will edit if the fix doesnt work

edit:

Fix workd for it.

changing

`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',

to

`invite` MEDIUMTEXT NOT NULL,

xfaethorx · #**345** 04-18-2006, 06:42 PM

just a little issue i found...

i had a user who was stuck in a monster battle but everytime you clicked the link it said invalid battleid...

there was a reference to it in ther rpg_user table so i deleted it from that user however they were still stuck in the battle. The admin for the user said there was no battle id that they were in and although i clicked cancel current monster battle nothing happened there.

in the end i had to delete the rpg column to null in the user table as it seems to be a caching point?

anyway its kind of a bug because i don't know how it ended up like that but i was wondering if you could add a flush battle function that would clean out all battle related data and also clear this rpg field in users as thats how i fixed this problem.

Regards

Travis641 · #**346** 04-18-2006, 11:26 PM

I can also confirm the invalid battleid happening, as the HP/MP/PP not going up when the user levels. Updating the Stats in Admin CP for the user fixes the HP/MP/PP to what they should be though.

nadanada · #**347** 04-19-2006, 04:39 AM

fixed guild invite problem!

the established guilds with passwords you couldnt join, new ones without you couldn't, so i removed passwords via sql and viola!

Revan · #**348** 04-19-2006, 10:08 AM

Rly? I believe I dropped the `pass` bit... Didn't I? *goes to check*

General Update:
I got some spare time now which I will devote to this hack while waiting for my new 7900GTX 512 MB to play Oblivion with ^_^
Ahem.
So yeah, the next version of the RPG will be further away than the frequent updates you hopefully weren't getting too used to. It will, however, feature some cool changes:

Headquarters will get a major revamp, it will have different sections, which are detailed below.
Inventory function is merged into a new section of the Headquarters called Manage Items. It will be accessible both from the Headquarters and from the same button in the Itemshop.
"Your Stats" in the Battle Arena is now incorporated into the new Statistics page in the Headquarters.
Abovementioned Statistics page will also feature other useless information if I fancy adding it
First base for a Manage Skills page, in preparation for the new Skills system. This feature will probably not be completed, unless I for some reason make the Skills system before releasing the update.
Edit Settings is now a category for managing the RPG options.
Reset RPG is now an own link in the Headquarters.

Plus bugs you people will be kind enough to post at the bug tracker fixed

Oh and I forgot to ask: If there's anything you would like to see changed, feel free to post it in the Suggestions forum. Thx

Rated · #**349** 04-19-2006, 10:37 AM

Quote:

Originally Posted by Rated

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `rpg_clans`
(
`clanid` int(10) UNSIGNED NOT NULL auto_increment,
`title` varchar(50) NOT NULL DEFAULT '',
`leader` int(10) UNSIGNED NOT NULL DEFAULT '0',
`clanpoints` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`logo` varchar(100) NOT NULL DEFAULT '',
`signature` VARCHAR( 255 ) NOT NULL DEFAULT '',
`ally` MEDIUMTEXT NOT NULL,
`enemy` MEDIUMTEXT NOT NULL,
`members` INT( 10 ) UNSIGNED NOT NULL DEFAULT '1',
`maxmem` tinyint(3) UNSIGNED NOT NULL DEFAULT '5',
`invite` MEDIUMTEXT NOT NULL DEFAULT 'a:0:{}',
`col1` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col2` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col3` int(10) UNSIGNED NOT NULL DEFAULT '0',
`col4` int(10) UNSIGNED NOT NULL DEFAULT '0',
`cm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`ci_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`rm_col_access` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`midiurl` varchar(100) NOT NULL DEFAULT '',
`rank` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`clanid`)
) TYPE=InnoDB;

MySQL Error : BLOB column 'invite' can't have a default value
Error Number : 1101

Can anyone help me out please?

Revan · #**350** 04-19-2006, 02:09 PM

Just two updates files today
./installer/hacks/rpg_integr_hack/mysql-schema.php
./admincp/rpg_monsters.php

The first file is only needed if you are having troubles installing the hack, and the second file fixes an SQL error.
No new version number increase, and no other files were changed even though there IS still a confirmed bug in the Battle Arena.

nadanada · #**351** 04-19-2006, 03:35 PM

this is probably a stupid question, but do PP/limit break/anger do anything yet?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05718 seconds Memory Usage 2,331KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!