vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   RPG Integration Hack v3 (https://vborg.vbsupport.ru/showthread.php?t=68440)

Revan 08-16-2004 10:00 PM

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,
https://vborg.vbsupport.ru/
Click it!

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

https://vborg.vbsupport.ru/

Your donations are most appreciated :)

TTG 01-08-2005 01:11 PM

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.
Code:

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 01-08-2005 06:04 PM

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

SHARKY 01-08-2005 10:51 PM

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 01-10-2005 03:45 PM

Any news on an update for the above bug ?

Revan 01-11-2005 09:52 AM

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 01-11-2005 07:46 PM

Quote:

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 01-18-2005 05:55 PM

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 01-18-2005 05:56 PM

Quote:

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 01-23-2005 04:45 AM

Quote:

Originally Posted by bozzy
what support forum? this is the only thread about this hack.

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

Dark s.s. Trunk 02-16-2005 03:30 AM

Good Mod I still love it

Revan 03-04-2005 07:47 PM

v3 Beta 1 is released :)

DeMiNe0 03-04-2005 07:48 PM

Quote:

Originally Posted by 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.

You ARE doing somthing wrong. They all work for me.
Post about this in the support forum linked in the first post and i will help you there.

|Jordan| 03-04-2005 08:15 PM

Sweeeet.

I thought this mod was dead.

TTG 03-05-2005 06:54 PM

Too many errors in too many places .. instructions need updating to advise which old code needs deleting in ALL files, not just the profile.php .. If deleting all code in profile, how does member update info ?

Revan 03-05-2005 07:53 PM

First of all, errors are to be expected in a Beta version. I stated this thoroughly in the first post, I also stated why I released this here and not in Beta forums.
Second, I feel the instructions are (finally) completely up to date, because the Upgrade instructions states to redo all edits mentioned in the Install readme. This will update all coding to get it working. Provided the user is smart enough to understand that the previous coding is to be replaced...
And we update stats in the headquarters.php, as per the new USERCP_SHELL edit to link to this page.

Cyricx 03-05-2005 10:33 PM

As Revan mentions this code is in beta still. There's alot being moved and switched around :)

And the general rule of thumb for doing a modification this size is to wait a day or two after it comes out before you install it if you want to avoid alot of minor bugs.

Myself, I like to help out with the lil bugs and get those buggers squashed ;), so I uploaded asap and sorted through them :)

Revan - Awesome work man, my users are absolutely loving it and sheer number of settings from classes to backgrounds to items to midi files allows us to make this hack work just how we want :)

Totally appreciate your work!

|Jordan| 03-11-2005 09:58 PM

What's the diff between this and the other rpg hack?

Revan 03-15-2005 06:34 AM

The two are developed by different people, for one :p
But the main difference is that this hack will ALWAYS be free, no matter how many features I add into it that would qualify the hack as a paid mod.
As for the feature aspect, Inferno has the advantage due to its development starting sooner than this mod, but in the future, this hack will at least rival Inferno in features :)

Lizard King 03-15-2005 06:41 AM

Revan when do you think full version will be ready cause i'm still holding to upgrade as this is a beta version.

Revan 03-16-2005 05:24 AM

The full version will be ready as soon as I complete the Monster Arena, release a beta with this to weed out its bugs, then after approx 3-5 days without any non-bogus bug reports :p

mindbuster 03-17-2005 10:07 AM

Pretty cool stuff, been lurking this hack for some time, looking forward to it. :squareeyed:

*Waits anxiously for v.3.1.0 final*

MindBusterhttp://www.entropiaforum.com/forums/...ilies/poke.gifRevan

|Jordan| 03-24-2005 03:35 AM

Revan, the monster arena sounds awesome

YOU ARE A GOD!

xbaby 04-02-2005 02:36 PM

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in d:\www\includes\init.php on line 699
Parsing functions.php Time before: 1112459526.34 Time after: 1112459526.42 Time taken: 0.0852010250092

