vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   RPG Integration Hack /w Battle (BETA) (https://vborg.vbsupport.ru/showthread.php?t=46417)

Xyphen 01-10-2003 02:09 AM

Bitsys, I just upgraded to the new version v.59b and now when I visit someones Profile "GetInfo" it gives this error..

Code:

Database error in vBulletin 2.2.8:

Invalid SQL:
        SELECT
        user.userid,user.rpgclass,user.element,user.rpgrace,user.alignment,user.rpggender,user.posts,user.maxhp,user.maxma,user.maxpp,user.inbattle,
        user.ma AS uma,user.hp AS uhp,user.pp AS upp,user.ap AS uap,
        items_options.pointfield,battle_options.namefield, userfield.*,
        battle_options.usepostcount,battle_options.exprate,battle_options.levelfield,battle_options.privacy AS battleprivacy,
        items_user.*,battle_stats.*,rpg_race.name AS rpgracename,rpg_race.alignment AS rpgalignmentname,rpg_classf.name AS fclassname,
        rpg_classf.folder AS fclassfolder,rpg_classm.name AS mclassname,rpg_classm.folder AS mclassfolder,rpg_element.name AS elename
        FROM user, userfield, items_user, battle_stats, rpg_classf, rpg_classm, rpg_element, rpg_race, battle_options, items_options
        WHERE
        user.userid=10
        AND userfield.userid=user.userid
        AND items_user.userid=user.userid
        AND battle_stats.userid=user.userid
        AND rpg_classf.id=user.rpgclass
        AND rpg_classm.id=user.rpgclass
        AND rpg_element.elementid=user.element
        AND rpg_race.raceid=user.rpgrace
        AND rpg_race.alignmentid=user.alignment
       
mysql error: Unknown column 'battle_options.usepostcount' in 'field list'

mysql error number: 1054

Date: Friday 10th of January 2003 05:03:40 AM
Script: http://www.ooforums.net/forums/forum...info&userid=10
Referer: http://ooforums.net/forums/index.php?s=


Bitsys 01-10-2003 02:22 AM

Travis641:
Re-download the .zip file and upload rpg.php to your server. That should fix it.

Davey:
Can you post the errors you are getting?

AViO 07:
Remove the old member profile add-on (it was one file edit), and use the version I am attaching here. Let me know if it doesn't work or if you are still having problems with the new version.

Travis641 01-10-2003 02:35 AM

Yay, thanks alot. Everything works perfect now! =)

mr e 01-10-2003 02:46 AM

well looks like most of the gimongous erros are gone

Mijae 01-10-2003 03:49 AM

My users are level 20+ withing a day (will reset again) and after updating their stats they still show up as 0 in rpg.php

Mijae 01-10-2003 04:00 AM

Also, does anyone have a good formula to calculate the Buff?

mr e 01-10-2003 04:16 AM

https://vborg.vbsupport.ru/showthrea...122#post340122

Quote:

Originally posted by v0id
My users are level 20+ withing a day (will reset again) and after updating their stats they still show up as 0 in rpg.php

mr e 01-10-2003 04:18 AM

do you mean weapons/armor etc?

Quote:

Originally posted by v0id
Also, does anyone have a good formula to calculate the Buff?

Cyclonus888 01-10-2003 04:41 AM

sorry but Im completely new to installing hacks....how do I make a query??

Bitsys 01-10-2003 10:33 AM

Quote:

Originally posted by v0id
My users are level 20+ withing a day (will reset again) and after updating their stats they still show up as 0 in rpg.php
You can adjust the amount of experience it takes to gain a level in the Battle Options menu. Try changing the Power Level Modifier to 1. It will automatically apply to everyone, without people having to update their stats. You can play around with this to get the desired result.

To fix the 0 in rpg.php, redownload the .zip file and re-upload rpg.php to your server.


Quote:

Originally posted by v0id
Also, does anyone have a good formula to calculate the Buff?
I think armor should be less buff than weapons of the same price range, but should also be a little more expensive.


Quote:

Originally posted by Cyclonus888
sorry but Im completely new to installing hacks....how do I make a query??
If you have phpmyadmin, then try reading http://www.vbulletin.com/forum/showt...threadid=18558 Also, if you haven't already read it, I suggest you read https://vborg.vbsupport.ru/showthrea...threadid=39142

However, for a clean install, you shouldn't have to run any queries unless the install script fails to execute some of them.


All times are GMT. The time now is 05:19 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.03019 seconds
  • Memory Usage 1,745KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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