RPG Integration Hack

[Revan]

Um... "default weapons" means the items that come with the hack. Edit the items yourself to create new ones, look in the images/itemshop for images you can use.

[Tyegurl]

i thought you meant default came with class....okay i found the bows in the folder :o didn't think of looking there. ty for the help!

[Revan]

RPG Integration Hack v3.5.1
I've just upgraded hack version to 3.5.1. This is more a feature release than previous updates, and contain two extensive updates to annoyances.
ClanCP feature: Invitation System.
What this feature does is allow a Clan Leader/Co-Leader to send Invites to users instead of using a password. Now, when you kick a member from your Clan, he will not be able to re-join until he gets a new Invite.
Inventory.
You may now manage your Inventory from the Inventory button. The Inventory behaves just like the Itemshop when it comes to display, also you will be able to sell your Equipped items from the Inventory as well as the ItemshopIt does fix a bug where users who reset their RPG info gets put in Clan Id 1 though.

[Tyegurl]

ty!!

[mikeylikesitz]

any idea on when postbit will be done?

[cayote]

Well after having a bit of fun with this I now see that no matter what level items/weapons/armor are set at, any level can buy them. This is why a level 1 dude kept beating a lvl 6 guy. He had a level 8 weapon. Any help?

Thanks

[cayote]

It must not be running the cron job properly. Try setting the cron job to run at a time you or many members are online, then wait a day and talk back then we'll see.


If you meant just changing the date in the lottery manager, that didn't do anything. The day went by with no lottery and I had to hit the pick button again.

Sorry for being a newb about this...still learning.

[Revan]

any idea on when postbit will be done?Im focusing on getting the new stats system done, Ill try bringing it on for the next version.
Well after having a bit of fun with this I now see that no matter what level items/weapons/armor are set at, any level can buy them. This is why a level 1 dude kept beating a lvl 6 guy. He had a level 8 weapon. Any help?

ThanksIf 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.
If you meant just changing the date in the lottery manager, that didn't do anything. The day went by with no lottery and I had to hit the pick button again.

Sorry for being a newb about this...still learning.No, I ment go to your Scheduled Task Manager and change the time the cron job runs at.

[Replicators]

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

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

[Twin-x]

I have the Exact same error as above!!!!

[Tyegurl]

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]

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

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_databaseIm 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]

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

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

to

`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]

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]

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]

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]

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]

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 forumI 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.

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]

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]

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

pages seem to load slower now though

[nadanada]

Clan Invite -

It will send a message

Hi, --> PERSON'S NAME <--


Message
Whatever the message is


Clan Info
Clan Name: This is a clan
Clan Password: The Password (which is the senders name, my test username is two words)

To Accept the Clan Invite click here.

The click here is kind of backwards, its like: http:///clancp.php?http://www.boards.com/do=joinclan&clanid=&pass=user name

even when fixed like (manually fixed and pasted in browser):
http://www.boards.com/clancp.php?do=joinclan&clanid=&pass=user name

I get:
The Clan Name or Clan Password is incorrect. Go Back.

Same thing when I try to Join A Clan from Clan CP

Thanks

Also where is the template for the message that is sent? I want to add a few things to it.

[Tri@de]

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


have you installed the ushop ucash hack?

[Revan]

Clan Invite -

It will send a message



The click here is kind of backwards, its like:

even when fixed like (manually fixed and pasted in browser):


I get:


Same thing when I try to Join A Clan from Clan CP

Thanks

Also where is the template for the message that is sent? I want to add a few things to it.The entire Join Clan needs debugging, Ill release Update 1 with this fixed in a short while.
Its not a template, its a vbphrase, rpg_clan_x_invite_msg

[Otikeu]

I'm recieving timeouts or even a download dialog box asking to download the requested RPG .php file. This is only with the RPG, not with any other portion of the forum. Help?

[Revan]

Try running the Maintenance functions. All of them. Those errors happened to me once on showthread, when it was trying to loop something on many users in once.

[vbreal]

great hack BTW

i have a bit of an issue.

After I made new races and added the genders to them. I went to test by creating a character with the new race and the class section doesn't show up. How would I go about assigning the classes to the new races?

thanks in advance for the help

[Revan]

Classes cannot be assigned to Races per se, only to genders.

[nadanada]

only issue I have with the invitation system now is the error of not having a valid password, otherwise the message including the 'click here' link works great.

also would it be possible to add an if statement for names that are still N/A to reject the invitation, so when i go to check invitations sent I know which is which, thanks sir.

[xfaethorx]

im getting the following error

Unknown column 'ebux' in 'field list' have i got the right field point type name im using vbplaza

[xfaethorx]

fixed it just needed to update the user table

[xfaethorx]

one more thing nothings appearing in post bit legacy can anyone shed any light as to why?

[Tyegurl]

im getting the following error

Unknown column 'ebux' in 'field list' have i got the right field point type name im using vbplaza


is it ebux or vbbux?

[xfaethorx]

haha its vbbux...i screwed up with that one :D. Never used a system like it before so it confused me in my old age :D. Yeah if your using vbbux then funily enough its vbbux silly me.

[Tyegurl]

haha its vbbux...i screwed up with that one :D. Never used a system like it before so it confused me in my old age :D. Yeah if your using vbbux then funily enough its vbbux silly me.


;) thought so

[vbreal]

i recieved this error when uninstalled it and tried to reinstalled it

any idea

Database error in vBulletin 3.5.4:

Invalid SQL:

ALTER TABLE `tdadministrator`
ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date : Wednesday, April 12th 2006 @ 03:52:16 PM
Script : http://www.trudaily.com/installer/index.php
Referrer : http://www.trudaily.com/installer/index.php
IP Address : 69.249.227.104
Username : MrDaily
Classname : vb_database

[nadanada]

looks like there are 2 fields of the same name in sql, best thing to do is log into your database if you can and see.

check vb_datastore or whatever your prefix is _datastore

also its should be a pretty big field, so you may want to copy and paste everything in notepad to find the duplicate

[vbreal]

edit

[Tyegurl]

one more thing nothings appearing in post bit legacy can anyone shed any light as to why?

was there template edits??? if theere was i bet you edited postbit instead....oh wait i see above that its a known issue about posbit not containing RPG info...i assume the same would go for postbit legacy...but i also assume i know nothing....

[Queball_Beast]

Can someone tell me why I dont have any control over this game? the install went fine.. but I have nothing appearing in my admin control panel. only the options that appear in the VBulletin options menu. so I could use some help here please..:)

[xfaethorx]

was there template edits??? if theere was i bet you edited postbit instead....oh wait i see above that its a known issue about posbit not containing RPG info...i assume the same would go for postbit legacy...but i also assume i know nothing....

yeah i had an attack of the "blonde days" it says the postbit doesn't work yet so I'm assuming thats for BOTH postbits and postbits_legacy

[soulface]

was there template edits??? if theere was i bet you edited postbit instead....oh wait i see above that its a known issue about posbit not containing RPG info...i assume the same would go for postbit legacy...but i also assume i know nothing....

ummm all i can see is, thrs nathing in rpg_postbit templates, its just blank. but rpg_postbit_legacy templates is OK. so when i choose postbit_legacy system, RPG stats shows & but nathing in postbit, since thrs is nahting in rpg_postbit...

[Revan]

Can someone tell me why I dont have any control over this game? the install went fine.. but I have nothing appearing in my admin control panel. only the options that appear in the VBulletin options menu. so I could use some help here please..:)Make yourself super admin and give yourself Can Administer RPG.
was there template edits??? if theere was i bet you edited postbit instead....oh wait i see above that its a known issue about posbit not containing RPG info...i assume the same would go for postbit legacy...but i also assume i know nothing....No. Just edit the postbit_legacy template like the readme says and it will work.

[xfaethorx]

getting an odd error here...

xfaethorx walked over to the cleric and cashed in on the spoils of war: 14 Gold. Batfutt is not in a Clan, so Batfutt's failure went by unpunished. As a result of xfaethorx's bravery, Clan WYHC Ninja Crew gained 1 Clan Point. xfaethorx gained 5 EXP and [ARG:3 UNDEFINED] [ARG:4 UNDEFINED] as a reward for exploits in battle.

Don't know whats not defined...any ideas?

[xfaethorx]

another oddity is that a couple of members have complained about their items disapearing. They have bought the broadsword (330) and when entering monster battle their weapon has gone subiquently they either retreat or get pounded. Anyone else notice this or could it just be a gremlin?

[Revan]

That item glitch seems to be completely random. On one site, it was fixed with a simple re-upload. On another, it's reoccurring. I need to examine more closely.

EDIT: I just tried some battles on localhost... Ill have to move on to the forum this is actually happening on.

[Revan]

Nvm, I fixed it. Releasing an update shortly.

[Ziki]

lol 99 installs only till now....that stupid RPG inferno is taking away all your installers :)

[Revan]

yer, but I have some stuff planned that will surpass even RPG Inferno 3.0 so I hope that will net me more installs.
I just need some help with some new formulas, the maths isn't rly my strong side XD

[Ziki]

Need a bit help?With what.I can help abit

[Revan]

Formulas, writing up a formula that will offer a nice stat increase curve.

[Ziki]

I think I don't quite get what you are sayin'
Like an advertisement?

[Solitary Seraph]

I have a question from my members. Apparently if you're a higher level than the others, you cannot challenge the others to a fight. I've tried to figure out what is wrong with it, but, all i get is "The Opponent is not eligible for battle at this time."

Also, when my users buy more than one type of item, the item doesnt show up in the inventory or in the list of items they have, but they cannot buy another. This gets really frustrating, especially when they try to buy a potion, and it doesnt show up.

[Queball_Beast]

Make yourself super admin and give yourself Can Administer RPG.
No. Just edit the postbit_legacy template like the readme says and it will work.
I got it to work ThankyoU
Now I have another problem. my members say that they are not gaining any more HP when they go up in levels. Ive read the RPG admin manul where i have to modify the userfields in the user profile fields.
The instructions were Go to your admin panel.
Go to modify user profile fields.
Find the RPG Name profile field.
Right click over the edit link and go to "Copy Shortcut".
Copy it in your browser.
Near the end there will be a number (something like profilefieldid=#). Remember that number.
Go to edit the Battle Options.
But I dont have that addition to the user profile field.
All I have there are User profile field manager and add new profile field But the RPG Name is not there unless you are speaking of a different location. But i cannot find this Go to your admin panel.
Go to modify user profile fields.
Find the RPG Name profile field. in the user profile there are only 2 options there and in your directions it states that another one should have been added with the installation of the Hack.

Any Ideas please? Thanks for your help in advance :banana:

[Revan]

I got it to work ThankyoU
Now I have another problem. my members say that they are not gaining any more HP when they go up in levels. Ive read the RPG admin manul where i have to modify the userfields in the user profile fields.
The instructions were .
But I dont have that addition to the user profile field.
All I have there are But the RPG Name is not there unless you are speaking of a different location. But i cannot find this in the user profile there are only 2 options there and in your directions it states that another one should have been added with the installation of the Hack.

Any Ideas please? Thanks for your help in advance :banana:Read the Known Issues for explanation why the Manual is wonky.
Due to the stats system being remade, for now youll have to modify the Modifiers in your RPG options in order to bring HP back to a normal level.

[Travis641]

Searched around but couldn't find anything. When people on my forums die, they lose EXP. One guy went from level 8 to level 3. I myself went from level 15 to level 1. Not sure what is causing this, but would like to get rid of it.

Also I saw no where to set the character's element. Is it now random or based on some other aspect you pick?

Thanks ^^

[Queball_Beast]

When I visited your site at http://demo.neomateria.net/ I notice during each post the RPG stats were being displayed. Is that an addon for the hack or is that the way it suposed to be displayed? Because it does not display like that on my Board and I sure would like for it to be displayed like that. :banana: :bunny:

[Revan]

Searched around but couldn't find anything. When people on my forums die, they lose EXP. One guy went from level 8 to level 3. I myself went from level 15 to level 1. Not sure what is causing this, but would like to get rid of it.

Also I saw no where to set the character's element. Is it now random or based on some other aspect you pick?

Thanks ^^This doesn't happen on any of my forums, are you sure someone didn't just mess about with the EXP Modifier? Can anyone else confirm?
As for the elements, it is being moved out of the user select options and into the Skills (thereunder, spells) to give them real meaning.
Thefore, for now, all users use the Unknown element.

When I visited your site at http://demo.neomateria.net/ I notice during each post the RPG stats were being displayed. Is that an addon for the hack or is that the way it suposed to be displayed? Because it does not display like that on my Board and I sure would like for it to be displayed like that. :banana: :bunny:You can set the default for Guests in the AdminCP and your own in the Headquarters.

[Queball_Beast]

Searched around but couldn't find anything. When people on my forums die, they lose EXP. One guy went from level 8 to level 3. I myself went from level 15 to level 1. Not sure what is causing this, but would like to get rid of it.

Also I saw no where to set the character's element. Is it now random or based on some other aspect you pick?

Thanks ^^
I to can verify this as it is also happening on my forum also. my members are losing HP, some are not gaining any at all when they level up, and I had one guy go from level 15 to level 4 and lost HP. I just giving you some more feedback.
But all of my members love this Hack, and i`ll make a donation for this one. "Thanks"

[Queball_Beast]

Ok I think I may be going loco :banana: I cant seem to get the stats displayed in the threads and member post, you said You can set the default for Guests in the AdminCP and your own in the Headquarters.
But I have searched high and low for this and the only setting I see for guess are located in the RPG intergration Hack General options Located on the bottom there is an option to set the default postbit . but nothing was displayed after the settings were changed, Also in my headquarters I had set it both dropdown and postbit, but nothing was displayed also. so am I missing anything? :banana:


That dancing banana is funny.lol

[Tyegurl]

mine doesn't show either and i know i did all the edits....have checked and rechecked...
But I have searched high and low for this and the only setting I see for guess are located in the RPG intergration Hack General options Located on the bottom there is an option to set the default postbit . but nothing was displayed after the settings were changed, Also in my headquarters I had set it both dropdown and postbit, but nothing was displayed also. so am I missing anything?

[Revan]

The dying members, are they fighting Monster Battles or regular ones?

[Travis641]

Monster Battles for me, haven't tried battles with other people yet.

[Queball_Beast]

Monster Battles for me, haven't tried battles with other people yet.
Same here, monster battles I have not tried the player vs player battles yet and my members said they are also doing monster battles.

