vb.org Archive

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)

nadanada 04-16-2006 09:28 PM

Quote:

Originally Posted by Revan
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 04-17-2006 10:43 AM

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

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

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

Ziki 04-17-2006 06:22 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?

llskipper 04-17-2006 11:23 PM

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

Code:

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:

Code:

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 04-18-2006 01:35 AM

Quote:

Originally Posted by mak_mak
Whenether I try to insert a bot 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 ;)

Rated 04-18-2006 03:51 AM

Quote:

Originally Posted by 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 04-18-2006 06:04 AM

I quess no one helps me.....

cayote 04-18-2006 07:09 AM

Quote:

Originally Posted by Revan
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 04-18-2006 08:42 AM

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 04-18-2006 01:47 PM

Quote:

Originally Posted by mak_mak
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 :)


All times are GMT. The time now is 06:26 PM.

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

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01803 seconds
  • Memory Usage 1,756KB
  • 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
  • (2)bbcode_code_printable
  • (7)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