[Erwin]

Change this:

PHP Code:

$therebattlestats=$DB_site->query_first("SELECT username, battle_armor, battle_intel, battle_magic, battle_skill, battle_armor, battle_health FROM user WHERE userid='$userid'"); 


to this:

PHP Code:

$therebattlestats=$DB_site->query_first("SELECT userid, username, battle_armor, battle_intel, battle_magic, battle_skill, battle_armor, battle_health FROM user WHERE userid='$userid'"); 


You need to SELECT userid from the USER table as well, which you haven't done.