vb.org Archive
Page 4 of 22 « First 23 4 5614 Last »
Show 40 post(s) from this thread on one page

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

:)

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 SQL: DELETE FROM battle WHERE battlenumber='1'
mysql error: Table '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 error: parse error, unexpected 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?

orca 08-21-2004 08:01 PM
Hmm, I installed this hack but funny enough some images won't show although in the correct directories...This is especially the case for the itemshop directory. hat.gif shows for example but racket.gif not although it exists in that directory.

Revan 08-21-2004 08:46 PM
Quote:
Originally Posted by orca
Hmm, I installed this hack but funny enough some images won't show although in the correct directories...This is especially the case for the itemshop directory. hat.gif shows for example but racket.gif not although it exists in that directory.
This I never encountered. All my test forums show the image correctly.... You sure both images are in the same dir?

Quote:
Originally Posted by Rahzel_hx
I'm lv2 in the rpg and i have like 56 hp, 8k ma and 20k pp ? >_< and 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 SQL: DELETE FROM battle WHERE battlenumber='1'
mysql error: Table '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 i'ma vb no0b umm
PHP Code:
Parse error: parse error, unexpected 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
First of all, your massive amounts of MA and PP are because the MA and PP modifiers are way off the scale.
Enter your AdminCP, and select Edit Options under Battle.
There set new values for MA and PP, recommended values are 0.003 :)

For your battle accept error, this has happened before but was reported to have gone away. But as I see its back, it will be pinned down and fixed for v2.5 ;)

For your Cancel Battle error, that is a small fix which I am just about to note down in the changelog. To fix it quickly, enter battlefight.php and search for:
[sql]DELETE FROM ".TABLE_PREFIX."battle[/sql]
change to
[sql]DELETE FROM ".TABLE_PREFIX."rpg_battle[/sql]

And as for your functions_online stuff:
find
PHP Code:
    case 'rpgcp':
        $userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>"; 
change to
PHP Code:
    case 'rpgcp':
        $userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>";
        break; 
Quote:
Originally Posted by Pixelgrounds
have al lthe bug fixes iv read in this thread and all the little mods been added to the main page zip file yet?
Bug fixes: Most
Addons: None. The addons are in a special post linked to from the main page.


Status on the v2.5:
I am just going through the files looking for missing ".TABLE_PREFIX."es, with much help from DeMiNe0 :)
After this I will start picking apart the battle part of the hack on the live forum.
Then, Im gonna do a fresh reinstall (cos I made tweaks to the installer), and go through it all again.
After THAT, then all bugs should be gone and I can put out the new version :)

And dont worry about having to redo/reupload all the files if you make modifications to the files, all the changes are documented in a changelog file. ;)


EDIT: I just managed to fix all bugs in the heal.php file, healing now works 100 % :D

Rahzel_hx 08-21-2004 11:02 PM
Quote:
Originally Posted by Revan

For your Cancel Battle error, that is a small fix which I am just about to note down in the changelog. To fix it quickly, enter battlefight.php and search for:
[sql]DELETE FROM ".TABLE_PREFIX."battle[/sql]
change to
[sql]DELETE FROM ".TABLE_PREFIX."rpg_battle[/sql]

And as for your functions_online stuff:
find
PHP Code:
    case 'rpgcp':
        $userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>"; 
change to
PHP Code:
    case 'rpgcp':
        $userinfo['action'] = "Viewing <a href='rpgcp.php'>RPG CP</a>";
        break; 
PHP Code:
Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1319 
after that change it gaive me another new error -_- also
[sql]DELETE FROM ".TABLE_PREFIX."battle[/sql]
change to
[sql]DELETE FROM ".TABLE_PREFIX."rpg_battle[/sql]
i don't have a [sql]DELETE FROM ".TABLE_PREFIX."battle[/sql]
it is already [sql]DELETE FROM ".TABLE_PREFIX."rpg_battle[/sql]

