www.kalibening.com/template Related Links Main Menu Home Joomla! Home Visitor Since Jan 2009 Today 4 Yesterday 5 This week 22 This month 45 All 2225 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 Downloads Home Search Document Sample Category You can delete this sample category. DocumentsDate added Order by : Name | Date | Hits [ Ascendant ] Sample Document 12/27/2008 Hits: 0 You can delete this sample document and the file it is linked to. Download View Details 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 < '1268389108' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268389108' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'e3c80ff0187849c56e105b02c9a7191a'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e3c80ff0187849c56e105b02c9a7191a','1268390008','','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 published = 1 AND
 link LIKE 'index.php?option=com\_docman&task=cat\_view%'
14
SELECT groups_id,groups_members 
 FROM jos_docman_groups
15
SELECT id
FROM jos_menu
WHERE link ='index.php?option=com_docman'
16
SELECT catid, count( d.id ) AS count 
 FROM jos_docman AS d
   WHERE dmowner=-1
   AND d.published=1 
   AND d.approved=1
 GROUP BY d.catid
17
SELECT c.id, c.parent_id AS parent
 FROM jos_categories AS c
 WHERE section='com_docman'
 AND published <> -2
 ORDER BY ordering
18
SELECT id, name, title, parent_id AS parent
 FROM jos_categories
 WHERE section='com_docman'
 AND published <> -2
 ORDER BY ordering
19
SELECT * FROM jos_categories
 WHERE section = 'com_docman'
20
SELECT * FROM jos_categories 
 WHERE section = 'com_docman'
   AND published = 1 
   AND parent_id=13 AND access=0 ORDER BY ordering ASC
21
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 (13) 
 ORDER BY d.dmname DESC
LIMIT 5
22
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
23
SELECT *
 FROM jos_docman
 WHERE id = '1'
24
SELECT *
 FROM jos_users
 WHERE id = '62'
25
SELECT *
 FROM jos_docman_groups
 WHERE groups_id = '1'
26
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
27
SELECT params
 FROM jos_mambots
 WHERE element = 'standardbuttons'
 AND folder = 'docman'
28
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'
29
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
30
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
31
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
32
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`))
33
SELECT MAX(id) FROM jos_vvisit_counter
34
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.114' AND (tm+'1440')>'1268390009'
35
INSERT INTO jos_vvisit_counter (id, tm, ip) VALUES ('', '1268390009', '38.107.191.114')
36
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268326800'
37
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268240400' and tm<'1268326800'
38
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267981200'
39
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267376400'
40
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
41
SELECT *
 FROM jos_docman
 WHERE id = '1'
42
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
43
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
44
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
45
SELECT *
 FROM jos_docman
 WHERE id = '1'
46
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
47
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:33' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-12 17:33' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering