DjHuSo
BestMaker, # BestMaker (09.02.2018 / 17:56)
news kommentga Qo'shilaman qo'shilmayman modulini kimda bor?


  1. view.php ga $post dan keyin.
  2.  
  3. if ($user_id != $row['user_id'])
  4. echo '
  5. <div class="ovoz_berish">
  6. <a href="/news/index.php?act=comments&mod=yoqdi&id=' . $id . '&com=' . $row['mid'] . '" class="green">
  7. <img width="18" src="http://fc-arsenal.uz/images/smileys/user/emoji/thumbsup.png"/> Qo\'shilaman
  8. <span class="yoqd1i">(' . ($row['yoqdi'] == '' ? '0' : $row['yoqdi']) . ')</span>
  9. </a> |
  10. <a href="/news/index.php?act=comments&mod=yoqmadi&id=' . $id . '&com=' . $row['mid'] . '" class="red">
  11. <img width="18" src="http://fc-arsenal.uz/images/smileys/user/emoji/thumbsdown.png"/> Qarshiman
  12. <span class="yoqmadi1">(' . ($row['yoqmadi'] == '' ? '0' : $row['yoqmadi']) . ')</span>
  13. </a>
  14. </div>';
  15. else
  16. echo '
  17. <div class="ovoz_berish">
  18. <a class="green">
  19. <img width="18" src="http://fc-arsenal.uz/images/smileys/user/emoji/thumbsup.png"/> Qo\'shilganlar
  20. <span class="yoqd1i">(' . ($row['yoqdi'] == '' ? '0' : $row['yoqdi']) . ')</span>
  21. </a> |
  22. <a class="red">
  23. <img width="18" src="http://fc-arsenal.uz/images/smileys/user/emoji/thumbsdown.png"/> Qarshilar
  24. <span class="yoqmadi1">(' . ($row['yoqmadi'] == '' ? '0' : $row['yoqmadi']) . ')</span>
  25. </a>
  26. </div>';
  27. comments.php dagi default: dan oldin.
  28. case 'yoqdi':
  29. $q = mysql_fetch_assoc(mysql_query("SELECT * FROM `cms_news_comments` WHERE `id`='$com' LIMIT 1;"));
  30. if ($q['ovoz_berdi_id'] != $user_id) {
  31. $_SESSION['id'] = $id;
  32. mysql_query('UPDATE `cms_news_comments` SET `yoqdi`="' . ($q['yoqdi'] ? ++$q['yoqdi'] : 1) . '" WHERE `id`=' . $com);
  33. mysql_query('UPDATE `cms_news_comments` SET `ovoz_berdi_id`="' .$user_id. '" WHERE `id`=' . $com);
  34. echo '<div class="gmenu">Izoha ovoz berdigiz <a href="../news/index.php?act=view&id=' . $id. '#comments">Yangilikga qaytish</a></div>';
  35. } else {
  36. echo '<div class="gmenu">Siz bu izohga <b>Ijobiy</b> ovoz bergansiz. <a href="../news/index.php?act=view&id=' . $id. '#comments">Yangilikga qaytish</a></div>';
  37. }
  38. //Header('Location: ../news/index.php?act=view&id=' . $id);
  39. break;
  40. case 'yoqmadi':
  41. $q = mysql_fetch_assoc(mysql_query("SELECT * FROM `cms_news_comments` WHERE `id`='$com' LIMIT 1;"));
  42. if ($q['ovoz_berdi_id'] != $user_id) {
  43. $_SESSION['id'] = $id;
  44. mysql_query('UPDATE `cms_news_comments` SET `yoqmadi`="' . ($q['yoqmadi'] ? ++$q['yoqmadi'] : 1) . '" WHERE `id`=' . $com);
  45. echo '<div class="gmenu"Izohga <b>Salbiy</b> ovoz berdingiz. <a href="../news/index.php?act=view&id=' . $id. '#comments">Yangilikga qaytish</a></div>';
  46. mysql_query('UPDATE `cms_news_comments` SET `ovoz_berdi_id`="' .$user_id. '" WHERE `id`=' . $com);
  47. } else {
  48. echo '<div class="gmenu">Siz bu postga <b>Salbiy</b> ovoz bergansiz. <a href="../news/index.php?act=view&id=' . $id. '#comments">Yangilikga qaytish</a></div>';
  49. }
  50. //Header('Location: ../news/index.php?act=view&id=' . $id);
  51. break;

Bazga yuboramiz:

  1. ALTER TABLE `cms_news_comments` ADD COLUMN
  2. (
  3. `yoqdi` INT(11) UNSIGNED NOT NULL,
  4. `yoqmadi` INT(11) UNSIGNED NOT NULL,
  5. `ovoz_berdi_id` INT(11) UNSIGNED NOT NULL
  6. ) ;