Ps, Any idea on about thisBut I have searched high and low for this and the only setting I see for guess are located in the RPG intergration Hack General options Located on the bottom there is an option to set the default postbit . but nothing was displayed after the settings were changed, Also in my headquarters I had set it both dropdown and postbit, but nothing was displayed also. so am I missing anything? ?:banana:

[Revan]

I just died with a monster battle on localhost and the only exp lost is the wager on the battle.
Maybe that's your issue then, your wager was set too high? Because it IS just that, a wager, until I get an algorithm up for determining EXP loss.

As for that postbit error, the regular postbit (not _legacy) doesn't have RPG code in it yet.

[Queball_Beast]

I just died with a monster battle on localhost and the only exp lost is the wager on the battle.
Maybe that's your issue then, your wager was set too high? Because it IS just that, a wager, until I get an algorithm up for determining EXP loss.

As for that postbit error, the regular postbit (not _legacy) doesn't have RPG code in it yet.
Ok i`ll Take a look at the wagers for battle.

As for the code in the postbit (not legacy) it is there.
the code said "Find code in postbit"
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>
</div>
"add below"
$rpg_postbit

Then "find code in postbit legacy"
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>
</div>

"Add below"
$rpg_postbit_legacy
Those are all done, I even checked it over again right before I made this post. and it is all there.
But I am wondering if the code for vbplaza in postbit_legacy has something to do with the code for the rpg stats not showing up.
the vbplaza ask for this same code as RPG, vbplaza readme states find this code <div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div> and add below <!-- vbPlaza start -->
<if condition="$post['giftsdisplay']"><div class="smallfont">$post[giftsdisplay]</div></if>
<if condition="$post['ribbonsdisplay']"><div class="smallfont">$post[ribbonsdisplay]</div></if>
<!-- vbPlaza end -->The readme for vbplaza states I could use either postbit or postbit_legacy. so at first I used postbit but sice my rpg stats were`n showing I change to postbit_Legacy but it is still the same.
And now this is the way the RPG code looks in posbit(not_legacy)
</div>
<if condition="$show['reputation']"><if condition="$show['reppower']">$vbphrase[reppower]: $post[reppower] </if><div>$post[reputationdisplay]</div></if>
<div>$post[icqicon] $post[aimicon] $post[msnicon] $post[yahooicon] $post[skypeicon]</div>
</div>
$rpg_postbit Which is just as the RPG readme first states.
I hope this helps you Revan. And thankyou verymuch for your time and help.:banana:

[Tyegurl]

so do the stats work?

[Travis641]

Yeah, I lose the amount of exp that the monster would give if I won. This is design? Anyway to disable it, if that is possible?

Thanks.

[Revan]

Ok i`ll Take a look at the wagers for battle.

As for the code in the postbit (not legacy) it is there.
the code said "Find code in postbit"

"add below"


Then "find code in postbit legacy"


"Add below"

Those are all done, I even checked it over again right before I made this post. and it is all there.
But I am wondering if the code for vbplaza in postbit_legacy has something to do with the code for the rpg stats not showing up.
the vbplaza ask for this same code as RPG, vbplaza readme states find this code and add below The readme for vbplaza states I could use either postbit or postbit_legacy. so at first I used postbit but sice my rpg stats were`n showing I change to postbit_Legacy but it is still the same.
And now this is the way the RPG code looks in posbit(not_legacy)
Which is just as the RPG readme first states.
I hope this helps you Revan. And thankyou verymuch for your time and help.:banana:Open the rpg_postbit and rpg_postbit_legacy templates. Notice anything?
Yeah, I lose the amount of exp that the monster would give if I won. This is design? Anyway to disable it, if that is possible?

Thanks.No, that will stay in place until I can get a formula for EXP loss. This will happen some time after I get some forumlas for calculating the new stats.

[Queball_Beast]

Open the rpg_postbit and rpg_postbit_legacy templates. Notice anything?
Hmmmm it is emty, something has to be added there, but what?
I dont know what to add here. Can you help me? please hehe:banana:

[Tyegurl]

Hmmmm it is emty, something has to be added there, but what?
I dont know what to add here. Can you help me? please hehe:banana:
don't think its ready yet....or it would all ready be there....

[Kingzor]

New sql error from a forum member.

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO rpg_ibot_templates
(`userid`,
`ibotid`,
`hp`,
`maxhp`,
`mp`,
`maxmp`,
`pp`,
`maxpp`,
`ap`)
VALUES
('443',
'2',
'200',
'200',
'25',
'25',
'30',
'30',
'0');

MySQL Error : Duplicate entry '443' for key 1
Error Number : 1062
Date : Saturday, April 15th 2006 @ 08:14:30 AM
Script : http://www.hiberniagaming.net/vbull/monsterarena.php
Referrer : http://www.hiberniagaming.net/vbull/monsterarena.php?do=newbattle&ibotid=2
IP Address : x.x.x.x
Username : Fosilex
Classname : vb_database

[Revan]

The user must have had an ibot battle half-made or something, because that should not happen.
run DELETE FROM rpg_ibot_templates WHERE userid = 443 and DELETE FROM rpg_monster_battle WHERE userid = 443 and have him remake the battle.

[Tyegurl]

oh yes i did forget to tell you that i cannot creat I bots....

one more thing....how would i create a dropdown menu on the first navbar? i am getting rid of clutter in my navbar....added two dropdown menus all ready and would like to tidy up the 2nd navbar and move the links to the first navbar? not sure how i would get rid of the 2nd navbar though....

[Travis641]

