privmsgs_bbcode_uid int4 DEFAULT '0' NOT NULL,

CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id)

);

/* --------------------------------------------------------

}

}

{

global $db;

WHERE user_id = $userid";

{

$userdata = array("error" => "1");

return ($userdata);

global $db;

AND user_level != ".DELETED;

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

{

}

?>

{

case 'postgresql':

$limit_forums = ($viewcat != -1) ? "AND f.cat_id = $viewcat " : "";

FROM ".FORUMS_TABLE." f, ".TOPICS_TABLE." t, ".POSTS_TABLE." p, ".USERS_TABLE." u, ".AUTH_FORUMS_TABLE." af

WHERE f.forum_last_post_id = p.post_id

AND p.post_id = t.topic_last_post_id

AND af.forum_id = f.forum_id

$limit_forums

UNION (

FROM ".FORUMS_TABLE." f

WHERE NOT EXISTS (

SELECT p.post_time

case 'oracle':

$limit_forums = ($viewcat != -1) ? "AND f.cat_id = $viewcat " : "";

FROM ".FORUMS_TABLE." f, ".POSTS_TABLE." p, ".TOPICS_TABLE." t, ".USERS_TABLE." u, ".AUTH_FORUMS_TABLE." af

WHERE f.forum_last_post_id = p.post_id(+)

AND p.post_id = t.topic_last_post_id(+)

$limit_forums

ORDER BY f.cat_id, f.forum_order";

*/

FROM ((( ".FORUMS_TABLE." f

LEFT JOIN ".POSTS_TABLE." p ON f.forum_last_post_id = p.post_id )

LEFT JOIN ".TOPICS_TABLE." t ON p.post_id = t.topic_last_post_id )

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

{

$last_post_time = create_date($board_config['default_dateformat'], $forum_rows[$j]['post_time'], $board_config['default_timezone']);

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

$last_post .= "<a href=\"" . append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $forum_rows[$j]['topic_last_post_id']) . "#" . $forum_rows[$j]['topic_last_post_id'] . "\"><img src=\"" . $images['latest_reply'] . "\" width=\"20\" height=\"11\" border=\"0\" alt=\"View Latest Post\"></a>";

//

// Viewtopic

//

//

// Posting/Replying (Not private

$lang['Website'] = "Website";

$lang['From'] = "From";

$lang['Wrong_Profile'] = "You cannot modify a profile that is not your own.";

//

// Memberslist

}

break;

case 'reply':

$is_auth_type = "auth_reply";

$error_string = "reply to topics";

break;

$notify = (isset($HTTP_POST_VARS['notify'])) ? $HTTP_POST_VARS['notify'] : $userdata["always_notify"];

$annouce = (isset($HTTP_POST_VARS['annouce'])) ? $HTTP_POST_VARS['annouce'] : "";

$sticky = (isset($HTTP_POST_VARS['sticky'])) ? $HTTP_POST_VARS['sticky'] : "";

if($annouce)

{

//

// Prepare our message and subject on a 'submit'

//

{

//

// Flood control

//

{

$sql = "SELECT max(post_time) AS last_post_time

FROM ".POSTS_TABLE."

// End: Flood control

//

$subject = trim(strip_tags(htmlspecialchars($HTTP_POST_VARS['subject'])));

if($mode == 'newtopic' && empty($subject))

{

if(!empty($HTTP_POST_VARS['message']))

{

{

if($disable_html)

{

}

}

{

$topic_time = get_gmt_ts();

$topic_notify = ($HTTP_POST_VARS['notify']) ? $HTTP_POST_VARS['notify'] : 0;

$sql = "INSERT INTO ".TOPICS_TABLE." (topic_title, topic_poster, topic_time, forum_id, topic_notify, topic_status, topic_type)

if($db->sql_query($sql))

{

$new_topic_id = $db->sql_nextid();

if($db->sql_query($sql))

{

$page_title = " $l_reply";

$section_title = $l_postreplyto;

{

if($SQL_LAYER != "mysql")

{

}

}

$new_topic_id = $HTTP_POST_VARS[POST_TOPIC_URL];

$topic_time = get_gmt_ts();

if($db->sql_query($sql))

{

case 'editpost':

$page_title = " $l_editpost";

$section_title = $l_editpostin;

{

if(isset($HTTP_POST_VARS['delete_post']))

{

}

}

}

{

$post_id = ($HTTP_GET_VARS[POST_POST_URL]) ? $HTTP_GET_VARS[POST_POST_URL] : $HTTP_POST_VARS[POST_POST_URL];

if(!empty($post_id))

// End: error handling

//

//

// Show the same form for each mode.

//

}

else

{

$username_input = '<input type="text" name="username" value="'.$username.'" size="25" maxlength="50">';

$password_input = '<input type="password" name="password" size="25" maxlenght="40">';

}

//

// Page specific functions

//

function language_select($default, $dirname="language/")

{

global $phpEx;

<script language="Javascript">

<!--

{

return;

}

{

document.posting.message.value=document.posting.message.value+bbCode;

document.posting.message.focus();

<tr>

<td>

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

<td bgcolor="#DDDDDD">{L_USERNAME}</td>

<td bgcolor="#CCCCCC">{USERNAME_INPUT}</td>

<td bgcolor="#DDDDDD">{L_PASSWORD}</td>

<td bgcolor="#CCCCCC">{PASSWORD_INPUT}</td>

</tr>

// Grab all the basic data for

// this forum

//

FROM ".TOPICS_TABLE." t, ".USERS_TABLE." u, ".POSTS_TABLE." p, ".USERS_TABLE." u2

WHERE t.forum_id = $forum_id

AND t.topic_poster = u.user_id

$limit_posts_time

ORDER BY t.topic_type DESC, p.post_time DESC

LIMIT $start, ".$board_config['topics_per_page'];

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

{

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

$topic_poster_profile_url = append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$topic_rowset[$x]['user_id']);

$last_post_time = create_date($board_config['default_dateformat'], $topic_rowset[$x]['post_time'], $board_config['default_timezone']);

$last_post_profile_url = append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$topic_rowset[$x]['id2']);

$views = $topic_rowset[$x]['topic_views'];

//

// Go ahead and pull all data for this topic

//

FROM ".POSTS_TABLE." p, ".USERS_TABLE." u, ".POSTS_TEXT_TABLE." pt

WHERE p.topic_id = $topic_id

AND p.poster_id = u.user_id

$poster_avatar = ($postrow[$x]['user_avatar'] != "" && $userdata['user_id'] != ANONYMOUS) ? "<img src=\"".$board_config['avatar_path']."/".$postrow[$x]['user_avatar']."\">" : "";

{

for($i = 0; $i < count($ranksrow); $i++)

{

}

}

$profile_img = "<a href=\"".append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=$poster_id")."\"><img src=\"".$images['profile']."\" alt=\"$l_profileof $poster\" border=\"0\"></a>";

$email_img = ($postrow[$x]['user_viewemail'] == 1) ? "<a href=\"mailto:".$postrow[$x]['user_email']."\"><img src=\"".$images['email']."\" alt=\"$l_email $poster\" border=\"0\"></a>" : "";

$delpost_img = "<a href=\"".append_sid("topicadmin.$phpEx?mode=delpost&".POST_POST_URL."=".$postrow[$x]['post_id'])."\"><img src=\"".$images['delpost']."\" alt=\"$l_delete\" border=\"0\"></a>";

}

$post_subject = ($postrow[$x]['post_subject'] != "") ? stripslashes($postrow[$x]['post_subject']) : "Re: ".$topic_title;

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