vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   RPG Integration Hack - Old Support Thread (https://vborg.vbsupport.ru/showthread.php?t=73868)

SB2002 08-21-2004 08:52 AM

I have a question. I've divided the itemshop into different sections for the different classes, the only thing is, the only weapons people can buy are the generic ones, no matter what class they chose. When they access their classes weapons, it tells them that they must be that class to buy them.

ie i have a pistoleer class, and they should be able to buy the pistols, but whenever they go to that classes shop they are told they must be a pistoleer to purchase them...... any ideas?

Or do I have to just have everything as generic?

Revan 08-21-2004 10:18 AM

Quote:

Originally Posted by winlya
hic,I just testing on localhost.But not work.
some error with me when install
PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLCREATE TABLE `rpg_clan` (
  `
clanidsmallint(5unsigned NOT NULL auto_increment,
  `
titlevarchar(50NOT NULL default '',
  `
passvarchar(50NOT NULL default '',
  `
leadervarchar(50NOT NULL default '',
  `
clanpointsvarchar(5NOT NULL default '',
  `
logovarchar(100NOT NULL default '',
  `
allyvarchar(10NOT NULL default '0',
  `
enemyvarchar(10NOT NULL default '0',
  `
sb_settingschar(1NOT NULL default '0',
  `
maxmemint(3NOT NULL default '5',
  `
col1varchar(5NOT NULL default '0',
  `
col2varchar(5NOT NULL default '0',
  `
col3varchar(5NOT NULL default '0',
  `
col4varchar(5NOT NULL default '0',
  `
sb_col_accessvarchar(5NOT NULL default '0',
  `
cm_col_accessvarchar(5NOT NULL default '0',
  `
ci_col_accessvarchar(5NOT NULL default '0',
  `
rm_col_accessvarchar(5NOT NULL default '0',
  `
clanmidiurlvarchar(100NOT NULL default '',
  
PRIMARY KEY  (`clanid`)
TYPE=MyISAM;

mysql errorYou have an error in your SQL syntax near ';
at line 22

mysql error number
1064

Date
Saturday 21st of August 2004 03:08:46 AM
Script
http://localhost/vB3.0.3/install/battleinstall.php?step=1
Refererhttp://localhost/vB3.0.3/install/menue.htm
Usernameadmin
IP Address
127.0.0.1 


I cant seem to find an error in this installer, just yesterday I installed perfectly on the beta board I use to track down bugs.
At any rate, the new installer has redundant sections removed from it, patches for which will be found in the new version due to be released once all bugs have been pinned.


Quote:

Originally Posted by ogetbilo
With the updated heal.php healing is working now.
But I found 2 more problems.
When I tried to optimize my database tables I had this warning :

PHP Code:

rpg_rpg_alignment      Check      WarningFound row where the auto_increment column has the value 0
rpg_rpg_alignment     Check     Status
OK
rpg_rpg_alignment     Optimize     Status
OK
rpg_rpg_classf     Check     Warning
Found row where the auto_increment column has the value 0
rpg_rpg_classf     Check     Status
OK
rpg_rpg_classf     Optimize     Status
OK
rpg_rpg_classm     Check     Warning
Found row where the auto_increment column has the value 0
rpg_rpg_classm     Check     Status
OK
rpg_rpg_classm     Optimize     Status
OK
rpg_rpg_element     Check     Warning
Found row where the auto_increment column has the value 0
rpg_rpg_element     Check     Status
OK
rpg_rpg_element     Optimize     Status
OK
rpg_rpg_race     Check     Warning
Found row where the auto_increment column has the value 0
rpg_rpg_race     Check     Status
OK
rpg_rpg_race     Optimize     Status
OK
rpg_rpg_type     Check     Warning
Found row where the auto_increment column has the value 0
rpg_rpg_type     Check     Status
OK
rpg_rpg_type     Optimize     Status
OK 

Why do i have a warning like this when I optimize the tables.
Also I dont know why but character names are always same with your location.
I thiink you miss coded something ovet there.Noone can update their names.

2 things for you:
First of all, those warnings appear because the rpg_rpg_type is of course auto_increment (since if you add more than one type you would get SQL errors if it didnt automatically increment by one.)
But the default value, the value that your users have BEFORE they update their stats, are "Unknown" which has an ID of 0.
I might change the numbers to have 1 be the default, but this would NOT work if you already installed the hack.
Dont worry about it ;)

Second, please consult the FAQ_FRE file for solution to your RPG Name problem. :)
I will move that info over to the installer as it seems like everyone gets this problem :)



Quote:

Originally Posted by Starscream
Revan, thanks for the dropdown in the postbit. It is perfect for my forum. All things seem to be running great on my site. I have even heavily modified/adapted the RPG elements to fit my site theme and everything has gone pretty smoothly and is operational.

I am having one minor problem concerning the dropdown. I can't figure out how to make the dropdown in the postbit become the default view. I like that you made it so you can choose between having the dropdown or not, but I wish the dropdown would be the default view. It's probably a simple change, but I can't see it. Any help would be very appreciated.

*Clicks Install*

You can make the dropdown be the default view by running these 2 queries:
[SQL]ALTER TABLE `user` DROP `rpgstats`;
ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '0';[/SQL]
0 is the dropdown value and 1 is the normal postbit value :)
(Just remember to run these seperately in acp, and in quick succession to avoid SQL errors if an user tries to update ;) )
Thanks for clicking install btw :)


Quote:

Originally Posted by SB2002
I have a question. I've divided the itemshop into different sections for the different classes, the only thing is, the only weapons people can buy are the generic ones, no matter what class they chose. When they access their classes weapons, it tells them that they must be that class to buy them.

ie i have a pistoleer class, and they should be able to buy the pistols, but whenever they go to that classes shop they are told they must be a pistoleer to purchase them...... any ideas?

Or do I have to just have everything as generic?

I believe you have to update the Classes as well. Currently all your classes are (probs) set to Generic type, and so they can only get Generic items ;)
I have not done extensive testing on the Battle Types yet, but it will come in time ;)



Thats about everything I guess :)
The Service Pack 1 that will update this hack to v2.5 build1 is in the works, with new bugs being squashed every day :)
I cannot tell an ETA yet, but heres the remaining sections to test:
* Itemshop
* User's Battle Types as discussed in the above quote
* Battle
* Healing

Finished sections:
* Entire ACP
* Entire ClanCP
* RPG CP

Additional work:
* Templates

:)

SB2002 08-21-2004 10:36 AM

yeah, that was one of the first things i did (altering the classes etc into specific groups) and that is where the problem began, as the itemshop shows the classes, but when you clik them it doesnt actually let you buy the weapons for that class. If needs be I will drop in a test account, give it an rpg class and let you see what i mean.

deathemperor 08-21-2004 12:29 PM

Quote:

Originally Posted by winlya
wow..cool hack..
I am waiting this hack a long time.
But I look this hack same RPG Inferno V1...

believe it or not, RPG Inferno is based on Bitsys' RPG hack and another old IB hack that I've used both of them. Bitsys' RPG has been here months (even more than 1 year) before ZT made RPG Inferno and honestly one of the reason drove me to use vb was the RPG hack.

@SB2002, there's no problem with the Itemshop, I've tested and I can buy any items I want while my class is generic and that item is for generic class.

But well the itemshop is messy, Revan. I asked you to let users have many items in their inventories, it meant: you can buy 10 swords in the weapon shop, 5 armors in the armor shop, 4 accessories and 13 potions in different kind from the Potions Shop, 7 spells from the spell shop but can only equip 1 weapon/1 armor/2 accessories/4 potions/3 spells at a time, and the total items you can buy is 30.

well that way everything would be very easy and comfortable for users. We don't need something like: If you want to let user has 2 weapon, create 2 weapon shop hence if I wish to let them own 10 swords I will have to forget everything to sit there and create items for the shops. But actually with this items system, If I create 10 weapon shops it means everyone will be able to have 10 weapons in battle.

my idea sounds troublesome huh ? it's ok, it's just MHO

Revan 08-21-2004 01:28 PM

death; yes I understand what you mean but it is not possible to let an user equip more items than theres categories.
At least not with the current way of storing items, an Im not sure its smart to go about redesigning the entire item storage database :p


Quote:

Originally Posted by SB2002
yeah, that was one of the first things i did (altering the classes etc into specific groups) and that is where the problem began, as the itemshop shows the classes, but when you clik them it doesnt actually let you buy the weapons for that class. If needs be I will drop in a test account, give it an rpg class and let you see what i mean.

EDIT: I tried this on my localhost also, and I see what you mean now. Ill get right on fixing it.
EDIT2: I have fixed that bug along with some other small graphical bugs, expect a fully working itemshop in v2.5! :D ;)

SB2002 08-21-2004 02:55 PM

splendid. Much appriciated. What sort of eta do you have on 2.5 as I have a board full of members wanting to buy things, lol

Revan 08-21-2004 03:04 PM

I dont really know, I have to finish writing the changelog for the itemshop.php as well as test every aspect of the battles.
Plus I hear DeMiNe0 got some errors for me in the showthread and showpost files.... :p

Id rather not rush the new update, just to be sure I got all the errors.
Such as your error, at first I had this long step by step update gotten as to what I did to get it working (cos it LOOKED like it worked), but then after about 15 mins I saw "wtf this is bs it doesnt work *runs to edit post before he sees it and thinks Im dumb*" ;)
Plus I think its dumb to release quickfixes, because this would just confuse users that downloads the new zip and sees the changelog and goes "hey I cant find this it tells me to find in the changelog!" :p

Im working thoroughly fast ;)

SB2002 08-21-2004 03:38 PM

nah thats cool dude, no rush on it, i'll just throw a couple more arcade games at them to keep the masses happy, lol.

Rahzel_hx 08-21-2004 06:59 PM

i'm not able to reset the rpg stats it goes to a blank page

When i try to start the battle accepting it , it says invaild password or battle

i also get this error when i try to cancle a battle
PHP Code:

Database error in vBulletin 3.0.3:

Invalid SQLDELETE FROM battle WHERE battlenumber='1'
mysql errorTable 'spiritno_forum.battle' doesn't exist

mysql error number: 1146

Date: Saturday 21st of August 2004 03:00:45 PM
Script: http://--------/forum/battlefight.php?action=cancelbattle
Referer: http://--------forum/battlefight.php?action=enterbattle&battlenumber=1
Username: ----------
IP Address: ---------- 

Edit wish i could fix this my self but umm
PHP Code:

Parse errorparse errorunexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1318 

i get this when i goto look at users profiles

Pixelgrounds 08-21-2004 07:39 PM

have al lthe bug fixes iv read in this thread and all the little mods been added to the main page zip file yet?


All times are GMT. The time now is 08:28 AM.

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.01680 seconds
  • Memory Usage 1,815KB
  • 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
  • (4)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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