....................................../////.===Shadow-Here===./////................................................ > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < > < ------------------------------------------------------------------------------------------------------------------- /////////////////////////////////////////////////////////////////////////////////////////////////////////////////// RIFF¤ WEBPVP8 ˜ ðÑ *ôô>‘HŸK¥¤"§£±¨àð enü¹%½_F‘åè¿2ºQú³íªú`N¿­3ÿƒügµJžaÿ¯ÿ°~¼ÎùnúîÞÖô•òíôÁÉß®Sm¥Ü/ ‡ó˜f£Ùà<˜„xëJ¢Ù€SO3x<ªÔ©4¿+ç¶A`q@Ì“Úñè™ÍÿJÌ´ª-˜ÆtÊÛL]Ïq*‘Ý”ì#ŸÌÏãY]@ê`¿ /ªfkØB4·®£ó z—Üw¥Pxù–ÞLШKÇN¾AkÙTf½è'‰g gÆv›Øuh~ a˜Z— ïj*á¥t d£“uÒ ¨`K˜¹ßþ]b>˜]_ÏÔ6W—è2r4x•íÖ…"ƒÖNîä!¦å Ú}ýxGøÌ —@ ;ÆÚŠ=ɾ1ý8lªË¥ô ^yf®Œ¢u&2©nÙÇ›ñÂñŒ³ aPo['½»øFùà­+4ê“$!lövlüÞ=;N®3ð‚õ›DÉKòÞ>ÄÍ ¥ˆuߤ#ˆ$6ù™¥îŠ‡y’ÍB¼ çxÛ;X"WL£R÷͝*ó-¶Zu}º.s¸sšXqù–DþÿvªhüïwyŸ ¯é³lÀ:KCûÄ£Ëá\…­ ~—ýóî ¼ûûÜTÓüÇy…ŽÆvc»¾×U ñ¸žþоP÷¦ó:Ò¨¨5;Ð#&#ÖúñläÿÁœ GxÉ­/ñ‡áQðìYÉtÒwŽ¼GÔ´zàÒò ð*ëzƒ•4~H]Ø‹f ñÓÈñ`NåWçs'ÆÏW^ø¹!XžµmQ5ÃËoLœÎ: ÞËÍ¥J ù…î èo£ßPÎñ¶ž8.Œ]ʵ~5›ÙË-ù*8ÙÖß±~ ©¹rÓê‚j¶d¸{^Q'˜±Crß ÚH—#¥¥QlÀ×ëã‡DÜ«èî þ&Çæžî;ŽÏºò6ÒLÃXy&ZŒ'j‚¢Ù€IßÚù+–MGi‰*jE€‘JcÜ ÓÌ EÏÚj]o˜ Þr <¾U ûŪæÍ/šÝH¥˜b”¼ ÁñßX GP›ï2›4WŠÏà×£…íÓk†¦H·ÅíMh–*nó÷à]ÁjCº€b7<ب‹¨5車bp2:Á[UªM„QŒçiNMa#<5›áËó¸HýÊ"…×Éw¹¦ì2º–x<›»a±¸3Weü®FÝ⑱ö–î–³|LPÈ~çð~Çå‡|º kD¢µÏàÆAI %1À% ¹Ò – ”ϝS¦‰4&¶£°à Öý”û_Ò Áw°A«Å€?mÇÛgHÉ/8)á¾ÛìáöŽP í¨PŸNÙµº¦‡§Ùš"ÿ«>+ªÕ`Ê÷‡‚ß Õû˜þãÇ-PÍ.¾XV‘€ dÜ"þ4¹ ±Oú‘©t¥¦FªÄÃÄ•b‚znýu½—#cDs˜ÃiÑOˆñ×QO=*IAÊ,¶ŽZƒ;‡wøXè%EÐk:F±Ú” .Ѽ+Áu&Ç`."pÈÉw o&¿dE6‘’EqTuK@Ì¥ã™À(Êk(h‰,H}RÀIXÛš3µ1©_OqÚÒJAñ$ÊÙÜ;D3çŒ[þùœh¬Ã³™ö6ç†NY".Ú‰ï[ªŸŒ '²Ð öø_¨ÂÉ9u鶳ÒŠõTàîMØ#û¯gN‡bÙ놚X„ö …ÉeüÌ^J ‹€.œ$Æ)βÄeæW#óüßĺŸ€ ÀzwV 9oä»f4V*uB «Ë†¹ì¯žR霓æHXa=&“I4K;¯ç‹h×·"UŠ~<•â•ªVêª&ÍSÃÆÅ?ÔqÎ*mTM ˜›µwêd#[C¡©§‘D<©àb†–ÁœøvH/,í:¯( ²£|4-„Æövv„Yͼ™^Á$ˆ„¢Û[6yB.åH*V¨æ?$=˜Ñ€•î¦ñ·­(VlŸ‘ nÀt8W÷´Bûba?q9ú¶Xƒl«ÿ\ù¶’þòUÐj/õ¢Ìµ³g$ƒÎR!¸»|Oߍë’BhîÚÑ¢ñåŒJ„®„£2Ð3•ô02Nt…!£Í]Ïc½Qÿ?ˆ<&ÃA¾Ú,JˆijÌ#5yz„‰Î|ÊŽ5QÏ:‹ÐaóVÔxW—CpeÏzÐïíçôÿÅ_[hãsÐ_/ŽTÝ?BîˆííV$<¿i>²F¬_Eß¿ †bÊŒº­ÿ®Z H“C}”¬,Mp ý/Bá£w>˜YV°aƒúh+cŠ- r/[%|üUMHäQ°X»|û/@|°¥Ð !BÔ Ç¢Ä©š+Õì D«7ìN¶ŽðÔ " ƶ’ÖçtA‰Û×}{tþz­¾GÍ›k¹OEJR$ Â׃ «ëÁ"oÉôž$oUK(Ä)Ãz³Ê-‹êN[Ò3Œñbï8P 4ƒ×q¢bo|?<ÛX¬òÄÍ°L–±›(™ûG?ýË©ÚÄ–ÂDØÐ_Ç¡ô ¾–ÄÏø ×e8Ë©$ÄF¹Å‹ì[©óìl:F¾f´‹‹Xì²ï®\¬ôùƒ ÿat¥óèÒùHß0äe‚;ü×h:ÆWðHž=Ã8骣"kœ'Y?³}Tûè€>?0l›e1Lòñ„aæKÆw…hÖŠùW…ÈÆÄ0ši·›[pcwËþñiêíY/~-Á5˜!¿†A›™Mÿþ(±“t@â“ö2­´TG5yé]çå僳 .·ÍïçÝ7UÚ±Ð/Nè»,_Ï ùdj7\ï Wì4›„»c¸àešg#ÒÊ⥭áØo5‘?ÌdÝô¯ ¹kzsƒ=´#ëÉK›Ø´±-¥eW?‡çßtòTã…$Ý+qÿ±ƒ÷_3Ô¥í÷:æ–ž<·Ö‡‰Å¢ š‡%Ô—utÌÈìðžgÖÀz²À—ï÷Óîäõ{K'´È÷³yaÏÁjƒô}ž§®æÊydÕÈë5¯èˆõvÕ©ã*çD„ “z„Ó‡^^xÂ3M§A´JG‚öï 3W'ˆ.OvXè¡ÊÕª?5º7†˜(˜Ç¶#çê’¶!ÌdZK§æ 0fãaN]òY³RV ™î$®K2R¨`W!1Ôó\;Ý ýB%qæK•&ÓÈe9È0êI±žeŸß -ú@žQr¦ ö4»M¼Áè¹µmw 9 EÆE_°2ó„ŸXKWÁ×Hóì^´²GѝF©óäR†¦‰ç"V»eØ<3ùd3ÿÚ¤Žú“Gi" —‘_ÙËÎ~Üö¯¥½Î»üŸEÚŽåmÞþí ;ÞólËΦMzA"Âf(´òá;Éï(/7½ûñÌ­cïÕçлþÝz¾-ÍvÑ“pH­–ðÓj$¸Äû¤‚‘ãUBË-n“2åPkS5&‹Â|+g^œ®Ì͆d!OïäîU«c;{Û!ÅŽ«ëZ9Ókóˆ]¯ƒ›né `ÇÒ+tÆš (ØKá¾—=3œ®•vuMñg²\ï Ec€ 05±d™‡×iÇ×›UúvÌ¢£Èþ¡ÕØô¶ßÎA"ß±#Ö²ˆÊŸ¦*Ä~ij|àø.-¼'»Ú¥£h ofº¦‡VsR=N½„Î v˜Z*SÌ{=jÑB‹tê…;’HžH¯8–îDù8ñ¢|Q•bÛçš–‹m³“ê¨ åÏ^m¬Žãþ©ïêO‡½6] µÆ„Ooòü ²x}N¦Ë3ïé¿»€›HA˜m%çÞ/¿í7Fø“‹léUk)É°Œµ8Q8›:ÀŠeT*šõ~ôڝG6 ¢}`ùH­–”¡k ‰P1>š†®9z11!X wKfmÁ¦xÑ,N1Q”–æB¶M…ÒÃv6SMˆhU¬ÊPŽï‘öj=·CŒ¯u¹ƒVIЃsx4’ömÛýc塶7ßŠß 57^\wÒÐÆ k§h,Œý î«q^R½3]J¸ÇðN ‚çU¬ôº^Áì} ³f©Õœ§ˆã:FÄÈ‚é(€™?àýÓüè1Gô£¼éj‚OÅñ  #>×—ßtà 0G¥Åa뀐kßhc™À_ÉñÞ#±)GD" YîäË-ÿÙ̪ ¹™a¯´¢E\ÝÒö‚;™„ë]_ p8‰o¡ñ+^÷ 3‘'dT4œŽ ðVë½° :¬víÑ«£tßÚS-3¶“þ2 †üüʨòrš¹M{É_¤`Û¨0ìjœøJ‡:÷ÃáZ˜†@GP&œÑDGÏs¡þ¦þDGú‘1Yá9Ôþ¼ ûø…§÷8&–ÜÑnÄ_m®^üÆ`;ÉVÁJ£?â€-ßê}suÍ2sõA NÌúA磸‘îÿÚ»ƒìö·á¿±tÑÐ"Tÿü˜[@/äj¬€uüªìù¥Ý˜á8Ý´sõj 8@rˆð äþZÇD®ÿUÏ2ùôõrBzÆÏÞž>Ì™xœ“ wiÎ×7_… ¸ \#€MɁV¶¥üÕÿPÔ9Z‡ø§É8#H:ƒ5ÀÝå9ÍIŒ5åKÙŠ÷qÄ>1AÈøžj"µÂд/ªnÀ qªã}"iŸBå˜ÓÛŽ¦…&ݧ;G@—³b¯“•"´4í¨ôM¨åñC‹ïùÉó¯ÓsSH2Ý@ßáM‡ˆKÀªÛUeø/4\gnm¥‹ŸŒ qÄ b9ÞwÒNÏ_4Ég³ú=܆‚´ •â¥õeíþkjz>éÚyU«Íӝ݃6"8/ø{=Ô¢»G¥ äUw°W«,ô—¿ãㆅү¢³xŠUû™yŒ (øSópÐ 9\åTâ»—*oG$/×ÍT†Y¿1¤Þ¢_‡ ¼ „±ÍçèSaÓ 3ÛMÁBkxs‰’R/¡¤ˆÙçª(*õ„üXÌ´ƒ E§´¬EF"Ù”R/ÐNyÆÂ^°?™6¡œïJ·±$§?º>ÖüœcNÌù¯G ‹ñ2ŠBB„^·úìaz¨k:#¨Æ¨8LÎõލ£^§S&cŒÐU€ü(‡F±Š¼&P>8ÙÁ ‰ p5?0ÊƃZl¸aô š¼¡}gÿ¶zÆC²¹¬ÎÖG*HB¡O<º2#ñŒAƒ–¡B˜´É$¥›É:FÀÔx¾u?XÜÏÓvN©RS{2ʈãk9rmP¼Qq̳ è¼ÐFׄ^¡Öì fE“F4A…!ì/…¦Lƒ… … $%´¾yã@CI¬ á—3PþBÏNÿ<ý°4Ü ËÃ#ØÍ~âW«rEñw‹eùMMHß²`¬Öó½íf³:‹k˜¯÷}Z!ã¿<¥,\#öµÀ¯aÒNÆIé,Ћ–lŽ#Àæ9ÀÒS·I’½-Ïp Äz¤Š Â* ­íÄ9­< h>׍3ZkËU¹§˜ŒŠ±f­’¤º³Q ÏB?‹#µíÃ¥®@(Gs«†vI¥Mµ‹Á©e~2ú³ÁP4ìÕi‚²Ê^ö@-DþÓàlÜOÍ]n"µã:žpsŽ¢:! Aõ.ç~ÓBûH÷JCÌ]õVƒd «ú´QÙEA–¯¯Œ!.ˆˆëQ±ù œ·Ì!Õâ )ùL„ÅÀlÚè5@B…o´Æ¸XÓ&Û…O«˜”_#‡ƒ„ûÈt!¤ÁÏ›ÎÝŠ?c9 â\>lÓÁVÄÑ™£eØY]:fÝ–—ù+p{™ðè û³”g±OƒÚSù£áÁÊ„ä,ï7š²G ÕÌBk)~ÑiCµ|h#u¤¶îK¨² #²vݯGãeÖ϶ú…¾múÀ¶þÔñ‚Š9'^($¤§ò “š½{éúp÷J›ušS¹áªCÂubÃH9™D™/ZöØÁ‡¦ÝÙŸ·kð*_”.C‹{áXó€‡c¡c€§/šò/&éš÷,àéJþ‰X›fµ“C¨œ®r¬"kL‰Â_q…Z–.ÉL~O µ›zn‚¹À¦Öª7\àHµšÖ %»ÇníV[¥*Õ;ƒ#½¾HK-ÖIÊdÏEÚ#=o÷Óò³´Š: Ç?{¾+9›–‘OEáU·S€˜j"ÄaÜ ŒÛWt› á–c#a»pÔZÞdŽtWê=9éöÊ¢µ~ ë ;Öe‡Œ®:bî3±ýê¢wà¼îpêñ¹¾4 zc¾ðÖÿzdêŒÑÒŝÀ‰s6¤í³ÎÙB¿OZ”+F¤á‡3@Ñëäg©·Ž ˆèª<ù@É{&S„œÕúÀA)‰h:YÀ5^ÂÓŒ°õäU\ ùËÍû#²?Xe¬tu‰^zÒÔãë¼ÛWtEtû …‚g¶Úüâî*moGè¨7%u!]PhÏd™Ý%Îx: VÒ¦ôÊD3ÀŽKÛËãvÆî…N¯ä>Eró–ð`5 Œ%u5XkñÌ*NU%¶áœÊ:Qÿú»“úzyÏ6å-၇¾ ´ ÒÊ]y žO‘w2Äøæ…H’²f±ÎÇ.ª|¥'gîV•Ü .̘¯€šòü¤U~Ù†*¢!?ò wý,}´°ÔÞnïoKq5µb!áÓ3"vAßH¡³¡·G(ÐÎ0Îò¼MG!/ài®@—¬04*`…«é8ªøøló“ˆÊ”èù¤…ßÊoÿé'ËuÌÖ5×È¡§ˆˆfŽë9}hìâ_!!¯  B&Ëö¶‰ÀAÙNVŸ Wh›¸®XÑJì¨ú“¿÷3uj²˜¨ÍÎìë±aúŠÝå¯ð*Ó¨ôJ“yºØ)m°WýOè68†ŸÏ2—‰Ïüꪫٚ¥‹l1 ø ÏÄFjêµvÌbü¦èÝx:X±¢H=MÐß—,ˆÉÇ´(9ú¾^ÅÚ4¿m‡$âX‘å%(AlZo@½¨UOÌÕ”1ø¸jÎÀÃÃ_ µ‘Ü.œº¦Ut: Æï’!=¯uwû#,“pþÇúŒø(é@?³ü¥‘Mo §—s@Œ#)§ŒùkL}NOÆêA›¸~r½¼ÙA—HJ«eˆÖ´*¡ÓpÌŸö.m<-"³ûÈ$¬_6­åf£ïÚâj1y§ÕJ½@dÞÁr&Í\Z%D£Íñ·AZ Û³øüd/ªAi†/Й~  ‡âĮҮÏh§°b—›Û«mJžòG'[ÈYýŒ¦9psl ýÁ ®±f¦x,‰½tN ‚Xª9 ÙÖH.«Lo0×?͹m¡å†Ѽ+›2ƒF ±Ê8 7Hցϓ²Æ–m9…òŸï]Â1äN†VLâCˆU .ÿ‰Ts +ÅÎx(%¦u]6AF Š ØF鈄‘ |¢¶c±soŒ/t[a¾–û:s·`i햍ê›ËchÈ…8ßÀUÜewŒðNOƒõD%q#éû\9¤x¹&UE×G¥ Í—™$ð E6-‡¼!ýpãÔM˜ Âsìe¯ñµK¢Ç¡ùôléœ4Ö£”À Š®Ðc ^¨À}ÙËŸ§›ºê{ÊuÉC ×Sr€¤’fÉ*j!úÓ’Gsùìoîßîn%ò· àc Wp÷$¨˜)û»H ×8ŽÒ€Zj¤3ÀÙºY'Ql¦py{-6íÔCeiØp‘‡XÊîÆUߢ܂ž£Xé¼Y8þ©ëgñß}é.ÎógÒ„ÃØËø¯»™§Xýy M%@NŠ À(~áÐvu7&•,Ù˜ó€uP‡^^®=_E„jt’ 403WebShell
403Webshell
Server IP : 213.186.33.2  /  Your IP : 216.73.216.250
Web Server : Apache
System : Linux webd003.cluster102.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64
User : uneseuleoc ( 96096)
PHP Version : 7.4.33
Disable Function : _dyuweyrj4,_dyuweyrj4r,dl
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /home/uneseuleoc/crid/web/app/plugins/ultimate-maps-by-supsystic/modules/marker/models/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/uneseuleoc/crid/web/app/plugins/ultimate-maps-by-supsystic/modules/marker/models/marker.php
<?php
class markerModelUms extends modelUms {
   public static $tableObj;
   function __construct() {
      $this->_setTbl('marker');
      if (empty(self::$tableObj)) {
         self::$tableObj = frameUms::_()->getTable('marker');
      }
   }
   public function save($marker = array() , &$update = false) {
      $id = isset($marker['id']) ? (int)$marker['id'] : 0;
      $marker['title'] = isset($marker['title']) ? trim($marker['title']) : '';
      $marker['coord_x'] = isset($marker['coord_x']) ? (float)$marker['coord_x'] : 0;
      $marker['coord_y'] = isset($marker['coord_y']) ? (float)$marker['coord_y'] : 0;
      if (!empty($marker['period_date_from']) && strtotime($marker['period_date_from'])) {
         $marker['period_from'] = date('Y-m-d', strtotime($marker['period_date_from']));
      }
      if (!empty($marker['period_date_to']) && strtotime($marker['period_date_to'])) {
         $marker['period_to'] = date('Y-m-d', strtotime($marker['period_date_to']));
      }
      $update = (bool)$id;
      if (!empty($marker['title'])) {
         $marker = apply_filters('ums_before_marker_save', $marker);
         if (isset($marker['description'])) {
            //Replace site url in markers descriptions backend. Fixed site migration issue.
            $marker['description'] = str_replace(UMS_SITE_URL, 'UMS_SITE_URL', $marker['description']);
         }
         if (!isset($marker['marker_group_id'])) {
            $marker['marker_group_id'] = 0;
         }
         if (!isset($marker['icon']) || !frameUms::_()->getModule('icons')
            ->getModel()
            ->iconExists($marker['icon'])) {
            $marker['icon'] = 1;
         }
         $marker['map_id'] = isset($marker['map_id']) ? (int)$marker['map_id'] : 0;
         if (!$update) {
            $marker['create_date'] = date('Y-m-d H:i:s');
            if ($marker['map_id']) {
               //$maxSortOrder = (int)dbUms::get('SELECT MAX(sort_order) FROM @__markers WHERE map_id = "' . $marker['map_id'] . '"', 'one');
               global $wpdb;
               $maxSortOrder = $wpdb->get_var("SELECT MAX(sort_order) FROM {$wpdb->prefix}ums_markers WHERE " . $wpdb->prepare("map_id = %s", $marker['map_id']));
               $marker['sort_order'] = ++$maxSortOrder;
            }
         }
         //save first groups value in markers table to better compatibility
         $markerGroupIds = $marker['marker_group_id'];
         $first_value = is_array($markerGroupIds) ? reset($markerGroupIds) : 0;
         $marker['marker_group_id'] = $first_value;

         $marker['params'] = isset($marker['params']) ? utilsUms::serialize($marker['params']) : '';
         if ($update) {
            dispatcherUms::doAction('beforeMarkerUpdate', $id, $marker);
            global $wpdb;
            $tableName = $wpdb->prefix . "ums_markers";
            $data_update = array(
                'title' => $marker['title'],
                'description' => $marker['description'],
                'icon' => $marker['icon'],
                'address' => $marker['address'],
                'coord_x' => $marker['coord_x'],
                'coord_y' => $marker['coord_y'],
                'params' => $marker['params'],
                'id' => $marker['id'],
                'map_id' => $marker['map_id'],
                'marker_group_id' => $marker['marker_group_id'],
            );
            if (!empty($marker['create_date'])) {
              $data_update['create_date'] = $marker['create_date'];
            }
            if (!empty($marker['sort_order'])) {
              $data_update['sort_order'] = $marker['sort_order'];
            }
            $data_where = array(
               'id' => $id
            );
            $dbRes = $wpdb->update($tableName, $data_update, $data_where);
            if ($dbRes) {
               $dbResId = $id;
            }

            $tableName = $wpdb->prefix . "ums_marker_groups_relation";
            $data_where = array(
               'marker_id' => $marker['id']
            );
            $wpdb->delete($tableName, $data_where);

            if (!empty($markerGroupIds)) {
               foreach ($markerGroupIds as $markerId) {
                  global $wpdb;
                  $tableName = $wpdb->prefix . "ums_marker_groups_relation";
                  $dbRes = $wpdb->insert($tableName, array(
                     'marker_id' => $marker['id'],
                     'groups_id' => $markerId,
                  ));
                  if ($dbRes) {
                     $dbResId = $wpdb->insert_id;;
                  }

               }
            }
            dispatcherUms::doAction('afterMarkerUpdate', $id, $marker);
         }
         else {
            dispatcherUms::doAction('beforeMarkerInsert', $marker);

            global $wpdb;
            $tableName = $wpdb->prefix . "ums_markers";
            $dbRes = $wpdb->insert($tableName, array(
               'title' => $marker['title'],
               'description' => $marker['description'],
               'icon' => $marker['icon'],
               'address' => $marker['address'],
               'coord_x' => $marker['coord_x'],
               'coord_y' => $marker['coord_y'],
               'params' => $marker['params'],
               'map_id' => $marker['map_id'],
               'marker_group_id' => $marker['marker_group_id'],
               'create_date' => $marker['create_date'],
               'sort_order' => !empty($marker['sort_order']) ? $marker['sort_order'] : '',
            ));
            if ($dbRes) {
               $dbResId = $wpdb->insert_id;;
            }
            if ($dbRes) {
               $tableName = $wpdb->prefix . "ums_marker_groups_relation";
               $data_where = array(
                  'marker_id' => $dbResId
               );
               $wpdb->delete($tableName, $data_where);
               if (!empty($markerGroupIds) && is_array($markerGroupIds)) {
                  foreach ($markerGroupIds as $markerId) {
                     $tableName = $wpdb->prefix . "ums_marker_groups_relation";
                     $wpdb->insert($tableName, array(
                        'marker_id' => $dbResId,
                        'groups_id' => $markerId,
                     ));
                  }
               }
            }
            dispatcherUms::doAction('afterMarkerInsert', $dbResId, $marker);
         }
         if ($dbResId) {
            if (!$update) {
               $id = $dbResId;
            }
            do_action('ums_save_lang_data', array(
               'type' => 'markers',
               'marker_id' => $id,
               'map' => frameUms::_()->getModule('maps')
                  ->getModel()
                  ->getMapById($marker['map_id']) ,
            ));
            return $id;
         }
         else {
            $this->pushError(frameUms::_()
               ->getTable('marker')
               ->getErrors());
         }
      }
      else {
         $this->pushError(__('Please enter marker name', UMS_LANG_CODE) , 'marker_opts[title]');
      }
      return false;
   }
   public function existsId($id) {
      if ($id) {
        global $wpdb;
        $marker = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}ums_markers WHERE " . $wpdb->prepare("id = %s", $id), ARRAY_A);
         // $marker = frameUms::_()->getTable('marker')
         //    ->get('*', array(
         //    'id' => $id
         // ) , '', 'row');
         if (!empty($marker)) {
            return true;
         }
      }
      return false;
   }
   public function getById($id) {
      global $wpdb;
      $row = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}ums_markers WHERE " . $wpdb->prepare("id = %s", $id), ARRAY_A);
      return $this->_afterGet($row);
    //   return $this->_afterGet(
    //     frameUms::_()
    //      ->getTable('marker')
    //      ->get('*', array(
    //      'id' => $id
    //   ) , '', 'row')
    // );
   }
   public function getMarkerByTitle($title) {
     global $wpdb;
     $row = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}ums_markers WHERE " . $wpdb->prepare("title = %s", $title), ARRAY_A);
     return $this->_afterGet($row);
      // return $this->_afterGet(frameUms::_()
      //    ->getTable('marker')
      //    ->get('*', array(
      //    'title' => $title
      // ) , '', 'row'));
   }
   public function _afterGet($marker, $widthMapData = false, $withoutIcons = false) {
      if (!empty($marker)) {
         if (!$withoutIcons) {
            $marker['icon_data'] = frameUms::_()->getModule('icons')
               ->getModel()
               ->getIconFromId($marker['icon']);
         }
         $marker['params'] = utilsUms::unserialize($marker['params']);

         if (isset($marker['params']['marker_title_link']) && !empty($marker['params']['marker_title_link']) && strpos($marker['params']['marker_title_link'], 'http') !== 0) {
            $marker['params']['marker_title_link'] = 'http://' . $marker['params']['marker_title_link'];
         }
         if (!empty($marker['params']['title_is_link'])) $marker['params']['title_is_link'] = false;

         $siteUrl = uriUms::isHttps() ? uriUms::makeHttps(UMS_SITE_URL) : UMS_SITE_URL;
         // Go to absolute path as "../wp-content/" will not work on frontend
         $marker['description'] = str_replace('../wp-content/', $siteUrl . 'wp-content/', $marker['description']);
         //Replace site url in markers descriptions frontend.
         $marker['description'] = str_replace('UMS_SITE_URL', $siteUrl, $marker['description']);

         $marker['description'] = str_replace('\&quot;', '', $marker['description']);
         $marker['description'] = str_replace('\\', '', $marker['description']);

         if ($widthMapData && !empty($marker['map_id'])) $marker['map'] = frameUms::_()->getModule('maps')
            ->getModel()
            ->getMapById($marker['map_id'], false);

         if ($widthMapData && !empty($marker['map_id'])) $marker['map'] = frameUms::_()->getModule('maps')
            ->getModel()
            ->getMapById($marker['map_id'], false);

         if (!empty($marker['id'])) {
            $marker['marker_group_ids'] = frameUms::_()->getModule('marker')
               ->getModel('marker_groups_relation')
               ->getRelationsByMarkerId($marker['id']);
         }
      }
      return $marker;
   }
   public function getMapMarkers($mapId, $withGroup = false, $userId = false) {
      $mapId = (int)$mapId;
      $params = array(
         'map_id' => $mapId
      );
      if ($userId) {
         $params['user_id'] = $userId;
      }
      global $wpdb;
      $markers = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}ums_markers AS toe_mr WHERE map_id = %s ORDER BY sort_order ASC", $mapId), ARRAY_A);
      if (!empty($markers)) {
         $iconIds = array();
         foreach ($markers as $i => $m) {
            $markers[$i] = $this->_afterGet($markers[$i], false, true);
            // We need to do shortcode only on frontend
            if (isset($markers[$i]["description"])) {
               ob_start();
               echo do_shortcode($markers[$i]["description"]);
               $out = ob_get_contents();
               ob_end_clean();
               $markers[$i]["description"] = $out;
            }
            $iconIds[$m['icon']] = 1;
         }
         $usedIcons = frameUms::_()->getModule('icons')
            ->getModel()
            ->getIconsByIds(array_keys($iconIds));
         foreach ($markers as $i => $m) {
            $markers[$i]['icon_data'] = isset($usedIcons[$m['icon']]) ? $usedIcons[$m['icon']] : '';
         }
      }
      return $markers;
   }
   public function getMapMarkersIds($mapId) {
     global $wpdb;
     $markers = $wpdb->get_col($wpdb->prepare("SELECT * FROM {$wpdb->prefix}ums_markers WHERE map_id= %s", $mapId), ARRAY_A);
     return $markers;
   }
   public function getMarkersByIds($ids) {
      if (!is_array($ids)) $ids = array(
         $ids
      );
      $ids = array_map('intval', $ids);
      global $wpdb;
      $ids = implode(',', array_map('absint', $ids));
      $markers = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}ums_markers WHERE id IN (%1s)", $ids), ARRAY_A);
      if (!empty($markers)) {
         foreach ($markers as $i => $m) {
            $markers[$i] = $this->_afterGet($markers[$i]);
         }
      }
      return $markers;
   }
   public function removeMarker($markerId) {
      dispatcherUms::doAction('beforeMarkerRemove', $markerId);
      global $wpdb;
      $tableName = $wpdb->prefix . "ums_markers";
      $data_where = array(
         'id' => $markerId
      );
      return $res = $wpdb->delete($tableName, $data_where);
   }
   public function removeList($ids) {
      $ids = array_map('intval', $ids);
      global $wpdb;
      foreach ($ids as $id) {
         $tableName = $wpdb->prefix . "ums_markers";
         $data_where = array(
            'id' => $id
         );
         $res = $wpdb->delete($tableName, $data_where);
      }
      if ($res) {
         return true;
      }
   }
   public function findAddress($params) {
      if (!isset($params['addressStr']) || strlen($params['addressStr']) < 3) {
         $this->pushError(__('Address is empty or not match', UMS_LANG_CODE));
         return false;
      }
      $addr = $params['addressStr'];
      $getdata = http_build_query(array(
         'address' => $addr,
         'language' => 'en',
         'sensor' => 'false',
      ));
      $apiDomain = frameUms::_()->getModule('maps')
         ->getView()
         ->getApiDomain();
      $google_response = utilsUms::jsonDecode(file_get_contents($apiDomain . 'maps/api/geocode/json?' . $getdata));
      $res = array();
      foreach ($google_response['results'] as $response) {
         $res[] = array(
            'position' => $response['geometry']['location'],
            'address' => $response['formatted_address'],
         );
      }
      return $res;
   }
   public function removeMarkersFromMap($mapId) {
      global $wpdb;
      $tableName = $wpdb->prefix . "ums_markers";
      $data_where = array(
         'map_id' => $mapId
      );
      return $res = $wpdb->delete($tableName, $data_where);
   }
   public function getAllMarkers($d = array() , $widthMapData = false) {
      global $wpdb;
      $markerList = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}ums_markers", ARRAY_A);
      foreach ($markerList as $i => & $m) {
         $markerList[$i] = $this->_afterGet($markerList[$i], $widthMapData);
      }
      return $markerList;
   }
   public function getTotalCountBySearch($search) {
      global $wpdb;
      if (!empty($search)) {
         $count = (int)$wpdb->get_var("SELECT COUNT(*) AS total FROM {$wpdb->prefix}ums_markers " . $wpdb->prepare("(id = %s OR title = %s)", $search, $search));
      }
      else {
         $count = (int)$wpdb->get_var("SELECT COUNT(*) AS total FROM {$wpdb->prefix}ums_markers ");
      }
      return $count;
   }
   public function getListForTblBySearch($search, $limitStart, $rowsLimit, $mapId) {
      global $wpdb;
      if (!empty($search)) {
         $data = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}ums_markers WHERE " . $wpdb->prepare(" map_id = %s AND (id = %s OR title = %s) ORDER BY id ASC LIMIT %1s,%1s", $mapId, $search, $search, (int)$limitStart, (int)$rowsLimit) , ARRAY_A);
      }
      else {
         $data = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}ums_markers WHERE " . $wpdb->prepare(" map_id = %s ORDER BY id ASC LIMIT %1s,%1s", $mapId, (int)$limitStart, (int)$rowsLimit) , ARRAY_A);
      }
      foreach ($data as $i => & $m) {
         $data[$i] = $this->_afterGet($data[$i]);
      }
      return $data;
   }
   public function setMarkersToMap($addMarkerIds, $mapId) {
      if (!is_array($addMarkerIds)) $addMarkerIds = array(
         $addMarkerIds
      );
      $addMarkerIds = array_map('intval', $addMarkerIds);
      foreach ($addMarkerIds as $addMarkerId) {
         $tableName = $wpdb->prefix . "ums_markers";
         $data_update = array(
            'map_id' => (int)$mapId,
         );
         $data_where = array(
            'id' => $addMarkerId
         );
         $dbRes = $wpdb->update($tableName, $data_update, $data_where);
      }
      if ($dbRes) {
         return true;
      }
   }
   public function getCount($d = array()) {
      global $wpdb;
      return $count = (int)$wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}ums_markers ");
   }
   public function updatePos($d = array()) {
      global $wpdb;
      $d['id'] = isset($d['id']) ? (int)$d['id'] : 0;
      if ($d['id']) {
         $tableName = $wpdb->prefix . "ums_markers";
         $data_update = array(
            'coord_x' => $d['lat'],
            'coord_y' => $d['lng'],
         );
         $data_where = array(
            'id' => $d['id']
         );
         return $dbRes = $wpdb->update($tableName, $data_update, $data_where);
      }
      else $this->pushError(__('Invalid Marker ID'));
      return false;
   }
   public function replaceDeletedIconIdToDefault($id) {
      if ($id) {
         $tableName = $wpdb->prefix . "ums_markers";
         $data_update = array(
            'icon' => '1',
         );
         $data_where = array(
            'icon' => $id,
         );
         return $dbRes = $wpdb->update($tableName, $data_update, $data_where);
      }
      else $this->pushError(__('Invalid ID'));
      return false;
   }
}

Youez - 2016 - github.com/yon3zu
LinuXploit