PHP Code:
<?php
/*
*----------------------------phpMyBitTorrent V 2.0-beta3-----------------------*
*--- The Ultimate BitTorrent Tracker and BMS (Bittorrent Management System) ---*
*-------------- Created By Antonio Anzivino (aka DJ Echelon) --------------*
*------------- http://www.p2pmania.it -------------*
*------------ Based on the Bit Torrent Protocol made by Bram Cohen ------------*
*------------- http://www.bittorrent.com -------------*
*------------------------------------------------------------------------------*
*------------------------------------------------------------------------------*
*-- This program is free software; you can redistribute it and/or modify --*
*-- it under the terms of the GNU General Public License as published by --*
*-- the Free Software Foundation; either version 2 of the License, or --*
*-- (at your option) any later version. --*
*-- --*
*-- This program is distributed in the hope that it will be useful, --*
*-- but WITHOUT ANY WARRANTY; without even the implied warranty of --*
*-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the --*
*-- GNU General Public License for more details. --*
*-- --*
*-- You should have received a copy of the GNU General Public License --*
*-- along with this program; if not, write to the Free Software --*
*-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA --*
*-- --*
*------------------------------------------------------------------------------*
*------ ©2005 phpMyBitTorrent Development Team ------*
*----------- http://phpmybittorrent.com -----------*
*------------------------------------------------------------------------------*
*----------------- Sunday, September 14, 2008 9:05 PM ---------------------*
*/
error_reporting(0);
if (!defined('IN_PMBT'))die("You can't access this file directly");
if (isset($autoscrape)) {
require_once("include/bdecoder.php");
require_once("include/torrent_functions.php");
}
function autoinvites($length, $minlimit, $maxlimit, $minratio, $invites)
{
global $db, $db_prefix;
$minlimit = $minlimit*1024*1024*1024;
$maxlimit = $maxlimit*1024*1024*1024;
$res = $db->sql_query("SELECT id, invites FROM ".$db_prefix."_users WHERE active = 1 AND downloaded >= $minlimit AND downloaded < $maxlimit AND uploaded / downloaded >= $minratio AND warned = '0' AND invites < 10 AND UNIX_TIMESTAMP(invitedate) < UNIX_TIMESTAMP(NOW()) - $length*86400") ;
if ($db->sql_numrows($res) > 0)
{
while ($arr = $db->sql_fetchrow($res))
{
if ($arr[invites] == 9)
$invites = 1;
elseif ($arr[invites] == 8 && $invites == 3)
$invites = 2;
$db->sql_query("UPDATE ".$db_prefix."_users SET invites = invites + ".$invites.", invitedate = NOW() WHERE id='".$arr['id']."'") ;
}
}
}
function cleanup() {
global $db, $db_prefix, $admin_email, $runhnrsystem, $btuser, $autoscrape,$most_users_online , $dead_torrent_interval, $announce_interval, $down_limit, $autodel_users, $sitename, $autodel_users_time, $inactwarning_time, $siteurl, $forumbase,$forumshare,$phpEx, $config,$phpbb_root_path,$forumpx, $autoclean_interval;
//most users online
$sql = "SELECT COUNT(id)as num_users FROM ".$db_prefix."_online_users";
$sql_count = $db->sql_query($sql);
$numbero = (int) $db->sql_fetchfield('num_users');
$db->sql_freeresult($sql_count);
if($most_users_online < $numbero)
{
$db->sql_query("UPDATE ".$db_prefix."_config SET `most_on_line` = '".$numbero."', `when_most` = NOW()");
}
//clean up donations
$sql = "SELECT COUNT(DISTINCT username) as name
FROM ".$db_prefix."_users
WHERE donator = 'true'";
$res = $db->sql_query($sql);
$doners = (int) $db->sql_fetchfield('name');
$db->sql_freeresult($res);
if ($doners > 0) {
$sql2 = "SELECT id, dondate, donator_tell
FROM ".$db_prefix."_users
WHERE donator = 'true'
AND UNIX_TIMESTAMP(donator_tell) < UNIX_TIMESTAMP(NOW())-0";
$res2 = $db->sql_query($sql2);
while ($arr = $db->sql_fetchrow($res2)) {
$donatedate = $arr['dondate'];
$doner_tell = $arr['donator_tell'];
$uid = $arr['id'];
if(get_date_time(gmtime()) >= $doner_tell){
$db->sql_query("UPDATE ".$db_prefix."_users SET `dondate`= '0000-00-00 00:00:00', `donator_tell`='0000-00-00 00:00:00', `donator`= 'false', `dongift`=0 WHERE `id` = ".$uid.";");
}
}
}
unset($sql,$res,$arr,$uid,$donatedate,$doner_tell);
$hnr_sql = "SELECT `hnr_system`, `seedtime`, `time_before_warn`, `maxhitrun`, `warnlength` FROM `".$db_prefix."_hit_n_run` ";
$hnr_sql1=$db->sql_query($hnr_sql);
$rowhnr = $db->sql_fetchrow($hnr_sql1);
$db->sql_freeresult($hnr_sql);
$hnr_system = $rowhnr['hnr_system'];
$warnlength = $rowhnr['warnlength'];
$maxhitrun = $rowhnr['maxhitrun'];
$seedtime = $rowhnr['seedtime']*60;
$time_before_warn = ($rowhnr['time_before_warn']*60);
$warnlength = ($rowhnr['warnlength']*60*60*24);
$timedelay = time()-($announce_interval+$time_before_warn);
if($hnr_system == 'true')
{
// Message users who have hit and run
$dohr = false;
$sqlc = "SELECT COUNT(s.id)as hrcount FROM ".$db_prefix."_snatched AS s INNER JOIN ".$db_prefix."_torrents AS t ON s.torrentid = t.id WHERE s.userid <> t.owner AND `completedat` > '0000-00-00 00:00:00' AND `completedat` > '2009-03-27 17:53:50' AND `seeding_time` > '0' AND `seeding_time` < '".$seedtime."' AND s.`downloaded` > s.`uploaded` AND `seeder` = 'no' AND s.last_action < '".get_date_time(gmtime() - ($announce_interval+$time_before_warn))."' AND hitrunwarn = 'no'";
$resc = $db->sql_query($sqlc)or btsqlerror($sqlc);
while ($arrc = $db->sql_fetchrow($resc)) {
$dohr = true;
}
$sql = "SELECT s.id, userid, torrentid, t.name FROM ".$db_prefix."_snatched AS s INNER JOIN ".$db_prefix."_torrents AS t ON s.torrentid = t.id WHERE s.userid <> t.owner AND `completedat` > '0000-00-00 00:00:00' AND `completedat` > '2009-03-27 17:53:50' AND `seeding_time` > '0' AND `seeding_time` < '".$seedtime."' AND s.`downloaded` > s.`uploaded` AND `seeder` = 'no' AND s.last_action < '".get_date_time(gmtime() - ($announce_interval+$time_before_warn))."' AND hitrunwarn = 'no'";
$res = $db->sql_query($sql)or btsqlerror($sql);
// echo $sql;
if ($dohr) {
//die("warn");
$ids = $userids = array();
while ($arr = $db->sql_fetchrow($res)) {
if(hitrun($arr['userid'])){
$ids[] = $arr["id"];
$userids[] = $arr["userid"];
$hitrun[$arr["userid"]]++;
$torrents[$arr["userid"]] .= "\n[b][url=".$siteurl."/details.php?id=$arr[torrentid]]".addslashes($arr['name'])."[/url][/b]";
}
}
$userids = array_unique($userids);
foreach($userids as $userid) {
$hnrtorrents = $torrents[$userid];
$hnrtot = $hitrun[$userid];
$hnrcount = ($hitrun[$userid] == 1 ? "" : "s");
$these = ($hitrun[$userid] == 1 ? "this" : "these");
$is = ($hitrun[$userid] == 1 ? "is" : "are");
$msg = str_replace(array("{hnrtot}","{hnrcount}","{these}","{is}","{hnrtorrents}"),array($hnrtot,$hnrcount,$these,$hnrtorrents),_BT_HNR_NOTICE_PM);
$db->sql_query("INSERT INTO ".$db_prefix."_private_messages (sent, sender, recipient, subject, text) VALUES (NOW(), 0, $userid, 'Hit and Run', '$msg')") ;
}
if(sizeof($ids) != 0)$db->sql_query("UPDATE ".$db_prefix."_snatched SET hitrunwarn = 'pending', last_action='".get_date_time()."' WHERE id IN (".implode(", ", $ids).")") or sqlerr();
}
// Process hit and runs of users that have not returned
$sql = "SELECT id, userid FROM ".$db_prefix."_snatched WHERE hitrunwarn = 'pending' AND last_action < '".get_date_time(gmtime() - ($announce_interval+$time_before_warn))."'";
$res = $db->sql_query($sql);
if ($db->sql_numrows($res) > 0) {
$ids = $userids = array();
while ($arr = $db->sql_fetchrow($res)) {
$ids[] = $arr["id"];
$userids[] = $arr["userid"];
$hitrun[$arr["userid"]]++;
}
$userids = array_unique($userids);
foreach($userids as $userid)
$db->sql_query("UPDATE ".$db_prefix."_users SET hitruns = hitruns + $hitrun[$userid], hitrun = '".get_date_time()."' WHERE id = $userid");
$db->sql_query("UPDATE ".$db_prefix."_snatched SET hitrunwarn = 'yes', hitrun = '".get_date_time()."' WHERE id IN (".implode(", ", $ids).")");
}
// Warn repeating hit and runners
// $maxhitrun = 0;
$sql = "SELECT id FROM ".$db_prefix."_users WHERE hitruns > $maxhitrun AND hitrun < '".get_date_time(gmtime() - ($announce_interval+$time_before_warn))."' AND warned = '0'";
$res = $db->sql_query($sql);
if ($db->sql_numrows($res) > 0) {
$userids = array();
$modcomment = addslashes(_btmod_HNR_mesage_a);
$msg = _bt_HNR_WARN_PM;
while ($arr = $db->sql_fetchrow($res)) {
$userids[] = $arr["id"];
$db->sql_query("INSERT INTO ".$db_prefix."_private_messages (sent, sender, recipient, subject, text) VALUES (NOW(), 0, $arr[id], 'Hit and Run', '$msg')");
}
//$warnlength = 604800;
$db->sql_query("UPDATE ".$db_prefix."_users SET warned = '1', warn_kapta='" . strtotime(gmdate("Y-m-d H:i:s", time())) . "', warn_hossz = warn_hossz + '".$warnlength."', modcomment = CONCAT('$modcomment', modcomment), hitruns = 0, HNR_W = HNR_W + '1' WHERE id IN (".implode(", ", $userids).")");
}
unset($ids,$userids,$msg);
$sql = "SELECT id, userid FROM ".$db_prefix."_snatched WHERE seeder = 'yes' AND hitrunwarn = 'yes'";
$res = $db->sql_query($sql);
if ($db->sql_numrows($res) > 0) {
$ids = $userids = array();
$msg = addslashes(_bt_hnrremoved);
$modcomment = _btmod_HNR_mesage_b;
while ($arr = $db->sql_fetchrow($res)) {
$ids[] = $arr["id"];
$userids[] = $arr["userid"];
// $userids[] = $arr["id"];
$db->sql_query("INSERT INTO ".$db_prefix."_private_messages (sent, sender, recipient, subject, text) VALUES (NOW(), 0, ".$arr["userid"].", 'Hit and Run', '$msg')");
}
//$warnlength = 604800;
$db->sql_query("UPDATE ".$db_prefix."_users SET warned = '0', warn_kapta='" . strtotime(gmdate("Y-m-d H:i:s", time())) . "', warn_hossz = warn_hossz - '".$warnlength."', modcomment = CONCAT('$modcomment', modcomment), hitruns = 0, HNR_W = HNR_W - '1' WHERE id IN (".implode(", ", $userids).")");
$db->sql_query("UPDATE ".$db_prefix."_snatched SET hitrun ='0000-00-00 00:00:00', hitrunwarn = 'no' WHERE id IN (".implode(", ", $ids).")");
}
}
$db->sql_query("DELETE FROM ".$db_prefix."_users WHERE active = 0 AND UNIX_TIMESTAMP(regdate) < UNIX_TIMESTAMP(NOW()) - 86400;");
# Delete PMs that have been removed by both Sender and Recipient
$db->sql_query( "DELETE FROM ".$db_prefix."_private_messages WHERE sender = '0' AND recipient_del = 'true';");
$db->sql_query( "DELETE FROM ".$db_prefix."_private_messages WHERE sender_del = 'true' AND recipient_del = 'true';");
$db->sql_query( "DELETE FROM ".$db_prefix."_private_messages WHERE recipient = '0';");
$db->sql_query( "DELETE FROM ".$db_prefix."_private_messages WHERE save = 'false' AND UNIX_TIMESTAMP(sent) < UNIX_TIMESTAMP(NOW()) - 2592000;");
#clean snatch list
// $db->sql_query("UPDATE ".$db_prefix."_snatched SET seeder = 'no' WHERE seeder = 'yes' AND UNIX_TIMESTAMP(last_action) < UNIX_TIMESTAMP(NOW()) - ".intval($announce_interval).";";
#Reset Statistics. Run where there is a dead peer
$sql = "DELETE FROM ".$db_prefix."_peers WHERE UNIX_TIMESTAMP(last_action) < UNIX_TIMESTAMP(NOW()) - ".($announce_interval+60).";"; //One minute of tolerance
$res = $db->sql_query($sql);
if ($db->sql_affectedrows($res) > 0) {
$db->sql_query("UPDATE ".$db_prefix."_torrents SET seeders = 0, leechers = 0, tot_peer = 0, speed = 0 WHERE tracker IS NULL OR backup_tracker = 'true';");
$sql = "SELECT COUNT(*) AS tot, torrent, seeder, SUM(upload_speed) AS speed FROM ".$db_prefix."_peers GROUP BY torrent, seeder;";
$res = $db->sql_query($sql);
while($row = $db->sql_fetchrow($res)) {
if ($row["seeder"] == "yes") $sql = "UPDATE ".$db_prefix."_torrents SET seeders = '".$row["tot"]."', speed = speed + '".$row["speed"]."' WHERE id='".$row["torrent"]."';";
else $sql = "UPDATE ".$db_prefix."_torrents SET leechers = '".$row["tot"]."', speed = speed + '".$row["speed"]."' WHERE id='".$row["torrent"]."';";
$db->sql_query($sql);
}
$db->sql_query("UPDATE ".$db_prefix."_torrents SET tot_peer = seeders + leechers;");
}
$db->sql_query("UPDATE ".$db_prefix."_torrents SET evidence = 0 WHERE evidence = 1 AND UNIX_TIMESTAMP(added) < UNIX_TIMESTAMP(NOW()) - 14*84600;");
$db->sql_query("UPDATE ".$db_prefix."_torrents SET visible = 'no' WHERE type != 'link' AND tot_peer <= '".$down_limit."' AND UNIX_TIMESTAMP(last_action) < UNIX_TIMESTAMP(NOW()) - ".intval($dead_torrent_interval)." AND evidence != 1 AND (TRACKER IS NULL OR ".intval($autoscrape).");");
$db->sql_query("UPDATE ".$db_prefix."_torrents SET visible = 'yes' WHERE tot_peer > '".$down_limit."';");
#prune users
if ($autodel_users)
{
$userwarninactivesub = Array();
$userwarninactivesub['english'] = "".$sitename." Warning";
$userwarninactivesub['german'] = "".$sitename." Achtung";
$userwarninactivesub['spanish'] = "Advertencia ".$sitename."";
$userwarninactivesub['brazilian'] = "".$sitename." adverte";
$userwarninactivesub['portuguese'] = "".$sitename." adverte";
$userwarninactivetext = Array();
$warntexten1 = "Hi,
we would like to warn you that you have not been active on **siteurl** for more than **inactwarning_time** days,
if you do not want to have your account deleted please login to it.
";
if ($autodel_users_time != 0)
{
$warntexten2 = "You have **autodel_users_time** days to log in from now.
Otherwise we will delete your account permanently.";
}
else $warntexten2 = "";
$warntexten3 = "
Thanks **sitename** Admin
**siteurl**";
$userwarninactivetext['english'] = "".$warntexten1.$warntexten2.$warntexten3."";
$warntextger1 = "Wir möchten darauf hinweisen , dass du auf **siteurl** seit mehr als **inactwarning_time** Tagen nicht mehr aktiv warst,
wenn Du nicht willst, dass dein Account gelöscht wird, logge dich bitte ein.
";
if ($autodel_users_time != 0)
{
$warntextger2 = "Du hast ab jetzt **autodel_users_time** Tage Zeit um dich auf **sitename** einzuloggen.
Ansonsten werden wir deinen Account permanent löschen.";
}
else $warntextger2 = "";
$warntextger3 = "
Danke**sitename**Admin.
**siteurl**";
$userwarninactivetext['german'] = "".$warntextger1.$warntextger2.$warntextger3."";
$warntextspa1 = "Hola,
Queriamos decirte que no visitaste nuestra pagina **siteurl** por mas de **inactwarning_time** dias.
Si no quieres que tu Cuenta sea borrada, por favor logueate.
";
if ($autodel_users_time != 0)
{
$warntextspa2 = "Tienes **autodel_users_time** dias para loguearte nuevamente apartir de hoy.
De otra manera borraremos tu cuenta de forma permanente.";
}
else $warntextspa2 = "";
$warntextspa3 = "
Gracias. Los **sitename** administradores
**siteurl**";
$userwarninactivetext['spanish'] = "".$warntextspa1.$warntextspa2.$warntextspa3."";
$warntextbra1 = "Oi,
Nós gostaríamos de avisa-lo que voce nao tem estado ativo no **siteurl** por mais de **inactwarning_time** dias.
Se voce nao quer ter sua conta excluída, por favor conecte-se.
";
if ($autodel_users_time != 0)
{
$warntextbra2 = "Voce tem **autodel_users_time** dias a partir de hoje para fazer isso.
Caso contrário nós iremos apagar sua conta permanentemente.";
}
else $warntextbra2 = "";
$warntextbra3 = "
Obrigado **sitename** Administrador
**siteurl**";
$userwarninactivetext['brazilian'] = "".$warntextbra1.$warntextbra2.$warntextbra3."";
$warntextpor1 = "Oi,
Nós gostaríamos de avisa-lo que voce nao tem estado ativo no **siteurl** por mais de **inactwarning_time** dias.
Se voce nao quer ter sua conta excluída, por favor conecte-se.
";
if ($autodel_users_time != 0)
{
$warntextpor2 = "Voce tem **autodel_users_time** dias a partir de hoje para fazer isso.
Caso contrário nós iremos apagar sua conta permanentemente.";
}
else $warntextpor2 = "";
$warntextpor3 = "
Obrigado **sitename** Administrador
**siteurl**";
$userwarninactivetext['portuguese'] = "".$warntextpor1.$warntextpor2.$warntextpor3."";
$sql = "SELECT id, email, inactwarning, lastlogin, language, ban FROM ".$db_prefix."_users WHERE ban != 1 AND inactwarning != 1 AND lastlogin != '0000-00-00 00:00:00' AND (UNIX_TIMESTAMP(lastlogin) < UNIX_TIMESTAMP(NOW()) - ".$inactwarning_time.") ;";
$res = $db->sql_query($sql);
while ($get_info = $db->sql_fetchrow($res))
{
echo $get_info['id']."<br>";
//logerror($get_info['id'].$get_info['email'].$get_info['inactwarning'].$get_info['lastlogin'], "prune time");
$replace_markers = Array("**sitename**","**siteurl**","**inactwarning_time**","**autodel_users_time**");
$replace_data = Array ("".$sitename."","".$siteurl."","".($inactwarning_time/86400)."","".($autodel_users_time/86400)."");
if ($get_info['language'] == "") $get_info['language'] = "english";
$warn_mail = new eMail;
$warn_mail->sender = $admin_email;
$warn_mail->subject = $userwarninactivesub[$get_info['language']];
$warn_mail->body = str_replace($replace_markers,$replace_data,$userwarninactivetext[$get_info['language']]);
$warn_mail->Add($get_info['email']);
$warn_mail->Send();
$up_warn = "UPDATE ".$db_prefix."_users SET inactwarning = 1, inactive_warn_time = NOW() WHERE id = ".$get_info['id'].";";
$db->sql_query($up_warn);
}
}
$db->sql_query("UPDATE ".$db_prefix."_users SET inactwarning = 0, inactive_warn_time = '0000-00-00 00:00:00' WHERE inactwarning = 1 AND UNIX_TIMESTAMP(lastlogin) > UNIX_TIMESTAMP(NOW()) - (".$inactwarning_time.");");
#Clean Shoutbox after 8 hours
// $db->sql_query("DELETE FROM ".$db_prefix."_shouts WHERE UNIX_TIMESTAMP(posted) < UNIX_TIMESTAMP(NOW()) - (8 * 60 * 60);");
#Clean online user list after 10 minutes of inactivity
$db->sql_query("DELETE FROM ".$db_prefix."_online_users WHERE UNIX_TIMESTAMP(last_action) < UNIX_TIMESTAMP(NOW()) - 1600;");
$res = $db->sql_query("SELECT * FROM ".$db_prefix."_lottery_config") ;
while ($arr = $db->sql_fetchrow($res))
$arr_config[$arr['name']] = $arr['value'];
if ($arr_config['enable'] == 1)
{
if (gmdate("Y-m-d H:i:s", time()) > $arr_config['end_date'])
{
if ($arr_config["ticket_amount_type"] == GB)
$arr_config['ticket_amount'] = 1024 * 1024 * 1024 * $arr_config['ticket_amount'];
else if ($arr_config["ticket_amount_type"] == MB)
$arr_config['ticket_amount'] = 1024 * 1024 * $arr_config['ticket_amount'];
$size = $arr_config['ticket_amount'];
if ($arr_config["ticket_amount_type"] == GB)
$arr_config['prize_fund'] = 1024 * 1024 * 1024 * $arr_config['prize_fund'];
else if ($arr_config["ticket_amount_type"] == MB)
$arr_config['prize_fund'] = 1024 * 1024 * $arr_config['prize_fund'];
$prize_fund = $arr_config['prize_fund'];
$total = $db->sql_numrows($db->sql_query("SELECT * FROM ".$db_prefix."_tickets"));
if ($arr_config["use_prize_fund"])
{
$pot = $prize_fund / $arr_config['total_winners'];
$res = $db->sql_query("SELECT user FROM ".$db_prefix."_tickets ORDER BY RAND() LIMIT $arr_config[total_winners]") ;
$who_won = array();
$msg = "Congratulations, You have won: <b>".mksize($pot)."</b>.<br /><br />This has been added to your upload amount<br /><br />Thanks for playing Lottery.";
while ($arr = $db->sql_fetchrow($res))
{
$res2 = $db->sql_query("SELECT modcomment FROM ".$db_prefix."_users WHERE id = $arr[user]") ;
$arr2 = $db->sql_fetchrow($res2);
$modcomment = $arr2['modcomment'];
$modcom = "User won the lottery: " . mksize($pot) . " at " . gmdate("Y-m-d H:i:s", time()) . "\n" . $modcomment;
$db->sql_query("UPDATE ".$db_prefix."_users SET uploaded = uploaded + $pot, modcomment = '".$modcom."' WHERE id = $arr[user]") ;
$db->sql_query("INSERT INTO ".$db_prefix."_private_messages (sender, recipient, subject, text, sent) VALUES('1', '".$arr['user']."', 'LOTTERY', '".$msg."', NOW())") ;
$who_won[] = $arr['user'];
}
}
else
{
$pot = $total * $size / $arr_config['total_winners'];
$res = $db->sql_query("SELECT user FROM ".$db_prefix."_tickets ORDER BY RAND() LIMIT $arr_config[total_winners]") ;
$who_won = array();
$msg = "Congratulations, You have won: <b>".mksize($pot)."</b>.<br /><br />This has been added to your upload amount<br /><br />Thanks for playing Lottery.";
while ($arr = $db->sql_fetchrow($res))
{
$res2 = $db->sql_query("SELECT modcomment FROM ".$db_prefix."_users WHERE id = $arr[user]") ;
$arr2 = $db->sql_fetchrow($res2);
$modcomment = $arr2['modcomment'];
$modcom = "User won the lottery: " . mksize($pot) . " at " . gmdate("Y-m-d H:i:s", time()) . "\n" . $modcomment;
$db->sql_query("UPDATE ".$db_prefix."_users SET uploaded = uploaded + $pot, modcomment = '".$modcom."' WHERE id = $arr[user]") ;
$db->sql_query("INSERT INTO ".$db_prefix."_private_messages (sender, recipient, subject, text, sent) VALUES('1', '".$arr['user']."', 'LOTTERY', '".$msg."', NOW())") ;
$who_won[] = $arr['user'];
}
}
$who_won = implode("|", $who_won);
$who_won_date = gmdate("Y-m-d H:i:s", time());
$who_won_prize = $pot;
$db->sql_query("TRUNCATE TABLE ".$db_prefix."_tickets") ;
if ($who_won != '')
{
$db->sql_query("UPDATE ".$db_prefix."_lottery_config SET value = '$who_won' WHERE name = 'lottery_winners'") ;
$db->sql_query("UPDATE ".$db_prefix."_lottery_config SET value = '$who_won_prize' WHERE name = 'lottery_winners_amount'") ;
$db->sql_query("UPDATE ".$db_prefix."_lottery_config SET value = '$who_won_date' WHERE name = 'lottery_winners_time'") ;
}
$db->sql_query("UPDATE ".$db_prefix."_lottery_config SET value = '0' WHERE name = 'enable'") ;
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// TRYS CASINO //
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$hours = 1; // Hours to wait after using all tries, until they will be restarted
$sql = $db->sql_query("SELECT userid, trys, date, enableplay FROM ".$db_prefix."_casino WHERE UNIX_TIMESTAMP(date) < UNIX_TIMESTAMP(NOW()) - 300 AND trys >= '0' AND enableplay = 'yes'");
while ($arr = $db->sql_fetchrow($res))
{
$db->sql_query("UPDATE ".$db_prefix."_casino SET trys='0' WHERE userid='".$arr['userid']."'");
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// TRYS CASINO //
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// EFFACEMENT DES VIEILLES REQUETES //
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$hours = 720; // Hours to keep no filled requests 720=30days, 30*24=720
$res = $db->sql_query("SELECT id, userid, request, descr, added, hits, cat, filled, filledby FROM ".$db_prefix."_requests WHERE UNIX_TIMESTAMP(added) < UNIX_TIMESTAMP(NOW()) - $hours*3600") ;
while ($arr = $db->sql_fetchrow($res))
{
$db->sql_query("DELETE FROM ".$db_prefix."_requests WHERE id=$arr[id]") ;
$db->sql_query("DELETE FROM ".$db_prefix."_addedrequests WHERE id=$arr[id]") ;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// FIN EFFACEMENT DES VIEILLES REQUETES //
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// EFFACEMENT DES PROPOSITIONS UPLOAD //
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$hours = 360; // Hours to keep offers 360=15days, 15*24=360
$jours = ($hours/24);
$res = $db->sql_query("SELECT id, name, userid FROM ".$db_prefix."_offers WHERE UNIX_TIMESTAMP(added) < UNIX_TIMESTAMP(NOW()) - $hours*3600");
while ($arr = $db->sql_fetchrow($res))
{
$db->sql_query("DELETE FROM ".$db_prefix."_offers WHERE id=$arr[id]") ;
$db->sql_query("DELETE FROM ".$db_prefix."_offervotes WHERE offerid=$arr[id]") ;
$db->sql_query("UPDATE ".$db_prefix."_users SET seedbonus = seedbonus - '10.0' WHERE id = $arr[userid]") ;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// FIN EFFACEMENT DES PROPOSITIONS UPLOAD //
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//die();
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// FLASHSCORES //
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$hours = 720; // Hours to keep MPS 720=30 days, 720/24=30
$res =$db->sql_query("SELECT ID, game, user, level, score, date FROM ".$db_prefix."_flashscores WHERE UNIX_TIMESTAMP(date) < UNIX_TIMESTAMP(NOW()) - $hours*3600");
while ($arr = $db->sql_fetchrow($res))
{
$db->sql_query("DELETE FROM ".$db_prefix."_flashscores WHERE date < '".get_date_time(gmtime() - $hours)."'");
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// FLASHSCORES //
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//SET INVITE AMOUNTS ACCORDING TO RATIO/GIGS ETC
autoinvites(10,1,4,.90,1);
autoinvites(10,4,7,.95,2);
autoinvites(10,7,10,1.00,3);
autoinvites(10,10,100000,1.05,4);
//END INVITES
if (isset($autoscrape)) multiscrape();
autoclean();
if ($autodel_users)
{
$sql = "SELECT id FROM ".$db_prefix."_users WHERE inactwarning = 1 AND UNIX_TIMESTAMP(inactive_warn_time) < UNIX_TIMESTAMP(NOW()) - ".intval($autodel_users_time).";";
$res = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($res))
{
removedinactive($row['id']);
}
$db->sql_freeresult($res);
}
}
//cleanup();
register_shutdown_function("cleanup");
?>