discuz!X2插入主题帖子所需运行的代码和SQL语句

$subject = $news_subject;
$message = $news_message;


DB::query("INSERT INTO ".DB::table('forum_thread')." (fid, posttableid, readperm, price, typeid, sortid, author, authorid, subject, dateline, lastpost, lastposter, displayorder, digest, special, attachment, moderated, status, isgroup, replycredit, closed) VALUES ('$cmt_fid', '0', '0', '0', '0', '0', '$cmt_author', '$cmt_uid', '$subject', '$_G[timestamp]', '$_G[timestamp]', '$cmt_author', '0', '0', '0', '0', '0', '0', '0', '0', '0')");
$tid = DB::insert_id();


$pid = insertpost(array(
'fid' => $cmt_fid,
'tid' => $tid,
'first' => '1',
'author' => $cmt_author,
'authorid' => $cmt_uid,
'subject' => $subject,
'dateline' => $_G['timestamp'],
'message' => $message,
'useip' => $_G['clientip'],
'invisible' => 0,
'anonymous' => 0,
'usesig' => 0,
'htmlon' => 0,
'bbcodeoff' => 0,
'smileyoff' => 0,
'parseurloff' => 0,
'attachment' => 0,
'tags' => '',
'replycredit' => 0,
'status' => 0
));


$subject = str_replace("\t", ' ', $subject);
$lastpost = "$tid\t$subject\t$_G[timestamp]\t$cmt_author";
DB::query("UPDATE ".DB::table('forum_forum')." SET lastpost='$lastpost', threads=threads+1, posts=posts+1, todayposts=todayposts+1 WHERE fid='$cmt_fid'", 'UNBUFFERED');
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值