[Release]MT2GS Ban addon

[KilleRzZ™]

Hello today i will release my ban addon is not so good but i will make it better by the time
screen:

 Spoiler

PHP:

 Spoiler

<?PHP
if(!empty($_SESSION['user_id']))

{

echo'<h2>Account Status</h2>';

echo'<div class="splitLeft">';

echo'<p>In this page you can see if you have take ban!</p> ';

echo'</div>';

echo'<div class="splitRight">';



$cmdStats = "SELECT SUM( player.playtime ) AS ges_spielzeit, COUNT( * ) AS ges_chars, player_index.empire

FROM player.player

INNER JOIN player.player_index ON player_index.id = player.account_id

WHERE player.account_id = '".$_SESSION['user_id']."'

LIMIT 1";



$qryStats = mysql_query($cmdStats,$sqlServ);

$getStats = mysql_fetch_object($qryStats);



if(!empty($getStats->empire)) {

$reich = '<img src="m2m.eikones/vaseilia/'.$getStats->empire.'.png" title="Βασίλειο" alt="Reich"/>';

}

else {

$reich='Dont selected kingdom';

}




echo'<center>';
echo'<table>

<tr>

<th class="topLine">Account:</th>

<td class="tdunkel"><b>'.$_SESSION['user_name'].'</td>

</tr>


';



$sqlAcc = "SELECT account.social_id AS loeschcode, logos, status, warm, do8ike, safebox.password AS lagerpw



FROM account.account



LEFT JOIN player.safebox



ON account.id=safebox.account_id



WHERE account.id='".$_SESSION['user_id']."'";







$qryAcc = mysql_query($sqlAcc) or die(mysql_error());



$getAcc = mysql_fetch_object($qryAcc);







if(empty($getAcc->lagerpw)) $getAcc->lagerpw = '000000';


if($getAcc->status >= "OK") {



$getAcc->status = '<td class="statusok"><b>Normal</b></font></center>'; }



if($getAcc->status >= "BLOCK") {

$getAcc->status = '<td class="statusblock"><b>Blocked</b></font></center>'; }

if($getAcc->warm >= "3") {
$getAcc->warm = '<td class="statusmelba"><b>You have 3 warnings</b></font></center>';
}
elseif($getAcc->warm >= "2") {
$getAcc->warm = '<td class="statusmelba"><b>You have 2 warnings</b></font></center>';
}
elseif($getAcc->warm >= "1") {
$getAcc->warm = '<td class="statusmelba"><b>You have 1 warning</b></font></center>';
}
elseif($getAcc->warm >= "") {
$getAcc->warm = '<td class="statusok"><b>You dont have warnings</b></font></center>';
}

if($getAcc->logos >= "3") {
$getAcc->logos = '<td class="statusmelba"><b>excessive swearing</b></font></center>';
}
elseif($getAcc->logos >= "2") {
$getAcc->logos = '<td class="statusmelba"><b>Advertising of another server</b></font></center>';
}
elseif($getAcc->logos >= "1") {
$getAcc->logos = '<td class="statusmelba"><b>Hacking</b></font></center>';
}
elseif($getAcc->logos >= "") {
$getAcc->logos = '<td class="statusok"><b>Has not been excluded from the game</b></font></center>';
}


if($getAcc->do8ike >= "3") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Ven</b></font></center>';
}
elseif($getAcc->do8ike >= "2") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Gracia</b></font></center>';
}
elseif($getAcc->do8ike >= "1") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Destorm</b></font></center>';
}
elseif($getAcc->do8ike >= "") {
$getAcc->do8ike = '<td class="statusok"><b>You have gotten from anyone exclusion</b></font></center>';
}

echo'



<tr>



<th class="topLine">Login Status:</th>



<b>'.$getAcc->status.'</td>



</tr>

<tr>



<th class="topLine">Warning:</th>



<b>'.$getAcc->warm.'</td>



</tr>


<tr>



<th class="topLine">Reason for exclusion:</th>



<b>'.$getAcc->logos.'</td>



</tr>



<tr>



<th class="topLine">given by:</th>



<b>'.$getAcc->do8ike.'</td>



</tr>
</table>';