Thanks for your help ^__^ i know you will do ur best even though it isn't paid XP

orca 08-22-2004 07:06 AM
Yes, they are in the same dir. Also, if I right-click on the cross and check the path, it's correct.
Would it be possible that mod_rewrite does sth wrong there?

Revan 08-22-2004 11:22 AM
Quote:
Originally Posted by orca
Yes, they are in the same dir. Also, if I right-click on the cross and check the path, it's correct.
Would it be possible that mod_rewrite does sth wrong there?
Mod rewrite sth what? :ermm:
All I know is that it works correctly here, and every dam other test/live board Ive ever seen... :p


Quote:
Originally Posted by Rahzel_hx
PHP Code:
Parse error: parse error, unexpected T_CASE in /home/spiritno/public_html/forum/includes/functions_online.php on line 1319 
after that change it gaive me another new error -_- also
[sql]DELETE FROM ".TABLE_PREFIX."battle[/sql]
change to
[sql]DELETE FROM ".TABLE_PREFIX."rpg_battle[/sql]
i don't have a [sql]DELETE FROM ".TABLE_PREFIX."battle[/sql]
it is already [sql]DELETE FROM ".TABLE_PREFIX."rpg_battle[/sql]

Thanks for your help ^__^ i know you will do ur best even though it isn't paid XP
Then whats the new error, if that was it then its not cause of this, because I checked all the rpg edits for functions_online and that rpgcp.php was the only one that lacked a break;
Can you post the 2-3 lines surrounding your line 1319 in that file then?

orca 08-22-2004 02:02 PM
Well, I only know that the weapons, asc.gif, desc.gif, src.gif and no item.gif give a red cross. All other gifs work. Funny thing is that if I enter the path to those images directly, it leads me to a crappy main page of my site whereas the working images show up. That's why I asked about mod_rewrite as I use it for the main site. See the following examples:

http://forum.arachid.net/images/itemshop/racket.gif (doesn't show in list)

http://forum.arachid.net/images/itemshop/hat.gif (shows in list)

The files are chmod 777 just to be sure it's no permission problem. The mod_rewrite is actually for www.arachid.net and not for forum.arachid.net.

Revan 08-22-2004 03:02 PM
I can see both of them fine, just like the normal images.
This problem doesnt seem like it can be fixed on my side, sorry :(


On a brighter note, Ive sent the RC1 of the changelog for v2.5 over to the team's testers (yeah didnt that sound fancy :p ), and it addresses 14 errors, redundant coding, adds the features of Admin Only-Classes settable in the ACP (this is actually just a touchup of the old code, previously the Admin classes was selectable for users, now they are hidden), and the RPG CP now also displays your current Battle Type (like Generic etc)

It will most likely be made public in 1-2 days :)

Pixelgrounds 08-22-2004 04:14 PM
I think im going to wait till this is more stable before i install it. Last thing i want is my boss getting mad at me for the site going down or any errors.

NyCwill 08-22-2004 10:53 PM
Quote:
Originally Posted by Revan
For the users with the "Invalid battle or password" errors, the fix is here. :)
where is the fix?? :surprised:

House_of_Crazed 08-23-2004 01:07 AM
Suggestion -

Add a script that would reset everyone's stats based on their postcount. :D

I tried doing this and accidently reset'ed everyone's characters. *laughs* Good thing it was on a test site, *laughs*

HoC

Rahzel_hx 08-23-2004 02:54 AM
lol nice i don't know what is wrong with functions_online.php i think i just have to site down and re trace my steps ^__^

When the new version comes out will you have a upgrade.txt so we don't have to clean install again

Revan 08-23-2004 07:52 AM
Quote:
Originally Posted by NyCwill
where is the fix?? :surprised:
If its not there, then I took it down because I was doin fixed on it.
Dont worry, the new upgrade's battles has been tested and works 100 % ;)


