www.kalibening.com/template Related Links Main Menu Home Joomla! Home Login Form Username Password Remember me Lost Password? No account yet? Register Syndicate Visitor Since Jan 2009 Today 2 Yesterday 3 This week 15 This month 38 All 2219 Visitors Counter 1.0.2 Translation Translate This Website DOCman Latest Downloads Sample Document (Sample Category) DOCman Category No Documents DOCman Most Downloaded Sample Document (0) Who's Online We have 1 guest online Visitor Template Black Batman Thursday, 25 December 2008 Template For Joomla 1.1.X...     Template Black Batman Last Updated ( Thursday, 25 December 2008 ) Read more...   http://kalibening.com/template, designed edit by anurjamansyah web team

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 = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1268258476' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268258476' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'e173fe22e528f936b16e310f24148131'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e173fe22e528f936b16e310f24148131','1268259376','','0','1' )
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
13
SELECT *
 FROM jos_menu
 WHERE id = 1
14
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 05:16' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 05:16' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
15
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 05:16' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 05:16' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 4
16
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
17
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'
18
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 = 1 )
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
20
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
21
CREATE TABLE IF NOT EXISTS jos_vvisit_counter (id int(11) NOT NULL AUTO_INCREMENT, tm int NOT NULL, ip varchar(16) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`))
22
SELECT MAX(id) FROM jos_vvisit_counter
23
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.110' AND (tm+'1440')>'1268259377'
24
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268240400'
25
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268154000' and tm<'1268240400'
26
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267981200'
27
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267376400'
28
SELECT groups_id,groups_members 
 FROM jos_docman_groups
29
SELECT id
FROM jos_menu
WHERE link ='index.php?option=com_docman'
30
SELECT d.*, c.title AS cat_title FROM jos_docman AS d
 LEFT JOIN jos_categories AS c ON d.catid = c.id WHERE d.dmowner=-1
 AND d.published=1 AND d.approved=1
 ORDER BY d.dmdate_published DESC
LIMIT 3
31
SELECT *
 FROM jos_docman
 WHERE id = '1'
32
SELECT *
 FROM jos_users
 WHERE id = '62'
33
SELECT *
 FROM jos_docman_groups
 WHERE groups_id = '1'
34
SELECT * FROM jos_categories
 WHERE section = 'com_docman'
35
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
36
SELECT params
 FROM jos_mambots
 WHERE element = 'standardbuttons'
 AND folder = 'docman'
37
SELECT d.*, c.title AS cat_title FROM jos_docman AS d
 LEFT JOIN jos_categories AS c ON d.catid = c.id WHERE d.dmowner=-1
 AND d.published=1 AND d.approved=1
 AND d.catid IN (3) 
 ORDER BY d.dmname DESC
LIMIT 3
38
SELECT d.*, c.title AS cat_title FROM jos_docman AS d
 LEFT JOIN jos_categories AS c ON d.catid = c.id WHERE d.dmowner=-1
 AND d.published=1 AND d.approved=1
 ORDER BY d.dmcounter DESC
LIMIT 4
39
SELECT *
 FROM jos_docman
 WHERE id = '1'
40
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
41
SELECT guest, usertype
 FROM jos_session
42
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 <= '2010-03-11 05:16' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 05:16' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering