]>
Commit | Line | Data |
---|---|---|
5f0a3741 | 1 | <?php |
369dbc19 | 2 | class Pref_Instances extends Handler_Protected { |
5f0a3741 | 3 | |
32532f1c AD |
4 | private $status_codes = array( |
5 | 0 => "Connection failed", | |
6 | 1 => "Success", | |
7 | 2 => "Invalid object received", | |
8 | 16 => "Access denied" ); | |
9 | ||
8484ce22 AD |
10 | function csrf_ignore($method) { |
11 | $csrf_ignored = array("index", "edit"); | |
12 | ||
13 | return array_search($method, $csrf_ignored) !== false; | |
14 | } | |
15 | ||
17f9d200 JK |
16 | function before($method) { |
17 | if (parent::before($method)) { | |
5f0a3741 AD |
18 | if ($_SESSION["access_level"] < 10) { |
19 | print __("Your access level is insufficient to open this tab."); | |
20 | return false; | |
21 | } | |
22 | return true; | |
23 | } | |
24 | return false; | |
25 | } | |
26 | ||
27 | function remove() { | |
28 | $ids = db_escape_string($_REQUEST['ids']); | |
29 | ||
30 | db_query($this->link, "DELETE FROM ttrss_linked_instances WHERE | |
31 | id IN ($ids)"); | |
32 | } | |
33 | ||
34 | function add() { | |
35 | $id = db_escape_string($_REQUEST["id"]); | |
36 | $access_url = db_escape_string($_REQUEST["access_url"]); | |
37 | $access_key = db_escape_string($_REQUEST["access_key"]); | |
38 | ||
39 | db_query($this->link, "BEGIN"); | |
40 | ||
41 | $result = db_query($this->link, "SELECT id FROM ttrss_linked_instances | |
42 | WHERE access_url = '$access_url'"); | |
43 | ||
44 | if (db_num_rows($result) == 0) { | |
45 | db_query($this->link, "INSERT INTO ttrss_linked_instances | |
46 | (access_url, access_key, last_connected, last_status_in, last_status_out) | |
47 | VALUES | |
48 | ('$access_url', '$access_key', '1970-01-01', -1, -1)"); | |
49 | ||
50 | } | |
51 | ||
52 | db_query($this->link, "COMMIT"); | |
53 | } | |
54 | ||
55 | function edit() { | |
56 | $id = db_escape_string($_REQUEST["id"]); | |
57 | ||
58 | $result = db_query($this->link, "SELECT * FROM ttrss_linked_instances WHERE | |
59 | id = '$id'"); | |
60 | ||
61 | print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"id\" value=\"$id\">"; | |
62 | print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"op\" value=\"pref-instances\">"; | |
63 | print "<input dojoType=\"dijit.form.TextBox\" style=\"display : none\" name=\"method\" value=\"editSave\">"; | |
64 | ||
65 | print "<div class=\"dlgSec\">".__("Instance")."</div>"; | |
66 | ||
67 | print "<div class=\"dlgSecCont\">"; | |
68 | ||
69 | /* URL */ | |
70 | ||
71 | $access_url = htmlspecialchars(db_fetch_result($result, 0, "access_url")); | |
72 | ||
73 | print __("URL:") . " "; | |
74 | ||
75 | print "<input dojoType=\"dijit.form.ValidationTextBox\" required=\"1\" | |
76 | placeHolder=\"".__("Instance URL")."\" | |
77 | regExp='^(http|https)://.*' | |
78 | style=\"font-size : 16px; width: 20em\" name=\"access_url\" | |
79 | value=\"$access_url\">"; | |
80 | ||
81 | print "<hr/>"; | |
82 | ||
83 | $access_key = htmlspecialchars(db_fetch_result($result, 0, "access_key")); | |
84 | ||
85 | /* Access key */ | |
86 | ||
87 | print __("Access key:") . " "; | |
88 | ||
89 | print "<input dojoType=\"dijit.form.ValidationTextBox\" required=\"1\" | |
90 | placeHolder=\"".__("Access key")."\" regExp='\w{40}' | |
91 | style=\"width: 20em\" name=\"access_key\" id=\"instance_edit_key\" | |
92 | value=\"$access_key\">"; | |
93 | ||
94 | print "<p class='insensitive'>" . __("Use one access key for both linked instances."); | |
95 | ||
96 | print "</div>"; | |
97 | ||
98 | print "<div class=\"dlgButtons\"> | |
99 | <div style='float : left'> | |
100 | <button dojoType=\"dijit.form.Button\" | |
101 | onclick=\"return dijit.byId('instanceEditDlg').regenKey()\">". | |
102 | __('Generate new key')."</button> | |
103 | </div> | |
104 | <button dojoType=\"dijit.form.Button\" | |
105 | onclick=\"return dijit.byId('instanceEditDlg').execute()\">". | |
106 | __('Save')."</button> | |
107 | <button dojoType=\"dijit.form.Button\" | |
108 | onclick=\"return dijit.byId('instanceEditDlg').hide()\"\">". | |
109 | __('Cancel')."</button></div>"; | |
110 | ||
111 | } | |
112 | ||
113 | function editSave() { | |
114 | $id = db_escape_string($_REQUEST["id"]); | |
115 | $access_url = db_escape_string($_REQUEST["access_url"]); | |
116 | $access_key = db_escape_string($_REQUEST["access_key"]); | |
117 | ||
118 | db_query($this->link, "UPDATE ttrss_linked_instances SET | |
119 | access_key = '$access_key', access_url = '$access_url', | |
120 | last_connected = '1970-01-01' | |
121 | WHERE id = '$id'"); | |
122 | ||
123 | } | |
124 | ||
125 | function index() { | |
126 | ||
127 | if (!function_exists('curl_init')) { | |
128 | print "<div style='padding : 1em'>"; | |
129 | print_error("This functionality requires CURL functions. Please enable CURL in your PHP configuration (you might also want to disable open_basedir in php.ini) and reload this page."); | |
130 | print "</div>"; | |
131 | } | |
132 | ||
133 | print "<div id=\"pref-instance-wrap\" dojoType=\"dijit.layout.BorderContainer\" gutters=\"false\">"; | |
134 | print "<div id=\"pref-instance-header\" dojoType=\"dijit.layout.ContentPane\" region=\"top\">"; | |
135 | ||
136 | print "<div id=\"pref-instance-toolbar\" dojoType=\"dijit.Toolbar\">"; | |
137 | ||
138 | $sort = db_escape_string($_REQUEST["sort"]); | |
139 | ||
140 | if (!$sort || $sort == "undefined") { | |
141 | $sort = "access_url"; | |
142 | } | |
143 | ||
144 | print "<div dojoType=\"dijit.form.DropDownButton\">". | |
145 | "<span>" . __('Select')."</span>"; | |
146 | print "<div dojoType=\"dijit.Menu\" style=\"display: none;\">"; | |
147 | print "<div onclick=\"selectTableRows('prefInstanceList', 'all')\" | |
148 | dojoType=\"dijit.MenuItem\">".__('All')."</div>"; | |
149 | print "<div onclick=\"selectTableRows('prefInstanceList', 'none')\" | |
150 | dojoType=\"dijit.MenuItem\">".__('None')."</div>"; | |
151 | print "</div></div>"; | |
152 | ||
153 | print "<button dojoType=\"dijit.form.Button\" onclick=\"addInstance()\">".__('Link instance')."</button>"; | |
154 | print "<button dojoType=\"dijit.form.Button\" onclick=\"editSelectedInstance()\">".__('Edit')."</button>"; | |
155 | print "<button dojoType=\"dijit.form.Button\" onclick=\"removeSelectedInstances()\">".__('Remove')."</button>"; | |
156 | ||
157 | print "</div>"; #toolbar | |
158 | ||
159 | $result = db_query($this->link, "SELECT *, | |
160 | (SELECT COUNT(*) FROM ttrss_linked_feeds | |
161 | WHERE instance_id = ttrss_linked_instances.id) AS num_feeds | |
162 | FROM ttrss_linked_instances | |
163 | ORDER BY $sort"); | |
164 | ||
165 | print "<p class=\"insensitive\" style='margin-left : 1em;'>" . __("You can connect other instances of Tiny Tiny RSS to this one to share Popular feeds. Link to this instance of Tiny Tiny RSS by using this URL:"); | |
166 | ||
167 | print " <a href=\"#\" onclick=\"alert('".htmlspecialchars(get_self_url_prefix())."')\">(display url)</a>"; | |
168 | ||
169 | print "<p><table width='100%' id='prefInstanceList' class='prefInstanceList' cellspacing='0'>"; | |
170 | ||
171 | print "<tr class=\"title\"> | |
172 | <td align='center' width=\"5%\"> </td> | |
173 | <td width=''><a href=\"#\" onclick=\"updateInstanceList('access_url')\">".__('Instance URL')."</a></td> | |
174 | <td width='20%'><a href=\"#\" onclick=\"updateInstanceList('access_key')\">".__('Access key')."</a></td> | |
175 | <td width='10%'><a href=\"#\" onclick=\"updateUsersList('last_connected')\">".__('Last connected')."</a></td> | |
32532f1c | 176 | <td width='10%'><a href=\"#\" onclick=\"updateUsersList('last_status_out')\">".__('Status')."</a></td> |
5f0a3741 AD |
177 | <td width='10%'><a href=\"#\" onclick=\"updateUsersList('num_feeds')\">".__('Stored feeds')."</a></td> |
178 | </tr>"; | |
179 | ||
180 | $lnum = 0; | |
181 | ||
182 | while ($line = db_fetch_assoc($result)) { | |
183 | $class = ($lnum % 2) ? "even" : "odd"; | |
184 | ||
185 | $id = $line['id']; | |
186 | $this_row_id = "id=\"LIRR-$id\""; | |
187 | ||
188 | $line["last_connected"] = make_local_datetime($this->link, $line["last_connected"], false); | |
189 | ||
190 | print "<tr class=\"$class\" $this_row_id>"; | |
191 | ||
192 | print "<td align='center'><input onclick='toggleSelectRow(this);' | |
193 | type=\"checkbox\" id=\"LICHK-$id\"></td>"; | |
194 | ||
195 | $onclick = "onclick='editInstance($id, event)' title='".__('Click to edit')."'"; | |
196 | ||
197 | $access_key = mb_substr($line['access_key'], 0, 4) . '...' . | |
198 | mb_substr($line['access_key'], -4); | |
199 | ||
200 | print "<td $onclick>" . htmlspecialchars($line['access_url']) . "</td>"; | |
201 | print "<td $onclick>" . htmlspecialchars($access_key) . "</td>"; | |
202 | print "<td $onclick>" . htmlspecialchars($line['last_connected']) . "</td>"; | |
32532f1c | 203 | print "<td $onclick>" . $this->status_codes[$line['last_status_out']] . "</td>"; |
5f0a3741 AD |
204 | print "<td $onclick>" . htmlspecialchars($line['num_feeds']) . "</td>"; |
205 | ||
206 | print "</tr>"; | |
207 | ||
208 | ++$lnum; | |
209 | } | |
210 | ||
211 | print "</table>"; | |
212 | ||
213 | print "</div>"; #pane | |
6065f3ad AD |
214 | |
215 | global $pluginhost; | |
216 | $pluginhost->run_hooks($pluginhost::HOOK_PREFS_TAB, | |
217 | "hook_prefs_tab", "prefInstances"); | |
218 | ||
5f0a3741 AD |
219 | print "</div>"; #container |
220 | ||
221 | } | |
222 | } | |
223 | ?> |