vb.org Archive
Page 35 of 81 « First 253334 35 363745 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)

vbreal 04-18-2006 02:06 PM
PHP Code:
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 04-18-2006 04:25 PM
Quote:
Originally Posted by Revan
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 04-18-2006 04:29 PM
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.

Quote:
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 04-18-2006 06:42 PM
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 04-18-2006 11:26 PM
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 04-19-2006 04:39 AM
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 04-19-2006 10:08 AM
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 :)

Rated 04-19-2006 10:37 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

:(
Can anyone help me out please?

Revan 04-19-2006 02:09 PM
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 04-19-2006 03:35 PM
this is probably a stupid question, but do PP/limit break/anger do anything yet?


All times are GMT. The time now is 11:51 AM.
Page 35 of 81 « First 253334 35 363745 Last »
Show 40 post(s) from this thread on one page

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.01786 seconds
  • Memory Usage 1,758KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php_printable
  • (3)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