// First check if campaigns raised max money level print "\nChecking if active campaigns raises max money level:\n"; $find_active_campaigns = mysql_query("SELECT id,max_money,campaign_type FROM campaigns WHERE enabled='1' AND max_money != '0';"); while ($campaign = mysql_fetch_array($find_active_campaigns)) { $campaign_id = $campaign['id']; $campaign_max_money = $campaign['max_money']; $campaign_type = $campaign['campaign_type']; switch ($campaign_type) { case 'oneweek': $fare = 0.01; break; case 'twoweeks': $fare = 0.05; break; } $campaign_fund_raised = $money_class->GetCampaignAmountReceived($campaign_id); $campaign_fund_raised_a = $campaign_fund_raised['sum(amount)']; if ($campaign_fund_raised_a == '') { $campaign_fund_raised_a = '0'; } if ($campaign_fund_raised_a >= $campaign_max_money) { $to_status = 'will disable it'; //Disable campaign: $disable = mysql_query("UPDATE campaigns SET enabled = '0' WHERE id = '" . $campaign_id . "';"); //Send notif to liquidate campaign switch ($campaign_type) { case 'oneweek': $fare = 0.01; break; case 'twoweeks': $fare = 0.05;
// REMOVE IT FOR PRODUCTION require_once '../twitteroauth/twitteroauth.php'; require_once '../config.php'; require_once '../classes.php'; $money_class = new MoneyStuff(); $user_class = new Users(); // First check active campaigns print "\nChecking active campaigns...\n"; $find_active_campaigns = mysql_query("SELECT id,needed_money,user_id FROM campaigns WHERE enabled='1';"); while ($campaign = mysql_fetch_array($find_active_campaigns)) { $campaign_id = $campaign['id']; $campaign_user_id = $campaign['user_id']; $campaign_needed_money = $campaign['needed_money']; $campaign_twitter_user_id = $user_class->GetTwitterIdFromUserId($campaign_user_id); $campaign_twitter_screen_name = $user_class->GetUSerScreenName($campaign_user_id); $campaign_amount = $money_class->GetCampaignAmountReceived($campaign_id); $campaign_user_currency = $user_class->GetUSerCurrency($campaign_user_id); $campaign_fund_raised_a = $campaign_amount['sum(amount)']; if ($campaign_fund_raised_a == '') { $campaign_fund_raised_a = 0; } //be careful, notifier: //Get random value from $notificator array $k = array_rand($notificator); $notificator_data = $notificator[$k]; $link = "https://" . TUITFLOW_URL . "campaign.php?id=" . $campaign_id; $connection_own = new TwitterOAuth($notificator_data['consumer_key'], $notificator_data['consumer_secret'], $notificator_data['own_key'], $notificator_data['own_secret']); $user_prof = $user_class->GetUSerFullProfile($campaign_user_id); $user_lang = $user_prof['languaje']; if ($user_lang == 'es') { $status = "@" . $campaign_twitter_screen_name . ", tu campaña ha recaudado hasta hoy: " . $campaign_fund_raised_a . ' ' . $campaign_user_currency . '. ¡Sigue difundiendola y consigue tu objetivo! ' . $link;