[FUDforum]$ ls -al files/222.atch
-rw-r--r--    1 c74      c74          2151 May  5  2005 files/222.atch

[FUDforum]$ ls -ld files/
drwxrwxrwx    2 c74      c74          4096 Apr 17 14:37 files/

        $id = db_qid("INSERT INTO {SQL_TABLE_PREFIX}attach (location,message_id,original_name,owner,attach_opt,mime_type,fsize) SEL\
ECT '', 0, "._esc($at['name']).", ".$owner.", ".$attach_opt.", id, ".$at['size']." FROM {SQL_TABLE_PREFIX}mime WHERE fl_ext IN('', \
"._esc(substr(strrchr($at['name'], '.'), 1)).") ORDER BY fl_ext DESC LIMIT 1");

INSERT INTO fud26_attach (location,message_id,original_name,owner,attach_opt,mime_type,fsize) SELECT '', 0, 'readme.txt', 2543, 0, id, 177 FROM fud26_mime WHERE fl_ext IN('', 'txt') ORDER BY fl_ext DESC LIMIT 1

750151 Query       SELECT t.forum_id, t.replies, t.thread_opt, t.root_msg_id, t.orderexpiry, m.subject FROM fud26_
thread t INNER JOIN fud26_msg m ON t.root_msg_id=m.id WHERE t.id=19641
                 750151 Query       SELECT id, name, max_attach_size, forum_opt, max_file_attachments, post_passwd, message_thresho
ld FROM fud26_forum WHERE id=7
                 750151 Query       SELECT group_cache_opt, 1 as md FROM fud26_group_cache WHERE user_id IN(2543,2147483647) AND re
source_id=7 ORDER BY user_id ASC LIMIT 1
                 750151 Query       INSERT INTO fud26_attach (location,message_id,original_name,owner,attach_opt,mime_type,fsize) S
ELECT '', 0, 'dog.gif', 2543, 0, id, 5073 FROM fud26_mime WHERE fl_ext IN('', 'gif') ORDER BY fl_ext DESC LIMIT 1
                 750151 Query       SELECT with_str, replace_str FROM fud26_replace WHERE replace_str IS NOT NULL AND with_str IS N
