124 lines
3.7 KiB
PHP
124 lines
3.7 KiB
PHP
|
|
<?php
|
||
|
|
|
||
|
|
/**
|
||
|
|
* @author Ermek
|
||
|
|
* @copyright Hire-Experts LLC
|
||
|
|
* @version UserNote 1.01
|
||
|
|
*/
|
||
|
|
|
||
|
|
class he_user_note
|
||
|
|
{
|
||
|
|
function save_note_admin( $viewer_id, $user_id, $note, $admin = false )
|
||
|
|
{
|
||
|
|
global $database, $admin;
|
||
|
|
if ( !$user_id || !$note || (!$viewer_id && !$admin) )
|
||
|
|
{
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
$database->database_query("INSERT INTO bateworldcom_wall.notes SET user_id='".$database->database_real_escape_string($user_id)."', admin_id='".$database->database_real_escape_string($admin->admin_info["admin_id"])."', note='".$database->database_real_escape_string($note)."', date='".time()."'");
|
||
|
|
|
||
|
|
/*he_database::placeholder( "INSERT INTO `se_he_user_note` (`viewer_id`, `user_id`, `note`)
|
||
|
|
VALUES(?, ?, '?')", $viewer_id, $user_id, $note );*/
|
||
|
|
|
||
|
|
$this->save_note( $viewer_id, $user_id, $note, $admin );
|
||
|
|
//he_database::query($query);
|
||
|
|
|
||
|
|
return nl2br($note);
|
||
|
|
}
|
||
|
|
function save_note( $viewer_id, $user_id, $note, $admin = false )
|
||
|
|
{
|
||
|
|
if ( !$user_id || !$note || (!$viewer_id && !$admin) )
|
||
|
|
{
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
$query = (new he_database())->placeholder("SELECT 1 FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $viewer_id, $user_id );
|
||
|
|
/*he_database::placeholder( "SELECT 1 FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $viewer_id, $user_id );
|
||
|
|
*/
|
||
|
|
//$note_exist = he_database::fetch_field($query);
|
||
|
|
$note_exist = (new he_database())->fetch_field($query);
|
||
|
|
if ( $note_exist )
|
||
|
|
{
|
||
|
|
|
||
|
|
|
||
|
|
$query = (new he_database())->placeholder("UPDATE `se_he_user_note` SET `note`='?'
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $note, $viewer_id, $user_id );
|
||
|
|
|
||
|
|
|
||
|
|
/*he_database::placeholder( "UPDATE `se_he_user_note` SET `note`='?'
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $note, $viewer_id, $user_id );*/
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$query = (new he_database())->placeholder( "INSERT INTO `se_he_user_note` (`viewer_id`, `user_id`, `note`)
|
||
|
|
VALUES(?, ?, '?')", $viewer_id, $user_id, $note );
|
||
|
|
|
||
|
|
/*he_database::placeholder( "INSERT INTO `se_he_user_note` (`viewer_id`, `user_id`, `note`)
|
||
|
|
VALUES(?, ?, '?')", $viewer_id, $user_id, $note );*/
|
||
|
|
}
|
||
|
|
|
||
|
|
he_database::query($query);
|
||
|
|
if(!$admin){wrapup("note",$user_id,$viewer_id);}
|
||
|
|
return nl2br($note);
|
||
|
|
}
|
||
|
|
|
||
|
|
function delete_note( $viewer_id, $user_id, $admin = false )
|
||
|
|
{
|
||
|
|
if ( !$user_id || (!$viewer_id && !$admin) )
|
||
|
|
{
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
$query = (new he_database())->placeholder( "DELETE FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $viewer_id, $user_id );
|
||
|
|
/*
|
||
|
|
he_database::placeholder( "DELETE FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $viewer_id, $user_id );*/
|
||
|
|
|
||
|
|
he_database::query($query);
|
||
|
|
|
||
|
|
return true;
|
||
|
|
}
|
||
|
|
|
||
|
|
function user_notes( $user_id )
|
||
|
|
{
|
||
|
|
if ( !$user_id )
|
||
|
|
{
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
$query = (new he_database())->placeholder( "SELECT * FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=?", $user_id );
|
||
|
|
/*
|
||
|
|
he_database::placeholder( "SELECT * FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=?", $user_id );*/
|
||
|
|
|
||
|
|
return (new he_database())->fetch_array($query, 'user_id');
|
||
|
|
|
||
|
|
//he_database::fetch_array($query, 'user_id');
|
||
|
|
}
|
||
|
|
|
||
|
|
function get_note( $viewer_id, $user_id, $admin = false )
|
||
|
|
{
|
||
|
|
if ( !$user_id || (!$viewer_id && !$admin) )
|
||
|
|
{
|
||
|
|
return false;
|
||
|
|
}
|
||
|
|
|
||
|
|
$query = (new he_database())->placeholder( "SELECT * FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $viewer_id, $user_id );
|
||
|
|
|
||
|
|
/* he_database::placeholder( "SELECT * FROM `se_he_user_note`
|
||
|
|
WHERE `viewer_id`=? AND `user_id`=?", $viewer_id, $user_id );
|
||
|
|
*/
|
||
|
|
return (new he_database())->fetch_row( $query);
|
||
|
|
|
||
|
|
// he_database::fetch_row($query);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
?>
|