Znote AAC to Gesior AAC ?

[president vankk]

Hi everyone, I was searching and I found this script http://pastebin.com/raw.php?i=z7h0vyTm and I wonder know how I transform Znote AAC script to Gesior AAC?
Or maybe if someone can help me with creating a page like guildwar.php?warid=1 will be awesome, because I have no ideia to where start this code.

Thanks.

 

[Roga Foryn]

The ?warid=1 comes from $_GET['warid'].
$_GET['warid'] returns the value from warid=.
Then you need to get all needed information from this value.

 

[president vankk]

@Roga Foryn
I was trying make this, but a code without success.

<?php

####################################################################################
####################################### SQL ########################################
####################################################################################

$warFrags = array();
foreach($SQL->query('SELECT * FROM `guildwar_kills` ORDER BY `time` DESC')->fetchAll() as $frag)
{
   $warFrags[$frag['warid']][] = $frag;
}

$count = 0;

foreach($SQL->query('SELECT `guild_wars`.`id`, `guild_wars`.`guild1`, `guild_wars`.`guild2`, `guild_wars`.`name1`, `guild_wars`.`name2`, `guild_wars`.`status`, `guild_wars`.`started`, `guild_wars`.`ended`, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild1`) guild1_kills, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild2`) guild2_kills FROM `guild_wars` ORDER BY `started` DESC') as $war)
{

   $count++;
   if (!empty($_GET['warid'])) {
     $warid = (int)$_GET['warid']; // Sanitizing GET.
     $war = get_guild_war($warid);
     echo 'returns shit';
   }
}

if($count == 0)
   echo 'returns nothing';

?>

 

[Roga Foryn]

Send output back to me

<?php

####################################################################################
####################################### SQL ########################################
####################################################################################

$warFrags = array();
foreach($SQL->query('SELECT * FROM `guildwar_kills` ORDER BY `time` DESC')->fetchAll() as $frag)
{
   $warFrags[$frag['warid']][] = $frag;
    echo "Debug: ".$frag['warid'];
}

$count = 0;
echo "Debug: ".$war;
foreach($SQL->query('SELECT `guild_wars`.`id`, `guild_wars`.`guild1`, `guild_wars`.`guild2`, `guild_wars`.`name1`, `guild_wars`.`name2`, `guild_wars`.`status`, `guild_wars`.`started`, `guild_wars`.`ended`, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild1`) guild1_kills, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild2`) guild2_kills FROM `guild_wars` ORDER BY `started` DESC') as '$war' )
{
   $count++;
   if (!empty($_GET['warid'])) {
     $warid = (int)$_GET['warid']; // Sanitizing GET.
     $war = get_guild_war($warid);
     echo 'returns shit';
     echo "Debug: ".$war;
   }
}

if($count == 0) {
   echo 'returns nothing';
}
?>

 

[president vankk]

The debug returns nothing.

Anyone have some ideia to how make this script works?