echo'</div><div class="clear"></div>';



}



else



{



?>

<h2>login</h2>

<form action="index.php?s=login" method="POST">

<table>

<tr>

<th class="topLine">Username:</th>

<td class="tdunkel"><input type="text" name="userid" maxlength="16" size="20"/></td>

</tr>

<tr>

<th class="topLine">Passwort:</th>

<td class="thell"><input type="password" name="userpass" maxlength="16" size="20"/></td>

</tr>

<tr>

<td class="topLine" style="text-align:center;" colspan="2"><input type="submit" name="submit" value="Login"/></td>

</tr>

</table>

<p><a href="index.php?s=register">register</a> &bull; <a href="index.php?s=lostpw">Lost password</a></p>

</form>

<?PHP

}

For do this script work 100% you have to add in mysql account.account 3 new tables with names:warm,logos,do8ike
after this you will change the numbers for example if you put warm 1 site will say:You have 1 warning

Dont forget to thanks <3 <3 if anyone want help then send me pm i will help

[MBoyJohnTz]

Nice man Good job keep on

[anestivas11]

Thank You KillerZ <3

[stylmp]

Very nice, keep doing your best! Tnx for the release.

[kstmr]

Originally Posted by KilleRzZ™

Hello today i will release my ban addon is not so good but i will make it better by the time
screen:

 Spoiler

PHP:

 Spoiler

<?PHP
if(!empty($_SESSION['user_id']))

{

echo'<h2>Account Status</h2>';

echo'<div class="splitLeft">';

echo'<p>In this page you can see if you have take ban!</p> ';

echo'</div>';

echo'<div class="splitRight">';



$cmdStats = "SELECT SUM( player.playtime ) AS ges_spielzeit, COUNT( * ) AS ges_chars, player_index.empire

FROM player.player

INNER JOIN player.player_index ON player_index.id = player.account_id

WHERE player.account_id = '".$_SESSION['user_id']."'

LIMIT 1";



$qryStats = mysql_query($cmdStats,$sqlServ);

$getStats = mysql_fetch_object($qryStats);



if(!empty($getStats->empire)) {

$reich = '<img src="m2m.eikones/vaseilia/'.$getStats->empire.'.png" title="Βασίλειο" alt="Reich"/>';

}

else {

$reich='Dont selected kingdom';

}




echo'<center>';
echo'<table>

<tr>

<th class="topLine">Account:</th>

<td class="tdunkel"><b>'.$_SESSION['user_name'].'</td>

</tr>


';



$sqlAcc = "SELECT account.social_id AS loeschcode, logos, status, warm, do8ike, safebox.password AS lagerpw



FROM account.account



LEFT JOIN player.safebox



ON account.id=safebox.account_id



WHERE account.id='".$_SESSION['user_id']."'";







$qryAcc = mysql_query($sqlAcc) or die(mysql_error());



$getAcc = mysql_fetch_object($qryAcc);







if(empty($getAcc->lagerpw)) $getAcc->lagerpw = '000000';


if($getAcc->status >= "OK") {



$getAcc->status = '<td class="statusok"><b>Normal</b></font></center>'; }



if($getAcc->status >= "BLOCK") {

$getAcc->status = '<td class="statusblock"><b>Blocked</b></font></center>'; }

if($getAcc->warm >= "3") {
$getAcc->warm = '<td class="statusmelba"><b>You have 3 warnings</b></font></center>';
}
elseif($getAcc->warm >= "2") {
$getAcc->warm = '<td class="statusmelba"><b>You have 2 warnings</b></font></center>';
}
elseif($getAcc->warm >= "1") {
$getAcc->warm = '<td class="statusmelba"><b>You have 1 warning</b></font></center>';
}
elseif($getAcc->warm >= "") {
$getAcc->warm = '<td class="statusok"><b>You dont have warnings</b></font></center>';
}

if($getAcc->logos >= "3") {
$getAcc->logos = '<td class="statusmelba"><b>excessive swearing</b></font></center>';
}
elseif($getAcc->logos >= "2") {
$getAcc->logos = '<td class="statusmelba"><b>Advertising of another server</b></font></center>';
}
elseif($getAcc->logos >= "1") {
$getAcc->logos = '<td class="statusmelba"><b>Hacking</b></font></center>';
}
elseif($getAcc->logos >= "") {
$getAcc->logos = '<td class="statusok"><b>Has not been excluded from the game</b></font></center>';
}


if($getAcc->do8ike >= "3") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Ven</b></font></center>';
}
elseif($getAcc->do8ike >= "2") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Gracia</b></font></center>';
}
elseif($getAcc->do8ike >= "1") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Destorm</b></font></center>';
}
elseif($getAcc->do8ike >= "") {
$getAcc->do8ike = '<td class="statusok"><b>You have gotten from anyone exclusion</b></font></center>';
}

