BUGFIX: diamond was added twice in defining the sorting order for the cards
[e-DoKo.git] / include / register.php
index 88b13a235e967ffc64992d81b749702444707d5c..03be8038cda9a04c02403fc253e3f78446a1426a 100644 (file)
@@ -22,10 +22,10 @@ if(myisset("Rfullname","Remail","Rpassword","Rtimezone") )
       }
     if($ok)
       {
-       $r=mysql_query("INSERT INTO User VALUES(NULL,".DB_quote_smart($_REQUEST["Rfullname"]).
-                      ",".DB_quote_smart($_REQUEST["Remail"]).
-                      ",".DB_quote_smart(md5($_REQUEST["Rpassword"])).
-                      ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL,NULL)"); 
+       $r=DB_query("INSERT INTO User VALUES(NULL,".DB_quote_smart($_REQUEST["Rfullname"]).
+                   ",".DB_quote_smart($_REQUEST["Remail"]).
+                   ",".DB_quote_smart(md5($_REQUEST["Rpassword"])).
+                   ",".DB_quote_smart($_REQUEST["Rtimezone"]).",NULL,NULL)"); 
        
        if($r)
          {
@@ -63,13 +63,9 @@ if(myisset("Rfullname","Remail","Rpassword","Rtimezone") )
               </tr><tr>
               <td><label for="Rtimezone">Timezone:</label></td>
                <td>
-                 <select id="Rtimezone" name="Rtimezone" size="1">
-                     <option value="Europe/London">Berlin</option>
-                     <option value="Europe/Berlin">Berlin</option>
-                     <option value="America/Vancouver">Berkeley</option>
-                     <option value="Pacific/Auckland">Wellington</option>
-                 </select>
-                (If your timezone is not listed, just select whatever you want and email the admin your correct time zone.)
+<?php
+               output_select_timezone("Rtimezone");
+?>
               </td>
               </tr><tr>
                <td colspan="2"> <input type="submit" value="register" /></td>