vb.org Archive - RPG Integration Hack

Page 33 of 81

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - RPG Integration Hack (https://vborg.vbsupport.ru/showthread.php?t=108790)

Kingzor

04-15-2006 03:20 PM

New sql error from a forum member.

Code:

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

04-15-2006 07:54 PM

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

04-15-2006 09:39 PM

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

04-15-2006 10:28 PM

If you were getting the error I was, then you need to edit:

Code:

        $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

04-15-2006 11:31 PM

should clan invites be working?

Tyegurl

04-16-2006 02:38 AM

Quote:

Originally Posted by Travis641

If you were getting the error I was, then you need to edit:

Code:

        $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

04-16-2006 09:22 AM

Quote:

Originally Posted by nadanada

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

04-16-2006 12:32 PM

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

04-16-2006 05:47 PM

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	04-16-2006 06:33 PM

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?

All times are GMT. The time now is 07:41 PM.

Page 33 of 81

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01747 seconds Memory Usage 1,753KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: