[分享]IBF
發表於 : 2002-05-16 22:22
我前幾天才去看過，還沒提供下載，本以為還要等一段時間，想不到才幾天就釋出了。
下載試試看吧，搜尋功能頁簡直與 vbb 一模一樣，這幾天在玩 wbb，其搜尋功能也是\r
是，vbb 果然是 php 論壇的典範。
代碼: 選擇全部
SELECT * FROM v1_b1sessions WHERE id='ddda52c52849317fc714fdff3d52066d'
SELECT m.id, m.name, m.mgroup, m.password, m.email, m.allow_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post, m.last_visit, m.last_activity, g.* FROM v1_b1members m, v1_b1groups g WHERE m.id='1' and g.g_id=m.mgroup
UPDATE v1_b1sessions SET member_name='HeartIcy', member_pass='098f6bcd4621d373cade4e832627b4f6', member_id='1', member_group='4', login_type='-1', ip_address='127.0.0.1', running_time='1021636336', location='Search,,,,01' WHERE id='ddda52c52849317fc714fdff3d52066d'
SELECT s.*, i.*, t.template FROM v1_b1templates t, v1_b1skins s, v1_b1images i WHERE s.default_set=1 AND t.tmid=s.tmpl_id AND i.imid=s.img_id
SELECT id, read_perms from v1_b1forums WHERE id='1'
SELECT DISTINCT(t.tid) FROM v1_b1posts p, v1_b1topics t WHERE (t.tid=p.topic_id AND p.forum_id IN (1)) AND (t.approved=1 and p.queued <> 1) AND ( (LOWER(t.title) REGEXP '[^0-9a-zA-Z]?许[ \t.,!?:;]' or LOWER(p.post) REGEXP '[^0-9a-zA-Z]?许[ \t.,!?:;]') ) AND (t.last_post > 1019044336 or p.post_date > 1019044336) ORDER BY last_post desc LIMIT 0, 200
INSERT INTO v1_b1search_results (id, topics, search_date, max_hits, sort_key, sort_order) VALUES ('75b60a30b35490af148b9ca1f21f2ef4', '5', '1021636336', '1', 'last_post', 'desc')
SELECT t.*, f.id as forum_id, f.name as forum_name FROM v1_b1topics t, v1_b1forums f WHERE t.tid IN(5) and f.id=t.forum_id ORDER BY last_post desc LIMIT 0,25