File:cn/search.html
Function Code:300
Method Code:6
事务(进程 ID 66)与另一个进程被死锁在 锁 资源上，并且已被选作死锁牺牲品。请重新运行该事务。
update shopiprecord set status=0,stoptime=dateadd(hour,12,getdate()) where ip=replace('216.73.216.123','.','')
数据库执行错误
class/product.xmlc
...aRow({% select id,status,stoptime from shopiprecord with(nolock) where ip=replace('{@userIP}','.','') %});
$if($and($iif(@searchip<>$empty),$iif(@searchip<>$null),$iif(@searchip[id]>0))){
$if(@searchip[status]==2){
//$write(继续2);
}
$elseif(@searchip[status]==1){
//查询次数，次数超限制，封ip
@searchtimes=$db.dataRow({% select count(*) as c from searchHistory with(nolock) where userip='{@userIP}' and ddate>dateadd(minute,-5,getdate()); %});
$if(@searchtimes[c]>$global(searchtimes)){
//$write(封ip);
$db.transaction({%#&:update shopiprecord set status=0,stoptime=dateadd(hour,{$global(search_stophours)},getdate()) where ip=replace('{@userIP}','.','') %});
$write(<div class="alert">Access permission denied! Please try again later.</div>);
$end;
}
$else{
//$write(继续1);
}
}
$elseif(@searchip[status]==0){
//检查有没有超过封印时间
$if($datetime.compare(@searchip[stoptime],$datetime.now())<0){
$db.transaction({%#&:update shopiprecord set status=1,stoptime=null where ip=replace('{@userIP}','.','') %}...