echo'



<tr>



<th class="topLine">Login Status:</th>



<b>'.$getAcc->status.'</td>



</tr>

<tr>



<th class="topLine">Warning:</th>



<b>'.$getAcc->warm.'</td>



</tr>


<tr>



<th class="topLine">Reason for exclusion:</th>



<b>'.$getAcc->logos.'</td>



</tr>



<tr>



<th class="topLine">given by:</th>



<b>'.$getAcc->do8ike.'</td>



</tr>
</table>';







echo'</div><div class="clear"></div>';



}



else



{



?>

<h2>login</h2>

<form action="index.php?s=login" method="POST">

<table>

<tr>

<th class="topLine">Username:</th>

<td class="tdunkel"><input type="text" name="userid" maxlength="16" size="20"/></td>

</tr>

<tr>

<th class="topLine">Passwort:</th>

<td class="thell"><input type="password" name="userpass" maxlength="16" size="20"/></td>

</tr>

<tr>

<td class="topLine" style="text-align:center;" colspan="2"><input type="submit" name="submit" value="Login"/></td>

</tr>

</table>

<p><a href="index.php?s=register">register</a> &bull; <a href="index.php?s=lostpw">Lost password</a></p>

</form>

<?PHP

}

For do this script work 100% you have to add in mysql account.account 3 new tables with names:warm,logos,do8ike
after this you will change the numbers for example if you put warm 1 site will say:You have 1 warning

Dont forget to thanks <3 <3 if anyone want help then send me pm i will help

nice work just use this for php code

PHP Code:

