newpost.php

需要mysql

<?php
if(!$inc_lib)  { include("lib.inc.php"); }

if($newpost)
{
	$user_id=1;//缺省处理
	
	if(!$inc_condb)  { include("conn_db.inc.php"); }
	//检测录入合法性,插入数据库一条新记录
	if((strlen($user_name)<1) or ( strlen($user_name)>30) ) { fatalerror("姓名输入错误,输入范围2到30个字符 \n<br>  "); }
	if((strlen($g_title)<1) or (strlen($g_title)>30) ) { fatalerror("标题错误,输入范围2到30个字符 \n<br>  "); }
	if(strlen($user_url)>100) { fatalerror("主页地址太长,最多100个字符 \n<br>  "); }
	if(($user_url!='') and (strtolower(substr($user_url,0,4))!='http') ) { $user_url='http://'.$user_url; }
	if(strtolower($user_url)=='http://') { $user_url=''; }
	if ( ($user_url!='') and (!eregi("http://..*\...*", $user_url)) ) { fatalerror("网址书写不规范 \n<br>  "); }
	if(strlen($user_email)>80) { fatalerror("邮件地址太长,最多80个字符 \n<br>"); }
	if( ($user_email!='') and (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$", $user_email)) )
	{ fatalerror("邮件地址不规范 \n<br>  "); }
	if(strlen($g_said)<1) { fatalerror("留言内容没有填写. \n<br>  "); }
	if(strlen($g_said)>16000) { fatalerror("留言内容太长,如果有重要意见,请到论坛发表. \n<br>  "); }
	if($g_sendmail) { $g_sendmail='1'; } else {$g_sendmail='0';}
	$g_time=nowstr();
	$g_ltime=$g_time;
	$user_ip=getenv("REMOTE_ADDR");
	
	$thissql="select count(*) from $db_gb where user_id=$user_id and g_title='$g_title' and user_name='$user_name' and g_said='$g_said'";
	$query=mysql_query($thissql,$db_conn);
	$array=mysql_fetch_row($query);
	if($array[0]>0) { fatalerror("这条留言已经发表过了,请不要重复发表.谢谢."); }
	
	$thissql="insert into $db_gb (user_id,g_top_id,user_name,user_url,user_email,user_ip,g_title,g_said,g_time,g_ltime,g_sendmail)
		values ($user_id,0,'$user_name','$user_url','$user_email','$user_ip','$g_title','$g_said','$g_time','$g_ltime',$g_sendmail)";
	$query=mysql_query($thissql,$db_conn);
	
	if($show_newpost)
	{	
		okto($gb_url,'留言成功','留言成功,稍候返回');	
	}
	else
	{
		popok('留言成功','留言成功,稍候返回');	
		
	}
}
else
{
	header("Location:$gb_url\n\n");
}
?>