Vergleich inc/tasks/promotions.php - 1.6.3 - 1.6.17

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 6
 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * Website: http://mybb.com
* License: http://mybb.com/about/license
*

 * $Id: promotions.php 5380 2011-02-21 12:04:43Z Tomm $

 * $Id$

 */

function task_promotions($task)
{
global $mybb, $db, $lang, $cache;

 */

function task_promotions($task)
{
global $mybb, $db, $lang, $cache;

	



$usergroups = $cache->read("usergroups");

	// Iterate through all our promotions
$query = $db->simple_select("promotions", "*", "enabled = '1'");
while($promotion = $db->fetch_array($query))
{

	// Iterate through all our promotions
$query = $db->simple_select("promotions", "*", "enabled = '1'");
while($promotion = $db->fetch_array($query))
{

 
		// Does the destination usergroup even exist?? If it doesn't and it moves a user to it, the user will get PHP errors.
if(!array_key_exists($promotion['newusergroup'], $usergroups))
{
// Instead of just skipping this promotion, disable it to stop it even being selected when this task is run.
$update = array(
"enabled" => 0
);
$db->update_query("promotions", $update, "pid = '" . intval($promotion['pid']) . "'");
continue;
}


		$and = "";
$sql_where = "";

		$and = "";
$sql_where = "";

		



		// Based on the promotion generate criteria for user selection
$requirements = explode(',', $promotion['requirements']);
if(in_array('postcount', $requirements) && intval($promotion['posts']) >= 0 && !empty($promotion['posttype']))
{
$sql_where .= "{$and}postnum {$promotion['posttype']} '{$promotion['posts']}'";

		// Based on the promotion generate criteria for user selection
$requirements = explode(',', $promotion['requirements']);
if(in_array('postcount', $requirements) && intval($promotion['posts']) >= 0 && !empty($promotion['posttype']))
{
$sql_where .= "{$and}postnum {$promotion['posttype']} '{$promotion['posts']}'";

			



			$and = " AND ";
}

			$and = " AND ";
}

		



		if(in_array('reputation', $requirements) && !empty($promotion['reputationtype']))
{
$sql_where .= "{$and}reputation {$promotion['reputationtype']} '{$promotion['reputations']}'";

		if(in_array('reputation', $requirements) && !empty($promotion['reputationtype']))
{
$sql_where .= "{$and}reputation {$promotion['reputationtype']} '{$promotion['reputations']}'";

			
$and = " AND ";
}



$and = " AND ";
}


		if(in_array('referrals', $requirements) && intval($promotion['referrals']) >= 0 && !empty($promotion['referralstype']))
{
$sql_where .= "{$and}referrals {$promotion['referralstype']} '{$promotion['referrals']}'";

		if(in_array('referrals', $requirements) && intval($promotion['referrals']) >= 0 && !empty($promotion['referralstype']))
{
$sql_where .= "{$and}referrals {$promotion['referralstype']} '{$promotion['referrals']}'";

			



			$and = " AND ";
}

			$and = " AND ";
}

		



		if(in_array('timeregistered', $requirements) && intval($promotion['registered']) > 0 && !empty($promotion['registeredtype']))
{
switch($promotion['registeredtype'])

		if(in_array('timeregistered', $requirements) && intval($promotion['registered']) > 0 && !empty($promotion['registeredtype']))
{
switch($promotion['registeredtype'])

Zeile 55Zeile 67
					break;
case "weeks":
$regdate = $promotion['registered']*60*60*24*7;

					break;
case "weeks":
$regdate = $promotion['registered']*60*60*24*7;

 
					break;

				case "months":
$regdate = $promotion['registered']*60*60*24*30;

				case "months":
$regdate = $promotion['registered']*60*60*24*30;

					break;

					break;

				case "years":
$regdate = $promotion['registered']*60*60*24*365;
break;

				case "years":
$regdate = $promotion['registered']*60*60*24*365;
break;

Zeile 67Zeile 80
			$sql_where .= "{$and}regdate <= '".(TIME_NOW-$regdate)."'";
$and = " AND ";
}

			$sql_where .= "{$and}regdate <= '".(TIME_NOW-$regdate)."'";
$and = " AND ";
}

		



		if(!empty($promotion['originalusergroup']) && $promotion['originalusergroup'] != '*')
{
$sql_where .= "{$and}usergroup IN ({$promotion['originalusergroup']})";

		if(!empty($promotion['originalusergroup']) && $promotion['originalusergroup'] != '*')
{
$sql_where .= "{$and}usergroup IN ({$promotion['originalusergroup']})";

				
$and = " AND ";
}



$and = " AND ";
}


		if(!empty($promotion['newusergroup']))
{
$sql_where .= "{$and}usergroup != '{$promotion['newusergroup']}'";

		if(!empty($promotion['newusergroup']))
{
$sql_where .= "{$and}usergroup != '{$promotion['newusergroup']}'";

					



			$and = " AND ";
}

			$and = " AND ";
}

		



		$sql_where .= "{$and}lastactive >= '{$task['lastrun']}'";

		$sql_where .= "{$and}lastactive >= '{$task['lastrun']}'";

		





// Exclude super admins
$sql_where .= not_super_admins(true);


		$uid = array();
$log_inserts = array();

		$uid = array();
$log_inserts = array();

		



		if($promotion['usergrouptype'] == "secondary")
{
$usergroup_select = "additionalgroups";

		if($promotion['usergrouptype'] == "secondary")
{
$usergroup_select = "additionalgroups";

Zeile 95Zeile 111
		{
$usergroup_select = "usergroup";
}

		{
$usergroup_select = "usergroup";
}

		



		$query2 = $db->simple_select("users", "uid,{$usergroup_select}", $sql_where);
while($user = $db->fetch_array($query2))
{

		$query2 = $db->simple_select("users", "uid,{$usergroup_select}", $sql_where);
while($user = $db->fetch_array($query2))
{

Zeile 122Zeile 138
					'type' => "primary",
);
}

					'type' => "primary",
);
}

		



			$uids[] = $user['uid'];

			$uids[] = $user['uid'];

			





			if($usergroup_select == "additionalgroups")
{
if(join_usergroup($user['uid'], $promotion['newusergroup']) === false)

			if($usergroup_select == "additionalgroups")
{
if(join_usergroup($user['uid'], $promotion['newusergroup']) === false)

Zeile 135Zeile 151
					array_pop($uids);
}
}

					array_pop($uids);
}
}

			



			if((count($uids) % 20) == 0)
{
if($usergroup_select == "usergroup")

			if((count($uids) % 20) == 0)
{
if($usergroup_select == "usergroup")

				{

				{

					$db->update_query("users", array('usergroup' => $promotion['newusergroup']), "uid IN(".implode(",", $uids).")");
}

					$db->update_query("users", array('usergroup' => $promotion['newusergroup']), "uid IN(".implode(",", $uids).")");
}

				



				if(!empty($log_inserts))
{
$db->insert_query_multiple("promotionlogs", $log_inserts);
}

				if(!empty($log_inserts))
{
$db->insert_query_multiple("promotionlogs", $log_inserts);
}

				



				$uids = array();
$log_inserts = array();

				$uids = array();
$log_inserts = array();

			}

			}

		}

		}

		



		if(count($uids) > 0)
{
if($usergroup_select == "usergroup")
{
$db->update_query("users", array('usergroup' => $promotion['newusergroup']), "uid IN(".implode(",", $uids).")");
}

		if(count($uids) > 0)
{
if($usergroup_select == "usergroup")
{
$db->update_query("users", array('usergroup' => $promotion['newusergroup']), "uid IN(".implode(",", $uids).")");
}

			



			if(!empty($log_inserts))
{
$db->insert_query_multiple("promotionlogs", $log_inserts);
}

			if(!empty($log_inserts))
{
$db->insert_query_multiple("promotionlogs", $log_inserts);
}

				



			$uids = array();
$log_inserts = array();
}
}

			$uids = array();
$log_inserts = array();
}
}

	



	$cache->update_moderators();

	$cache->update_moderators();

	



	add_task_log($task, $lang->task_promotions_ran);
}
?>

	add_task_log($task, $lang->task_promotions_ran);
}
?>