OT NULL AND LENGTH(replace_str)>0
                 750151 Query       LOCK TABLES fud26_fl_7 WRITE
                 750151 Query       UNLOCK TABLES
                 750151 Query       UPDATE fud26_msg SET
                        file_id=70000,
                        foff=10316402,
                        length=42,
                        mlist_msg_id='11034(dot)44f316e4(at)test(dot)com',
                        file_id_preview=0,
                        offset_preview=0,
                        length_preview=0,
                        updated_by=2543,
                        msg_opt=0,
                        attach_cnt=1,
                        poll_id=0,
                        update_stamp=1156782395,
                        icon=NULL ,
                        poll_cache=NULL,
                        subject='testing'
                WHERE id=69684
                 750151 Query       SELECT orderexpiry, thread_opt, root_msg_id FROM fud26_thread WHERE id=19641
                 750151 Query       UPDATE fud26_thread SET thread_opt=0, orderexpiry=1000000000 WHERE id=19641
                 750151 Query       SELECT seq FROM fud26_tv_7 ORDER BY seq DESC LIMIT 1
                 750151 Query       SELECT fud26_thread.id FROM fud26_tv_7
                        INNER JOIN fud26_thread ON fud26_thread.id=fud26_tv_7.thread_id
                        INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id
                        WHERE fud26_tv_7.id>1078
                                AND fud26_tv_7.iss>0
                                AND fud26_thread.thread_opt>=2
                                AND (fud26_msg.post_stamp+fud26_thread.orderexpiry)<=1156782395
                 750151 Query       DELETE FROM fud26_thread WHERE forum_id=7 AND moved_to>0 AND last_post_date<1156523195
                 750151 Query       LOCK TABLES fud26_tv_7 WRITE, fud26_thread READ, fud26_msg READ
                 750151 Query       SET @seq=0
                 750151 Query       DELETE FROM fud26_tv_7
                 750151 Query       INSERT INTO fud26_tv_7 (thread_id,iss,seq) SELECT fud26_thread.id, (thread_opt & (2|4)), (@seq:
=@seq+1) FROM fud26_thread
                INNER JOIN fud26_msg ON fud26_thread.root_msg_id=fud26_msg.id
                WHERE forum_id=7 AND fud26_msg.apr=1
                ORDER BY (CASE WHEN thread_opt>=2 THEN (4294967294 + fud26_thread.last_post_date) ELSE fud26_thread.last_post_date
END) ASC
060828 10:26:36  750151 Query       UNLOCK TABLES
                 750151 Query       DELETE FROM fud26_index WHERE msg_id=69684
                 750151 Query       DELETE FROM fud26_title_index WHERE msg_id=69684
                 750151 Query       INSERT IGNORE INTO fud26_search (word) VALUES ('testing'),('this'),('test'),('see'),('attachmen
ts'),('work')
                 750151 Query       INSERT INTO fud26_title_index (word_id, msg_id) SELECT id, 69684 FROM fud26_search WHERE word I
N('testing')
                 750151 Query       INSERT INTO fud26_index (word_id, msg_id) SELECT id, 69684 FROM fud26_search WHERE word IN('tes
ting','this','test','see','attachments','work')
                 750151 Query       DELETE FROM fud26_attach WHERE message_id=69684
                 750151 Query       SELECT a.id, a.original_name, a.fsize, a.dlcount, COALESCE(m.icon, 'unknown.gif') FROM fud26_at
tach a LEFT JOIN fud26_mime m ON a.mime_type=m.id WHERE message_id=69684 AND attach_opt=0
                 750151 Query       UPDATE fud26_ses SET data=NULL WHERE id=625014
                 750151 Quit

                1079123 Connect     test@localhost on
                1079123 Init DB     qatestfud
                1079123 Query       SELECT * FROM fud26_mlist WHERE id=7
                1079123 Query       SELECT id, forum_opt, message_threshold, (max_attach_size * 1024) AS max_attach_size, max_file_attachments FROM fud26_forum WHERE id=7
                1079123 Query       SELECT lang, locale FROM fud26_themes WHERE theme_opt=1|2 LIMIT 1
                1079123 Query       SELECT id FROM fud26_msg WHERE mlist_msg_id='44F60607(dot)9000808(at)test(dot)com'
                1079123 Query       SELECT id FROM fud26_users WHERE email='test(at)test(dot)com'
                1079123 Query       SELECT with_str, replace_str FROM fud26_replace WHERE replace_str IS NOT NULL AND with_str IS NOT NULL AND LENGTH(replace_str)>0
                1079123 Query       LOCK TABLES fud26_fl_7 WRITE
                1079123 Query       UNLOCK TABLES
                1079123 Query       INSERT INTO fud26_msg (
                1079123 Query       INSERT INTO
                1079123 Query       UPDATE fud26_msg SET thread_id=19650 WHERE id=69694
                1079123 Query       SELECT
                1079123 Query       UPDATE fud26_msg SET apr=1 WHERE id=69694
                1079123 Query       SELECT MAX(id),count(*) FROM fud26_msg WHERE poster_id=2543 AND apr=1
060830 15:41:33 1079123 Query       SELECT id FROM fud26_level WHERE post_count <= 332 ORDER BY post_count DESC LIMIT 1
                1079123 Query       UPDATE fud26_users SET u_last_post_id=69694, posted_msg_count=332, level_id=1 WHERE id=2543
                1079123 Query       SELECT seq FROM fud26_tv_7 ORDER BY seq DESC LIMIT 1
                1079123 Query       SELECT fud26_thread.id FROM fud26_tv_7
                1079123 Query       DELETE FROM fud26_thread WHERE forum_id=7 AND moved_to>0 AND last_post_date<1156714892
                1079123 Query       LOCK TABLES fud26_tv_7 WRITE
                1079123 Query       SELECT seq,iss FROM fud26_tv_7 ORDER BY seq DESC LIMIT 1
                1079123 Query       INSERT INTO fud26_tv_7 (thread_id,iss,seq) VALUES(19650,0,1137)
                1079123 Query       UNLOCK TABLES
                1079123 Query       UPDATE fud26_forum SET post_count=post_count+1, thread_count=thread_count+1, last_post_id=69694 WHERE id=7
                1079123 Query       INSERT IGNORE INTO fud26_search (word) VALUES ('test'),('blah')
                1079123 Query       INSERT INTO fud26_title_index (word_id, msg_id) SELECT id, 69694 FROM fud26_search WHERE word IN('test','blah')
                1079123 Query       INSERT INTO fud26_index (word_id, msg_id) SELECT id, 69694 FROM fud26_search WHERE word IN('test','blah')
                1079123 Query       SELECT u.email
                1079123 Query       SELECT p.total_votes, p.name AS poll_name, m.reply_to, m.subject, m.id, m.post_stamp, m.poster_id, m.foff, m.length, m.file_id, u.alias, m.attach_cnt, m.attach_cache, m.poll_cache FROM fud26_msg m LEFT JOIN fud26_users u ON m.poster_id=u.id LEFT JOIN fud26_poll p ON m.poll_id=p.id WHERE m.id=69694 AND m.apr=1
                1079123 Quit