Optimize code (mysqlquery and gdimage)
Posted: Wed Apr 07, 2004 6:27 pm
A code to be used a lot. Any hints for optimizing it's performance?
Code: Select all
<?php
# Includes etc, because this is not INCLUDED but linked!
$DBC1="x"; $DBC2="x"; $DBC3="x"; $DB="x";
include ("../../includes/functions/fetch_query.php");
$GameNumber = $_GET['gn'];
$kuva = imagecreate(256, 128);
$bgcolor = ImageColorAllocate($kuva, 255, 255, 255);
$v = fetch_query("select * from __nations");
while ($row = mysql_fetch_array($v, MYSQL_ASSOC))
{
$red = 100;
$green = 100;
$blue = 100;
$fg = $row['n_color'];
if( eregi( "[#]?([0-9a-f]{2})([0-9a-f]{2})([0-9a-f]{2})", $fg, $ret ) )
{
$red = hexdec( $ret[1] );
$green = hexdec( $ret[2] );
$blue = hexdec( $ret[3] );
}
ImageColorAllocate( $kuva, $red, $green, $blue );
}
$v = fetch_query("select * from g_{$GameNumber}_map");
while ($row = mysql_fetch_array($v, MYSQL_ASSOC))
{
$xx=$row['x'];
$yy=$row['y'];
$va[$xx][$yy] = $row['owner'];
}
for ($y = 1; $y <= 256; $y++)
{
for ($x = 1; $x <= 512; $x++)
{
#if (isset($va[$x][$y]))
# $var = $va[$x][$y];
# else
# $var = 0;
$var = $va[$x][$y]+1;
imagesetpixel ($kuva, $x/2-1, $y/2-1, $var);
}
}
Header("Content-type: image/png");
ImagePng($kuva);
ImageDestroy($kuva);
?>