Changeset 787 for trunk/Modules/User/Options.php

Timestamp:

Feb 7, 2014, 5:14:20 PM (10 years ago)

Author:

maron

Message:

• Added: Users tag. Means style translation names for users

File:

• trunk/Modules/User/Options.php (modified) (2 diffs)

trunk/Modules/User/Options.php

@@ -30 +30 @@
                                 '<tr><td>Upřednostněná verze klienta: </td><td>'.ClientVersionSelection($this->System->User->PreferredVersion).'</td></tr>'.
                                 '<tr><td>Veřejný text profilu:</td><td>'.
-                                '<textarea name="info" cols="60" rows="10">'.$this->System->User->Info.'</textarea></td></tr>'.
-                                '<tr><td colspan="2"><input type="submit" value="Uložit" /></td></tr>'.
+                                '<textarea name="info" cols="60" rows="10">'.$this->System->User->Info.'</textarea></td></tr>';
+        
+        
+    $Output .= '<tr><td>';
+                $Query = 'SELECT * FROM UserTagType';
+                $DbResult = $this->Database->query($Query);
+    $Output .= 'Překladatel se řídí zaškrtnutými pravidly:</td><td>';
+    while ($UserTag = $DbResult->fetch_array()) { 
+                 $Query = 'SELECT * FROM `UserTag` '.
+     //'LEFT JOIN `UserTagType` ON `UserTagType`.`ID` = `UserTag`.`UserTagType` '.
+     'WHERE `UserTagType` = '.$UserTag['ID'].' AND `User` = '.($this->System->User->Id * 1);
+                  $DbResult2 = $this->Database->query($Query);
+      if ($DbResult2->num_rows != 0) $checked = true;
+      else  $checked = false; 
+      
+      $Output .= CheckBox('Tag'.$UserTag['ID'], $checked, 'CheckBox');    
+      $Output .= ''.$UserTag['Text'].'<br />';
+    }
+    $Output .= '</td></tr>';
+    
+                $Output .= '<tr><td colspan="2"><input type="submit" value="Uložit" /></td></tr>'.
                                 '</table></fieldset>'.
                                 '</form>';
@@ -85 +104 @@
                                 } else $Output .= ShowMessage('Hesla se neshodují.', MESSAGE_CRITICAL);
                         }
+      //tag
+                $Query = 'SELECT * FROM UserTagType';
+                $DbResult = $this->Database->query($Query);
+      while ($UserTag = $DbResult->fetch_array()) { 
+       if (array_key_exists('Tag'.$UserTag['ID'], $_POST)) {
+                   $Query = 'SELECT * FROM `UserTag` '.
+         'WHERE `UserTagType` = '.$UserTag['ID'].' AND `User` = '.($this->System->User->Id * 1);
+                 $DbResult2 = $this->Database->query($Query);
+         if ($DbResult2->num_rows == 0) {
+                   $Query = 'INSERT INTO `UserTag` (`ID` ,`UserTagType`,`User` ) '.
+           'VALUES (NULL, '.$UserTag['ID'].' , '.($this->System->User->Id * 1).')';
+                 $DbResult2 = $this->Database->query($Query);
+         }
+       } else {
+                   $Query = 'DELETE FROM `UserTag` '.
+         'WHERE `UserTagType` = '.$UserTag['ID'].' AND `User` = '.($this->System->User->Id * 1);
+                     $DbResult2 = $this->Database->query($Query);
+       }
+      }
+      
                         $this->Database->update('User', '`ID` = '.$this->System->User->Id, array('Email' => $Email,
                           'Language' => $Language, 'Redirecting' => $Redirecting, 'Info' => $Info,