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

Tyegurl · #**262** 04-10-2006, 03:18 PM

I just want to say that my members love the fact that when they use a bow and fight a battle you get this roughly...

So and So runs towards Frick and Frack swinging the mighty weapon!

they think that is hilarious!!

My upgrade went smoothly except the inventory didn't upload even on the fourth time. exited my ftp and retried...uploaded fine. thanks so much!

Revan · #**263** 04-10-2006, 03:56 PM

Quote:

Originally Posted by Replicators

I got this when trying to install the MYSQL tables....

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `sf_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
Date         : Monday, April 10th 2006 @ 03:11:23 AM
Script       : http://www.******.com/installer/index.php
Referrer     : http://www.******.com/installer/index.php
IP Address   : **.**.***.***
Username     : Replicators
Classname    : vb_database

Im uploading a fixed file, youll have to continue from that step but you shouldn't have any errors.
Check abck in 5 mins and it should be up.

Twin-x · #**264** 04-10-2006, 04:13 PM

I managed to do it by hand i updated the line from

Code:

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

to

Code:

`invite` MEDIUMTEXT NOT NULL,

Is this ok?

p.s. i really really love your work done here. This is an most excellent feature to our forums.
A million time thanks!

Revan · #**265** 04-10-2006, 04:15 PM

yeah Twin, but youll probs get some table already exists errors if you don't use the new mysql-schema file.
Thanks for the comment, always nice to hear from a satisfied customer

Twin-x · #**266** 04-10-2006, 04:23 PM

Quote:

Originally Posted by Revan

yeah Twin, but youll probs get some table already exists errors if you don't use the new mysql-schema file.
Thanks for the comment, always nice to hear from a satisfied customer

Ahaa that was not a problem since i dropped the tables in mysql admin.
And you deserve the words!! No need to thank! :banana:

kevmaz · #**267** 04-10-2006, 09:51 PM

I tried to upgrade today and I get the folowing error.

There is an error with your Version Number, and the upgrade cannot continue.
To remedy this error, manually set your Version Number setting in the hidden RPG Integration Hack - Untoucheables vBulletin Options Setting Group to match the version number you believe you should have.

To see this vBulletin Options Setting Group, you must enable Debug Mode. Visit vBulletin.org for assistance on how to enable Debug Mode.

To figure out what Version Number you must insert, open /installer/hacks/rpg_integr_hack/class.php and find the four digit versionnumber that matches the version you believe you have installed.

I have uninstalled it from my database via phpmyadmin and I still get the error
any help please
Vbulletin says never use debug mode on a live forum

cayote · #**268** 04-11-2006, 03:53 AM

Quote:

Originally Posted by Revan

If you are sure that your items have proper Level Requirements, then it might be that the guy you mentioned is a Staff member. All staff members (Mods, SMods, Admins) are default set to be Game Masters, which means they can buy/sell while in battle, use Healing Center in battle, bypass certain requirements.

Yep he was a moderator. I had him as Game Master = No but guess that's not it. Is there a way to prevent Moderators etc. from being able to buy out of range items without just removing them as moderators?

Thx.

Revan · #**269** 04-11-2006, 07:33 AM

Quote:

Originally Posted by kevmaz

I tried to upgrade today and I get the folowing error.

There is an error with your Version Number, and the upgrade cannot continue.
To remedy this error, manually set your Version Number setting in the hidden RPG Integration Hack - Untoucheables vBulletin Options Setting Group to match the version number you believe you should have.

To see this vBulletin Options Setting Group, you must enable Debug Mode. Visit vBulletin.org for assistance on how to enable Debug Mode.

To figure out what Version Number you must insert, open /installer/hacks/rpg_integr_hack/class.php and find the four digit versionnumber that matches the version you believe you have installed.

I have uninstalled it from my database via phpmyadmin and I still get the error
any help please
Vbulletin says never use debug mode on a live forum

I do not support methods of removal other than the included uninstall.php, but that wouldn't have worked properly anyways.
It's your fault for not shutting down your forum and enabling Debug Mode for the duration of you fixing of this error. Therefore you're on your own.

Quote:

Originally Posted by cayote

Yep he was a moderator. I had him as Game Master = No but guess that's not it. Is there a way to prevent Moderators etc. from being able to buy out of range items without just removing them as moderators?

Thx.

He can't buy them if he's not Game Master - the hack goes by that setting, not usergroup.

vbreal · #**270** 04-11-2006, 04:57 PM

PHP Code:


			
Database error in vBulletin 3.5.4: Invalid SQL:     SELECT `userid`, `rpg`, `items`, `inventory`, `uttpoints` AS `points`
    FROM `tduser`
    WHERE `userid` = '10'; MySQL Error  : Unknown column 'uttpoints' in 'field list'
Error Number : 1054
Date         : Tuesday, April 11th 2006 @ 12:51:21 PM
Script       : http://www.trudaily.com/showthread.php?t=240
Referrer     : http://www.trudaily.com/forumdisplay.php?f=23
IP Address   : 69.249.227.104
Username     : MrDaily
Classname    : vb_database

hey i keep getting this error when i click a thread with in a forum

any suggestions

vbreal · #**271** 04-11-2006, 05:05 PM

arg never mind i got it i had to change the points system.

pages seem to load slower now though

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05036 seconds Memory Usage 2,330KB 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 (3)bbcode_code (1)bbcode_php (5)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 (3)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!