index.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223
  1. <?php
  2. define('IN_SMT', true);
  3. define('IN_MYMPS', true);
  4. define('CURSCRIPT', 'index');
  5. require_once dirname(__FILE__) . '/include/global.php';
  6. require_once MYMPS_DATA . '/config.php';
  7. require_once MYMPS_DATA . '/config.db.php';
  8. require_once MYMPS_INC . '/db.class.php';
  9. ifsiteopen();
  10. runcron();
  11. $mayimobile = get_mobile_settings();
  12. $mayimobile['mobiledomain'] = $mayimobile['mobiledomain'] ? $mayimobile['mobiledomain'] : $mymps_global['SiteUrl'] . '/m';
  13. $mayimobile['mobileuri'] = $mayimobile['mobiledomain'];
  14. if ($ifmobile) {
  15. write_msg('', $mayimobile['mobileuri']);
  16. exit;
  17. }
  18. $cache = get_cache_config();
  19. require_once MYMPS_INC . '/cachepages.class.php';
  20. $cachepages = new cachepages($cache['site']['time'], 'index');
  21. $cachetime = 0 < $cache['site']['time'] ? true : false;
  22. $cachepages->cacheCheck();
  23. unset($cache);
  24. $tpl_index = get_tpl_index();
  25. $tpl_index = $tpl_index['tpl_set'];
  26. $seo = get_seoset();
  27. $mymps_global = array_merge($mymps_global, $seo);
  28. $loc = get_location('index');
  29. $location = $loc['location'];
  30. $page_title = $loc['page_title'];
  31. $advertisement = get_advertisement('index');
  32. $adveritems = $advertisement['items'];
  33. $advertisement['type'] = $advertisement['all'] ? is_array($advertisement['type']) ? array_merge($advertisement['all']['type'], $advertisement['type']) : $advertisement['all']['type'] : $advertisement['type'];
  34. $about['friendlink_uri'] = $mymps_global['SiteUrl'] . Rewrite('about', array('part' => 'friendlink'));
  35. if ($tpl_index['banmian'] == 'portal') {
  36. $index_cat = get_categories_tree(0, 'category');
  37. if (ifplugin('group')) {
  38. require_once MYMPS_ROOT . '/plugin/group/include/functions.php';
  39. $groups = mymps_get_groups(3);
  40. $groupclass = get_group_class();
  41. }
  42. if (ifplugin('goods')) {
  43. require_once MYMPS_ROOT . '/plugin/goods/include/functions.php';
  44. $goods = mymps_get_goods($tpl_index['goods'], 1);
  45. }
  46. $in = $tpl_index['portal']['ershou'] . ',' . $tpl_index['portal']['zhaopin'] . ',' . $tpl_index['portal']['ershoufang'] . ',' . $tpl_index['portal']['jianli'] . ',' . $tpl_index['portal']['zufang'];
  47. if ($query = $db->query('SELECT catid,dir_typename FROM `' . $db_mymps . 'category` WHERE catid IN(' . $in . ')')) {
  48. while ($row = $db->fetchRow($query)) {
  49. $hd[$row['catid']]['dir_typename'] = $row['dir_typename'];
  50. }
  51. }
  52. $portaluri['moreershou'] = Rewrite('category', array('catid' => $tpl_index['portal']['ershou'], 'dir_typename' => $hd[$tpl_index['portal']['ershou']]['dir_typename']));
  53. $portaluri['catidershou'] = $tpl_index['portal']['ershou'];
  54. $portaluri['morezufang'] = Rewrite('category', array('catid' => $tpl_index['portal']['zufang'], 'dir_typename' => $hd[$tpl_index['portal']['zufang']]['dir_typename']));
  55. $portaluri['catidzufang'] = $tpl_index['portal']['zufang'];
  56. $portaluri['postzhaopin'] = $mymps_global['cfg_postfile'] . '?catid=' . $tpl_index['portal']['zhaopin'];
  57. $portaluri['morezhaopin'] = Rewrite('category', array('catid' => $tpl_index['portal']['zhaopin'], 'dir_typename' => $hd[$tpl_index['portal']['zhaopin']]['dir_typename']));
  58. $portaluri['catidzhaopin'] = $tpl_index['portal']['zhaopin'];
  59. $portaluri['moreershoufang'] = Rewrite('category', array('catid' => $tpl_index['portal']['ershoufang'], 'dir_typename' => $hd[$tpl_index['portal']['ershoufang']]['dir_typename']));
  60. $portaluri['catidershoufang'] = $tpl_index['portal']['ershoufang'];
  61. $portaluri['morejianli'] = Rewrite('category', array('catid' => $tpl_index['portal']['jianli'], 'dir_typename' => $hd[$tpl_index['portal']['jianli']]['dir_typename']));
  62. $portaluri['catidjianli'] = $tpl_index['portal']['jianli'];
  63. $arr = '';
  64. $zhaopin = array();
  65. $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.dir_typename,g.' . $tpl_index[portali][company] . ' FROM `' . $db_mymps . 'information` AS a LEFT JOIN `' . $db_mymps . 'information_' . $tpl_index[portal][zhaopinmod] . '` AS g ON a.id = g.id WHERE ' . get_children($tpl_index[portal][zhaopin]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,12');
  66. while ($row = $db->fetchRow($query)) {
  67. $arr['id'] = $row['id'];
  68. $arr['title'] = $row['title'];
  69. $arr['ifred'] = $row['ifred'];
  70. $arr['ifbold'] = $row['ifbold'];
  71. $arr[$tpl_index['portali']['company']] = $row[$tpl_index['portali']['company']];
  72. $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
  73. $zhaopin[$row['id']] = $arr;
  74. }
  75. $arr = '';
  76. $jianli = array();
  77. $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.contact_who,a.dir_typename FROM `' . $db_mymps . 'information` AS a WHERE ' . get_children($tpl_index[portal][jianli]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,4');
  78. if ($query) {
  79. while ($row = $db->fetchRow($query)) {
  80. $arr['id'] = $row['id'];
  81. $arr['title'] = $row['title'];
  82. $arr['ifred'] = $row['ifred'];
  83. $arr['ifbold'] = $row['ifbold'];
  84. $arr['contact_who'] = $row['contact_who'];
  85. $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
  86. $jianli[$row['id']] = $arr;
  87. }
  88. }
  89. $arr = '';
  90. $esf = array();
  91. $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.img_path,a.dir_typename,g.' . $tpl_index[portali][acreage] . ',g.' . $tpl_index[portali][prices] . ' FROM `' . $db_mymps . 'information` AS a LEFT JOIN `' . $db_mymps . 'information_' . $tpl_index[portal][ershoufangmod] . '` AS g ON a.id = g.id WHERE ' . get_children($tpl_index[portal][ershoufang]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,12');
  92. while ($row = $db->fetchRow($query)) {
  93. $arr['id'] = $row['id'];
  94. $arr['title'] = $row['title'];
  95. $arr['ifred'] = $row['ifred'];
  96. $arr['ifbold'] = $row['ifbold'];
  97. $arr['img_path'] = $row['img_path'];
  98. $arr[$tpl_index[portali][prices]] = $row[$tpl_index[portali][prices]];
  99. $arr[$tpl_index[portali][acreage]] = $row[$tpl_index[portali][acreage]];
  100. $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
  101. $esf[$row['id']] = $arr;
  102. }
  103. $arr = '';
  104. $czf = array();
  105. $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.img_path,a.dir_typename FROM `' . $db_mymps . 'information` AS a WHERE ' . get_children($tpl_index[portal][zufang]) . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,4');
  106. while ($row = $db->fetchRow($query)) {
  107. $arr['id'] = $row['id'];
  108. $arr['title'] = $row['title'];
  109. $arr['ifred'] = $row['ifred'];
  110. $arr['ifbold'] = $row['ifbold'];
  111. $arr['img_path'] = $row['img_path'];
  112. $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
  113. $czf[$row['id']] = $arr;
  114. }
  115. unset($arr);
  116. $ershou = $ershou_img = array();
  117. $inershou = get_children($tpl_index[portal][ershou]);
  118. $query = $db->query('SELECT a.id,a.title,a.ifred,a.ifbold,a.begintime,a.catname,a.dir_typename FROM ' . $db_mymps . 'information AS a WHERE ' . $inershou . ' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC LIMIT 0,10');
  119. while ($row = $db->fetchRow($query)) {
  120. $arr['id'] = $row['id'];
  121. $arr['title'] = $row['title'];
  122. $arr['begintime'] = $row['begintime'];
  123. $arr['catname'] = $row['catname'];
  124. $arr['ifred'] = $row['ifred'];
  125. $arr['ifbold'] = $row['ifbold'];
  126. $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
  127. $ershou[$row['id']] = $arr;
  128. }
  129. $arr = '';
  130. $query = $db->query('SELECT a.id,a.title,a.img_path,a.dir_typename FROM `' . $db_mymps . 'information` AS a WHERE ' . $inershou . ' AND (a.info_level = 1 OR a.info_level = 2) AND img_path != \'\' ORDER BY a.begintime DESC LIMIT 0,6');
  131. if ($query) {
  132. while ($row = $db->fetchRow($query)) {
  133. $arr['id'] = $row['id'];
  134. $arr['title'] = $row['title'];
  135. $arr['img_path'] = $row['img_path'];
  136. $arr['uri'] = Rewrite('info', array('id' => $row['id'], 'dir_typename' => $row['dir_typename']));
  137. $ershou_img[$row['id']] = $arr;
  138. }
  139. }
  140. } else {
  141. if ($tpl_index['banmian'] == 'classic') {
  142. $index_cat = get_categories_tree(0, 'category');
  143. if (is_array($index_cat)) {
  144. foreach ($index_cat as $firstcatkey => $firstcatval) {
  145. $idin = get_page_idin2('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a WHERE a.gid=\'' . $firstcatval['catid'] . '\' AND (a.info_level = 1 OR a.info_level = 2) ORDER BY a.begintime DESC', $tpl_index['foreachinfo']);
  146. if ($idin) {
  147. $query = $db->query('SELECT a.catname,a.dir_typename,a.id,a.userid,a.catid,a.title,a.ifred,a.ifbold,a.begintime FROM `' . $db_mymps . 'information` AS a WHERE a.id IN (' . $idin . ') ORDER BY a.begintime DESC');
  148. $index_cat[$firstcatval['catid']]['information'] = array();
  149. while ($irow = $db->fetchRow($query)) {
  150. $arr['id'] = $irow['id'];
  151. $arr['title'] = $irow['title'];
  152. $arr['begintime'] = $irow['begintime'];
  153. $arr['catname'] = $irow['catname'];
  154. $arr['ifred'] = $irow['ifred'];
  155. $arr['ifbold'] = $irow['ifbold'];
  156. $arr['caturi'] = Rewrite('category', array('dir_typename' => $irow['dir_typename'], 'catid' => $irow['catid']));
  157. $arr['uri'] = Rewrite('info', array('id' => $irow['id'], 'dir_typename' => $irow['dir_typename']));
  158. $index_cat[$firstcatval['catid']]['information'][] = $arr;
  159. }
  160. }
  161. }
  162. }
  163. $tpl_index[classic][cats] = $tpl_index[classic][cats] ? $tpl_index[classic][cats] + 1 : '12';
  164. } else {
  165. if ($tpl_index['banmian'] == 'simple') {
  166. if (ifplugin('goods')) {
  167. require_once MYMPS_ROOT . '/plugin/goods/include/functions.php';
  168. $goods = mymps_get_goods($tpl_index['goods'], 1);
  169. }
  170. $index_cat = get_categories_tree(0, 'category');
  171. $firstcats = get_smplist_cats($tpl_index['smp_cats']['first'], $tpl_index['showstyle']);
  172. $secondcats = get_smplist_cats($tpl_index['smp_cats']['second'], $tpl_index['showstyle']);
  173. $thirdcats = get_smplist_cats($tpl_index['smp_cats']['third'], $tpl_index['showstyle']);
  174. $fourthcats = get_smplist_cats($tpl_index['smp_cats']['fourth'], $tpl_index['showstyle']);
  175. } else {
  176. if ($tpl_index['banmian'] == 'gezi') {
  177. $where .= ' WHERE 1 ';
  178. $where .= ' AND (a.info_level = 1 OR a.info_level = 2)';
  179. $orderby = ' ORDER BY a.upgrade_type_index DESC,a.begintime DESC';
  180. $param = setParam(array('catid'), 'active', 'news-');
  181. $rows_num = $db->getOne('SELECT COUNT(a.id) FROM `' . $db_mymps . 'information` AS a ' . $s . ' ' . $where);
  182. $idin = get_page_idin('id', 'SELECT a.id FROM `' . $db_mymps . 'information` AS a ' . $s . $where . $orderby, 30);
  183. $sql = 'SELECT a.id,a.tel,a.title,a.userid,a.contact_who,a.content,a.img_path,a.img_count,a.upgrade_type_index,a.upgrade_time_index,a.begintime,a.endtime,a.info_level,a.certify,a.ifred,a.ifbold,a.dir_typename,b.areaname FROM ' . $db_mymps . 'information AS a LEFT JOIN `' . $db_mymps . 'area` AS b ON a.areaid = b.areaid WHERE a.id IN (' . $idin . ') ' . $orderby;
  184. $info_list = array();
  185. $page1 = $idin ? $db->getAll($sql) : array();
  186. foreach ($page1 as $key => $val) {
  187. $infolist['id'] = $val['id'];
  188. $infolist['begintime'] = $val['begintime'];
  189. $infolist['title'] = $val['title'];
  190. $infolist['ifred'] = $val['ifred'];
  191. $infolist['ifbold'] = $val['ifbold'];
  192. $infolist['tel'] = $val['tel'];
  193. $infolist['img_count'] = $val['img_count'];
  194. $infolist['content'] = clear_html($val['content']);
  195. $infolist['areaname'] = $val['areaname'];
  196. $infolist['contact_who'] = $val['contact_who'];
  197. $infolist['poster'] = !empty($val['userid']) ? '<a target="black" href=' . Rewrite('space', array('user' => $val['userid'])) . '>' . $val['userid'] . '</a>' : ($val['contact_who'] ? $val['contact_who'] : '游客');
  198. $infolist['img_path'] = $val['img_path'];
  199. $infolist['img_count'] = $val['img_count'];
  200. $infolist['uri'] = Rewrite('info', array('id' => $val['id'], 'dir_typename' => $val['dir_typename']));
  201. $infolist['info_level'] = $val['info_level'];
  202. $infolist['upgrade_type_index'] = $val['upgrade_type_index'];
  203. $infolist['certify'] = $val['certify'];
  204. $info_list[$val['id']] = $infolist;
  205. $ids = true;
  206. if (0 < $val['upgrade_time_index'] && $val['upgrade_time_index'] < $timestamp) {
  207. $db->query('UPDATE `' . $db_mymps . 'information` SET upgrade_type_index = \'1\',upgrade_time_index = \'0\' WHERE id =\'' . $val['id'] . '\'');
  208. }
  209. }
  210. $idin = $ids ? ' AND a.id IN (' . $idin . ') ' : '';
  211. $pageline = NULL;
  212. $pageview = page2('active');
  213. }
  214. }
  215. }
  216. }
  217. include mymps_tpl('index_' . $tpl_index['banmian']);
  218. is_object($db) && $db->Close();
  219. $cachetime && $cachepages->caching();
  220. $advertisement = NULL;
  221. unset($advertisement);