Avatarimage.php script

Quote:

---

Originally Posted by Akimbo

What's the poitn with that? Yeh, it does take more space! That must be the point.
The point with this is for fansites really. It's simple and easy. Still pretty secure.

---

It does save speed, though, but in light, it doesn't seem efficient if the person has changed their avatar. Caching is worth it.

Quote:

---

Originally Posted by Near

Not sure if ignorant or just real stupid... No point in caching? My CMS must suck now...

---

You are right Sir, I am stupid.

It might take up space, but i have a fairly small hotel, so not that much avatar's are cached in the long run.

PHP Code:

---

foreach ($_GET as $key => $value)
{
    $_GET[$key] = mysql_real_escape_string($value);
} 


---

Haha, nice script. Thankz nigga!

Quote:

---

Originally Posted by Nathandj

PHP Code:

---

foreach ($_GET as $key => $value)
{
    $_GET[$key] = mysql_real_escape_string($value);
} 


---

---

http_build_query does not require an loop.
plus its only a function (less code)

PHP Code:

---

http_build_query($_GET) 


---

Quote:

---

Originally Posted by joopie

2000*

But, you code something and you know it should return one result? :P "LIMIT 1" in query

---

Try and remove the while loop and see what's happening

Quote:

---

Originally Posted by Akimbo

Try and remove the while loop and see what's happening

---

Not remove it, replace it with a mysql_result /facepalm

Quote:

---

Originally Posted by Akimbo

Try and remove the while loop and see what's happening

---

:stupid:

PHP Code:

---

while($row = mysql_fetch_assoc($result)) 


---

To

PHP Code:

---

$row = mysql_fetch_assoc($result) 


---

/facepalm

Quote:

---

Originally Posted by joopie

:stupid:

PHP Code:

---

while($row = mysql_fetch_assoc($result)) 


---

To

PHP Code:

---

$row = mysql_fetch_assoc($result) 


---

/facepalm

---

Maybe it does not effect the performance but as the only thing he really gets from the database is the look. Wouldent it then be better with a mysql_result?

Like this:

PHP Code:

---

$look = mysql_result(mysql_query("SELECT look FROM users WHERE username = '" . $u . "'"), 0); 


---

Quote:

---

Originally Posted by joopie

:stupid:

PHP Code:

---

while($row = mysql_fetch_assoc($result)) 


---

To

PHP Code:

---

$row = mysql_fetch_assoc($result) 


---

/facepalm

---

I acctly tried that one, didn't work for me >.<
Edit: Parse error: syntax error, unexpected T_ECHO in avatarimage.php on line 20

Good job guy, but this script does not support the use HTML tags <img>, try the php document be interpreted as an image like mine: http://www.maniahotel.com.br/avatar?...ure=sml&size=b

Good job guy, but this script does not support the use HTML tags <img>, try the php document be interpreted as an image like mine:
http://www.maniahotel.com.br/avatar?...ure=sml&size=b

Quote:

---

Originally Posted by Akimbo

I acctly tried that one, didn't work for me >.<
Edit: Parse error: syntax error, unexpected T_ECHO in avatarimage.php on line 20

---

did you ever put an ; after the "$row = ...."???

If it matter, yes, i did.

Quote:

---

Originally Posted by MrCR

Good job guy, but this script does not support the use HTML tags <img>, try the php document be interpreted as an image like mine: http://www.maniahotel.com.br/avatar?...ure=sml&size=b

---

Something like this?:

PHP Code:

---

<?php
header("Content-Type: image/png");
?>
<?php
$dbhost = 'localhost'; 
$dbuser = 'root'; 
$dbpass = ''; 
$db = 'uber'; 

mysql_connect($dbhost,$dbuser,$dbpass);   
mysql_select_db($db);   
$action = mysql_real_escape_string( strip_tags( $_GET["action"] ) ); 
$direction = mysql_real_escape_string( strip_tags( $_GET["direction"] ) ); 
$head_direction = mysql_real_escape_string( strip_tags( $_GET["head_direction"] ) ); 
$gesture = mysql_real_escape_string( strip_tags( $_GET["gesture"] ) ); 
$size = mysql_real_escape_string( strip_tags( $_GET["size"] ) ); 
$u = mysql_real_escape_string( strip_tags( $_GET["user"] ) ); 
$userq = mysql_query("SELECT * FROM users WHERE username = '$u' LIMIT 1");
$user = mysql_fetch_array($userq);
$looks = $user['look'];
$image = imagecreatefrompng("stand.png");
$look = imagecreatefrompng("http://habbo.com/habbo-imaging/avatarimage?figure='.$looks.'&action=" . $action . "&direction=" . $direction . "&head_direction=" . $h_direction . "&gesture=" . $gesture . "&size=" . $size . "");
imagecopy($image, $look, 9, 10, 6, 13, 49, 94);


ImagePng ($look);
imagedestroy($look);        


// $result = mysql_query($query) or die('Query failed: ' . mysql_error()); //Okay
// if(mysql_num_rows($result)) { //thihi<3
// while($row = mysql_fetch_assoc($result)) { //resultat...
// echo "<img src=\"http://habbo.com/habbo-imaging/avatarimage?figure=".$row['look']."\" alt='".$row['username']."'>";
//        }
// }
?>

---