[Astrospaces-commits] SF.net SVN: astrospaces: [11] trunk

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Revision: 11
          http://astrospaces.svn.sourceforge.net/astrospaces/?rev=11&view=rev
Author:   p3net
Date:     2007-03-17 09:46:30 -0700 (Sat, 17 Mar 2007)

Log Message:
-----------
-Display our space
-Add headline to the database (how did I forget that?)
-Blank edit_profile.tpl
-Edit our TODO to reflect the fact that we now have (somewhat of a) space put together

Modified Paths:
--------------
    trunk/TODO.txt
    trunk/includes/profile.php
    trunk/install/install.php
    trunk/space.php
    trunk/styles/default/edit_profile.tpl
    trunk/styles/default/space.tpl

Modified: trunk/TODO.txt
===================================================================

--- trunk/TODO.txt	2007-03-17 06:04:26 UTC (rev 10)
+++ trunk/TODO.txt	2007-03-17 16:46:30 UTC (rev 11)
@@ -1,4 +1,4 @@
 TODO:
 
---Make space.tpl (see space.php for the variables)
+--Edit space.tpl after we have all of our functions done (add comment, send PM, add friend, etc)
 --Make edit_profile.tpl (see includes/profile.php for the variables)
\ No newline at end of file

Modified: trunk/includes/profile.php
===================================================================
--- trunk/includes/profile.php	2007-03-17 06:04:26 UTC (rev 10)
+++ trunk/includes/profile.php	2007-03-17 16:46:30 UTC (rev 11)
@@ -54,7 +54,7 @@
 		}
 		//Time to insert...
 		$_query="INSERT INTO " . DB_USERS . " VALUES('', '1', '" . $var["username"] . "', '" . md5($var["password"]) .
-			"', '" . $var["email"] . "', '../default.gif', '" . $var["aim"] . "', '" . $var["msn"] . "', '" . $var["irc"] .
+			"', '', '" . $var["email"] . "', '../default.gif', '" . $var["aim"] . "', '" . $var["msn"] . "', '" . $var["irc"] .
 			"', '" . $var["icq"] . "', '" . $var["yahoo"] . "', '" . $var["website"] .", 'default', '" . time() . "');";
 		
 		//Run the query

Modified: trunk/install/install.php
===================================================================
--- trunk/install/install.php	2007-03-17 06:04:26 UTC (rev 10)
+++ trunk/install/install.php	2007-03-17 16:46:30 UTC (rev 11)
@@ -75,6 +75,7 @@
 	`user_level` int(1) NOT NULL default 1,
 	`username` text NOT NULL,
 	`password` text NOT NULL,
+	`headline` text NOT NULL,
 	`email` varchar(25) NOT NULL,
 	`icon` varchar(25) NOT NULL,
 	`aim` text,

Modified: trunk/space.php
===================================================================
--- trunk/space.php	2007-03-17 06:04:26 UTC (rev 10)
+++ trunk/space.php	2007-03-17 16:46:30 UTC (rev 11)
@@ -54,7 +54,7 @@
 //This is going to be a big JOIN query. Let's hope it works...
 $_query="SELECT " . DB_USERS . ".id, " . DB_USERS . ".username, " .
 				DB_USERS . ".theme, " . DB_USERS . ".icon" .
-				 " DB_USERS . ".last_login, " .
+				 " DB_USERS . ".last_login, " . DB_USERS . ".headline, " .
 				DB_SPACE . ".left, " . DB_SPACE . ".right , " .
 				DB_FRIENDS . ".to, " . DB_FRIENDS . ".from , ".
 				DB_FRIENDS . ".approved, " " . DB_COMMENTS .
@@ -93,6 +93,7 @@
 		$space->set('space_left', $array["left"]);
 		$space->set('space_right', $array["right"]);
 		$space->set('icon', $array["icon"]);
+		$space->set('headline', $array["headline"]);
 		
 		//Finally, increment the value of $i so we don't do this
 		//again
@@ -143,6 +144,8 @@
 $space->set('from_username', $comments_from_username); //Comment author
 $space->set('from_id', $comments_from); //Comment author ID
 $space->set('from_icon', $comments_from_icon); //Comment author icon
+$space->set('comm_content', $comments_content); //Comment content
+$space->set('time', date($comm_time)); //Comment time
 $space->set('friend', $friends_username); //Friend's Username
 $space->set('friend_id', $friends_id); //Friend's ID
 $space->set('friend_icon', $friends_icon); //Friend's Icon

Modified: trunk/styles/default/edit_profile.tpl
===================================================================
--- trunk/styles/default/edit_profile.tpl	2007-03-17 06:04:26 UTC (rev 10)
+++ trunk/styles/default/edit_profile.tpl	2007-03-17 16:46:30 UTC (rev 11)
@@ -1,8 +0,0 @@
-<html>
-  <head>
-    <title></title>
-    <meta content="">
-    <style></style>
-  </head>
-  <body></body>
-</html>
\ No newline at end of file

Modified: trunk/styles/default/space.tpl
===================================================================
--- trunk/styles/default/space.tpl	2007-03-17 06:04:26 UTC (rev 10)
+++ trunk/styles/default/space.tpl	2007-03-17 16:46:30 UTC (rev 11)
@@ -1,8 +1,36 @@
-<html>
-  <head>
-    <title></title>
-    <meta content="">
-    <style></style>
-  </head>
-  <body></body>
-</html>
\ No newline at end of file
+<div id="left">
+	<?php echo $username; ?><br>
+	"<?php echo $headline; ?>"<br>
+	<img src="uploads/<?php echo $id; ?>/<?php echo $icon; ?>"><br>
+	<!-- Links to do stuff go here -->
+	<?php echo $space_left; ?>
+</div>
+<div id="right">
+	<?php echo $space_right; ?><br>
+	<!-- BEGIN friends -->
+	<?php
+	$i=0;
+	for($i, $i<count($friends_username), $i++)
+	{ ?>
+		<a href="space.php?id=<?php echo $friend_id[$i]; ?>"><img src="/uploads/<?php echo $friend_id[$i]; ?>/<?php echo $friend_icon[$i]; ?>
+		$nbsp;<?php echo $friend[$i]; ?><br>
+	<?php } ?>
+	<!-- END friends -->
+	<!-- BEGIN comments -->
+	<table>
+	<?php
+	$i=0;
+	for($i, $i<count($from_id), $i++)
+	{ ?>
+		<tr>
+			<td>
+				<a href="space.php?id=<?php echo $from_id[$i]; ?>"><?php echo $from_username[$i]; ?></a><br>
+				<?php echo $time[$i]; ?><br>
+				<img src="/uploads/<?php echo $from_id[$i]; ?>/<?php echo $from_icon[$i]; ?>">
+			</td>
+			<td>
+				<?php echo $comm_content[$i]; ?>
+			</td>
+		</tr>
+	<?php } ?>
+</div>
\ No newline at end of file


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


