Board Logo
Go To Bottom

Printable Version  
[ Total Views: 4168 | 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: 32.1% - SQL: 67.9% ]
#Duration:Query:
1.0.00028110SELECT * FROM ubb_settings
2.0.00024414SELECT moderator FROM ubb_forums WHERE moderator != ''
3.0.00022316SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
4.0.00016308SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
5.0.00016093SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
6.0.00015402SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
7.0.00014591SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
8.0.00015712SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
9.0.00014615SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
10.0.00015306SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
11.0.00013900SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
12.0.00015092SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
13.0.00013804SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
14.0.00015807SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.0.00060511SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robots ORDER BY strlen DESC
16.0.00021696SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '78567'
17.0.00037193DELETE FROM ubb_whosonline WHERE ip = '3.235.184.215' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1623896403'
18.0.00016212INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.235.184.215', LPAD('1623897003', '15', '0'), '/viewtopic.php?tid=78567&page=1', '0', '')
19.0.00015998DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.235.184.215') OR (onlinetime < '1623810603'))
20.0.00011086DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.235.184.215') OR (onlinetime < '1623810603'))
21.0.00014091INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.235.184.215', '1623897003')
22.0.00024605SELECT * FROM ubb_themes WHERE themeid = '1'
23.0.00013089SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.0.00015092SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '235' OR ip2 = '-1') AND (ip3 = '184' OR ip3 = '-1') AND (ip4 = '215' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.0.00047898SELECT 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.00013494SELECT themeid, name FROM ubb_themes
27.0.00086522SELECT 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.00023794SELECT 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.00020504SELECT * FROM ubb_forums WHERE fid='96' AND status='on'
30.0.00016093SELECT name, fid, private, userlist FROM ubb_forums WHERE fid = '88'
31.0.00015211SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
32.0.00009394SELECT find, replace1 FROM ubb_words
33.0.00019908SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
34.0.00018692UPDATE ubb_threads SET views = views+1 WHERE tid = '78567' LIMIT 1
35.0.00016809SELECT COUNT(pid) FROM ubb_posts WHERE tid = '78567'
36.0.00040483SELECT 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.00029707SELECT 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.00012612SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '78567'
39.0.00014591SELECT pid FROM ubb_posts WHERE tid = '78567' ORDER BY pid LIMIT 0, 30
40.0.00011992SELECT * FROM ubb_attachments WHERE pid IN('730806')
41.0.00033593SELECT 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