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.
Quote:
Originally Posted by Warlord
What the hell does fpg.php do? I get:
Code:
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
Heres some pics of that background bug, seems to be a problem with the right side where the Race,Class and Element is listed.
It only does it when there is a class with 2 words and only on the right side.
Hope this helps.
Heres some pics of that background bug, seems to be a problem with the right side where the Race,Class and Element is listed.
It only does it when there is a class with 2 words and only on the right side.
Hope this helps.
This helps immensely, I will expand the width of this template part and post a hotfix as soon as I find it!
Quote:
Originally Posted by RasMasta
How do I install UCS it should have already installed itself right?
No it shouldnt.
Go download uCash/uShop from their own thread
EDIT: I finally fixed the alignment stuff for good
Redownload the rpg_hotfix_battlescene.txt from the Hotfixes post
Is it possible to make all the stats and everything in the postbit_legacy in a drop down menu? because this really annoys me, it exdents the size of my templates
Is it possible to make all the stats and everything in the postbit_legacy in a drop down menu? because this really annoys me, it exdents the size of my templates
I guess I should rename the "User Select RPG Postbit" to something a little more descriptive eh...
(Btw in case you didnt get it, this is what you need to install.
Ill make it a bundled feature in v3)
Quote:
Originally Posted by Cubie
nice job
it all works just fine
good idea to include a manual
one problem though, in my admincp I got twice the lottery option
I placed in the Postbit an Scrollable div Tag. But the Problem is, that only the IE can display it. So i am looking for a good Option to Display it more efficient an smaller.
RPG Integration Hack - Old Support Thread Details »»
About Developer
Visit Web Site
No support by the author.
09-20-2004, 06:54 AM
