DBCC CHECKIDENT (Table, RESEED, 100)
100 — текущая позиция, не следующая
DBCC CHECKIDENT (Table, RESEED, 100)
jquery.min.js:4 Uncaught TypeError: Illegal invocation
PHP Warning: Missing boundary in multipart/form-data POST data in Unknown on line 0
проставим значения параметров для аякса:
processData: false,
contentType: false,
t = new XMLHttpRequest(); t.open('post',''); t.send(new FormData($('#contracts_edit')[0]));
isFile()) { $filenames[$fileinfo->getMTime()] = $fileinfo->getFilename(); } } krsort($filenames); foreach($filenames as $mt => $fn) { $ot = new \DateTime(); $ot->setTimestamp($mt); $st = $ot->format('d.m.Y H:i'); $t = unserialize_php(file_get_contents($directory . $fn)); if (isset($t['auth']) && isset($t['auth']['user'])) { $tt = (object)$t['auth']['user']; echo " Последняя активность ФИО Роль "; } } ?> {$st} {$tt->nameLast} {$tt->nameFirst} {$tt->nameMidle} {$tt->email} {$tt->name}
select c1.value('xs:integer((/v)[1])','int') ci1, c1.value('xs:float((/v)[1])','float') ci1 from ( select cast(' 1234 ' as xml) c1 union all select cast('1234 Z ' as xml) c1 union all select cast('12,3 ' as xml) c1 union all select cast('12.3 ' as xml) c1 union all select cast('23e2 ' as xml) c1 ) tt ci1 ci1 1234 1234 NULL NULL NULL NULL NULL 12,3 NULL 2300 select cast('1234 ' as xml).value('xs:integer((/v)[1])','int') ci1 Это не проверял CREATE FUNCTION TryCastInt(@inputStr nvarchar(max)) RETURNS int AS BEGIN DECLARE @ret int; set @ret = -999999 IF (~(cast(patindex('%[^0-9]%', @inputStr) as bit))) >0 select @ret = cast (@inputStr as int) ELSE set @ret = -999999 RETURN @ret; END; Немного другой вариант, для поразмыслитьDECLARE @VARCHARString VARCHAR(8000) SET @VARCHARString = '000012W`''ASDASDS3A@!#@!#_)+)_4)' SELECT @VARCHARString --Remove non numeric charecters from the varchar variable WHILE PATINDEX('%[^0-9]%', @VARCHARString) > 0 SET @VARCHARString = STUFF(@VARCHARString, PATINDEX('%[^0-9]%', @VARCHARString), 1, '') SELECT @VARCHARString + c1 from ( select 1 c1 union all select 2 c2 ) tt
Служба «Служба профилей пользователей» препятствует входу в систему. Невозможно загрузить профиль пользователя.Перезагрузка, жмет F8 (часто) И «Последняя удачная конфигурация» не помогла, совсем плохо.
https://msdn.microsoft.com/en-us/library/hh801214(v=vs.85).aspx «Отделить» 10-ый от 11-го с помощью js или на бекенде аналогично распарсить User-Agent
var uA = navigator.userAgent; if(uA.indexOf('Trident') != -1 && uA.indexOf('rv:11') != -1){ document.body.className = document.body.className+' ie ie11'; } else if(uA.indexOf('Trident') != -1 && uA.indexOf('MSIE 10.0') != -1){ document.body.className = document.body.className+' ie ie10'; } else if(uA.indexOf('MSIE ') != -1) { document.body.className = document.body.className+' ie ieo'; }
<?php namespace app\models; class User extends \yii\base\Object implements \yii\web\IdentityInterface { public $id; public $username; public $password; public $authKey; public $accessToken; public $credential; public $first_name; public $last_name; public $gid; public $group_name; public static function _init() { if (empty(self::$users)) { $users = \Yii::$app->db->createCommand("select c.id, c.lower_user_name username, c.credential, c.first_name, c.last_name from cwd_user c where c.active = 1") ->cache(3600) ->queryAll(); foreach ($users as $u) { self::$users[$u['id']] = $u; } } } public static $users = []; ............................... /** * Validates password * * @param string $password password to validate * @return boolean if password provided is valid for current user */ public function validatePassword($password) { return JiraAuth::isValidPassword($password, $this->credential); } }И сам класс проверки пароля
<?php class JiraAuth { const DEFAULT_PREFIX = '{PKCS5S2}'; const DEFAULT_SALT_LENGTH_BYTES = 16; public static function isValidPassword($password, $credential) { $ret = false; if ( strrpos($credential, JiraAuth::DEFAULT_PREFIX) === false) return $ret; $credential = substr($credential, strlen(JiraAuth::DEFAULT_PREFIX)-1); $binSaltAndKey = base64_decode($credential); if (strlen($binSaltAndKey)<48) return $ret; $salt = substr($binSaltAndKey,0,JiraAuth::DEFAULT_SALT_LENGTH_BYTES); $oldKey = bin2hex(substr($binSaltAndKey,JiraAuth::DEFAULT_SALT_LENGTH_BYTES)); $newKey = hash_pbkdf2('sha1', $password, $salt, 10000, 64); return ($oldKey == $newKey); } }Замечание, PHP нужен от 5.5, а JIRA была версии v6.3