Changeset 510 for trunk/admin

Timestamp:

Feb 15, 2013, 11:02:13 PM (12 years ago)

Author:

chronos

Message:

• Přidáno: Novinky na webu nyní mají titulek. U starých novinek se nastaví jako titulek jméno uživatele, jako to bylo dříve.

Location:

trunk/admin

Files:

• UpdateTrace.php (modified) (1 diff)
• index.php (modified) (2 diffs)
• install.php (modified) (1 diff)

trunk/admin/UpdateTrace.php ¶

@@ -2395 +2395 @@
 }
 
+function UpdateTo510($Manager)
+{      
+  global $System;
+  
+  $Manager->Execute('ALTER TABLE `News` ADD `Title` VARCHAR( 255 ) NOT NULL AFTER `Time`');
+  $Manager->Execute('UPDATE `News` SET `Title` = (SELECT `Name` FROM `User` AS `T` WHERE `T`.`ID` = `User`)');
+}
+
 $Updates = array(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
+        506 => array('Revision' => 510, 'Function' => 'UpdateTo510'),
 );
 

trunk/admin/index.php ¶

@@ -31 +31 @@
   
   $Output = '<form action="?action=addnew" method="POST">'.
-  'Uživatel: '.$User->Name.'('.$User->Id.')<br/> '.
+  'Uživatel: '.$User->Name.'('.$User->Id.')<br/> '.  
+  'Nadpis: <input type="text" name="title" size="40"/><br/>'.
+  'Obsah: <textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="Text" name="text"></textarea><br/>'.
   '<input type="submit" value="Uložit"/><br/>'.
-  '<textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="Text" name="text"></textarea>'.
   '</form>';
   return($Output);
@@ -42 +43 @@
   global $System, $Config, $User;
   
-  if(array_key_exists('text', $_POST)) 
+  if(array_key_exists('text', $_POST) and array_key_exists('title', $_POST)) 
   {
-    $querty = 'INSERT INTO `News` ( `Time` ,`User` ,`Text`) VALUES ( NOW( ) , '.$User->Id.', "'.$_POST['text'].'")';
+    $querty = 'INSERT INTO `News` (`Title`, `Time` ,`User` ,`Text`) VALUES ( "'.$_POST['title'].'", NOW( ) , '.
+      $User->Id.', "'.$_POST['text'].'")';
     $System->Database->query($querty);
     $Output = ShowMessage('Aktualita uložena.');

trunk/admin/install.php ¶

@@ -3 +3 @@
 $StopAfterUpdateManager = true;
 include_once('../includes/global.php');
-include_once('../sql/UpdateTrace.php');
+include_once('UpdateTrace.php');
 $UpdateManager->Trace = $Updates;
 $UpdateManager->InstallMethod = 'FullInstall';