This my error

xbaby 04-03-2005 02:16 AM

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in d:\www\includes\init.php on line 699
Parsing functions.php Time before: 1112459526.34 Time after: 1112459526.42 Time taken: 0.0852010250092

This my error
Please help me !

Q-v-n-s-Q 04-03-2005 05:24 AM

this is bull++++

|Jordan| 04-03-2005 05:10 PM

Quote:

Originally Posted by Q-v-n-s-Q
this is bull++++

you are bull++++

xbaby 04-03-2005 11:52 PM

I install success , but , when I am trying to open some thread , it say :
Database error in vBulletin 3.0.3:

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 post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
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 deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
LEFT JOIN rpg_items_user AS rpg_items_user ON(rpg_items_user.userid=user.userid)
LEFT JOIN rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid=user.userid)
LEFT JOIN rpg_class AS rpg_class ON(rpg_class.id=user.rpgclass)
LEFT JOIN rpg_element AS rpg_element ON(rpg_element.elementid=user.element)
LEFT JOIN rpg_clan AS rpg_clan ON(rpg_clan.clanid=user.clan)
LEFT JOIN rpg_race AS rpg_race ON(rpg_race.raceid=user.rpgrace)
AND rpg_race.alignmentid=user.alignment

WHERE post.postid IN (0,1628,2516,2521,2522)
ORDER BY dateline

mysql error: Unknown column 'userfield.field' in 'field list'

mysql error number: 1054

Help me !!!

xbaby 04-03-2005 11:56 PM

oh, I 'm new mem , so don't say like that , please !!!
thanks !

Marco van Herwaarden 04-04-2005 08:12 AM

Quote:

Originally Posted by Q-v-n-s-Q
this is bull++++

Please keep this discussion civilized.

Crow 04-04-2005 09:28 PM

~Edit~

Found answer.

|Jordan| 04-06-2005 01:51 PM

Quote:

Originally Posted by MarcoH64
Please keep this discussion civilized.

I concur. The nerve of some people ...

xbaby 04-09-2005 02:33 AM

I don't know what is it : When I trying to creat battle !
"Your opponent is ineligible for battle at this time "
Please tell me more about it
thanks !!!

Tri@de 04-12-2005 03:20 PM

probably, he doesn't upgraded his character o he haven't created it yet

AnimePlus 04-13-2005 10:06 PM

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE `rpg_lottery` DROP `editing`
mysql error: Can't DROP 'editing'. Check that column/key exists

mysql error number: 1091

Date: Wednesday 13th of April 2005 07:05:31 PM

help please

torahtrance 04-13-2005 11:51 PM

i dont understand what this error is!
Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE `vb3_rpg_lottery` DROP `editing`
mysql error: Can't DROP 'editing'. Check that column/key exists

mysql error number: 1091

Date: Wednesday 13th of April 2005 08:51:06 PM

asianboi 04-30-2005 02:55 PM

nice love it!

MissKalunji 05-06-2005 05:02 AM

THATS A WICKED HACK! NO PROBLEM ENCOUNTER THE INSTALL FINE IS MAGNIFICIANT A+++++++++++++++++ GREAT HACK !!


here for demo : www.dancehallareaz.com/forum/battle.php :nervous:

|Jordan| 05-07-2005 12:14 AM

:( i over hacked (80+ hacks) my forum and performance took a hit so i uninstalled the RPG. Maybe some time in the future when all the bugs and the new features are available; i'll reinstall.

MissKalunji 05-07-2005 12:28 AM

Quote:

Originally Posted by MyIS_Jordan
:( i over hacked (80+ hacks) my forum and performance took a hit so i uninstalled the RPG. Maybe some time in the future when all the bugs and the new features are available; i'll reinstall.


wowwwwwwwww 80!


All times are GMT. The time now is 03:53 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01440 seconds
  • Memory Usage 1,842KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete