412 lines
14 KiB
PHP
412 lines
14 KiB
PHP
<?php
|
|
/* $Id: class_notify.php 116 2009-03-14 20:21:24Z john $ */
|
|
|
|
// THIS CLASS IS USED TO OUTPUT AND UPDATE NOTIFICATIONS
|
|
// METHODS IN THIS CLASS:
|
|
// notify_add()
|
|
// notify_summary()
|
|
|
|
class se_notify
|
|
{
|
|
// THIS METHOD ADDS A NEW NOTIFICATION
|
|
// INPUT: $user_id REPRESENTING THE USER ID OF THE USER WHO COMMITTED THE ACTION
|
|
// $notifytype REPRESENTING THE ID OF THE TYPE OF NOTIFICATION
|
|
// $notify_object_id REPRESENTING THE ID OF THE OBJECT (FOR LATER DELETING PURPOSES)
|
|
// $urlvars (OPTIONAL) REPRESENTING VARS TO USE IN THE NOTIFYTYPE URL
|
|
// $replace (OPTIONAL) REPRESENTING AN ARRAY OF VALUES FOR THE NOTIFICATION TEXT STRING (MUST CORRESPOND TO NOTIFYTYPE_VARS)
|
|
// $update (OPTIONAL) REPRESENTING WHETHER TO INSERT A NEW NOTIFICATION IF AN OLD ONE WITH THE SAME OBJECT ID EXISTS
|
|
|
|
function notify_add($user_id, $notifytype, $notify_object_id = 0, $urlvars = Array(), $replace = Array(), $update = FALSE, $objectid="")
|
|
{
|
|
global $database, $setting;
|
|
|
|
$to_user = new SEUser(array($user_id));
|
|
if($to_user->usersetting_info["notify_".$notifytype]==0||$to_user->usersetting_info["notify_".$notifytype]==""){
|
|
|
|
return;}
|
|
|
|
// GET CURRENT DATE
|
|
$nowdate = time();
|
|
//send_admin("sean@bateworld.com", "RR", "INSERT INTO bateworldcom_wall.admin_log SET user_id='".$user_id."', time='".time()."', action='User Notification Added: {$notifytype}'");
|
|
|
|
|
|
/* $action_media="";
|
|
$query=$database->database_query("SELECT user_username FROM se_users WHERE user_id='".$database->database_real_escape_string($user_id)."'");
|
|
if($database->database_num_rows($query)>0){
|
|
|
|
//$timesince=$datetime->time_since($action["action_date"]);
|
|
//sprintf(SE_Language::get($action["action_text"]), $row["user_username"], $row["user_username"]);
|
|
//media
|
|
}*/
|
|
|
|
//$txt=sprintf(SE_Language::get($action["action_text"]), $user->user_info["user_username"], $row["user_username"]);
|
|
//send_admin("sean@bateworld.com", "AAA", "INSERT INTO bateworldcom_wall.admin_log SET user_id='".$user_id."', time='".time()."', action='User Notification Added: ".$database->database_real_escape_string($txt)."'");
|
|
//$database->database_query("INSERT INTO bateworldcom_wall.admin_log SET user_id='".$user_id."', time='".time()."', action='User Notification Added: ".$database->database_real_escape_string($txt)."'");
|
|
// GET NOTIFY TYPE
|
|
$notifytype_query = $database->database_query("SELECT * FROM se_notifytypes WHERE notifytype_name='{$notifytype}'");
|
|
if($database->database_num_rows($notifytype_query) != 1) {
|
|
|
|
return false; }
|
|
|
|
|
|
$notifytype = $database->database_fetch_assoc($notifytype_query);
|
|
|
|
|
|
|
|
// SERIALIZE APPROPRIATE VARS
|
|
$notify_text = serialize($replace);
|
|
$notify_urlvars = serialize($urlvars);
|
|
|
|
|
|
|
|
// RETRIEVE OLD NOTIFICATION IF UPDATE NECESSARY
|
|
$insert = TRUE;
|
|
if($update)
|
|
{
|
|
|
|
$old_notify = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_notifys FROM se_notifys WHERE notify_user_id='{$user_id}' AND notify_notifytype_id='{$notifytype['notifytype_id']}' AND notify_object_id='{$notify_object_id}'"));
|
|
if( $old_notify['total_notifys'] ){$insert = FALSE; }
|
|
|
|
}
|
|
// INSERT DATA
|
|
if($insert)
|
|
{
|
|
|
|
|
|
|
|
$database->database_query("
|
|
INSERT INTO se_notifys(
|
|
notify_user_id,
|
|
notify_notifytype_id,
|
|
notify_object_id,
|
|
notify_urlvars,
|
|
notify_text
|
|
) VALUES (
|
|
'{$user_id}',
|
|
'".$database->database_real_escape_string($notifytype['notifytype_id'])."',
|
|
'".$database->database_real_escape_string($notify_object_id)."',
|
|
'".$database->database_real_escape_string($notify_urlvars)."',
|
|
'".$database->database_real_escape_string($notify_text)."'
|
|
)
|
|
");
|
|
|
|
|
|
}
|
|
|
|
$database->database_query("
|
|
INSERT INTO bateworldcom_wall.notifications(
|
|
userid,
|
|
actiontype,
|
|
date,
|
|
userfrom,
|
|
objectid2, objectowner_id
|
|
) VALUES (
|
|
'{$user_id}',
|
|
'".$database->database_real_escape_string($notifytype['notifytype_id'])."',
|
|
'".time()."',
|
|
'".$user->user_info["user_id"]."',
|
|
'".$database->database_real_escape_string($objectid)."', '".$database->database_real_escape_string($notify_object_id)."'
|
|
|
|
)
|
|
");
|
|
|
|
$database->database_query("UPDATE se_users SET user_hasnotifys=1 WHERE user_id='{$user_id}' LIMIT 1");
|
|
|
|
// RETURN NOTIFY TYPE
|
|
return $notifytype;
|
|
}
|
|
|
|
function notify_add_new($user_id, $notifytype, $notify_object_id = 0, $urlvars = Array(), $replace = Array(), $update = FALSE, $objectid="")
|
|
{
|
|
global $database, $setting, $user;
|
|
|
|
$to_user = new SEUser(array($user_id));
|
|
if($to_user->usersetting_info["notify_".$notifytype]==0||$to_user->usersetting_info["notify_".$notifytype]==""){
|
|
|
|
return;}
|
|
|
|
// GET CURRENT DATE
|
|
$nowdate = time();
|
|
|
|
// GET NOTIFY TYPE
|
|
$notifytype_query = $database->database_query("SELECT * FROM se_notifytypes WHERE notifytype_name='{$notifytype}'");
|
|
if($database->database_num_rows($notifytype_query) != 1) {
|
|
|
|
return false; }
|
|
|
|
|
|
$notifytype = $database->database_fetch_assoc($notifytype_query);
|
|
|
|
|
|
|
|
// SERIALIZE APPROPRIATE VARS
|
|
$notify_text = serialize($replace);
|
|
$notify_urlvars = serialize($urlvars);
|
|
|
|
// RETRIEVE OLD NOTIFICATION IF UPDATE NECESSARY
|
|
$insert = TRUE;
|
|
if($update)
|
|
{
|
|
|
|
$old_notify = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_notifys FROM se_notifys WHERE notify_user_id='{$user_id}' AND notify_notifytype_id='{$notifytype['notifytype_id']}' AND notify_object_id='{$notify_object_id}'"));
|
|
if( $old_notify['total_notifys'] ){$insert = FALSE; }
|
|
|
|
}
|
|
|
|
// INSERT DATA
|
|
if($insert)
|
|
{
|
|
|
|
$database->database_query("
|
|
INSERT INTO bateworldcom_wall.notifications(
|
|
userid,
|
|
actiontype,
|
|
date,
|
|
userfrom,
|
|
objectid2, objectowner_id
|
|
) VALUES (
|
|
'{$user_id}',
|
|
'{$notifytype['notifytype_id']}',
|
|
'".time()."',
|
|
'".$user->user_info["user_id"]."',
|
|
'{$objectid}', '{$notify_object_id}'
|
|
|
|
)
|
|
");
|
|
|
|
|
|
}
|
|
|
|
$database->database_query("UPDATE se_users SET user_hasnotifys=1 WHERE user_id='{$user_id}' LIMIT 1");
|
|
|
|
// RETURN NOTIFY TYPE
|
|
return $notifytype;
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
// THIS METHOD DELETES A NOTIFICATION
|
|
|
|
function notify_delete($notifytype_id, $notify_grouped)
|
|
{
|
|
global $user, $database;
|
|
|
|
if( !$notifytype_id || !$user->user_exists )
|
|
return FALSE;
|
|
|
|
// BUILD QUERY
|
|
//$delete_query = "DELETE FROM se_notifys WHERE notify_notifytype_id='{$notifytype_id}' AND notify_user_id='{$user->user_info['user_id']}'";
|
|
|
|
$delete_query = "UPDATE se_notifys SET isread=1 WHERE notify_notifytype_id='{$notifytype_id}' AND notify_user_id='{$user->user_info['user_id']}'";
|
|
if( $notify_grouped ) $delete_query .= " AND notify_object_id='{$notify_grouped}'";
|
|
|
|
// DELETE ACTION (IF OWNED BY LOGGED-IN USER)
|
|
$database->database_query($delete_query);
|
|
|
|
// UPDATE user notify cache
|
|
$resource = $database->database_query("SELECT NULL FROM se_notifys WHERE notify_user_id='{$user->user_info['user_id']}' LIMIT 1");
|
|
$has_notifys = $database->database_num_rows($resource);
|
|
|
|
if( $has_notifys != $user->user_info['user_hasnotifys'] )
|
|
{
|
|
$has_notifys = ( $user->user_info['user_hasnotifys'] ? '1' : '0' );
|
|
$database->database_query("UPDATE se_users SET user_hasnotifys={$has_notifys} WHERE user_id='{$user->user_info['user_id']}' LIMIT 1");
|
|
}
|
|
|
|
return TRUE;
|
|
}
|
|
|
|
// END notify_delete() METHOD
|
|
|
|
|
|
|
|
|
|
|
|
// THIS METHOD DISPLAYS A SUMMARY OF NOTIFICATIONS RELATING TO A SPECIFIC USER
|
|
// INPUT:
|
|
// OUTPUT: SUMMARY OF NOTIFICATIONS FOR THAT USER
|
|
|
|
function notify_summary()
|
|
{
|
|
global $database, $user;
|
|
|
|
$total_notifications = 0;
|
|
$notify_array = array();
|
|
|
|
// CHECK THAT USER EXISTS
|
|
if( is_object($user) && $user->user_exists && $user->user_info['user_hasnotifys'] )
|
|
{
|
|
// BUILD NOTIFICATION QUERY
|
|
$notify_query = "
|
|
(
|
|
SELECT
|
|
'0' AS notify_grouped,
|
|
count(se_notifys.notify_id) AS total_notifications,
|
|
se_notifytypes.notifytype_id,
|
|
se_notifytypes.notifytype_desc,
|
|
se_notifytypes.notifytype_icon,
|
|
se_notifytypes.icon,
|
|
se_notifytypes.notifytype_url,
|
|
se_notifys.notify_urlvars,
|
|
se_notifys.notify_text
|
|
FROM se_notifys
|
|
LEFT JOIN se_notifytypes
|
|
ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id
|
|
WHERE
|
|
notify_user_id='{$user->user_info['user_id']}'
|
|
AND
|
|
notifytype_group=1 AND isread=0
|
|
GROUP BY se_notifys.notify_notifytype_id
|
|
) UNION ALL (
|
|
SELECT
|
|
se_notifys.notify_object_id AS notify_grouped,
|
|
count(se_notifys.notify_id) AS total_notifications,
|
|
se_notifytypes.notifytype_id,
|
|
se_notifytypes.notifytype_desc,
|
|
se_notifytypes.notifytype_icon,
|
|
se_notifytypes.icon,
|
|
se_notifytypes.notifytype_url,
|
|
se_notifys.notify_urlvars,
|
|
se_notifys.notify_text
|
|
FROM se_notifys
|
|
LEFT JOIN se_notifytypes
|
|
ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id
|
|
WHERE
|
|
notify_user_id='{$user->user_info['user_id']}'
|
|
AND
|
|
notifytype_group=0 AND isread=0
|
|
GROUP BY se_notifys.notify_notifytype_id, se_notifys.notify_text
|
|
"//GROUP BY se_notifys.notify_notifytype_id, se_notifys.notify_object_id
|
|
.")
|
|
";
|
|
|
|
// GET NOTIFICATIONS
|
|
$notifys = $database->database_query($notify_query);
|
|
while( $notify = $database->database_fetch_assoc($notifys) )
|
|
{
|
|
// REGISTER PRELOADED TEXT
|
|
SE_Language::_preload($notify['notifytype_desc']);
|
|
|
|
// GET URL VARS
|
|
$urlvars = unserialize($notify['notify_urlvars']);
|
|
$notify_url = vsprintf($notify['notifytype_url'], $urlvars);
|
|
|
|
// GET DESC TEXT VARS
|
|
$notify_text = unserialize($notify['notify_text']);
|
|
|
|
// ADD THIS NOTIFICATION TO OUTPUT ARRAY
|
|
$total_notifications += $notify['total_notifications'];
|
|
$notify_array[] = Array(
|
|
'notifytype_id' => $notify['notifytype_id'],
|
|
'notify_grouped' => $notify['notify_grouped'],
|
|
'notify_icon' => $notify['notifytype_icon'],
|
|
'icon' => $notify['icon'],
|
|
'notify_url' => $notify_url,
|
|
'notify_desc' => $notify['notifytype_desc'],
|
|
'notify_text' => $notify_text,
|
|
'notify_total' => $notify['total_notifications']
|
|
);
|
|
}
|
|
}
|
|
|
|
// RETURN LIST OF NOTIFICATIONS
|
|
return array(
|
|
'total' => (int) $total_notifications,
|
|
'total_grouped' => (int) count($notify_array),
|
|
'notifys' => $notify_array
|
|
);
|
|
}
|
|
|
|
function notify_summary_old()
|
|
{
|
|
global $database, $user;
|
|
|
|
$total_notifications = 0;
|
|
$notify_array = array();
|
|
|
|
// CHECK THAT USER EXISTS
|
|
if( is_object($user) && $user->user_exists && $user->user_info['user_hasnotifys'] )
|
|
{
|
|
// BUILD NOTIFICATION QUERY
|
|
$notify_query = "
|
|
(
|
|
SELECT
|
|
'0' AS notify_grouped,
|
|
count(se_notifys.notify_id) AS total_notifications,
|
|
se_notifytypes.notifytype_id,
|
|
se_notifytypes.notifytype_desc,
|
|
se_notifytypes.notifytype_icon,
|
|
se_notifytypes.notifytype_url,
|
|
se_notifys.notify_urlvars,
|
|
se_notifys.notify_text
|
|
FROM se_notifys
|
|
LEFT JOIN se_notifytypes
|
|
ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id
|
|
WHERE
|
|
notify_user_id='{$user->user_info['user_id']}'
|
|
AND
|
|
notifytype_group=1
|
|
GROUP BY se_notifys.notify_notifytype_id
|
|
) UNION ALL (
|
|
SELECT
|
|
se_notifys.notify_object_id AS notify_grouped,
|
|
count(se_notifys.notify_id) AS total_notifications,
|
|
se_notifytypes.notifytype_id,
|
|
se_notifytypes.notifytype_desc,
|
|
se_notifytypes.notifytype_icon,
|
|
se_notifytypes.notifytype_url,
|
|
se_notifys.notify_urlvars,
|
|
se_notifys.notify_text
|
|
FROM se_notifys
|
|
LEFT JOIN se_notifytypes
|
|
ON se_notifys.notify_notifytype_id=se_notifytypes.notifytype_id
|
|
WHERE
|
|
notify_user_id='{$user->user_info['user_id']}'
|
|
AND
|
|
notifytype_group=0 GROUP BY se_notifys.notify_notifytype_id, se_notifys.notify_object_id
|
|
|
|
"//GROUP BY se_notifys.notify_notifytype_id, se_notifys.notify_text
|
|
.")
|
|
";
|
|
|
|
// GET NOTIFICATIONS
|
|
$notifys = $database->database_query($notify_query);
|
|
while( $notify = $database->database_fetch_assoc($notifys) )
|
|
{
|
|
// REGISTER PRELOADED TEXT
|
|
SE_Language::_preload($notify['notifytype_desc']);
|
|
|
|
// GET URL VARS
|
|
$urlvars = unserialize($notify['notify_urlvars']);
|
|
$notify_url = vsprintf($notify['notifytype_url'], $urlvars);
|
|
|
|
// GET DESC TEXT VARS
|
|
$notify_text = unserialize($notify['notify_text']);
|
|
|
|
// ADD THIS NOTIFICATION TO OUTPUT ARRAY
|
|
$total_notifications += $notify['total_notifications'];
|
|
$notify_array[] = Array(
|
|
'notifytype_id' => $notify['notifytype_id'],
|
|
'notify_grouped' => $notify['notify_grouped'],
|
|
'notify_icon' => $notify['notifytype_icon'],
|
|
'notify_url' => $notify_url,
|
|
'notify_desc' => $notify['notifytype_desc'],
|
|
'notify_text' => $notify_text,
|
|
'notify_total' => $notify['total_notifications']
|
|
);
|
|
}
|
|
}
|
|
|
|
// RETURN LIST OF NOTIFICATIONS
|
|
return array(
|
|
'total' => (int) $total_notifications,
|
|
'total_grouped' => (int) count($notify_array),
|
|
'notifys' => $notify_array
|
|
);
|
|
}
|
|
|
|
// END notify_summary() METHOD
|
|
}
|
|
?>
|