This has got to be simple but its late

[Jalrock]

The following code is activated by a link that has the userid in it.

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

$battle_username = $therebattlestats['username'];
$battle_health = $therebattlestats['battle_health'];
$battle_intel = $therebattlestats['battle_intel'];
$battle_magic = $therebattlestats['battle_magic'];
$battle_skill = $therebattlestats['battle_skill'];
$battle_armor = $therebattlestats['battle_armor'];

$DB_site->free_result($therebattlestats);
    eval("\$therestats = \"".gettemplate('battle_there_stats')."\";");

eval("dooutput(\"".gettemplate("battle_main")."\");");
}

However it is not picking up the userid in the link.

Any help is greatly appreciated.

[christec]

Try $bbuserinfo[userid] instead of $userid

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

[Jalrock]

Thanks. I also found that the whole thing can be replaced with.....

if ($action=="selectuser") {
$user2info=getuserinfo($useridb);
$battle_username = $user2info['username'];
$battle_health = $user2info['battle_health'];
$battle_intel = $user2info['battle_intel'];
$battle_magic = $user2info['battle_magic'];
$battle_skill = $user2info['battle_skill'];
$battle_armor = $user2info['battle_armor'];
$DB_site->free_result($user2info);
eval("\$battle_user2 = \"".gettemplate('battle_user2')."\";");
}

Erwin,
You have been a big help thus far and I really do appreciate it. If you get to looking for a really simple to install and easy to use RPG battle hack, I will have it soon and it is yours.

[Erwin]

No worries.