firefly007 |
29th July 2013 15:24 |
Quote:
Originally Posted by FENIX
(Post 41128)
Hello. so I did. The question is, how well did I do? If it is bad, wanted ask for the correction of errors. Thank you very much.
|
Hi: there is no way that the above would work.
Try this
PHP Code:
<? /***********************************************/ /*===============[The Best v.5.6]==============*/ /*=============[Special Thanks To]=============*/ /* DrNet - wWw.SpecialCoders.CoM */ /* Vinson - wWw.Decode4u.CoM */ /* MrDecoder - wWw.Fearless-Releases.CoM */ /* Fynnon - wWw.BvList.CoM */ /***********************************************/
if (!defined ('IN_CRON')) { exit (); }
require INC_PATH . '/functions_pm.php'; mysql_query ('DELETE FROM shoutbox WHERE date < \'' . (TIMENOW - 604800) . '\''); ++$CQueryCount; mysql_query ('DELETE FROM loginattempts WHERE banned=\'no\' AND UNIX_TIMESTAMP(added) < \'' . (TIMENOW - 86400) . '\''); ++$CQueryCount; mysql_query ('DELETE FROM invites WHERE UNIX_TIMESTAMP(time_invited) < \'' . (TIMENOW - 172800) . '\''); ++$CQueryCount; mysql_query ('DELETE FROM ts_social_group_members WHERE type=\'inviteonly\' AND joined < \'' . (TIMENOW - 172800) . '\''); ++$CQueryCount; $query = mysql_query ('SELECT id, added FROM funds'); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $nowmonth = date ('m'); $dfid = array (); while ($funds = mysql_fetch_assoc ($query)) { $funds['added'] = @explode ('-', $funds['added']); if ($funds['added'][1] != $nowmonth) { $dfid[] = $funds['id']; continue; } }
if (count ($dfid)) { mysql_query ('DELETE FROM funds WHERE id IN (0, ' . implode (',', $dfid) . ')'); ++$CQueryCount; }
unset ($nowmonth); unset ($dfid); unset ($funds); }
$query = mysql_query ('SELECT id FROM users WHERE status = \'pending\' AND UNIX_TIMESTAMP(added) < \'' . (TIMENOW - 172800) . '\''); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $deleteuncousers = ''; while ($arr = mysql_fetch_assoc ($query)) { $deleteuncousers .= ',' . intval ($arr['id']); }
if (!empty ($deleteuncousers)) { mysql_query ('DELETE FROM users WHERE id IN (0' . $deleteuncousers . ')'); ++$CQueryCount; }
unset ($deleteuncousers); unset ($arr); }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE warned=\'yes\' AND warneduntil < NOW() AND enabled=\'yes\''); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET warned = \'no\', timeswarned = IF(timeswarned > 0, timeswarned - 1, 0), warneduntil = \'0000-00-00 00:00:00\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Warning removed by System. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; }
unset ($userids); }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE enabled=\'yes\' AND timeswarned >= \'' . $ban_user_limit . '\''); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); $reason = 'Reason: Automaticly banned system. (Max. Warn Limit [' . $ban_user_limit . '] reached!'; while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET enabled = \'no\', usergroup = \'' . UC_BANNED . '\', notifs = ' . sqlesc ($reason) . ', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ('' . ' - ' . $reason . ' \', modcomment) WHERE id IN (0,') . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been banned: ' . implode (', ', $userids) . '. ' . $reason); ++$CQueryCount; }
unset ($userids); unset ($reason); }
$query = mysql_query ('' . 'SELECT DISTINCT id FROM users WHERE leechwarn = \'yes\' AND uploaded / downloaded >= ' . $leechwarn_remove_ratio . ' AND enabled=\'yes\''); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET leechwarn = \'no\', leechwarnuntil = \'0000-00-00 00:00:00\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Leech-Warning removed by System. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; unset ($userids); } }
$downloaded = $leechwarn_gig_limit * 1024 * 1024 * 1024; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_USER . ('' . '\' AND leechwarn = \'no\' AND enabled=\'yes\' AND uploaded / downloaded < ' . $leechwarn_min_ratio . ' AND downloaded >= ' . $downloaded)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); $until = strtotime ('+' . $leechwarn_length . ' week' . (1 < $leechwarn_length ? 's' : '')); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET leechwarn = \'yes\', leechwarnuntil = FROM_UNIXTIME(' . $until . '), modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Leech-Warned by System - Low Ratio. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been leech-warned: ' . implode (', ', $userids) . '. Reason: Automatic Leech-Warn System!'); ++$CQueryCount; foreach ($userids as $wid) { send_pm ($wid, sprintf ($lang->cronjobs['lwarning_message'], $leechwarn_remove_ratio, $leechwarn_length), $lang->cronjobs['lwarning_subject']); ++$CQueryCount; }
unset ($downloaded); unset ($userids); unset ($until); unset ($wid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_USER . '\' AND enabled = \'yes\' AND leechwarn = \'yes\' AND leechwarnuntil < NOW()'); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); $reason = 'Reason: Banned by System because of Leech-Warning expired!'; while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET enabled = \'no\', usergroup = \'' . UC_BANNED . '\', notifs = ' . sqlesc ($reason) . ', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ('' . ' - ' . $reason . ' \', modcomment) WHERE id IN (0,') . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been banned: ' . implode (', ', $userids) . '. ' . $reason); ++$CQueryCount; }
unset ($reason); unset ($userids); }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE donor = \'yes\' AND donoruntil < NOW() AND donoruntil <> \'0000-00-00 00:00:00\' AND enabled = \'yes\''); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = IF(usergroup < ' . UC_UPLOADER . ', ' . UC_PLATINIUM_USER . ', ' . UC_GOLD_USER . ', ' . UC_SILVER_USER . ', ' . UC_BRONZE_USER . ', ' . UC_VETERAN . ', ' . UC_FANATIC . ', ' . UC_MANIAC . ', ' . UC_POWER_EXTREME . ', ' . UC_EXTREME . ', ' . UC_POWER_SEEDER . ', ' . UC_SEEDER . ', ' . UC_POWER_USER . ', ' . UC_USER . '), donor = \'no\', donoruntil = \'0000-00-00 00:00:00\', title=\'\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Donor status removed by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted: ' . implode (', ', $userids) . '. Reason: Donor status has been expired!'); ++$CQueryCount; foreach ($userids as $rid) { send_pm ($rid, $lang->cronjobs['donor_message'], $lang->cronjobs['donor_subject']); ++$CQueryCount; } }
unset ($userids); unset ($rid); }
$query = mysql_query ('SELECT v.userid as id, v.old_gid, u.modcomment, g.gid FROM ts_auto_vip v LEFT JOIN users u ON (v.userid=u.id) LEFT JOIN usergroups g ON (u.usergroup=g.gid) WHERE v.vip_until < NOW() AND g.cansettingspanel != \'yes\' AND g.canstaffpanel != \'yes\' AND g.issupermod != \'yes\' AND g.isforummod != \'yes\' AND u.enabled=\'yes\' AND u.usergroup != ' . UC_BANNED . ''); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $RemoveVStatus = array (); while ($arr = mysql_fetch_assoc ($query)) { send_pm ($arr['id'], $lang->cronjobs['vip_message'], $lang->cronjobs['vip_subject']); ++$CQueryCount; $RemoveVStatus[] = $arr['id']; mysql_query ('UPDATE users SET usergroup = \'' . ($arr['old_gid'] ? $arr['old_gid'] : UC_POWER_USER) . '\', modcomment = ' . sqlesc (gmdate ('Y-m-d') . ' - VIP status removed by -AutoSystem. ' . $arr['modcomment']) . ' WHERE id = ' . sqlesc ($arr['id'])); ++$CQueryCount; mysql_query ('DELETE FROM ts_auto_vip WHERE userid = ' . sqlesc ($arr['id'])); ++$CQueryCount; }
savelog ('Following user(s) has been demoted: ' . implode (', ', $RemoveVStatus) . '. Reason: KPS VIP status has been expired!'); ++$CQueryCount; unset ($RemoveVStatus); }
if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_USER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_POWER_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to POWER USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to Power User Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_USER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to User Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*======================================================================================================================================================SEEDER*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_USER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_SEEDER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to SEEDER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to SEEDER Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_SEEDER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_POWER_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to POWER USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to Power User Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*====================================================================================================================================================================POWER SEEDEER*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_SEEDER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_POWER_SEEDER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to POWER SEEDER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to Power Seeder Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_SEEDER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_SEEDER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to SEEDER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to Seeder Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*======================================================================================================================================================EXTREME*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_SEEDER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_EXTREME . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to EXTREME by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to EXTREME Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_SEEDER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_POWER_SEEDER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to SEEDER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to POWER SEEDER Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*===========================================================================================================================================================POWER EXTREME*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_SEEDER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_POWER_EXTREME . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to POWER EXTREME by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to Power User Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_EXTREME . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_EXTREME . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to EXTREME by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to EXTREME Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*========================================================================================================================================================MANIAC*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_EXTREME . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_MANIAC . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to MANIAC by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to MANIAC Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_POWER_EXTREME . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_POWER_EXTREME . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to POWER EXTREME Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*===============================================================================================================================================================FANATIC*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_MANIAC . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_FANATIC . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to FANATIC by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to FANATIC Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_MANIAC . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_MANIAC . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to MANIAC by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to MANIAC Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*===========================================================================================================================================================VETERAN*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_FANATIC . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_VETERAN . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to VETERAN by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to VETERAN Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_FANATIC . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_FANATIC . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to FANATIC by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to FANATIC Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*==========================================================================================================================================================BRONZE USER*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_VETERAN . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_BRONZE_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to BRONZE USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to BRONZE User Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_VETERAN . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_VETERAN . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to VETERAN by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to VETERAN Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*===============================================================================================================================================================SILVER USER*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_BRONZE_USER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_SILVER_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to SILVER USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to Silver User Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_BRONZE_USER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_BRONZE_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to BRONZE USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to BRONZE User Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*==================================================================================================================================================================GOLD USER*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_SILVER_USER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_GOLD_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to GOLD USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to GOLD User Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_SILVER_USER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_SILVER_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to SILVER USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to SILVER User Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } } /*======================================================================================================================================================PLATINIUM USER*/ if (0 < intval ($promote_gig_limit)) { $limit = $promote_gig_limit * 1024 * 1024 * 1024; $maxdt = TIMENOW - 86400 * $promote_min_reg_days; $query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_GOLD_USER . ('' . '\' AND enabled = \'yes\' AND uploaded >= ' . $limit . ' AND uploaded / downloaded >= ' . $promote_min_ratio . ' AND UNIX_TIMESTAMP(added) < ' . $maxdt)); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_PLATINIUM_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Promoted to PLATINIUM USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been promoted to PLATINIUM User Class: ' . implode (', ', $userids) . '. Reason: Automatic Promotion System!'); ++$CQueryCount; foreach ($userids as $pid) { send_pm ($pid, $lang->cronjobs['promote_message'], $lang->cronjobs['promote_subject']); ++$CQueryCount; } }
unset ($limit); unset ($maxdt); unset ($userids); unset ($pid); } }
$query = mysql_query ('SELECT DISTINCT id FROM users WHERE usergroup = \'' . UC_GOLD_USER . ('' . '\' AND uploaded / downloaded < ' . $demote_min_ratio . ' AND enabled=\'yes\'')); ++$CQueryCount; if (0 < mysql_num_rows ($query)) { $userids = array (); while ($arr = mysql_fetch_assoc ($query)) { $userids[] = $arr['id']; }
if (count ($userids)) { mysql_query ('UPDATE users SET usergroup = \'' . UC_GOLD_USER . '\', modcomment = CONCAT(\'' . gmdate ('Y-m-d') . ' - Demoted to GOLD USER by -AutoSystem. \', modcomment) WHERE id IN (0,' . implode (',', $userids) . ')'); ++$CQueryCount; savelog ('Following user(s) has been demoted to GOLD User Class: ' . implode (', ', $userids) . '. Reason: Automatic Demotion System!'); ++$CQueryCount; foreach ($userids as $did) { send_pm ($did, sprintf ($lang->cronjobs['demote_message'], $demote_min_ratio), $lang->cronjobs['demote_subject']); ++$CQueryCount; } }
unset($userids); unset($did); }
?>
|