vb.org Archive
Page 22 of 87 « First 122021 22 23243272 Last »
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)
-   -   RPG Integration Hack - Old Support Thread (https://vborg.vbsupport.ru/showthread.php?t=73868)

LeonHartHVA 08-28-2004 06:21 AM
PHP Code:
Invalid SQL: 
        SELECT
            user.userid,
            user.username,
            user.rpgclass,
            user.element,
            user.rpgrace,
            user.rpgtype AS rpgtype,
            user.alignment,
            user.rpggender,
            user.posts,
            user.maxhp,
            user.maxma,
            user.maxpp,
            user.inbattle,
            user.xp,
            user.ma AS uma,
            user.hp AS uhp,
            user.pp AS upp,
            user.ap AS uap,
            user.uttpoints AS money,
            rpg_battle_options.namefield AS namefield, 
            userfield.*,
            rpg_battle_options.exprate,
            rpg_battle_options.privacy AS battleprivacy,
            rpg_items_user.*,
            rpg_battle_stats.*,
            rpg_rpg_race.name AS rpgracename,
            rpg_rpg_race.alignment AS rpgalignmentname,
            rpg_rpg_classf.name AS fclassname,
            rpg_rpg_classf.folder AS fclassfolder,
            rpg_rpg_classm.name AS mclassname,
            rpg_rpg_classm.folder AS mclassfolder,
            rpg_rpg_element.name AS elename
        FROM rpg_battle_options
            LEFT JOIN user ON user.userid=1
            LEFT JOIN userfield ON userfield.userid=user.userid   
            LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
            LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
            LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
            LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
            LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
            LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment
    
mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054 
help me plz

Revan 08-28-2004 09:33 AM
Quote:
Originally Posted by CHIngs
Code:
Invalid SQL: SELECT * FROM rpg_datastore
mysql error: Table 'charmed_b12nqOyv.rpg_datastore' doesn't exist

mysql error number: 1146
what should i DO?
Please consult the SP1 file located in post #40 in this thread, linked to from the first page :)


Quote:
Originally Posted by LeonHartHVA
PHP Code:
Invalid SQL: 
        SELECT
            user.userid,
            user.username,
            user.rpgclass,
            user.element,
            user.rpgrace,
            user.rpgtype AS rpgtype,
            user.alignment,
            user.rpggender,
            user.posts,
            user.maxhp,
            user.maxma,
            user.maxpp,
            user.inbattle,
            user.xp,
            user.ma AS uma,
            user.hp AS uhp,
            user.pp AS upp,
            user.ap AS uap,
            user.uttpoints AS money,
            rpg_battle_options.namefield AS namefield, 
            userfield.*,
            rpg_battle_options.exprate,
            rpg_battle_options.privacy AS battleprivacy,
            rpg_items_user.*,
            rpg_battle_stats.*,
            rpg_rpg_race.name AS rpgracename,
            rpg_rpg_race.alignment AS rpgalignmentname,
            rpg_rpg_classf.name AS fclassname,
            rpg_rpg_classf.folder AS fclassfolder,
            rpg_rpg_classm.name AS mclassname,
            rpg_rpg_classm.folder AS mclassfolder,
            rpg_rpg_element.name AS elename
        FROM rpg_battle_options
            LEFT JOIN user ON user.userid=1
            LEFT JOIN userfield ON userfield.userid=user.userid   
            LEFT JOIN rpg_items_user ON rpg_items_user.userid=user.userid
            LEFT JOIN rpg_battle_stats ON rpg_battle_stats.userid=user.userid
            LEFT JOIN rpg_rpg_classf ON rpg_rpg_classf.id=user.rpgclass
            LEFT JOIN rpg_rpg_classm ON rpg_rpg_classm.id=user.rpgclass
            LEFT JOIN rpg_rpg_element ON rpg_rpg_element.elementid=user.element
            LEFT JOIN rpg_rpg_race ON rpg_rpg_race.raceid=user.rpgrace AND rpg_rpg_race.alignmentid=user.alignment
    
mysql error: Unknown column 'user.uttpoints' in 'field list'

mysql error number: 1054 
help me plz
If you have uCS installed, you have changed the Points Field location to something else than the 'uttpoints' in the 'user' table. Please change this back.
If you do not have the uCS installed, then you need to install this BEFORE this hack, otherwise you will get errors like this all over the place.
:)

Rahzel_hx 08-28-2004 11:57 AM
How do i added a field so my rpg name doesn't = my location?

Revan 08-28-2004 12:14 PM
Enter User Profile Field Manager, look at the ID of the "RPG Name" field, remember it, enter Edit Options in the Battle category, change Name Field to the field and id of your RPG Name field.
:)

korny 08-28-2004 08:48 PM
Quote:
Originally Posted by Revan
Enter User Profile Field Manager, look at the ID of the "RPG Name" field, remember it, enter Edit Options in the Battle category, change Name Field to the field and id of your RPG Name field.
:)
Hey Revan,

This may sound stupid, but does this hack have an actually battle field, where you and other users are fighting on a image of a field, with 2 or more characters battling it out, or is this RPG hack the one where you just type your actions in a thread, and wait for the other user to reply to your thread with another action?

Revan 08-28-2004 09:40 PM
Its like the RPG Integration Hack for vB2, so its the field stuff.
The latter you described is to me an RP, not RPG.

check out some of the forums that got it installed to see ;)

Troak 08-28-2004 11:47 PM
I got this error when going to update my RPG info

Database error in vBulletin 3.0.0:

[SQL]Invalid SQL: SELECT rpgclass, rpggender, rpgrace, alignment, element, inbattle, rpgstats FROM user WHERE userid='2'
mysql error: Unknown column 'rpgstats' in 'field list'

mysql error number: 1054[/SQL]

Revan 08-29-2004 08:10 AM
[sql]ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '1';[/sql]
I think I forgot to add that one to the installer... :p

Logikos 08-29-2004 09:21 AM
Great work revan, hotm definitly!

Troak 08-29-2004 05:15 PM
So how do I fix it using that code?

EDIT: I figured it out, thanks for the help! ^^


All times are GMT. The time now is 11:13 AM.
Page 22 of 87 « First 122021 22 23243272 Last »
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.01516 seconds
  • Memory Usage 1,792KB
  • 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
  • (2)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
  • (3)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