3 // Copyright (C) 2002, 2003 Mike Little -- mike@zed1.com
5 require_once('admin.php');
7 $title = __('Manage Links');
8 $this_file = $parent_file = 'link-manager.php';
11 $wpvarstoreset = array('action','cat_id', 'linkurl', 'name', 'image',
12 'description', 'visible', 'target', 'category', 'link_id',
13 'submit', 'order_by', 'links_show_cat_id', 'rating', 'rel',
14 'notes', 'linkcheck[]');
16 for ($i=0; $i<count($wpvarstoreset); $i += 1) {
17 $wpvar = $wpvarstoreset[$i];
18 if (!isset($$wpvar)) {
19 if (empty($_POST["$wpvar"])) {
20 if (empty($_GET["$wpvar"])) {
23 $$wpvar = $_GET["$wpvar"];
26 $$wpvar = $_POST["$wpvar"];
31 $links_show_cat_id = $_COOKIE['links_show_cat_id_' . COOKIEHASH];
32 $links_show_order = $_COOKIE['links_show_order_' . COOKIEHASH];
34 if ('' != $_POST['assign']) $action = 'assign';
35 if ('' != $_POST['visibility']) $action = 'visibility';
36 if ('' != $_POST['move']) $action = 'move';
37 if ('' != $_POST['linkcheck']) $linkcheck = $_POST[linkcheck];
42 check_admin_referer();
44 // check the current user's level first.
45 if ( !current_user_can('manage_links') )
46 die (__("Cheatin' uh ?"));
48 //for each link id (in $linkcheck[]): if the current user level >= the
49 //userlevel of the owner of the link then we can proceed.
51 if (count($linkcheck) == 0) {
52 header('Location: ' . $this_file);
55 $all_links = join(',', $linkcheck);
56 $results = $wpdb->get_results("SELECT link_id, link_owner FROM $wpdb->links LEFT JOIN $wpdb->users ON link_owner = ID WHERE link_id in ($all_links)");
57 foreach ($results as $row) {
58 $ids_to_change[] = $row->link_id;
61 // should now have an array of links we can change
62 $all_links = join(',', $ids_to_change);
63 $q = $wpdb->query("update $wpdb->links SET link_owner='$newowner' WHERE link_id IN ($all_links)");
65 header('Location: ' . $this_file);
70 check_admin_referer();
72 // check the current user's level first.
73 if ( !current_user_can('manage_links') )
74 die (__("Cheatin' uh ?"));
76 //for each link id (in $linkcheck[]): toggle the visibility
77 if (count($linkcheck) == 0) {
78 header('Location: ' . $this_file);
81 $all_links = join(',', $linkcheck);
82 $results = $wpdb->get_results("SELECT link_id, link_visible FROM $wpdb->links WHERE link_id in ($all_links)");
83 foreach ($results as $row) {
84 if ($row->link_visible == 'Y') { // ok to proceed
85 $ids_to_turnoff[] = $row->link_id;
87 $ids_to_turnon[] = $row->link_id;
91 // should now have two arrays of links to change
92 if (count($ids_to_turnoff)) {
93 $all_linksoff = join(',', $ids_to_turnoff);
94 $q = $wpdb->query("update $wpdb->links SET link_visible='N' WHERE link_id IN ($all_linksoff)");
97 if (count($ids_to_turnon)) {
98 $all_linkson = join(',', $ids_to_turnon);
99 $q = $wpdb->query("update $wpdb->links SET link_visible='Y' WHERE link_id IN ($all_linkson)");
102 header('Location: ' . $this_file);
107 check_admin_referer();
109 // check the current user's level first.
110 if ( !current_user_can('manage_links') )
111 die (__("Cheatin' uh ?"));
113 //for each link id (in $linkcheck[]) change category to selected value
114 if (count($linkcheck) == 0) {
115 header('Location: ' . $this_file);
118 $all_links = join(',', $linkcheck);
119 // should now have an array of links we can change
120 $q = $wpdb->query("update $wpdb->links SET link_category='$category' WHERE link_id IN ($all_links)");
122 header('Location: ' . $this_file);
128 check_admin_referer();
132 header('Location: ' . $_SERVER['HTTP_REFERER'] . '?added=true');
139 check_admin_referer();
141 if (isset($links_show_cat_id) && ($links_show_cat_id != ''))
142 $cat_id = $links_show_cat_id;
144 if (!isset($cat_id) || ($cat_id == '')) {
145 if (!isset($links_show_cat_id) || ($links_show_cat_id == ''))
148 $links_show_cat_id = $cat_id;
150 $link_id = (int) $_POST['link_id'];
153 setcookie('links_show_cat_id_' . COOKIEHASH, $links_show_cat_id, time()+600);
154 wp_redirect($this_file);
160 check_admin_referer();
162 if ( !current_user_can('manage_links') )
163 die (__("Cheatin' uh ?"));
165 $link_id = (int) $_GET['link_id'];
167 wp_delete_link($link_id);
169 if (isset($links_show_cat_id) && ($links_show_cat_id != ''))
170 $cat_id = $links_show_cat_id;
172 if (!isset($cat_id) || ($cat_id == '')) {
173 if (!isset($links_show_cat_id) || ($links_show_cat_id == ''))
176 $links_show_cat_id = $cat_id;
177 setcookie('links_show_cat_id_' . COOKIEHASH, $links_show_cat_id, time()+600);
178 wp_redirect($this_file);
184 include_once ('admin-header.php');
185 if ( !current_user_can('manage_links') )
186 die(__('You do not have sufficient permissions to edit the links for this blog.'));
188 $link_id = (int) $_GET['link_id'];
190 if ( !$link = get_link_to_edit($link_id) )
191 die( __('Link not found.') );
193 include('edit-link-form.php');
198 if (!isset($cat_id) || ($cat_id == '')) {
199 if (!isset($links_show_cat_id) || ($links_show_cat_id == ''))
202 $links_show_cat_id = $cat_id;
203 if (!isset($order_by) || ($order_by == '')) {
204 if (!isset($links_show_order) || ($links_show_order == ''))
205 $order_by = 'order_name';
207 $links_show_order = $order_by;
208 //break; fall through
212 $link_url = stripslashes($_GET["linkurl"]);
213 $link_name = stripslashes($_GET["name"]);
214 //break; fall through
218 if (isset($links_show_cat_id) && ($links_show_cat_id != ''))
219 $cat_id = $links_show_cat_id;
221 if (!isset($cat_id) || ($cat_id == '')) {
222 if (!isset($links_show_cat_id) || ($links_show_cat_id == ''))
225 $links_show_cat_id = $cat_id;
226 if (isset($links_show_order) && ($links_show_order != ''))
227 $order_by = $links_show_order;
229 if (!isset($order_by) || ($order_by == ''))
230 $order_by = 'order_name';
231 $links_show_order = $order_by;
233 setcookie('links_show_cat_id_' . COOKIEHASH, $links_show_cat_id, time()+600);
234 setcookie('links_show_order_' . COOKIEHASH, $links_show_order, time()+600);
235 include_once ("./admin-header.php");
236 if ( !current_user_can('manage_links') )
237 die(__("You do not have sufficient permissions to edit the links for this blog."));
241 case 'order_id': $sqlorderby = 'id'; break;
242 case 'order_url': $sqlorderby = 'url'; break;
243 case 'order_desc': $sqlorderby = 'description'; break;
244 case 'order_owner': $sqlorderby = 'owner'; break;
245 case 'order_rating': $sqlorderby = 'rating'; break;
247 default: $sqlorderby = 'name'; break;
250 if ($action != "popup") {
252 <script type="text/javascript">
254 function checkAll(form)
256 for (i = 0, n = form.elements.length; i < n; i++) {
257 if(form.elements[i].type == "checkbox") {
258 if(form.elements[i].checked == true)
259 form.elements[i].checked = false;
261 form.elements[i].checked = true;
269 <form name="cats" method="post" action="">
270 <table width="75%" cellpadding="3" cellspacing="3">
273 <?php _e('<strong>Show</strong> links in category:'); ?><br />
276 <?php _e('<strong>Order</strong> by:');?>
283 $results = $wpdb->get_results("SELECT cat_id, cat_name, auto_toggle FROM $wpdb->linkcategories ORDER BY cat_id");
284 echo " <select name=\"cat_id\">\n";
285 echo " <option value=\"All\"";
286 if ($cat_id == 'All')
287 echo " selected='selected'";
288 echo "> " . __('All') . "</option>\n";
289 foreach ($results as $row) {
290 echo " <option value=\"".$row->cat_id."\"";
291 if ($row->cat_id == $cat_id)
292 echo " selected='selected'";
293 echo ">".$row->cat_id.": ".wp_specialchars($row->cat_name);
294 if ($row->auto_toggle == 'Y')
295 echo ' '.__('(auto toggle)');
302 <select name="order_by">
303 <option value="order_id" <?php if ($order_by == 'order_id') echo " selected='selected'";?>><?php _e('Link ID') ?></option>
304 <option value="order_name" <?php if ($order_by == 'order_name') echo " selected='selected'";?>><?php _e('Name') ?></option>
305 <option value="order_url" <?php if ($order_by == 'order_url') echo " selected='selected'";?>><?php _e('URI') ?></option>
306 <option value="order_desc" <?php if ($order_by == 'order_desc') echo " selected='selected'";?>><?php _e('Description') ?></option>
307 <option value="order_owner" <?php if ($order_by == 'order_owner') echo " selected='selected'";?>><?php _e('Owner') ?></option>
308 <option value="order_rating" <?php if ($order_by == 'order_rating') echo " selected='selected'";?>><?php _e('Rating') ?></option>
312 <input type="submit" name="action" value="<?php _e('Show') ?>" />
320 <form name="links" id="links" method="post" action="">
323 <input type="hidden" name="link_id" value="" />
324 <input type="hidden" name="action" value="" />
325 <input type="hidden" name="order_by" value="<?php echo wp_specialchars($order_by, 1); ?>" />
326 <input type="hidden" name="cat_id" value="<?php echo (int) $cat_id ?>" />
327 <table id="the-list-x" width="100%" cellpadding="3" cellspacing="3">
329 <th width="15%"><?php _e('Name') ?></th>
330 <th><?php _e('URI') ?></th>
331 <th><?php _e('Category') ?></th>
332 <th><?php _e('rel') ?></th>
333 <th><?php _e('Image') ?></th>
334 <th><?php _e('Visible') ?></th>
335 <th colspan="2"><?php _e('Action') ?></th>
339 $sql = "SELECT link_url, link_name, link_image, link_description, link_visible,
340 link_category AS cat_id, cat_name AS category, $wpdb->users.user_login, link_id,
341 link_rating, link_rel
343 LEFT JOIN $wpdb->linkcategories ON $wpdb->links.link_category = $wpdb->linkcategories.cat_id
344 LEFT JOIN $wpdb->users ON $wpdb->users.ID = $wpdb->links.link_owner ";
346 if (isset($cat_id) && ($cat_id != 'All')) {
347 $sql .= " WHERE link_category = $cat_id ";
349 $sql .= ' ORDER BY link_' . $sqlorderby;
352 $links = $wpdb->get_results($sql);
354 foreach ($links as $link) {
355 $link->link_name = wp_specialchars($link->link_name);
356 $link->link_category = wp_specialchars($link->link_category);
357 $link->link_description = wp_specialchars($link->link_description);
358 $link->link_url = wp_specialchars($link->link_url);
359 $short_url = str_replace('http://', '', $link->link_url);
360 $short_url = str_replace('www.', '', $short_url);
361 if ('/' == substr($short_url, -1))
362 $short_url = substr($short_url, 0, -1);
363 if (strlen($short_url) > 35)
364 $short_url = substr($short_url, 0, 32).'...';
366 $image = ($link->link_image != null) ? __('Yes') : __('No');
367 $visible = ($link->link_visible == 'Y') ? __('Yes') : __('No');
369 $style = ($i % 2) ? '' : ' class="alternate"';
371 <tr id="link-<?php echo $link->link_id; ?>" valign="middle" <?php echo $style; ?>>
372 <td><strong><?php echo $link->link_name; ?></strong><br />
374 echo sprintf(__('Description: %s'), $link->link_description) . "</td>";
375 echo "<td><a href=\"$link->link_url\" title=\"" . sprintf(__('Visit %s'), $link->link_name) . "\">$short_url</a></td>";
377 <td>$link->category</td>
378 <td>$link->link_rel</td>
379 <td align='center'>$image</td>
380 <td align='center'>$visible</td>
382 $show_buttons = 1; // default
385 echo '<td><a href="link-manager.php?link_id=' . $link->link_id . '&action=linkedit" class="edit">' . __('Edit') . '</a></td>';
386 echo '<td><a href="link-manager.php?link_id=' . $link->link_id . '&action=Delete"' . " onclick=\"return deleteSomething( 'link', $link->link_id , '" . sprintf(__("You are about to delete the "%s" link to %s.\\n"Cancel" to stop, "OK" to delete."), wp_specialchars($link->link_name,1), wp_specialchars($link->link_url)) . '\' );" class="delete">' . __('Delete') . '</a></td>';
387 echo '<td><input type="checkbox" name="linkcheck[]" value="' . $link->link_id . '" /></td>';
389 echo "<td> </td><td> </td><td> </td>\n";
397 <div id="ajax-response"></div>
402 <table width="100%" cellpadding="3" cellspacing="3">
403 <tr><th colspan="4"><?php _e('Manage Multiple Links:') ?></th></tr>
404 <tr><td colspan="4"><?php _e('Use the checkboxes on the right to select multiple links and choose an action below:') ?></td></tr>
407 <?php _e('Assign ownership to:'); ?>
409 $results = $wpdb->get_results("SELECT ID, user_login FROM $wpdb->users ORDER BY ID");
410 echo " <select name=\"newowner\" size=\"1\">\n";
411 foreach ($results as $row) {
412 echo " <option value=\"".$row->ID."\"";
413 echo ">".$row->user_login;
418 <input name="assign" type="submit" id="assign" value="<?php _e('Go') ?>" />
421 <input name="visibility" type="submit" id="visibility" value="<?php _e('Toggle Visibility') ?>" />
424 <?php _e('Move to category:'); link_category_dropdown('category'); ?> <input name="move" type="submit" id="move" value="<?php _e('Go') ?>" />
427 <a href="#" onclick="checkAll(document.getElementById('links')); return false; "><?php _e('Toggle Checkboxes') ?></a>
445 <?php include('admin-footer.php'); ?>