Member Login

Ministries Church News Music Ministry WMU Ministry Youth Ministry Children's Ministry Royal Ambassadors Girls In Action Missions Mission Opportunities Senior Saints Baptist Men Deacon Ministry

FBC Warrenton Forum ForumShow latest postsRulesHelp Welcome, Guest Please Login or Register.    Lost Password? Welcome   Forum Topics Replies Last Post Teen Talk (13 and Up) 0 0 No Posts Chit Chat 0 0 No Posts Coffee Break (Adult) 0 0 No Posts Youth Yack 0 0 No Posts Scripture Share (Thoughts and Inspiration) 0 0 No Posts Testimonies 0 0 No Posts Prayer Requests 0 0 No Posts Recent Posts Topic Author Categories Date Hits Sample Post Guest Teen Talk (13 and Up) Friday, 11 May 2007 1 FBC Warrenton Forum Forum Stats Total Users: 238   Latest Member: mockouncargemak Total Messages: 1   Total Subjects: 1   Total Sections: 1   Total Categories: 7 Today Open: 0   Yesterday Open: 0   Today Total Answer: 0   Yesterday Total Answer: 0 » View Recent Posts » More About Stats » User List Online 0 Members and 1 Guests Board Categories Welcome ... Teen Talk (13 and Up) ... Chit Chat ... Coffee Break (Adult) ... Youth Yack ... Scripture Share (Thoughts and Inspiration) ... Testimonies ... Prayer Requests - New Posts - No New Posts Powered by FireBoard Dorona Brown 1.0.1 by Best of Joomla Home Contact Us News Links

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 28 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1283897970' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283900670' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = 'ec90c2415fb6beaa9175c51f55caa5f5'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = '0ce8d35dc3aca712193829ec9f114e6d'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '0ce8d35dc3aca712193829ec9f114e6d','1283901570','','0','1' )
8
SELECT *
 FROM jos_menu
 WHERE id = 28