If you were getting the error I was, then you need to edit: $db->query_write("
INSERT INTO `" . TABLE_PREFIX . "rpg_ibots`
(`botname`,
`levelrequired`,
`cost`,
`expdrop`,
`cashdrop`
`limitname`,
`hp`,
`maxhp`,
`mp`,
`maxmp`,
`pp`,
`maxpp`,
`ap`,
`xp`,
`genderid`)

`cashdrop` needs a comma after it in /admincp/rpg_monsters.php which allowed me to make ibots.

[nadanada]

should clan invites be working?

[Tyegurl]

If you were getting the error I was, then you need to edit: $db->query_write("
INSERT INTO `" . TABLE_PREFIX . "rpg_ibots`
(`botname`,
`levelrequired`,
`cost`,
`expdrop`,
`cashdrop`
`limitname`,
`hp`,
`maxhp`,
`mp`,
`maxmp`,
`pp`,
`maxpp`,
`ap`,
`xp`,
`genderid`)

`cashdrop` needs a comma after it in /admincp/rpg_monsters.php which allowed me to make ibots.

tyvm that worked :)

[Revan]

should clan invites be working?They don't? I tested them thoroughly... :surprised:


As for that SQL error, thanks for spotting it.

I hope to release 3.5.2 soon, with some new features as well as a new Stats system that will be the first step towards returning the stats to their "former glory" so to speak.
I don't know exactly when this will be ready, but as soon as possible.

[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

:(

[Decado]

I guess I'll get to work on those stats properly then, seeing as how everyone is waiting on the formulae for them. :p

[Ziki]

When my member wants to end a battle he can't.I tried to cancel his battle and it said

Warning: Invalid argument supplied for foreach() in /includes/class_rpg_battle.php on line 717

Any ideas?

[nadanada]

They don't? I tested them thoroughly... :surprised:
Well they aren't working for me atleast, I still get "The Clan Name or Clan Password is incorrect. Go Back." after I get an invite.

[MakZF]

Whenether I try to insert a bot I get this error:

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT INTO `vb3_rpg_ibots`
(`botname`,
`levelrequired`,
`cost`,
`expdrop`,
`cashdrop`
`limitname`,
`hp`,
`maxhp`,
`mp`,
`maxmp`,
`pp`,
`maxpp`,
`ap`,
`xp`,
`genderid`)
VALUES
('Test',
'0',
'0',
'99',
'99',
'Test',
'99',
'99',
'99',
'99',
'99',
'99',
'99',
'99',
'1');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limitname`,
`hp`,
`maxhp`,
`mp`,
`maxmp`,
`p


EDIT: Ok, I've tried to install again on a different board (my test vB) it but now it gives this error on the 6th installation step:

Fatal error: Call to undefined function: fetch_table_info() in /home/zeldafo/public_html/forum/installer/class_installer.php on line 849

[Ziki]

When my member wants to end a battle he can't.I tried to cancel his battle and it said

Warning: Invalid argument supplied for foreach() in /includes/class_rpg_battle.php on line 717

Any ideas?

[llskipper]

When I go to the installer, I get all the way to step 3 then it creates the tables:

Created Table: zg_rpg_alignments
Created Table: zg_rpg_battle
Created Table: zg_rpg_battle_posts
Created Table: zg_rpg_battlemusic
Created Table: zg_rpg_categories
Created Table: zg_rpg_clans

Then I get this error:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `zg_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 : Tuesday, April 18th 2006 @ 01:09:43 AM
Script : http://forums.zeldagenesis.com/installer/index.php
Referrer : http://forums.zeldagenesis.com/installer/index.php
IP Address :
Username : Karashimu
Classname : vb_database

[Tyegurl]

Whenether I try to insert a bot I get this error:



a page or two back it was posted....

https://vborg.vbsupport.ru/showpost.php?p=950789&postcount=324

check that out and see if it helps ;)

[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

:(

no one know whats wrong? :(

[Ziki]

I quess no one helps me.....

[cayote]

No, I ment go to your Scheduled Task Manager and change the time the cron job runs at.

Still doesn't work. I checked my logs and all cron jobs are running properly/daily except RPG Lottery which for whatever reason does not run at all unless I manually click pick.

[MakZF]

Ok, bar my previous problem, I mananged to install the hack. I have some testers for the RPG but they are complaining that thier HP will not increase. I have checked and when people gain levels thier HP does not increase, how do I go about fixing this?

[Revan]

Ok, bar my previous problem, I mananged to install the hack. I have some testers for the RPG but they are complaining that thier HP will not increase. I have checked and when people gain levels thier HP does not increase, how do I go about fixing this?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 :)

[vbreal]

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]

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]

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.

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]

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]

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]

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]

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 :p
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 (http://demo.neomateria.net/bugs.php) 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 (http://demo.neomateria.net/forumdisplay.php?f=11). Thx :)

[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]

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]

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

[Ziki]

When my member wants to end a battle he can't.I tried to cancel his battle and it said

Warning: Invalid argument supplied for foreach() in /includes/class_rpg_battle.php on line 717

Revan.....any idea???

[SupremeWeapon]

the un install doesnt work. nor is there anyway to update new skins without uninstalling it completety.

[Revan]

this is probably a stupid question, but do PP/limit break/anger do anything yet?PP - No.
Anger/Limit Break - When AP goes to 100%, you get an increasingly powerful attack. The power of this attack goes up with level up.

[Rated]

Dammit, first time Ive installed this hack correctly. All seems to be working fine, then i go and read a forum and i get a database error, no matter which forum it is :surprised:

I receive an email prompting me of the problem why the couldn't connect, and this is what i get
Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT `userid`, `rpg`, `items`, `inventory`, `uttpoints` AS `points`
FROM `user`
WHERE `userid` = '48';

MySQL Error : Unknown column 'uttpoints' in 'field list'
Error Number : 1054
Date : Thursday, April 20th 2006 @ 07:59:40 AM
Script : http://www.forums.gamelair.com/showthread.php?p=833
Referrer :
IP Address : 66.249.66.168
Username : Unregistered

Any help would be great, thanks :)

[DS MrSinister]

login to admincp vBulletin Options ---> RPG Integration Hack - Cash Options

and change uttpoints to ucash or vbux or what evey it is..

[Rated]

Thanks that worked great :)
Doesn't seem to be using the same amount of money that users have currently in vbBux though :confused:

[vbreal]

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

can someone help me with this. i have this hack turned off untill i can get an answer. i would love to turn it back on. but when the hack is on. i get this error message every time i respond to a post and so do other members

[Rated]

Can anyone post a url to there forum where they have this working correctly? id like to check your postbit and stuff, to take ideas for my own ;)

Also battle music won't work, i have alot of midis in the midi folder, uploaded to the server, but when i go to add them it says they don't exsist, any ideas? :surprised:

Thanks :D

[Revan]

The midis must have an extension of .midi, not .mid. That would be your problem.

[Rated]

That worked thanks :):)

is it possible to have the characters animated in the arena?
Also, is it possible to have a 'rpg' drop down menu, instead of it making another bar going across the top of the forum?

[Ziki]

When my member wants to end a battle he can't.I tried to cancel his battle and it said

Warning: Invalid argument supplied for foreach() in /includes/class_rpg_battle.php on line 717

Revan.....any idea???

Hello???

[Revan]

Nothing that can be done. The battle entry is corrupted. Given the fact that nobody else is recieving this error, this happened on your end.
Delete the database entry manually, in the database set battleid to 0 and re-cache all users.

[Ziki]

Errmmm....didn§t quite get it

[nadanada]

PP - No.
Anger/Limit Break - When AP goes to 100%, you get an increasingly powerful attack. The power of this attack goes up with level up.
ahh ok thanks!

is limit break supposed to go up? it shows 0% for all members, or is there a setting for it?

[Revan]

It goes up when members miss attacks, or do no damage.

[Ziki]

Nothing that can be done. The battle entry is corrupted. Given the fact that nobody else is recieving this error, this happened on your end.
Delete the database entry manually, in the database set battleid to 0 and re-cache all users.

Revan how to do the database thingy?

[Revan]

phpMyAdmin is your friend :P
rpg_battle table houses the database entry you want.

[Ziki]

I am in the table,now what?

[insane12]

Just installed this, and have the same problem i get with most hacks in that they work fine with the vbulletin default style, but not with custon styles.

So my question (just incase anyboby hasn't guest) is how do i make the navbar / links appear with a custom style. normally i would have edited the header templete but the installer takes care of the templete edits so i dont know what to cut and paste where, lol

[MoothMan]

insane12 I have the same issue... I have no idea how to get the navigation into my custom template...will let you know of i work it out :)

[MoothMan]

OK, i just went into the rpg navbar template in the default skin and copied this into my custom header :)

[vbreal]

Nothing that can be done. The battle entry is corrupted. Given the fact that nobody else is recieving this error, this happened on your end.
Delete the database entry manually, in the database set battleid to 0 and re-cache all users.

Revan

i appreciate your mod. but i noticed you have yet to address my issue with the database error and i have posted it twice. how can i correct it. i have it disabled for now. but i am eager to begin using it. could u please give me some idea on whats going on. ever one gets this error when they reply to a thread. i am using ur latest update. thanks in advance

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 : Sunday, April 23rd 2006 @ 12:36:02 AM
Script : http://www.trudaily.com/newreply.php
Referrer : http://www.trudaily.com/showthread.php?t=1824
IP Address : 69.249.227.104
Username : MrDaily
Classname : vb_database

[Shuichi]

I am needing to know how to get my vbplaza to work with the RPG.. I know this may be a stupid question, I am just needing help with it.. Can someone perhaps give me steps on how to do this? And also, if this error can be addressed, I'd VERY much appreciate it! Thanks! :)

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE `user`
SET `user` = `user` - '0'
WHERE `userid` = '1';

MySQL Error : Unknown column 'user' in 'field list'
Error Number : 1054
Date : Sunday, April 23rd 2006 @ 04:02:59 AM
Script : http://khnetwork.com/monsterarena.php
Referrer : http://khnetwork.com/monsterarena.php?do=newbattle&ibotid=32
IP Address : xxxxxx
Username : Piper
Classname : vb_database

[Revan]

Revan

i appreciate your mod. but i noticed you have yet to address my issue with the database error and i have posted it twice. how can i correct it. i have it disabled for now. but i am eager to begin using it. could u please give me some idea on whats going on. ever one gets this error when they reply to a thread. i am using ur latest update. thanks in advance

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 : Sunday, April 23rd 2006 @ 12:36:02 AM
Script : http://www.trudaily.com/newreply.php
Referrer : http://www.trudaily.com/showthread.php?t=1824
IP Address : 69.249.227.104
Username : MrDaily
Classname : vb_databaseThere's an error with your MySQL files. It's quite possible your MySQL configuration does not allow InnoDB, in which case you will need to contact your host.
I am needing to know how to get my vbplaza to work with the RPG.. I know this may be a stupid question, I am just needing help with it.. Can someone perhaps give me steps on how to do this? And also, if this error can be addressed, I'd VERY much appreciate it! Thanks! :)

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE `user`
SET `user` = `user` - '0'
WHERE `userid` = '1';

MySQL Error : Unknown column 'user' in 'field list'
Error Number : 1054
Date : Sunday, April 23rd 2006 @ 04:02:59 AM
Script : http://khnetwork.com/monsterarena.php
Referrer : http://khnetwork.com/monsterarena.php?do=newbattle&ibotid=32
IP Address : xxxxxx
Username : Piper
Classname : vb_databaseYou put the wrong value in the Point Field setting. You are supposed to put the field (like "ucash", "vbbux" or whatever), not the table name.

[Shuichi]

Ooooh thank you sooo much, thank you thank you thank you. I am retarded. Well, now I know what I did wrong. Thanks again! Everything works like A CHARM. Definately should be HOTM :)

[Revan]

Glad to be of service :)
This won't be HOTM though - its time is past. It didn't recieve enough install clicks.

[insane12]

OK, i just went into the rpg navbar template in the default skin and copied this into my custom header :)


Just copying <!-- / nav buttons bar --> to the header templete works as well:)

[smirnoff]

hi, i just wanna know if this Hack is already translated in french .... and where i can find it out if it exist

thanks in advance

best regards

[vbreal]

There's an error with your MySQL files. It's quite possible your MySQL configuration does not allow InnoDB, in which case you will need to contact your host.


thanks i will get in touch with them

but if that isn't the problem. what else could it be.

[vbreal]

We actually don't support InnoDB (we've never really seen a reason to as it's kind of antiquated and not really used). Sorry.


this is his response


so is there any way i can still use the hack. or should just uninstall it now

[MoothMan]

I get the following error after a fight

"KayJay Elron walked over to the cleric and cashed in on the spoils of war: 2000 Gil. commie is not in a Clan, so commie's failure went by unpunished. As a result of KayJay Elron's bravery, Clan KayJays Killers gained 1 Clan Point. KayJay Elron gained 10 EXP and [ARG:3 UNDEFINED] [ARG:4 UNDEFINED] as a reward for exploits in battle. "

How do I correct "[ARG:3 UNDEFINED] [ARG:4 UNDEFINED]"?
No funds get allocated after the win...

TIA

[smirnoff]

Hi i've installed this hack properly, all is ok except ...

Maybe it's me but i cant defeat any monster ... i battle them, and alread OneShooted and die .... i'm unable to win any battle ... so my question is ..

Is the default settings work fine? or must i change EVERY caracteristics and HP MP etc for all monsters to do it working ....

I hope my question is clear (sorry for my bad english)

Best regards

Smirnoff

[Revan]

this is his response


so is there any way i can still use the hack. or should just uninstall it now
Uninstall it, then open ./installer/hacks/rpg_integr_hack/mysql-schema.php and remove ALL instances of "TYPE = InnoDB" then reinstall.
I removed that from the file and that will be default for future versions. Sorry about that, I had no idea.
I get the following error after a fight

"KayJay Elron walked over to the cleric and cashed in on the spoils of war: 2000 Gil. commie is not in a Clan, so commie's failure went by unpunished. As a result of KayJay Elron's bravery, Clan KayJays Killers gained 1 Clan Point. KayJay Elron gained 10 EXP and [ARG:3 UNDEFINED] [ARG:4 UNDEFINED] as a reward for exploits in battle. "

How do I correct "[ARG:3 UNDEFINED] [ARG:4 UNDEFINED]"?
No funds get allocated after the win...

TIAIt's a mixup, will be fixed in the next version.
Hi i've installed this hack properly, all is ok except ...


Maybe it's me but i cant defeat any monster ... i battle them, and alread OneShooted and die .... i'm unable to win any battle ... so my question is ..

Is the default settings work fine? or must i change EVERY caracteristics and HP MP etc for all monsters to do it working ....


I hope my question is clear (sorry for my bad english)

Best regards

SmirnoffIt's because the HP level is wonky. Try making some weapons with damage ("Buff") then try again.

[smirnoff]

ok it seems to be ok, but very hard to understand how it work ...

Btw i've a primordial question...
If i translate this XML into french "product-rpg_integr_hack.xml"
is there any other files where i must translate english into french?
BTW if i succeed to translate, i give u xml and other files back ... like that i got a RPG into 2 langage US+FR ^^

Thanks for your answer

[vbreal]

Uninstall it, then open ./installer/hacks/rpg_integr_hack/mysql-schema.php and remove ALL instances of "TYPE = InnoDB" then reinstall.
I removed that from the file and that will be default for future versions. Sorry about that, I had no idea.
It's a mixup, will be fixed in the next version.
It's because the HP level is wonky. Try making some weapons with damage ("Buff") then try again.

ahh man i have already done an uninstall. and it didn't completely remove all the tables. i had to manually go and do that. and that took for ever.

when i remove all instances of "TYPE = InnoDB" will the hack still work proper ally.

[Revan]

ahh man i have already done an uninstall. and it didn't completely remove all the tables. i had to manually go and do that. and that took for ever.

when i remove all instances of "TYPE = InnoDB" will the hack still work proper ally.Yeah, the hack is not dependant on that. That's just selecting what storage type the tables are in. It will function as normal :)
ok it seems to be ok, but very hard to understand how it work ...


Btw i've a primordial question...
If i translate this XML into french "product-rpg_integr_hack.xml"
is there any other files where i must translate english into french?
BTW if i succeed to translate, i give u xml and other files back ... like that i got a RPG into 2 langage US+FR ^^

Thanks for your answerYou only have to translate the phrases. You should do this releasing a phrase file like vbulletin-language.xml, not the product-rpg_integr_hack.xml.
Also, you don't have to give me the phrase XML file. You can release that wherever, as long as it does not package any .php files.
There's nothing else that needs translating, the hack should be fully phrased :)

[Shuichi]

Oh hello Revan! I know I've said this before, but this is a -GREAT- hack.. But one of my members brought this to my attention and sent the following to me in a Private Message:

=========================================
Hello, can you tell me why the armor is giving me zero def?

Well...here is an example:

http://i23.photobucket.com/albums/b366/pod79/def0.jpg

I got the little window with the explanation by clicking on the "View" icons next to the armor.

You see, the def is 0, and so is the lvl required to use it. I know you adquire def when you lvl up, as you do in many other rpg's...

But what I am trying to say here is that it seems weird that there is a shop for items that...give you nothing, not even different looks?

So I thought that maybe there was missing the def, and the lvl you are required to use it.

For example, there is:

Name Prize
Mythril Vest 1180
Bronze Vest 670
Leather Vest 530

It seems weird that one will cost more than the other, if they don't give you any status (like more def, or in some other games, some clothes give you atk or int, among other things, but here seems to be simple; for clothes, def, for weapons, atk and maybe an element).

The weapons have the same problem, they don't give you any more damage, and you can use them at any level.
=========================================

Anyway to fix this? ^_^;; Sorry I am slow.

[smirnoff]

normal, just configure it by yourself ...

[emtee]

As my understanding, the hack Ultra Image Shop and this hack use the same itemshop.php, so they can't be installed together, right? So if I want them to be compatible with each other using vbPlaza money system, I have to replace every instance of itemshop.php in this hack to another name, ie rpgshop.php ?

Revan, if you could, can you rename itemshop.php to another name i.e. rpgshop.php so it would be compatible with Ultra Image Shop hack? I'm using vbPlaza money system. It will save me some time messing with your code.

Thank you very much.

[Revan]

normal, just configure it by yourself ...Truth.
For the next version, there will be more extensive default data for pretty much everything.
As my understanding, the hack Ultra Image Shop and this hack use the same itemshop.php, so they can't be installed together, right? So if I want them to be compatible with each other using vbPlaza money system, I have to replace every instance of itemshop.php in this hack to another name, ie rpgshop.php ?

Revan, if you could, can you rename itemshop.php to another name i.e. rpgshop.php so it would be compatible with Ultra Image Shop hack? I'm using vbPlaza money system. It will save me some time messing with your code.

Thank you very much.I don't know man, why can't you ask THEM to rename it? If the hack is called Ultra Image Shop then they should have named it imageshop.php or something.

------------------------------------------------------------------------
General Update
This next version will be more extensive than I thought, because as I add new features I find one bit after another needing added. Therefore the next version will most likely be v4, and it will feature a great many improvements to increase configurability.

Also, I decided that, in this thread, I will cut off support for those that cannot click the Install link. This hack lost its chance for HOTM because not enough clicked install. Since I'm not about to extort donations at gunpoint, I think it's only fair that you show that little bit of appreciation by clicking the install link.
The install count is pretty much my only motivation for continuing development of this hack and keeping it free, because it shows that people actually appreciate it.
To all that click the install link: Thanks, it's appreciated :)

[nadanada]

Oh hello Revan! I know I've said this before, but this is a -GREAT- hack.. But one of my members brought this to my attention and sent the following to me in a Private Message:

=========================================
Hello, can you tell me why the armor is giving me zero def?

Well...here is an example:

http://i23.photobucket.com/albums/b366/pod79/def0.jpg

I got the little window with the explanation by clicking on the "View" icons next to the armor.

You see, the def is 0, and so is the lvl required to use it. I know you adquire def when you lvl up, as you do in many other rpg's...

But what I am trying to say here is that it seems weird that there is a shop for items that...give you nothing, not even different looks?

So I thought that maybe there was missing the def, and the lvl you are required to use it.

For example, there is:

Name Prize
Mythril Vest 1180
Bronze Vest 670
Leather Vest 530

It seems weird that one will cost more than the other, if they don't give you any status (like more def, or in some other games, some clothes give you atk or int, among other things, but here seems to be simple; for clothes, def, for weapons, atk and maybe an element).

The weapons have the same problem, they don't give you any more damage, and you can use them at any level.
=========================================

Anyway to fix this? ^_^;; Sorry I am slow.

in the admin panel you adjust both level and def (it may be called damage) in item manager, just tested and it worked for me

[smirnoff]

Hi,

I have tested your hack and i see i cannot get more HP when i lvlup its stuck at 15 HP ... You know what is the problem ?? where can i configure that?

See you lather :)

[aramik]

ok ive just got one problem. what should I link to from the index... rpg.php leads to just the characters, isnt there a certain idex menu that links with all the pages.. ie , lottery, shops, batte arenas etc? or do I have to compile the menu myself?

[Revan]

Hi,

I have tested your hack and i see i cannot get more HP when i lvlup its stuck at 15 HP ... You know what is the problem ?? where can i configure that?

See you lather :)Need to increase the Modifiers in the AdminCP. That will be fixed in a future version.
ok ive just got one problem. what should I link to from the index... rpg.php leads to just the characters, isnt there a certain idex menu that links with all the pages.. ie , lottery, shops, batte arenas etc? or do I have to compile the menu myself?You are lacking the necessary comment string in the navbar template.
Insert <!-- / nav buttons bar --> just after the original navbar.

[ForYou]

Hello ,

When i was need to uninstall the hack to reinstall again , i got this error ,

:

Invalid SQL:

ALTER TABLE `administrator`
DROP `rpgadminperms`;

MySQL Error : Can't DROP 'rpgadminperms'; check that column/key exists
Error Number : 1091
Date : Saturday, April 29th 2006 @ 08:04:06 PM


please help why this error come :(

[trackpads]

Revan,

Excellent work man. I have RPG Inferno installed but is this better? I mean as many if not more features?

It looks like it is better supported and the Vbux integration is awesome.

Thanks again,

-Jason

[Revan]

Revan,

Excellent work man. I have RPG Inferno installed but is this better? I mean as many if not more features?

It looks like it is better supported and the Vbux integration is awesome.

Thanks again,

-JasonWell, currently Inferno has more features. But I am working on powerful features that I believe will surpass Inferno.
So yea I think the most this hack got going for it atm is the fact that it's free :p

[Darkfire122333]

Fatal error: Undefined class name 'rpg_core' in /home/xxxx/public_html/xxx/forums/includes/rpg_plugins/showthread_post_start.php on line 19

I get this after i uninstalled and re-installed the RPG hack.. I have tried re-installign again, i don't know what to do.. help?

[Revan]

Seems like your global_start plugin is fubared. Make sure that contains the include() for class_rpg_core.php and that this file exists in the folder.
A reupload of all files might be the way to go.

[Darkfire122333]

Fatal error: Undefined class name 'rpg_core' in /home/xxxx/public_html/xxx/forums/includes/rpg_plugins/showthread_post_start.php on line 19

still shows up after i re-uploaded the files 4 times, then i reinstalled, uninstalled all those combinations, but it does not work :(

[Revan]

What that error means is that includes/class_rpg_core isn't being included in global_start like it should.
open showthread_post_start.php and put at the top after the <?php
include(DIR . '/includes/class_rpg_core.php');
ad see if this helps.

[Zowners]

Is there any way to get rid of the character creation? I just want people to be able to register and play! This whole character creation and class setting is ridiculous. I tried turning off headquarters, but it did nothing more than refuse any new players to create a character.

I was also wondering if there would be any way to integrate the item center with the vbplaza shop. And just have it another catagory that is displayed in the shop. that would be really cool and just have the items displayed like that.

And finally, I was wondering if there would be a way to get rid of the dualing system, and just have it so that there is an attack button in the postbit that just attacks the person. So no accepting the fight or whatever. It just happens whether the person is online or offline. And then when they die, their usegroup is changed.

I know this is a lot to ask, so I am thinking of offering paypal? Name your price and we shall negotiate.

[Darkfire122333]

What that error means is that includes/class_rpg_core isn't being included in global_start like it should.
open showthread_post_start.php and put at the top after the <?php
include(DIR . '/includes/class_rpg_core.php');
ad see if this helps.

Thank you! it works :D why did it do this? It was working fine before, what made it suddenly do this?


Ok now i get this error when trying to go into healing center, headquarters, etc...

Fatal error: Undefined class name 'rpg_core' in /home/xxxx/public_html/xxx/forums/headquarters.php on line 75

[Revan]

Your global_start plugin is fubared. That error will spawn on every single page unless you fix it.
I don't know how to fix it, since I don't have that error appearing anywhere. Try to check that the RPG - Global Require plugin is active. That's all I can tell you.

[Darkfire122333]

Well I have tried everything in my power to get this to work with no prevail. If you ever do get a fix, be sure to PM me becuase I am uninstalling this. Sorry, but I do not run flawed things on my board.

- Dark (Aka Trevor)

[Kungfu]

Little off topic but to Raven, what Theme are you using for windows xp. Looks like royale but slightly different. Sorry for the off topic question.

[Revan]

Is there any way to get rid of the character creation? I just want people to be able to register and play! This whole character creation and class setting is ridiculous. I tried turning off headquarters, but it did nothing more than refuse any new players to create a character.

I was also wondering if there would be any way to integrate the item center with the vbplaza shop. And just have it another catagory that is displayed in the shop. that would be really cool and just have the items displayed like that.

And finally, I was wondering if there would be a way to get rid of the dualing system, and just have it so that there is an attack button in the postbit that just attacks the person. So no accepting the fight or whatever. It just happens whether the person is online or offline. And then when they die, their usegroup is changed.

I know this is a lot to ask, so I am thinking of offering paypal? Name your price and we shall negotiate.Not to mention how I don't have access to a computer at the moment, I need to get the hack in proper shape before I undertake such an extensive task.
Sorry, but I don't have the time to do this at the moment. It might benefit you, should you choose to attempt to hire someone to do this for you, to wait until the hack don't have too many major changes left to it. Not only because it will cost you extra to get it rewritten, but because you might like the new features ;)
Well I have tried everything in my power to get this to work with no prevail. If you ever do get a fix, be sure to PM me becuase I am uninstalling this. Sorry, but I do not run flawed things on my board.

- Dark (Aka Trevor)It's extremely difficult for me to bugfix something that is obviously not a problem with my hack. How I know it's not the RPG hack's fault? 300+ users have fresh installed and/or upgraded this hack and I have heard bugger all about this before.
So yeah, maybe your PHP version is incompatible for some reason, I dunno.
Little off topic but to Raven, what Theme are you using for windows xp. Looks like royale but slightly different. Sorry for the off topic question.It's called Luna Element 4 if Im not mistaken.

[Darkfire122333]

It's extremely difficult for me to bugfix something that is obviously not a problem with my hack. How I know it's not the RPG hack's fault? 300+ users have fresh installed and/or upgraded this hack and I have heard bugger all about this before.
So yeah, maybe your PHP version is incompatible for some reason, I dunno.

How do I know that this information is misleading?

I have had the hack installed ebfore, Thus, making it so that it DOES work on my PHP version. The only problem I can see is that something you did to the new version is not compatable with one of my other adons or that there is a tiny glitch in the files. Also I have tested this on 4 DIFFERENT boards and I get all the same results. So enjoy that little tase of life thanks.

[Zowners]

Not to mention how I don't have access to a computer at the moment, I need to get the hack in proper shape before I undertake such an extensive task.
Sorry, but I don't have the time to do this at the moment. It might benefit you, should you choose to attempt to hire someone to do this for you, to wait until the hack don't have too many major changes left to it. Not only because it will cost you extra to get it rewritten, but because you might like the new features ;)


Well, right now I have a hack from another website that is allowing me to port it over. pending on whether or not I can do this, I will probably hire someone to edit what I need.

[Paintfaker]

where become the RPG Hack? I need it

[Revan]

How do I know that this information is misleading?

I have had the hack installed ebfore, Thus, making it so that it DOES work on my PHP version. The only problem I can see is that something you did to the new version is not compatable with one of my other adons or that there is a tiny glitch in the files. Also I have tested this on 4 DIFFERENT boards and I get all the same results. So enjoy that little tase of life thanks.And do you expect me to verify that this hack is compatible with every single other addon out there? I think not.
And how do you explain how every single one of the other boards that ahve this installed (including my localhost and 3 live test sites) do not get this error?
If YOU want to spend two years creating something for free and install every other hack on vB.org in order to verify none of them messes anything up, then be my guest.
So unless you want to try to disable all your other products and re-enable them one at a time until you find the one that's faulty, I think you can take your "tase" of life out of my thread.
kthxbai.

[Darkfire122333]

Haha like hell i would do that, besides, I DO LIKE YER HACK! I never said I didn't, I am just going to wait until the next version to install it, I was just merely saying it might be a flaw in the code connecting to another hack. I am trying to be nice here, I am a nice person, I just got mad when you said it may be my PHP version...

I do like how you created this for free :d i am happy about that, do not worry, I enjoy this, so do my members, that is why I am anxious to install it again.

And yes... I cannot spell either... haha

[KHALIK]

It was working perfect for me, until recently

I get this message when I attemp to play a match "Start Battle" (Monster Arena), how can I fix this? I have many members and do not wish to reset everything.

I have resetted my character, and did the following;
Rebuild RPG Cache
RPG User Table Populate Fix
RPG User Table Cleanup
Rebuild RPG Users

Still No Luck, and getting the same message when I am about to enter a battle --> "Start Battle" (Monster Arena)

What could be the problem and how can I resolve it.


Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO rpg_ibot_templates
(`userid`,
`ibotid`,
`hp`,
`maxhp`,
`mp`,
`maxmp`,
`pp`,
`maxpp`,
`ap`)
VALUES
('1',
'3',
'320',
'320',
'54',
'54',
'67',
'67',
'0');

MySQL Error : Duplicate entry '1' for key 1
Error Number : 1062
Date : Saturday, May 6th 2006 @ 06:20:43 PM
Script : http://www.fragmasters.co.uk/forum/monsterarena.php
Referrer : http://www.fragmasters.co.uk/forum/monsterarena.php?do=newbattle&ibotid=3
IP Address : 83.67.204.214
Username : Fragmaster
Classname : vb_database

[KHALIK]

Your opponent is ineligible for Battle at this time. Go Back.

I keep getting this message and members who try to challenge me also get this message?

Any Ideas why and how can this be fixed?

[CyberCheetor]

During installation I get the following error:

Database error in vBulletin 3.5.4:

Invalid SQL:

ALTER TABLE `administrator`
ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date : Monday, May 8th 2006 @ 05:09:49 PM
Script : http://www.beastbot.com/forums/installer/index.php
Referrer : http://www.beastbot.com/forums/installer/index.php
IP Address : 68.119.186.149
Username : CyberCheetor
Classname : vb_database

How do I fix it?

[inkdot]

bug 1:
"You are currently listed as participating in Monster Battle 504. Enter here and finish that Monster Battle."
then you get this error message "Invalid Monster Battle. Go Back."
The battle number doesn't exist. Is there an option to clear the battle record so anyone can start a new battle eventhough they didn't end their previous battle? Does anyone know what's causing this so i can warn my members about it.

bug 2:
pic 1: Game Master off, user bought 3 weapons and sold the equipped item but cant use or equip the other weapons. Radio-box is disabled.

pic 2: Game Master on, user bought 2 weapons and sold the equipped item. The extra weapon can be equipped and sold then shows up in inventory again allowing the user to sell it over and over.

[Revan]

Whoah XD
Well Im sorry to say that I can't fix this until the next version. Reason(s) for this is that not only have I butchered the files and SQL on my localhost, but my computer is dead and dormant at the store until my amd dual core and mobo gets shipped to me.

[TamCaVBoy3]

how come i don't see the code to change in postbit, pleaes help, i also installed vbbux

[Revan]

You might be using a non-default template, thus the instructions would appear broken to you.
I suggest you split the instruction code up, and try to manually pinpoint where you should insert RPG code.
I can't (or rather, won't) find this for you, it's fairly easy if you know how to edit a template though.

[tvsf]

Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO `datastore`
(`title`, `data`)
VALUES
('rpg_alignments', ''),
('rpg_battlemusic', ''),
('rpg_categories', ''),
('rpg_classes', ''),
('rpg_clans', ''),
('rpg_elements', ''),
('rpg_genders', ''),
('rpg_ibots', ''),
('rpg_items', ''),
('rpg_races', ''),
('rpg_scenes', ''),
('rpg_types', '');

MySQL Error : Duplicate entry 'rpg_alignments' for key 1
Error Number : 1062
Date : Thursday, May 11th 2006 @ 03:24:27 PM
Script : http://tvseriesforum.com/tvsf/installer/index.php
Referrer : http://tvseriesforum.com/tvsf/installer/index.php
IP Address : 24.17.40.123
Username : The One
Classname : vb_database


That's the error i get when i run the installer. Any idea what's going on?

[Jafo232]

Simple question..

How are users supposed to know WHO to fight when you cannot see users RPG username? You can't display any RPG info in the postbit???!???!??

[mikeylikesitz]

regular postbit doesn't have the RPG code yet, i know it sucks, but either wait until its released with it or code it yourself. I myself will wait.

[Jafo232]

I just copied and edited the code for the legacy template, works for now.

[jon_argent]

HELP!!!

After installing this great mod, my site stopped working!! Whenever I tried to do anything, error messages come up, such as:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT `userid`, `rpg`, `items`, `inventory`, `uttpoints` AS `points`
FROM `user`
WHERE `userid` = '6';

MySQL Error : Unknown column 'uttpoints' in 'field list'
Error Number : 1054
Date : Friday, May 12th 2006 @ 06:56:56 PM
Script : http://www.landofthepinkbunnies.co.uk/showthread.php?p=746#post746
Referrer : http://www.landofthepinkbunnies.co.uk/
IP Address : 195.93.21.37
Username : guns_have_bunnies
Classname : vb_database


and:

Database error in vBulletin 3.5.4:

Invalid SQL:

UPDATE `user`
SET `uttpoints` = `uttpoints` - '0'
WHERE `userid` = '1';

MySQL Error : Unknown column 'uttpoints' in 'field list'
Error Number : 1054
Date : Friday, May 12th 2006 @ 12:25:48 AM
Script : http://www.landofthepinkbunnies.co.uk/monsterarena.php
Referrer : http://www.landofthepinkbunnies.co.uk/monsterarena.php?do=newbattle&ibotid=32
IP Address : 172.202.172.179
Username : Mr C
Classname : vb_database


Can anyone help me here?!

[Darkfire122333]

that ones easy.. go into the rpg cash options in the admincp and change the points field to what your cash mod is using aka for vbplaza it is vbbux and for ucash n store it's ustore <-- try that, and see if that fixes this problem.

[jon_argent]

stupid thing, but i'm not using any cash mod... what then?!

[Tulsa]

stupid thing, but i'm not using any cash mod... what then?!


Important Notices:

1. 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

[jon_argent]

Hi,

I've got that sorted :D but a couple more questions now:
1) Is there anyway to set a certain amount of currency to a character (editing it maybe, not cheating as such?)
2) When i went to reset my character, i got an error:

Fatal error: Call to a member function on a non-object in /homepages/15/d146309981/htdocs/includes/class_rpg_battle.php on line 431.

[dt~]

Hi all,

My character , upon level up, did not gain any HP increase. I think it has something to do with 'elements'. Kindly advise. Thanks.

[Darkfire122333]

ok,

dt~

your problem is, that the hp is connected to posting for now, I do not know if revan is going to change this, but you have to post on a regular basis to be able to allow your character to level and such. I found this out when I was running it.

jon_argent

i do not know how to fix number 2, but number one is easy, all you do is go ont your admincp liuke usual, edit the user, there is a new table for the store cash, just edit that, and you will be "awarded" that cash. also if you are running vbplaza, then all you have to do is go to "admin donate" in the vbplaza dropdown in the navbar and you can do it there! ease as pie!

[Jafo232]

I think it is safe to say, this mod requires A LOT OF WORK. I tried it out on a pretty big forum last week and ran into numerous problems. For one thing, users kept getting stuck in battles with monsters. Disappearing items was also another problem.

You should be very cautious before installing this mod, it just doesn't work.

Clicks uninstall.

[Revan]

ok,

dt~

your problem is, that the hp is connected to posting for now, I do not know if revan is going to change this, but you have to post on a regular basis to be able to allow your character to level and such. I found this out when I was running it.Wrong. That method changed about a year ago.
The reason why HP/MP/PP fails to increase is that the Elements are being moved out of the HP/MP/PP equation. Therefore the HP/MP/PP modifiers need to be increased in the AdminCP.
I think it is safe to say, this mod requires A LOT OF WORK. I tried it out on a pretty big forum last week and ran into numerous problems. For one thing, users kept getting stuck in battles with monsters. Disappearing items was also another problem.Yet I don't see you reporting any bugs in the bug tracker...
You should be very cautious before installing this mod, it just doesn't work.I think that's too bold of a statement. Sure, there's bugs that will be sorted out, but there's no need to be an +++++++ about it. Because yeah, that sort of statement really pisses me off.

[Jafo232]

Yet I don't see you reporting any bugs in the bug tracker...


Yet I don't see 'Beta' checked on this mod either, which I suppose you can be forgiven since this is obviously Alpha.


I think that's too bold of a statement. Sure, there's bugs that will be sorted out, but there's no need to be an +++++++ about it. Because yeah, that sort of statement really pisses me off.

What's so bold about telling people to be cautious about installing a non-working mod? It isn't about being an +++++++, it is about giving other people a heads up about non-working software before they install it.

[Darkfire122333]

What's so bold about telling people to be cautious about installing a non-working mod? It isn't about being an +++++++, it is about giving other people a heads up about non-working software before they install it.

Dude, please not that Revan works his ass off to get this hack working, if you do not want to use it, fine! thats your choice, people are aware that there are errors in the RPG hack, like myself, I had a problem, I am not not using it till the next version, but that does not mean i do not support this...

People do not need a "Heads up" about not working products becuase obviously it is not indended for fools to use this hack, get pissed off and flame about it (guilty, but i m over that, sorry revan)

Can I please ask you to be nicer to revan, all he is doing is creating a hack for the mass public, FREE, so please be quiet becuase he is doing a terriffic job and this is on his spare time so you cannot expect everything to be fixed.

Oh, and as an endnote... DO YOU REALLY EXPECT IT TO HAVE NO FLAWS? Jesus, if you do, get off your windows, linux, or mac version you are using and stop using that! ALL things have flaws so if you don't like it, throw your comp out the window! I GUARANTEE that you will have no mor problems with that computer :P :banana:

[Ziki]

Nominated for HOTM ;)

[Darkfire122333]

Nominated here too! There you go revan! you deserve it!

[tvsf]

In step 5...my installation failed. Is there a way to reverse the installation process and remove all tables and revert modified tables back to their original format? If not, then what tables do I need to delete manually and what kinds of edit do I have to do to my modified tables. thanks

[Revan]

Dude, please not that Revan works his ass off to get this hack working, if you do not want to use it, fine! thats your choice, people are aware that there are errors in the RPG hack, like myself, I had a problem, I am not not using it till the next version, but that does not mean i do not support this...

People do not need a "Heads up" about not working products becuase obviously it is not indended for fools to use this hack, get pissed off and flame about it (guilty, but i m over that, sorry revan)

Can I please ask you to be nicer to revan, all he is doing is creating a hack for the mass public, FREE, so please be quiet becuase he is doing a terriffic job and this is on his spare time so you cannot expect everything to be fixed.

Oh, and as an endnote... DO YOU REALLY EXPECT IT TO HAVE NO FLAWS? Jesus, if you do, get off your windows, linux, or mac version you are using and stop using that! ALL things have flaws so if you don't like it, throw your comp out the window! I GUARANTEE that you will have no mor problems with that computer :P :banana:
Nominated for HOTM ;)
Nominated here too! There you go revan! you deserve it!Thanks for the support :)

Imma go work on the Effects system, it's going to be powerful :) When I can get it to work properly and get the in-battle going, you're going to be able to add spells/weapons with effects like Drain and Osmose (for those unfamiliar with Final Fantasy, Drain means taking opponent HP and adding to your own, Osmose is the same but only for MP).
I still have a lot of work before the next version is released, Im going to hold off on the majority of complex features in order to get a fixed release online sooner.
I might also attempt to patch the current version, depending on how hard it is to fix the problems.

[Darkfire122333]

sounds awesome! :D just do not overwork yourself, pace, lol.

Well good luck getting that all fixed, I am going to ask my host to reset my hosting and I am going to re-install the whole board :P.

That is how much I like this hack. Well good luck on getting everything working! I am off to go to my work.. peace!


--EDIT--

Oh and revan, i'm going to do that update on the RPG Manual for you, i'll make it so that it is in vB style, would that be acceptable to you?

[Revan]

sounds awesome! :D just do not overwork yourself, pace, lol.No worries there, I take frequent breaks with some TES IV: Oblivion ;) I didn't buy this 7900GTX to have it display nothing but PHP :p
Oh and revan, i'm going to do that update on the RPG Manual for you, i'll make it so that it is in vB style, would that be acceptable to you?Sounds great, I have just never gotten around to doing that.
Note that that thing is like from the vB2 version, I think it was written by Bitsys XD I haven't read it in ages, but feel free to cut out all the chatter where it explains why he assembled the mod in the first place and the likes :p

[Darkfire122333]

what would you rather revan.. it all in the php file or it in the template still? either/or can be done by me :D

[dt~]

Hi all,

I have a very cute looking girlfriend, and we have been together for 2 years. Recently, her attitute changed. She began to reply with only a few words through the phone, and sometimes not even online when I attemp to chat with her throughout the night.

Feeling worried, I started to check on her handphone calls oftenly. To my surprise, there is another guy who have kept calling her since the past few months. She explained to me that he is only one of her college friends. My suspicion grew. Worse, she cancelled our date today with a reason that she will be busy.

Frustrated, I drive to her place this morning and parked myself near her apartment. I wish to see what she is doing while playing with my laptop. After a few hours, a handsome guy appeared with a bunch of roses on his hand. To my surprise, he was heading in the direction to my girlfriend's place! I attemp to rush out and dropped my laptop accidentally. I noticed that the laptop screen displayed a "Invalid Battle ID" message.

So besides waiting for the next release is there anything I can do about it?

[Revan]

what would you rather revan.. it all in the php file or it in the template still? either/or can be done by me :DWell if you're talking about the frontend then in the template would be good, if in the AdminCP then obviously in the php file :)
Hi all,

I have a very cute looking girlfriend, and we have been together for 2 years. Recently, her attitute changed. She began to reply with only a few words through the phone, and sometimes not even online when I attemp to chat with her throughout the night.

Feeling worried, I started to check on her handphone calls oftenly. To my surprise, there is another guy who have kept calling her since the past few months. She explained to me that he is only one of her college friends. My suspicion grew. Worse, she cancelled our date today with a reason that she will be busy.

Frustrated, I drive to her place this morning and parked myself near her apartment. I wish to see what she is doing while playing with my laptop. After a few hours, a handsome guy appeared with a bunch of roses on his hand. To my surprise, he was heading in the direction to my girlfriend's place! I attemp to rush out and dropped my laptop accidentally. I noticed that the laptop screen displayed a "Invalid Battle ID" message.

So besides waiting for the next release is there anything I can do about it?That depends entirely on where you see this Invalid Battle ID message. Did she attempt to continue an apparently finished Monster Battle after making out with her lover? I'm not sure if I seperated the error messages from the Monster Arena and the Battle Arena.

[dt~]

That depends entirely on where you see this Invalid Battle ID message. I'm not sure if I seperated the error messages from the Monster Arena and the Battle Arena.

After adding your hack, there were hundreds of users from my end who support it and invested their time with enthusiasm. Unfortuantely, similiar cases starts appearing - A "Battle no. xx does not exist" message. We could not join a Battle arena nor a monster arena. I don't think it's realistic to sit and wait for the next release, because the heat has only started.

I seek for your kind assistance to offer a help on this problem. For example, maybe you can provide a simple php script which can create battle IDs, or making a user's character 'free' to participate in another battle by dropping his current (invalid) ones. I have read through all user notes from V3.0 to NeoMaterial, hence writing here is the last option.

Looking forward for your reply, Thanks!
Aka.

[Darkfire122333]

Finished the Manual. Have sent Revan a PM with the url to it and a demo. I hope you like it Revan!

[jon_argent]

i do not know how to fix number 2, but number one is easy, all you do is go ont your admincp liuke usual, edit the user, there is a new table for the store cash, just edit that, and you will be "awarded" that cash. also if you are running vbplaza, then all you have to do is go to "admin donate" in the vbplaza dropdown in the navbar and you can do it there! ease as pie!

I didn't mean as a one off, I meant to edit the amount of currency each player would start off with? Is this possible?

[coRtALoS]

I'm getting an error when trying to install this on 3.5.3

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT INTO rpg_items
(`categoryid`, `itemname`, `cost`, `description`, `icon`, `stock`, `sold`, `damage`, `itemorder`, `itemtype`, `levelreq`, `extra`)
VALUES
(1, 'Dagger', 320, 'Weapon used by thieves', 'dagger', 34, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mage Masher', 200, 'Weapon originally used for combating mages', 'dagger', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Dagger', 950, 'Thief dagger made of mythril', 'dagger', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Butterfly Sword', 300, 'Standard thief sword', 'thiefsword', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'The Ogre', 700, 'Standard thief sword', 'thiefsword', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Masamune', 5600, 'Sword from a foreign land', 'thiefsword', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Air Racket', 400, 'Long-range combat racket.', 'racket', 21, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Rod', 260, 'Combat Rod', 'rod', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Rod', 760, 'Rod made of mythril', 'rod', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Broadsword', 330, 'Ordinary sword used in combat', 'blade', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Iron Sword', 660, 'Sword made of iron', 'blade', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Sword', 1300, 'Sword made out of mythril', 'blade', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Blood Sword', 2000, 'Sword varnished with blood', 'blade', 33, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mage Staff', 320, 'Staff used by black mages', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Flame Staff', 1100, 'Staff with a divine fire spirit dwelling inside', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Ice Staff', 980, 'Staff with a divine ice power dwelling inside', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Lightning Staff', 1200, 'Staff with a divine thunder power inside', 'staff', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Javelin', 880, 'Spear used by Dragon Knights', 'polearm', 44, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Spear', 1100, 'Spear made of mythril', 'polearm', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Partisan', 1600, 'Spear adorned with brilliant gems', 'polearm', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Poison Knuckles', 500, 'Combat knuckles', 'fist', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Claws', 750, 'Claws made of mythril', 'fist', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Shirt', 270, 'Clothes made of leather.', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Plate', 530, 'Plate worn for combat', 'shirt', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Vest', 670, 'Plate made of bronze', 'shirt', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Chain Plate', 810, 'Plate that provides brimming strength', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Cotton Robe', 200, 'Ordinary shirt', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Vest', 1180, 'Vest braided with mythril', 'vest', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Armor', 650, 'Armor made of bronze', 'plate', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Linen Cuirass', 800, 'Armor packed with magic', 'plate', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Hat', 150, 'Not a suitable item to wear in combat', 'hat', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Steepled Hat', 260, 'Hat worn by mages.', 'hat', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bandana', 500, 'Mysterious bandana that makes you light-footed', 'hat', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Rubber Helmet', 250, 'Helm worn by soldier trainees', 'helm', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Helmet', 300, 'Helmet made of bronze', 'helm', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Iron Helmet', 400, 'Helmet made of iron', 'helm', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Barbut', 600, 'Headgear that raises Spirit', 'helm', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Helmet', 1000, 'Helmet made of mythril', 'helm', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Pearl Armlet', 100, 'Regular wristlet', 'armgear', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Wrist', 130, 'Regular wristlet', 'armgear', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Glass Armlet', 250, 'Armlet made of glass', 'armgear', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bone Wrist', 330, 'Wristlet made from bones. Raises Earth Elem-Atk', 'armgear', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Armlet', 500, 'Armlet made of mythril', 'armgear', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Wrist', 200, 'Wristlet that raises Spirit when equipped', 'armgear', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Gloves', 480, 'Gloves made of bronze', 'glove', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Gloves', 980, 'Gloves made of mythril', 'glove', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Thunder Gloves', 1200, 'with a thunder god? power dwelling inside', 'glove', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Diamond Gloves', 2000, 'Gloves made of diamond', 'glove', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Hi-Potion', 200, 'Restores 300 HP in the field and 450 HP in battle.', 'vial1', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Potion', 100, 'Restores 100 HP in the field and 150 HP in battle', 'vial1', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Ether', 500, 'Restores 100 MP in the field and 150 MP in battle.', 'vial1', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Elixir', 1500, 'Full restores HP and MP.', 'vial1', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Gysahl Greens', 100, 'Cures Berserk and lures chocobos.', 'greens', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Phoenix Down', 150, 'Recovers a character from KO.', 'feather', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Echo Screen', 50, 'Cures Silence status.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Soft', 50, 'Cures Petrify and Gradual Petrify.', 'vial2', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Antidote', 50, 'Cures Poison and Venom.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Eye Drops', 50, 'Cures Darkness.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Magic Tag', 100, 'Cures Zombie status.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Vaccine', 100, 'Cures Virus.', 'vial2', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Remedy', 300, 'Cures various status abnormalities.', 'vial2', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Annoyntment', 150, 'Cures Trouble status.', 'vial2', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Tent', 800, 'Restores a large amount of HP and MP and removes some status effects.', 'tent', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Ore', 500, 'Restores HP. It cannot be used in field. It radiates a mysterious light.', 'orb', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0');;

MySQL Error : You have an error in your SQL syntax near ';
' at line 68
Error Number : 1064
Date : Friday, May 19th 2006 @ 03:28:41 PM
Script : http://battleforums.com/T35tHaCk5/installer/index.php
Referrer : http://battleforums.com/T35tHaCk5/installer/index.php
Username : RoaCh Of DisCord
Classname : vb_database

Any help, please? Would upgrading to 3.5.4 resolve this?

[Darkfire122333]

From what i can tell at this point, your tabled did not install properly, uninstall the hack and re-install it. Itshuld be fine if there is nothing wrong with your php.

[Langly]

in the admin panel you adjust both level and def (it may be called damage) in item manager, just tested and it worked for me

Where in the admin panel is this? All I see is uCash menu, uShop menu and 3 sections under vBulletin Options. None of these show the items.

[Langly]

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.

Where in admincp is this located?

Cheers

[Zowners]

Hey Great hack but im having a problem when I installed it. Users cant create a rpg character. You can put your name in make your alignment but nothing can be done after that. Please I have no clue what to do Ive reinstalled it twice.

[Zowners]

Ok fixed the problem but I have another for some reason when I buy a weapon in the store and use it in the battle my rpg character drinks it instead of using it. Any help would be great!!!

[Revan]

A milestone has been reached in the development of the RPG Integration Hack. I have pretty much finished the Admin backend for the Effects system.
For those of you that haven't been paying attention to the thread and wondering what the Effects system is, I'll give you a brief summary: Whatever you want it to be. You want the Blood Sword to actually drain damage? Now you can.
The Effects system will replace the generic "buff" you see in the current items, which is highly limiting and doesn't work like it's supposed to. Now, when creating items, you are asked to check boxes marking which effects you want to add to your item. You will of course be able to create these effects through an user-friendly interface on a seperate page.
I'll explain a bit how to create an effect: Say you want to create what makes your item called "X-Potion" heal all HP. First, you click Add New Effect. Then select "Healing" from the dropdown you see. Then select the following: [Self] [HP] by {100} [Percent], then click Add New Effect button. The [] brackets indicate dropdown menus where you will be able to select other options for your effect. The {} brackets indicate values you must write in yourself.
You will be able to add effects from three categories: Damage, Healing and Stat Modifier. The Damage is most commonly used for weapons, or items like Grenade. The Healing, as we saw, is most used for potions of various nature and also healing skills. The Stat Modifier is used to increase/decrease the raw stats. Weapons will most likely want to use this primarily to increase Strength/Attack and Armor will want to increase Endurance et cetera. You will also be able to decrease stats, for debuff skills and the likes.

But wait! There's more!
Have you ever been annoyed over the fact that "Two-handed" still allowed you to use a Shield? Then I have good news for you.
In the next version, Equipment Slots are added. These Equipment Slots make sure that Two-Handed Weapons have equip scope (what slots they occupy) to Left and Right, making equipping a shield (which goes into the Right slot) impossible.

The last and also least [I]completed change I will note today is the assigning of Battle Types to items. You know how you previously had to access a page that listed all your items and you must mark the checkbox for all the battletypes you want? Well now you have the option of doing this on a per-item basis. Just click the Edit link on the item as if it you were editing anything else about the item, and you can mark checkboxes for what Battle Types you want to be able to equip this item.


What I will begin working on next is the Skills system. This shouldn't take too long to complete the backend of, and it too will become highly customiseable. I will give a similar summary once I have completed it.

I can't give an ETA as to when this will be ready for Beta, simply because I haven't done anything on the front-end yet, and that's the most extensive part. I have also discovered a bug in the new Level Up system which will be exploitable unless I fix it. Which I will.
Not to mention how I have yet to be able to track down any of the bugs in the current system, though I admit I am guilty of letting this slide as I don't know if I will be changing the stuff that has bugs in it now.


For those of you that are wanting support for this version, I ask you to review the bold text in my signature.
Since the release of this hack, 80% of everybody who posted in this thread has not clicked Install. What's so terrible about showing your support?

[Langly]

Where do you edit the monsters, users, items? I tried in SQL but that didn't do anything. It turns ppl off when they have a blood sword and can't kill a dire wolf to lvl. Plus, the exp goes to zero when you die. In other RPG's you stay the same exp once you heal/resurrect. Only a slight exp decrease.

[Revan]

In your Admin Control Panel, you should see a link to "RPG Integration Hack" menu. If you do not see this, then you need to make yourself Super Administrator and set your Can Administer RPG to Yes.

[Dan]

A milestone has been reached in the development of the RPG Integration Hack. I have pretty much finished the Admin backend for the Effects system.
For those of you that haven't been paying attention to the thread and wondering what the Effects system is, I'll give you a brief summary: Whatever you want it to be. You want the Blood Sword to actually drain damage? Now you can.
The Effects system will replace the generic "buff" you see in the current items, which is highly limiting and doesn't work like it's supposed to. Now, when creating items, you are asked to check boxes marking which effects you want to add to your item. You will of course be able to create these effects through an user-friendly interface on a seperate page.
I'll explain a bit how to create an effect: Say you want to create what makes your item called "X-Potion" heal all HP. First, you click Add New Effect. Then select "Healing" from the dropdown you see. Then select the following: [Self] [HP] by {100} [Percent], then click Add New Effect button. The [] brackets indicate dropdown menus where you will be able to select other options for your effect. The {} brackets indicate values you must write in yourself.
You will be able to add effects from three categories: Damage, Healing and Stat Modifier. The Damage is most commonly used for weapons, or items like Grenade. The Healing, as we saw, is most used for potions of various nature and also healing skills. The Stat Modifier is used to increase/decrease the raw stats. Weapons will most likely want to use this primarily to increase Strength/Attack and Armor will want to increase Endurance et cetera. You will also be able to decrease stats, for debuff skills and the likes.

But wait! There's more!
Have you ever been annoyed over the fact that "Two-handed" still allowed you to use a Shield? Then I have good news for you.
In the next version, Equipment Slots are added. These Equipment Slots make sure that Two-Handed Weapons have equip scope (what slots they occupy) to Left and Right, making equipping a shield (which goes into the Right slot) impossible.

The last and also least [I]completed change I will note today is the assigning of Battle Types to items. You know how you previously had to access a page that listed all your items and you must mark the checkbox for all the battletypes you want? Well now you have the option of doing this on a per-item basis. Just click the Edit link on the item as if it you were editing anything else about the item, and you can mark checkboxes for what Battle Types you want to be able to equip this item.


What I will begin working on next is the Skills system. This shouldn't take too long to complete the backend of, and it too will become highly customiseable. I will give a similar summary once I have completed it.

I can't give an ETA as to when this will be ready for Beta, simply because I haven't done anything on the front-end yet, and that's the most extensive part. I have also discovered a bug in the new Level Up system which will be exploitable unless I fix it. Which I will.
Not to mention how I have yet to be able to track down any of the bugs in the current system, though I admit I am guilty of letting this slide as I don't know if I will be changing the stuff that has bugs in it now.


For those of you that are wanting support for this version, I ask you to review the bold text in my signature.
Since the release of this hack, 80% of everybody who posted in this thread has not clicked Install. What's so terrible about showing your support?
Awsome stuff man awsome stuff :)

[Zowners]

Sorry to post this again but im desperate. When I buy a weapon in the store and use it in the battle my rpg character drinks it instead of using it. Any help would be great!!!

[coRtALoS]

A milestone has been reached in the development of the RPG Integration Hack. I have pretty much finished the Admin backend for the Effects system.
For those of you that haven't been paying attention to the thread and wondering what the Effects system is, I'll give you a brief summary: Whatever you want it to be. You want the Blood Sword to actually drain damage? Now you can.
The Effects system will replace the generic "buff" you see in the current items, which is highly limiting and doesn't work like it's supposed to. Now, when creating items, you are asked to check boxes marking which effects you want to add to your item. You will of course be able to create these effects through an user-friendly interface on a seperate page.
I'll explain a bit how to create an effect: Say you want to create what makes your item called "X-Potion" heal all HP. First, you click Add New Effect. Then select "Healing" from the dropdown you see. Then select the following: [Self] [HP] by {100} [Percent], then click Add New Effect button. The [] brackets indicate dropdown menus where you will be able to select other options for your effect. The {} brackets indicate values you must write in yourself.
You will be able to add effects from three categories: Damage, Healing and Stat Modifier. The Damage is most commonly used for weapons, or items like Grenade. The Healing, as we saw, is most used for potions of various nature and also healing skills. The Stat Modifier is used to increase/decrease the raw stats. Weapons will most likely want to use this primarily to increase Strength/Attack and Armor will want to increase Endurance et cetera. You will also be able to decrease stats, for debuff skills and the likes.

But wait! There's more!
Have you ever been annoyed over the fact that "Two-handed" still allowed you to use a Shield? Then I have good news for you.
In the next version, Equipment Slots are added. These Equipment Slots make sure that Two-Handed Weapons have equip scope (what slots they occupy) to Left and Right, making equipping a shield (which goes into the Right slot) impossible.

The last and also least [I]completed change I will note today is the assigning of Battle Types to items. You know how you previously had to access a page that listed all your items and you must mark the checkbox for all the battletypes you want? Well now you have the option of doing this on a per-item basis. Just click the Edit link on the item as if it you were editing anything else about the item, and you can mark checkboxes for what Battle Types you want to be able to equip this item.


What I will begin working on next is the Skills system. This shouldn't take too long to complete the backend of, and it too will become highly customiseable. I will give a similar summary once I have completed it.

I can't give an ETA as to when this will be ready for Beta, simply because I haven't done anything on the front-end yet, and that's the most extensive part. I have also discovered a bug in the new Level Up system which will be exploitable unless I fix it. Which I will.
Not to mention how I have yet to be able to track down any of the bugs in the current system, though I admit I am guilty of letting this slide as I don't know if I will be changing the stuff that has bugs in it now.


For those of you that are wanting support for this version, I ask you to review the bold text in my signature.
Since the release of this hack, 80% of everybody who posted in this thread has not clicked Install. What's so terrible about showing your support?

I have sir ;). I've clicked 'install' except, I can't seem to get it installed.

[coRtALoS]

From what i can tell at this point, your tabled did not install properly, uninstall the hack and re-install it. Itshuld be fine if there is nothing wrong with your php.

I can't uninstall it, because it hasn't been installed.

I am a newer admin at our forums, and I think that we may have had a previous version of this rpg hack installed in the past. Maybe it wasn't uninstalled fully, and this is causing the problem? I am still getting the above error, and can't uninstall because it isn't installed =\.

Still this error:

INSERT INTO rpg_items
(`categoryid`, `itemname`, `cost`, `description`, `icon`, `stock`, `sold`, `damage`, `itemorder`, `itemtype`, `levelreq`, `extra`)
VALUES
(1, 'Dagger', 320, 'Weapon used by thieves', 'dagger', 34, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mage Masher', 200, 'Weapon originally used for combating mages', 'dagger', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Dagger', 950, 'Thief dagger made of mythril', 'dagger', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Butterfly Sword', 300, 'Standard thief sword', 'thiefsword', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'The Ogre', 700, 'Standard thief sword', 'thiefsword', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Masamune', 5600, 'Sword from a foreign land', 'thiefsword', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Air Racket', 400, 'Long-range combat racket.', 'racket', 21, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Rod', 260, 'Combat Rod', 'rod', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Rod', 760, 'Rod made of mythril', 'rod', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Broadsword', 330, 'Ordinary sword used in combat', 'blade', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Iron Sword', 660, 'Sword made of iron', 'blade', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Sword', 1300, 'Sword made out of mythril', 'blade', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Blood Sword', 2000, 'Sword varnished with blood', 'blade', 33, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mage Staff', 320, 'Staff used by black mages', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Flame Staff', 1100, 'Staff with a divine fire spirit dwelling inside', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Ice Staff', 980, 'Staff with a divine ice power dwelling inside', 'staff', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Lightning Staff', 1200, 'Staff with a divine thunder power inside', 'staff', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Javelin', 880, 'Spear used by Dragon Knights', 'polearm', 44, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Spear', 1100, 'Spear made of mythril', 'polearm', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Partisan', 1600, 'Spear adorned with brilliant gems', 'polearm', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Poison Knuckles', 500, 'Combat knuckles', 'fist', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(1, 'Mythril Claws', 750, 'Claws made of mythril', 'fist', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Shirt', 270, 'Clothes made of leather.', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Plate', 530, 'Plate worn for combat', 'shirt', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Vest', 670, 'Plate made of bronze', 'shirt', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Chain Plate', 810, 'Plate that provides brimming strength', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Cotton Robe', 200, 'Ordinary shirt', 'shirt', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Vest', 1180, 'Vest braided with mythril', 'vest', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Armor', 650, 'Armor made of bronze', 'plate', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Linen Cuirass', 800, 'Armor packed with magic', 'plate', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Hat', 150, 'Not a suitable item to wear in combat', 'hat', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Steepled Hat', 260, 'Hat worn by mages.', 'hat', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bandana', 500, 'Mysterious bandana that makes you light-footed', 'hat', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Rubber Helmet', 250, 'Helm worn by soldier trainees', 'helm', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Helmet', 300, 'Helmet made of bronze', 'helm', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Iron Helmet', 400, 'Helmet made of iron', 'helm', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Barbut', 600, 'Headgear that raises Spirit', 'helm', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Helmet', 1000, 'Helmet made of mythril', 'helm', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Pearl Armlet', 100, 'Regular wristlet', 'armgear', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Wrist', 130, 'Regular wristlet', 'armgear', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Glass Armlet', 250, 'Armlet made of glass', 'armgear', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bone Wrist', 330, 'Wristlet made from bones. Raises Earth Elem-Atk', 'armgear', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Armlet', 500, 'Armlet made of mythril', 'armgear', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Leather Wrist', 200, 'Wristlet that raises Spirit when equipped', 'armgear', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Bronze Gloves', 480, 'Gloves made of bronze', 'glove', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Mythril Gloves', 980, 'Gloves made of mythril', 'glove', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Thunder Gloves', 1200, 'with a thunder god? power dwelling inside', 'glove', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(2, 'Diamond Gloves', 2000, 'Gloves made of diamond', 'glove', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Hi-Potion', 200, 'Restores 300 HP in the field and 450 HP in battle.', 'vial1', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Potion', 100, 'Restores 100 HP in the field and 150 HP in battle', 'vial1', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Ether', 500, 'Restores 100 MP in the field and 150 MP in battle.', 'vial1', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Elixir', 1500, 'Full restores HP and MP.', 'vial1', 6, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Gysahl Greens', 100, 'Cures Berserk and lures chocobos.', 'greens', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Phoenix Down', 150, 'Recovers a character from KO.', 'feather', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Echo Screen', 50, 'Cures Silence status.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Soft', 50, 'Cures Petrify and Gradual Petrify.', 'vial2', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Antidote', 50, 'Cures Poison and Venom.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Eye Drops', 50, 'Cures Darkness.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Magic Tag', 100, 'Cures Zombie status.', 'vial2', 4, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Vaccine', 100, 'Cures Virus.', 'vial2', 7, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Remedy', 300, 'Cures various status abnormalities.', 'vial2', 5, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Annoyntment', 150, 'Cures Trouble status.', 'vial2', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Tent', 800, 'Restores a large amount of HP and MP and removes some status effects.', 'tent', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0'),
(3, 'Ore', 500, 'Restores HP. It cannot be used in field. It radiates a mysterious light.', 'orb', 0, 0, 0, 0, '1', 0, '0,0,0,0,0,0');;

MySQL Error : You have an error in your SQL syntax near ';
' at line 68
Error Number : 1064

[Don-King]

Hello

I have a small problem with this hack.Now i will give you a few informations:
vBulletin Version:vBulletin 3.5.4.
Description:
After I have tryed to installed this hack ,i have got the following error:
Error:
Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:

SELECT `userid`, `rpg`, `items`, `inventory`, `AS` AS `points`
FROM `vbuser`
WHERE `userid` = '97';

MySQL-Fehler : Unknown column 'AS' in 'field list'
Fehler-Nr. : 1054
Datum : Monday, May 22nd 2006 @ 04:20:15 PM
Skript : http://www.greatgamers.de/forum/showthread.php?t=798
Referrer : http://www.greatgamers.de/forum/forumdisplay.php?f=43
IP-Adresse : **.***.***.***
Benutzername : Don-King
Klassenname : vB_Database


Edit: There's a option in the admin menue: Point Field:
This should be set to the same value as whatever Cash hack you are using. and i don't know what it is meaning.

I Hope anybody can help me :confused:

[Revan]

I can't uninstall it, because it hasn't been installed.

I am a newer admin at our forums, and I think that we may have had a previous version of this rpg hack installed in the past. Maybe it wasn't uninstalled fully, and this is causing the problem? I am still getting the above error, and can't uninstall because it isn't installed =\.Open ./installer/hacks/rpg_integr_hack/mysql-schema.php and find:
'0,0,0,0,0,0');
Change to:
'0,0,0,0,0,0')

Older MySQL versions have problems with that line.

[coRtALoS]

Thank you! I saw that earlier and fixed it, worked. :)

[coRtALoS]

Ack, however..now I have a new problem. Possibly a file I didn't upload? I'm checking now..

Here is the issue, though

[Revan]

Okay that looks like your tables didn't get populated properly.
Id just uninstall it and reinstall, due to that mysql bug major bugs arose and your best bet would be a clean install.
Sorry for the trouble, Ill have that file fixed for the next version.

Just for the record, what version of mysql are you running?

[oninuva]

every time i enter battle i get a mysql error

here Invalid SQL:

UPDATE `user`
SET `uttpoints` = `uttpoints` - '0'
WHERE `userid` = '1';

MySQL Error : Unknown column 'uttpoints' in 'field list'

help?

and how do i make the nav bar a drop down list?

[coRtALoS]

Okay that looks like your tables didn't get populated properly.
Id just uninstall it and reinstall, due to that mysql bug major bugs arose and your best bet would be a clean install.
Sorry for the trouble, Ill have that file fixed for the next version.

Just for the record, what version of mysql are you running?

Hey, no problem. Thank you for the help so far.

I uninstalled, and reinstalled it, but still no luck.

I am using MySQL version 3.23.58

[Revan]

Hmm, then I don't know what could be wrong... Only other thing I can think of is if you fire every bit of Maintenance off and see if that does bugger all...
If that doesn't do anything, try running soemthing like
SELECT classid FROM rpg_classes
And see if that returns any rows.

And for the record, you might want to contact your host about upgrading MySQL. That version is 4 years old and will not be supported by the next version of vBulletin.
You will need MySQL 4.0 or newer, personally I suggest 4.1 for a good, stable release that won't need too much reconfiguration to work properly with vBulletin.

[oninuva]

if i die how do i ressurect?

[Zidane007nl]

if i die how do i ressurect?Heal yourself at the Healing Center for a small price.

And Revan, nice new features you announced. Really looking forward to it.

[oninuva]

i did but its in grey so i cant buy it,.

[coRtALoS]

Hmm, then I don't know what could be wrong... Only other thing I can think of is if you fire every bit of Maintenance off and see if that does bugger all...
If that doesn't do anything, try running soemthing like
SELECT classid FROM rpg_classes
And see if that returns any rows.

And for the record, you might want to contact your host about upgrading MySQL. That version is 4 years old and will not be supported by the next version of vBulletin.
You will need MySQL 4.0 or newer, personally I suggest 4.1 for a good, stable release that won't need too much reconfiguration to work properly with vBulletin.

I did that query, and it did pull up results. It seems the tables are populated, noot sure what the problem is. I will definitely talk to the owner about upgrading mysql though, thanks. :)

-edit

Yeah, I checked the database, and everything seems fine. The tables have all the information. Must be a PHP problem, or something! I think i'll try updating vbulletin to the latest this weekend, and see if that does anything.

[Oddjob]

I uninstalled this a long while back, i tried to re-install it tonight. I get this error in step 4 of the installation.

Database error in vBulletin 3.5.4:

Invalid SQL:

ALTER TABLE `administrator`
ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date : Tuesday, May 23rd 2006 @ 11:30:37 PM
Script : http://www.xx.com/forums//installer/index.php
Referrer : http://www.xx.com/forums//installer/index.php
IP Address : **(
Username : ***
Classname : vb_database

Ive searched this but have not found an answer.

Help.

[Revan]

I did that query, and it did pull up results. It seems the tables are populated, noot sure what the problem is. I will definitely talk to the owner about upgrading mysql though, thanks. :)

-edit

Yeah, I checked the database, and everything seems fine. The tables have all the information. Must be a PHP problem, or something! I think i'll try updating vbulletin to the latest this weekend, and see if that does anything.Did you try running the maintenance functions? Seems like either your cache is not built or not built properly.
SELECT * FROM datastore WHERE title = 'rpg_classes' See what that gives, should pull up a serialised string.
You might be using a php version with a bugged unserialize() function, I dunno.

[oninuva]

ahhh! how do i fix this?

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT languageid,
phrasegroup_arcade AS phrasegroup_arcade,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_arcade' in 'field list'
Error Number : 1054
Date : Wednesday, May 24th 2006 @ 05:32:27 AM
Script : http://www.wow-elite.org/forum/arcade.php?do=scores&gameid=98
Referrer :
IP Address : 65.54.188.99
Username :
Classname : vb_database


it came up after i installed this

[coRtALoS]

Did you try running the maintenance functions? Seems like either your cache is not built or not built properly.
SELECT * FROM datastore WHERE title = 'rpg_classes' See what that gives, should pull up a serialised string.
You might be using a php version with a bugged unserialize() function, I dunno.

I did this, and got:

a:132:{i:1;a:12:{s:7:"classid";s:1:"1";s:9:"classname";s:7:"Unknown";s:11:"classfolder";s:14:"mclasses/nonem";s:11:"classregatt";s:1:"1";s:13:"classmagicatt";s:1:"1";s:13:"classmagicdef";s:1:"1";s:11:"classregdef";s:1:"1";s:9:"classpeed";s:1:"1";s:10:"classevade";s:1:"1";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"1";s:7:"visible";s:1:"1";}i:2;a:12:{s:7:"classid";s:1:"2";s:9:"classname";s:6:"Amazon";s:11:"classfolder";s:16:"fclasses/amazonf";s:11:"classregatt";s:1:"8";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:3;a:12:{s:7:"classid";s:1:"3";s:9:"classname";s:6:"Archer";s:11:"classfolder";s:16:"fclasses/archerf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:4;a:12:{s:7:"classid";s:1:"4";s:9:"classname";s:8:"Archmage";s:11:"classfolder";s:18:"fclasses/archmagef";s:11:"classregatt";s:1:"6";s:13:"classmagicatt";s:2:"10";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:5;a:12:{s:7:"classid";s:1:"5";s:9:"classname";s:8:"Assassin";s:11:"classfolder";s:18:"fclasses/assassinf";s:11:"classregatt";s:2:"10";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"6";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:6;a:12:{s:7:"classid";s:1:"6";s:9:"classname";s:10:"Black Mage";s:11:"classfolder";s:19:"fclasses/blackmagef";s:11:"classregatt";s:1:"6";s:13:"classmagicatt";s:2:"10";s:13:"classmagicdef";s:2:"10";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:7;a:12:{s:7:"classid";s:1:"7";s:9:"classname";s:10:"Blacksmith";s:11:"classfolder";s:20:"fclasses/blacksmithf";s:11:"classregatt";s:1:"8";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:8;a:12:{s:7:"classid";s:1:"8";s:9:"classname";s:10:"Calculator";s:11:"classfolder";s:20:"fclasses/calculatorf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:9;a:12:{s:7:"classid";s:1:"9";s:9:"classname";s:7:"Captain";s:11:"classfolder";s:17:"fclasses/captainf";s:11:"classregatt";s:2:"10";s:13:"classmagicatt";s:1:"6";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:2:"10";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:10;a:12:{s:7:"classid";s:2:"10";s:9:"classname";s:7:"Chemist";s:11:"classfolder";s:17:"fclasses/chemistf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:11;a:12:{s:7:"classid";s:2:"11";s:9:"classname";s:11:"Dark Knight";s:11:"classfolder";s:20:"fclasses/darkknightf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"9";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:12;a:12:{s:7:"classid";s:2:"12";s:9:"classname";s:7:"Dragoon";s:11:"classfolder";s:17:"fclasses/dragoonf";s:11:"classregatt";s:1:"8";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"6";s:10:"classevade";s:1:"6";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:13;a:12:{s:7:"classid";s:2:"13";s:9:"classname";s:10:"Ex-Soldier";s:11:"classfolder";s:20:"fclasses/ex-soldierf";s:11:"classregatt";s:2:"10";s:13:"classmagicatt";s:1:"6";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:14;a:12:{s:7:"classid";s:2:"14";s:9:"classname";s:12:"Foot Soldier";s:11:"classfolder";s:21:"fclasses/footsoldierf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:2:"10";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:15;a:12:{s:7:"classid";s:2:"15";s:9:"classname";s:7:"Gambler";s:11:"classfolder";s:17:"fclasses/gamblerf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"6";s:10:"classevade";s:1:"6";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:16;a:12:{s:7:"classid";s:2:"16";s:9:"classname";s:9:"Geomancer";s:11:"classfolder";s:19:"fclasses/geomancerf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"9";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:17;a:12:{s:7:"classid";s:2:"17";s:9:"classname";s:11:"Holy Knight";s:11:"classfolder";s:20:"fclasses/holyknightf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"7";s:9:"

That's about half of the code, there's more..but it's all in that format.

[Oddjob]

Revan can i please have some help on how to re-install this...........

[Oddjob]

Still seeking help.......

[Revan]

ahhh! how do i fix this?



it came up after i installed thisAs you can see from the error, it's a problem with the Arcade.
I did this, and got:

a:132:{i:1;a:12:{s:7:"classid";s:1:"1";s:9:"classname";s:7:"Unknown";s:11:"classfolder";s:14:"mclasses/nonem";s:11:"classregatt";s:1:"1";s:13:"classmagicatt";s:1:"1";s:13:"classmagicdef";s:1:"1";s:11:"classregdef";s:1:"1";s:9:"classpeed";s:1:"1";s:10:"classevade";s:1:"1";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"1";s:7:"visible";s:1:"1";}i:2;a:12:{s:7:"classid";s:1:"2";s:9:"classname";s:6:"Amazon";s:11:"classfolder";s:16:"fclasses/amazonf";s:11:"classregatt";s:1:"8";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:3;a:12:{s:7:"classid";s:1:"3";s:9:"classname";s:6:"Archer";s:11:"classfolder";s:16:"fclasses/archerf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:4;a:12:{s:7:"classid";s:1:"4";s:9:"classname";s:8:"Archmage";s:11:"classfolder";s:18:"fclasses/archmagef";s:11:"classregatt";s:1:"6";s:13:"classmagicatt";s:2:"10";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:5;a:12:{s:7:"classid";s:1:"5";s:9:"classname";s:8:"Assassin";s:11:"classfolder";s:18:"fclasses/assassinf";s:11:"classregatt";s:2:"10";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"6";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:6;a:12:{s:7:"classid";s:1:"6";s:9:"classname";s:10:"Black Mage";s:11:"classfolder";s:19:"fclasses/blackmagef";s:11:"classregatt";s:1:"6";s:13:"classmagicatt";s:2:"10";s:13:"classmagicdef";s:2:"10";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:7;a:12:{s:7:"classid";s:1:"7";s:9:"classname";s:10:"Blacksmith";s:11:"classfolder";s:20:"fclasses/blacksmithf";s:11:"classregatt";s:1:"8";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:8;a:12:{s:7:"classid";s:1:"8";s:9:"classname";s:10:"Calculator";s:11:"classfolder";s:20:"fclasses/calculatorf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:9;a:12:{s:7:"classid";s:1:"9";s:9:"classname";s:7:"Captain";s:11:"classfolder";s:17:"fclasses/captainf";s:11:"classregatt";s:2:"10";s:13:"classmagicatt";s:1:"6";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:2:"10";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:10;a:12:{s:7:"classid";s:2:"10";s:9:"classname";s:7:"Chemist";s:11:"classfolder";s:17:"fclasses/chemistf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"8";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:11;a:12:{s:7:"classid";s:2:"11";s:9:"classname";s:11:"Dark Knight";s:11:"classfolder";s:20:"fclasses/darkknightf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"9";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:12;a:12:{s:7:"classid";s:2:"12";s:9:"classname";s:7:"Dragoon";s:11:"classfolder";s:17:"fclasses/dragoonf";s:11:"classregatt";s:1:"8";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"7";s:9:"classpeed";s:1:"6";s:10:"classevade";s:1:"6";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:13;a:12:{s:7:"classid";s:2:"13";s:9:"classname";s:10:"Ex-Soldier";s:11:"classfolder";s:20:"fclasses/ex-soldierf";s:11:"classregatt";s:2:"10";s:13:"classmagicatt";s:1:"6";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"5";s:10:"classevade";s:1:"5";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:14;a:12:{s:7:"classid";s:2:"14";s:9:"classname";s:12:"Foot Soldier";s:11:"classfolder";s:21:"fclasses/footsoldierf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"7";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:2:"10";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:15;a:12:{s:7:"classid";s:2:"15";s:9:"classname";s:7:"Gambler";s:11:"classfolder";s:17:"fclasses/gamblerf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"6";s:11:"classregdef";s:1:"9";s:9:"classpeed";s:1:"6";s:10:"classevade";s:1:"6";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:16;a:12:{s:7:"classid";s:2:"16";s:9:"classname";s:9:"Geomancer";s:11:"classfolder";s:19:"fclasses/geomancerf";s:11:"classregatt";s:1:"7";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"9";s:11:"classregdef";s:1:"8";s:9:"classpeed";s:1:"4";s:10:"classevade";s:1:"4";s:6:"typeid";s:1:"1";s:8:"genderid";s:1:"2";s:7:"visible";s:1:"1";}i:17;a:12:{s:7:"classid";s:2:"17";s:9:"classname";s:11:"Holy Knight";s:11:"classfolder";s:20:"fclasses/holyknightf";s:11:"classregatt";s:1:"9";s:13:"classmagicatt";s:1:"8";s:13:"classmagicdef";s:1:"7";s:11:"classregdef";s:1:"7";s:9:"
That's about half of the code, there's more..but it's all in that format.Okay, then we have established that the database is OK.
Are you sure the templates are all reverted, if you had edited them?

[Oddjob]

Hey Revan.....do you not give support?

Im trying to re-install your mod and your just ignoring me.

[Oddjob]

....guess not.

thats a shame.

[Revan]

Hey Revan.....do you not give support?

Im trying to re-install your mod and your just ignoring me.
....guess not.

thats a shame.Do you not read my signature? Guess not, thats a shame.
Honestly now, I don't see what's so bad about showing the small ounce of support back. Users like you are the reason coders leave this site, and why people want to go commercial with their hacks.
Do you have any idea of how annoying it is to get demands for support from someone who can't even show that one bit of free support by clicking the install link?
Is it a mental block that makes you unable to click the link or do you just have no respect for the TWO YEARS I put into this hack? And during these two years, I have been "paid" less than you would make in one day working at Wal-Mart or whatever your local supermarket chain is called. Im not demanding donations, I'm merely making a point, the point being that I spend at least a couple of hours every day trying my best to make my hack better and more flexible.

Also, I tend to like more to give support when the query is more than "I cant reinstall."


General update, Ill post detailed info on the latest milestone reached in a few minutes. I need to post in another thread first...

[Oddjob]

Do you not read my signature? Guess not, thats a shame.
Honestly now, I don't see what's so bad about showing the small ounce of support back. Users like you are the reason coders leave this site, and why people want to go commercial with their hacks.

Do you have any idea of how annoying it is to get demands for support from someone who can't even show that one bit of free support by clicking the install link?


Why am i going to click "Install" if it isnt installed on my board? Coders release products here for free on their own accord. I dont need the lecture that they leave because of people like me. Because to be honest i could care less.


Is it a mental block that makes you unable to click the link or do you just have no respect for the TWO YEARS I put into this hack? And during these two years, I have been "paid" less than you would make in one day working at Wal-Mart or whatever your local supermarket chain is called. Im not demanding donations, I'm merely making a point, the point being that I spend at least a couple of hours every day trying my best to make my hack better and more flexible.

Dont take it out on me that you dont make any money from your mod. You have a bug in your product, i simply asked for help.


Also, I tend to like more to give support when the query is more than "I cant reinstall."

I have posted the error i got a few posts back an they were just ignored. I have seen a few other people with the same problem, their posts ignored as well.

[Tri@de]

I try to make it simple: clicking install you have support.
So, don't complain. If you want support click install, even if you don't have it installed.

If for some reasons (logic: i don't have it installed so i don't click install)
or for pride (this pseudo-flame discussion) you know you will never get an answer.

Now Oddjob, is up to you...

[alexanderpas]

For support, please visit the RPG Integration Hack Support Forums (http://demo.neomateria.net/)
All support queries in this thread will be ignored by me. I don't think it's strange he doesn't give any support here.

[Revan]

So its about time I talk about the next milestone... *ahem*
The Admin Control Panel part of the skills is now done. True to what I hope will be the new theme of the RPG Integration Hack, skills are highly customiseable.
When you create a new skill, you are presented with two choices: First, whether or not it is a "General" or "Class-specific" skill. That's right, skills will be filterable by class. No longer do you find Warriors running around casting Firaga (unless you want them to :p), nor will you find Black Mages using Blade Beam. The second choice you are given is whether or not the skill is Active or Passive. For those unfamiliar with Lineage II skill categorisation, Active skills are skills you can use provided you meet the requirements (more on this below) whereas Passive skills are skills that's always in effect.
You will not be able to swap between Active and Passive type after creating it, since it's altering some of the fundamental properties of the skill.
For instance, with a Passive skill to Warriors you could make them stand out more by giving them Defence stat boosts for increased HP.
Active skills are simply skills like Firaga or Power Break.

Another important thing is that skills have durations. Called Skill Lasting Time in the interface, this can be used to create DoT (Damage over Time) skills. Alternatively, if you choose Restoration effects, you would get healing over time (Regen). This would effectively allow you to create status properties though not in the sense I had originally planned it. But you can understand it, if you add small amount of damage and make it last say 5 turns, you could call that skill Poison and watch the opponents HP whither away.

You will be able to configure an usage cost, where you will input a number followed by a dropdown box where you can select between MP and PP. Yeah, PP finally has a use.
You will of course also be able to configure a skill category.

The Level Requirement and Learning Cost are two options which will have a say in how an user aquires the skill. If you set both to 0, the skill is learned at character creation, provided the class requirement is met if it's a class skill.
If Learning Cost is set to 0, the skill will be aquired once a player reaches the specified level.
And finally, if Learning Cost is set, the user must buy the skills at that cost.

The Governing Stat option only has an effect if the effects you attach to the skill has the "Governed by an attribute" set on it. Needless to say, it's the stat that is taken into the calculation.


That's about what can be said about the skills :)
I have no ETA due to the fact that none of the front-end stuff for this is coded yet.

[Amaranth]

This is by far my favorite mod so far, outshining even the vbArcade! :) And I can't wait for the next update, your new features sound like alot of fun. Thanks alot for your hard work, Revan, can't wait to see what you come up with next!


[Q?] Only the Admin, usergroup 1, is listed in my RPG user table. Which means I can't for example give mass XP to my members, which is a shame. I have installed and uninstalled the mod a couple of times due to database issues(forgot to change Cash Option), if that matters. MySQL and PHP are not old. Can someone please tell me how to resolve this?

(I have of course tried RPG User Table Populate Fix, RPG User Table Cleanup, Rebuild RPG Users and the other logical options in the Maintenance section)


[Q?] Only the primary Admin 1 sees the RPG admincp link, how can I expand this to include the entire Administrator group?


[REQ] It would be wonderful if one was able to duplicate an existing Race with all it's genders and their classes to create a new race. This would save alot of time and effort.


[REQ] It would be fun if users could upload avatars for their champions.

[Revan]

This is by far my favorite mod so far, outshining even the vbArcade! :) And I can't wait for the next update, your new features sound like alot of fun. Thanks alot for your hard work, Revan, can't wait to see what you come up with next!Thanks for the nice feedback :)
[Q?] Only the Admin, usergroup 1, is listed in my RPG user table. Which means I can't for example give mass XP to my members, which is a shame. I have installed and uninstalled the mod a couple of times due to database issues(forgot to change Cash Option), if that matters. MySQL and PHP are not old. Can someone please tell me how to resolve this?

(I have of course tried RPG User Table Populate Fix, RPG User Table Cleanup, Rebuild RPG Users and the other logical options in the Maintenance section)That makes no sense whatsoever. I mean, I understand what it is you mean, but why it's happening is what makes no sense. When you say only the Admin, usergroup 1, dya mean userid 1 or everybody in the usergroup id 1?
Also you wouldn't need to uninstall/reinstall due to the cash option, that can be updated without problems.
[Q?] Only the primary Admin 1 sees the RPG admincp link, how can I expand this to include the entire Administrator group?Become Super Admin by editing the config file, then alter peoples Can Administer RPG.
[REQ] It would be wonderful if one was able to duplicate an existing Race with all it's genders and their classes to create a new race. This would save alot of time and effort.With the next version, you will be able to export all the RPG info bar the Options to an XML file, so you could duplicate them that way :)
[REQ] It would be fun if users could upload avatars for their champions.Ill note that down, though it doesn't have the highest priority. Getting this new stuff to actually work, eh? ;)

[Amaranth]

Thanks alot for answering my questions! There are some problems that persist though... I am not able to Mass XP the users anymore. Moderators and Admins have very low XP, trying to re-set the values doesn`t have any effect. Trying to update the RPG user tables only returns information that Admin user was updated, no-one else... Ah well, I`ll fool around a little more and see if I get any wiser. :)

Here is the latest error message, when trying to re-install the mod:
Database error in vBulletin 3.5.4:
Invalid SQL:
ALTER TABLE `vb_administrator`
ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
MySQL Error : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date : Monday, May 29th 2006 @ 07:33:08 PM


Edit: Okay, I found out that I needed to edit my config.php file and allow myself to run SQL queries from the Admin CP. Using commands like "ALTER TABLE vb_administrator DROP rpgadminperms" on similar syntas for vb_user rpg, items, inventory and vb_usergroup drop rpgpermissions... But, I still don?t understand the last error message I get, which is the part where it`s trying to feed info the rpg_alignments, rpg_battlemusic etc. tables...

Now I have deleted all the vb_rpg_* tables using the "DROP TABLE vb_rpg_alignments" and so on - but the install script still stops and says there is a duplicate key entry or whatever... Which I don`t understand, cuz I have deleted all the tables, and they should have been reconstructed in empty form... Please help!

[Revan]

Thanks alot for answering my questions! There are some problems that persist though... I am not able to Mass XP the users anymore. Moderators and Admins have very low XP, trying to re-set the values doesn`t have any effect. Trying to update the RPG user tables only returns information that Admin user was updated, no-one else... Ah well, I`ll fool around a little more and see if I get any wiser. :)

Here is the latest error message, when trying to re-install the mod:
Database error in vBulletin 3.5.4:
Invalid SQL:
ALTER TABLE `vb_administrator`
ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
MySQL Error : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date : Monday, May 29th 2006 @ 07:33:08 PM

Edit: Okay, I found out that I needed to edit my config.php file and allow myself to run SQL queries from the Admin CP. Using commands like "ALTER TABLE vb_administrator DROP rpgadminperms" on similar syntas for vb_user rpg, items, inventory and vb_usergroup drop rpgpermissions... But, I still don?t understand the last error message I get, which is the part where it`s trying to feed info the rpg_alignments, rpg_battlemusic etc. tables...

Now I have deleted all the vb_rpg_* tables using the "DROP TABLE vb_rpg_alignments" and so on - but the install script still stops and says there is a duplicate key entry or whatever... Which I don`t understand, cuz I have deleted all the tables, and they should have been reconstructed in empty form... Please help!Ok that was hella much... Uhm why didn't you uninstall using the uninstall.php script this time? Because I know for a fact that removes the rpgadminperms there...
And I cant explain any error messages I don't see.

[Amaranth]

Sorry for the confusion! :) Illegible English in my previous post, which doesn`t help...

What happened was that when I ran the uninstall script, it was interrupted because the database query/post limit from my provider was reached - effectively shutting everything down for 1 hour... This might have caused some problems/corruption somewhere, perhaps? After this happened, that is when the uninstall script didn`t function properly - it had been working fine until said incident took place... So, I`m not blaming you for a crap uninstall, it worked well until it got iced by my domain provider...

The error message is the same that has been posted previously in this thread, when the install script is trying to populate/setup the rpg_alignments, rpg_races etc. tables.

EDIT: Here is the above-mentioned error message:
Database error in vBulletin 3.5.4:

Invalid SQL:

INSERT INTO `datastore`
(`title`, `data`)
VALUES
('rpg_alignments', ''),
('rpg_battlemusic', ''),
('rpg_categories', ''),
('rpg_classes', ''),
('rpg_clans', ''),
('rpg_elements', ''),
('rpg_genders', ''),
('rpg_ibots', ''),
('rpg_items', ''),
('rpg_races', ''),
('rpg_scenes', ''),
('rpg_types', '');

MySQL Error : Duplicate entry 'rpg_alignments' for key 1
Error Number : 1062
Date : Thursday, May 11th 2006 @ 03:24:27 PM
Script : http://tvseriesforum.com/tvsf/installer/index.php
Referrer : http://tvseriesforum.com/tvsf/installer/index.php
IP Address : 24.17.40.123
Username : The One
Classname : vb_database

[Revan]

Sorry for the confusion! :) Illegible English in my previous post, which doesn`t help...

What happened was that when I ran the uninstall script, it was interrupted because the database query/post limit from my provider was reached - effectively shutting everything down for 1 hour... This might have caused some problems/corruption somewhere, perhaps? After this happened, that is when the uninstall script didn`t function properly - it had been working fine until said incident took place... So, I`m not blaming you for a crap uninstall, it worked well until it got iced by my domain provider...

The error message is the same that has been posted previously in this thread, when the install script is trying to populate/setup the rpg_alignments, rpg_races etc. tables.

EDIT: Here is the above-mentioned error message:
Database error in vBulletin 3.5.4:I see, well that makes it clearer :)
Here's what you must run to fix that:
DELETE FROM datastore WHERE title LIKE 'rpg_%'

Also you might want to swap hosting companies, because a forum that can't run more than 10 queries per hour does pretty much sod all good ;)

[Amaranth]

Ace! Thanks alot for your help :)

[D-Block]

What is the table used to INTEGRATE this with VBPLAZA/EBUX?

I have no idea what the right table is to make these 2 work together so I get sql errors unless I disable it.

Please, someone who has worked with VBplaza/ebux+RPG Integration, help me out here, I have been at this for an entire day. =(

[coRtALoS]

As you can see from the error, it's a problem with the Arcade.
Okay, then we have established that the database is OK.
Are you sure the templates are all reverted, if you had edited them?

Hi

Yes they were all reverted. I tried some of the maintanance functions, but not all. Which would you suggest?

Thanks
:)

[Tulsa]

Well finally loaded this thing to give it a whirl.

Very nicely done! Two thumbs up! :)

Any clue when the update is going to be released? I'm going to wait to release it to my members until then.

I moved everything into a dropdown on my main navbar, when the next release comes out is there going to be an option for this as that second navbar just looked awful on my site?

[mikeylikesitz]

the second navbar and the postbit are stopping me from installing this atm. i cant wait to see the next release though

[Tulsa]

I didn't install the postbit stuff myself, no real need for it. Fixing the navbar was a snap too.

[Revan]

Hi

Yes they were all reverted. I tried some of the maintanance functions, but not all. Which would you suggest?

Thanks
:)Maintenance functions are not important as the cache works.
I have no idea what your problem is, sorry.

Well finally loaded this thing to give it a whirl.

Very nicely done! Two thumbs up! :)

Any clue when the update is going to be released? I'm going to wait to release it to my members until then.

I moved everything into a dropdown on my main navbar, when the next release comes out is there going to be an option for this as that second navbar just looked awful on my site?Yeah Im going to start work on that option right now.

the second navbar and the postbit are stopping me from installing this atm. i cant wait to see the next release though I hope you are aware that the postbit is user selectable, and you can even choose the default in the AdminCP...

[Tulsa]

Any thoughts on what might cause this?

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 611198 bytes) in /home/*****/public_html/forums/includes/rpg_plugins/global_complete.php(5) : eval()'d code on line 2


It happens when trying to read a thread in the forum, totally unrelated to this hack. As the error has noted I am running php5

[mikeylikesitz]

I hope you are aware that the postbit is user selectable, and you can even choose the default in the AdminCP...


Right, but i only use the regular postbit in my site and you havent built in the rpg info into it yet correct?