<?php
if(!defined('SCRIPTNAME') OR (defined('SCRIPTNAME') AND SCRIPTNAME != 'cron.php'))
{
exit;
}
function hourly_cron(){
global $TSUE;
$find_scene_new_member = "SELECT
tsue_invites.sender_memberid,
tsue_invites.receiver_memberid,
tsue_members.membergroupid
FROM
tsue_member_profile
Inner Join tsue_invites ON tsue_invites.receiver_memberid = tsue_member_profile.memberid
Inner Join tsue_members ON tsue_invites.receiver_memberid = tsue_members.memberid
WHERE
tsue_invites.sender_memberid = '5555'  and tsue_members.joindate > UNIX_TIMESTAMP(now()) -  86400
";
$list = $TSUE['TSUE_Database']->query($find_scene_new_member);
while ($member = $list->fetch_assoc()) {
$update_scene_new_member = "Update tsue_members set tsue_members.membergroupid = '44' WHERE tsue_members.memberid = '".$member['receiver_memberid']."'";
$list = $TSUE['TSUE_Database']->query($update_scene_new_member);
}
}

ALTER TABLE tsue_member_profile MODIFY downloaded bigint(20) NOT NULL DEFAULT 1048576;
UPDATE tsue_member_profile set downloaded = '1048576' where downloaded = '0';