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)

Revan 02-28-2006 07:28 PM

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

Gizmo5h1t3 02-28-2006 08:05 PM

to help a little, youll find the 3 templates that need re editing are..

MEMBERINFO, POSTBIT LEGACY, AND FORUMRULES.

and as revan says, his codes dont affect this happening.

sorry revan for steppin on toes, but at least thatll stop others askin bout it.

lol

Chief Corn 02-28-2006 08:23 PM

aww sweetness. cool to see the headquarters layout made it in. still debating to upgrade my forum to 3.5.x because my clan needs vbwar but dw hasn't updated it for 3.5.x yet. i have a new 2nd vbulletin license that i'll test this on but wish i had the users to help squash the bugs.

Revan 03-01-2006 08:38 AM

Quote:

Originally Posted by Gizmo5h1t3
to help a little, youll find the 3 templates that need re editing are..

MEMBERINFO, POSTBIT LEGACY, AND FORUMRULES.

and as revan says, his codes dont affect this happening.

sorry revan for steppin on toes, but at least thatll stop others askin bout it.

lol

No prob, thanks for helping answering it :)

Tri@de 03-01-2006 09:03 AM

Revan, when i use quick reply post
in answer i see always rpgstats in postbit (only in my reply) even if i have set the dropdown menu. If i reload the page, the postbit disappear.

Sooner95 03-01-2006 05:20 PM

Hi, thought i had removed this all, but it left this bit behind..

Quote:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###

snip

