function addspam($type, $rlsname, $data, $filename, $fromnet, $crc, $ann = true)
{
global $mc;
$whichdb = array('ADDNFO' => 'nfosdb', 'OLDNFO' => 'nfosdb', 'ADDSFV' => 'sfvsdb', 'OLDSFV' => 'sfvsdb', 'ADDM3U' => 'm3usdb', 'OLDM3U' => 'm3usdb', 'ADDDIZ' => 'dizdb', 'OLDDIZ' => 'dizdb');
$w = mysql_query("SELECT COUNT(id) AS tid, id, size FROM " . $whichdb[$type] . " WHERE rlsname = " . sqlesc($rlsname) . "") or exit("Err1 " . mysql_error());
$qw = mysql_fetch_assoc($w);
if ($qw['tid'] == 0) {
$newdata = gzcompress($data, 9);
$grp = explode("-", $rlsname);
$grp = $grp[count($grp) - 1];
$fromdata = explode(":", trim($fromnet));
$fromdata[1] = "#" . $fromdata[1];
$size = strlen($data);
mysql_query("INSERT INTO " . $whichdb[$type] . " ( `rlsname` , `grp` , `time` , `data` , `filename` , `size` ) VALUES (" . sqlesc($rlsname) . "," . sqlesc($grp) . "," . time() . "," . sqlesc($newdata) . "," . sqlesc($filename) . "," . sqlesc($size) . ")") or exit('Err2 ' . mysql_error());
$id = mysql_insert_id();
mysql_query("INSERT INTO fromspamdata ( `spamid` , `type` , `time` , `nick` , `chan` , `network` ) VALUES (" . $id . "," . sqlesc($type) . "," . time() . "," . sqlesc($fromdata[0]) . "," . sqlesc($fromdata[1]) . "," . sqlesc($fromdata[2]) . ")") or exit('Err3 ' . mysql_error());
if ($ann == true) {
$mcdata = array('ID' => $id, 'TYPE' => $type);
$hash1 = md5($id . $type . $rlsname);
$hash2 = md5(md5($filename . time()) . time() . $rlsname);
$key = md5(md5($hash1 . $hash2) . md5($hash2 . $hash1));
$mc->set($key, $mcdata, false, 300) or die("Failed to save data at memcache server");
$sbotdata = array($type, $rlsname, $key, $filename, $crc, $size);
sendbot(join(" ", $sbotdata));
return "OK";
} else {
return "FAiL";
}
}
/* else {
$id = $qw['id'];
$mcdata = array('ID' => $id, 'TYPE' => $type);
$hash1 = md5($id . $type . $rlsname);
$hash2 = md5(md5($filename.time()).time().$rlsname);
$key = md5(md5($hash1.$hash2).md5($hash2.$hash1));
$mc->set($key, $mcdata, false, 300) or die ("Failed to save data at memcache server");
$sbotdata = array($type, $rlsname, $key, $filename, $crc, $qw['size']);
sendbot(join(" ",$sbotdata));
return "OK";
}*/
}
function addmp3info($type, $rlsname, $genre, $year, $hertz, $tp, $bitrate, $bittype, $fromnet, $ann = true)
{
$w = mysql_query("SELECT COUNT(id) AS tid FROM mp3info WHERE rlsname = " . sqlesc($rlsname) . "") or die("Err1 " . mysql_error());
$qw = mysql_fetch_assoc($w);
if ($qw['tid'] == 0) {
$fromdata = explode(":", trim($fromnet));
$fromdata[1] = "#" . $fromdata[1];
mysql_query("INSERT INTO mp3info ( `rlsname` , `genre` , `year` , `hertz` , `type` , `bitrate` , `bittype` , `unixtime` , `addedon` , `fromnet` ) VALUES (" . sqlesc($rlsname) . "," . sqlesc($genre) . "," . sqlesc($year) . "," . sqlesc($hertz) . "," . sqlesc($tp) . "," . sqlesc($bitrate) . "," . sqlesc($bittype) . "," . time() . "," . sqlesc(get_date_time()) . "," . sqlesc($fromnet) . ")") or die('Err2 ' . mysql_error());
$id = mysql_insert_id();
mysql_query("INSERT INTO frominfodata ( `infoid` , `type` , `time` , `nick` , `chan` , `network` ) VALUES (" . $id . "," . sqlesc($type) . "," . time() . "," . sqlesc($fromdata[0]) . "," . sqlesc($fromdata[1]) . "," . sqlesc($fromdata[2]) . ")") or die('Err3 ' . mysql_error());
if ($ann == true) {
$sbotdata = array($type, $rlsname, $genre, $year, $hertz, $tp, $bitrate, $bittype);
sendbot(join(" ", $sbotdata));
return "OK";
} else {
return "FAiL";
}
}
}
