vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   RPG Integration Hack (https://vborg.vbsupport.ru/showthread.php?t=108790)

DS MrSinister 03-02-2006 06:09 PM

Quote:

Originally Posted by Major Miner II
Hey - I'm having a couple of problems. First - while installing the hack I could not complete this option.



Second - I can't find the RPG Admin area - lol. Where do I find that?

Third - after installing this I get the following error on ALL old messages. Not new ones.


you have to change uttpoints to ucash or ebux on which point system you are running..

Admincp

RPG Navigation --> RPG Integration Hack Menu --> RPG Options --> Itemshop Options

or

vBulletin Options --> RPG Integration Hack - Cash Options

Major Miner II 03-02-2006 06:21 PM

great! fixed that - and apparently I have a permissions issue keeping me from seeing the RPG stuff.

Major Miner II 03-02-2006 06:27 PM

I'm all good! woohoo! thanks to all responsible for the hack and thanks for those who helped me.

bubba1977 03-02-2006 07:42 PM

Quote:

Originally Posted by Revan
Well this aint the eBux thread is it ;)
My RPG didn't add that code and hence I can't give support for it.


thanks... i slipped up when updateing ebux / eshop.

blablablabla 03-03-2006 10:40 PM

does it work on vbulletin 3.5.3?

Replicators 03-03-2006 10:55 PM

It works with 3.5.4 so yea, i cannot wait for the next version, i wanna kill monster's.

ffevo 03-04-2006 03:52 AM

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE `.sqlrpg_alignments`
(
        `alignmentid` int(10) unsigned NOT NULL auto_increment,
        `alignmentname` varchar(50) NOT NULL DEFAULT '',
        `alignmentleader` varchar(50) NOT NULL DEFAULT '',
        PRIMARY KEY (`alignmentid`)
) TYPE=InnoDB;

MySQL Error  : Incorrect table name '.sqlrpg_alignments'
Error Number : 1103
Date        : Friday, March 3rd 2006 @ 09:46:13 PM
Script      : http://www.squaresyndicate.com/forum...ller/index.php
Referrer    : http://www.squaresyndicate.com/forum...ller/index.php
IP Address  : 209.165.35.111
Username    : Loathor__Healer
Classname    : vb_database

What the hell. Okay. I get this error while trying to create the tables. right?

PHP Code:

$this->query("
            UPDATE `" 
TABLE_PREFIX "setting` SET 

SEE THAT ` before the " <-- if I remove that. it works Pefect.

and then.. Ill install it. and then.. when I want to get to ANY ++++ing Page. I get the same Error. wtf??

Revan 03-04-2006 10:22 AM

Your table prefix does not comply with MySQL standards. That's what causes the error, and I used the ` everywhere just because it is MySQL standard.
Please change your table prefix using tableprefix.php from the original vBulletin installation.

Sykoi 03-04-2006 04:29 PM

I'm having some problems with the install...
During the first time, I had gotten to the 16th or 17th step but had forgotten to change my old installion's (From 3.0.x) cash field name from uttpoints (Doesn't exist) to ebux (What I use now), and it spit out the following error:
Quote:

Invalid SQL:

SELECT
user.`userid`,
user.`username`,
user.`clan`,
user.`rpgclass`,
user.`rpgrace`,
user.`alignment`,
user.`rpgtype`,
user.`rpggender`,
user.`hp`,
user.`maxhp`,
user.`ma`,
user.`maxma`,
user.`pp`,
user.`maxpp`,
user.`ap`,
user.`element`,
user.`inbattle`,
user.`xp`,
user.`chalable`,
user.`rpgstats`,
user.`inmonsterbattle`,
user.`uttpoints` AS `points`,
rpg_clan.leader_old,
rpg_clan.clanid,
rpg_battle_stats.battles,
rpg_battle_stats.wins,
rpg_battle_stats.losses,
rpg_battle_stats.draws,
rpg_battle_stats.retreats,
rpg_items_user.*,
userfield.rpgname AS rpgname
FROM vb3_user AS user
LEFT JOIN vb3_rpg_clan AS rpg_clan ON(rpg_clan.clanid = user.clan)
LEFT JOIN vb3_rpg_items_user AS rpg_items_user ON(rpg_items_user.userid = user.userid)
LEFT JOIN vb3_rpg_battle_stats AS rpg_battle_stats ON(rpg_battle_stats.userid = user.userid)
LEFT JOIN vb3_userfield AS userfield ON(userfield.userid = user.userid)
WHERE user.`userid` >= 1
AND user.`userid` < 21;

MySQL Error : Unknown column 'user.uttpoints' in 'field list'
Now I've obviously fixed this, but ran into another problem... I can't get past step 3 because I've already went through these steps.
So, how do I manually bypass the steps I've done?

ffevo 03-05-2006 04:06 AM

Im wondering. Thanks for telling me to change that.

Im using The Itemshop Know. For Points. Is their a way I can intergrate this RPG with that hack?


All times are GMT. The time now is 07:35 PM.

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