misterfade
06-21-2004, 11:03 PM
Hi,
I'm trying to design my site around Vbulletin. I know I would need to include "global.php" in all of the pages, but from what I've tested, I'm having a problem with sessions.
Right now I login to my forums, then when I go to my test page, it's supposed to be like this: "Welcome, username", but instead of showing my username, it shows the username of the 1st ID in the database.
Here's the code I'm using. What's wrong?
<?php
chdir("../forums/");
require('./global.php');
?>
<?php require_once('Connections/forums.php'); ?>
<?php
$colname_forums = "1";
if (isset($_SESSION['userid'])) {
$colname_forums = (get_magic_quotes_gpc()) ? $_SESSION['userid'] : addslashes($_SESSION['userid']);
}
mysql_select_db($database_forums, $forums);
$query_forums = sprintf("SELECT * FROM `user` WHERE userid = %s", $colname_forums);
$forums = mysql_query($query_forums, $forums) or die(mysql_error());
$row_forums = mysql_fetch_assoc($forums);
$totalRows_forums = mysql_num_rows($forums);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<?php echo $row_forums['username']; ?>
</body>
</html>
<?php
mysql_free_result($forums);
?>
Thanks.
I'm trying to design my site around Vbulletin. I know I would need to include "global.php" in all of the pages, but from what I've tested, I'm having a problem with sessions.
Right now I login to my forums, then when I go to my test page, it's supposed to be like this: "Welcome, username", but instead of showing my username, it shows the username of the 1st ID in the database.
Here's the code I'm using. What's wrong?
<?php
chdir("../forums/");
require('./global.php');
?>
<?php require_once('Connections/forums.php'); ?>
<?php
$colname_forums = "1";
if (isset($_SESSION['userid'])) {
$colname_forums = (get_magic_quotes_gpc()) ? $_SESSION['userid'] : addslashes($_SESSION['userid']);
}
mysql_select_db($database_forums, $forums);
$query_forums = sprintf("SELECT * FROM `user` WHERE userid = %s", $colname_forums);
$forums = mysql_query($query_forums, $forums) or die(mysql_error());
$row_forums = mysql_fetch_assoc($forums);
$totalRows_forums = mysql_num_rows($forums);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<?php echo $row_forums['username']; ?>
</body>
</html>
<?php
mysql_free_result($forums);
?>
Thanks.