%PDF- %PDF-
Server IP : 37.220.80.31 / Your IP : 18.191.237.176 Web Server : Apache/2.4.52 (Ubuntu) System : Linux 3051455-guretool.twc1.net 5.15.0-107-generic #117-Ubuntu SMP Fri Apr 26 12:26:49 UTC 2024 x86_64 User : www-root ( 1010) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/www-root/data/www/dev.artlot24.ru/bitrix/modules/iblock/classes/mysql/ |
Upload File : |
<? class CIBlockSequence { var $iblock_id = 0; var $property_id = 0; public function __construct($iblock_id, $property_id = 0) { $this->iblock_id = $iblock_id; $this->property_id = $property_id; } function Drop($bAll = false) { global $DB; //OR part of the where is just for some cleanup $strSql = " DELETE FROM b_iblock_sequence WHERE IBLOCK_ID = ".intval($this->iblock_id)." ".(!$bAll? "AND CODE = 'PROPERTY_".intval($this->property_id)."'": "")." OR NOT EXISTS ( SELECT * FROM b_iblock_property WHERE concat('PROPERTY_', b_iblock_property.ID) = b_iblock_sequence.CODE AND b_iblock_property.IBLOCK_ID = b_iblock_sequence.IBLOCK_ID ) "; $rs = $DB->Query($strSql, false, "FILE: ".__FILE__."<br> LINE: ".__LINE__); return $rs; } function GetCurrent() { global $DB; $strSql = " SELECT * FROM b_iblock_sequence WHERE IBLOCK_ID = ".intval($this->iblock_id)." AND CODE = 'PROPERTY_".intval($this->property_id)."' "; $rs = $DB->Query($strSql, false, "FILE: ".__FILE__."<br> LINE: ".__LINE__); $ar = $rs->Fetch(); if($ar) return $ar["SEQ_VALUE"]; else return 0; } function GetNext() { global $DB; $strSql = " INSERT INTO b_iblock_sequence (IBLOCK_ID, CODE, SEQ_VALUE) VALUES (".intval($this->iblock_id).", 'PROPERTY_".intval($this->property_id)."', LAST_INSERT_ID(1)) ON DUPLICATE KEY UPDATE SEQ_VALUE = LAST_INSERT_ID(SEQ_VALUE + 1) "; $rs = $DB->Query($strSql, false, "FILE: ".__FILE__."<br> LINE: ".__LINE__); return $DB->LastID(); } function SetNext($value) { global $DB; $value = intval($value); $strSql = " INSERT INTO b_iblock_sequence (IBLOCK_ID, CODE, SEQ_VALUE) VALUES (".intval($this->iblock_id).", 'PROPERTY_".intval($this->property_id)."', LAST_INSERT_ID(".$value.")) ON DUPLICATE KEY UPDATE SEQ_VALUE = LAST_INSERT_ID(".$value.") "; $rs = $DB->Query($strSql, false, "FILE: ".__FILE__."<br> LINE: ".__LINE__); return $DB->LastID(); } } ?>