inc_indexxxx.php 3.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. <?php
  2. CURSCRIPT != 'wap' && exit('FORBIDDEN');
  3. $perpage = $mobile_settings['mobiletopicperpage'] ? $mobile_settings['mobiletopicperpage'] : 10;
  4. $page = isset($_GET['page']) ? intval($_GET['page']) : '';
  5. $page = empty($page) ? 1 : $page;
  6. $orderby = ' ORDER BY a.begintime DESC';
  7. $param = setparams(array('mod'));
  8. $rows_num = $db->getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE (a.info_level = 1 OR a.info_level = 2) ' . $city_limit);
  9. $totalpage = ceil($rows_num / $perpage);
  10. $num = intval($page - 1) * $perpage;
  11. $idin = get_page_idin('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a ' . $s . ' WHERE (a.info_level = 1 OR a.info_level = 2) ' . $city_limit . $orderby, $perpage);
  12. $idin2 = $idin ? ' AND a.infoid IN (' . $idin . ') ' : '';
  13. $idin = $idin ? ' AND a.id IN (' . $idin . ') ' : '';
  14. $sql = 'SELECT a.*,b.areaname FROM ' . $db_mymps . 'information AS a LEFT JOIN `' . $db_mymps . 'area` AS b ON a.areaid=b.areaid WHERE 1 ' . $idin . ' ' . $orderby;
  15. $infolist = $idin ? $db->getAll($sql) : array();
  16. foreach ($infolist as $k => $row) {
  17. $arr['id'] = $row['id'];
  18. $arr['face'] = $row['face'];
  19. $arr['face'] = @strstr($arr['face'], 'http') ? $arr['face'] : $mymps_global['SiteUrl'] . $arr['face'];
  20. $arr['title'] = $row['title'];
  21. $arr['titlej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['title']) : $arr['title'];
  22. $arr['hit'] = $row['hit'];
  23. $arr['uri_m'] = mRewrite('info', array('id' => $row[id], 'dir_typename' => $row['dir_typename']));
  24. $arr['img_path'] = $row['img_path'];
  25. $arr['ifred'] = $row['ifred'];
  26. $arr['ifbold'] = $row['ifbold'];
  27. $arr['hit'] = $row['hit'];
  28. $arr['zan'] = intval($row['zan']);
  29. $arr['certify'] = $row['certify'];
  30. $arr['catname'] = $row['catname'];
  31. $arr['catnamej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['catname']) : $arr['catname'];
  32. $arr['areaname'] = $row['areaname'];
  33. $arr['areanamej'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['areaname']) : $arr['areaname'];
  34. $arr['tel'] = empty($cat['usecoin']) ? 'tel:' . $row['tel'] : $arr['uri_m'];
  35. $arr['img_count'] = $row['img_count'];
  36. $arr['upgrade_type_index'] = $row['upgrade_type_index'];
  37. $arr['userid'] = $row['userid'] ? $row['userid'] : $row['contact_who'];
  38. $arr['useridj'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['userid']) : $arr['userid'];
  39. $arr['content'] = $row['content'];
  40. $arr['contentj'] = cutstr(clear_html($row['content']), 50);
  41. $arr['contentj'] = $charset == 'gbk' ? iconv('gb2312', 'utf-8', $arr['contentj']) : $arr['contentj'];
  42. $arr['begintime'] = get_format_time($row['begintime']);
  43. $arr['endtime'] = $row['endtime'] ? $row['endtime'] : $timestamp;
  44. $info_list[$row['id']] = $arr;
  45. $ids .= $row['id'] . ',';
  46. if (0 < $row['upgrade_time_index'] && $row['upgrade_time_index'] < $timestamp) {
  47. $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_index = \'1\',upgrade_time_index = \'0\' WHERE id =\'' . $row['id'] . '\'');
  48. }
  49. }
  50. if ($idin2) {
  51. $iquery = $db->query('SELECT a.infoid,a.prepath FROM `' . $db_mymps . 'info_img` AS a WHERE 1 ' . $idin2);
  52. while ($r = $db->fetchRow($iquery)) {
  53. $info_list[$r['infoid']]['img'][] = $r['prepath'];
  54. }
  55. }
  56. if ($mayi) {
  57. $info_list = 5.4000000000000004 <= PHP_VERSION ? json_encode($info_list, JSON_UNESCAPED_SLASHES) : str_replace('\\/', '/', json_encode($info_list));
  58. echo $info_list;
  59. exit();
  60. }
  61. $seo = get_seoset();
  62. $mymps_global = array_merge($mymps_global, $seo);
  63. $loc = get_location_m('index');
  64. $page_title = $loc['page_title'];
  65. $count = array();
  66. $count['info'] = mymps_count('information');
  67. $count['store'] = mymps_count('member', ' WHERE if_corp = 1');
  68. include mymps_tpl('index');
  69. ?>