include/labels.php

   1 <?php
   2         function label_find_id($label, $owner_uid) {
   3                 $result = db_query(
   4                         "SELECT id FROM ttrss_labels2 WHERE caption = '$label'
   5                                 AND owner_uid = '$owner_uid' LIMIT 1");
   6
   7                 if (db_num_rows($result) == 1) {
   8                         return db_fetch_result($result, 0, "id");
   9                 } else {
  10                         return 0;
  11                 }
  12         }
  13
  14         function label_find_caption($label, $owner_uid) {
  15                 $result = db_query(
  16                         "SELECT caption FROM ttrss_labels2 WHERE id = '$label'
  17                                 AND owner_uid = '$owner_uid' LIMIT 1");
  18
  19                 if (db_num_rows($result) == 1) {
  20                         return db_fetch_result($result, 0, "caption");
  21                 } else {
  22                         return "";
  23                 }
  24         }
  25
  26         function get_all_labels($owner_uid) {
  27                 $rv = array();
  28
  29                 $result = db_query("SELECT fg_color, bg_color, caption FROM ttrss_labels2 WHERE owner_uid = " . $owner_uid);
  30
  31                 while ($line = db_fetch_assoc($result)) {
  32                         array_push($rv, $line);
  33                 }
  34
  35                 return $rv;
  36         }
  37
  38         function label_update_cache($owner_uid, $id, $labels = false, $force = false) {
  39
  40                 if ($force)
  41                         label_clear_cache($id);
  42
  43                 if (!$labels)
  44                         $labels = get_article_labels($id);
  45
  46                 $labels = db_escape_string(json_encode($labels));
  47
  48                 db_query("UPDATE ttrss_user_entries SET
  49                         label_cache = '$labels' WHERE ref_id = '$id' AND  owner_uid = '$owner_uid'");
  50
  51         }
  52
  53         function label_clear_cache($id) {
  54
  55                 db_query("UPDATE ttrss_user_entries SET
  56                         label_cache = '' WHERE ref_id = '$id'");
  57
  58         }
  59
  60         function label_remove_article($id, $label, $owner_uid) {
  61
  62                 $label_id = label_find_id($label, $owner_uid);
  63
  64                 if (!$label_id) return;
  65
  66                 db_query(
  67                         "DELETE FROM ttrss_user_labels2
  68                         WHERE
  69                                 label_id = '$label_id' AND
  70                                 article_id = '$id'");
  71
  72                 label_clear_cache($id);
  73         }
  74
  75         function label_add_article($id, $label, $owner_uid) {
  76
  77                 $label_id = label_find_id($label, $owner_uid);
  78
  79                 if (!$label_id) return;
  80
  81                 $result = db_query(
  82                         "SELECT
  83                                 article_id FROM ttrss_labels2, ttrss_user_labels2
  84                         WHERE
  85                                 label_id = id AND
  86                                 label_id = '$label_id' AND
  87                                 article_id = '$id' AND owner_uid = '$owner_uid'
  88                         LIMIT 1");
  89
  90                 if (db_num_rows($result) == 0) {
  91                         db_query("INSERT INTO ttrss_user_labels2
  92                                 (label_id, article_id) VALUES ('$label_id', '$id')");
  93                 }
  94
  95                 label_clear_cache($id);
  96
  97         }
  98
  99         function label_remove($id, $owner_uid) {
 100                 if (!$owner_uid) $owner_uid = $_SESSION["uid"];
 101
 102                 db_query("BEGIN");
 103
 104                 $result = db_query("SELECT caption FROM ttrss_labels2
 105                         WHERE id = '$id'");
 106
 107                 $caption = db_fetch_result($result, 0, "caption");
 108
 109                 $result = db_query("DELETE FROM ttrss_labels2 WHERE id = '$id'
 110                         AND owner_uid = " . $owner_uid);
 111
 112                 if (db_affected_rows($result) != 0 && $caption) {
 113
 114                         /* Remove access key for the label */
 115
 116                         $ext_id = LABEL_BASE_INDEX - 1 - $id;
 117
 118                         db_query("DELETE FROM ttrss_access_keys WHERE
 119                                 feed_id = '$ext_id' AND owner_uid = $owner_uid");
 120
 121                         /* Remove cached data */
 122
 123                         db_query("UPDATE ttrss_user_entries SET label_cache = ''
 124                                 WHERE label_cache LIKE '%$caption%' AND owner_uid = " . $owner_uid);
 125
 126                 }
 127
 128                 db_query("COMMIT");
 129         }
 130
 131         function label_create($caption, $fg_color = '', $bg_color = '', $owner_uid = false) {
 132
 133                 if (!$owner_uid) $owner_uid = $_SESSION['uid'];
 134
 135                 db_query("BEGIN");
 136
 137                 $result = false;
 138
 139                 $result = db_query("SELECT id FROM ttrss_labels2
 140                         WHERE caption = '$caption' AND owner_uid = $owner_uid");
 141
 142                 if (db_num_rows($result) == 0) {
 143                         $result = db_query(
 144                                 "INSERT INTO ttrss_labels2 (caption,owner_uid,fg_color,bg_color)
 145                                         VALUES ('$caption', '$owner_uid', '$fg_color', '$bg_color')");
 146
 147                         $result = db_affected_rows($result) != 0;
 148                 }
 149
 150                 db_query("COMMIT");
 151
 152                 return $result;
 153         }