[SASHA-Code] SF.net SVN: sasha:[76] trunk/SASHA

[<gph...@us...>]

Revision: 76
          http://sasha.svn.sourceforge.net/sasha/?rev=76&view=rev
Author:   gphemsley
Date:     2009-12-30 22:48:00 +0000 (Wed, 30 Dec 2009)

Log Message:
-----------
Add ability to keep track of user registration date.
Make usernames case-insensitive.
Add rounded corners for tabs, buttons, and headers (in browsers that support them).
Clean up some redundant CSS.

Modified Paths:
--------------
    trunk/SASHA/inc/lib/lib.sessions.php
    trunk/SASHA/inc/lib/lib.user.php
    trunk/SASHA/style/default/screen.css

Modified: trunk/SASHA/inc/lib/lib.sessions.php
===================================================================
--- trunk/SASHA/inc/lib/lib.sessions.php	2009-11-21 21:55:46 UTC (rev 75)
+++ trunk/SASHA/inc/lib/lib.sessions.php	2009-12-30 22:48:00 UTC (rev 76)
@@ -323,7 +323,7 @@
 
 		$sql = "SELECT user_id, username, password
 			FROM users
-			WHERE username = '" . $Database->escape( $username ) . "'";
+			WHERE username = '" . $Database->escape( strtolower( $username ) ) . "'";
 
 		$result = $Database->query( $sql );
 

Modified: trunk/SASHA/inc/lib/lib.user.php
===================================================================
--- trunk/SASHA/inc/lib/lib.user.php	2009-11-21 21:55:46 UTC (rev 75)
+++ trunk/SASHA/inc/lib/lib.user.php	2009-12-30 22:48:00 UTC (rev 76)
@@ -260,8 +260,8 @@
 			return FALSE;
 		}
 
-		$sql = "INSERT INTO users ( username, password, email_address, full_name, preferred_name, default_institution )
-			VALUES ( '" . $Database->escape( $username ) . "', '" . sha1( $password ) . "', '" . $Database->escape( $email_address ) . "', '" . $Database->escape( $full_name ) . "', '" . $Database->escape( $preferred_name ) . "', '" . $Database->escape( $default_institution ) . "' )";
+		$sql = "INSERT INTO users ( username, password, email_address, full_name, preferred_name, default_institution, registration_date, user_type )
+			VALUES ( '" . $Database->escape( strtolower( $username ) ) . "', '" . sha1( $password ) . "', '" . $Database->escape( $email_address ) . "', '" . $Database->escape( $full_name ) . "', '" . $Database->escape( $preferred_name ) . "', '" . $Database->escape( $default_institution ) . "', " . time() . ', ' . UT_STUDENT . ' )';
 
 		if( $result = $Database->query( $sql ) )
 		{

Modified: trunk/SASHA/style/default/screen.css
===================================================================
--- trunk/SASHA/style/default/screen.css	2009-11-21 21:55:46 UTC (rev 75)
+++ trunk/SASHA/style/default/screen.css	2009-12-30 22:48:00 UTC (rev 76)
@@ -153,11 +153,17 @@
 /**
 * Header on every page
 */
-div#header {
+#header {
 	background-color: #660066;
 	color: white;
 	width: 96%;
 	margin: auto;
+	border-top-left-radius: 1%;
+	border-top-right-radius: 1%;
+	-moz-border-radius-topleft: 1%;
+	-moz-border-radius-topright: 1%;
+	-webkit-border-top-left-radius: 1%;
+	-webkit-border-top-right-radius: 1%;
 	padding: 0.5em 0em;
 	text-align: center;
 }
@@ -220,6 +226,12 @@
 	padding: 0em;
 	height: 100%;
 	border: 1px solid black;
+	border-top-left-radius: 1em;
+	border-top-right-radius: 1em;
+	-moz-border-radius-topleft: 1em;
+	-moz-border-radius-topright: 1em;
+	-webkit-border-top-left-radius: 1em;
+	-webkit-border-top-right-radius: 1em;
 	background-color: #FF99FF;
 	color: black;
 }
@@ -228,6 +240,12 @@
 	height: 100%;
 	width: 100%;
 	margin: 0px;
+	border-top-left-radius: 1em;
+	border-top-right-radius: 1em;
+	-moz-border-radius-topleft: 1em;
+	-moz-border-radius-topright: 1em;
+	-webkit-border-top-left-radius: 1em;
+	-webkit-border-top-right-radius: 1em;
 	padding: 0em 2em;
 }
 
@@ -264,6 +282,9 @@
 	padding: 0.5em 0em;
 	height: 100%;
 	border: 1px solid black;
+	border-radius: 0.5em;
+	-moz-border-radius: 0.5em;
+	-webkit-border-radius: 0.5em;
 	background-color: #FFDDFF;
 	color: black;
 }
@@ -272,6 +293,9 @@
 	height: 100%;
 	width: 100%;
 	margin: 0px;
+	border-radius: 0.5em;
+	-moz-border-radius: 0.5em;
+	-webkit-border-radius: 0.5em;
 	padding: 0.5em 2em;
 }
 
@@ -407,35 +431,35 @@
 /**
 * Footer on every page
 */
-div#copyright, div#debug {
+#copyright, #debug {
 	clear: both;
 	text-align: center;
 	margin: auto;
 	padding-top: 1em;
 }
 
-div#copyright {
+#copyright {
 	font-size: small;
 }
 
-div#debug {
+#debug {
 	font-size: x-small;
 }
 
-div#copyright p, div#debug p {
+#copyright p, #debug p {
 	margin: 0px;
 }
 
 /**
 * Home page styling (task lists)
 */
-div#left-column, div#center-column, div#right-column {
+#left-column, #center-column, #right-column {
 	float: left;
 	width: 31.698%;
 	border-left: 1px solid #7F007F;
 	padding: 0% 0.75%;
 }
 
-div#right-column {
+#right-column {
 	float: right;
 }
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.