vb.org Archive
Page 1 of 2 1 2
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)
-   -   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.


All times are GMT. The time now is 02:58 AM.
Page 1 of 2 1 2
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.01125 seconds
  • Memory Usage 1,754KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (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