<?PHP
  if(!empty($_SESSION['user_id'])) 

  {

    echo'<h2>Account Status</h2>';

    echo'<div class="splitLeft">';

echo'<p>In this page you can see if you have take ban!</p> ';

    echo'</div>';

    echo'<div class="splitRight">';

    

    $cmdStats = "SELECT SUM( player.playtime ) AS ges_spielzeit, COUNT( * ) AS ges_chars, player_index.empire

    FROM player.player

    INNER JOIN player.player_index ON player_index.id = player.account_id

    WHERE player.account_id = '".$_SESSION['user_id']."'

    LIMIT 1";

    

    $qryStats = mysql_query($cmdStats,$sqlServ);

    $getStats = mysql_fetch_object($qryStats);

    

    if(!empty($getStats->empire)) {

      $reich = '<img src="m2m.eikones/vaseilia/'.$getStats->empire.'.png" title="Βασίλειο" alt="Reich"/>';

    }

    else {

      $reich='Dont selected kingdom';

    }

    

    
echo'<center>';
    echo'<table>

      <tr>

        <th class="topLine">Account:</th>

        <td class="tdunkel"><b>'.$_SESSION['user_name'].'</td>

      </tr>


';



    $sqlAcc = "SELECT account.social_id AS loeschcode, logos, status, warm, do8ike, safebox.password AS lagerpw



    FROM account.account 



    LEFT JOIN player.safebox 



    ON account.id=safebox.account_id 



    WHERE account.id='".$_SESSION['user_id']."'";







    $qryAcc = mysql_query($sqlAcc) or die(mysql_error());



    $getAcc = mysql_fetch_object($qryAcc);



    



    if(empty($getAcc->lagerpw)) $getAcc->lagerpw = '000000';


    if($getAcc->status >= "OK") {



     $getAcc->status = '<td class="statusok"><b>Normal</b></font></center>';       }  



    if($getAcc->status >= "BLOCK") {
    
     $getAcc->status = '<td class="statusblock"><b>Blocked</b></font></center>';       }   
    
    if($getAcc->warm >= "3") { 
    $getAcc->warm = '<td class="statusmelba"><b>You have 3 warnings</b></font></center>';  
    }
    elseif($getAcc->warm >= "2") {
    $getAcc->warm = '<td class="statusmelba"><b>You have 2 warnings</b></font></center>'; 
    }
    elseif($getAcc->warm >= "1") {
    $getAcc->warm = '<td class="statusmelba"><b>You have 1 warning</b></font></center>';      
    }     
    elseif($getAcc->warm >= "") {
    $getAcc->warm = '<td class="statusok"><b>You dont have warnings</b></font></center>';      
    }     
    
        if($getAcc->logos >= "3") { 
    $getAcc->logos = '<td class="statusmelba"><b>excessive swearing</b></font></center>';  
    }
    elseif($getAcc->logos >= "2") {
    $getAcc->logos = '<td class="statusmelba"><b>Advertising  of another server</b></font></center>'; 
    }
    elseif($getAcc->logos >= "1") {
    $getAcc->logos = '<td class="statusmelba"><b>Hacking</b></font></center>';      
    }     
    elseif($getAcc->logos >= "") {
    $getAcc->logos = '<td class="statusok"><b>Has not  been excluded from the game</b></font></center>';       
    } 
    
    
        if($getAcc->do8ike >= "3") { 
    $getAcc->do8ike = '<td class="statusblock"><b>[SA]Ven</b></font></center>';  
    }
    elseif($getAcc->do8ike >= "2") {
    $getAcc->do8ike = '<td class="statusblock"><b>[SA]Gracia</b></font></center>'; 
    }
    elseif($getAcc->do8ike >= "1") {
    $getAcc->do8ike = '<td class="statusblock"><b>[SA]Destorm</b></font></center>';      
    }     
    elseif($getAcc->do8ike >= "") {
    $getAcc->do8ike = '<td class="statusok"><b>You have  gotten from anyone exclusion</b></font></center>';       
    } 
    
      echo'



        <tr>



        <th class="topLine">Login Status:</th>



        <b>'.$getAcc->status.'</td>



      </tr>
      
              <tr>



        <th class="topLine">Warning:</th>



        <b>'.$getAcc->warm.'</td>



      </tr>
      
      
      <tr>



        <th class="topLine">Reason for exclusion:</th>



        <b>'.$getAcc->logos.'</td>



      </tr>

      
      
      <tr>



        <th class="topLine">given by:</th>



        <b>'.$getAcc->do8ike.'</td>



      </tr> 
    </table>';



    



    echo'</div><div class="clear"></div>';



  }



  else 



  {



  ?>

        <h2>login</h2>

<form action="index.php?s=login" method="POST">

  <table>

    <tr>

      <th class="topLine">Username:</th>

      <td class="tdunkel"><input type="text" name="userid" maxlength="16" size="20"/></td>

    </tr>

    <tr>

      <th class="topLine">Passwort:</th>

      <td class="thell"><input type="password" name="userpass" maxlength="16" size="20"/></td>

    </tr>

    <tr>

      <td class="topLine" style="text-align:center;"  colspan="2"><input type="submit" name="submit"  value="Login"/></td>

    </tr>

  </table>

  <p><a href="index.php?s=register">register</a>  &bull; <a href="index.php?s=lostpw">Lost  password</a></p>

</form>

  <?PHP

  }

thanks

[barbaques]

Denic Copyrights?

[KilleRzZ™]

Originally Posted by barbaques

Denic Copyrights?

my copyrights :*

[[uLow]NTX?!]

Hey,

nettes Realese Danke dafür.

Ich habe mal ein paar Verbesserungsvorschläge für dich.

Z.b. solltest du
filter_input() mit entsprechenden filtern nutzen. Das kann dann alles mögliche rausfiltern.


Und bei diesem abschnitt z.b.

Warum machst du eine If?

du kannst einfach &getAcc->warm dynamsich ausgeben lassen. Das spaart Code & man kann mehr als 3 Warnings haben.

PHP Code:

if($getAcc->status >= "BLOCK") {

$getAcc->status = '<td class="statusblock"><b>Blocked</b></font></center>'; }

if($getAcc->warm >= "3") {
$getAcc->warm = '<td class="statusmelba"><b>You have 3 warnings</b></font></center>';
}
elseif($getAcc->warm >= "2") {
$getAcc->warm = '<td class="statusmelba"><b>You have 2 warnings</b></font></center>';
}
elseif($getAcc->warm >= "1") {
$getAcc->warm = '<td class="statusmelba"><b>You have 1 warning</b></font></center>';
}
elseif($getAcc->warm >= "") {
$getAcc->warm = '<td class="statusok"><b>You dont have warnings</b></font></center>';
} 


[kangar00]

Originally Posted by kstmr

nice work just use this for php code

PHP Code:

<?PHP
  if(!empty($_SESSION['user_id'])) 

  {

    echo'<h2>Account Status</h2>';

    echo'<div class="splitLeft">';

echo'<p>In this page you can see if you have take ban!</p> ';

    echo'</div>';

    echo'<div class="splitRight">';

    

    $cmdStats = "SELECT SUM( player.playtime ) AS ges_spielzeit, COUNT( * ) AS ges_chars, player_index.empire

    FROM player.player

    INNER JOIN player.player_index ON player_index.id = player.account_id

    WHERE player.account_id = '".$_SESSION['user_id']."'

    LIMIT 1";

    

    $qryStats = mysql_query($cmdStats,$sqlServ);

    $getStats = mysql_fetch_object($qryStats);

    

    if(!empty($getStats->empire)) {

      $reich = '<img src="m2m.eikones/vaseilia/'.$getStats->empire.'.png" title="Βασίλειο" alt="Reich"/>';

    }

    else {

      $reich='Dont selected kingdom';

    }

    

    
echo'<center>';
    echo'<table>

      <tr>

        <th class="topLine">Account:</th>

        <td class="tdunkel"><b>'.$_SESSION['user_name'].'</td>

      </tr>


';



    $sqlAcc = "SELECT account.social_id AS loeschcode, logos, status, warm, do8ike, safebox.password AS lagerpw



    FROM account.account 



    LEFT JOIN player.safebox 



    ON account.id=safebox.account_id 



    WHERE account.id='".$_SESSION['user_id']."'";







    $qryAcc = mysql_query($sqlAcc) or die(mysql_error());



    $getAcc = mysql_fetch_object($qryAcc);



    



    if(empty($getAcc->lagerpw)) $getAcc->lagerpw = '000000';


    if($getAcc->status >= "OK") {



     $getAcc->status = '<td class="statusok"><b>Normal</b></font></center>';       }  



    if($getAcc->status >= "BLOCK") {
    
     $getAcc->status = '<td class="statusblock"><b>Blocked</b></font></center>';       }   
    
    if($getAcc->warm >= "3") { 
    $getAcc->warm = '<td class="statusmelba"><b>You have 3 warnings</b></font></center>';  
    }
    elseif($getAcc->warm >= "2") {
    $getAcc->warm = '<td class="statusmelba"><b>You have 2 warnings</b></font></center>'; 
    }
    elseif($getAcc->warm >= "1") {
    $getAcc->warm = '<td class="statusmelba"><b>You have 1 warning</b></font></center>';      
    }     
    elseif($getAcc->warm >= "") {
    $getAcc->warm = '<td class="statusok"><b>You dont have warnings</b></font></center>';      
    }     
    
        if($getAcc->logos >= "3") { 
    $getAcc->logos = '<td class="statusmelba"><b>excessive swearing</b></font></center>';  
    }
    elseif($getAcc->logos >= "2") {
    $getAcc->logos = '<td class="statusmelba"><b>Advertising  of another server</b></font></center>'; 
    }
    elseif($getAcc->logos >= "1") {
    $getAcc->logos = '<td class="statusmelba"><b>Hacking</b></font></center>';      
    }     
    elseif($getAcc->logos >= "") {
    $getAcc->logos = '<td class="statusok"><b>Has not  been excluded from the game</b></font></center>';       
    } 
    
    
        if($getAcc->do8ike >= "3") { 
    $getAcc->do8ike = '<td class="statusblock"><b>[SA]Ven</b></font></center>';  
    }
    elseif($getAcc->do8ike >= "2") {
    $getAcc->do8ike = '<td class="statusblock"><b>[SA]Gracia</b></font></center>'; 
    }
    elseif($getAcc->do8ike >= "1") {
    $getAcc->do8ike = '<td class="statusblock"><b>[SA]Destorm</b></font></center>';      
    }     
    elseif($getAcc->do8ike >= "") {
    $getAcc->do8ike = '<td class="statusok"><b>You have  gotten from anyone exclusion</b></font></center>';       
    } 
    
      echo'



        <tr>



        <th class="topLine">Login Status:</th>



        <b>'.$getAcc->status.'</td>



      </tr>
      
              <tr>



        <th class="topLine">Warning:</th>



        <b>'.$getAcc->warm.'</td>



      </tr>
      
      
      <tr>



        <th class="topLine">Reason for exclusion:</th>



        <b>'.$getAcc->logos.'</td>



      </tr>

      
      
      <tr>



        <th class="topLine">given by:</th>



        <b>'.$getAcc->do8ike.'</td>



      </tr> 
    </table>';



    



    echo'</div><div class="clear"></div>';



  }



  else 



  {



  ?>

        <h2>login</h2>

<form action="index.php?s=login" method="POST">

  <table>

    <tr>

      <th class="topLine">Username:</th>

      <td class="tdunkel"><input type="text" name="userid" maxlength="16" size="20"/></td>

    </tr>

    <tr>

      <th class="topLine">Passwort:</th>

      <td class="thell"><input type="password" name="userpass" maxlength="16" size="20"/></td>

    </tr>

    <tr>

      <td class="topLine" style="text-align:center;"  colspan="2"><input type="submit" name="submit"  value="Login"/></td>

    </tr>

  </table>

  <p><a href="index.php?s=register">register</a>  &bull; <a href="index.php?s=lostpw">Lost  password</a></p>

</form>

  <?PHP

  }

