vb.org Archive

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)

btappan 10-24-2004 11:40 PM

uh, did you read any of this? its working for it now

ezsouljahs 10-28-2004 04:20 AM

Add a new phrase and make sure it is in the "posting" phrase type, otherwise it won't work

phrase: in_private_message
Text: Private Message

how do i add a new phrase

h75 11-10-2004 10:08 AM

I get an error, wenn i attach an txt-file an klick send. :nervous:
Quote:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
UPDATE attachment
SET private = , posthash = ''
WHERE posthash = '7812b835551ecc43a34408135f1b1774' AND
userid = 1

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 ' posthash = ''
WHERE posthash = '7812b8

mysql error number: 1064

Datum: 10.11.2004 13:05:01
Skript: http://halloo.de/private.php
Referer: http://halloo.de/private.php?do=newpm&pmid=619
Benutzername: H75
IP-Adresse:

h75 11-10-2004 10:40 AM

and this:

Quote:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage: INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES (, 1, -1, 1)
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 ' 1, -1, 1)' at line 1

mysql error number: 1064

Datum: 10.11.2004 13:07:40
Skript: http://halloo.de/private.php
Referer: http://halloo.de/private.php?do=newpm&pmid=619
Benutzername: H75
IP-Adresse::

seraphex 11-12-2004 03:09 AM

ok.. I've installed this and reverted back to my original files (other than my template edits) like 4 times. It looks like everything works except the attachment does not show up in the pm when it's opened. I just noticed that I had the following line wrong in my pm_newpm template. And I'm curious if this would cause the attachment to not show up. I'm almost done removing it and I hate to redo everything again just to find out that this had no effect on things. Here's the line I had wrong (just missing the closing >):
Code:

<input type="hidden" name="poststarttime" value="$poststarttime" /

vs.

<input type="hidden" name="poststarttime" value="$poststarttime" />


JKeats 11-18-2004 05:16 PM

nm... fixed. sorry.

Scerina 11-22-2004 12:49 AM

I just upgraded to version 3.03 and I am having problems editing the attachment.php file cause it differs from 3.0 and am sure the other files are the same way. I manage to edit private.php file with no problem.

Is this hack compatiable with version 3.03 and if so, what are the file modification instructions for it? Thanx in advance

T3MEDIA 12-12-2004 12:19 AM

Thank god I read this last post.

I thought they said this was 3.0.3 compatable.
I really dont like the idea of this site. Its soo cool that users help and put up hacks but It feels like we are greedy lab rats. I wish they made it that once its 100% its like a install. you click enter what ever and "patch" your site.
keeps a record and ya set. that way if I make a hack that confilcts you will know. blah blah does not work with this patch.

Im I crazy or does that make sense? shoot I would pay for that.

T3MEDIA 12-18-2004 11:17 PM

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.

BlasterT3 01-24-2005 08:12 PM

thanks alot for this hack i love it but i think i might of found a bug

as u can see in the attached img the file i attached in a pm shows up twice

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
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

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
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!!!

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
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.

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)
        );


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
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.

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

TouchStone 04-10-2005 05:53 AM

Hello I has chops inserted and gets if I with PM a file to attach wants:
Quote:

Apology, but in this forum no new contributions can be written.
Sorry for my bad English i'm a German User

Thanks for help

Text in German:
Hallo ich habe den HAck eingebaut und es geht auch soweit , nur wenn ich in den PM einen Anhang rein machen m?chte bekomme ich:
Quote:

Entschuldigung, aber in diesem Forum k?nnen keine neuen Beitr?ge geschrieben werden.
Wo liegt der fehler?

Mfg

TouchStone 04-10-2005 02:26 PM

Quote:

Originally Posted by TouchStone
Hello I has chops inserted and gets if I with PM a file to attach wants:


Sorry for my bad English i'm a German User

Thanks for help

Text in German:
Hallo ich habe den HAck eingebaut und es geht auch soweit , nur wenn ich in den PM einen Anhang rein machen m?chte bekomme ich:


Wo liegt der fehler?

Mfg

Please I need Help?

paulomt1 04-11-2005 02:22 PM

My friend. Nobody will help you here.
I have requested help for this hack a few times and nobody reply.
Exist lots of coders that can help you make this hack working for version 3.0.7, but nobody help. It's true :-(

TouchStone 04-11-2005 02:35 PM

I do not find that good, if one makes sowas should it also to support give? What can one make, I have chop now already drinne and it can actually if one Coden can not much be?

Marco van Herwaarden 04-11-2005 02:50 PM

According to the the installation instructions (i hope you used the 3.0.3 version), you should made some modifications to your attachment.php file. Please check if those edits are done correct, pay special attention to the second and the third modification in that file. Or one of the modifications to newattachment.php could be wrong.

TouchStone 04-11-2005 04:22 PM

no I have the 3.0.7, have that the version and only am too late seen, but up to the error all.I thinks times some Coder the error goes fast for repairing could?

Jagged Tooth 04-26-2005 12:25 PM

I have complted the hack up to executing the query. When i try to run it get this error. Also I have no prefix for my tables.

Quote:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index' at line 1
PHP Version: 4.3.10
mySQL version: 4.1.10a-standard
vBulletin Version: 3.07

Any help would be great.


--Jagged Tooth--

Marco van Herwaarden 04-26-2005 12:44 PM

If you are running the queries from your AdminCP, you can only run 1 statement at a time. A statement is ended by a semicolon ( ; ).

Execute 1 statement at a time.

Jagged Tooth 04-26-2005 12:50 PM

Thanks MarcoH64 got that working now. But now a new problem when I click the manage attachments button ig et this messege

Quote:

Sorry! This forum is not accepting new posts.
Any ideas


--Jagged Tooth--

paulomt1 04-26-2005 04:22 PM

I have the same error.
Only a coder can help us, but nobody are interested :-(


All times are GMT. The time now is 08:36 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01608 seconds
  • Memory Usage 1,840KB
  • 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
  • (7)bbcode_code_printable
  • (14)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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