MyBB Community Forums

Code:

<?

//Error Reporting

error_reporting (E_ALL);

//Hi SYX. I'm fetching data directly from the forums and it updates when your profile is. Cool, right?

$dbhost = "localhost";

$dbname = "sysyoshi_forum";

$dbusername = "sysyoshi_forum";

$dbpassword = "1337";

//Tables for data fetching

$users = "mybb_users";

$fields = "mybb_userfields";

//Connect

$mysql = mysql_connect("$dbhost", "$dbusername", "$dbpassword");

mysql_select_db($dbname, $mysql);

//Query MemberBase 1

$sql1 = "SELECT * FROM $users WHERE loyalty='staff'";

$result1 = @mysql_query($sql1);

//Query MemberBase 2

$sql2 = "SELECT * FROM $fields";

$result2 = @mysql_query($sql2);

while ($rows1=@mysql_fetch_array($result1)){

?>

<h2><? echo $rows1['username']; ?></h2>

<img src="<? echo $rows1['avatar']; ?>"><br>

<b>Position:</b> <? echo $rows1['position']; ?><br>

<b>Birthdate:</b> <? echo $rows1['birthday']; ?><br>

<b>E-Mail:</b> <? echo $rows1['email']; ?><br>

<b>MSN:</b> <? echo $rows1['msn']; ?><br>

<b>AIM:</b> <? echo $rows1['aim']; ?><br>

<b>YIM:</b> <? echo $rows1['yahoo']; ?><br>

<b>ICQ:</b> <? echo $rows1['icq']; ?><br>

<?

//Okay, now let's start fetching custom profile fields stuff.

while ($rows2=@mysql_fetch_array($result2)){

?>

<b>Sprite Submissions:</b> <? echo $rows2['fid5']; ?>

<b>Gender:</b> <? echo $rows2['fid3']; ?><br>

<b>Personal Quote:</b> <? echo $rows2['fid6']; ?><br>

<b>Stuffs:</b> <? echo $rows2['fid2']; ?><br>

<b>Item of Choice:</b><? echo $rows2['fid4']; ?><br>

<?

}}

mysql_close($mysql);

?>

http://dino-productions.net/?id=staff

I want to organize it to show it for a specific User ID, but I can't get it to show for a specific User ID, because my logic is crazy.

Faltzer