thanks

Deine Einrückungsregeln sind mir ein Rätsel, ist aber irrelevant.

Ich habe das Script schon mindestens 4x gesehen, für mich ist es nichts Neues.
Ebenfalls würde es mich interressierten warum du Klassen setzt, aber keine dazugehörige CSS Datei sharest.
Wenn du das proffessionell machen würdest, würdest du auf <b>- Tags verzichten und diese in CSS ausgeben lassen, außerdem schreibt man heute: >

<span style="font-weight: bold;"></span>

Ebenso unnötig dürfte das hier sein:
>

<td class="topLine" style="text-align:center;"....

Du gibst eine Klasse aus, aber benutzt direkt daneben CSS?

.topLine {
text-align: center;
}

Ist wohl nicht so schwer oder ?

Trotzdem danke fürs sharen, ich werde es allerdings nicht verwenden.
Thanks kriegst du aber trotzdem für deine Mühe.

[.Ultimate.]

Very useful!

[KilleRzZ™]

Originally Posted by .Ultimate.

Very useful!

thanks

[Sir-Kolonial]

Originally Posted by KilleRzZ™

Hello today i will release my ban addon is not so good but i will make it better by the time
screen:

 Spoiler

PHP:

 Spoiler

<?PHP
if(!empty($_SESSION['user_id']))

