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 4 Yesterday 3 This week 7 This month 16 All 2102 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 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 id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1265713259' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265713259' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 1
7
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-02-09 18:15' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 18:15' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
8
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-02-09 18:15' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 18:15' )
 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
9
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
10
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'
11
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
12
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
13
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
14
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`))
15
SELECT MAX(id) FROM jos_vvisit_counter
16
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.119' AND (tm+'1440')>'1265714159'
17
INSERT INTO jos_vvisit_counter (id, tm, ip) VALUES ('', '1265714159', '38.107.191.119')
18
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1265648400'
19
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1265562000' and tm<'1265648400'
20
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1265562000'
21
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1264957200'
22
SELECT groups_id,groups_members 
 FROM jos_docman_groups
23
SELECT id
FROM jos_menu
WHERE link ='index.php?option=com_docman'
24
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
25
SELECT *
 FROM jos_docman
 WHERE id = '1'
26
SELECT *
 FROM jos_users
 WHERE id = '62'
27
SELECT *
 FROM jos_docman_groups
 WHERE groups_id = '1'
28
SELECT * FROM jos_categories
 WHERE section = 'com_docman'
29
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
30
SELECT params
 FROM jos_mambots
 WHERE element = 'standardbuttons'
 AND folder = 'docman'
31
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
32
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
33
SELECT *
 FROM jos_docman
 WHERE id = '1'
34
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
35
SELECT guest, usertype
 FROM jos_session
36
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-02-09 18:15' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 18:15' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering