June 7th, 2004, 10:47 PM
|
|
Registered User
|
|
Join Date: Dec 2002
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
PHP League CMS
Hello all, I am new to the devArticles community but I have been stuck on this problem for a long time and figured that you guys might be able to help me. I have been trying to program a League system for a league me and my buddies are creating. Here is what I wish it to do.
- Register a user
- Password Recovery
- Let a registered user create a team.
- Other users may join the team with a team password
- With each team created a private fourm is created for them. (Can be real simple right now like ez board).
- Teams can challenge each other with conformation from both teams on a date and time.
- Teams report losses
- Team stats
- Ladder stats
- More to come.
My problem right now is with the templating. I want to create like blocks like phpnuke but I am having trouble doing that. I also am really uncetin about using the cookies like how some of the cms systems have cookies collum in the database, I have no clue what that is for.
Here is what I have:
includeme.php
PHP Code:
<?php
session_start();
define("MODULE", "modules/");
define("CORE", "core/");
define("USER", MODULE."core_users/");
define("THEME","themes/SobTribe/");
include(CORE."class.db.php");
include(USER."user.functions.php");
include(THEME."theme.php");
include(CORE."theme.functions.php");
include(CORE."core.menu.php");
$dblink = new db("DATABASE","SERVER","USER","PASSWORD");
//global $dblink;
?>
modules.php
PHP Code:
<?php
include("includeme.php");
themeheader();
OpenTable2();
print ("<font class=\"title\">".themeGetTitle($_GET['page'])."</font>");
CloseTable2();
echo "<br />";
OpenTable();
if(file_exists("modules/$_GET[module]/$_GET[page].php"))
{
include("modules/$_GET[module]/$_GET[page].php");
}
else
{
echo $_GET['module'];
die("Error finding module");
}
CloseTable();
echo "<br />";
echo "<br />";
themefooter();
?>
core/class.db.php
PHP Code:
<?php
class db
{
var $db_name;
var $db_server;
var $db_user;
var $db_password;
function db($dbName, $dbServer, $dbUser, $dbPassword)
{
$this->db_name = $dbName;
$this->db_server = $dbServer;
$this->db_user = $dbUser;
$this->db_password = $dbPassword;
mysql_connect($this->db_server,$this->db_user,$this->db_password)
or die("Could not connect to the mySQL server.");
mysql_select_db($this->db_name)
or die("Could not select the database. Reason: ".mysql_error());
}
function dbInsert($dbTable, $dbField, $dbValue)
{
/*
$dbref_arg = $dbField[0];
$dbref_condition = $dbValue[0];
$Field = $dbField[0];
$Value = addslashes($dbValue[0]);
$sql = "INSERT INTO $dbTable (`$Field`) VALUES('$Value')";
//echo "<br />".$sql."<br />";
mysql_query($sql) or die(mysql_error());
for($counter=1; $counter != count($dbField); $counter++)
{
$Field = $dbField[$counter];
$Value = addslashes($dbValue[$counter]);
$sql = "UPDATE $dbTable SET $Field='$Value' WHERE $dbref_arg = '$dbref_condition'";
//echo $sql;
mysql_query($sql) or die(mysql_error());
}*/
$sql = "INSERT INTO $dbTable (";
$sql .= $dbField[0];
for($counter=1;$counter != count($dbField); $counter++)
{
$sql .= ",".$dbField[$counter];
}
$sql .= ") VALUES (";
$sql .= "'".$dbValue[0]."'";
for($counter=1;$counter != count($dbField); $counter++)
{
$sql .= ",'".$dbValue[$counter]."'";
}
$sql .= ")";
//echo $sql."<br /><br /><br />";
mysql_query($sql) or die(mysql_error());
}
function dbUpdate($dbTable, $dbField, $dbValue, $arg, $condition)
{
/*
for($counter=0;$counter != count($dbField)+1; $counter++)
{
if($arg==$dbField[$counter] && $counter != count($dbField))
{
$last_field = $dbField[$counter];
$last_value = addslashes($dbValue[$counter]);
$counter++;
}
else if($counter = count($dbField) && isset($last_field) && isset($last_value))
{
$sql = "UPDATE $dbTable SET $last_field = '$last_value' WHERE $arg='$condition'";
mysql_query($sql) or die(mysql_error());
$last=true;
}
if($last != true)
{
$Field = $dbField[$counter];
$Value = addslashes($dbValue[$counter]);
$sql = "UPDATE $dbTable SET $Field='$Value' WHERE $arg = '$condition'";
mysql_query($sql) or die(mysql_error());
}
}
*/
$sql = "UPDATE $dbTable SET ".$dbField[0]." = '".$dbValue[0]."'";
for($counter=1; $counter != count($dbField); $counter++)
{
$sql .= " , ".$dbField[$counter]." = '".$dbValue[$counter]."'";
}
$sql .= " WHERE $arg='$condition'";
//echo $sql."<br /><br />";
mysql_query($sql) or die(mysql_error());
}
function dbDelete($dbTable, $arg, $condition)
{
$sql = "DELETE FROM $dbTable WHERE $arg='$condition'";
//echo $sql;
mysql_query($sql) or die(mysql_error());
}
}
?>
core/core.menu.php
PHP Code:
<?php
function blocks($pos)
{
$sql = "SELECT * FROM core_blocks WHERE position='$pos'";
$blocks = mysql_query($sql);
while($blocksrow = mysql_fetch_array($blocks))
{
OpenTable2();
echo "<font class=\"title\">".$blocksrow[name]."</font>";
CloseTable2();
$sql ="SELECT * FROM core_pages WHERE block_id='$blocksrow[id]' ORDER BY block_weight AND name";
$pages= mysql_query($sql);
OpenTable();
while($pagesrow = mysql_fetch_array($pages))
{
echo "<a href='modules.php?module=".$pagesrow[module]."&page=".$pagesrow[page]."'>".$pagesrow[name]."</a><br />";
//echo $pagesrow[name];
//echo count($blocks);
}
CloseTable();
}
}
?>
modules/core_users/user.functions.php
PHP Code:
<?php
function user_login($userUserName, $userUserPassword)
{
$userUserName = addslashes($userUserName);
$userUserPassword = md5($userUserPassword);
$sql = "SELECT * FROM core_users WHERE user_name='$userUserName' AND password='$userUserPassword'";
$user = mysql_query($sql);
if(mysql_num_rows($user) < 1)
{
return false;
}
$user = mysql_fetch_array($user);
return $user;
}
//Checks to see if the username is avalible in the database
function user_checkname($userUserName)
{
$sql = "SELECT * FROM core_users WHERE user_name='$userUserName'";
$check = mysql_num_rows(mysql_query($sql));
if($check < 1)
{
return true;
}
if($check > 1)
{
return false;
}
return false;
}
function user_checksteamid($userSteamID)
{
$sql = "SELECT * FROM core_users WHERE steam_id='$userSteamID'";
$check = mysql_num_rows(mysql_query($sql));
if($check < 1)
{
return true;
}
if(check > 1)
{
return false;
}
return false;
}
//Checks to see if the email is avalible in the database
function user_checkemail($userEmail)
{
$sql = "SELECT * FROM core_users WHERE email='$userEmail'";
$check = mysql_num_rows(mysql_query($sql));
if($check < 1)
{
return true;
}
if($check > 1)
{
return false;
}
return false;
}
//Gets the user
function user_get($userName, $userPassword)
{
$user['username']=addslashes($userName);
$user['password']=addslashes(md5($userPassword));
$sql = "SELECT * ";
$sql .= "FROM core_users ";
$sql .= "WHRE user_name='$user[username]' AND password='$user[password]'";
return mysql_fetch_assoc(mysql_query($sql));
}
function user_new(&$dblink, $userUserName, $userPassword, $userPasswordCheck, $userEmail, $userShowEmail, $userSteamID)
{
$newuser[0]=addslashes($userUserName);
$newuser[1]=addslashes(md5($userPassword));
$newuser[2]=addslashes($userEmail);
$newuser[3]=$userShowEmail;
$newuser[4]=$userSteamID;
$error=false;
if($userUserName > 5 || $userUserName == '' || !user_checkname($userUserName))
{
echo"Please fix your username: ".$userUserName."<br />";
/*
if($user['username' > 5)
{
echo "Username must be larger then 5 characters\n";
}
if($user['username'] == '')
{
echo "Please enter a username\n";
}
if(!user_checkname($userUserName))
{
echo "Username has already been taken";
}
*/
$error = true;
}
if($userEmail == '' || !user_checkemail($userEmail))
{
echo"Please fix your email: ".$userEmail."<br />";
$error = true;
}
if($userPassword == '' || $userPasswordCheck == '' || $userPassword != $userPasswordCheck)
{
echo"Please fix your password: <br />";
$error = true;
}
if($userSteamID == '' || !user_checksteamid($userSteamID))
{
echo "Please fix you Steam ID: ".$userSteamID."<br />";
$error = true;
}
if($error == true)
{
return false;
}
/*
$sql = "INSERT INTO core_users (user_name, password, email, hide_email) ";
$sql .="VALUES('$user[username]', $user[password], $user[email], $user[showemail]";
mysql_query($sql) or die("Can not add new user!\n");*/
$user = array("user_name",
"password",
"email",
"hide_email",
"steam_id");
$dblink->dbInsert("core_users", $user, $newuser);
return true;
}
function user_newuser_form()
{
include("user_new.inc.php");
}
function user_newuser_page()
{
include("user_new.php");
}
function user_loggin_form()
{
include("user_login.inc.php");
}
?>
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
