View file avatar.php

File size: 1.41Kb
  1. <?php
  2. include 'inc/db.php';
  3. include 'inc/1.php';
  4. if (!$user){
  5. header("Location: /index.php");
  6. exit;
  7. }
  8. if (!$_GET['avatar']){
  9. if (!$_GET['p'])$_GET['p']=1;
  10. $p=intval($_GET['p']);
  11. $q=mysql_query("SELECT `id` FROM `obmen` WHERE `ras` = 'jpg' OR `ras` = 'gif' OR `ras` = 'png' OR `ras` = 'bmp' OR `ras` = 'tif'");
  12. $start=($p*15-15);
  13. $qq=mysql_query("SELECT `id`, `time` FROM `obmen` WHERE `ras` = 'jpg' OR `ras` = 'gif' OR `ras` = 'png' OR `ras` = 'bmp' OR `ras` = 'tif' ORDER BY `time` DESC LIMIT $start, 15");
  14. $b=1;
  15. while ($f=mysql_fetch_assoc($qq)){
  16. $pp=($b%2);
  17. div("p$pp");
  18. echo "<a href='?avatar=$f[id]'><img src='obmen/$f[id].file' width='70'></a>";
  19. nodiv();
  20. $b++;
  21. }
  22. $q1=(mysql_num_rows($q)/15);
  23. $q2=round(mysql_num_rows($q)/15);
  24. if ($q1>$q2)$pages=($q2+1);
  25. else
  26. $pages=$q2;
  27. pages($pages, $p, "?p");
  28. }
  29. else
  30. {
  31. $ava=mysql_fetch_assoc(mysql_query("SELECT * FROM `obmen` WHERE `id` = '".intval($_GET['avatar'])."'"));
  32. if (mysql_num_rows(mysql_query("SELECT * FROM `obmen` WHERE `id` = '".intval($_GET['avatar'])."'"))==0){
  33. header("Location: /avatar.php");
  34. exit;
  35. }
  36. $b=(($ava['ras']=='jpg') || ($ava['ras']=='png') || ($ava['ras']=='gif') || ($ava['ras']=='bmp') || ($ava['ras']=='tif'));
  37. if (!$b){
  38. header("Location: /avatar.php");
  39. exit;
  40. }
  41. mysql_query("UPDATE `user` SET `avatar` = '".intval($_GET['avatar'])."' WHERE `id` = '$user[id]'");
  42. header("Location: /ank.php");
  43. exit;
  44. }
  45. include 'inc/foot.php';
  46. ?>