`photoplogmaxfilesize` = '512000',
`photoplogmaxfilelimit` = '100',
`rpgpermissions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'rpgpermissions' in 'field list'
I get that when trying to update usergroups. The tables/columns are not in my SQL, so where does it get this value from and how do I remove it?

Sooner95 03-01-2006 05:38 PM

nm, debug mode is a beautiful thing.. sorry for the trouble...

Vizionz 03-01-2006 07:07 PM

i dont know if it was noted but in battles. ya should not be able to shop. i was in battle and able to buy potions. that means anyone with money and good amount of hitpoints could just keep buying elixers everytime there low and be unbeatable

Revan 03-02-2006 04:54 AM

Quote:

Originally Posted by Vizionz
i dont know if it was noted but in battles. ya should not be able to shop. i was in battle and able to buy potions. that means anyone with money and good amount of hitpoints could just keep buying elixers everytime there low and be unbeatable

All Admins, Mods and SMods from the default usergroup IDs are listed as GMs. This means theyare able to do stuff like that.

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

Hey - I'm having a couple of problems. First - while installing the hack I could not complete this option.

Quote:

In the RPG Integration Hack - Cash Options settinggroup ( Done)



Make sure the Point Field setting matches that of your Points hack.
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.

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT `userid`, `rpg`, `items`, `inventory`, `uttpoints` AS `points`
FROM `user`
WHERE `userid` = '27';

MySQL Error : Unknown column 'uttpoints' in 'field list'
Error Number : 1054
Date : Thursday, March 2nd 2006 @ 12:01:27 PM
Script : http://www.troll-cave.org/forums/showthread.php?t=535
Referrer : http://www.troll-cave.org/forums/forumdisplay.php?f=3
IP Address : 162.1.17.48
Username : Frapster
Classname : vb_database

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?

ffevo 03-05-2006 04:07 AM

EDIT: Syoki, You need to Delete all the tables that were created in your database, and also what it added.

Got it installed. Good hack, Once you work through all the irritaing Installs.

Sykoi 03-05-2006 07:39 AM

Have a list of tables I need to delete and modify? Or the file used for each step, so I can just comment out the needless steps' bulk.

ffevo 03-05-2006 07:45 AM

well, I had to do it throught PHPmyadmin but you can run queires in your Admin CP.

Open the " Mysqlschema.php" in your Installer/Hacks folder. and look at each of those. thats how I did it. ..

Sykoi 03-05-2006 10:55 AM

There really has to be an easier way; I have no idea what has and hasn't been updated, and I'd really like to keep my previous RPG data.

TamCaVBoy3 03-06-2006 04:45 AM

i don't see the stats in postbit ...

Revan 03-06-2006 08:56 AM

Quote:

Originally Posted by TamCaVBoy3
i don't see the stats in postbit ...

The regular postbit template (not _legacy) does not currently have any RPG data. The template edit is just there to cater to future needs.

Ski-Whiz 03-06-2006 07:16 PM

I think my problem is simple, but I can't figure it out...

I have the posbit (not legacy)...

How does one battle someone, where is their RPG name listed?? I can't find it anywhere.

Since I don't have the legacy posbit, nothing is really shown in my posbit. So how do I find the name of someone to battle?

Thanks!!

Ski-Whiz 03-06-2006 09:00 PM

I did find a bug. Not sure if this was noticed yet.. When using ebux and entering a wager:

"Your opponent does not have enough Gil. The wager is 10 Gil, and your opponent only has 512496.33 Gil. "

Ziki 03-07-2006 06:21 PM

Hey Revan when will be a new update?

Deagle Man 03-08-2006 04:24 AM

Never mind I uninstalled via admincp.

Revan 03-08-2006 08:36 AM

Quote:

Originally Posted by ZIKI-SET
Hey Revan when will be a new update?

Working on the Monster Arena these days, somewhat distracted at times but slowly moving forward. Some time before the end of the week I expect the MA to be ready.

Vizionz 03-08-2006 09:34 AM

very cool good work so far rev

ffevo 03-09-2006 12:29 AM

eh, that Money bug is happening on Cash Also, not Just bux. is ther a fix to that yet? Or is that gunna be in the next release?

Sinistra 03-09-2006 01:37 PM

Any way I can make the RPG navbar a dropdown menu for the main navbar. with the UserCP and all that stuff?

Replicators 03-09-2006 03:06 PM

First go into your plugin manager and disable "RPG Navbar Addon"

You need to edit the templates navbar (found in Navigation/Breadcrumb Templates).

Find:

Code:

<td class="vbmenu_control"><a href="faq.php?$session[sessionurl]" accesskey="5">$vbphrase[faq]</a></td>
Insert this after that:

Code:

<td id="rpg" class="vbmenu_control"><a href="#rpg">RPG</a> <script type="text/javascript"> vbmenu_register("rpg"); </script></td>
Find this:

Code:

<!-- / PAGENAV POPUP -->
</if>

Above add:

Code:

<!-- RPG menu -->
<div class="vbmenu_popup" id="rpg_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">RPG</td></tr>
<tr>
<td class="vbmenu_option"><a href="headquarters.php">Headquarters</a></td></tr>
<tr>
<td class="vbmenu_option"><a href="battle.php">Battle Arena</a></td></tr>
<tr>
<td class="vbmenu_option"><a href="monsterarena.php">Monster Arena</a></td></tr>
<tr>
<td class="vbmenu_option"><a href="itemshop.php">Itemshop</a></td></tr>
<tr>
<td class="vbmenu_option"><a href="heal.php">Healing Center</a></td></tr>
<tr>
<td class="vbmenu_option"><a href="clancp.php">Clan CP</a></td></tr>
<tr>
<td class="vbmenu_option"><a href="lottery.php">Lottery</a></td></tr>
</table>
</div>
<!-- RPG menu -->

This is Zidane007nl's code so i take no credit on it.

bubba1977 03-09-2006 03:51 PM

thanks.. that helped loads.

TosaInu 03-10-2006 01:27 PM

The RPG navbar doesn't show at all on our board. It's there in the plugins and it is activated. Shouldn't there be an edit in template navbar to activate it?

Sykoi 03-11-2006 12:13 AM

Just out of curiosity - is there an easy way to clear old data from 3.0.x RPG? As in, player data (Stored in the users table)

Revan 03-12-2006 09:33 AM

Quote:

Originally Posted by Sykoi
Just out of curiosity - is there an easy way to clear old data from 3.0.x RPG? As in, player data (Stored in the users table)

Not at the moment, no. In a later Beta, I plan to re-introduce the Reset RPG function which will do what you suggest thar.

Ziki 03-12-2006 07:20 PM

And Revan you could make a edit for navbar in a drop down menu instead of that the installer adds another navbar line...


All times are GMT. The time now is 10:13 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.01841 seconds
  • Memory Usage 1,836KB
  • 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
  • (5)bbcode_code_printable
  • (1)bbcode_php_printable
  • (11)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