Community (phpmysql) iii

Function prev_subj ($ id ){
$ Droot = getenv ('document _ root ');
Include ("SQL. php3 ");
$ Db = mysql_connect ($ SQL ['host'], $ SQL ['user'], $ SQL ['passwd']);
$ Qstr = "select ID, aid from bbs_subj where id = '$ id '";
$ Rs = mysql_db_query ($ SQL ['db'], $ qstr );
$ ROW = mysql_fetch_array ($ RS );
$ Aid = $ row ['aid '];

$ Qstr = "select ID from bbs_subj where aid = '$ aid' order by wdate DESC ";
$ Rs = mysql_db_query ($ SQL ['db'], $ qstr );
$ Pid = $ ID;
While ($ ROW = mysql_fetch_array ($ RS )){
$ Tid = $ row ['id'];
If ($ id = $ tid) break;
$ Pid = $ tid;
}

Return $ PID;
}
// Configure
Function next_subj ($ id ){
$ Droot = getenv ('document _ root ');
Include ("SQL. php3 ");
$ Db = mysql_connect ($ SQL ['host'], $ SQL ['user'], $ SQL ['passwd']);
$ Qstr = "select ID, aid from bbs_subj where id = '$ id '";
$ Rs = mysql_db_query ($ SQL ['db'], $ qstr );
$ ROW = mysql_fetch_array ($ RS );
$ Aid = $ row ['aid '];

$ Qstr = "select ID from bbs_subj where aid = '$ aid' order by wdate DESC ";
$ Rs = mysql_db_query ($ SQL ['db'], $ qstr );
$ Pid = $ ID;
While ($ ROW = mysql_fetch_array ($ RS )){
$ Pid = $ row ['id'];
If ($ id = $ PID) break;
}
If ($ ROW = mysql_fetch_array ($ RS )){
$ Pid = $ row ['id'];
}
Return $ PID;
}

