}
}
$parameters = array($user);
// Get name of requestee for activity
$businessNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($businessNameQuery, array($business), false);
if ($name != false) {
// Found name
$businessName = $name[0];
$nameFound = true;
}
}
// Push notification to requestee
push_notification($business, 'New endorser', $userName . ' endorses you', 'BusinessPage', json_encode($parameters), $user);
// Create activity for new endorsement
create_activity($user, 'endorsement', json_encode(array($userName . ' has endorsed ' . $businessName, $business)));
// Check if user earned new badge
// Get updated number of endorsements
$endorsementCntQuery = 'SELECT endorser FROM endorsement WHERE endorsee = ?';
$endorsements = prepare_and_execute($endorsementCntQuery, array($business));
$newEndorseCnt = $endorsements->rowCount();
$newBadge = false;
if ($curEndorseCnt < 5 && $newEndorseCnt >= 5) {
// Business moved from no badge to bronze badge
$newBadge = 'bronze';
} else {
if ($curEndorseCnt < 10 && $newEndorseCnt >= 10) {
// Business moved from bronze badge to silver badge
$newBadge = 'silver';
prepare_and_execute($stmt, array($id, $replier, $reply));
// Get name of requester for notification
$userNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($replier), false);
if ($name != false) {
// Found name
$userName = $name[0];
$nameFound = true;
}
}
// Get email of post owner and title of post
$postDetailsQuery = 'SELECT title, postBusiness FROM forumpost WHERE id = ?;';
$detailsFound = false;
while (!$detailsFound) {
$details = select($postDetailsQuery, array($id), false);
if ($details != false) {
$postTitle = $details[0];
$business = $details[1];
$detailsFound = true;
}
}
if ($business != $replier) {
// Check post author didn't reply to post
$parameters = array($replier);
// Push notification to requestee
push_notification($business, 'New post reply', $userName . " replied to your forum post '" . $postTitle . "'", 'BusinessPage', json_encode($parameters), $replier);
}
echo '1';
}
// Insert alliance row
prepare_and_execute($insertStmt, array($user, $business));
// Get name of requester for notification
$userNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($user), false);
if ($name != false) {
// Found name
$userName = $name[0];
$nameFound = true;
}
}
$parameters = array($user);
// Get name of requestee for notification
$businessNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($business), false);
if ($name != false) {
// Found name
$businessName = $name[0];
$nameFound = true;
}
}
// Push notification to requestee
push_notification($business, 'Alliance confirmed', $userName . ' accepted your Alliance request', 'BusinessPage', json_encode($parameters), $user);
// Create activity for new alliance
create_activity($user, 'alliance', json_encode(array($userName . ' has formed an alliance with ' . $businessName, $business)));
echo '1';
}
<?php
// Check mandatory values are set
if (isset($_GET['business']) && $_GET['business'] != '' && (isset($_GET['user']) && $_GET['user'] != '')) {
require dirname(__FILE__) . '/../../pdo.inc';
$business = $_GET['business'];
$user = $_GET['user'];
// Statement to insert alliance request row into database
$stmt = 'INSERT INTO alliancerequest (requester,requestee,ignored) VALUES (?,?,0);';
// Insert alliance request
prepare_and_execute($stmt, array($user, $business));
// Get name of requester for notification
$userNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($userNameQuery, array($user), false);
if ($name != false) {
// Found name
$userName = $name[0];
$nameFound = true;
}
}
$parameters = array($user);
// Push notification to requestee
push_notification($business, 'Alliance request', $userName . ' requests an Alliance with your businesss', 'BusinessPage', json_encode($parameters), $user);
echo '1';
}
<?php
// Check mandatory values are set
if (isset($_GET['send']) && $_GET['send'] != '' && (isset($_GET['receive']) && $_GET['receive'] != '') && (isset($_GET['message']) && $_GET['message'] != '')) {
require dirname(__FILE__) . '/../../pdo.inc';
$send = $_GET['send'];
$receive = $_GET['receive'];
$message = $_GET['message'];
// Statement to insert message row into database
$stmt = 'INSERT INTO message (send,receive,message) VALUES (?,?,?);';
// Insert message row
prepare_and_execute($stmt, array($send, $receive, $message));
// Get name of sender for notification
$sendNameQuery = 'SELECT name FROM business WHERE userEmail = ?';
$nameFound = false;
while (!$nameFound) {
$name = select($sendNameQuery, array($send), false);
if ($name != false) {
// Found name
$sendName = $name[0];
$nameFound = true;
}
}
$parameters = array($sendName, $send);
push_notification($receive, 'New message', $sendName . ' sent you a new message', 'MessagePage', json_encode($parameters), $send);
echo '1';
}
