- SELECT * 
 FROM jos_session
 WHERE session_id = 'uk2neav1819at32ocqpurmp673'
 
- DELETE 
 FROM jos_session
 WHERE ( TIME < '1761752919' )
 
- SELECT * 
 FROM jos_session
 WHERE session_id = 'uk2neav1819at32ocqpurmp673'
 
- UPDATE `jos_session` 
 SET `time`='1761753819',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:10:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1761753799;s:18:\"session.timer.last\";i:1761753814;s:17:\"session.timer.now\";i:1761753816;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:10:\"com_search\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:5:\"limit\";i:10;}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/spatiala/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:16:\"com_mailto.links\";a:2:{s:40:\"109b582027423414d6dd5eda424cf33efa36ac24\";O:8:\"stdClass\":2:{s:4:\"link\";s:51:\"https://www.spatialacademy.ir/prj/item/73-arch.html\";s:6:\"expiry\";i:1761753801;}s:40:\"15b2c942545d37cfb87d98e9fbf6bb27404a8825\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"https://www.spatialacademy.ir/tutorials.html?print=1&tmpl=component\";s:6:\"expiry\";i:1761753815;}}s:23:\"gantry-current-template\";s:13:\"rt_enigma_j15\";s:13:\"session.token\";s:32:\"c41af1598f2c9f8e8b62a40e6b7d798c\";}'
 WHERE session_id='uk2neav1819at32ocqpurmp673'
 
- SELECT * 
 FROM jos_components
 WHERE parent = 0
 
- SELECT folder AS TYPE, element AS name, params 
 FROM jos_plugins
 WHERE published >= 1
 AND access <= 0
 ORDER BY ordering
 
- SELECT * 
 FROM `jos_rsfirewall_configuration`
 
- SELECT template 
 FROM jos_templates_menu
 WHERE client_id = 0
 AND menuid = 0
 ORDER BY menuid DESC
 LIMIT 0, 1
 
- SELECT template 
 FROM jos_templates_menu
 WHERE client_id = 0
 AND menuid = 0
 ORDER BY menuid DESC
 LIMIT 0, 1
 
- SELECT `extension`, `file`, `type` 
 FROM `jos_rokcommon_configs`
 ORDER BY `priority`
 
- SELECT `ip` 
 FROM jos_rsfirewall_lists
 WHERE (`ip`='216.73.216.221' OR `ip` LIKE '%*%')
 AND `type`='1'
 AND `published`='1'
 
- SELECT `ip` 
 FROM jos_rsfirewall_lists
 WHERE (`ip`='216.73.216.221' OR `ip` LIKE '%*%')
 AND `type`='1'
 AND `published`='1'
 
- SELECT `ip`, `reason` 
 FROM jos_rsfirewall_lists
 WHERE (`ip`='216.73.216.221' OR `ip` LIKE '%*%')
 AND `type`='0'
 AND `published`='1'
 
- SELECT * 
 FROM jos_rsfirewall_hashes
 WHERE `type`='1.5.26'
 
- SELECT * 
 FROM jos_rsfirewall_hashes
 WHERE `type`='1.5.26'
 
- SELECT * 
 FROM jos_rsfirewall_hashes
 WHERE `type`='protect'
 
- SELECT * 
 FROM jos_rsfirewall_hashes
 WHERE `type`='protect'
 
- SELECT m.*, c.`option` AS component 
 FROM jos_menu AS m
 LEFT JOIN jos_components AS c
 ON m.componentid = c.id
 WHERE m.published = 1
 ORDER BY m.sublevel, m.parent, m.ordering
 
- SELECT `ip` 
 FROM jos_rsfirewall_lists
 WHERE (`ip`='216.73.216.221' OR `ip` LIKE '%*%')
 AND `type`='1'
 AND `published`='1'
 
- SELECT `ip` 
 FROM jos_rsfirewall_lists
 WHERE (`ip`='216.73.216.221' OR `ip` LIKE '%*%')
 AND `type`='1'
 AND `published`='1'
 
- SELECT template 
 FROM jos_templates_menu
 WHERE client_id = 0
 AND (menuid = 0 OR menuid = 89)
 ORDER BY menuid DESC
 LIMIT 0, 1
 
- SELECT id, parent_id, VALUE, name, lft, rgt 
 FROM jos_core_acl_aro_groups
 WHERE id=23
 
- SELECT id 
 FROM jos_k2_categories
 WHERE published=1
 AND trash=0
 AND access<=0
 
- SELECT * 
 FROM jos_k2_items
 WHERE id=11
 LIMIT 0, 1
 
- SELECT * 
 FROM jos_k2_categories
 WHERE id = '6'
 
- SELECT tag.*
 
 FROM jos_k2_tags AS tag
 JOIN jos_k2_tags_xref AS xref
 ON tag.id = xref.tagID
 
 WHERE tag.published=1
 
 AND xref.itemID = 11
 ORDER BY xref.id ASC
 
- SELECT * 
 FROM jos_k2_attachments
 WHERE itemID=11
 
- SELECT * 
 FROM jos_k2_rating
 WHERE itemID = 11
 
- SELECT * 
 FROM jos_users
 WHERE id = '63'
 
- SELECT id, gender, description, image, url, `group`, plugins 
 FROM jos_k2_users
 WHERE userID=63
 
- SELECT COUNT(*) 
 FROM jos_k2_comments
 WHERE itemID=11
 AND published=1
 
- SELECT g.* 
 FROM jos_core_acl_aro_groups AS g
 INNER JOIN jos_core_acl_groups_aro_map AS gm
 ON gm.group_id = g.id
 INNER JOIN jos_core_acl_aro AS ao
 ON ao.id = gm.aro_id
 WHERE ao.VALUE='63'
 ORDER BY g.id
 
- UPDATE jos_k2_items 
 SET hits = ( hits + 1 )
 WHERE id='11'
 
- SELECT * 
 FROM jos_jcomments_settings
 
- SELECT COUNT(*)
 
 FROM jos_jcomments AS c
 
 WHERE c.object_id = 11
 AND c.object_group = 'com_k2'
 AND c.published = 1
 
- SELECT *  
 FROM `jos_jcomments_objects`
 WHERE `object_id` = '11'
 AND `object_group` = 'com_k2'
 AND `lang` = 'fa-IR'
 
- SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
 , c.email, c.homepage, c.DATE, c.DATE AS datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
 , c.isgood, c.ispoor
 , v.VALUE AS voted
 , CASE WHEN c.parent = 0 THEN unix_timestamp(c.DATE) ELSE 0 END AS threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
 
 FROM jos_jcomments AS c
 
 LEFT JOIN jos_jcomments_votes AS v
 ON c.id = v.commentid
 AND v.userid = 0
 AND v.ip = '216.73.216.221'
 
 WHERE c.object_id = 11
 AND c.object_group = 'com_k2'
 AND c.published = 1
 
 ORDER BY c.parent, c.DATE DESC
 
- SELECT i.*, c.alias AS categoryalias 
 FROM jos_k2_items AS i
 
 LEFT JOIN jos_k2_categories c
 ON c.id = i.catid
 
 WHERE i.id != 11
 
 AND i.published = 1
 
 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-29 16:03:39' )
 
 AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-29 16:03:39' )
 AND i.access <= 0
 AND i.trash = 0
 
 AND i.created_by = 63
 
 AND i.created_by_alias=''
 
 AND c.published = 1
 AND c.access <= 0
 AND c.trash = 0
 
 ORDER BY i.created DESC
 LIMIT 0, 20
 
- SELECT DISTINCT itemID 
 FROM jos_k2_tags_xref
 WHERE tagID IN (18,19,20,21,22,23,24,25)
 AND itemID!=11
 
- SELECT i.*, c.alias AS categoryalias 
 FROM jos_k2_items AS i
 
 LEFT JOIN jos_k2_categories c
 ON c.id = i.catid
 
 WHERE i.published = 1
 
 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-10-29 16:03:39' )
 
 AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-29 16:03:39' )
 AND i.access <= 0
 AND i.trash = 0
 
 AND c.published = 1
 AND c.access <= 0
 AND c.trash = 0
 
 AND (i.id) IN (10,25,14,32,142,162,354)
 
 ORDER BY i.created DESC
 LIMIT 0, 5
 
- SELECT * 
 FROM jos_k2_categories
 WHERE id = '51'
 
- SELECT * 
 FROM jos_users
 WHERE id = '62'
 
- SELECT id, gender, description, image, url, `group`, plugins 
 FROM jos_k2_users
 WHERE userID=62
 
- SELECT COUNT(*) 
 FROM jos_k2_comments
 WHERE itemID=354
 AND published=1
 
- SELECT g.* 
 FROM jos_core_acl_aro_groups AS g
 INNER JOIN jos_core_acl_groups_aro_map AS gm
 ON gm.group_id = g.id
 INNER JOIN jos_core_acl_aro AS ao
 ON ao.id = gm.aro_id
 WHERE ao.VALUE='62'
 ORDER BY g.id
 
- SELECT COUNT(*) 
 FROM jos_k2_comments
 WHERE itemID=162
 AND published=1
 
- SELECT * 
 FROM jos_k2_categories
 WHERE id = '39'
 
- SELECT * 
 FROM jos_users
 WHERE id = '119'
 
