[PHP] Showing Namelock.

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

 

[kito2]

Bump!

 

[kito2]

Someone pleaseee!

 

[QuaS]

show it where? characters.php?

 

[kito2]

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

 

[QuaS]

$limit=50;
$a = $SQL->query("select * from player_namelocks DESC date LIMIT ".$limit.";")->fetchAll();
echo("<table><tr><td>Old Name</td><td>New Name</td></tr>
foreach($a as $each) do
echo("<tr><td>".$each["name"]."</td><td>".$each["new_name"]."</td></tr>");
echo("</table>");

 

[kito2]

Parse error: syntax error, unexpected '>' in D:\mtibia\xampp\htdocs\namelocks.php on line 7

Line 7: echo("<tr><td>".$each["name"]."</td><td>".$each["new_name"]."</td></tr>");

<?PHP

$limit=50;
$a = $SQL->query("select * from player_namelocks DESC date LIMIT ".$limit.";")->fetchAll();
echo("<table><tr><td>Old Name</td><td>New Name</td></tr>
foreach($a as $each) do
echo("<tr><td>".$each["name"]."</td><td>".$each["new_name"]."</td></tr>");
echo("</table>");  

?>

 

[StreamSide]

lool change the echos!

 

[kito2]

I don't understand that, how?

 

[kito2]

Bump!

 

[Jano]

echo( ... ) -> $main_content .= " ... ";