Changeset 9985 for trunk/admin/links.php

Timestamp:

04/06/09 23:30:15 (3 years ago)

Author:

Andrey Prikaznov

Message:

 

File:

• trunk/admin/links.php (modified) (5 diffs)

trunk/admin/links.php

@@ -54 +54 @@
     else
     {
-        if( db_res( "INSERT INTO `Links` SET `Title` = '" . $_POST['title'] . "', `URL` = '" . $_POST['URL'] . "', `Description` = '" . $_POST['desc'] . "';" ) )
+        if( db_res( "INSERT INTO `sys_links` SET `Title` = '" . $_POST['title'] . "', `URL` = '" . $_POST['URL'] . "', `Description` = '" . $_POST['desc'] . "';" ) )
         {
             echo GetActionText( 'link successfully added', 1);
@@ -91 +91 @@
     else
     {
-        if( db_res( "UPDATE `Links` SET `Title` = '" . process_db_input($_POST['title']) . "', `URL` = '" . process_db_input($_POST['URL']) . "', `Description` = '" . process_db_input($_POST['desc']) . "' WHERE `ID` = " . (int)$_POST['linkID'] . ";" ) )
+        if( db_res( "UPDATE `sys_links` SET `Title` = '" . process_db_input($_POST['title']) . "', `URL` = '" . process_db_input($_POST['URL']) . "', `Description` = '" . process_db_input($_POST['desc']) . "' WHERE `ID` = " . (int)$_POST['linkID'] . ";" ) )
         {
             echo GetActionText( 'link updated successfully', 1 );
@@ -105 +105 @@
 elseif( !$demo_mode && 'delete' == $_GET['action'] )
 {
-    if( db_res( "DELETE FROM `Links` WHERE `ID` = " . (int)$_GET['linkID'] ) )
+    if( db_res( "DELETE FROM `sys_links` WHERE `ID` = " . (int)$_GET['linkID'] ) )
     {
         echo GetActionText( 'link deleted successfully', 1 );
@@ -128 +128 @@
     global $site;
 
-    $link_query = "SELECT `ID`, `Title`, `URL`, `Description` FROM `Links`";
+    $link_query = "SELECT `ID`, `Title`, `URL`, `Description` FROM `sys_links`";
     $link_res = db_res($link_query);
 
-    $link_count = db_arr("SELECT COUNT(ID) FROM `Links`");
+    $link_count = db_arr("SELECT COUNT(ID) FROM `sys_links`");
     $link_count = $link_count['0'];
     $links_onpage = 10;
@@ -186 +186 @@
     if( $edit )
     {
-        $link_arr = db_arr( "SELECT `ID`, `Title`, `URL`, `Description` FROM `Links` WHERE `ID` = '" . (int)$linkID . "';");
+        $link_arr = db_arr( "SELECT `ID`, `Title`, `URL`, `Description` FROM `sys_links` WHERE `ID` = '" . (int)$linkID . "';");
         $value_title = htmlspecialchars($link_arr['Title']);
         $value_URL = htmlspecialchars($link_arr['URL']);