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