Файл: gamele.ru/inc/complect.php
Строк: 48
<?php
if($post_id==2){
db_query('SELECT invent.*, items.* FROM items INNER JOIN invent ON items.id = invent.protype WHERE used='.AP.'1'.AP.' and pl_id='.AP.$player[id].AP.'');
while ($row = db_fetch()) {
$ids .= "@$row[id_item]";
$slots .= "@$row[curslot]";}
$cname=chars($cname);
db_query('SELECT * FROM pcompl WHERE uid='.AP.$player[id].AP.'');
while ($r = db_fetch()) {
if($r['name']==$cname){$i+=1;}
}
if($ids!='' and $slots!='' and $i==0 and $cname!=''){
db_query('INSERT INTO pcompl(uid,name,ids,slots) VALUES('.AP.$player[id].AP.','.AP.$cname.AP.','.AP.$ids.AP.','.AP.$slots.AP.')');$msg='<b><font class=nickname><font color=#cc0000>Комплект "'.$cname.'" сохранен!</font></font></b><br>';}
if($ids!='' and $slots!='' and $i!=0 and $cname!=''){
db_query('UPDATE pcompl SET ids='.AP.$ids.AP.', slots='.AP.$slots.AP.' WHERE uid='.AP.$player[id].AP.' and name='.AP.$cname.AP.';');$msg='<b><font class=nickname><font color=#cc0000>Комплект "'.$cname.'" заменен!</font></font></b><br>';}}
if($post_id==4){
db_query('UPDATE invent SET used='.AP.'0'.AP.', curslot='.AP.'0'.AP.' WHERE used='.AP.'1'.AP.' and pl_id='.AP.$player[id].AP.';');
db_query("SELECT * FROM pcompl WHERE uid='".$player[id]."' and id='".intval($_GET['key'])."' LIMIT 1");
$row = db_fetch();
$exp_id = explode('@',$row['ids']);
$exp_slots = explode('@',$row['slots']);
for($i=1;$i<=count($exp_id);$i++){
$slot=$exp_slots[$i];$id=$exp_id[$i];
db_query('UPDATE invent SET used='.AP.'1'.AP.', curslot='.AP.$slot.AP.' WHERE id_item='.AP.$id.AP.' and pl_id='.AP.$player[id].AP.'LIMIT 1;');}
calcstat($player[id]);
testcompl();
}
?>