- if ($thread && $thread->{post}){
- addForumPost($DBH,$thread,$ND::UID,param('message'));
+ if(param('cmd') eq 'Move' && $board->{moderate}){
+ $DBH->begin_work;
+ my $moveThread = $DBH->prepare(q{UPDATE forum_threads SET fbid = $1 WHERE ftid = $2 AND fbid = $3});
+ for my $param (param()){
+ if ($param =~ /t:(\d+)/){
+ $moveThread->execute(param('board'),$1,$board->{id}) or $ND::ERROR .= p($DBH->errstr);
+ if ($moveThread->rows > 0){
+ log_message $ND::UID, qq{Moved thread: $1 to board: }.param('board');
+ }
+ }
+ }
+ $DBH->commit or $ND::ERROR .= p($DBH->errstr);
+ }
+ if($thread && param('cmd') eq 'Sticky' && $thread->{moderate}){
+ if ($DBH->do(q{UPDATE forum_threads SET sticky = TRUE WHERE ftid = ?}, undef,$thread->{id})){
+ $thread->{sticky} = 1;
+ }else{
+ $ND::ERROR .= p($DBH->errstr);
+ }
+ }
+ if($thread && param('cmd') eq 'Unsticky' && $thread->{moderate}){
+ if ($DBH->do(q{UPDATE forum_threads SET sticky = FALSE WHERE ftid = ?}, undef,$thread->{id})){
+ $thread->{sticky} = 0;
+ }else{
+ $ND::ERROR .= p($DBH->errstr);
+ }