Subject: Welcome to the Members area. How it works.
BUGBOY
Super Moderator
Chief Toy Dude / Head Cruiser
Posts: 2146
Threads: 403
Registered: August 27th, 2002
Member Is Offline
Location: Bass coast
Theme: UltimaBB Pro Blue ( Default )
Mood: A wise German once said
posted on June 22nd, 2008 at 07:30 PM
Welcome to the Members area. How it works.
This area has been made for people who wish to post pictures, updates etc of thier own Country buggy.
Now to help with keeping the KO register updated with new information etc.
I just ask you to post under your KO number.
With your KO number as your heading just always update that post with pictures,or work being done to your CB.
If you wish to have your info moved from another section to here please send me a U2U
Thanks
Nathan
Everything 36HP !
Change over king and link spindles
6-12volt semaphores
Find us on Facebook
SELECT moderator FROM ubb_forums WHERE moderator != ''
3.
0.00010204
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
4.
0.00008488
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
5.
0.00006819
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
6.
0.00006604
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
7.
0.00006294
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
8.
0.00006509
SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
9.
0.00006413
SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
10.
0.00005913
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
11.
0.00006104
SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
12.
0.00005484
SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
13.
0.00006318
SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
14.
0.00006509
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.
0.00032091
SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robotsORDER BY strlen DESC
16.
0.00009394
SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '69966'
17.
0.00013518
DELETE FROM ubb_whosonline WHERE ip = '3.235.176.80' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1652995897'
18.
0.00007105
INSERT INTO ubb_whosonline(username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.235.176.80', LPAD('1652996497', '15', '0'), '/viewtopic.php?tid=69966', '0', '')
19.
0.00007391
DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.235.176.80') OR (onlinetime < '1652910097'))
20.
0.00004196
DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.235.176.80') OR (onlinetime < '1652910097'))
21.
0.00003695
INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.235.176.80', '1652996497')
22.
0.00009799
SELECT * FROM ubb_themes WHERE themeid = '1'
23.
0.00005198
SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.
0.00006199
SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '235' OR ip2 = '-1') AND (ip3 = '176' OR ip3 = '-1') AND (ip4 = '80' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.
0.00025105
SELECT 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
SELECT 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 = '69966'
29.
0.00008392
SELECT * FROM ubb_forums WHERE fid='100' AND status='on'
30.
0.00004506
SELECT name, fid, private, userlist FROM ubb_forums WHERE fid = '88'
31.
0.00020289
SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
32.
0.00003600
SELECT find, replace1 FROM ubb_words
33.
0.00006700
SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
34.
0.00007486
UPDATEubb_threads SET views = views+1 WHERE tid = '69966' LIMIT 1
35.
0.00006604
SELECT COUNT(pid) FROM ubb_posts WHERE tid = '69966'
36.
0.00213003
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 69966 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 = '100' ORDER BY l.dateline DESC LIMIT 1
37.
0.00021005
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 69966 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 = '100' ORDER BY l.dateline ASC LIMIT 1
38.
0.00006509
SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '69966'
39.
0.00006914
SELECT pid FROM ubb_posts WHERE tid = '69966' ORDER BY pid LIMIT 0, 30
40.
0.00008202
SELECT * FROM ubb_attachments WHERE pid IN('653326')
41.
0.00018382
SELECT 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 = '100' AND p.tid = '69966' ORDER BY p.pid ASC LIMIT 0, 30