i know that not about ur hack.... ;)

anyway i comment that and it works now

thankz rake.......this is a nice hack..... :classic:

find new problem when edit post and remove the multiple attachment files i got this

Invalid SQL: SELECT attachmentid FROM post WHERE attachmentid=233,234
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '234' at line 1

mysql error number: 1064

Date: Thursday 01st of May 2003 04:30:10 AM
Script: http:///forum/forum/editpost.php
Referer: http:///forum/editpost.php?s=&action=editpost&postid=1372

I don't have it anymore :( I have been trying for hours to get this too work, and can't uninstall it as i have no idea on how to delete the tables and get the attachments back to the way they were...

:) I'm glad to see it finally works.

Edit: Wow, great timing. :lick:


To fix the editing error:

Replace
if (trim($attachmentaction)=="delete") {
$attachmentsql=",attachmentid=0";
$DB_site->query("DELETE FROM attachment WHERE attachmentid=$postinfo[attachmentid]");
updatethreadcount($threadinfo[threadid]);
}

With

if (trim($attachmentaction)=="delete") {
$attachmentsql=",attachmentid=0";


$att = explode(",",$postinfo[attachmentid]);
foreach($att as $value) {
if(isset($qry)) {
$qry .= " OR attachmentid='$value'";
} else {
$qry = "attachmentid='$value'";
}
}

$DB_site->query("DELETE FROM attachment WHERE $qry");
updatethreadcount($threadinfo[threadid]);
}

Download a new ZIP from the member's area or make the changes to the attachment.php that I posted. If you make the changes I posted, that attachment.php will work ;)

So are we, rake, so are we. :)

i will be installing this when i get some free time

which file is that from????

I have applied the changes you made and it still doesn't work??? is there any chance you could post your attachment.php..... I am really getting depressed now! this should've gone into the beta release not here!

The hack didn't work before because of small errors which slipped in because of tiredness. :sleep: The hack in it's current state will work fine.

Is there any chance that you could send me - or post - a working attachment.php. I have tried altering the one on the post but i can now edit but i am still getting error when trying to view an attachment -