]>
Commit | Line | Data |
---|---|---|
87d7e850 | 1 | <?php |
a42c55f0 | 2 | function label_find_id($label, $owner_uid) { |
6322ac79 | 3 | $result = db_query( |
87d7e850 AD |
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 | ||
a42c55f0 | 14 | function get_article_labels($id, $owner_uid = false) { |
87d7e850 AD |
15 | $rv = array(); |
16 | ||
17 | if (!$owner_uid) $owner_uid = $_SESSION["uid"]; | |
18 | ||
a42c55f0 | 19 | $result = db_query("SELECT label_cache FROM |
87d7e850 AD |
20 | ttrss_user_entries WHERE ref_id = '$id' AND owner_uid = " . |
21 | $owner_uid); | |
22 | ||
23 | if (db_num_rows($result) > 0) { | |
24 | $label_cache = db_fetch_result($result, 0, "label_cache"); | |
25 | ||
26 | if ($label_cache) { | |
27 | $label_cache = json_decode($label_cache, true); | |
28 | ||
29 | if ($label_cache["no-labels"] == 1) | |
30 | return $rv; | |
31 | else | |
32 | return $label_cache; | |
33 | } | |
34 | } | |
35 | ||
6322ac79 | 36 | $result = db_query( |
87d7e850 AD |
37 | "SELECT DISTINCT label_id,caption,fg_color,bg_color |
38 | FROM ttrss_labels2, ttrss_user_labels2 | |
39 | WHERE id = label_id | |
40 | AND article_id = '$id' | |
41 | AND owner_uid = ". $owner_uid . " | |
42 | ORDER BY caption"); | |
43 | ||
44 | while ($line = db_fetch_assoc($result)) { | |
cdfc4114 AD |
45 | $rk = array(label_to_feed_id($line["label_id"]), |
46 | $line["caption"], $line["fg_color"], | |
87d7e850 AD |
47 | $line["bg_color"]); |
48 | array_push($rv, $rk); | |
49 | } | |
50 | ||
51 | if (count($rv) > 0) | |
a42c55f0 | 52 | label_update_cache($owner_uid, $id, $rv); |
87d7e850 | 53 | else |
a42c55f0 | 54 | label_update_cache($owner_uid, $id, array("no-labels" => 1)); |
87d7e850 AD |
55 | |
56 | return $rv; | |
57 | } | |
58 | ||
59 | ||
a42c55f0 | 60 | function label_find_caption($label, $owner_uid) { |
6322ac79 | 61 | $result = db_query( |
87d7e850 AD |
62 | "SELECT caption FROM ttrss_labels2 WHERE id = '$label' |
63 | AND owner_uid = '$owner_uid' LIMIT 1"); | |
64 | ||
65 | if (db_num_rows($result) == 1) { | |
66 | return db_fetch_result($result, 0, "caption"); | |
67 | } else { | |
68 | return ""; | |
69 | } | |
70 | } | |
71 | ||
a42c55f0 | 72 | function get_all_labels($owner_uid) { |
87d7e850 AD |
73 | $rv = array(); |
74 | ||
a42c55f0 | 75 | $result = db_query("SELECT fg_color, bg_color, caption FROM ttrss_labels2 WHERE owner_uid = " . $owner_uid); |
87d7e850 AD |
76 | |
77 | while ($line = db_fetch_assoc($result)) { | |
78 | array_push($rv, $line); | |
79 | } | |
80 | ||
81 | return $rv; | |
82 | } | |
83 | ||
a42c55f0 | 84 | function label_update_cache($owner_uid, $id, $labels = false, $force = false) { |
87d7e850 AD |
85 | |
86 | if ($force) | |
a42c55f0 | 87 | label_clear_cache($id); |
87d7e850 AD |
88 | |
89 | if (!$labels) | |
a42c55f0 | 90 | $labels = get_article_labels($id); |
87d7e850 | 91 | |
a42c55f0 | 92 | $labels = db_escape_string(json_encode($labels)); |
87d7e850 | 93 | |
a42c55f0 | 94 | db_query("UPDATE ttrss_user_entries SET |
87d7e850 AD |
95 | label_cache = '$labels' WHERE ref_id = '$id' AND owner_uid = '$owner_uid'"); |
96 | ||
97 | } | |
98 | ||
a42c55f0 | 99 | function label_clear_cache($id) { |
87d7e850 | 100 | |
a42c55f0 | 101 | db_query("UPDATE ttrss_user_entries SET |
87d7e850 AD |
102 | label_cache = '' WHERE ref_id = '$id'"); |
103 | ||
104 | } | |
105 | ||
a42c55f0 | 106 | function label_remove_article($id, $label, $owner_uid) { |
87d7e850 | 107 | |
a42c55f0 | 108 | $label_id = label_find_id($label, $owner_uid); |
87d7e850 AD |
109 | |
110 | if (!$label_id) return; | |
111 | ||
4a80c57c | 112 | db_query( |
87d7e850 AD |
113 | "DELETE FROM ttrss_user_labels2 |
114 | WHERE | |
115 | label_id = '$label_id' AND | |
116 | article_id = '$id'"); | |
117 | ||
a42c55f0 | 118 | label_clear_cache($id); |
87d7e850 AD |
119 | } |
120 | ||
a42c55f0 | 121 | function label_add_article($id, $label, $owner_uid) { |
87d7e850 | 122 | |
a42c55f0 | 123 | $label_id = label_find_id($label, $owner_uid); |
87d7e850 AD |
124 | |
125 | if (!$label_id) return; | |
126 | ||
6322ac79 | 127 | $result = db_query( |
87d7e850 AD |
128 | "SELECT |
129 | article_id FROM ttrss_labels2, ttrss_user_labels2 | |
130 | WHERE | |
131 | label_id = id AND | |
132 | label_id = '$label_id' AND | |
133 | article_id = '$id' AND owner_uid = '$owner_uid' | |
134 | LIMIT 1"); | |
135 | ||
136 | if (db_num_rows($result) == 0) { | |
a42c55f0 | 137 | db_query("INSERT INTO ttrss_user_labels2 |
87d7e850 AD |
138 | (label_id, article_id) VALUES ('$label_id', '$id')"); |
139 | } | |
140 | ||
a42c55f0 | 141 | label_clear_cache($id); |
87d7e850 AD |
142 | |
143 | } | |
144 | ||
a42c55f0 | 145 | function label_remove($id, $owner_uid) { |
87d7e850 AD |
146 | if (!$owner_uid) $owner_uid = $_SESSION["uid"]; |
147 | ||
a42c55f0 | 148 | db_query("BEGIN"); |
87d7e850 | 149 | |
a42c55f0 | 150 | $result = db_query("SELECT caption FROM ttrss_labels2 |
87d7e850 AD |
151 | WHERE id = '$id'"); |
152 | ||
153 | $caption = db_fetch_result($result, 0, "caption"); | |
154 | ||
a42c55f0 | 155 | $result = db_query("DELETE FROM ttrss_labels2 WHERE id = '$id' |
87d7e850 AD |
156 | AND owner_uid = " . $owner_uid); |
157 | ||
a42c55f0 | 158 | if (db_affected_rows($result) != 0 && $caption) { |
87d7e850 AD |
159 | |
160 | /* Remove access key for the label */ | |
161 | ||
f822a8e5 | 162 | $ext_id = LABEL_BASE_INDEX - 1 - $id; |
87d7e850 | 163 | |
a42c55f0 | 164 | db_query("DELETE FROM ttrss_access_keys WHERE |
87d7e850 AD |
165 | feed_id = '$ext_id' AND owner_uid = $owner_uid"); |
166 | ||
87d7e850 AD |
167 | /* Remove cached data */ |
168 | ||
a42c55f0 | 169 | db_query("UPDATE ttrss_user_entries SET label_cache = '' |
87d7e850 AD |
170 | WHERE label_cache LIKE '%$caption%' AND owner_uid = " . $owner_uid); |
171 | ||
172 | } | |
173 | ||
a42c55f0 | 174 | db_query("COMMIT"); |
87d7e850 AD |
175 | } |
176 | ||
a42c55f0 | 177 | function label_create($caption, $fg_color = '', $bg_color = '', $owner_uid = false) { |
87d7e850 AD |
178 | |
179 | if (!$owner_uid) $owner_uid = $_SESSION['uid']; | |
180 | ||
a42c55f0 | 181 | db_query("BEGIN"); |
87d7e850 AD |
182 | |
183 | $result = false; | |
184 | ||
a42c55f0 | 185 | $result = db_query("SELECT id FROM ttrss_labels2 |
87d7e850 AD |
186 | WHERE caption = '$caption' AND owner_uid = $owner_uid"); |
187 | ||
188 | if (db_num_rows($result) == 0) { | |
6322ac79 | 189 | $result = db_query( |
87d7e850 AD |
190 | "INSERT INTO ttrss_labels2 (caption,owner_uid,fg_color,bg_color) |
191 | VALUES ('$caption', '$owner_uid', '$fg_color', '$bg_color')"); | |
192 | ||
a42c55f0 | 193 | $result = db_affected_rows($result) != 0; |
87d7e850 AD |
194 | } |
195 | ||
a42c55f0 | 196 | db_query("COMMIT"); |
87d7e850 AD |
197 | |
198 | return $result; | |
199 | } | |
200 | ||
201 | ?> |