Quote:
Originally Posted by House_of_Crazed
Suggestion -

Add a script that would reset everyone's stats based on their postcount. :D

I tried doing this and accidently reset'ed everyone's characters. *laughs* Good thing it was on a test site, *laughs*

HoC
This is already in there.
Please enter the 'Reset' script in your AdminCP and read each description thoroughly to find your reset preference ;)
(I cant tell you exactly since Im away from my comp atm)


Quote:
Originally Posted by Rahzel_hx
lol nice i don't know what is wrong with functions_online.php i think i just have to site down and re trace my steps ^__^

When the new version comes out will you have a upgrade.txt so we don't have to clean install again
There will be a changelog text file containing the fixes, both for the rpg files and the file edits you did ;)

NyCwill 08-23-2004 09:24 AM
when will the upgrade be release?

fade 08-23-2004 01:43 PM
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 
Getting the exact same error message when trying to install..

Revan 08-23-2004 02:17 PM
Quote:
Originally Posted by fade
Getting the exact same error message when trying to install..
Then how come I could paste that very query into a test mySQL dbase and get it to work 100 %?:p

Ive thoroughly tested the new installer also, so it doesnt have any problems.



About the release time, Ill post back once I can breathe some life into the tester ;)

fade 08-24-2004 12:26 AM
Quote:
Originally Posted by Revan
Then how come I could paste that very query into a test mySQL dbase and get it to work 100 %?:p
are you able to suggest anything that *might* be causing it?

Revan 08-24-2004 11:42 AM
Nah this has me completely stumped.
I tried the install and reinstall like 5 times and theres no errors.


Anyways I havnt heard anything from testers about errors, and all works fine in all tests, so what the hell, heres the new version :)

Virulent1 08-24-2004 05:18 PM
what if i just installed the lottery and not the rpg thing? will the lottery work correctly with Ushop?

xiang 08-24-2004 05:57 PM
Hi, Revan
I meet the same problem when have a new install. pls check yours pm to find my website.

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',
  `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',
  `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 20

mysql error number: 1064

Revan 08-24-2004 06:40 PM
just try removing the ; after MyISAM then... as thats the character in the error :ermm:

Virulent1 08-24-2004 10:24 PM
revan, if i were to install the lottery part ONLY and not the RPG stuff will it work properly with Ushop?

