comment.php 5.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192
  1. <?php
  2. //decode by http://dezend.qiling.org QQ 2859470
  3. define('CURSCRIPT', 'comment');
  4. require_once dirname(__FILE__) . '/global.php';
  5. require_once MYMPS_INC . '/db.class.php';
  6. $part = $part ? trim($part) : 'information';
  7. $action = $action ? trim($action) : 'list';
  8. $id = isset($id) ? $id : '';
  9. if (!in_array($part, array('information', 'news', 'coupon', 'group'))) {
  10. $part = 'information';
  11. }
  12. if ($part == 'news') {
  13. chk_admin_purview('purview_新闻评论');
  14. }
  15. if ($action == 'del') {
  16. if (empty($id)) {
  17. write_msg('无效的评论参数提交!');
  18. }
  19. $db->query('DELETE FROM `' . $db_mymps . 'comment` WHERE id = \'' . $id . '\' AND type = \'' . $part . '\'');
  20. write_msg('成功删除编号为' . $id . '的网友评论', 'comment.php?part=' . $part, 'Mymps');
  21. } else {
  22. if ($action == 'delall') {
  23. if (!is_array($id)) {
  24. write_msg('您没有选中任何记录!');
  25. }
  26. $db->query('DELETE FROM `' . $db_mymps . 'comment` WHERE id ' . create_in($id) . ' AND type = \'' . $part . '\'');
  27. write_msg('批量删除网友评论成功!', 'comment.php?part=' . $part, 'write_record');
  28. } else {
  29. if ($action == 'level0') {
  30. if (!is_array($id)) {
  31. write_msg('您没有选中任何记录!');
  32. }
  33. foreach ($id as $k => $v) {
  34. $db->query('UPDATE `' . $db_mymps . 'comment` SET comment_level = 0 WHERE id = \'' . $v . '\' AND type = \'' . $part . '\'');
  35. }
  36. write_msg('更新评论状态为 待审状态 操作成功!', 'comment.php?part=' . $part, 'RECORD');
  37. } else {
  38. if ($action == 'level1') {
  39. if (!is_array($id)) {
  40. write_msg('您没有选中任何记录!');
  41. }
  42. foreach ($id as $k => $v) {
  43. $db->query('UPDATE `' . $db_mymps . 'comment` SET comment_level = 1 WHERE id = \'' . $v . '\' AND type = \'' . $part . '\'');
  44. }
  45. write_msg('更新评论状态为 正常状态 操作成功!', 'comment.php?part=' . $part, 'RECORD');
  46. } else {
  47. if ($action == 'list') {
  48. $admindir = getcwdOL();
  49. $comment_level = isset($comment_level) ? intval($comment_level) : '';
  50. require_once MYMPS_DATA . '/info.level.inc.php';
  51. $part_arr = array('information' => '信息评论', 'news' => '新闻评论', 'group' => '团购评论', 'coupon' => '优惠券评论');
  52. $here = $part_arr[$part];
  53. unset($part_arr);
  54. $where = ' WHERE type = \'' . $part . '\' ';
  55. $where .= $keywords != '' ? ' AND a.content LIKE \'%' . $keywords . '%\'' : '';
  56. $where .= $commment_level != '' ? ' AND a.comment_level = \'0\'' : '';
  57. $sql = 'SELECT a.id,a.userid,a.content,a.pubtime,a.ip,a.typeid,a.type,b.title,a.comment_level FROM `' . $db_mymps . 'comment` AS a LEFT JOIN `' . $db_mymps . $part . '` AS b ON a.typeid = b.id ' . $where . ' ORDER BY a.pubtime DESC';
  58. $rows_num = $db->getOne('SELECT COUNT(*) FROM `' . $db_mymps . 'comment` AS a ' . $where);
  59. $param = setParam(array('part', 'keywords', 'comment_level'));
  60. $comment = array();
  61. foreach (page1($sql) as $k => $row) {
  62. $arr['id'] = $row['id'];
  63. $arr['content'] = $row['content'];
  64. switch ($part) {
  65. case 'information':
  66. $arr['title'] = '<a href=../information.php?id=' . $row[typeid] . ' target=_blank>' . $row[title] . '</a>';
  67. break;
  68. case 'news':
  69. $arr['title'] = '<a href=../news.php?id=' . $row[typeid] . ' target=_blank>' . $row[title] . '</a>';
  70. break;
  71. case 'group':
  72. $arr['title'] = '<a href=../group.php?id=' . $row[infoid] . ' target=_blank>' . $row[title] . '</a>';
  73. break;
  74. case 'coupon':
  75. $arr['title'] = '<a href=../coupon.php?id=' . $row[infoid] . ' target=_blank>' . $row[title] . '</a>';
  76. break;
  77. }
  78. $arr['userid'] = $row[userid] ? '<a href="javascript:void(0);" onclick="' . "\r\n" . 'setbg(\'Mymps会员中心\',400,110,\'../box.php?part=member&userid=' . $row['userid'] . '&admindir=' . $admindir . '\')">' . $row[userid] . '</a>' : $row[ip];
  79. $arr['pubtime'] = GetTime($row['pubtime']);
  80. $arr['ip'] = $row['ip'];
  81. $arr['comment_level'] = $information_level[$row[comment_level]];
  82. $comment[] = $arr;
  83. }
  84. include mymps_tpl('comment');
  85. }
  86. }
  87. }
  88. }
  89. }
  90. is_object($db) && $db->Close();
  91. $db = $mymps_global = $part = $action = $here = NULL;