if($action=='reset'){
echo "No available!!!<br>";
}
if($action=='delete'){
$qu="DELETE FROM `schems` WHERE `id`=$sid";
$result=mysql_query($qu); //Удаляем схему
$qu="DELETE FROM `outs` WHERE `id` IN (SELECT `oid` FROM `tds_out2s` WHERE `sid`=$sid)";
$result=mysql_query($qu); //Удаляем все ауты удаляемой схемы
$qu="DELETE FROM `filters` WHERE `id` IN (SELECT `fid` FROM `filt2o` WHERE `oid` IN (SELECT `oid` FROM `out2s` WHERE `sid`=$sid))";
$result=mysql_query($qu); //Удаляем все фильтры всех аутов удаляемой схемы
$qu="DELETE FROM `outs_stat` WHERE `oid` IN (SELECT `oid` FROM `out2s` WHERE `sid`=$sid)";
$result=mysql_query($qu); //Удаляем всю статистику аутов удаляемой схемы
$qu="DELETE FROM `filt2o` WHERE `oid` IN (SELECT `oid` FROM `out2s` WHERE `sid`=$sid)";
$result=mysql_query($qu); //Удаляем все связи фильтров и аутов удаляемой схемы
$qu="DELETE FROM `out2s` WHERE `sid`=$sid";
$result=mysql_query($qu); //Удаляем все связи аутов и удаляемой схемы
}
$qu="SELECT * FROM `schems` ORDER BY `id`";
/*
Вытаскиваем уники и хиты схемы:
*/
$result=mysql_query($qu);
while($schema=mysql_fetch_array($result)){
$sid = $schema['id'];
$qu1="SELECT SUM(o.`hits`) hits, SUM(o.`unics`) unics
FROM `schems` s,
`outs_stat` o
WHERE o.`oid` IN (SELECT `oid` FROM `out2s` o2 WHERE `sid` = {$sid})
GROUP BY s.`id` ORDER BY s.`id` ASC;";
$result1=mysql_query($qu1);
$schemai=mysql_fetch_array($result1);
$qub="SELECT count(*) count FROM `outs` WHERE `id` IN (SELECT `oid` FROM `out2s` WHERE `sid`=$sid) AND `upbot_disabled` = '1'";
$resultb=mysql_query($qub); //Читаем все ауты для данной схемы...
$lineb=mysql_fetch_array($resultb);
$ubt = "";
if($lineb['count'] > 0)
{
$ubt = "<br><font color=red><b>OFF OUT by UpTime Bot</b></font>";
}