Файл: bots/svaisch2.php
Строк: 21
<?
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '1'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
if ($msg=='!тут'||$msg=='!tut'){
if($a['j_t']==0&&$user['id']==$a['j_id'])query("UPDATE `zags` SET `j_t` = '1' WHERE `id` = '".$a['id']."'");
if($a['n_t']==0&&$user['id']==$a['n_id'])query("UPDATE `zags` SET `n_t` = '1' WHERE `id` = '".$a['id']."'");
if($a['frj_t']==0&&$user['id']==$a['frj_id'])query("UPDATE `zags` SET `frj_t` = '1' WHERE `id` = '".$a['id']."'");
if($a['frn_t']==0&&$user['id']==$a['frn_id'])query("UPDATE `zags` SET `frn_t` = '1' WHERE `id` = '".$a['id']."'");
}
}
// Согласие жениха
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '3'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
if (($msg=='!да'||$msg=='!da')&&$user['id']==$a['j_id']){
query("UPDATE `zags` SET `cer` = '4' WHERE `id` = '".$a['id']."'");
}
}
// Согласие невесты
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '5'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
if (($msg=='!да'||$msg=='!da')&&$user['id']==$a['n_id']){
query("UPDATE `zags` SET `cer` = '6' WHERE `id` = '".$a['id']."'");
}
}
// Дружок даёт кольцо
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '9'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
//
if (($msg=='!кольцо')&&$user['id']==$a['frj_id']){
$vp0 = rand(1,3);
$vp1 = '<img src="/zags/'.$vp0.'.gif" alt="кольцо" />';
query("UPDATE `message` SET `msg` = '$vp1' WHERE `id` = '".$idmsg."'");
query("UPDATE `zags` SET `cer` = '10', `kolco` = '$vp0' WHERE `id` = '".$a['id']."'");
}
}
// Подруга даёт кольцо
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '12'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
if (($msg=='!кольцо')&&$user['id']==$a['frn_id']){
$vp = '<img src="/zags/1'.$a['kolco'].'.gif" alt="кольцо" />';
query("UPDATE `message` SET `msg` = '$vp' WHERE `id` = '".$idmsg."'");
query("UPDATE `zags` SET `cer` = '13' WHERE `id` = '".$a['id']."'");
}
}
// Обмен кольцами. Заменям надпись на иконку
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '16'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
//
if ($msg=='!кольцо'&&$user['id']==$a['j_id']){
//$vp = '<img src="/zags/1'.$a['kolco'].'.gif" alt="кольцо" />';
$msg = preg_replace("#!кольцо#i",'<img src="/zags/1'.$a['kolco'].'.gif" alt="кольцо" />',$msg);
query("UPDATE `message` SET `msg` = '$msg' WHERE `id` = '".$idmsg."'");
$mes = "Напиши [b]".user($a['j_id'])."[/b]: !кольцо";
query ("INSERT INTO message (user,user_id,time,msg,rm,komu,privat) VALUES ('$user_svaisch','0','".($time+1)."','".$mes."','$rm','$a[n_id]','$a[n_id]')");
query("UPDATE `zags` SET `cer` = '17' WHERE `id` = '".$a['id']."'");
}
}
// Обмен кольцами. Заменям надпись на иконку
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '17'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
//
if ($msg=='!кольцо'&&$user['id']==$a['n_id']){
$msg = preg_replace("#!кольцо#i",'<img src="/zags/'.$a['kolco'].'.gif" alt="кольцо" />',$msg);
query("UPDATE `message` SET `msg` = '$msg' WHERE `id` = '".$idmsg."'");
query("UPDATE `zags` SET `cer` = '18' WHERE `id` = '".$a['id']."'");
}
}
// Поцелуй
$r = query("Select * from zags WHERE `timesv` < '".$time."' and `cer` = '19'");
if (mysql_affected_rows()!=0){
$a = mysql_fetch_assoc($r);
//
if ($msg=='!поцелуй'&&$user['id']==$a['j_id']){
$msg = preg_replace("#!поцелуй#i",'<img src="/zags/poc.gif" alt="поцелуй" />',$msg);
query("UPDATE `message` SET `msg` = '$msg' WHERE `id` = '".$idmsg."'");
query("UPDATE `zags` SET `cer` = '20' WHERE `id` = '".$a['id']."'");
}
}
?>