summaryrefslogtreecommitdiff
path: root/html/app/views/simple/Model.php
diff options
context:
space:
mode:
Diffstat (limited to 'html/app/views/simple/Model.php')
-rw-r--r--html/app/views/simple/Model.php887
1 files changed, 0 insertions, 887 deletions
diff --git a/html/app/views/simple/Model.php b/html/app/views/simple/Model.php
deleted file mode 100644
index 6ea1e7d..0000000
--- a/html/app/views/simple/Model.php
+++ /dev/null
@@ -1,887 +0,0 @@
-<?php
-/** Wiki Model Class
- * -----------------------------------------------------------------------------
- *
- * + connects to the Wiki database; forwards SQL queries and returns data
- *
- * + forms data to be used in the application
- *
- * + implements some optimizations (data-caching)
- *
- * -----------------------------------------------------------------------------
- */
-class Wiki_Model
-{
-
- protected $pdo;
-
- protected $pdo_pythia;
-
- protected $user_id; // connected user-id
-
- protected $wiki_files_root = 'uploads/wiki/files'; // root path for wiki file attachments
-
-
- /** __construct
- *
- * Connects to the Wiki database
- *
- */
- public function __construct()
- {
- /// // Default
- /// $db = new Database();
- /// $this->pdo_pythia= $db->connect();
-
- /// // database for wiki
- /// $this->pdo = new PDO('mysql:unix_socket=/cloudsql/pythia-251711:europe-west4:pythia-db-eu;dbname=' . DB_DATABASE . ';charset=utf8', DB_USERNAME, DB_PASSWORD, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC));
- /// $this->user_id = $_SESSION['user_session'];
-
- $this->pdo = $GLOBALS['DB_con'];
-
- }
-
-
- /** Close Instance
- * --------------------------------------------------- (probably not needed)
- */
- public function close()
- {
- // Default
- // $this->pdo=Database::disconnect();
- }
-
-
-
- ## -------------------------------------------------------------------------
- ##
- ## CATEGORY METHODS
- ##
- ## -------------------------------------------------------------------------
-
-
- /** get all categories
- *
- * raw table data (simplest SELECT)
- *
- */
- public function get_categories()
- {
- $sql = "SELECT * FROM wiki_category ORDER BY title";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute();
-
- return $stmt->fetchAll(PDO::FETCH_ASSOC);
- }
-
-
- /** constuct a category_tree
- *
- * returns a tree representation of the categories
- *
- * NOTE:
- * category_tree() is an expensive method;
- * it calls 2 other methods implementing recursive algorithms
- * thus it uses many sources to run (particularly RAM).
- * Caching the result is strogly recommended.
- *
- */
- public function category_tree()
- {
- $categories = $this->get_categories(); // get all categories
-
- $tree = $this->to_tree($categories); // format to a tree
-
- $tree_wParents = $this->tree_parents($tree); // add parents section for each tree-node
-
- return $tree_wParents;
- }
-
-
- /** to_tree
- *
- * constructs a tree from raw-table data;
- * this is a private method and uses a recursive algorithm
- *
- * @param $dataset (array): flar array of records with id/parent-id pairs
- * @return $root (array): id of root category
- *
- * (**) each node has 2 parts:
- * .... .. rec : all record attributes/data as passed into $dataset
- * .... .. childs : array of (children) nodes
- */
- public function to_tree($dataset, $root = 0)
- {
- $return = [];
-
- // loop data ; search for direct children of root
- foreach($dataset as $key => $rec) {
-
- $child = $rec['id'];
- $parent = $rec['parent_id'];
-
- if ($parent == $root) { // a direct child is found
-
- unset($dataset[$key]); // remove item (no need to traverse again)
-
- // Append the child into result array ; parse its children
- $return[] = [
- 'rec' => [
- 'id' => $rec['id'],
- 'title' => $rec['title'],
- 'parent' => $rec['parent_id']
- ],
- 'childs' => $this->to_tree($dataset, $child) // recursively
- ];
- }
- }
- return empty($return) ? [] : $return;
- }
-
-
- /** tree_parents
- *
- * adds a section to each tree node with all parents of each node
- *
- * @param $tree (array) : nodes array (each node has `rec` and `childs` sections )
- * @param $parents (array); DO NOT SET IT (takes values automaticaly)
- * @return array of nodes with an extra node[parents] section
- *
- */
- private function tree_parents($tree, $parents = [])
- {
- $tree_with_parents = [];
-
- foreach($tree as $key => $node) {
- // parents to be pushed for node's children
- $push_parents = $parents; // parents so far
- $push_parents[] = $node['rec']; // this record will be a new parent
-
- $tree_with_parents[$key] = [
- 'rec' => $node['rec'],
- 'parents' => $parents,
- 'childs' => ($node['childs'] == [])
- ? []
- : $this->tree_parents($node['childs'], $push_parents)
- ];
- }
-
- return $tree_with_parents;
- }
-
-
- /** add_category()
- *
- * add new category
- *
- * @param $recuest (array): [ title => , parent_id => ]
- * @return true;
- *
- * TODO: catch database error -> return succes => false
- */
- public function add_category($request)
- {
- $sql = "INSERT INTO wiki_category (title, parent_id) VALUES (:title, :parent_id)";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([
- 'title' => $request['title'],
- 'parent_id' => $request['parent_id']
- ]);
- $inserted_id = $this->pdo->lastInsertId();
-
- return [ "success" => true, 'id' => $inserted_id ];
- }
-
-
- /** update_category()
- *
- * update an existing category
- *
- * @param $recuest (array): [ id => , title => , parent_id => ]
- * @return true;
- *
- * TODO: catch database error -> return false
- */
- public function update_category($request)
- {
- $sql = "UPDATE wiki_category SET title = :title, parent_id = :parent_id WHERE id = :id";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([
- 'title' => $request['title'],
- 'parent_id' => $request['parent_id'],
- 'id' => $request['id']
- ]); ;
-
- return true;
- }
-
-
-
- ## -------------------------------------------------------------------------
- ##
- ## POST (ARTICLE) METHODS
- ##
- ## -------------------------------------------------------------------------
-
-
- /** get_post
- *
- * get a certain post (given the post's `id`)
- *
- * @param $id (int)
- * @param $only_publised (bool): should the post be published? (default=true)
- */
- public function get_post($id, $only_published = true) {
-
- $where_clause = ($only_published) ? ' AND post.status = 1' : '';
-
- // depricated: $sql = "SELECT * FROM post WHERE id = :id {$where_clause}";
- // Select post
- // + inject tags json
- // TODO: + inject media
- // ---
- $sql = "SELECT wiki_post.*,
- ( SELECT CONCAT('[', GROUP_CONCAT(JSON_OBJECT('id', wiki_tag.id, 'name', wiki_tag.name)), ']')
- FROM wiki_tag
- WHERE wiki_tag.id IN ( SELECT tag_id FROM wiki_post_tags WHERE post_id = :id )
- ) AS tags_json,
- ( SELECT
- CONCAT('[', GROUP_CONCAT(JSON_OBJECT(
- 'id', wiki_media.id,
- 'title', wiki_media.title,
- 'type', wiki_media.type,
- 'path', wiki_media.path,
- 'reference', wiki_post_media.reference )),
- ']')
- FROM wiki_media
- LEFT JOIN wiki_post_media ON wiki_post_media.media_id = wiki_media.id
- WHERE wiki_post_media.post_id = :id
- ) AS medias_json
- FROM wiki_post
- WHERE wiki_post.deleted IS NULL AND wiki_post.id = :id";
-
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute(['id' => $id]);
-
- $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- return ($result == [])
- ? false // no result? false
- : $result[0]; // else return 1st record
- }
-
-
- /** add post
- *
- * insert post to database
- *
- * @param $data (array): an array with all post-properties
- * @return: an array with `status` (bool), `id` (int) given to post
- */
- public function add_post($data)
- {
- $post = [
- 'title' => $data['title'],
- 'category_id' => $data['category_id'],
- 'body' => $data['body'],
- 'intro' => $data['intro'],
- 'status' => $data['status'],
- 'userid' => $this->user_id
- ];
-
- $sql = "INSERT INTO wiki_post (`title`, category_id, `body`, intro, `status`, user_id)
- VALUES (:title, :category_id, :body, :intro, :status, :userid)";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute($post);
-
- $inserted_id = $this->pdo->lastInsertId();
-
- // create + link tags to the post
- // --- -- -- - - -
- if (isset($data['tags'])) { // existing tags...
- $this->set_post_tags($inserted_id, $data['tags']);
- }
- if (isset($data['new_tags'])) { // new tags...
- $this->create_tags_for_post($data['new_tags'], $inserted_id);
- }
-
- // set medias for post
- // --- -- -- - - -
- if (isset($data['media'])) { // new tags...
- $this->create_medias_for_post($data['media'], $inserted_id);
- }
-
- return [ "success" => true, 'id' => $inserted_id ];
- }
-
-
- /** update post
- *
- * update post record to database
- *
- * @param $data (array): an array with all post-properties
- */
- public function update_post($data)
- {
- $post = [
- 'id' => $data['id'],
- 'title' => $data['title'],
- 'category_id' => $data['category_id'],
- 'body' => $data['body'],
- 'intro' => $data['intro'],
- 'status' => $data['status']
- ];
- $sql = "UPDATE wiki_post
- SET `title` = :title, category_id = :category_id,
- `body` = :body, intro = :intro,
- `status` = :status
- WHERE id = :id";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute($post);
-
- // create + link tags to the post
- // --- -- -- - - -
- if (isset($data['tags'])) { // old tags...
- $this->set_post_tags($post['id'], $data['tags']);
- }
- if (isset($data['new_tags'])) { // new tags...
- $this->create_tags_for_post($data['new_tags'], $post['id']);
- }
-
- // set medias for post
- // --- -- -- - - -
- if (isset($data['media'])) {
- $this->remove_media_from_post($post['id']); // remove old
- $this->create_medias_for_post($data['media'], $post['id']); // re-create new
- }
-
- return true;
- }
-
-
- /** latest_published_posts
- *
- * latest PUBLISHED posts of a category (by category_id)
- *
- * TODO: handle sorting
- *
- * @param $category_id (int) ; if 0 then no category is specified
- * @param $limit (int) ; 0 = no limit
- * @param $fieldset (string): list of fields; default all = '*'
- */
- public function latest_published_posts($category_id, $limit = 10, $fieldset = '*')
- {
-
- $where_clause = ($category_id)
- ? " AND category_id = :categoryid "
- : " ";
-
- $limit_clause = ($limit)
- ? " LIMIT ". $limit
- : "";
-
- $sql = "SELECT {$fieldset} FROM wiki_post
- WHERE `status` = 1 AND deleted IS NULL ". $where_clause
- ." ORDER BY creation_date DESC ". $limit_clause;
-
- $stmt = $this->pdo->prepare($sql);
-
- if (!$category_id) {
- $stmt->execute();
-
- } else {
- $stmt->execute(['categoryid' => $category_id]);
- }
-
- $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- return ($result === null)
- ? false // no result? return false
- : $result; // else return results
- }
-
-
- /** delete post
- *
- * NOTE:
- * post is *marked* as deleted;
- * a cron-job will make the actual deletions in a later time
- *
- * @param $id (int): post id
- */
- public function delete_post($id)
- {
- if (intval($id) == 0) { // no valid id?
- return ["success" => false]; // return false
- }
-
- $sql = "UPDATE wiki_post SET deleted = 1 WHERE id = :id";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute(['id' => $id]);
-
- return ["success" => true];
- }
-
-
- /** all posts
- * published + unpublished ; any category ; no limit
- *
- * @param $filedset (string): list of fields; default all = '*'
- */
- public function all_posts($fieldset = '*')
- {
-
- $sql = "SELECT {$fieldset} FROM wiki_post WHERE deleted IS NULL";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute();
-
- $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- return ($result === null)
- ? false // no result? return false
- : $result; // else return results
- }
-
-
-
- ## -------------------------------------------------------------------------
- ##
- ## MEDIA METHODS
- ##
- ## -------------------------------------------------------------------------
-
- /** create media for post
- *
- * links post to each media-file of the media `id`s array
- * @param $media (array): a list of media-file `id`s
- * @param $post_id (int)
- */
- private function create_medias_for_post( $medias, $post_id )
- {
- foreach($medias as $medi_string) {
- $medi = explode(';', $medi_string); // [0]: media_id, [1]: reference
- $this->link_media_to_post($medi[0], $post_id, $medi[1]); // link to post
- }
- return true;
- }
-
- /** remove_media_from_post
- *
- * remove all media records/attachments from post
- *
- * @param $post_id (int)
- */
- private function remove_media_from_post( $post_id )
- {
- $sql = "DELETE FROM wiki_post_media WHERE post_id = :postid";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute(['postid' => $post_id]);
- return true;
- }
-
- /** link one media-file to a specific post
- *
- * NOTE:
- * the method does not check if media is linked already
- * so be sure that the pair of (media_id,post_id) not exist
- *
- * @param $media_id (int)
- * @param $post_id (int)
- * @param $reference (int|bit)
- */
- private function link_media_to_post( $media_id, $post_id, $reference )
- {
- $sql = "INSERT INTO wiki_post_media (post_id, media_id, reference) VALUES (:postid, :mediaid, :reference)";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([
- 'postid' => $post_id,
- 'mediaid' => $media_id,
- 'reference' => $reference
- ]);
- return true;
- }
-
-
-
-
-
- ## -------------------------------------------------------------------------
- ##
- ## FILE METHODS
- ##
- ## -------------------------------------------------------------------------
-
-
- /** upload_file_to_folder
- *
- * upload the file to CloudStorage
- * in a virtual folder
- *
- * @param $folder
- */
- public function upload_file_to_folder($folder)
- {
- // Checks before uploading the file
- ////////////////////////////////////////////////////////////////////////
-
- // ** 1: file is upladed to temporary folder ---------------------------
- if (! is_uploaded_file($_FILES['file']['tmp_name'])) {
- return false; // bye!
- }
-
- // ** 2: File belongs to the allowed MIME types ------------------------
- $allowed_file_types = array(
- 'application/pdf',
- 'image/png', 'image/jpeg',
- 'application/msword', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
- 'application/vnd.ms-excel', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
- );
- // Recomended MIME type checking via mime_content_type():
- $mime_type = mime_content_type($_FILES['file']['tmp_name']);
- if (! in_array($mime_type, $allowed_file_types)) { // File type NOT allowed ...
- return false; // bye!
- }
-
- $file_name = $_FILES['file']['name'];
- $file_type = $_FILES['file']['type']; // do not take it for granted
- $file_size = $_FILES['file']['size'];
- $file_tmp = $_FILES['file']['tmp_name'];
-
- $bare_name = pathinfo($file_name, PATHINFO_FILENAME);
- $file_ext = pathinfo($file_name, PATHINFO_EXTENSION);
-
-
- // ** 3: filename or size checks may be added --------------------------
- if ($file_name == "") {
- return false; // bye!
- }
-
- // READY to finaly save/upload the file to CDN /////////////////////////
-
- $store_filename = $folder .'/'. strtolower($this->clear_file_name($bare_name) .'.'. $file_ext);
-
- $file_destination = $this->wiki_files_root .'/'. $store_filename;
-
- // depricated; it is autoloaded include_once CLOUDSTORAGE;
- $cloudstorage = new CloudStorage();
-
- if ($cloudstorage->upload_object($file_destination, $file_tmp)) {
-
- return [
- 'path' => $file_destination,
- 'type' => $mime_type
- ];
-
- } else { return false; }
- }
-
- /** uc_split
- *
- * this is an mb_str_split polyfill because
- * pythia uses a php version < 7.4
- *
- * CHECK: https://www.php.net/manual/en/function.mb-str-split.php
- */
- private function uc_split($string, $length = 1, $encoding = 'UTF-8' )
- {
- if(!empty($string)){
- $split = array();
- $mb_strlen = mb_strlen($string,$encoding);
- for($pi = 0; $pi < $mb_strlen; $pi += $length){
- $substr = mb_substr($string, $pi,$length,$encoding);
- if( !empty($substr)) {
- $split[] = $substr;
- }
- }
- }
- return $split;
- }
-
- /** clear_file_name
- * replace greek characters and strip symbols
- */
- private function clear_file_name($str)
- {
- $el = $this->uc_split("ΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθικλμνξοπρστυφχψωάέήίόύώϊϋς ");
- $en = str_split( "ABGDEZHUIKLMNJOPRSTYFXCVabgdezhuiklmnjoprstyfxcvaehioyviys-");
- $strip = str_split("!@#$%^&*()+~`[]{};'/<>?=\"");
-
- return str_replace($strip, '', str_replace($el, $en, $str));
- }
-
-
- /** define_media
- *
- * create a record in media table
- *
- * @param $data
- * @return id (int): id of created media record
- */
- public function define_media($data)
- {
- $sql = "INSERT INTO wiki_media (`title`, `type`, `path`)
- VALUES (:title, :mimetype, :filepath)";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([
- 'title' => $data['title'],
- 'mimetype' => $data['type'],
- 'filepath' => $data['path']
- ]);
- $inserted_id = $this->pdo->lastInsertId();
-
- return $inserted_id;
- }
-
-
- ## -------------------------------------------------------------------------
- ##
- ## TAG METHODS
- ##
- ## -------------------------------------------------------------------------
-
- /** all tags
- *
- * @return: (array) all tags
- */
- public function all_tags()
- {
- $sql = "SELECT * FROM wiki_tag";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute();
-
- $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- return ($result === null)
- ? false // no result? return false
- : $result; // else return results
- }
-
-
- /** create_tag
- *
- * @param $tag (string): the tag label
- * @return : id (int) given to tag
- */
- public function create_tag($tag)
- {
- $sql = "INSERT INTO wiki_tag (`name`) VALUES (:label)";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([ 'label' => $tag ]);
-
- $tag_id = $this->pdo->lastInsertId();
-
- return $tag_id;
- }
-
- /** destroy_tag
- *
- * @param $tag_id (int)
- */
- public function destroy_tag($id)
- {
- // remove all post-links to this tag
- $clean_posts = "DELETE FROM wiki_post_tags WHERE tag_id = :tagid";
- $clean = $this->pdo->prepare($clean_posts);
- $clean->execute([ 'tagid' => $id ]);
-
- // remove tag from tags table
- $sql = "DELETE FROM wiki_tag WHERE id = :tagid";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([ 'tagid' => $id ]);
-
- return true;
- }
-
- /** posts_of_tag
- *
- * return posts linked to the specified tag (by tag-id)
- *
- * @param tag_id
- * @param limit
- * @param fieldset (string): list of post field-names separated with a comma (,)
- * @param only_published (bool)
- */
- public function posts_of_tag($tag_id, $limit = 0, $fieldset = '*', $only_published = true)
- {
- // format post field-names for SELECT SQL
- // post_fields will be somethning like... `post.*`
- // or... `post.id, post.title, post.into`
- // --- -- -- - - -
- $fields = explode(',', str_replace(' ', '', $fieldset));
- $fields_arr = [];
- foreach($fields as $f) { $fields_arr[] = 'wiki_post.'. $f; }
- $post_fields = implode(', ', $fields_arr);
-
- $limit_clause = ($limit)
- ? " LIMIT ". $limit
- : "";
-
- $filter = ($only_published)
- ? " AND post.status = 1 "
- : "";
-
- $sql = "SELECT {$post_fields} FROM wiki_post
- LEFT JOIN wiki_post_tags ON wiki_post_tags.post_id = wiki_post.id
- LEFT JOIN wiki_tag ON wiki_tag.id = wiki_post_tags.tag_id
- WHERE wiki_post.deleted IS NULL AND wiki_tag.id = :tagid {$filter}
- {$limit_clause}";
-
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute(['tagid' => $tag_id]);
-
- $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
-
- return $result;
- }
-
-
- /** tag_name
- * return tag name (name = label / title / text)
- * by tag_id
- *
- * @param $id (int): given tag-id
- * @return (string)
- */
- public function tag_name($id) {
- $sql = "SELECT `name` FROM wiki_tag WHERE id = :id LIMIT 1";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute(['id' => $id]);
-
- $result = $stmt->fetch();
-
- return $result['name'];
-
- }
-
- /** set_tags_to_post()
- *
- * REMOVE OLD tags from post;
- * then SET NEW tags
- *
- * NOTE:
- * make sure that any old tags are removed from post;
- * new tags should not be linked in a later cycle
- *
- */
- private function set_post_tags($post_id, $tags)
- {
- $this->remove_tags_from_post($post_id); // remobve any old tags
-
- foreach($tags as $tag) { // set each tag to post
- $this->link_tag_to_post($tag, $post_id);
- }
- }
-
- /** remove_tags_from_post
- *
- * @param $post_id (int)
- */
- private function remove_tags_from_post( $post_id )
- {
- $sql = "DELETE FROM wiki_post_tags WHERE post_id = :postid";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute(['postid' => $post_id]);
- return true;
- }
-
- /** set one tag to a specific post
- *
- * NOTE:
- * the method does not check if tag is linked already
- *
- */
- private function link_tag_to_post( $tag_id, $post_id )
- {
- $sql = "INSERT INTO wiki_post_tags (post_id, tag_id) VALUES (:postid, :tagid)";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([
- 'postid' => $post_id,
- 'tagid' => $tag_id
- ]);
- return true;
- }
-
- /** create tags for post
- *
- * creates an array of tags; links post to each one;
- * @param $tags (array): a list of tags (labels/texts)
- * @param $post_id (int)
- */
- private function create_tags_for_post( $tags, $post_id )
- {
- foreach($tags as $tag) {
- $tag_id = $this->create_tag($tag); // create tag
- $this->link_tag_to_post($tag_id, $post_id); // link to post
- }
- return true;
- }
-
-
- public function tags_stats()
- {
- $sql = "SELECT tag.id, tag.name, COUNT(post_tags.post_id) as totals
- FROM wiki_tag
- LEFT JOIN wiki_post_tags ON wiki_post_tags.tag_id = wiki_tag.id
- GROUP BY wiki_tag.id";
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute();
-
- return $stmt->fetchAll(PDO::FETCH_ASSOC);
- }
-
-
- ## -------------------------------------------------------------------------
- ##
- ## USER METHODS
- ##
- ## -------------------------------------------------------------------------
-
- /** user_info
- *
- * no user is passed; user info are exrtacted from Session
- *
- */
- private function user_info()
- {
- $user = [];
- $keys = [
- 'user_session' => 'user',
- 'employee_id' => 'employee',
- 'store_id' => 'store',
- 'site_id' => 'site',
- 'unit_id' => 'unit',
- 'employee_rID' => 'rid'
- ];
-
- foreach($keys as $key => $attribute) {
- if (isset($_SESSION[$key]) && ($_SESSION[$key] != '')) {
- $user[$attribute] = $_SESSION[$key];
- }
- }
- return $wiki_user;
- }
-
-
- /** update post stats
- *
- */
- public function update_post_stats($post_id)
- {
-
- $user_id = $_SESSION['user_session']; // get user from session
-
- $sql = "INSERT INTO wiki_stats
- (post_id, user_id, views) VALUES (:post, :user, 1)
- ON DUPLICATE KEY UPDATE views = views + 1";
-
- $stmt = $this->pdo->prepare($sql);
- $stmt->execute([
- 'user' => $user_id,
- 'post' => $post_id
- ]);
-
- return true;
-
- }
-
-}
generated by cgit v1.2.3 (git 2.39.1) at 2026-09-22 13:27:42 +0000