Board Logo
Go To Bottom

Printable Version  
[ Total Views: 4221 | Total Replies: 0 | Thread Id: 78567 ]
Author: Subject:  CB REGISTER IS UPDATED
Member58camper
A.k.a.: Bill Moore
Wolfsburg Wizard
***


Avatar


Posts: 591
Threads: 110
Registered: August 27th, 2002
Member Is Offline

Location: NORTH NOWRA is now Country Buggy Central
Theme: UltimaBB Pro Blue ( Default )
Mood: Curt but friendly

posted on August 22nd, 2009 at 05:36 PM
CB REGISTER IS UPDATED


The Register has now been updated and it now records sonme level of information about 330 known CBs

Keep the changes coming through.

countrybuggybill


  Go To Top


Powered by GaiaBB, © 2011 The GaiaBB Group


[ Queries: 41 ] [ PHP: 25.8% - SQL: 74.2% ]
#Duration:Query:
1.0.00021791SELECT * FROM ubb_settings
2.0.00016499SELECT moderator FROM ubb_forums WHERE moderator != ''
3.0.00016809SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
4.0.00013900SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
5.0.00014997SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
6.0.00011897SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
7.0.00011301SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
8.0.00011897SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
9.0.00011396SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
10.0.00013208SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
11.0.00010800SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
12.0.00014901SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
13.0.00225115SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
14.0.00045514SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.0.00064397SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robots ORDER BY strlen DESC
16.0.00021005SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '78567'
17.0.00036383DELETE FROM ubb_whosonline WHERE ip = '44.197.197.23' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1632843416'
18.0.00015521INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('xguest123', '44.197.197.23', LPAD('1632844016', '15', '0'), '/viewtopic.php?tid=78567', '0', '')
19.0.00013900DELETE FROM ubb_guestcount WHERE ((ipaddress = '44.197.197.23') OR (onlinetime < '1632757616'))
20.0.00009704DELETE FROM ubb_robotcount WHERE ((ipaddress = '44.197.197.23') OR (onlinetime < '1632757616'))
21.0.00008798INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('44.197.197.23', '1632844016')
22.0.00017691SELECT * FROM ubb_themes WHERE themeid = '1'
23.0.00010800SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.0.00015211SELECT id FROM ubb_banned WHERE ((ip1 = '44' OR ip1 = '-1') AND (ip2 = '197' OR ip2 = '-1') AND (ip3 = '197' OR ip3 = '-1') AND (ip4 = '23' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.0.00047112SELECT fid, type, name, fup, status, private, userlist, password FROM ubb_forums WHERE private != '5' AND private != '3' AND private != '2' AND userlist = '' AND password = '' AND status = 'on' ORDER BY displayorder
26.0.00016809SELECT themeid, name FROM ubb_themes
27.0.00128794SELECT name, template FROM ubb_templates WHERE name IN ('functions_bbcode', 'functions_bbcodeinsert', 'functions_smilieinsert_smilie', 'functions_smilieinsert', 'viewtopic_reply', 'viewtopic_quickreply', 'viewtopic', 'viewtopic_invalid', 'viewtopic_modoptions', 'viewtopic_newpoll', 'viewtopic_newtopic', 'viewtopic_poll_options_view', 'viewtopic_poll_options', 'viewtopic_poll_submitbutton', 'viewtopic_poll', 'viewtopic_post', 'viewtopic_post_email', 'viewtopic_post_site', 'viewtopic_post_icq', 'viewtopic_post_aim', 'viewtopic_post_msn', 'viewtopic_post_yahoo', 'viewtopic_post_search', 'viewtopic_post_profile', 'viewtopic_post_pm', 'viewtopic_post_ip', 'viewtopic_post_repquote', 'viewtopic_post_report', 'viewtopic_post_edit', 'viewtopic_post_delete', 'viewtopic_post_attachmentimage', 'viewtopic_post_attachment', 'viewtopic_post_attach_noborder', 'viewtopic_post_attimg_noborder', 'viewtopic_post_sig', 'viewtopic_post_nosig', 'viewtopic_printable', 'viewtopic_printable_row', 'viewtopic_multipage', 'viewtopic_post_attachment_none', 'viewforum_rules', 'viewtopic_post_blog', 'viewtopic_post_rpg', 'viewforum_mpn_info', 'viewtopic_next_prev_links', 'viewtopic_captcha', 'css', 'error', 'footer', 'footer_querynum', 'footer_load', 'footer_phpsql', 'footer_totaltime', 'header', 'message', 'meta_tags', 'shadow', 'shadow2')
28.0.00049520SELECT t.tid, t.fid, t.subject, t.views, t.replies, t.closed, t.topped, l.uid as lp_uid, l.username as lp_user, l.dateline as lp_dateline, l.pid as lp_pid FROM ubb_threads t LEFT JOIN ubb_lastposts l ON l.tid = t.tid WHERE t.tid = '78567'
29.0.00031900SELECT * FROM ubb_forums WHERE fid='96' AND status='on'
30.0.00046682SELECT name, fid, private, userlist FROM ubb_forums WHERE fid = '88'
31.0.00034714SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
32.0.00023103SELECT find, replace1 FROM ubb_words
33.0.00038385SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
34.0.00023985UPDATE ubb_threads SET views = views+1 WHERE tid = '78567' LIMIT 1
35.0.00018692SELECT COUNT(pid) FROM ubb_posts WHERE tid = '78567'
36.0.00040007SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 78567 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline < x.dateline AND t.fid = '96' ORDER BY l.dateline DESC LIMIT 1
37.0.00032210SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 78567 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline > x.dateline AND t.fid = '96' ORDER BY l.dateline ASC LIMIT 1
38.0.00015807SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '78567'
39.0.00014520SELECT pid FROM ubb_posts WHERE tid = '78567' ORDER BY pid LIMIT 0, 30
40.0.00012708SELECT * FROM ubb_attachments WHERE pid IN('730806')
41.0.00037479SELECT p.*, m.*,w.time FROM ubb_posts p LEFT JOIN ubb_members m ON m.username = p.author LEFT JOIN ubb_whosonline w ON p.author = w.username WHERE p.fid = '96' AND p.tid = '78567' ORDER BY p.pid ASC LIMIT 0, 30