BuddyPress.org

Let’s assume that we want to install a notification for when a user comments on a photo:

function add_photo_comment()
{
// Process the photo comment

if ($comment)
{
// Insert the photo comment

$msg = “Success! The comment was added to the user’s photo”;

// BEGIN ARROWCHAT NOTIFICATION
$sql = “INSERT INTO arrowchat_notifications (to_id, author_id, author_name, type, alert_time)
VALUES (‘”.$to_id.”‘, ‘”.$author_id.”‘, ‘”.$author_name.”‘, ‘1’, ‘”.time().”‘)”;
mysql_query($sql);
// END ARROWCHAT NOTIFICATION
}
else
{
$error = “You did not enter a comment”;
}
}
As you can see from the example above, we only inserted the notification into the database where the action occured, which in this case, was adding a photo comment. If you want to add a notification for private messages, you would insert the ArrowChat mySQL code where a user has successfully sent a private message.

Sample MySQL Insert Code
Here is the way a proper notification should be entered into the database:

$sql = “INSERT INTO arrowchat_notifications (to_id, author_id, author_name, type, alert_time, misc1, misc2, misc3)
VALUES (‘”.$to_id.”‘, ‘”.$author_id.”‘, ‘”.$author_name.”‘, ‘1’, ‘”.time().”‘, ”, ”, ”)”;
mysql_query($sql);
The above is a basic template that you should use for inserting notifications. Some modification might be necessary.

to_id – (int) The user ID of the user that should receive the notification.
author_id – (int) The user ID of the user that sent the notification. Can be left blank if none.
author_name – (varchar) The name of the user that sent the notification. Can be left blank if none.
type – (int) The type of notification. You need to create a notification markup in the admin panel, and then insert the number of that markup as the type.
alert_time – (int) The unix time of when the notification was sent.
misc1 – (varchar) A miscellaneous field that can be used for anything or left blank.
misc2 – (varchar) A miscellaneous field that can be used for anything or left blank.
misc3 – (varchar) A miscellaneous field that can be used for anything or left blank.

The Notification Markup and Type Number

If you need to install a notification that is not already included in the default ArrowChat installation, you can add one by clicking Notifications under the Manage menu. Add a name and the HTML markup that should be used when receiving the notification. You can look at the notifications already installed for reference.