www.kalibening.com/template Related Links Main Menu Home Joomla! Home Visitor Since Jan 2009 Today 3 Yesterday 5 This week 21 This month 44 All 2224 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) Visitor Registration Fields marked with an asterisk (*) are required. Name: * Username: * E-mail: * Password: * Verify Password: * 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 = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1268389059' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268389059' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
6
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
11
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com\_registration&task=register%'
12
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'
13
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 = 99999999 )
 ORDER BY ordering
14
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
15
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
16
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`))
17
SELECT MAX(id) FROM jos_vvisit_counter
18
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.111' AND (tm+'1440')>'1268389959'
19
INSERT INTO jos_vvisit_counter (id, tm, ip) VALUES ('', '1268389959', '38.107.191.111')
20
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268326800'
21
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268240400' and tm<'1268326800'
22
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267981200'
23
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267376400'
24
SELECT groups_id,groups_members 
 FROM jos_docman_groups
25
SELECT id
FROM jos_menu
WHERE link ='index.php?option=com_docman'
26
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
27
SELECT *
 FROM jos_docman
 WHERE id = '1'
28
SELECT *
 FROM jos_users
 WHERE id = '62'
29
SELECT *
 FROM jos_docman_groups
 WHERE groups_id = '1'
30
SELECT * FROM jos_categories
 WHERE section = 'com_docman'
31
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
32
SELECT params
 FROM jos_mambots
 WHERE element = 'standardbuttons'
 AND folder = 'docman'
33
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
34
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
35
SELECT *
 FROM jos_docman
 WHERE id = '1'
36
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
37
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-12 17:32' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-12 17:32' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering