function setstatus($data, $id = "")
{
$dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS);
$ids = explode(',', $_POST['id']);
for ($i = 0; $i < count($ids); $i++) {
$result = $dbase->_query("SELECT * FROM " . TBLPREFIX . "subscribers where id=\"{$ids[$i]}\"");
$recrow = mysql_fetch_row($result);
$stat = $recrow[15];
unset($recrow);
if ($stat == 1) {
$stat = 0;
} else {
$stat = 1;
}
$in = "update " . TBLPREFIX . "subscribers set status = {$stat}\n where id=\"{$ids[$i]}\"";
$result = $dbase->_query($in);
}
if ($result) {
} else {
}
unset($dbase);
}
function getProfileDetails()
{
$detailsJSON = array();
$JSONData = json_decode(file_get_contents('php://input'));
$breakerID = $JSONData->breaker_id;
$dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS);
$query = "SELECT B.id,B.socialid,B.mobile,B.country,B.name,B.username,B.email,B.profileimage,B.latitude,\n B.longitude,B.dateregistered,B.dateofbirth,B.about,B.gender,B.city,B.lang,\n (SELECT name_en FROM breakcategory WHERE id=(SELECT breakid FROM breaks WHERE pid={$breakerID} LIMIT 1)) as break_category_en,\n (SELECT name_ar FROM breakcategory WHERE id=(SELECT breakid FROM breaks WHERE pid={$breakerID} LIMIT 1)) as break_category_ar \n FROM breakers as B WHERE B.id={$breakerID}";
$result = $dbase->_query($query);
while ($row = mysql_fetch_array($result)) {
$details = array("id" => $row['id'], "socialid" => $row['socialid'], "mobile" => $row['mobile'], "country" => $row['country'], "name" => $row['name'], "username" => $row['username'], "email" => $row['email'], "breaker_image" => UPLOAD_SERVER . "/resources/images/profile/" . $row['profileimage'], "latitude" => $row['latitude'], "longitude" => $row['longitude'], "latitude" => $row['latitude'], "dateregistered" => $row['dateregistered'], "dateofbirth" => $row['dateofbirth'], "about" => $row['about'], "gender" => $row['gender'], "city" => $row['city'], "lang" => $row['lang'], "break_category_en" => $row['break_category_en'], "break_category_ar" => $row['break_category_ar']);
$detailsJSON[] = $details;
}
giveResponseToApp($detailsJSON);
}
