Home Contact Forum   Newsflash Bine ati venit pe site, va dorim navigare placuta!   Meniu Principal Home Argument Actualitate Articole Cauta in site Istoria Bisericii Istoria sarbilor Sfintii imparati Texte bizantine Profetii Istorie Bizantina Harti Imperiul romano-bulgar Forum Muzica Bizantina Familia Bizantina Spiritualitate ortodoxa Recomandari Afaceri  Detectoare radar Romania Bogdan Stanciu  Revista Murmur Sfantul Daniil Sihastrul  Sita Deasa  Home Forum Forum Probyzantinum ForumThreaded ViewRulesHelp Welcome, Guest Please Login or Register.    Lost Password? Forum Probyzantinum Lista de discutii Istorie Istoria antica (1 viewing) (1) Guests Istoria antica Page: 1 Thread in Forum : Istoria antica Forum Tools Post New Topic Show latest posts Rules Help     Topics Replies Views Last Post Celtii de la Dunare by admin 1 2982 2008/06/01 22:05 by Nicetas Page: 1 Board Categories Lista de discutii ... Regulamnet si anunturi administrative ... Istorie ...... Istoria Romanilor ...... Discutii pe teme istorice diverse ... Lingvistica si Literatura ...... Etimologii si evolutii lingvistice ...... Carti, citite sau nu ... Coltul colectionarului ... Spiritualitate ...... Spiritualitate bizantina/ortodoxa ...... Alte culte ... Feed Back Powered by FireBoard

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 = 37 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1227216452' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1227216452' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_menu
 WHERE id = 37
5
SELECT template FROM jos_templates_menu where client_id ='0'
6
DELETE FROM jos_fb_whoisonline WHERE time < '1227216452'
7
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE userip='38.103.63.62' AND userid='0'
8
SELECT name FROM jos_fb_categories WHERE id = 5
9
UPDATE jos_fb_whoisonline SET time='1227217352', what='Istoria antica', do= '', task= '', link= '/index.php?option=com_fireboard&Itemid=37&func=showcat&id=0&view=flat&catid=5', func= 'showcat'
 WHERE userid=0 AND userip='38.103.63.62'
10
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=5
11
SELECT * from jos_fb_sessions where userid=0
12
SELECT max(posts) from jos_fb_users
13
SELECT parent FROM jos_fb_categories WHERE id=5
14
SELECT count(*) FROM jos_fb_messages WHERE catid=5 and hold=1
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 = 37 )
 ORDER BY ordering
17
SELECT userid FROM jos_fb_moderation WHERE catid='5' and userid='0'
18
SELECT id FROM jos_fb_categories WHERE published='1' AND pub_access='0'
19
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse FROM jos_fb_categories where id='5'
20
Select count(*) FROM jos_fb_messages WHERE parent = '0' AND catid= '5' AND hold = '0'
21
SELECT a. * , MAX( b.time )  AS lastpost FROM  jos_fb_messages  AS a LEFT  JOIN jos_fb_messages  AS b ON b.thread = a.thread WHERE a.parent =  '0' AND a.catid =  5 AND a.hold =  '0' GROUP  BY id ORDER  BY ordering DESC , lastpost DESC  LIMIT 0,20
22
SELECT id,parent,thread,catid,subject,name,time,topic_emoticon,locked,ordering,userid moved FROM jos_fb_messages WHERE thread IN ('6') AND id NOT IN ('6') and hold=0
23
select count(*) from jos_fb_messages where catid='5' and hold=1
24
select * from jos_fb_categories where id=5 and published=1
25
select * from jos_fb_categories where id=2 and published=1
26
select * from jos_fb_categories where id=1 and published=1
27
SELECT w.userid, u.username , 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  WHERE w.link like '%/index.php?option=com_fireboard&Itemid=37&func=showcat&id=0&view=flat&catid=5%'
28
SELECT * from jos_fb_categories where id = 5
29
SELECT name,id FROM jos_fb_categories WHERE id = 2
30
SELECT id, name, locked,review, pub_access, pub_recurse, admin_access, admin_recurse FROM jos_fb_categories WHERE parent='5'  and published='1' order by ordering
31
SELECT readtopics FROM jos_fb_sessions WHERE userid=0
32
SELECT mesid FROM jos_fb_attachments WHERE mesid=6
33
select count(*) from jos_fb_favorites where thread = 6 && userid = 0
34
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=5
35
SELECT c.*, c.parent
 FROM jos_fb_categories c
 WHERE published =1 
 AND ( pub_access = 0 ) 
 ORDER BY ordering, name
36
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'
37
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
38
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
39
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-20 13:42' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-20 13:42' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
40
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
41
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
42
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
43
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=30'
44
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
45
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=15'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=17'
48
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
49
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=19'
50
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
51
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
52
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
53
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Recomandari'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
54
SELECT *
 FROM jos_banner
 WHERE showBanner=1
55
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering