} } $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'; }