New sql error from a forum member.

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.

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

If you were getting the error I was, then you need to edit: `cashdrop` needs a comma after it in /admincp/rpg_monsters.php which allowed me to make ibots.

should clan invites be working?

tyvm that worked :)

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.

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

:(

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

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?

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.

Whenether I try to insert a bot I get this error:
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:

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?

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

Then I get this error:

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

https://vborg.vbsupport.ru/showpost....&postcount=324

check that out and see if it helps ;)

no one know whats wrong? :(

I quess no one helps me.....

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.

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 :)

i have been getting this error all day



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

thanks in advance

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

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.


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,

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

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.

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!

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:

1. Headquarters will get a major revamp, it will have different sections, which are detailed below.
2. 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.
3. "Your Stats" in the Battle Arena is now incorporated into the new Statistics page in the Headquarters.
4. Abovementioned Statistics page will also feature other useless information if I fancy adding it :p
5. 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.
6. Edit Settings is now a category for managing the RPG options.
7. Reset RPG is now an own link in the Headquarters.

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

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

Can anyone help me out please?

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.

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

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???

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

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.

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 :)

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

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

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

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

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

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

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?