9
SELECT template FROM jos_templates_menu where client_id ='0'
10
DELETE FROM jos_fb_whoisonline WHERE time < '1283899770'
11
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE userip='38.107.191.91' AND userid='0'
12
INSERT INTO jos_fb_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`) 
 VALUES ('0', '1283901570', 'Forum Main','','','','/index.php?option=com_fireboard&Itemid=28', '38.107.191.91', '0')
13
SELECT max(posts) from jos_fb_users
14
SELECT max(posts) from jos_fb_users
15
SELECT su.view, u.name, su.moderator,su.avatar FROM jos_fb_users as su
LEFT JOIN jos_users as u on u.id=su.userid WHERE su.userid=0
16
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 28 )
 ORDER BY ordering
17
SELECT * FROM jos_fb_categories WHERE parent= 0 and published=1 ORDER BY ordering
18
SELECT id,title,sdescription,description, created ,published,showdate
 FROM jos_fb_announcement  WHERE  published = 1 ORDER BY created DESC LIMIT 1
19
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=1
20
SELECT c.*,m.subject, mm.catid as lastcat, m.name as mname, m.userid, u.username, u.name as uname FROM jos_fb_categories as c
                    left join jos_fb_messages as m on c.id_last_msg = m.id
                    left join jos_users as u on u.id = m.userid
                    left join jos_fb_messages as mm on mm.id = c.id_last_msg
                    WHERE c.parent='1'  and c.published='1' order by ordering
21
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=2
22
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='2'  AND published =1
23
SELECT userid FROM jos_fb_moderation WHERE catid='2'
24
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=2
25
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=4
26
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='4'  AND published =1
27
SELECT userid FROM jos_fb_moderation WHERE catid='4'
28
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=4
29
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=3
30
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='3'  AND published =1
31
SELECT userid FROM jos_fb_moderation WHERE catid='3'
32
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=3
33
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=5
34
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='5'  AND published =1
35
SELECT userid FROM jos_fb_moderation WHERE catid='5'
36
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=5
37
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=8
38
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='8'  AND published =1
39
SELECT userid FROM jos_fb_moderation WHERE catid='8'
40
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=8
41
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=9
42
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='9'  AND published =1
43
SELECT userid FROM jos_fb_moderation WHERE catid='9'
44
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=9
45
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=10
46
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE  parent='10'  AND published =1
47
SELECT userid FROM jos_fb_moderation WHERE catid='10'
48
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=10
49
select gid from jos_users where id=0
50
select gid from jos_users where id=0
51
SELECT u.id, ifnull(u.username, 'Guest') as username, ifnull(u.name,'Guest') as name,   fb.subject, fb.id as fbid, fb.catid, from_unixtime(fb.time) as date,    fb.hits, fb.locked,fb.topic_emoticon, fb.parent, sc.name as catname  FROM jos_fb_messages AS fb  LEFT JOIN jos_users AS u ON u.id = fb.userid INNER JOIN jos_fb_categories sc on sc.id = fb.catid  WHERE 1=1   AND (sc.pub_access<=0)   AND (sc.published=1)  AND (fb.hold=0) GROUP BY fb.subject ORDER BY fb.time DESC LIMIT 10
52
SELECT COUNT(*) FROM jos_users
53
SELECT COUNT(*) FROM jos_fb_messages WHERE moved=0 AND hold=0
54
SELECT COUNT(*) FROM jos_fb_messages WHERE parent=0 AND moved=0 AND hold=0
55
SELECT COUNT(*) FROM jos_fb_categories WHERE parent=0
56
SELECT COUNT(*) FROM jos_fb_categories WHERE parent>0
57
SELECT id, username FROM jos_users WHERE block=0 AND activation='' ORDER BY id DESC LIMIT 0,1
58
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1283842801 AND time < 1283929199 AND parent>0
59
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1283756401 AND time < 1283842799 AND parent>0
60
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1283842801 AND time < 1283929199 AND parent=0
61
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1283756401 AND time < 1283842799 AND parent=0
62
SELECT p.userid, p.posts, u.username FROM jos_fb_users AS p
 LEFT JOIN jos_users AS u ON u.id = p.userid
 WHERE p.posts > 0 ORDER BY p.posts DESC LIMIT 5
63
SELECT u.uhits AS hits, u.userid AS user_id, j.username AS user  FROM jos_fb_users AS u
 LEFT JOIN jos_users AS j ON j.id = u.userid
 WHERE u.uhits > 0 ORDER BY u.uhits DESC LIMIT 5
64
SELECT uhits FROM jos_fb_users
 WHERE uhits > 0 ORDER BY uhits DESC LIMIT 1
65
SELECT posts FROM jos_fb_users WHERE posts > 0 ORDER BY posts DESC LIMIT 0,1
66
SELECT * FROM jos_fb_messages WHERE moved=0 AND hold=0 AND parent=0 ORDER BY hits DESC LIMIT 5
67
SELECT hits FROM jos_fb_messages WHERE moved=0 AND hold=0 AND parent=0 ORDER BY hits DESC LIMIT 1
68
SELECT COUNT(*) FROM jos_fb_messages AS m
 LEFT JOIN jos_fb_categories AS c ON c.id = m.catid
 LEFT JOIN jos_users AS u ON u.gid >= c.pub_access
 WHERE m.moved='0' AND u.id = 0 AND c.published = 1 AND m.hold = 0
69
SELECT COUNT(*) FROM jos_fb_messages AS m
 LEFT JOIN jos_fb_categories AS c ON c.id = m.catid
 LEFT JOIN jos_users AS u ON u.gid >= c.pub_access
 WHERE m.moved='0' AND u.id = 0 AND c.published = 1 AND m.hold = 0 AND m.parent= 0
70
SELECT m.*, m.time AS sendtime FROM jos_fb_messages AS m
 LEFT JOIN jos_fb_categories AS c ON c.id = m.catid
 LEFT JOIN jos_users AS u ON u.gid >= c.pub_access
 WHERE m.moved='0' AND u.id = 0 AND c.published = 1 AND m.hold = 0
 ORDER BY m.id DESC LIMIT 0,1
71
SELECT w.userip, w.time, w.what, u.username, u.id, k.moderator, k.showOnline 
 FROM jos_fb_whoisonline AS w
 LEFT JOIN jos_users AS u ON u.id=w.userid 
 LEFT JOIN jos_fb_users AS k ON k.userid=w.userid 
 INNER JOIN jos_session AS s 
  ON s.guest=0 AND s.userid=w.userid 
 WHERE w.userid!=0 
 GROUP BY u.id 
  ORDER BY w.time DESC
72
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE user = 0
73
select id, title from jos_fb_groups
74
SELECT c.*, c.parent
 FROM jos_fb_categories c
 WHERE published =1 
 AND ( pub_access = 0 ) 
 ORDER BY ordering, name
75
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
76
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering
77
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
78
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Ministries'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
79
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
80
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1