*

***************************************************************************/

//

//

// Find Users real IP (if possible)

$user_ip = ($HTTP_X_FORWARDED_FOR) ? $HTTP_X_FORWARDED_FOR : $REMOTE_ADDR;

include('includes/functions.'.$phpEx);

include('includes/db.'.$phpEx);

// Setup forum wide options.

// This is also the first DB query/connect

$sql = "SELECT *

FROM ".CONFIG_TABLE."

if(!$result = $db->sql_query($sql))

{

$template = new Template("templates/Default");

error_die(SQL_QUERY, "Could not query config information.", __LINE__, __FILE__);

}

else

{

$config = $db->sql_fetchrow($result);

}

// Initialise user settings on page load

function init_userprefs($userdata)

{

{

if(($userdata['user_id'] != ANONYMOUS || $userdata['user_id'] != DELETED) && $userdata['user_theme'])

{

}

else

{

}

}

else

{

}

if($userdata['user_lang'] != '')

{

}

if($userdata['user_dateformat'] != '')

{

}

if(isset($userdata['user_timezone']))

{

}

// Setup user's Template

if($userdata['user_template'] != '')

}

else

{

}

{

}

else

{

}

return;

}

function setuptheme($theme)

{

global $db;

if(!$result = $db->sql_query($sql))

{

//

// Do timezone text output

//

{

}

{

$s_timezone = "$l_all_times GMT";

}

else

{

}

//

$sql = "SELECT u.username, u.user_id, s.session_logged_in

FROM ".USERS_TABLE." u, ".SESSIONS_TABLE." s

WHERE u.user_id = s.session_user_id

$result = $db->sql_query($sql);

if(!$result)

{

$userlist = ($logged_online > 0) ? "$l_Registered $l_r_user_s: " . $userlist : "$l_Registered $l_r_user_s: $l_None";

$template->assign_vars(array(

"PHPEX" => $phpEx,

"PHPSELF" => $PHP_SELF,

"L_AUTO_LOGIN" => $l_autologin,

"L_AUTHOR" => $l_author,

"L_MESSAGE" => $l_message,

"L_LOGIN_LOGOUT" => $l_login_logout,

"U_REGISTER" => "profile.".$phpEx."?mode=register",

"U_PROFILE" => "profile.".$phpEx."?mode=editprofile",

"U_PRIVATEMSGS" => "priv_msgs.".$phpEx."?mode=read",

$template->assign_vars(array(

"FORUM_ID" => $forum_id,

"FORUM_NAME" => $forum_name,

$template->pparse("header");

break;

"FORUM_NAME" => $forum_name,

"TOPIC_ID" => $topic_id,

"TOPIC_TITLE" => $topic_title,

$template->pparse("header");

break;

break;

case 'register':

{

$template->set_filenames(array(

"body" => "agreement.tpl"));

$template->assign_vars(array(

break;

}

//

if($userdata['session_logged_in'])

{

}

$current_time = time();

$template->pparse("overall_footer");

( $category_rows[$i]["cat_id"] == $viewcat) )

{

$posts = $forum_rows[$j]["forum_posts"];

$topics = $forum_rows[$j]["forum_topics"];

if($forum_rows[$j]["username"] != "" && $forum_rows[$j]["post_time"] > 0)

{

$last_post = $last_post_time."<br>by ";

$last_post .= "<a href=\"profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$forum_rows[$j]["user_id"];

}

else

{

// Members and profile

$l_reginfo = "Registration Information";

$l_profile = "Profile";

$l_register = "Register";

$l_onlyreq = "Only requried if being changed";

$l_location = "From";

$l_url = "URL";

$l_icq = "ICQ";

$l_icqadd = "Add";

$l_icqpager = "Pager";

$l_aim = "AIM";

$l_userdisallowed= "The $l_username you picked has been disallowed by the administrator. $l_tryagain";

$l_infoupdated = "Your Information has been updated";

$l_publicmail = "Allow other users to view my $l_emailaddress";

$l_nouserid = "You must supply a user ID number in order to view profile data.";

$l_viewingprofile = "Viewing profile of ";

$l_hidden = "hidden";

$l_boardtemplate = "Select Template";

// Viewforum

";

$l_coppa = "Your account has been created, however in complance with the COPPA act you must print out this page and have you parent or guardian mail it to: <br>$l_mailingaddress<br>Or fax it to: <br>$l_faxinfo<br> Once this information has been recived your account will be activated by the administrator and you will recive and email notification.";

$l_welcomesubj = "Welcome to $sitename Forums";

$l_welcomesubj,

Please keep this email for your records.

Thank you for registering.

";

$l_welcomesubj,

Please keep this email for your records.

Thank you for registering.

";

$l_beenadded = "You have been added to the database.";

Have a nice day.

$l_quotemsg = '[quote]\nOn $m[post_time], $m[username] wrote:\n$text\n[/quote]';

$l_passsubj = "$sitename Forums Password Change";

You are receiving this email because you (or someone pretending to be you)

has requested a passwordchange on $sitename forums. If you believe you have

received this message in error simply delete it and your password will remain

Thank you for using $sitename Forums

$l_passsent = "Your password has changed to a new, random, password. Please check your email on how to complete the password change procedure.";

$l_emailpass = "Email Lost Password";

$l_autologin = "Log me on automatically each visit";

$l_resend_password = "I have forgotten my password";

"body" => "login_body.tpl",

)

);

{

$forward_page .= "?mode=".$mode;

}

}

"L_USERNAME" => $l_username,

"L_VIEW_USERS_POSTS" => $l_view_users_posts,

"L_JOINED" => $l_joined,

"POSTS_PER_DAY" => $posts_per_day,

"L_PER_DAY" => $l_per_day,

"POSTS" => $profiledata['user_posts'],

$page_title = "$l_register";

include('includes/page_header.'.$phpEx);

break;

case 'register':

$allowbbcode = $HTTP_POST_VARS['allowbbcode'];

$allowsmilies = $HTTP_POST_VARS['allowsmilies'];

list($hr, $min, $sec, $mon, $day, $year) = explode(",", gmdate("H,i,s,m,d,Y", time()));

$regdate = gmmktime($hr, $min, $sec, $mon, $day, $year);

$page_title = "$l_register";

include('includes/page_header.'.$phpEx);

{

$template->pparse("body");

include('includes/page_tail.'.$phpEx);

}

else

{

{

$error = FALSE;

if(empty($username) || empty($password) || empty($password_confirm) || empty($email))

}

}

{

//

// The AUTO_INCREMENT field in MySQL v3.23 doesn't work

(user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_desmile, user_html, user_bbcode, user_timezone, user_dateformat, user_lang, user_template, user_theme, user_active, user_actkey)

VALUES

('$new_user_id', '$username', '$regdate', '$md_pass', '$email', '$icq', '$website', '$occupation', '$location', '$interests', '$signature', '$viewemail', '$aim', '$yim', '$msn', '$attachsig', '$allowsmilies', '$allowhtml', '$allowbbcode', '$user_timezone', '$user_dateformat', '$user_lang', '$user_template', '$user_theme', ";

{

$act_key = generate_activation_key();

$sql .= "0, '$act_key')";

$coppa = FALSE;

}

{

}

$template->assign_vars(array(

"MODE" => $mode,

"USERNAME" => $username,

$template->pparse("body");

include('includes/page_tail.'.$phpEx);

case 'activate':

$sql = "SELECT user_id

FROM ".USERS_TABLE."

WHERE user_actkey = '$act_key'";

<!-- BEGIN topicrow -->

<tr bgcolor="#DDDDDD" class="tablebody">

<td width="5%" align="center" valign="middle">{topicrow.FOLDER}</td>

<td width="5%" align="center" valign="middle">{topicrow.VIEWS}</td>

<!-- END topicrow -->

</table>

</td>

<td>

<table border="0" width="100%" bgcolor="#CCCCCC" cellpadding="1" cellspacing="1">

<tr>

</tr>

</table>

</td>

<table border="0" width="100%" bgcolor="#CCCCCC" cellpadding="1" cellspacing="1">

<tr>

<td align="right" style="{font-size: 8pt;}">

<img src="images/newpost.jpg" height="50" width="250" alt="Post New Topic" border="0">

</a>

</td>

<tr>

<td>

<table border="0" width="100%" cellpadding="3" cellspacing="1">

</tr>

</table>

</td>

<td width="90%" class="tablebody" bgcolor="#CCCCCC"><table width="100%" cellspacing="0" cellpadding="0" border="0">

<tr>

<td align="left" nowrap><b>{S_TIMEZONE}</b></td>

</tr>

</table></td>

</tr>

</table>

</td>

<table border="0" width="100%" bgcolor="#CCCCCC" cellpadding="1" cellspacing="1">

<tr>

<td align="left" style="{font-size: 8pt;}">

<img src="images/newpost.jpg" height="50" width="125" alt="Post New Topic" border="0"></a>&nbsp;

<img src="images/reply.jpg" height="50" width="125" alt="Reply to this topic" border="0">

</a>

</td>

<table border="0" width="100%" bgcolor="#CCCCCC" cellpadding="1" cellspacing="1">

<tr>

<td align="left" valign="bottom" style="{font-size: 8pt; height: 55px;}" nowrap>

</td>

</tr>

</table>

<table border="0" width="100%" bgcolor="#CCCCCC" cellpadding="1" cellspacing="1">

<tr>

<td align="right" style="{font-size: 8pt;}">

</td>

</tr>

</table>

include('extension.inc');

include('common.'.$phpEx);

//

// Obtain which forum id is required

//

$forum_id = ($HTTP_GET_VARS['forum']) ? $HTTP_GET_VARS['forum'] : $HTTP_POST_VARS['forum'];

}

//

// If not give them a nice error page.

if(isset($forum_id))

{

$sql = "SELECT f.forum_type, f.forum_name, f.forum_topics, u.username, u.user_id

error_die(GENERAL_ERROR, "You have reached this page in error, please go back and try again");

}

if(!$result = $db->sql_query($sql))

{

error_die(SQL_QUERY, "Couldn't obtain forums information.", __LINE__, __FILE__);

}

//

// Add checking for private forums here!!

//

$forum_row = $db->sql_fetchrowset($result);

if(!$forum_row)

$topics_count = $forum_row[0]["forum_topics"];

for($x = 0; $x < $db->sql_numrows($result); $x++)

{

}

if(!isset($start))

{

}

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time

LEFT JOIN " . USERS_TABLE . " u2 ON p.poster_id = u2.user_id

WHERE t.forum_id = '$forum_id'

ORDER BY topic_time DESC

if(!$t_result = $db->sql_query($sql))

{

error_die(SQL_QUERY, "Couldn't obtain topic information.", __LINE__, __FILE__);

}

if($total_topics)

{

else

}

}

else

{

include('common.'.$phpEx);

include('includes/bbcode.'.$phpEx);

if(!isset($HTTP_GET_VARS['topic'])) // For backward compatibility

{

$topic_id = $HTTP_GET_VARS[POST_TOPIC_URL];

// Add checking for private forums here

//

if(!isset($start))

{

AND (r.rank_special = 1)

WHERE p.topic_id = '$topic_id'

ORDER BY p.post_time ASC

if(!$result = $db->sql_query($sql))

{

error_die(SQL_QUERY, "Couldn't obtain post/user information.", __LINE__, __FILE__);

$postrow = $db->sql_fetchrowset($result);

$ranksrow = $db->sql_fetchrowset($ranksresult);

for($x = 0; $x < $total_posts; $x++)

{

$poster = stripslashes($postrow[$x]["username"]);

$poster_id = $postrow[$x]["user_id"];

$poster_posts = $postrow[$x]["user_posts"];

$poster_from = ($postrow[$x]["user_from"]) ? "$l_from: ".$postrow[$x]["user_from"] : "";

if($poster_id != ANONYMOUS && $poster_id != DELETED)

{

if(!$postrow[$x]["rank_title"])

$poster_rank = "";

}

if($postrow[$x]["user_icq"])

{

$icq_status_img = "<a href=\"http://wwp.icq.com/".$postrow[$x]["user_icq"]."#pager\"><img src=\"http://online.mirabilis.com/scripts/online.dll?icq=".$postrow[$x]["user_icq"]."&img=5\" alt=\"$l_icqstatus\" border=\"0\"></a>";

}

else

{

$icq_add_img = "";

}

if($is_moderator)

{

}

$message = stripslashes($postrow[$x]["post_text"]);

$bbcode_uid = $postrow[$x]['bbcode_uid'];

$user_sig = stripslashes($postrow[$x]['user_sig']);

{

$user_sig = strip_tags($user_sig);

$message = strip_tags($message);

}

{

// do bbcode stuff here

$sig_uid = make_bbcode_uid();

$message = eregi_replace("\[addsig]$", "<br />_________________<br />" . nl2br($user_sig), $message);

"POSTER_NAME" => $poster,

"POSTER_RANK" => $poster_rank,

"RANK_IMAGE" => $rank_image,

"DELPOST_IMG" => $delpost_img));

}

{

$times = 0;

{

$times++;

}

$times = 1;

$pagination = "$l_gotopage (";

if($start > 0)

{

}

{

if($times != 1)

{

}

else

{

}

$times++;

}

{

}

$pagination .= " )";

}

else

{

}

"PAGINATION" => $pagination));

$template->pparse("body");