Valr the Slain 08-25-2004 12:02 AM
Hello,
I recently tried to install this hack and came up with this error:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_items_options` (
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '0',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
) TYPE=MyISAM;
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 ') TYPE=MyISAM' at line 11

mysql error number: 1064
Any possible ways to fix this?

Thank you.

Revan 08-25-2004 05:22 AM
Quote:
Originally Posted by Valr the Slain
Hello,
I recently tried to install this hack and came up with this error:

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: CREATE TABLE `rpg_items_options` (
`refund` varchar(5) NOT NULL default '0',
`stockdate` varchar(250) NOT NULL default '0',
`onofforder` smallint(6) NOT NULL default '0',
`sold` int(11) NOT NULL default '0',
`profit` int(11) NOT NULL default '0',
`minstock` int(11) NOT NULL default '0',
`maxstock` int(11) NOT NULL default '0',
`stockreset` varchar(250) NOT NULL default '0',
`hidelevel` tinyint(4) NOT NULL default '0',
) TYPE=MyISAM;
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 ') TYPE=MyISAM' at line 11

mysql error number: 1064
Any possible ways to fix this?

Thank you.
Ugh... find this:
[sql]
`hidelevel` tinyint(4) NOT NULL default '0',[/sql]
change to this:
[sql]`hidelevel` tinyint(4) NOT NULL default '0'[/sql]


Quote:
Originally Posted by Virulent1
revan, if i were to install the lottery part ONLY and not the RPG stuff will it work properly with Ushop?
No clue.
Its worth a test, but I cannot provide support should anything go wrong ;)

HiDeo 08-25-2004 08:48 AM
Nice hack, thanks

DaPro 08-25-2004 12:57 PM
1 Attachment(s)
Ok guys, I have fixed my install problems that most of you were having, so if you would like help, please use my battleinstall.php file and preform these few simple tasks.

*Note: I am not an experienced PHP coder, I am just trying to help myself and others, I will not offer support for this fix, so don't PM me! LOL

Now go into your PHPMYADMIN and go into your users table. Now DROP the following rows before you try to reinstall with the fixed install:

DROP rpgclass
DROP rpgrace
DROP alignment
DROP rpgtype
DROP rpggender
DROP hp
DROP maxhp
DROP ma
DROP maxma
DROP pp
DROP maxpp
DROP ap
DROP element
DROP inbattle
DROP clan
DROP xp

Now after that is all done, we need to clean out all of those old RPG tables added by any previous install attempt. So loud up the installer/installer.php files and click delete on the side menu. Go into your PHPMYADMIN and make sure they were all deleted. If you get an error when you click, don't worry, I got that too :P

Now you are safe to upload the battleinstall.php and run the install. If it says Success or Install OK, then you are GOOD2GO. If you have problems, post here, no PM's!

Revan 08-25-2004 02:03 PM
Quote:
Originally Posted by DaPro
Ok guys, I have fixed my install problems that most of you were having, so if you would like help, please use my battleinstall.php file and preform these few simple tasks.

*Note: I am not an experienced PHP coder, I am just trying to help myself and others, I will not offer support for this fix, so don't PM me! LOL

Now go into your PHPMYADMIN and go into your users table. Now DROP the following rows before you try to reinstall with the fixed install:

DROP rpgclass
DROP rpgrace
DROP alignment
DROP rpgtype
DROP rpggender
DROP hp
DROP maxhp
DROP ma
DROP maxma
DROP pp
DROP maxpp
DROP ap
DROP element
DROP inbattle
DROP clan
DROP xp

Now after that is all done, we need to clean out all of those old RPG tables added by any previous install attempt. So loud up the installer/installer.php files and click delete on the side menu. Go into your PHPMYADMIN and make sure they were all deleted. If you get an error when you click, don't worry, I got that too :P

Now you are safe to upload the battleinstall.php and run the install. If it says Success or Install OK, then you are GOOD2GO. If you have problems, post here, no PM's!
Thank you very much, if this really does help the other users then you are getting a place in the first post in the thanks section :D
I'll wait to see if people report error fixed before I update the first zip ;)

DaPro 08-25-2004 02:55 PM
Thanks, I just try to help, I will also be re-doing all the RPG templates to make them look more vB Intergrated than off with the style. I should have it done sometime by next week I hope, because there are alot of templates and doing them all today is out of the question :P LOL.

MayhemSI 08-25-2004 03:02 PM
Finally! an installer that works! I had given up on this hack after about 30 minutes of messing with the script.. I'm lazy.. what can I say.. hehe

DaPro 08-25-2004 03:56 PM
Glad to have helped! Well, hopefully it will serve others well, it did take me alot of messing around with the whole shabang of this hack to actually get the damn thing running right. LOL, so the installer unfortunately is only half the battle. No offense to the makers of this port, but there should have been a little wait until you fixed most of the kinks, more beta testing and what not. I would ask for more reorganizing in the readme.

Hopefully my new templates will make it look nicer as well. :)

Revan 08-25-2004 04:01 PM
Um just FYI the v2.5 Gold version fixes all bugs, apart from apparently this installer.
And the readme IS as organised as it gets... what version did you dload anyways? :ermm:

Aight if the installer works Ill update the zip and send out an update....


All times are GMT. The time now is 08:06 AM.
Page 4 of 22 « First 23 4 5614 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.02910 seconds
  • Memory Usage 1,978KB
  • 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
  • (13)bbcode_php_printable
  • (22)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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