vb.org Archive - [VB3 RC3] Attachments in private messages

Page 27 of 31

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - [VB3 RC3] Attachments in private messages (https://vborg.vbsupport.ru/showthread.php?t=59840)

gemmagy

02-24-2005 03:51 AM

Quote:

Originally Posted by BluPhoenix

Maybe too late now but here goes..

in includes/cron/cleanup2.php find:

Code:

$attachments = $DB_site->query("

                SELECT attachmentid, userid

                FROM " . TABLE_PREFIX . "attachment

                WHERE postid = 0 AND private = 0 AND

                dateline < " . (TIMENOW - 3600)

        );

and change it to:

Code:

$attachments = $DB_site->query("

                SELECT attachmentid, userid

                FROM " . TABLE_PREFIX . "attachment AS pmattach

                WHERE pmattach.postid = 0 AND pmattach.private = 0 AND

                pmattach.dateline < " . (TIMENOW - 3600)

        );

Thanks, I restored my forum back to wait for an answer. Will this take care of the naming of the tables? Support said I need to add a prefix to the name of the tables.

I really appreciate your help, I will give this a try in the next day or two.
gemmagy

msimplay

02-24-2005 06:18 AM

Quote:

Originally Posted by BluPhoenix

Maybe too late now but here goes..

in includes/cron/cleanup2.php find:

Code:

$attachments = $DB_site->query("

                SELECT attachmentid, userid

                FROM " . TABLE_PREFIX . "attachment

                WHERE postid = 0 AND private = 0 AND

                dateline < " . (TIMENOW - 3600)

        );

and change it to:

Code:

$attachments = $DB_site->query("

                SELECT attachmentid, userid

                FROM " . TABLE_PREFIX . "attachment AS pmattach

                WHERE pmattach.postid = 0 AND pmattach.private = 0 AND

                pmattach.dateline < " . (TIMENOW - 3600)

        );

would this work on vb3.0 ?

paulomt1

02-28-2005 12:13 AM

I had installed this hack in VB 3.0.7 but I have a problem!
When I click in the button Manage Attachments in new PM screen, opens the window for manage attachments but only say this:
Sorry! This forum is not accepting new posts.

Please help, I have lot's of PM with attachments and I need this working in this new version.

Thanks
Sorry my English.

smess

02-28-2005 01:46 PM

Does anyone have a clue as how to make this work for 3.0.3. I now have broken pictures and pm's that don't get attachements

DivisionByZero

03-03-2005 01:24 AM

Quote:

Originally Posted by paulomt1

yeah me too... same error!

DivisionByZero

03-04-2005 01:27 PM

hello????

josian

03-06-2005 11:14 PM

Im using file system for attachments storage, how can I use this hack if the code is written only for db storage type?

Also, can I limit the extensions to be allowed in the PM? apart from the regular forum extensions.

thanks!!

bkaul

03-14-2005 02:28 AM

Hmm... looks like an interesting hack; I might try it if I see verification that it works in 3.0.7...

jbell

03-29-2005 06:33 PM

what would be the syntax to uninstall should I ever need to?

paulomt1

04-08-2005 08:19 AM

Anyone can fix this hack for working in vb 3.0.7?
I really need this one. I can pay for it.

Thanks
Thinking Games

All times are GMT. The time now is 08:14 AM.

Page 27 of 31

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01259 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: