PHP Page of Banned Users[LIST]

Results 1 to 14 of 14
  1. 10-02-09 #1
    BRAZIL-PAULINHO
    Account Upgraded | Title Enabled! BRAZIL-PAULINHO is offline
    MemberRank
    Sep 2008 Join Date
    Brasil, RioLocation
    537Posts

    PHP Page of Banned Users[LIST]

    Not Tested

    Code:
    <?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)) {
    ?>
    <style type="text/css">
    table{border: 1px solid #111111; font-family: verdana,tahoma,sans-serif; color: #464646;  font-size: 11px;}
    </style>
    <table border="1">
        <tr>
            <td><b>Account Name</b></td>
            <td><b>AID</b></td>
        </tr>
        <tr>
            <td><? echo $acc['UserID']; ?></td>
            <td align="center"><? echo $acc['AID']; ?></td>
        </tr>
    <?
    $char_query = odbc_exec($dbc,"SELECT Name,CID FROM Character WHERE AID='".$acc['AID']."'");
    while($char = odbc_fetch_array($char_query)) {
        if ($i++ == null) {
        ?>
            <tr>
                <td><b>Character Name</b></td>
                <td><b>CID</b></td>
            </tr>
        <?
        }
        ?>
            <tr>
                <td><? echo $char['Name']; ?></td>
                <td align="center"><? echo $char['CID']; ?></td>
            </tr>
        <?
    }
    unset($i);
    echo '</table><br />';
}
?>
    ALL CREDITS TO SHADOW-XX


    A PHP by Demantor :

    Code:
    <!PHP written by: SHADOW-XX, HTML written by: Demantor, you are allowed of course to edit what you want 

here>
<html>
<head>
  <title>Banned Members</title>
</head>
<body
 style="background-color: rgb(204, 204, 255); color: rgb(0, 0, 0);"
 alink="#ee0000" link="#0000ee" vlink="#551a8b">
<span style="font-weight: bold; font-style: italic;">CrazYToffi
GunZ Banned UserID(s)/Character(s):-</span><br>
<br>
<span style="text-decoration: underline; color: rgb(255, 0, 0);">Format:
</span><br>
<br>
<span style="color: rgb(102, 51, 102); font-weight: bold;">UserID</span><br>
&gt; <span style="color: rgb(51, 51, 153);">Character<span
 style="color: rgb(102, 51, 51);">1</span></span><br>
&gt; <span style="color: rgb(51, 51, 153);">Character
<span style="color: rgb(102, 51, 51);">2</span></span><br>
&gt; <span style="color: rgb(51, 51, 153);">Character
<span style="color: rgb(102, 51, 51);">n</span></span><br>
--------------------<br>
<span style="text-decoration: underline;">Example:-</span><br>
<br>
stocksting &nbsp; &nbsp; ---------&gt;Banned UserID (
Account Name )<br>
&gt; Stocksting &nbsp; &nbsp; --------&gt; Banned
Character name of this Account (&nbsp;stocksting )<br>
--------------------<br>
<br>
<span style="font-style: italic; font-weight: bold;"><span
 style="color: rgb(153, 51, 0);">List
of <big style="text-decoration: underline;">Banned</big><span
 style="text-decoration: underline;"> </span>Users:-</span><br>
<br>
</span><?php $database['name'] = 'GunZDB';
$database['user'] = '';
$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 />';
}
?>
</body>
</html>
    Last edited by BRAZIL-PAULINHO; 11-02-09 at 08:17 PM.
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    PHP Page of Banned Users[LIST]
  3. 10-02-09 #2
    mikethemak
    ツ mikethemak is offline
    MemberRank
    Apr 2008 Join Date
    Ragezone Spam SectionLocation
    1,019Posts

    Re: PHP Page of Banned Users[LIST]

    Not hard to do, but ty :)
    Reply With Quote Reply With Quote
  4. 10-02-09 #3
    Tra3200
    Proficient Member Tra3200 is offline
    MemberRank
    Jul 2008 Join Date
    199Posts

    Re: PHP Page of Banned Users[LIST]

    Nice But why would you release something thats not tested ..O_O
    Reply With Quote Reply With Quote
  5. 11-02-09 #4
    dacharles
    GunZ Developer dacharles is offline
    MemberRank
    Oct 2006 Join Date
    476Posts

    Re: PHP Page of Banned Users[LIST]

    not is hard ..
    Reply With Quote Reply With Quote
  6. 11-02-09 #5
    BRAZIL-PAULINHO
    Account Upgraded | Title Enabled! BRAZIL-PAULINHO is offline
    MemberRank
    Sep 2008 Join Date
    Brasil, RioLocation
    537Posts

    Re: PHP Page of Banned Users[LIST]

    Case i dont have nothing to test this on my pc and shadow did it
    Reply With Quote Reply With Quote
  7. 11-02-09 #6
    Demantor
    Sultan of Yolo Demantor is offline
    MemberRank
    May 2008 Join Date
    GermanyLocation
    1,266Posts

    Re: PHP Page of Banned Users[LIST]

    I made just some basic html edits :-
    PHP Code:
    <!PHP written by: SHADOW-XX, HTML written by: Demantor, you are allowed of course to edit what you want 

    here>
    <html>
    <head>
      <title>Banned Members</title>
    </head>
    <body
     style="background-color: rgb(204, 204, 255); color: rgb(0, 0, 0);"
     alink="#ee0000" link="#0000ee" vlink="#551a8b">
    <span style="font-weight: bold; font-style: italic;">CrazYToffi
    GunZ Banned UserID(s)/Character(s):-</span><br>
    <br>
    <span style="text-decoration: underline; color: rgb(255, 0, 0);">Format:
    </span><br>
    <br>
    <span style="color: rgb(102, 51, 102); font-weight: bold;">UserID</span><br>
    &gt; <span style="color: rgb(51, 51, 153);">Character<span
     style="color: rgb(102, 51, 51);">1</span></span><br>
    &gt; <span style="color: rgb(51, 51, 153);">Character
    <span style="color: rgb(102, 51, 51);">2</span></span><br>
    &gt; <span style="color: rgb(51, 51, 153);">Character
    <span style="color: rgb(102, 51, 51);">n</span></span><br>
    --------------------<br>
    <span style="text-decoration: underline;">Example:-</span><br>
    <br>
    stocksting &nbsp; &nbsp; ---------&gt;Banned UserID (
    Account Name )<br>
    &gt; Stocksting &nbsp; &nbsp; --------&gt; Banned
    Character name of this Account (&nbsp;stocksting )<br>
    --------------------<br>
    <br>
    <span style="font-style: italic; font-weight: bold;"><span
     style="color: rgb(153, 51, 0);">List
    of <big style="text-decoration: underline;">Banned</big><span
     style="text-decoration: underline;"> </span>Users:-</span><br>
    <br>
    </span><?php $database['name'] = 'GunZDB';
    $database['user'] = '';
    $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 />';
    }
    ?>
    </body>
    </html>
    Please, Don'T use your brain and name this xxx.html its php
    Ty
    Reply With Quote Reply With Quote
  8. 11-02-09 #7
    WooAf
    DarKGunZ Owner WooAf is offline
    MemberRank
    Dec 2007 Join Date
    CanadaLocation
    485Posts

    Re: PHP Page of Banned Users[LIST]

    Just go to your DB and type
    SELECT * FROM Account WHERE UGradeID = 253
    Reply With Quote Reply With Quote
  9. 11-02-09 #8
    Demantor
    Sultan of Yolo Demantor is offline
    MemberRank
    May 2008 Join Date
    GermanyLocation
    1,266Posts

    Re: PHP Page of Banned Users[LIST]

    Quote Originally Posted by WooAf View Post
    Just go to your DB and type
    SELECT * FROM Account WHERE UGradeID = 253
    Can'T understand?
    Reply With Quote Reply With Quote
  10. 11-02-09 #9
    Demantor
    Sultan of Yolo Demantor is offline
    MemberRank
    May 2008 Join Date
    GermanyLocation
    1,266Posts

    Re: PHP Page of Banned Users[LIST]

    Quote Originally Posted by BRAZIL-PAULINHO View Post
    A PHP by Demantor :
    It is still SHADOW-XX's PHP^^
    I just added html
    Reply With Quote Reply With Quote
  11. 11-02-09 #10
    shadow-xx
    Account Upgraded | Title Enabled! shadow-xx is offline
    MemberRank
    Jan 2007 Join Date
    MegatonLocation
    804Posts

    Re: PHP Page of Banned Users[LIST]

    Here use this one, it outputs the data in tables..
    Easier to read separate accounts.

    PHP Code:
    <?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)) {
            ?>
        <style type="text/css">
        table{border: 1px solid #111111; font-family: verdana,tahoma,sans-serif; color: #464646;  font-size: 11px;}
        </style>
        <table border="1">
            <tr>
                <td><b>Account Name</b></td>
                <td><b>AID</b></td>
            </tr>
            <tr>
                <td><? echo $acc['UserID']; ?></td>
                <td align="center"><? echo $acc['AID']; ?></td>
            </tr>
        <?
        $char_query     = odbc_exec($dbc,"SELECT Name,CID FROM Character WHERE AID='".$acc['AID']."'");
        while(    $char = odbc_fetch_array($char_query)) {
            if (    $i++ == null) {
                ?>
                <tr>
                    <td><b>Character Name</b></td>
                    <td><b>CID</b></td>
                </tr>
            <?
                }
                ?>
                <tr>
                    <td><? echo $char['Name']; ?></td>
                    <td align="center"><? echo $char['CID']; ?></td>
                </tr>
            <?
            }
        unset(    $i);
        echo     '</table><br />';
    }
    ?>
    Reply With Quote Reply With Quote
  12. 11-02-09 #11
    BRAZIL-PAULINHO
    Account Upgraded | Title Enabled! BRAZIL-PAULINHO is offline
    MemberRank
    Sep 2008 Join Date
    Brasil, RioLocation
    537Posts

    Re: PHP Page of Banned Users[LIST]

    Ok EDITED
    Reply With Quote Reply With Quote
  13. 11-02-09 #12
    WooAf
    DarKGunZ Owner WooAf is offline
    MemberRank
    Dec 2007 Join Date
    CanadaLocation
    485Posts

    Re: PHP Page of Banned Users[LIST]

    Why make a PHP page of it?
    just use this query in mssql management

    SELECT * FROM Account WHERE UGradeID = 253
    Reply With Quote Reply With Quote
  14. 11-02-09 #13
    shadow-xx
    Account Upgraded | Title Enabled! shadow-xx is offline
    MemberRank
    Jan 2007 Join Date
    MegatonLocation
    804Posts

    Re: PHP Page of Banned Users[LIST]

    Because Dementor requested it..
    and that query wont grab the characters from the database..
    Reply With Quote Reply With Quote
  15. 11-02-09 #14
    Gosu[ru]
    Account Upgraded | Title Enabled! Gosu[ru] is offline
    MemberRank
    Jan 2009 Join Date
    http://www.epicLocation
    359Posts

    Re: PHP Page of Banned Users[LIST]

    Add another IP there
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement