';
//
while ($row = mysqli_fetch_assoc($result)) {
$cnt++;
$xml.= "- ".$row['email']."";
/*
$xml.="".$row['first_name']."";
$xml.="".$row['middle_name']."";
$xml.="".$row['last_name']."";
*/
$xml.="".explode(" ",$row['join_date'])[0]."";
$xml.="".$row['cfirst_name']."";
/*
$xml.="".$row['cmiddle_name']."";
$xml.="".$row['clast_name']."";
*/
$xml.="".$row['gender']."";
$xml.="".$row['affiliateID']."";
// $xml.="".$row['uid']."";
$xml.="
".$row['subscribed']."";
$xml.="".$row['mail_opt']."";
$xml.="".explode(" ",$row['sub_date'])[0]."";
// $xml.="".$row['init']."";
// $xml.="".$row['public_id']."";
$xml.=" ";
}
$xml.= "".$cnt."";
$xml = file_get_contents("xml.txt"); //sara
echo $xml;
}else if($ui=="quick_load"){
//
$usql = "SELECT * FROM `Users` ORDER BY `join_date` DESC LIMIT 10000";
$result = mysqli_query($hookup, $usql);
$cnt = 0;
$xml='';
//
while ($row = mysqli_fetch_assoc($result)) {
$cnt++;
$xml.= "- ".$row['email']."";
/*
$xml.="".$row['first_name']."";
$xml.="".$row['middle_name']."";
$xml.="".$row['last_name']."";
*/
$xml.="".explode(" ",$row['join_date'])[0]."";
$xml.="".$row['cfirst_name']."";
/*
$xml.="".$row['cmiddle_name']."";
$xml.="".$row['clast_name']."";
*/
$xml.="".$row['gender']."";
$xml.="".$row['affiliateID']."";
// $xml.="".$row['uid']."";
$xml.="
".$row['subscribed']."";
$xml.="".$row['mail_opt']."";
$xml.="".explode(" ",$row['sub_date'])[0]."";
// $xml.="".$row['init']."";
// $xml.="".$row['public_id']."";
$xml.=" ";
}
$xml.= "".$cnt."";
echo $xml;
}else if($ui=="quick_sales"){
//
$usql = "SELECT * FROM `Users` WHERE `subscribed` > 0 ORDER BY `sub_date` DESC LIMIT 1000 ";
$result = mysqli_query($hookup, $usql);
$cnt = 0;
$xml='';
//
while ($row = mysqli_fetch_assoc($result)) {
$cnt++;
$xml.= "- ".$row['email']."";
/*
$xml.="".$row['first_name']."";
$xml.="".$row['middle_name']."";
$xml.="".$row['last_name']."";
*/
$xml.="".explode(" ",$row['join_date'])[0]."";
$xml.="".$row['cfirst_name']."";
/*
$xml.="".$row['cmiddle_name']."";
$xml.="".$row['clast_name']."";
*/
$xml.="".$row['gender']."";
$xml.="".$row['affiliateID']."";
// $xml.="".$row['uid']."";
$xml.="
".$row['subscribed']."";
$xml.="".$row['mail_opt']."";
$xml.="".explode(" ",$row['sub_date'])[0]."";
// $xml.="".$row['init']."";
// $xml.="".$row['public_id']."";
$xml.=" ";
}
$xml.= "".$cnt."";
echo $xml;
}else if($ui=="search_users"){
$email = $_POST['email'] ? $_POST['email'] : $_GET['email'];
$bsql = "SELECT * FROM `Users` WHERE `email` = '$email'";
$sresult = mysqli_query($hookup, $bsql);
$cnt = 0;
$xml="";
while ($row = mysqli_fetch_assoc($sresult)) {
$cnt++;
$xml.="- ".$row['ID']."";
$xml.= "".$row['email']."";
$xml.="".$row['uid']."";
$xml.="".$row['first_name']."";
$xml.="".$row['middle_name']."";
$xml.="".$row['last_name']."";
$xml.="".$row['cfirst_name']."";
$xml.="".$row['cmiddle_name']."";
$xml.="".$row['clast_name']."";
$xml.="".$row['subscribed']."";
$xml.="".$row['sub_date']."";
$xml.="".$row['user_name']."";
$xml.="".$row['dob']."";
$xml.="
";
}
$xml.= "";
echo $xml;
}else if($ui=="edituser"){
$uid = $_POST['uid'];
$subscribed = $_POST['subscribed'];
$sub_date = $_POST['sub_date'];
$first = $_POST['firstname'];
$middle = $_POST['middlename'];
$last = $_POST['lastname'];
$cfirst = $_POST['cfirstname'];
$cmiddle = $_POST['cmiddlename'];
$clast = $_POST['clastname'];
$uname = $_POST['user_name'];
$dob = $_POST['dob'];
$sql = "UPDATE `Users` SET `subscribed` = '$subscribed', `sub_date` = '$sub_date', `first_name` = '$first', `middle_name` = '$middle', `last_name` = '$last', `cfirst_name` = '$cfirst', `cmiddle_name` = '$cmiddle', `clast_name` = '$clast', `dob` = '$dob', `user_name` = '$uname' WHERE `ID` = '$uid'";
$result=mysqli_query($hookup, $sql);
if($result){
$return = "success";
echo $return;
}else{
$return = "error=" . $type. " / ". mysqli_error($hookup);
echo $return;
}
}else if($ui=="user_optout"){
$email=$_POST['email'];
$sql = "UPDATE `Users` SET `mail_opt` = '0' WHERE `email` IN ($email)";
$result=mysqli_query($hookup, $sql);
if($result){
$return = "success: ".$email;
echo $return;
}else{
$return = "error=" . $type. " / ". mysqli_error($hookup);
echo $return;
}
}else if($ui=="get_vendors"){
$sql = "SELECT * FROM `Vendors`";
$result=mysqli_query($hookup, $sql);
$xml="";
while ($row = mysqli_fetch_assoc($result)) {
$xml.="- ".$row['ID']."";
$xml.= "".$row['vname']."";
$xml.="
";
}
$xml.= "";
echo $xml;
}
file_put_contents("test.txt",$sql, FILE_APPEND );
file_put_contents("xml.txt",$xml, FILE_APPEND );
?>