RPG Integration Hack - Old Support Thread

Nice conversion there mate, lot of work has gone into it so well done and thanks for sharing it

[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

[Revan]

Originally Posted by CHIngs

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

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]

How do i added a field so my rpg name doesn't = my location?

[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.

[korny]

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]

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]

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]

[sql]ALTER TABLE `user` ADD `rpgstats` CHAR(1) NOT NULL DEFAULT '1';[/sql]
I think I forgot to add that one to the installer...

[Logikos]

Great work revan, hotm definitly!

[Troak]

So how do I fix it using that code?

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