PHP Page of banned users [list]

[shadow-xx]

Inserted some characters in my db..
And then tested this..

i forgot to change ".$row['AID']."'"); Into ".$acc['AID']."'");
Stupid mistakes T_T

<?php
$database['name'] = 'GunZDB';
$database['user'] = 'sa';
$database['pass'] = '';

$dbc = odbc_connect($database['name'],$database['user'],$database['pass']);
$acc_query = odbc_exec($dbc,"SELECT AID,UserID FROM Account WHERE UgradeID='253'");

while ($acc = odbc_fetch_array($acc_query)) {
    echo $acc['UserID'].'<br />';
    $char_query = odbc_exec($dbc,"SELECT Name FROM Character WHERE AID='".$acc['AID']."'");
    while($char = odbc_fetch_array($char_query)) {
        echo '> '.$char['Name'].'<br />';
    }
    echo '--------------------<br />';
}
?>

[sayuta]

Wanted to say that, but u fixxed it already xD

[Demantor]

lol, nice guys, thanks a lot for your help =)

[sayuta]

Your welcome o.o

[Solaire]

Try this ;

<?php 
$database['name'] = 'GunZDB'; 
$database['user'] = 'sa'; 
$database['pass'] = ''; 
 
$dbc = odbc_connect($database['name'],$database['user'],$database['pass']); 
$query = odbc_exec($dbc,"SELECT * FROM Account WHERE UgradeID='253'"); 
 
while ($row = odbc_fetch_array($query)) { 
echo "".$row['AID']." ".$row['Character']."<br>";
} 
?>

Not sure what table name, just change the AID & the Character to the correct one..

And this is another proof you don't know master PHP.

echo "".$row['AID']." ".$row['Character']."<br>"; 

Should simply be

echo $row['AID']." ".$row['Character']."<br>"; 

Ok, out of this discussion. Not worth my time.

[Demantor]

This doesn't matter, his php is working fine by me, that's good... ty

[4ndr34s]

thanks!!!