Сирожиддин
Foydalauvchining albomidagi rasmlarni profilga chiqarish (JohnCMS 6.x.x versiyasida sinalgan)
  1. // LIMIT 8 - qancha rasmini chiqarmoqchi bo'lsangiz 8 orniga shu raqamni qo'ying.
  2. $album_rasmlari = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `user_id` = '" . $user['id'] . "'"), 0);
  3. echo '
  4. <div class="phdr">Shaxsiy rasmlar ' . ($album_rasmlari ? $album_rasmlari : '') . '</div>
  5. <div class="menu">';
  6. $fotoalbom = mysql_query("SELECT `id`, `user_id`, `album_id`, `img_name` FROM `cms_album_files` WHERE `user_id` = '" .$user['id']. "' ORDER BY `time` DESC LIMIT 8");
  7. $fotosurat = mysql_fetch_array($fotoalbom);
  8.  
  9. if (file_exists('../files/users/album/' . $user['id'] . '/' . $fotosurat['img_name'] . '')) {
  10. $fotoalbom = mysql_query("SELECT `id`, `user_id`, `album_id`, `img_name` FROM `cms_album_files` WHERE `user_id` = '" .$user['id']. "' ORDER BY `time` DESC LIMIT 8");
  11. while ($fotosurat = mysql_fetch_array($fotoalbom)) {echo '
  12. <a href="../users/album.php?act=show&amp;al=' . $fotosurat['album_id'] . '&amp;img=' . $fotosurat['id'] . '&amp;user=' . $fotosurat['user_id'] . '&amp;view">
  13. <img style="height: 80px;" src="../files/users/album/' . $fotosurat['user_id'] . '/' . $fotosurat['img_name'] . '" />
  14. </a>';
  15. }
  16. } else {
  17. echo '<bold>' .$user['name']. '</bold> fotoalbomiga fotosuratlar qo\'shmagan!';
  18. } echo '
  19. </div>'; //.menu
  20.  
  21. if ($user_id == $user['id']) {
  22. $shaxsiy_albom = mysql_fetch_assoc(mysql_query("SELECT * FROM `cms_album_cat` WHERE `user_id` = '".$user_id."' "));
  23. echo '
  24. <div class="menu">
  25. <a href="'.$set['homeurl'].'/users/album.php?act=image_upload&al='.$shaxsiy_albom['id'].'&user='.$user_id.'">Albomga rasm qo\'shish</a>
  26. <a href="'.$set['homeurl'].'//users/album.php?act=show&al='.$shaxsiy_albom['id'].'&user='.$user_id.'">Barcha rasmlar</a>
  27. </div>
  28. ';
  29. }