Mysql-based Forum (5)

Last Update:2018-12-08 Source: Internet

Author: User

Tags sendmsg

Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞

# Manage_read.php
<? Php
Require ("func. php ");
If (check_admin_password ()){
$ Board = $ jl_forum [board];
Switch ($ job ){
Case "setgood ":
Set_good ($ jl_forum [board], $ uid );
$ Work = 1;
Break;
Case "setnogood ":
Set_no_good ($ jl_forum [board], $ uid );
$ Work = 1;
Break;
Case "delete ":
Del_doc ($ jl_forum [board], $ uid );
$ Work = 1;
Break;
}
If (! $ Word ){
Add_one_hit ($ board, $ id );
}
$ SQL = "select * from $ board where id = $ id ";
$ SQL _result = mysql_query ($ SQL );
$ Sum = mysql_num_rows ($ SQL _result );
$ SQL _row = mysql_fetch_array ($ SQL _result );
$ Title = $ SQL _row [title];
$ Writer = $ SQL _row [writer];
$ Cont = $ SQL _row [cont];
$ Writetime = $ SQL _row [writetime];
$ Hits = $ SQL _row [hits];
$ Good = $ SQL _row [good];
$ Rootid = $ SQL _row [id];
$ Fromip = $ SQL _row [fromip];
$ SQL = "select * from $ board where slaveid = $ id ";
$ SQL _result = mysql_query ($ SQL );
If ($ sum <> 0 ){
?>
<Html>
<Head>
<Title> <? Php echo $ title;?> </Title>
<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">
<Link rel = "stylesheet" type = "text/css" href = "css/index.css">
<Script language = "javascript">
Function sendmsg (name) {window. open ("sendmsg. php? Name = "+ name," "," height = 200, width = 500, resizable = yes, scrollbars = yes, status = no, toolbar = no, menubar = no, location = no ");
}
</Script>

</Head>

<Body bgcolor = "#666699" type = "codeph" text = "/codeph">
<? Php include "ad. php";?> <Br>
<Hr noshade width = "98%" size = "1">
<Table width = "98%" border = "1" cellspacing = "0" cellpadding = "2" align = "center" bordercolorlight = "# cccccccc" bordercolordark = "# FFFFFF">
<Tr bgcolor = "#666666" type = "codeph" text = "/codeph">
<Td> <font color = "# FFcc00"> <B> title: <? Php echo $ title;?> <Font color = "# FFFFCC"> ◎ operation: </font> </B> </font> <B> <? Php echo "<a href =" $ php_self? Job = setgood & uid = $ id & id = $ rootid ">";?> <Font color = "# FFFFFF"> transfer to essence </font> </a> </B> <font color = "# FFcc00"> <B> </B> </font> <B> <? Php echo "<a href =" $ php_self? Job = delete & uid = $ id & id = $ rootid ">";?> <Font color = "# FFFFFF"> Delete </font> </a> </B> <font color = "# FFcc00"> <B> <? Php
If ($ good = "y "){
?> </B> </font> <B> <? Php echo "<a href =" $ php_self? Job = setnogood & uid = $ id & id = $ rootid ">";?> <Font color = "# FFFFFF"> transfer out of the essence area </font> </a> </B> <font color = "# FFcc00"> <B>
<? Php
}
?> </B> </font> </td>
</Tr>
<Tr>
<Td bgcolor = "# eeeeee"> author: <? Php echo "$ writer";?> (<? Php echo $ writetime;?>, Click: <? Php echo $ hits;?>) <A href = "javascript: sendmsg ('<? Php echo "$ writer";?> ') "> </a> </Tr>
<Tr>
<Td bgcolor = "# ffffef"> <? Php echo $ cont;?> </Td>
</Tr>
<Tr bgcolor = "# e8eee0">
<Td> ※source: <? Php echo $ jl_forum [chinesename];?> [◆ FROM: <? Php echo $ fromip;?>] </Td>
</Tr>
</Table>
<Br>
<? Php
If (! $ Add ){
While ($ SQL _row = mysql_fetch_array ($ SQL _result )){
$ Good = $ SQL _row [good];
?>
<Table width = "98%" border = "1" cellspacing = "0" cellpadding = "2" align = "center" bordercolorlight = "# cccccccc" bordercolordark = "# FFFFFF">
<Tr bgcolor = "#015C71">
<Td> <font color = "# ffffff"> title: <? Php echo $ SQL _row [title];
$ Id = $ SQL _row [id];
?> <Font color = "# FFFFCC"> ◎ operation: </font> </B> </font> <B> <? Php echo "<a href =" $ php_self? Job = setgood & uid = $ id & id = $ rootid ">";?> <Font color = "# FFFFFF"> transfer to essence </font> </a> </B> <font color = "# FFcc00"> <B> </B> </font> <B> <? Php echo "<a href =" $ php_self? Job = delete & uid = $ id & id = $ rootid ">";?> <Font color = "# FFFFFF"> Delete </font> </a> </B> <font color = "# FFcc00"> <B> <? Php
If ($ good = "y "){
?> </B> </font> <B> <? Php echo "<a href =" $ php_self? Job = setnogood & uid = $ id & id = $ rootid ">";?> <Font color = "# FFFFFF"> transfer out of the essence area </font> </a> </B> <font color = "# FFcc00"> <B>
<? Php
}
?> </B> </font> </td>
</Tr>
<Tr bgcolor = "# eeeeee">
<Td> author: <? Php echo "$ SQL _row [writer]";?> (<? Php echo $ SQL _row [writetime];?>) <A href = "javascript: sendmsg ('<? Php echo "$ SQL _row [writer]";?> ') "> </a> </Tr>
<Tr>
<Td bgcolor = "# ffffef"> <? Php echo $ SQL _row [cont];?> </Td>
</Tr>
<Tr bgcolor = "# e8eee0">
<Td> ※source: <? Php echo $ jl_forum [chinesename];?> [◆ FROM: <? Php echo $ SQL _row [fromip];?>] </Td>
</Tr>
</Table>
<? Php
}
}
?> <Br>
<? Php include "footer. php";?> <Br>
</Body>
</Html>
<? Php
}
Else {
Echo "this record has been deleted ";
}
}
Else {
Show_error (1 );
}
?>
# Modify. php
<? Php
Require "func. php ";
If (check_user_password ($ jl_forum [name], $ jl_forum [password]) {
$ Name = $ jl_forum [name];
$ Password = $ jl_forum [password];
$ SQL = "select * from user where name = '$ name '";
$ SQL _result = mysql_query ($ SQL );
$ SQL _row = mysql_fetch_array ($ SQL _result );
?>
<Html>
<Head>
<Title> modify materials </title>
<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">
<Link rel = "stylesheet" type = "text/css" href = "css/index.css">
</Head>
<Body bgcolor = "# FFFFFF" background = "image/bg.gif">
<? Php include "header. php";?> <Br>
<Hr noshade width = "97%" size = "1">
<Div align = "center"> modify user profile <br>
<Table width = "90%" border = "1" cellspacing = "0" cellpadding = "0" bordercolorlight = "#336699" bordercolordark = "# FFFFFF">
<Tr valign = "top">
<Td colspan = "2"> </td>
</Tr>
<Tr>
<Td colspan = "2">
<Form method = "post" action = "change. php">
<Table width = "80%" border = "0" cellspacing = "0" cellpadding = "3" align = "center">
<Tr>
<Td align = "right"> User Name </td>
<Td> <? Php echo $ name;?> </Td>
</Tr>
<Tr>
<Td align = "right"> password </td>
<Td>
<Input type = "password" name = "pwd1" maxlength = "8" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "size =" 9 "value =" <? Php echo $ password;?> ">
* </Td>
</Tr>
<Tr>
<Td align = "right"> duplicate password </td>
<Td>
<Input type = "password" name = "pwd2" maxlength = "8" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "size =" 9 "value =" <? Php echo $ password;?> ">
* </Td>
</Tr>
<Tr>
<Td align = "right"> Email </td>
<Td>
<Input type = "text" name = "email" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "value =" <? Php echo $ SQL _row [email];?> ">
* </Td>
</Tr>
<Tr>
<Td align = "right"> gender </td>
<Td>
<Select name = "sex">
<Option value = "secret" selected> secret </option>
<Option value = "male"> male </option>
<Option value = ""> female </option>
</Select>
</Td>
</Tr>
<Tr>
<Td align = "right"> authenticity name </td>
<Td>
<Input type = "text" name = "realname" size = "17" maxlength = "16" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "value =" <? Php echo $ SQL _row [realname];?> ">
</Td>
</Tr>
<Tr>
<Td align = "right"> address </td>
<Td>
<Input type = "text" name = "address" maxlength = "40" size = "30" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "value =" <? Php echo $ SQL _row [address];?> ">
</Td>
</Tr>
<Tr>
<Td align = "right"> phone number </td>
<Td>
<Input type = "text" name = "phone" size = "22" maxlength = "20" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "value =" <? Php echo $ SQL _row [phone];?> ">
</Td>
</Tr>
<Tr>
<Td align = "right"> homepage </td>
<Td>
<Input type = "text" name = "homepage" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "size =" 50 "value =" <? Php echo $ SQL _row [homepage];?> ">
</Td>
</Tr>
<Tr>
<Td align = "right"> OICQ </td>
<Td>
<Input type = "text" name = "oicq" maxlength = "11" style = "font-size: 9pt; background-color: # FFFFFF; color: # FF0000; border: 1 solid #000000 "size =" 12 "value =" <? Php echo $ SQL _row [oicq];?> ">
</Td>
</Tr>
<Tr>
<Td align = "right"> signature </td>
<Td> <? Php echo "$ SQL _row [qm] <br>" ;?>
<Textarea name = "qm" wrap = "VIRTUAL" cols = "50"> </textarea>
</Td>
</Tr>
<Tr>
<Td align = "right"> </td>
<Td align = "center">
<Input type = "submit" name = "b2" value = "modify">
<Input type = "reset" name = "Submit2" value = "clear">
</Td>
</Tr>
</Table>
</Form>
</Td>
</Tr>
</Table>
<Div align = "center"> <br>
</Div>
</Div>
<? Php include "footer. php";?>
</Body>
</Html>
<? Php
}
Else {
Show_error (4 );
}
?>
# Modify_l.php
<? Php
Require "func. php ";
If ($ b1 ){
If (is_user_exits ($ name) and check_user_password ($ name, $ password )){
Setcookie ("jl_forum [name]", $ name );
Setcookie ("jl_forum [password]", $ password );
Redirect2 ("modify. php ");
}
Else {
Show_error (4 );
}
}
Else {
?>
<Html>
<Head>
<Title> main </title>
<Meta http-equiv = "Content-Type" content = "text/html; charset = gb2312">
<Link rel = "stylesheet" type = "text/css" href = "css/page.css">
</Head>

<Body bgcolor = "# FFFFFF" background = "image/bg.gif">
<Table width = "90%" border = "1" cellspacing = "0" cellpadding = "0" align = "center" bordercolorlight = "# FFCC99" bordercolordark = "# FFCC99">
<Tr bgcolor = "# CCFF99">
<Td>
<Div align = "center"> <B> modify data logon </B> </div>
</Td>
</Tr>
<Tr align = "center">
<Td>
<Form method = "post" action = "modify_l.php">
<Table width = "70%" border = "0" cellspacing = "0" cellpadding = "0">
<Tr>
<Td width = "38%" align = "right"> User name: </td>
& Lt; td width = "62%" align = "left" & gt;
<Input type = "text" name = "name" size = "17" maxlength = "16">
</Td>
</Tr>
<Tr>
<Td width = "38%" align = "right"> password: </td>
& Lt; td width = "62%" align = "left" & gt;
<Input type = "password" name = "password" size = "17" maxlength = "16">
</Td>
</Tr>
</Table>
<Input type = "submit" name = "b1" value = "enter">
</Form>
</Td>
</Tr>
<Tr bgcolor = "# CCFF99">
<Td>
<Div align = "center"> <B> Forum Information </B> </div>
</Td>
</Tr>
<Tr valign = "top">
<Td>
<? Php include "info. php";?>
</Td>
</Tr>
</Table>
</Body>
</Html>
<? Php
}
?>
# Composer. php
<? Php
Require "func. php ";
If (adminok ()){
If (isset ($ add_board )){
If (isset ($ name) and isset ($ chinesename) and! Is_board_exits ($ name )){
Create_board_table ($ name, $ chinesename );
}
Else {
Echo "error! (The layout may already exist )";
$ Founderr = 1;
}
}
Elseif (isset ($ del_board )){
If (isset ($ board )){
Drop_board_table ($ board );
}
Else {
Echo "error! (Select the layout to delete )";
$ Founderr = 1;
}
}
Elseif (isset ($ modify )){
If (isset ($ name) and isset ($ chinesename )){
Update_board ($ name, $ chinesename );
}
Else {
Echo "error! (Complete )";
$ Founderr = 1;
}
}
Elseif (isset ($ add_admin )){
If (is_user_exits ($ name) and isset ($ board )){
Add_admin ($ board, $ name );
}
Else {
Echo "error! (Most likely the user does not exist )";
$ Founderr = 1;
}
}
Elseif (isset ($ delete_admin )){
If (is_user_exits ($ name )){
Del_admin ($ name );
}
Else {
Echo "error! (Most likely the user does not exist )";
$ Founderr = 1;
}
}
Else {
Echo "what are you doing? ";
$ Founderr = 1;
}
If (! $ Founderr ){
Redirect2 ("admin. php ");
}
}
Else {
Show_error (1 );
}
?>

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More