friendlink.php 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
  1. <?php
  2. //decode by http://dezend.qiling.org QQ 2859470
  3. define('CURSCRIPT', 'friendlink');
  4. require_once dirname(__FILE__) . '/global.php';
  5. require_once MYMPS_INC . '/db.class.php';
  6. $do = $do ? $do : 'link';
  7. switch ($do) {
  8. case 'link':
  9. $part = $part ? $part : 'list';
  10. $catid = isset($catid) ? intval($catid) : '';
  11. require_once MYMPS_INC . '/flink.fun.php';
  12. if ($part == 'list') {
  13. chk_admin_purview('purview_友情链接');
  14. $where = $ifindex ? ' WHERE ifindex = \'' . $ifindex . '\'' : ' WHERE 1';
  15. $where .= $catid ? ' AND ' . get_children($catid, 'catid') : '';
  16. $where .= $ischeck ? ' AND ischeck = \'' . $ischeck . '\'' : '';
  17. $rows_num = mymps_count('flink', $where);
  18. $param = setParam(array('do', 'part', 'ifindex', 'catid', 'ischeck'));
  19. $links = page1('SELECT * FROM ' . $db_mymps . 'flink ' . $where . ' ORDER BY ordernumber ASC');
  20. $here = '友情链接管理';
  21. $cats = $db->getAll('SELECT * FROM `' . $db_mymps . 'category` WHERE parentid = \'0\'');
  22. include mymps_tpl(CURSCRIPT . '_default');
  23. } else {
  24. if ($part == 'add') {
  25. chk_admin_purview('purview_增加链接');
  26. $here = '添加友情链接';
  27. $sql = 'SELECT * FROM ' . $db_mymps . 'flink_type ORDER BY id Asc';
  28. $links = $db->getAll($sql);
  29. include mymps_tpl(CURSCRIPT . '_add');
  30. } else {
  31. if ($part == 'insert') {
  32. $sql = 'Insert Into `' . $db_mymps . 'flink`(id,ifindex,catid,url,webname,weblogo,typeid,createtime,ischeck,ordernumber)' . "\r\n\t\t\t\t" . 'Values(\'\',\'' . $ifindex . '\',\'' . $catid . '\',\'' . $url . '\',\'' . $webname . '\',\'' . $weblogo . '\',\'' . $typeid . '\',\'' . $timestamp . '\',\'' . $ischeck . '\',\'' . $ordernumber . '\'); ';
  33. $res = $db->query($sql);
  34. clear_cache_files('friendlink');
  35. write_msg('添加友情链接 ' . $webname . ' 成功', '?part=list', 'mymps');
  36. } else {
  37. if ($part == 'edit') {
  38. $sql = 'SELECT * FROM ' . $db_mymps . 'flink WHERE id = \'' . $id . '\'';
  39. $link = $db->getRow($sql);
  40. $here = '编辑友情链接';
  41. include mymps_tpl(CURSCRIPT . '_edit');
  42. } else {
  43. if ($part == 'update') {
  44. if (empty($url) || empty($webname)) {
  45. write_msg('请输入完整信息');
  46. exit;
  47. }
  48. $sql = 'UPDATE ' . $db_mymps . 'flink SET webname=\'' . $webname . '\',weblogo=\'' . $weblogo . '\',url=\'' . $url . '\',ordernumber=\'' . $ordernumber . '\',createtime=\'' . $timestamp . '\',ifindex=\'' . $ifindex . '\',catid=\'' . $catid . '\',ischeck=\'' . $ischeck . '\',msg=\'' . textarea_post_change($msg) . '\',name=\'' . $name . '\',qq=\'' . $qq . '\',email=\'' . $email . '\',typeid=\'' . $typeid . '\',dayip=\'' . $dayip . '\',pr=\'' . $pr . '\' WHERE id = \'' . $id . '\'';
  49. $res = $db->query($sql);
  50. clear_cache_files('friendlink');
  51. write_msg('编辑链接 ' . $webname . ' 成功', '?part=edit&id=' . $id, 'mymps');
  52. } else {
  53. if ($part == 'delete') {
  54. if (empty($id)) {
  55. write_msg('没有选择记录');
  56. }
  57. mymps_delete('flink', 'WHERE id = \'' . $id . '\'');
  58. clear_cache_files('friendlink');
  59. write_msg('删除友情链接 ' . $id . ' 成功', 'friendlink.php');
  60. } else {
  61. if ($part == 'doall') {
  62. if (is_array($ordernumber)) {
  63. foreach ($ordernumber as $korder => $value) {
  64. $db->query('UPDATE `' . $db_mymps . 'flink` SET ordernumber = \'' . $value . '\' WHERE id = \'' . $korder . '\'');
  65. }
  66. }
  67. if (is_array($ids)) {
  68. if (in_array($do_action, array('index', 'inside', 'del', 'check1', 'check2'))) {
  69. if ($do_action == 'index') {
  70. $db->query('UPDATE `' . $db_mymps . 'flink` SET ifindex = \'2\' WHERE ' . create_in($ids, 'id'));
  71. } else {
  72. if ($do_action == 'inside') {
  73. $db->query('UPDATE `' . $db_mymps . 'flink` SET ifindex = \'1\' WHERE ' . create_in($ids, 'id'));
  74. } else {
  75. if ($do_action == 'del') {
  76. $db->query('DELETE FROM `' . $db_mymps . 'flink` WHERE ' . create_in($ids, 'id'));
  77. } else {
  78. if ($do_action == 'check1') {
  79. $db->query('UPDATE `' . $db_mymps . 'flink` SET ischeck = \'1\' WHERE ' . create_in($ids, 'id'));
  80. } else {
  81. if ($do_action == 'check2') {
  82. $db->query('UPDATE `' . $db_mymps . 'flink` SET ischeck = \'2\' WHERE ' . create_in($ids, 'id'));
  83. }
  84. }
  85. }
  86. }
  87. }
  88. }
  89. }
  90. $return_url = $return_url ? $return_url : '?do=link&part=list';
  91. clear_cache_files('friendlink');
  92. write_msg('友情链接更新成功!', $return_url, 'mymps');
  93. }
  94. }
  95. }
  96. }
  97. }
  98. }
  99. }
  100. break;
  101. case 'type':
  102. $part = $part ? $part : 'list';
  103. $here = '<b>网站类型管理</b>';
  104. if ($part == 'list') {
  105. $sql = 'SELECT * FROM ' . $db_mymps . 'flink_type ORDER BY id Asc';
  106. $links = $db->getAll($sql);
  107. include mymps_tpl(CURSCRIPT . '_type');
  108. } else {
  109. if ($part == 'insert') {
  110. $typename = trim($typename);
  111. $sql = 'Insert Into `' . $db_mymps . 'flink_type`(id,typename)' . "\r\n\t\t\t\t" . 'Values(\'\',\'' . $typename . '\');';
  112. $res = $db->query($sql);
  113. write_msg('添加网站分类 ' . $typename . ' 成功', '?do=type', 'mymps');
  114. } else {
  115. if ($part == 'update') {
  116. $typename = trim($_POST['typename']);
  117. $sql = 'UPDATE ' . $db_mymps . 'flink_type SET typename=\'' . $typename . '\' WHERE id = \'' . $id . '\'';
  118. $res = $db->query($sql);
  119. write_msg('分类 ' . $typename . ' 更改成功', '?do=type&part=edit&id=' . $id, 'mymps');
  120. } else {
  121. if ($part == 'delete') {
  122. if (empty($id)) {
  123. write_msg('没有选择记录');
  124. } else {
  125. mymps_delete('flink_type', 'WHERE id = \'' . $id . '\'');
  126. write_msg('删除分类 ' . $id . ' 成功', '?do=type', 'mymps');
  127. }
  128. }
  129. }
  130. }
  131. }
  132. break;
  133. }
  134. is_object($db) && $db->Close();
  135. $db = $mymps_global = $part = $action = $here = NULL;