Files
Testing/include/class_he_user_note.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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);
}
}
?>