[RELEASE] 'Save Copy' Move Hack

Ok, it's the really simple, crappy version - sue me!

Not tested too much (only twice), but seemed to work relatively well.

postings.php, find:

$DB_site->query("UPDATE thread SET forumid=$forumid WHERE threadid=$threadid");

ABOVE it add:

  if ($savecopy) {
  	$threadinfo=$DB_site->query_first("SELECT title,lastpost,forumid,open,replycount,postusername,lastposter,dateline,views,iconid,notes,visible,subjectindex,threadindex,userindex FROM thread WHERE threadid=$threadid");
  	$DB_site->query("INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,postusername,lastposter,dateline,views,iconid,notes,visible,subjectindex,threadindex,userindex) VALUES (NULL,'".addslashes("$threadinfo[title]")."','".addslashes("$threadinfo[lastpost]")."','".addslashes("$threadinfo[forumid]")."',0,'".addslashes("$threadinfo[replycount]")."','".addslashes("$threadinfo[postusername]")."','".addslashes("$threadinfo[lastposter]")."','".addslashes("$threadinfo[dateline]")."','".addslashes("$threadinfo[views]")."','".addslashes("$threadinfo[iconid]")."','".addslashes("$threadinfo[notes]")."','".addslashes("$threadinfo[visible]")."','".addslashes("$threadinfo[subjectindex]")."','".addslashes("$threadinfo[threadindex]")."','".addslashes("$threadinfo[userindex]")."')");
  	$newid=$DB_site->insert_id();
  	$posts=$DB_site->query("SELECT postid,threadid,username,userid,title,dateline,pagetext,allowsmilie,email,signature,ipaddress,iconid,visible FROM post WHERE threadid=$threadid");
  	while ($post=$DB_site->fetch_array($posts)) {
  		$DB_site->query("INSERT INTO post (postid,threadid,username,userid,title,dateline,pagetext,allowsmilie,email,signature,ipaddress,iconid,visible) VALUES (NULL,'$newid','".addslashes("$post[username]")."','".addslashes("$post[userid]")."','".addslashes("$post[title]")."','".addslashes("$post[dateline]")."','".addslashes("$post[pagetext]")."','".addslashes("$post[allowsmilie]")."','".addslashes("$post[email]")."','".addslashes("$post[signature]")."','".addslashes("$post[ipaddress]")."','".addslashes("$post[iconid]")."','".addslashes("$post[visible]")."')");
  	}
  }

find:

$DB_site->query("UPDATE forum SET replycount=$numberposts,threadcount=threadcount-1,lastpost=$lastpost,lastposter='".addslashes($lastposter)."' WHERE forumid=$curforumid");

REPLACE with:

  if (!$savecopy) {
  	$DB_site->query("UPDATE forum SET replycount=$numberposts,threadcount=threadcount-1,lastpost=$lastpost,lastposter='".addslashes($lastposter)."' WHERE forumid=$curforumid");
  }

find:

eval("echo standardredirect(\$bbtitle,\"".gettemplate("redirect_movethread")."\",\"showthread.php?threadid=$threadid\");");

REPLACE with:

  if ($savecopy) {
  	eval("echo standardredirect(\$bbtitle,\"".gettemplate("redirect_movethread")."\",\"showthread.php?threadid=$newid\");");
  } else {
  	eval("echo standardredirect(\$bbtitle,\"".gettemplate("redirect_movethread")."\",\"showthread.php?threadid=$threadid\");");
  }

-----
Close that.

Now, in your move template, add this somewhere:

<TD><INPUT TYPE="checkbox" NAME="savecopy" value="yes">&nbsp;&nbsp; <normalfont>Do you want to save a copy of this message (but closed) in its original forum?</normalfont></td>

----
That's it, you should be done.
Maybe not efficient, but it works

BTW, sorry there's no note on the page - I don't feel like adding a whole column to the database for that

[Edited by Ed Sullivan on 06-17-2000 at 11:01 PM]

Thank you


I will try it shortly.

Ed, now how about the extended hack version, whereby the icon changes to "moved.gif" and the link of that thread in fact is linked to the new position of the thread?

I get a parse error on this line:

$DB_site->query("INSERT INTO post (postid,threadid,username,userid,title,dateline,pagetext,allowsmilie,email,signature,ipaddress,iconid,visible) VALUES (NULL,'$newid','".addslashes("post[username]")."','".addslashes("post[userid]")."','".addslashes("post[title]")."','".addslashes("post[dateline]")."','".addslashes("post[pagetext]")."','".addslashes("post[allowsmilie]")."','".addslashes("post[email,'".addslashes("post[signature]")."','".addslashes("post[ipaddress]")."','".addslashes("post[iconid]")."','".addslashes("post[visible]")."')");

Doh! Sorry, copied the wrong code. That line should read:

$DB_site->query("INSERT INTO post (postid,threadid,username,userid,title,dateline,pagetext,allowsmilie,email,signature,ipaddress,iconid,visible) VALUES (NULL,'$newid','".addslashes("$post[username]")."','".addslashes("$post[userid]")."','".addslashes("$post[title]")."','".addslashes("$post[dateline]")."','".addslashes("$post[pagetext]")."','".addslashes("$post[allowsmilie]")."','".addslashes("$post[email]")."','".addslashes("$post[signature]")."','".addslashes("$post[ipaddress]")."','".addslashes("$post[iconid]")."','".addslashes("$post[visible]")."')");

bira - I haven't studied the tables, but unfortunately, I'm a littled limited in what I can do without adding a field. Maybe, but it's low on my to do list

Ok, fixed the aforementioned mistake in my original code and added another search and replace (if (!$savecopy) {). Not a HUGE deal if you don't add it, but you're counters will be off then

Thanks! Works like a champ now.

Yes it does, thank you again

woah... hard to follow a bit... thought i'd bring it back up a bit

hmmm.. it didn't work ? no thread was saved in the original forum ?

okay i have hacks installed? could that be the problem ?

i have the location/interest hack, search result hack and avatar hack