// ================================================ ======================================
Function viewbar (){
Global $ pgno;
Global $ php_self;
Global $ aid, $ Sid;
// Global $ open_list;
Echo "<Table width = 85% border = 0 cellpadding = 0 cellspacing = 1 align = center class = 'num'> ";
Echo "<tr> <TD align = center> ";
$ Nextid = next_subj ($ Sid );
$ Previd = prev_subj ($ Sid );
Echo "<a href = $ php_self? Aid = $ Aid & SID = $ Sid> [Folder comment] </a> ";
Echo "<a href = # Re> [Lai Yun] </a> ";
Echo "<a href = $ php_self? Proc = view & Aid = $ aid> [just pull away] </a> ";
Echo "<a href = $ php_self? Proc = view & Aid = $ Aid & SID = $ nextid & rid = $ nextid> [partition] </a> ";
Echo "<a href = $ php_self? Proc = view & Aid = $ Aid & SID = $ previd & rid = $ previd> [region] </a> ";
// Echo "<a href = $ php_self? Proc = view & pgno = $ pgno & Aid = $ Aid & SID = $ previd & rid = $ previd> [Cheng Jing] </a> ";

Echo "</TD> ";

Echo "</tr> </table> ";

}
// ================================================ ======================================
Function view (){
Global $ php_self, $ aid, $ Sid, $ RID;
Global $ c_poster, $ c_email;
// Echo "$ php_self, $ aid, $ Sid, $ RID, $ pgno ";
$ Type = 0; // adjust parallel bars
If ($ Sid & $ RID ){
Addhitviews ($ Sid, $ RID );
$ Type = 1; // click
$ Db_table = "bbs_subj ";
If ($ Sid! = $ RID) $ db_table = "bbs_docs ";
$ Droot = getenv ('document _ root ');
Include ("SQL. php3 ");
$ Db = mysql_connect ($ SQL ['host'], $ SQL ['user'], $ SQL ['passwd']);
$ Qstr = "select banner from bbs_area where id = '$ aid '";
$ Rs = mysql_db_query ($ SQL ['db'], $ qstr );
Echo mysql_error ();
$ ROW = mysql_fetch_array ($ RS );
$ Abanner = $ row ['banner '];

$ Qsql = "select * from $ db_table where id = '$ rid '";
$ Rs = mysql_db_query ($ SQL ['db'], $ qsql );
$ ROW = mysql_fetch_array ($ RS );
$ Poster = $ row ['poster'];
$ Pip = $ row ['pip '];
$ Wdate = $ row ['wdate'];
$ Rebanner = $ banner = $ row ['banner '];
$ Body = $ row ['body'];
$ Body = htmlspecialchars ($ body );
$ Pbody = ereg_replace ("N", "<br>", $ body );
$ Pbody = preg_replace ("/[www *] ([\ x0-\ xFF] *?) [/WWW *]/", '<a href =" \ 1 "target =" _ blank "> \ 1 </a>', $ pbody );
$ Pbody = preg_replace ("/[www + ([a-zA-Z0-9.: // _-] +)] ([\ x0-\ xFF] *?) [/WWW *]/", '<a href =" \ 1 "target =" _ blank "> \ 2 </a>', $ pbody );

Echo "<center> ";
Echo "<font color = green size = 5> <B> [$ abanner] <br> ";
Echo "$ banner </B> </font> </center> ";
Echo "<Table border = 0 width = 95% align = center cellpadding = 1 cellspacing = 0 class = 'tablefont'> ";
Echo "<tr> <TD> ";
Viewbar ();
Echo "</TD> </tr> ";
Echo "<tr> <TD> ";
// ===== Chanchefile ======================
Echo "<Table border = 0 width = 100% align = center cellpadding = 1 cellspacing = 0 class = 'tablefont'> ";
Echo "<tr> ";
Echo "<TD width = '000000' align = 'right'> ";
Echo ":";
Echo "</TD> ";
Echo "<TD align = 'left'> ";
Echo $ poster;
Echo "</TD> ";
Echo "</tr> ";
Echo "<tr> ";
Echo "<TD width = '000000' align = 'right'> ";
Echo "success :";
Echo "</TD> ";
Echo "<TD align = 'left'> ";
Echo $ PIP;
Echo "</TD> ";
Echo "</tr> ";
Echo "<tr> ";
Echo "<TD width = '000000' align = 'right' valign = 'top'> ";
Echo "Success success :";
Echo "</TD> ";
Echo "<TD valign = 'top' class = 'bodycolor' align = 'left'> ";
Echo $ pbody;
Echo "<HR size = 1> ";
Echo "</TD> ";
Echo "</tr> ";
Echo "</TD> </tr> ";
Echo "</table> ";
Echo "<tr> <TD> ";

// ======== Commandid already exist ======================
Echo "<Table border = 0 width = 100% align = center cellpadding = 3 cellspacing = 0 class = 'menufont'> ";
Echo "<form name = mtab enctype = multipart/form-data method = post action = $ php_self? Proc = mail_friend> ";
Echo "<input type = 'ddn' name = Sid value = '$ Sid'> ";
Echo "<input type = 'ddn' name = aid value = '$ aid'> ";
Echo "<input type = 'ddn' name = rid value = '$ rid'> ";
Echo "<input type = 'ddn' name = poster value = '$ c_poster'> ";
Echo "<input type = 'siden' name = Email value = '$ c_email'> ";
Echo "<tr> ";
Echo "<TD align = 'right' width = 250> ";
Echo "too many threads have been too wide :";
Echo "</TD> ";
Echo "<TD> ";
Echo "<input type = 'text' name = 'frmail' size = 25 value = 'your email '> ";

echo "";
echo " ";
echo "";
echo "";
echo " ";
echo " ";
echo " ";
// ========= Mail List ===================< br> echo "

"; echo " "; echo" "; echo " "; echo " "; echo " "; echo "";

Echo "<tr> ";
Echo "<TD align = 'right' width = 250> ";
Echo "stage o urgency order :";
Echo "</TD> ";
Echo "<TD> ";
If (strlen ($ c_email) $ addmail = $ c_email;
Else $ addmail = "E-mail ";
Echo "<input type = 'text' name = 'email 'size = 25 value =' $ addmail'> ";
Echo "<input type = 'submit 'name = 'way1' value = 'submit?> ";
Echo "<input type = 'submit 'name = 'way2' value = 'submit?> ";
$ Qsql = "select ID from bbs_sml where Sid = '$ Sid '";
$ Rs = mysql_db_query ($ SQL ['db'], $ qsql );
$ Nums = mysql_num_rows ($ RS );
Echo "<br> when there are too many milliseconds between H: $ Nums ";
Echo "</TD> ";
Echo "</tr> ";
Echo "</form> ";
Echo "</table> ";

Echo "</TD> </tr> ";
Echo "<tr> <TD> ";
Viewbar ();
Echo "</TD> </tr> ";
Echo "</table> ";

To be continued ........