]>
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 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 | } |