public function getEventCategories() { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); mysql_query("set names 'utf8'"); $query = mysql_query("SELECT * FROM `EventCatigories` ") or die(mysql_error()); $stack = array(); while ($row = mysql_fetch_array($query, MYSQL_ASSOC)) { array_push($stack, $row); } echo json_encode($stack); $dbConnect->close(); }
public function getGroupList($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $query = mysql_query("SELECT * FROM `groups` LIMIT " . $inputs->limit . "") or die(mysql_error()); $stack = array(); while ($row = mysql_fetch_array($query)) { $respond = array('id' => $row['Gid'], 'name' => $row['Gname'], 'ProfilePic' => $row['GProfilePic'], 'Royal' => $row['Royal']); array_push($stack, $respond); } echo json_encode($stack); $dbConnect->close(); }
public function GetFullNews($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); mysql_query("set names 'utf8'"); $query = mysql_query("SELECT * FROM News WHERE NewsID=" . $inputs->NewsID . ""); if ($query) { $row = mysql_fetch_array($query, MYSQL_ASSOC); echo json_encode($row); } else { $respond = array('sucess' => false); echo json_encode($respond); } $dbConnect->close(); }
public function SendFeedback($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $sql = "INSERT INTO `" . DB_DATABASE . "`.`Feedbacks` (`SenderID`, `FeedbackType`, `Subject`, `Message`)\n VALUES ('" . $inputs->SenderID . "', '" . $inputs->FeedbackType . "', '" . $inputs->Subject . "', '" . $inputs->Message . "');"; if (mysql_query($sql)) { $respond = array('sucess' => true); echo json_encode($respond); //successfully Registering new user } else { $respond = array('success' => false); echo json_encode($respond); //an error has been accourd } $dbConnect->close(); }
public function GetUserBlockList($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $sql = mysql_query("SELECT InvitationID FROM BlockList WHERE memberID=" . $inputs->memberID . " ORDER BY InvitationID"); if ($sql) { $stack = array(); while ($row = mysql_fetch_array($sql, MYSQL_ASSOC)) { array_push($stack, $row); } echo json_encode($stack); } else { $respond = array('sucess' => false); echo json_encode($respond); } $dbConnect->close(); }
public function retriveComments($inputs) { $tableName = $inputs->POSTType == 0 ? "EventsComments" : "NewsComments"; require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $sql = mysql_query("SELECT `" . $tableName . "`.`CommentID`,`members`.`name` ,`members`.`id`, `members`.`ProfilePic`\n , `" . $tableName . "`.`comment` from `" . $tableName . "` INNER JOIN `members`\n ON `members`.`id`=`" . $tableName . "`.`memberID`\n WHERE `" . $tableName . "`.`POSTID` = \"" . $inputs->POSTID . "\"\n LIMIT " . $inputs->start . ", " . $inputs->limit . " ") or die(mysql_error()); if ($sql) { $stack = array(); while ($row = mysql_fetch_array($sql, MYSQL_ASSOC)) { array_push($stack, $row); } echo json_encode($stack); } else { $respond = array('sucess' => false); echo json_encode($respond); } $dbConnect->close(); }
public function getInvitationList($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $query = mysql_query("SELECT * FROM `invitationPackages` LIMIT " . $inputs->limit . "") or die(mysql_error()); $stack = array(); while ($row = mysql_fetch_array($query)) { $invitations = new invitationPackages(); $invitations->id = $row['Packageid']; $invitations->number = $row['number']; $invitations->packageName = $row['packageName']; //$invitations->VIP=$row['VIP']; $invitations->price = $row['price']; array_push($stack, $invitations); } echo json_encode($stack); $dbConnect->close(); }
public function getUserInvNumber($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); mysql_query("set names 'utf8'"); $MembersQuery = mysql_query("SELECT `inNOR` , `inVIP` FROM `members` WHERE `id` = \"" . $inputs->id . "\" ") or die(mysql_error()); $membersRow = mysql_fetch_array($MembersQuery); if ($membersRow) { $respond = array('success' => true, 'inNOR' => $membersRow['inNOR'], 'inVIP' => $membersRow['inVIP']); echo json_encode($respond); } else { $respond = array('success' => false); echo json_encode($respond); } $dbConnect->close(); }
public function getEvents($inputs) { //$inputs->groupID;// -1:home page anyother value i am on a group //$inputs->catID;//-1 uncatigorized , anyother value catigorized //$inputs->start; //$inputs->limit; $timeNow = Date("Y-m-d h:m:s"); require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); mysql_query("set names 'utf8'"); $Filters = ""; if ($inputs->groupID == -1) { $Filters .= "AND `Events`.`VIP` = 1"; //Homepage } else { $Filters .= "AND `members`.`groupID` = " . $inputs->groupID . " "; //Group page } if ($inputs->catID != -1) { $Filters .= " AND `Events`.`eventType` = " . $inputs->catID . " "; //catigorized } if (1) { $Filters .= " AND `Events`.`TimeEnded` >= '" . $timeNow . "' "; //catigorized } $query = mysql_query("SELECT\n `Events`.`id` ,\n `members`.`name`,\n `members`.`groupID` ,\n `members`.`ProfilePic` ,\n `Events`.`subject` ,\n `Events`.`VIP` ,\n `Events`.`eventType` ,\n `Events`.`picture` ,\n `Events`.`TimeEnded` ,\n `Events`.`approved`\n from `Events` INNER JOIN `members` ON `Events`.`CreatorID`=`members`.`id`\n WHERE `Events`.`approved`=1 " . $Filters . "\n ORDER BY `Events`.`VIP` DESC,\n `Events`.`timeCreated` DESC\n LIMIT " . $inputs->start . ", " . $inputs->limit . " ") or die(mysql_error()); $stack = array(); while ($row = mysql_fetch_array($query)) { $user = array('Eventid' => $row['id'], 'CreatorName' => $row['name'], 'CreatorPic' => $row['ProfilePic'], 'subject' => $row['subject'], 'EventPic' => $row['picture'], 'catID' => $row['eventType'], 'VIP' => $row['VIP'], 'TimeEnded' => $row['TimeEnded']); array_push($stack, $user); } echo json_encode($stack); $dbConnect->close(); }
$dbConnect->close(); // if everything is ok, try to upload file } else { if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) { $respond = array('success' => true, 'id' => $TicketId); createthumb($target_file, $FileName . "150x150." . $imageFileType, 150, 150); $dbConnect = new DatabaseConnect(); mysql_query("UPDATE `" . DB_DATABASE . "`.`Images` SET `imageSrc` = '" . $FileNameOnline . "', `ext` = '" . $imageFileType . "' WHERE `Images`.`imageID` = " . $TicketId . ""); echo json_encode($respond); //SUCESS uploading } else { $respond = array('success' => false); echo json_encode($respond); $dbConnect = new DatabaseConnect(); mysql_query("DELETE FROM `Images` WHERE `imageID`=" . $TicketId . ""); $dbConnect->close(); } } } } function createthumb($name, $filename, $new_w, $new_h) { $system = explode(".", $name); if (preg_match("/jpg|jpeg/", $system[1])) { $src_img = imagecreatefromjpeg($name); } if (preg_match("/png/", $system[1])) { $src_img = imagecreatefrompng($name); } $old_x = imageSX($src_img); $old_y = imageSY($src_img);
public function DisapproveEventbyID($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $sql = mysql_query("SELECT `VIP` FROM `Events` WHERE `Events`.`id`=" . $inputs->Eventid) or die(mysql_error()); if ($sql) { $row = mysql_fetch_array($sql); if ($row["VIP"] == 1) { //Give the user back his points } else { // Just Send the dissaproval messege ي } } $dbConnect->close(); }
public function isInvited($inputs) { require_once "DataBaseConnection.php"; $dbConnect = new DatabaseConnect(); $query = mysql_query("SELECT * FROM `invitationsLog` WHERE `EventID` = \"" . $inputs->eventID . "\" AND\n `memberID` = \"" . $inputs->memberID . "\" ") or die(mysql_error()); $row = mysql_fetch_array($query); $respond = array('sucess' => false); if (!empty($row)) { $respond = array('sucess' => true); } echo json_encode($respond); $dbConnect->close(); }