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