[Revan]

Originally Posted by RasMasta

PHP Code:

Database error in vBulletin 3.0.3:

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 


I get that error when viewing fpg.php and rpgcp.php

What is wrong?

You either changed uCS's point field to something else than 'uttpoints', or you did not install uCS.

Originally Posted by Warlord

What the hell does fpg.php do? I get:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, scott.alan.williams1@us.army.mil and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.27 Server at www.neropolis.com Port 80

You mean seeing as theres no file called 'fpg.php'?
If you did a typo and you get this error at 'rpg.php', then your server is misconfigured in some way