Main Menu Home President's Message Directions Member Galleries Student Galleries Show Opportunities Learning Resources Links Job Opportunities Contact Us Search Become a Member   Gallery Home » Student Assignments User Panel - Most Viewed - Last Added Last Image Slideshow: Start - Stop Next Image Wilkins_Crescent Description: Date: Thu 18 May 2006 13:10:14 CDT Hits: 1243 Rating: No Votes Filesize: 83,86 KB Author: batbuddy Send to Friend Please login first... [RM]: Registered Members Directory [SM]: Special Members Directory Powered by: PonyGallery

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND menuid = 0
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND menuid = 30
 LIMIT 1
4
DELETE FROM jos_session
 WHERE ( time < '1371715068' )
5
SELECT * FROM jos_session WHERE session_id='8a94fd094a39f0e0f3db94d9f0856a59'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = MD5( '558d3385517d16135874148350816d59' )
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e9403a8890a7394bd70d731094117591','1371725868','','0','1' )
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'com'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'editors-xtd'
 ORDER BY ordering
15
SELECT access
 FROM jos_menu
 WHERE id = 30
16
SELECT a.*, cc.name AS category
FROM jos_ponygallery AS a, jos_ponygallery_catg AS cc
WHERE a.catid=cc.cid AND a.id=116
 AND cc.access<=''
17
select * from jos_ponygallery_catg where cid=1 and published=1 
 AND access<='0'
18
SELECT c.access FROM jos_ponygallery_catg as c
 left join jos_ponygallery as a on a.catid=c.cid
 WHERE a.id= '116'
19
SELECT a.id, a.catid, a.imgtitle, a.imgauthor, a.imgtext, a.imgdate, a.imgcounter, a.imgvotes, a.imgvotesum, a.published, a.imgfilename, a.imgthumbname,a.owner,u.id FROM jos_ponygallery as a 
 left join jos_users as u on u.username = a.owner
 WHERE a.id= '116' AND a.approved=1
20
SELECT a.id, a.catid, a.imgtitle, a.imgauthor, a.imgtext, a.imgdate, a.imgcounter, a.imgvotes, a.imgvotesum, a.published, a.imgfilename, a.imgthumbname,a.owner,u.id FROM jos_ponygallery as a 
 left join jos_users as u on u.username = a.owner
 WHERE a.id= '116' AND a.approved=1
21
SELECT id, imgfilename FROM jos_ponygallery WHERE catid=1 ORDER BY id DESC
22
UPDATE jos_ponygallery SET imgcounter='1243' WHERE id=116
23
SELECT a.id
 FROM jos_components AS a
 WHERE a.name = 'Syndicate'
24
SELECT * FROM jos_components WHERE id='17'
25
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m, jos_modules_menu AS mm
 WHERE m.published = 1
 AND m.access <= '0'
 AND m.client_id != 1
 AND mm.moduleid = m.id
 AND ( mm.menuid = '30' OR mm.menuid = 0 )
 ORDER BY ordering
26
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
27
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
28
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
29
SELECT COUNT(*) AS numrows
 FROM jos_banner
 WHERE showBanner = 1