{

echo'<h2>Account Status</h2>';

echo'<div class="splitLeft">';

echo'<p>In this page you can see if you have take ban!</p> ';

echo'</div>';

echo'<div class="splitRight">';



$cmdStats = "SELECT SUM( player.playtime ) AS ges_spielzeit, COUNT( * ) AS ges_chars, player_index.empire

FROM player.player

INNER JOIN player.player_index ON player_index.id = player.account_id

WHERE player.account_id = '".$_SESSION['user_id']."'

LIMIT 1";



$qryStats = mysql_query($cmdStats,$sqlServ);

$getStats = mysql_fetch_object($qryStats);



if(!empty($getStats->empire)) {

$reich = '<img src="m2m.eikones/vaseilia/'.$getStats->empire.'.png" title="Βασίλειο" alt="Reich"/>';

}

else {

$reich='Dont selected kingdom';

}




echo'<center>';
echo'<table>

<tr>

<th class="topLine">Account:</th>

<td class="tdunkel"><b>'.$_SESSION['user_name'].'</td>

</tr>


';



$sqlAcc = "SELECT account.social_id AS loeschcode, logos, status, warm, do8ike, safebox.password AS lagerpw



FROM account.account



LEFT JOIN player.safebox



ON account.id=safebox.account_id



WHERE account.id='".$_SESSION['user_id']."'";







$qryAcc = mysql_query($sqlAcc) or die(mysql_error());



$getAcc = mysql_fetch_object($qryAcc);







if(empty($getAcc->lagerpw)) $getAcc->lagerpw = '000000';


if($getAcc->status >= "OK") {



$getAcc->status = '<td class="statusok"><b>Normal</b></font></center>'; }



if($getAcc->status >= "BLOCK") {

$getAcc->status = '<td class="statusblock"><b>Blocked</b></font></center>'; }

if($getAcc->warm >= "3") {
$getAcc->warm = '<td class="statusmelba"><b>You have 3 warnings</b></font></center>';
}
elseif($getAcc->warm >= "2") {
$getAcc->warm = '<td class="statusmelba"><b>You have 2 warnings</b></font></center>';
}
elseif($getAcc->warm >= "1") {
$getAcc->warm = '<td class="statusmelba"><b>You have 1 warning</b></font></center>';
}
elseif($getAcc->warm >= "") {
$getAcc->warm = '<td class="statusok"><b>You dont have warnings</b></font></center>';
}

if($getAcc->logos >= "3") {
$getAcc->logos = '<td class="statusmelba"><b>excessive swearing</b></font></center>';
}
elseif($getAcc->logos >= "2") {
$getAcc->logos = '<td class="statusmelba"><b>Advertising of another server</b></font></center>';
}
elseif($getAcc->logos >= "1") {
$getAcc->logos = '<td class="statusmelba"><b>Hacking</b></font></center>';
}
elseif($getAcc->logos >= "") {
$getAcc->logos = '<td class="statusok"><b>Has not been excluded from the game</b></font></center>';
}


if($getAcc->do8ike >= "3") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Ven</b></font></center>';
}
elseif($getAcc->do8ike >= "2") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Gracia</b></font></center>';
}
elseif($getAcc->do8ike >= "1") {
$getAcc->do8ike = '<td class="statusblock"><b>[SA]Destorm</b></font></center>';
}
elseif($getAcc->do8ike >= "") {
$getAcc->do8ike = '<td class="statusok"><b>You have gotten from anyone exclusion</b></font></center>';
}

echo'



<tr>



<th class="topLine">Login Status:</th>



<b>'.$getAcc->status.'</td>



</tr>

<tr>



<th class="topLine">Warning:</th>



<b>'.$getAcc->warm.'</td>



</tr>


<tr>



<th class="topLine">Reason for exclusion:</th>



<b>'.$getAcc->logos.'</td>



</tr>



<tr>



<th class="topLine">given by:</th>



<b>'.$getAcc->do8ike.'</td>



</tr>
</table>';







echo'</div><div class="clear"></div>';



}



else



{



?>

<h2>login</h2>

<form action="index.php?s=login" method="POST">

<table>

<tr>

<th class="topLine">Username:</th>

<td class="tdunkel"><input type="text" name="userid" maxlength="16" size="20"/></td>

</tr>

<tr>

<th class="topLine">Passwort:</th>

<td class="thell"><input type="password" name="userpass" maxlength="16" size="20"/></td>

</tr>

<tr>

<td class="topLine" style="text-align:center;" colspan="2"><input type="submit" name="submit" value="Login"/></td>

</tr>

</table>

<p><a href="index.php?s=register">register</a> &bull; <a href="index.php?s=lostpw">Lost password</a></p>

</form>

<?PHP

}

For do this script work 100% you have to add in mysql account.account 3 new tables with names:warm,logos,do8ike
after this you will change the numbers for example if you put warm 1 site will say:You have 1 warning

Dont forget to thanks <3 <3 if anyone want help then send me pm i will help

Its not your work noob Its the work of Alyx You know ?