[PHP] Showing Namelocks.

[kito2]

Hi there, well... There is a table called player_namelocks with the columns player_id, name, new_name, date... I was thinking how about a php for gesior that show how has changed his name and to which one?

Anyone?

PD: Just like any other php, just show a table: Old Name - New Name, and a list down with pages.

 

[kito2]

Bump?

 

[Aleh]

<?PHP
$zap = $SQL->query('SELECT `player_namelocks`.`player_id`, `player_namelocks`.`name`, `player_namelocks`.`new_name`, `player_namelocks`.`date`, `players`.`id`  FROM `player_namelocks`, `players` WHERE `player_namelocks`.`player_id` = `players`.`id`; ');
	foreach($zap as $namelock) {
		$players++;
		$number++;
			 if(is_int($players / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
		$content .= '<TR BGCOLOR='.$bgcolor.'><TD>'.$number.'.</TD><TD>'.$namelock['name'].'</TD><TD><a href="?subtopic=characters&name='.urlencode($namelock['new_name']).'">'.$namelock['new_name'].'</a></TD><TD>'.date("d.m.Y, G:i:s", $namelock['date']).'</TD>';
		}
	$main_content .= '<center><hr/><b>Namelock on '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=1%><b>#</b></TD><TD CLASS=white WIDTH=32%><b>Old name</b></TD><TD CLASS=white WIDTH=32%><b>New name</b></TD><TD CLASS=white WIDTH=32%><b>Date</b></TD></TR>'.$content.'</TABLE>';
$main_content .= '<div align="right"><small><b>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';

?>

Working?

 

[Jano]

<?PHP
$zap = $SQL->query('SELECT `player_namelocks`.`player_id`, `player_namelocks`.`name`, `player_namelocks`.`new_name`, `player_namelocks`.`date`, `players`.`id`  FROM `player_namelocks`, `players` WHERE `player_namelocks`.`player_id` = `players`.`id`; ');
    foreach($zap as $namelock) {
        $players++;
        $number++;
             if(is_int($players / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
        $content .= '<TR BGCOLOR='.$bgcolor.'><TD>'.$number.'.</TD><TD>'.$namelock['name'].'</TD><TD><a href="?subtopic=characters&name='.urlencode($namelock['new_name']).'">'.$namelock['new_name'].'</a></TD><TD>'.date("d.m.Y, G:i:s", $namelock['date']).'</TD>';
        }
    $main_content .= '<center><hr/><b>Namelock on '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=1%><b>#</b></TD><TD CLASS=white WIDTH=32%><b>Old name</b></TD><TD CLASS=white WIDTH=32%><b>New name</b></TD><TD CLASS=white WIDTH=32%><b>Date</b></TD></TR>'.$content.'</TABLE>';
$main_content .= '<div align="right"><small><b>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';

?>

Working?

-->        foreach($zap as $namelock) {
            $players++;
            $number++;
            if(is_int($players / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
                
                $content .= '<TR BGCOLOR='.$bgcolor.'>
        
        
        

        
-->        foreach ($zap as $k=>$namelock) {
            $content .= '
                <TR BGCOLOR=\"".$config['site'][($k % 2 == 1 ? 'light' : 'dark').'border']."\">
        
        ...

comeon stop those sucky codes

 

[kito2]

<?PHP
$zap = $SQL->query('SELECT `player_namelocks`.`player_id`, `player_namelocks`.`name`, `player_namelocks`.`new_name`, `player_namelocks`.`date`, `players`.`id`  FROM `player_namelocks`, `players` WHERE `player_namelocks`.`player_id` = `players`.`id`; ');
	foreach($zap as $namelock) {
		$players++;
		$number++;
			 if(is_int($players / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
		$content .= '<TR BGCOLOR='.$bgcolor.'><TD>'.$number.'.</TD><TD>'.$namelock['name'].'</TD><TD><a href="?subtopic=characters&name='.urlencode($namelock['new_name']).'">'.$namelock['new_name'].'</a></TD><TD>'.date("d.m.Y, G:i:s", $namelock['date']).'</TD>';
		}
	$main_content .= '<center><hr/><b>Namelock on '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=1%><b>#</b></TD><TD CLASS=white WIDTH=32%><b>Old name</b></TD><TD CLASS=white WIDTH=32%><b>New name</b></TD><TD CLASS=white WIDTH=32%><b>Date</b></TD></TR>'.$content.'</TABLE>';
$main_content .= '<div align="right"><small><b>Author of script: <a href="http://otland.net/members/aleh/">Aleh</a></b></small></div><br />';

?>

Working?

Thanks it works, can you make with pages and max of X players?
And also I need to order it by desc time.

'SELECT  `player_namelocks`.`player_id` ,  `player_namelocks`.`name` ,  `player_namelocks`.`new_name` ,  `player_namelocks`.`date` ,  `players`.`id` 
FROM  `player_namelocks` ,  `players` 
WHERE  `player_namelocks`.`player_id` =  `players`.`id` 
ORDER BY  `player_namelocks`.`date` DESC 
LIMIT 0 , 1000 '

PS: Repped.

 

[kito2]

Bump?

 

[kito2]

Bump!