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 SQL: CREATE TABLE `rpg_clan` (
`clanid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`pass` varchar(50) NOT NULL default '',
`leader` varchar(50) NOT NULL default '',
`clanpoints` varchar(5) NOT NULL default '',
`logo` varchar(100) NOT NULL default '',
`ally` varchar(10) NOT NULL default '0',
`enemy` varchar(10) NOT NULL default '0',
`sb_settings` char(1) NOT NULL default '0',
`maxmem` int(3) NOT NULL default '5',
`col1` varchar(5) NOT NULL default '0',
`col2` varchar(5) NOT NULL default '0',
`col3` varchar(5) NOT NULL default '0',
`col4` varchar(5) NOT NULL default '0',
`sb_col_access` varchar(5) NOT NULL default '0',
`cm_col_access` varchar(5) NOT NULL default '0',
`ci_col_access` varchar(5) NOT NULL default '0',
`rm_col_access` varchar(5) NOT NULL default '0',
`clanmidiurl` varchar(100) NOT NULL default '',
PRIMARY KEY (`clanid`)
) TYPE=MyISAM;
mysql error: You 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
Referer: http://localhost/vB3.0.3/install/menue.htm
Username: admin
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 Warning: Found 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
More Information