Tutorial: Gesior .phps to Modern

[kito2]

Credits to tatu hunter

You have to add an 'echo $main_content;' at bottom of the script or change all $main_content .= to echo/print

And at the top of the script add:

require("config.php");
$ots = POT::getInstance();
$ots->connect(POT:B_MYSQL, connection());
$SQL = $ots->getDBHandle();

Example:

 <?PHP 
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = $ots->getDBHandle();

//////////////////
/// CREATED BY ///
///   SAMME    ///
/// AND EDITED ///
//// BY MINDEZ ///
/////  FROM  /////
/// OTLAND.NET ///
//////////////////

//Please respect the copyrights!//
$ban_reason = array("Offensive Name", "Invalid Name Format", "Unsuitable Name", "Name Inciting Rule Violation", "Offensive Statement", "Spamming", "Illegal Advertising", "Off-Topic Public Statement", "Non-English Public Statement", "Inciting Rule Violation", "Bug Abuse", "Game Weakness Abuse", "Using Unofficial Software to Play", "Hacking", "Multi-Clienting", "Account Trading or Sharing", "Threatening Gamemaster", "Pretending to Have Influence on Rule Enforcer", "False Report to Gamemaster", "Destructive Behaviour", "Excessive Unjustified Player Killing", "Invalid Payment", "Spoiling Auction");

$players_banned = $SQL->query('SELECT `bans`.`value`, `bans`.`comment`, `bans`.`admin_id`, `bans`.`expires`, `bans`.`added`, `bans`.`reason` FROM `bans`, `players` WHERE `players`.`account_id` = `bans`.`value` AND `bans`.`type` = 3 AND `bans`.`active` = 1 GROUP BY `bans`.`value` ORDER BY `bans`.`added` DESC')->fetchAll();
if(!$players_banned) $main_content .= "There are currently no players banned.";
else{
    $number_of_players = 0;        
    foreach($players_banned as $player) {
        $nick = $SQL->query("SELECT name, id, level, account_id FROM `players` WHERE account_id =".$player['value']." ORDER BY level DESC LIMIT 1")->fetch(); 
        $gmnick = $SQL->query("SELECT name, id FROM `players` WHERE id =".$player['admin_id']."")->fetch(); 
        
        if($player['admin_id'] > "1")
            $banby = "<a href=?subtopic=characters&name=$gmnick[0]><font color ='green'>$gmnick[0]</font></a>";
        else
            $banby = "Auto Ban";
            
        $number_of_players++;
        
        if(is_int($number_of_players / 2))
            $bgcolor = $config['site']['darkborder'];
        else
            $bgcolor = $config['site']['lightborder'];
        
        if ($player['expires'] == -1) // If the banishment is permanent
            $expires = "PERMANENT";
        else
            $expires = date("d/m/Y, G:i:s", $player['expires']);
        
            
        $players_rows .= '<TR BGCOLOR='.$bgcolor.'><TD WIDTH=15%><A HREF="?subtopic=characters&name='.$nick['name'].'">'.$nick['name'].'</A></TD><TD WIDTH=5%><font color ="red">'.$ban_reason[$player['reason']].'</font></TD><TD WIDTH=20%>'.$player['comment'].'</TD><TD>'.$banby.'</TD><TD>'.date("d/m/Y, G:i:s", $player['added']).'</TD><TD>'.$expires.'</TD></TR>';
    }
    //list of players
    $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b><center>Banned Player</center></b></TD><TD class="white"><b><center>Reason</center></b></TD><TD class="white"><b><center>Comment</center></b></TD><TD class="white"><b><center>Banned By</center></b></TD><TD class="white"><b><center>Added</center></b></TD><TD class="white"><b><center>Expires</center></b></TD></TR>'.$players_rows.'</TABLE>';
}
    //COPY RIGHTS!! DO NOT DELETE!
    $main_content .= '<br/><p align="right">Scripted by <B>Samme</B><br>Improved by <B>Mindez</B></p>';
    
echo $main_content;
?>

 

[hodleo]

$ots = POT::getInstance();
$ots->connect(POT:B_MYSQL, connection());
$SQL = $ots->getDBHandle();[/B]

only needed when values from database are required
for ex. addons page

 

[kito2]

Thanks for that tip.

 

[stian]

Please use the ModernAAC database handler instead of POTs. That'll save us an entier DB connection (or we should atleast rewrite POT to use ModernAACs).

 

[Slain]

thanks for this very useful information.

 

[kito2]

Please use the ModernAAC database handler instead of POTs. That'll save us an entier DB connection (or we should atleast rewrite POT to use ModernAACs).

You mean that those script are vulnerable with that little fix?

thanks for this very useful information.

Yvw

 

[Debian]

If.
You have to divide the code in functions or classes for every request to the database

 

[kito2]

Bumping thread -- nice guide.

 

[troja]

You need to edit links also, "?subtopic="~ to modern aac.

 

[kito2]

You are right... I changed them all also xD

 

[kito2]

Bump thread.