tabibzadeh
06-05-2008, 02:43 PM
بمجرد ايجاد يك محتوا و نوشتن يك مطلب ، پيام هاي ذيل اضافه ميشود
توجه فرمائيد اين آخرين رده پيام هاست ،
ضمنا برخي مطالب هم پاك ميشود ، نظير صفحه همياران
و يا قسمت اختياري محتوا بعد از نوشتن قسمت الزامي و قسمت اول خبر مطلب سيو نميز شود .
طبيب زاده
4
5
queries executed
1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=9) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1212671410 AND guest>=0) OR (time<1212672610 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='e26e7ba6d2560a69b6cce2f197d33216'
4
UPDATE mos_session SET `time`='1212676210',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1' WHERE session_id='e26e7ba6d2560a69b6cce2f197d33216'
5
SELECT count(*), type FROM mos_stats_agents WHERE (agent='Mozilla Firefox 2.0.0.14' AND type=0) OR (agent='Windows XP' AND type=1) OR (agent='net' AND type=2) GROUP BY type
6
INSERT INTO mos_stats_agents (agent,type) VALUES ('Mozilla Firefox 2.0.0.14',0)
7
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Windows XP' AND type=1
8
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='net' AND type=2
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Mozilla Firefox 2.0.0.14' AND type=0
10
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
11
SELECT * FROM mos_menu ORDER BY name
12
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.id='611' AND (a.state = '1' OR a.state = '-1')
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-06-05 16:30:10')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-06-05 16:30:10')
AND a.access <= 0
13
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 437
AND a.state = 1 AND ordering < 7
AND a.access <= '0'
ORDER BY a.ordering DESC
LIMIT 1
14
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 437
AND a.state = 1 AND ordering > 7
AND a.access <= '0'
ORDER BY a.ordering
LIMIT 1
15
UPDATE mos_content SET hits=(hits+1) WHERE id='611'
16
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2008-06-05' AND item_table='#__content' AND item_id='611'
17
UPDATE mos_core_log_items SET hits=(hits+1)
WHERE time_stamp='2008-06-05' AND item_table='#__content' AND item_id='611'
18
SELECT id, title, module, position, content, showtitle, params, published
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '9' OR mm.menuid = '0')
ORDER BY ordering
19
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
20
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 35,1
21
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='48'
22
SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-06-05 16:30:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-06-05 16:30:11')
AND catid='422'
ORDER BY a.ordering
LIMIT 50
23
SELECT * FROM mos_content WHERE id='376'
24
SELECT count(*) FROM mos_comment WHERE articleid='376' AND published='1'
25
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
26
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 18,1
27
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='29'
28
SELECT metakey FROM mos_content WHERE id='611'
29
SELECT id, title
FROM mos_content
WHERE id<>611 AND state=1 AND access <=0 AND (metakey LIKE '%معرفي و تاريخچه پروژه%' OR metakey LIKE '%سوابق طراح پروژه%' OR metakey LIKE '%زندگینامه خلد آشیان جنت مكان مرحوم اشرف الملوك معينيان ( طبيب زاده حكيمي )%')
30
SELECT i.id, i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id ORDER BY i.id DESC LIMIT 250
31
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=182
32
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=223
33
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=260
34
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=261
35
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=262
36
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=263
37
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=264
38
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=265
39
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=266
40
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=267
41
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=268
42
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=269
43
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
44
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
45
SELECT DISTINCT a.username
FROM mos_session AS a
WHERE (a.guest=0)
توجه فرمائيد اين آخرين رده پيام هاست ،
ضمنا برخي مطالب هم پاك ميشود ، نظير صفحه همياران
و يا قسمت اختياري محتوا بعد از نوشتن قسمت الزامي و قسمت اول خبر مطلب سيو نميز شود .
طبيب زاده
4
5
queries executed
1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=9) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1212671410 AND guest>=0) OR (time<1212672610 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='e26e7ba6d2560a69b6cce2f197d33216'
4
UPDATE mos_session SET `time`='1212676210',`userid`='0',`usertype`='',`us ername`='',`gid`='0',`guest`='1' WHERE session_id='e26e7ba6d2560a69b6cce2f197d33216'
5
SELECT count(*), type FROM mos_stats_agents WHERE (agent='Mozilla Firefox 2.0.0.14' AND type=0) OR (agent='Windows XP' AND type=1) OR (agent='net' AND type=2) GROUP BY type
6
INSERT INTO mos_stats_agents (agent,type) VALUES ('Mozilla Firefox 2.0.0.14',0)
7
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Windows XP' AND type=1
8
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='net' AND type=2
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Mozilla Firefox 2.0.0.14' AND type=0
10
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
11
SELECT * FROM mos_menu ORDER BY name
12
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
FROM mos_content AS a
LEFT JOIN mos_categories AS cc ON cc.id = a.catid
LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
LEFT JOIN mos_users AS u ON u.id = a.created_by
LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
LEFT JOIN mos_groups AS g ON a.access = g.id
WHERE a.id='611' AND (a.state = '1' OR a.state = '-1')
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-06-05 16:30:10')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-06-05 16:30:10')
AND a.access <= 0
13
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 437
AND a.state = 1 AND ordering < 7
AND a.access <= '0'
ORDER BY a.ordering DESC
LIMIT 1
14
SELECT a.id
FROM mos_content AS a
WHERE a.catid = 437
AND a.state = 1 AND ordering > 7
AND a.access <= '0'
ORDER BY a.ordering
LIMIT 1
15
UPDATE mos_content SET hits=(hits+1) WHERE id='611'
16
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2008-06-05' AND item_table='#__content' AND item_id='611'
17
UPDATE mos_core_log_items SET hits=(hits+1)
WHERE time_stamp='2008-06-05' AND item_table='#__content' AND item_id='611'
18
SELECT id, title, module, position, content, showtitle, params, published
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '9' OR mm.menuid = '0')
ORDER BY ordering
19
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
20
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 35,1
21
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='48'
22
SELECT a.id
FROM mos_content AS a
INNER JOIN mos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-06-05 16:30:11')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-06-05 16:30:11')
AND catid='422'
ORDER BY a.ordering
LIMIT 50
23
SELECT * FROM mos_content WHERE id='376'
24
SELECT count(*) FROM mos_comment WHERE articleid='376' AND published='1'
25
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
26
SELECT * FROM mos_banner WHERE showBanner=1
LIMIT 18,1
27
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='29'
28
SELECT metakey FROM mos_content WHERE id='611'
29
SELECT id, title
FROM mos_content
WHERE id<>611 AND state=1 AND access <=0 AND (metakey LIKE '%معرفي و تاريخچه پروژه%' OR metakey LIKE '%سوابق طراح پروژه%' OR metakey LIKE '%زندگینامه خلد آشیان جنت مكان مرحوم اشرف الملوك معينيان ( طبيب زاده حكيمي )%')
30
SELECT i.id, i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id ORDER BY i.id DESC LIMIT 250
31
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=182
32
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=223
33
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=260
34
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=261
35
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=262
36
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=263
37
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=264
38
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=265
39
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=266
40
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=267
41
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=268
42
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=269
43
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
44
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
45
SELECT DISTINCT a.username
FROM mos_session AS a
WHERE (a.guest=0)