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

Page 26 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)

T3MEDIA

01-27-2005 12:21 PM

Quote:

Originally Posted by T3MEDIA

Ok works like a charm. Thank you. Only down side is the attachments stay. If I send a private message it should be on his/hers quota not mine. so if they want to keep it they can. also what if you want to send 3 differn people a picture of youself. you already have it saved on the site. so you cant re upload it. you have to delte your attachments. it should be a bit more seperate in that sense from forums.

Agreed. Can someone get a work around on this? Just have it put on that users quota and its fixed. Also maybe a cronjob to check to see if the user doesnt exist remove the PM.

This hack isnt finished if you think about it.
BUT what a nice idea. its like internal email now.

dookie

02-16-2005 02:00 PM

Is this hack working in 3.0.6?

gemmagy

02-18-2005 05:25 AM

I am brand new at this, I just got my database and tried to load this. I followed the directions very carefully. When I got to the part where I query I got the following error:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'scribble_forum.pmtext' doesn't exist

my forum is completely down now. Please help me.
Gemma

gemmagy

02-18-2005 06:01 AM

Quote:

Originally Posted by gemmagy

One more thing to add. When I go to my database on the server the file pmtext is there but it's titled jelsoft_pmtext,,,, not scribble_forum.pmtext. Every file is titled that way, with the jelsoft in front of the files. Am i going to have this issue everytime i do a query?????

gemmagy

02-18-2005 02:38 PM

I tried to contact vbulletin to see if they could help me this is their answer:

It sounds like you are trying to install a resource from vBulletin.org. We do not give support for customizations as we aren't the author of that code. I suggest to contact the author of this resource. Ask him to update his code to take table prefixes into account. Your table prefix is jelsoft_ if I remember correctly.

please help!!!

gemmagy

02-18-2005 02:43 PM

Quote:

Originally Posted by gemmagy

Here's the email I got from my database when one of the mods went into the GUI pm:

Database error in vBulletin 3.0.6:

Invalid SQL:
DELETE FROM jelsoft_attachment
WHERE postid = 0 AND private = 0 AND
dateline < 1108738351
mysql error: Unknown column 'private' in 'where clause'

mysql error number: 1054

and,,,,,,,,,,,,,,,,,,,,,

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT
pm.*, pmtext.*,
icon.title AS icontitle, icon.iconpath,
IF(ISNULL(pmreceipt.pmid), 0, 1) AS receipt, pmreceipt.readtime, pmreceipt.denied, attach
FROM jelsoft_pm AS pm
LEFT JOIN jelsoft_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN jelsoft_icon AS icon ON(icon.iconid = pmtext.iconid)
LEFT JOIN jelsoft_pmreceipt AS pmreceipt ON(pmreceipt.pmid = pm.pmid)
WHERE pm.userid=3 AND pm.pmid=128

mysql error: Unknown column 'attach' in 'field list'

mysql error number: 1054

T3MEDIA

02-18-2005 08:12 PM

Quote:

Originally Posted by T3MEDIA

bump?

gemmagy

02-18-2005 10:55 PM

Hi,

Can anyone please help me, my forum is down. Please see the other for posts I posted yesterday.

Please help!!
gemmagy

gemmagy

02-22-2005 07:40 PM

Bump!

Please read the previous four posts I posted.

Gemma

BluPhoenix

02-24-2005 01:34 AM

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)

        );

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

Page 26 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.01243 seconds Memory Usage 1,745KB 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 (2)bbcode_code_printable (4)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: