Changeset 217

Timestamp:

Jan 12, 2008, 10:40:33 PM (17 years ago)

Author:

maron

Message:

Menší úoravy

Location:

quests

Files:

• dictionary.php (modified) (2 diffs)
• includes/global.php (modified) (2 diffs)

quests/dictionary.php

@@ -9 +9 @@
 $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
 $Database->SelectDatabase($Config['Database']['Database']);    
+
+
+
+
+  function Licence($Licence)
+  { // BEGIN function Licence
+    global $Database;
+    if (isset($_SESSION['User']) and $_SESSION['User'] <> '') {
+      $User = $_SESSION['User'];
+      $Pass = $_SESSION['Pass'];
+    
+    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE LOWER(user) = LOWER('$User')"));
+    if (!$Line) {
+       return false;
+    } else {
+      if ($Licence == 1) {
+        if ($Line['gm'] == 1) {
+          return true;
+        } else return false;
+      }  
+      If ($Line['pass'] == $Pass) {
+              
+        // zapsání poslení použité IP
+    //    $Addres = $_SERVER['REMOTE_ADDR'];    
+    //    $Database->SQLCommand("UPDATE user SET LastLogin = now(), LastIP = '$Addres' WHERE user = '$User'");
+
+        return True;
+      } else { return False;
+      //  die('Nemáte zde pøístup, pøihlašte se: <a href="'.$Config['Web']['BaseURL'].'">zde</a>');
+      }
+    }
+    } else { return False;
+      //  die('Nemáte zde pøístup, pøihlašte se: <a href="'.$Config['Web']['BaseURL'].'">zde</a>');
+    }
+        
+  } // END function Licence
+
+
 
 
@@ -56 +94 @@
     echo '<tr><td><form action="dictionary.php" method="get">
           <input type="text" value="'.$Search.'" name="search" size="30">
-          <input type="submit" value="Vyhledat"> <a href="dictionary.php?insert">Vlo¾it slovo</a>
-          </form></td></tr>'; 
+          <input type="submit" value="Vyhledat">';
+    if (Licence(0))
+     echo ' <a href="dictionary.php?insert">Vlo¾it slovo</a>';
+           
+    echo '</form></td></tr>'; 
     echo '<tr><td>
     <p style="  overflow: auto;  width: 100%; height: 345px;">';

quests/includes/global.php

@@ -15 +15 @@
     $_SESSION['Pass'] = $_POST['LoginPass'];
     
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT ID FROM user WHERE user = '".$_SESSION['User']."'"));
+    $Line = mysql_fetch_array($Database->SQLCommand("SELECT ID FROM user WHERE LOWER(user) = LOWER('".$_SESSION['User']."')"));
     $_SESSION['UserID'] = $Line['ID']; 
   }
@@ -32 +32 @@
       $Pass = $_SESSION['Pass'];
     
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE user = '$User'"));
+    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE LOWER(user) = LOWER('$User')"));
     if (!$Line) {
        return false;