- SELECT id, gender, description, image, url, `group`, plugins 
 FROM jos_k2_users
 WHERE userID=119
 
- SELECT COUNT(*) 
 FROM jos_k2_comments
 WHERE itemID=32
 AND published=1
 
- SELECT g.* 
 FROM jos_core_acl_aro_groups AS g
 INNER JOIN jos_core_acl_groups_aro_map AS gm
 ON gm.group_id = g.id
 INNER JOIN jos_core_acl_aro AS ao
 ON ao.id = gm.aro_id
 WHERE ao.VALUE='119'
 ORDER BY g.id
 
- SELECT * 
 FROM jos_k2_categories
 WHERE id = '17'
 
- SELECT COUNT(*) 
 FROM jos_k2_comments
 WHERE itemID=25
 AND published=1
 
- SELECT * 
 FROM jos_k2_categories
 WHERE id = '16'
 
- SELECT COUNT(*) 
 FROM jos_k2_comments
 WHERE itemID=14
 AND published=1
 
- SELECT * 
 FROM jos_k2_items
 WHERE id != 11
 AND catid=6
 AND ordering > 2
 AND published=1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-10-29 16:03:39' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-10-29 16:03:39' )
 AND access <= 0
 AND trash=0
 ORDER BY ordering ASC
 LIMIT 0, 1
 
- SELECT * 
 FROM jos_k2_items
 WHERE id != 11
 AND catid=6
 AND ordering < 2
 AND published=1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-10-29 16:03:39' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-10-29 16:03:39' )
 AND access <= 0
 AND trash=0
 ORDER BY ordering DESC
 LIMIT 0, 1
 
- SELECT params 
 FROM jos_components AS c
 WHERE c.OPTION='com_widgetkit'
 
- SELECT id, title, module, POSITION, content, showtitle, control, params 
 FROM jos_modules AS m
 LEFT JOIN jos_modules_menu AS mm
 ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id = 0
 AND ( mm.menuid = 89 OR mm.menuid = 0 )
 ORDER BY POSITION, ordering
 
- SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.fulltext ) AS readmore  
 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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-10-29 16:03:39' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-10-29 16:03:39' )
 AND s.id > 0
 AND a.access <= 0
 AND cc.access <= 0
 AND s.access <= 0
 AND (cc.id=11)
 AND (s.id=1)
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.ordering
 
نظرات
مهندس چرا همه لینکها خرابه ؟ اصلا نمیتونم چیزی دانلود کنم
فیلم آموزشی شما و دوستان خیلی خوبه
اگه می شه یه کتاب راجع به مدل های جی آی اس معرفی کنید
با سپاس
با تشكر از مطالب مفيدي كه خالصانه در اختيار كارشناسان و بهره برداران قرار ميديد
لطفا در صورت امكان چگونگي تبديل فرمت DWGباتبديل اطلاعات جداولش به فرمت Shape توضيح دهيد يا فيلم آموزشي بذاريد . ممنون
بنده حامد نوری ترم آخر رشته عمران سازه هیدرولیکی هستم برای پایان نامم از آرک جی آی اس دارم استفاده می کنم
من فایل های آموزشی تصویری شما رو از وبلاگتون دانلود کردم
خیلی آموزنده بود فقط داخل صحبتها تون از یک کتاب جی آی اس صحبت می کردید میشه این کتابو معرفی کنید و بگید از کجا میشه تهیه کرد.
ممنون
ممکن است اموزش کامل رسم نقشه ژئوشیمی را برام بگذاریذ ممنون
منظورتون روزنامه همشری که نیست
بدون تعارف از آموزش های بسیار خوبتون واقعا متشکر و ممنونم انشالله که زیر سایهخداوندگار با قدرت تمام به کارتون اداده بدین.بازم ازتون ممنونم
ممنون از حسن نظر و توجه تان.. با حمایت شما چه به صورت اطلاع رسانی چه به صورت همکاری در تهیه مطالب روز های خوبی را برای این آب و خاک رقم بزنیم..
با سپاس از آموزش هایی که در سایت گذاشتید
به زودی مطالب بیشتری منتشر خواهد شد.
واقعا ممنون.خیلی عالی و کاربردی است.
منون از حسن نظرتان.. با معرفی این مطالب به سایر دوستان ما را یاری کنید.
واقعا مطالبتون کاربردیه. من ویدیوهای آموزشی شما رو تو یوتوب دیدم. خیلی به کارم اومده. بازم ممنون
برای دسترسی عزیزان داخل کشور و بهره برداری از کیفیت خوب تصویر در اف تی پی خود سایت قابل دسترس می باشد
با حمایت های دوستان بزرگ واری همچون شما روز های بهتری را پیش رو خواهیم داشت
فید آر اس اس برای نظرات به این ارسال