www.kalibening.com/template Related Links Main Menu Home Joomla! Home Visitor Since Jan 2009 Today 4 Yesterday 3 This week 17 This month 40 All 2220 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 < '1268258496' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268258496' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '530b9a3aa9ece74ae2a55044b3bbb7f2'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = '594f1c7300c2896c69a4b01923c380a1'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '594f1c7300c2896c69a4b01923c380a1','1268259396','','0','1' )
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com\_docman&task=cat\_view%'
15
SELECT groups_id,groups_members 
 FROM jos_docman_groups
16
SELECT id
FROM jos_menu
WHERE link ='index.php?option=com_docman'
17
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
18
SELECT c.id, c.parent_id AS parent
 FROM jos_categories AS c
 WHERE section='com_docman'
 AND published <> -2
 ORDER BY ordering
19
SELECT id, name, title, parent_id AS parent
 FROM jos_categories
 WHERE section='com_docman'
 AND published <> -2
 ORDER BY ordering
20
SELECT * FROM jos_categories
 WHERE section = 'com_docman'
21
SELECT * FROM jos_categories 
 WHERE section = 'com_docman'
   AND published = 1 
   AND parent_id=13 AND access=0 ORDER BY ordering ASC
22
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
23
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
24
SELECT *
 FROM jos_docman
 WHERE id = '1'
25
SELECT *
 FROM jos_users
 WHERE id = '62'
26
SELECT *
 FROM jos_docman_groups
 WHERE groups_id = '1'
27
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
28
SELECT params
 FROM jos_mambots
 WHERE element = 'standardbuttons'
 AND folder = 'docman'
29
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'
30
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
31
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
32
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
33
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`))
34
SELECT MAX(id) FROM jos_vvisit_counter
35
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.114' AND (tm+'1440')>'1268259396'
36
INSERT INTO jos_vvisit_counter (id, tm, ip) VALUES ('', '1268259396', '38.107.191.114')
37
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268240400'
38
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268154000' and tm<'1268240400'
39
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267981200'
40
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267376400'
41
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
42
SELECT *
 FROM jos_docman
 WHERE id = '1'
43
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
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
 AND d.catid IN (3) 
 ORDER BY d.dmname DESC
LIMIT 3
45
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
46
SELECT *
 FROM jos_docman
 WHERE id = '1'
47
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'docman'
 ORDER BY ordering
48
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