PHP Page of banned users [list]

[Demantor]

<?
include "Tittle.txt";
$released = true;
if($released == true){
$Replay = "Thanxx";
}
?>

[MentaL]

[shadow-xx]

Not tested!

<?php
$database['name'] = 'GunZDB';
$database['user'] = 'sa';
$database['pass'] = '';
$dbc = odbc_connect($database['name'],$database['user'],$database['pass']);
while (odbc_fetc_array(odbc_query($dbc,"SELECT * FROM Account WHERE UgradeID='253'")) = $row) {
    foreach($row as $var => $val) {
        echo $var.' = '.$val."\r\n";
    }
    echo '-------------------------------------';
}
?>

[Demantor]

Ty, but not working D:

[shadow-xx]

Try this i just tested this one

<?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)) {
    foreach($row as $var => $val) {
        echo $var.' = '.$val.'<br />';
    }
    echo '-------------------------------------<br />';
}
?>

[Demantor]

ya, nice =) working

but, maybe you can make it only to post the Account ID(name) and its Characters,, this will be very useful
Thanks in advance....

[sayuta]

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

[Demantor]

it is only showing the banned users number D: but, ty =)

[sayuta]

Well, what do u want exactly?

[Demantor]

That the banned users(Name) with there characters(Name) to be posted, i don't want that all the table data to be posted D:

Thanks again :)

[shadow-xx]

This should work...
not tested on characters as i dont have a database that contains any he he..

<?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='".$row['AID']."'");
    while($char = odbc_fetch_array($char_query)) {
        echo '> '.$char['name'];
    }
    echo '--------------------<br />';
}
?>

[Anan]

Wow cool , shadow-xx one is the best one of them... it says only Name... easier but else are good too :o
or got a idea make first thing like shadow-xx , if press on name get reason and details of banning for the user... but that is like need to make new shit xD

[sayuta]

i dont got a DB either,
Shadows script looks fine ;). i think you mean that.

[Demantor]

well, ya.. that php is working all right, but it still doesn't show the character for the posted account name, but anyway, thanx alot shadow-xx & sayuta :)

[shadow-xx]

Forgot the capital N 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='".$row['AID']."'");
    while($char = odbc_fetch_array($char_query)) {
        echo '> '.$char['Name'];
    }
    echo '--------------------<br />';
}
?>

Offtopic :
If anyone has a nicely filled db feel free to donate it will make things easier.

[Demantor]

Ty,, but same, only account names shown =)

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