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

[<del...@us...>]

Revision: 98
          http://astrospaces.svn.sourceforge.net/astrospaces/?rev=98&view=rev
Author:   deltalabs
Date:     2007-08-07 10:20:03 -0700 (Tue, 07 Aug 2007)

Log Message:
-----------
Added settings table to schema and config, and added several things to the front page.

Modified Paths:
--------------
    trunk/config.php
    trunk/develop/new-schema.sql
    trunk/index.php

Modified: trunk/config.php
===================================================================
--- trunk/config.php	2007-08-07 05:34:01 UTC (rev 97)
+++ trunk/config.php	2007-08-07 17:20:03 UTC (rev 98)
@@ -21,7 +21,8 @@
    from functioning.
 */
 define('AS_TBL_USERS',    AS_DB_PREFIX.'users');
-define('AS_TBL_STATIC_PROFILE_FIELDS',    AS_DB_PREFIX.'static_profile_fields');
+define('AS_TBL_SETTINGS', AS_DB_PREFIX.'settings');
+define('AS_TBL_STATPROF', AS_DB_PREFIX.'static_profile_fields');
 define('AS_TBL_BLOG',     AS_DB_PREFIX.'blog');
 define('AS_TBL_BLOG_CMT', AS_DB_PREFIX.'blog_comment');
 define('AS_TBL_COMMENTS', AS_DB_PREFIX.'comments');

Modified: trunk/develop/new-schema.sql
===================================================================
--- trunk/develop/new-schema.sql	2007-08-07 05:34:01 UTC (rev 97)
+++ trunk/develop/new-schema.sql	2007-08-07 17:20:03 UTC (rev 98)
@@ -157,3 +157,10 @@
   `field_value` varchar(128),
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+DROP TABLE IF EXISTS `as_settings`;
+CREATE TABLE `as_settings` (
+  `setting_id` int(10) unsigned NOT NULL auto_increment,
+  `setting_name` varchar(45) NOT NULL,
+  `setting_value` varchar(45) NOT NULL,
+  PRIMARY KEY (`setting_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
\ No newline at end of file

Modified: trunk/index.php
===================================================================
--- trunk/index.php	2007-08-07 05:34:01 UTC (rev 97)
+++ trunk/index.php	2007-08-07 17:20:03 UTC (rev 98)
@@ -19,23 +19,75 @@
     @id: $Id$
 *********************************************************/
 include('globals.php');
+
 /* 5 most recent users should be enough. We can fill the rest with ads or something */
 $_query = 'SELECT user_id, display_name, user_image FROM '.AS_TBL_USER.' SORT BY user_id DESC LIMIT 5';
 $_query = $db->Execute($_query);
-while($user = $_query->FetchRow())
+while($usr = $_query->FetchRow())
 {
-    $userdetails[$user['user_id']] = array(
-		'id' => $user['user_id'],
-		'display_name' => $user['display_name'],
-		'icon' => $user['user_image']
+    $userdetails[$usr['user_id']] = array(
+		'id' => $usr['user_id'],
+		'display_name' => $usr['display_name'],
+		'icon' => $usr['user_image']
     );
 }
+
+//login stuff
+$show_login = false;
+if (!isset($_POST['email']) && isset($_POST['passwd']))
+{
+	$_query = 'SELECT user_id,password FROM ' . AS_TBL_USERS . ' WHERE email = ' . $db->qstr($_POST['email']) . ' LIMIT 1';
+	$_query = $db->Execute($_query);
+	$userlogin = $_query->FetchRow();
+	if ($_POST['passwd'] == $userlogin['password'])
+	{
+		$user->login($userlogin['user_id']);
+		$loginmessage = "Successfully logged in!";
+	}
+}
+else
+{
+	$show_login = true;
+}
+
+//show user message
+if ($user->logged_in())
+{
+	$_query = 'SELECT display_name FROM ' . AS_TBL_STATIC_PROFILE_FIELDS . ' WHERE user_id = ' . $userlogin['user_id'];
+	$_query = $db->Execute($_query);
+	$dispname = $_query->FetchRow();
+	$_query = 'SELECT setting_value FROM ' . AS_TBL_SETTINGS . " WHERE setting_name = 'user_message'";
+	$_query = $db->Execute($_query);
+	$usermessage = $_query->FetchRow();
+	$usermessage = str_replace('%displayname', $dispname['display_name'], $usermessage['setting_value']);
+}
+else
+{
+	$_query = 'SELECT setting_value FROM ' . AS_TBL_SETTINGS . " WHERE setting_name = 'anonymous_user_message'";
+	$_query = $db->Execute($_query);
+	$usermessage = $_query->FetchRow();
+	$usermessage = $usermessage['setting_value'];
+}
+
+// Show number of users
+$_query = 'SELECT count(*) FROM' . AS_TBL_USERS;
+$num_users = $db->GetOne($_query);
+
 $index = template(AS_TPL.'home.tpl');
 
+$index->define_var('loginmessage', $loginmessage);
+$index->define_var('usermessage', $usermessage);
+$index->define_var('num_users', $num_users);
+
 foreach ($userdetails as $userdetail)
 {
-	set($userdetail, 'userdetail');
-	parse_slice_to_parent('userdetail');
+	$index->set($userdetail, 'userdetail');
+	$index->parse_slice_to_parent('userdetail');
 }
+
+if ($show_login)
+{
+	parse_slice_to_parent('login_form');
+}
 $index->pparse();
 ?>
\ No newline at end of file


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