$encodedStr = $encodedStr . "+" . $seed_array[$num]; $encodedStr = base64_encode($encodedStr); return $encodedStr; } date_default_timezone_set('America/Los_Angeles'); $db = new mysqldb(); // First lets check for any jobs which are a) Schedule for any time NOW or before AND b) Status is PENDING (0) // Now we need member id of campaign... later we'll need list id... we can probably do this as part of the same query with a join // while we're at it, let's get the message details? $now = date('Y-m-d G:i:s', strtotime("now")); $sql = "SELECT \r\nXJ.XE_JOB_ID AS JID,\r\nXJ.XE_JOB_CAMPAIGN_ID AS CID,\r\nXC.XE_CAMPAIGN_MID AS MID,\r\nXC.XE_CAMPAIGN_LIST_ID AS GID,\r\nXM.XE_MSG_FROM_LABEL AS FROM_LABEL,\r\nXM.XE_MSG_FROM_EMAIL AS FROM_EMAIL,\r\nXM.XE_MSG_SUBJECT AS SUBJECT,\r\nXM.XE_MSG_REPLY_TO AS REPLYTO,\r\nXM.XE_MSG_UNSUBSCRIBE AS UNSUBSCRIBE,\r\nXM.XE_MSG_POSTAL_ADDRESS AS ADDRESS,\r\nXM.XE_MSG_TEMPLATE_TEXT AS MSG_TXT,\r\nXM.XE_MSG_TEMPLATE_HTML AS MSG_HTML\r\nFROM XEBURA_JOBS AS XJ\r\nJOIN XEBURA_CAMPAIGN AS XC ON XJ.XE_JOB_CAMPAIGN_ID = XC.XE_CAMPAIGN_ID\r\nJOIN XEBURA_MESSAGE AS XM ON XJ.XE_JOB_CAMPAIGN_ID = XM.XE_MSG_CAMPAIGN_ID\r\nWHERE XE_JOB_LAUNCH <= '" . $now . "'\r\nAND XE_JOB_STATUS = '0'"; //job status 0 = pending // now that we've got the campaigns, we need to loop over them.. $db->query($sql); $result = $db->query($sql); $total_items = $db->getNumRows($result); if ($db->getNumRows($result) > 0) { while (list($jid, $cid, $mid, $gid, $from_label, $from_email, $subject, $replyto, $unsubscribe, $address, $msg_txt, $msg_html) = $db->fetchQueryRow($result)) { // get the amazon credentials for the campaign creator $res = $db->query("SELECT\r\nXE_AMZ_ACCESS_KEY AS ACCESS_KEY,\r\nXE_AMZ_SECRET_KEY AS SECRET_KEY\r\nFROM XEBURA_AMAZON_CREDENTIALS\r\nWHERE XE_AMZ_MID = '" . $mid . "'"); $row = $db->fetchQueryArray($res); $amz_akey = $row['ACCESS_KEY']; $amz_skey = $row['SECRET_KEY']; // intialize ses class $ses = new SimpleEmailService($amz_akey, $amz_skey); // now for our inner loop, let's find out who we're supposed to send this campaign out to, and loop over them. // need to add check for sending allowed status on email record to this query later // remove LIMIT // update campaign as launched $values = array(XE_CAMPAIGN_STATUS => '2'); // status 2 = launched
// Beverly Hills, CA 90211 // USA // www.xebura.com // hello@xebura.com //============================================================+ /* If the session exists for a user and it accidently comes to the index page then first it unsets the message on session. */ if (isset($_SESSION['SHOWMESSAGE'])) { unset($_SESSION['SHOWMESSAGE']); } include "include/unsecure_includes.php"; if (isset($_REQUEST['username']) && trim($_REQUEST['username']) != "") { $db = new mysqldb(); $sql = "select * from xebura_MEMBERS where USERNAME='******'username']) . "' and PASSWORD='******'password'])) . "' AND ACCOUNT_STATUS ='1'"; $result = $db->query($sql); $num = $db->getNumRows($result); if ($num > 0) { $row = $db->fetchQueryArray($result); $aid = $row["AID"]; $mid = $row["MID"]; /*include "online.php"; $row=$db->fetchQueryArray($result); $aid=$row["AID"]; echo $aid; $mid=$row["MID"];echo $mid; //exit; if($_POST['username']!="") { $users_online_read = fopen("$log_file", "r"); $users_online = fread($users_online_read, filesize("$log_file")); fclose($users_online_read); $users_online=explode("\n",$users_online);
$onl = new onlinedb(); } if (@(!$smarty)) { $smarty = new Smarty(); } if (@(!$mailobj)) { $mailobj = new MyEmail(); } require_once 'language/smarty_assign.php'; if (!isset($hide_side_menu) || $hide_side_menu == true) { require_once 'sidemenu_details.php'; } require_once 'validation.php'; $query = "SELECT LOGIN_STATUS, IS_TEMP_PASSWORD FROM xebura_MEMBERS WHERE MID = '" . $_SESSION['Member_Id'] . "'"; $result = $db->query($query); if ($db->getNumRows($result) > 0) { $row = $db->fetchQueryArray($result); $smarty->assign("first_time_login", $row['LOGIN_STATUS']); if ($row['IS_TEMP_PASSWORD'] == 1) { $smarty->assign("temp_pass", 1); } else { $smarty->assign("temp_pass", 0); } // echo $row['LOGIN_STATUS'].'-->'.$row['IS_TEMP_PASSWORD']; if ($row['LOGIN_STATUS'] == 0 || $row['IS_TEMP_PASSWORD'] == 1) { // Do not show menu $show_user_menu = 0; $topmenu_opt = array("Home"); $topmenu = array(_DASHBOARD); } else { // Show menu