View Single Post
  #212  
Old 08-28-2004, 06:21 AM
LeonHartHVA LeonHartHVA is offline
 
Join Date: Jul 2003
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 number1054 
help me plz
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01260 seconds
  • Memory Usage 1,801KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete