}
array_push($orgnumberlist, $orgrow['orgnumber']);
$eventlist = array();
$eventrowarray = array();
$eventQuery = 'SELECT * FROM `event` WHERE `orgnumber`=' . $orgrow['orgnumber'];
if ($eventresults = mysqli_query($link, $eventQuery, MYSQLI_USE_RESULT)) {
while ($eventrow = mysqli_fetch_array($eventresults)) {
array_push($eventrowarray, $eventrow);
}
}
$eventlist = convertEventRows($eventrowarray);
$tmporg = array('name' => $orgrow['orgname'], 'orgNumber' => (int) $orgrow['orgnumber'], 'subscribed' => $subscribed, 'description' => $orgrow['description'], 'contact' => $orgrow['contact'], 'eventList' => $eventlist);
array_push($orglist, $tmporg);
}
mysqli_close($link);
$json_to_send = $orglist;
} elseif (strcmp($queryType, "myEvents") == 0) {
$json_to_send = convertEventRows($results);
} elseif (strcmp($queryType, "terms") == 0) {
$termlist = array();
foreach ($results as $termrow) {
$tmpterm = array('termID' => $termrow['termID']);
array_push($termlist, $tmpterm);
}
$json_to_send = $termlist;
}
echo json_encode($json_to_send);
} else {
echo 'Error';
}
}
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
$query = 'INSERT INTO `event`(`eventname`, `orgnumber`, `location`, `days`, `description`, `startyear`, `startmonth`, `startdayofmonth`, `endyear`, `endmonth`, `enddayofmonth`, `starthour`, `startminute`, `endhour`, `endminute`) VALUES (\'' . $eventname . '\',' . $orgnumber . ', \'' . $location . '\', \'' . $days . '\', \'' . $description . '\',' . $startyear . ',' . $startmonth . ',' . $startdayofmonth . ',' . $endyear . ',' . $endmonth . ',' . $enddayofmonth . ',' . $starthour . ',' . $startminute . ',' . $endhour . ',' . $endminute . ')';
//Database query
if (mysqli_query($link, $query)) {
require_once 'sendAndroidNotification.php';
require_once 'queryDatabaseHelper.php';
$getEventQuery = 'SELECT * FROM `event` WHERE `eventname`=\'' . $eventname . '\' AND `orgnumber`=' . $orgnumber . ' AND `location`=\'' . $location . '\' AND `days`=\'' . $days . '\' AND `description`=\'' . $description . '\' AND `startyear`=' . $startyear . ' AND `startmonth`=' . $startmonth . ' AND `startdayofmonth`=' . $startdayofmonth . ' AND `endyear`=' . $endyear . ' AND `endmonth`=' . $endmonth . ' AND `enddayofmonth`=' . $enddayofmonth . ' AND `starthour`=' . $starthour . ' AND `startminute`=' . $startminute . ' AND `endhour`=' . $endhour . ' AND `endminute`=' . $endminute;
if ($res = mysqli_query($link, $getEventQuery)) {
$eventarr = array();
$tmprow = mysqli_fetch_array($res);
$num = $tmprow['eventnumber'];
array_push($eventarr, $tmprow);
$convertedevents = convertEventRows($eventarr);
$registrationIDs = array();
// $usernames = array();
$subquery = 'SELECT `username` FROM `subscription` WHERE `orgnumber`=' . $orgnumber;
if ($subres = mysqli_query($link, $subquery)) {
while ($subrow = mysqli_fetch_array($subres)) {
$devicequery = 'SELECT * FROM `androiddevice`
INNER JOIN `subscription`
ON AndroidDevice.username=Subscription.username
WHERE \'' . $subrow['username'] . '\'=Subscription.username AND ' . $orgnumber . '=Subscription.orgnumber';
if ($regres = mysqli_query($link, $devicequery)) {
while ($regrow = mysqli_fetch_array($regres)) {
array_push($registrationIDs, $regrow['device_id']);
// array_push($usernames, $regrow['username']);
$insquery = 'INSERT IGNORE INTO `rsvp`(`username`, `eventnumber`) VALUES (\'' . $regrow['username'] . '\',' . $num . ')';
echo $insquery;
