vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   RPG Integration Hack (https://vborg.vbsupport.ru/forumdisplay.php?f=102)
-   -   Datastore problem? (https://vborg.vbsupport.ru/showthread.php?t=77834)

AnthonyJR 03-10-2005 03:10 AM
Datastore problem?
 
Well, first it worked, but now it doesnt.

i just inserted the classes through phpmyadmin, but I couldnt see any of them in the Admin CP -> Edit Class, it also gave me an error when I tried to by items saying I need to be of a Generic Class. So I went into the admin CP -> add class; and added the Amazon again. when i refreshed the RPG CP to select it I got the error that I just posted above.

can you help?

Revan 03-10-2005 01:29 PM
You seem to be running v2. Or, you have not removed the code from profile.php.
Because this file is not edited in v3.

AnthonyJR 03-10-2005 06:17 PM
ok thx, that problem is fixed. now, the classes and elements and all the other insert didnt work during the installation, so I did them through PHPMYADMIN. the only problem is with the classes; 1) they dont show up when I hit the Edit Classes in the admin cp 2) after I change all my character info ( I can see the classes in the drop down menu ) and I go to the itemshop, it says I must be a Generic to buy any thing. I dont feel like adding all those classes one by one in the admin cp, how can I fix this?

Revan 03-10-2005 08:26 PM
The first thing that springs to mind is a fresh run of the rpg_install.php
Uninstall (or manually remove any trace of) the hack, then reinstall using the installer.
The installation definetely works now, as it's been verified by members using a table prefix too.

AnthonyJR 03-10-2005 09:54 PM
almost :p

Database error in vBulletin 3.0.7:

PHP Code:
Invalid SQL: 
CREATE TABLE `rpg_items_user` 
(
    `userid` int(10) unsigned NOT NULL default '0',
    `item0` char(250) NOT NULL default 'No Item',
    `points0` int(5) NOT NULL default '0',
    `description0` char(250) NOT NULL default 'No Description Available',
    `icon0` char(250) NOT NULL default '',
    `itid0` int(11) NOT NULL default '0',
    `item1` char(250) NOT NULL default 'No Item',
    `points1` int(5) NOT NULL default '0',
    `description1` char(250) NOT NULL default 'No Description Available',
    `icon1` char(250) NOT NULL default '',
    `itid1` int(11) NOT NULL default '0',
    `item2` char(250) NOT NULL default 'No Item',
    `points2` int(5) NOT NULL default '0',
    `description2` char(250) NOT NULL default 'No Description Available',
    `icon2` char(250) NOT NULL default '',
    `itid2` int(11) NOT NULL default '0',
    `item3` char(250) NOT NULL default 'No Item',
    `points3` int(5) NOT NULL default '0',
    `description3` char(250) NOT NULL default 'No Description Available',
    `icon3` char(250) NOT NULL default '',
    `itid3` int(11) NOT NULL default '0'    
    PRIMARY KEY (`userid`)
) 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 '(`userid`)
) TYPE=MyISAM' at line 24 
in the mysql_schema file you have a space or tab behind one of the lines. fixed that and went through the whole installation with no problems once so ever. but I still get the same error, your install populated all the tables including the class table, but I still cant see any of the classes in the Admin Cp and it still says I need to be a Generic to purchase any items.

Revan 03-11-2005 09:27 AM
You need to download the latest file. That there has already been fixed.
The reason why the thread title says beta 2 is because I am no longer allowed to alter the thread title, it is too old.
So if I were you, I would click Install so that you will recieve a notification once database changes and/or major bugs are fixed.

As for the item saying you have to be generic, that is an error that is also fixed in abovementioned beta update.

AnthonyJR 03-11-2005 10:38 PM
the beta3 one? I believe I did download that one. Unless-- I downloaded your hack multiple times for some reason-- maybe the last time I installed the hack I didnt install the latest one. I'll download again and over write all files, I presume the latest file is in the same thread? I also shouldn't have to update the mysql right?

Revan 03-12-2005 07:26 AM
Well you need to run the rpg_install even if the hack was installed successfully in beta2.
Because beta3 modifies more of the database.

AnthonyJR 03-12-2005 07:20 PM
I just ran through the upgrade. it said i was running 3.0.0 and it was going to make it 3.0.0 Beta 3. There was a problem with the profilefield select so I just skipped that. But when I tried going to my RPG CP the whole page was blank. Everything RPG related is blank.

Revan 03-12-2005 11:00 PM
Of course it was an error with the profilefield select.... *stares*
You now have to manually add the profilefield with the name 'RPG Name' (EXACTLY like that, without the quotes), then uninstall the hack completely, then reinstall completely.
THAT should work.
Everything rpg related is blank because you probably never made it to the completed page, where everything is finalised.

AnthonyJR 03-13-2005 02:32 AM
'RPG Name' was already in my profilefield table.

I uninstalled the hack, no problems. Then when I went to do a fresh install I got this error:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT `profilefieldid` AS `id` FROM `profilefield` WHERE `varname` = 'RPG Name'
mysql error: Unknown column 'varname' in 'where clause'

mysql error number: 1054

...wow I seem to be having a lot of problems with this thing :\ I just hope we can eventually get it to work, alot of my members want this. OOO ++++! I think I just ruined all their clans and ++++ when I uninstalled? Owell

Revan 03-13-2005 09:07 AM
Fixed.
Uploading asap :)

AnthonyJR 03-13-2005 03:28 PM
ok, after all is said and done, i still cant buy items :( it is saying I need to be generic. but before I did the last set of uninstall & install, some members were able to buy items. but ONLY A COUPLE, others have the same problem that I do. i dont know whats going on

argh sigh -_-.. i tried adding an item just for the hell of it. and when i went to go buy it, I COULD!! does this mean that the easiest way to get around my problem is to delete all my items and just add them all in via acp?

Revan 03-13-2005 04:35 PM
You have to update the Item Types of the items....

AnthonyJR 03-13-2005 04:39 PM
I did, first I unchecked all of them and refreshed item shop, all of them disappeared. then I went back and checked all of them again and i still couldnt buy them

Revan 03-13-2005 05:39 PM
Then possibly your EXP is 0. I had to disallow purchasing of items when user's EXP is 0 to fix a bug where 0 EXP would bypass the level check (for some reason).

AnthonyJR 03-14-2005 07:03 PM
Level: 17
HP: 1070/1070

MA: 275/275

PP: 350/350

Limit: 25%

EXP: 14% Total: 10415

Revan 03-14-2005 07:17 PM
Then I would say yes, readding is the way to go.
I must say I cant make heads or tails from this problem, but if that solution works....


All times are GMT. The time now is 03:51 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.01805 seconds
  • Memory Usage 1,767KB
  • 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
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (18)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete