Alright i might be right about this.
So Would i need to make a database based on the user fields example:
<?php
/**
* vuBB
* Copyright 2005-2006 the vuBB Group
*
* http://www.vubb.com/
* http://community.vubb.com/
*/
// Get info for member info display
$member_info = mysql_fetch_array(mysql_query("SELECT * FROM `members` WHERE `id` = '" . intval($_GET['m']) . "'"));
if (!$member_info['user'])
{
redirect(-1);
error($lang['title']['invalid_member'], $lang['text']['member_doesnt_exist']);
}
// et rid of slashes from database for output
$member_info['user'] = stripslashes($member_info['user']);
$member_info['sig'] = stripslashes($member_info['sig']);
$member_info['avatar_link'] = $member_info['avatar_link'] ? stripslashes($member_info['avatar_link']) : $lang['text']['no_avatar'];
$member_info['location'] = $member_info['location'] ? stripslashes($member_info['location']) : $lang['text']['na'];
$member_info['website'] = $member_info['website'] ? stripslashes($member_info['website']) : $lang['text']['na'];
// Post count.
$post_sql = mysql_query("SELECT id FROM forum_replies WHERE starter_id='".$member_info["id"]."'");
$post_sql2 = mysql_query("SELECT id FROM forum_topics WHERE starter_id='".$member_info["id"]."'");
$member_info['posts'] = mysql_num_rows($post_sql)+mysql_num_rows($post_sql2);
// Group.
$group_sql = mysql_fetch_array(mysql_query("SELECT name FROM groups WHERE id='".$member_info["group"]."'"));
$member_info['group'] = $group_sql['name'];
if ($stat['id'] > 0) {
$member_info['aim'] = $member_info['aim'] ? stripslashes($member_info['aim']) : $lang['text']['na'];
$member_info['msn'] = $member_info['msn'] ? stripslashes($member_info['msn']) : $lang['text']['na'];
$member_info['yahoo'] = $member_info['yahoo'] ? stripslashes($member_info['yahoo']) : $lang['text']['na'];
$member_info['icq'] = $member_info['icq'] ? stripslashes($member_info['icq']) : $lang['text']['na'];
} else {
$member_info['aim'] = $member_info['msn'] = $member_info['yahoo'] = $member_info['icq'] = $lang['text']['login_to_view'];
}
// Signature - only if there is one.
$signature_box = '';
if (!empty($member_info['sig'])) {
$member_info['sig'] = postify($member_info['sig']);
$signature_box = eval(get_template('member_signature'));
}
addnav($lang['text']['viewing_profile'].' ', makeurl('member', intval($_GET['m'])));
echo eval(get_template('breadcrumb'));
echo eval(get_template('member'));
?>
as you can see from this it has somthen called member_info
where is this info coming from is my question so from this line:
$member_info = mysql_fetch_array(mysql_query("SELECT * FROM `members` WHERE `id` = '" . intval($_GET['m']) . "'"));
where is the varible hetting its information from so it outputs the code on te Bulliten Board..
would i have to make a mysql query for it? like this:
CREATE TABLE `lumos_users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(40) NOT NULL,
`registered` int(10) NOT NULL,
`last_action` int(10) NOT NULL,
`ip` varchar(20) NOT NULL,
`cookie` varchar(40) NOT NULL,
`email` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`) )