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