Wer ist online Aktuell 4 Gäste online News: Hauptmenü Startseite Ãœber Waldmühlen News Forum Bildergalerie Termine Newsletter Spielhalle Gästebuch Links Webcam Impressum Datenschutzerklärung

Hauptverzeichnis Dateien Unterlagen Breitscheid 2012 Download Dankeschön für das Herunterladen der Datei Unterlagen Breitscheid 2012 Falls der Download nicht automatisch startet, dann klicke auf den Link DOWNLOAD Letzte Änderung am: 16 Apr 2012 Letzte Änderung durch: Domy (Domy) Dateidatum: 16 Apr 2012 Dateigröße: 3,923.64 Kb Dateityp: zip Downloads: 8

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  OR menuid = 43 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1729607578' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1729607578' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '05d63bcb160c3dd575592ea805efc7fe'
5
UPDATE jos_session SET `time`='1729608478',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='05d63bcb160c3dd575592ea805efc7fe'
6
SELECT *
 FROM jos_menu
 WHERE id = 43
7
SELECT * FROM jos_downloads_repository WHERE id=0
8
SELECT fileid, COUNT(fileid) AS number FROM jos_downloads_log WHERE type = 1 AND ipaddress = '18.118.144.97' AND date > SUBDATE(NOW(), INTERVAL 24 HOUR) GROUP BY fileid
9
SELECT DISTINCT role FROM jos_assignments UNION SELECT DISTINCT role FROM jos_permissions
10
SELECT role, subject_id, action FROM jos_permissions WHERE subject_type = 'remosFolder' AND action IN('download','edit')
11
SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count FROM jos_downloads_files AS f LEFT JOIN jos_downloads_log AS l ON l.type=3 AND l.fileid=f.id WHERE f.id = 5 AND published=1 GROUP BY f.id
12
SELECT COUNT(*) FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')
13
SELECT `role`, `control`, `subject_id`, `action` FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')
14
SELECT *
 FROM jos_users
 WHERE id = '62'
15
SELECT fileid, COUNT(fileid) AS number FROM jos_downloads_log WHERE type = 1 AND userid = 62 AND date > SUBDATE(NOW(), INTERVAL 24 HOUR) GROUP BY fileid
16
SELECT role, access_id FROM jos_assignments AS a WHERE a.access_type='aUser' AND (a.access_id='62' OR a.access_id='*' OR a.access_id='+')
17
SELECT * FROM jos_downloads_containers ORDER BY sequence, name
18
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder
19
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder
20
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder
21
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder
22
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder
23
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'
24
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 = 43 )
 ORDER BY ordering
25
SELECT guest, usertype
 FROM jos_session
26
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 0 AND usertype <> 'Super Administrator'
27
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
28
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
29
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
30
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=60'
31
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
32
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=70'
33
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=71'
34
SELECT *
 FROM jos_banner
 WHERE showBanner=1
35
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 8