PM Attachments 3.5

[BluPhoenix]

Original Hack by Rigel Kentaurus (http://www.cemzoo.com)
Original Thread: https://vborg.vbsupport.ru/showthread.php?t=91220
See the original thread for details of the problems..

Basically everything has been fixed so this works with existing installs and not just clean ones, also no error message about a non-matching release anymore.. attachments are now correctly displayed as they would be in a thread and this hack No longer inteferes with non-pm attachments.. So all the good bits left (Attachments in Private Messages, using the existing usergroup permissions) and all the bad bits taken out.

Also I'm willing to support this hack, which is why I took the decision to start a new thread rather than use the existing one so I can easier support the hack and problems with this plugin not the old buggy one. (or at least that's the theory)

Please uninstall the old plugin first, thanks.

QuickFaq
I'm getting Invalid Post specified:
That means the plugin was unable to get attachments permissions for the user. The solution is to locate a thread in your forum (one that shouldn't be deleted in a long time, it doesn't matter if it's closed). Remember it's threadid
Go to Plugin Manager and click on "private attachments - get posthash and allow attachments"

Find: $_pmt = 1;


Replace the "1" with the threadid

[Boofo]

What would cause the "Invalid Post specified" error in the first place? ;)

[nexialys]

because this hack actually act like a "i take the permission from a thread, and apply it to the PM system"...

this means there is no permissions system for the PM attachments actually... missing!

[Boofo]

because this hack actually act like a "i take the permission from a thread, and apply it to the PM system"...

this means there is no permissions system for the PM attachments actually... missing!

Shouldn't there be one for PM attachments, too?

[TTG]

Tested a couple of times with different size and types of attachements .. no problems.
Very useful addition .. thanks BluPhoenix.
Clicked install.

[Andreas]

Some suggestions
- Make this into a Product with Install/Uninstall Codes so Users don't have to run Queries manually
- You can use Hook cron_script_cleanup for the Cron-Stuff so you don't need an additional File

[BluPhoenix]

Some suggestions
- Make this into a Product with Install/Uninstall Codes so Users don't have to run Queries manually
- You can use Hook cron_script_cleanup for the Cron-Stuff so you don't need an additional File

Boofo:
This works by tricking vbulletin that the pm is infact a thread, but on some systems the trick used to do that will fail. In such a case an old thread is used to hold the attachments in such a way that they are stored and viewed in the pm, but not viewed when the thread is viewed.

nexialys:
The permissions are still in effect if a usergroup does not have permission to send attachments they cannot send ones via pm either.

KirbyDE:
Thanks for the suggestions Kirby, I certainly plan to do just that once I've had some more A. Ok's for everything working as is.. I didn't want to make it too complex too soon and not be able to fix any little bugs that may come up.

TTG:
Good stuff, glad it's working for you.

[theArchitect]

Fantastic. My members really loved this hack and missed it one I upgraded to 3.5.0.

Although I have clicked install I haven't installed so I can't give you an a ok. I just want to get the e-mail letting me know the system has been updated to be a product.

[BluPhoenix]

Fantastic. My members really loved this hack and missed it one I upgraded to 3.5.0.

Although I have clicked install I haven't installed so I can't give you an a ok. I just want to get the e-mail letting me know the system has been updated to be a product.

Well I'm working on the product now.. Still learning when it comes to vb 3.5's way of doing things.. although I guess that's true of all of us *l*

[theArchitect]

Well I'm working on the product now.. Still learning when it comes to vb 3.5's way of doing things.. although I guess that's true of all of us *l*

I am just glad that people are prepared to build mods for those of us who don't have the skills. Many thanks to you and all the coders who contribute to this forum.

[jancarlo]

what I can modify for giving to the permissions to all the users even if in the forum the users simple they cannot enclose?

tnx
jancarlo

[Snake]

Some suggestions
- Make this into a Product with Install/Uninstall Codes so Users don't have to run Queries manually
- You can use Hook cron_script_cleanup for the Cron-Stuff so you don't need an additional File
Yes I would like to see this hack as a product or plugin, please.

[BluPhoenix]

what I can modify for giving to the permissions to all the users even if in the forum the users simple they cannot enclose?

tnx
jancarlo

A little more complex.. allow the usergroups to have attachments, but in the forum permissions manager you need to make sure each forum doesn't allow attachments, that way pm's can still have attachments while the forums do not..

[FleaBag]

Looking good here! Will keep an eye on it. :)

[jancarlo]

in Scheduled Tasks ---> Scheduled Task Manager ---> Private Attachments CleanUp ---> Run Now

Fatal error: Call to a member function on a non-object in /home/*******/public_html/includes/functions.php on line 4240 :ermm: ???

tnx
jancarlo

[BluPhoenix]

in Scheduled Tasks ---> Scheduled Task Manager ---> Private Attachments CleanUp ---> Run Now

Fatal error: Call to a member function on a non-object in /home/*******/public_html/includes/functions.php on line 4240 :ermm: ???

tnx
jancarlo

are you running RC2?

[.Tim]

I wanted to re-install this but have been paranoid since the last one wiped out 6 months worth of attachments. I installed this one, hopefully no problems. I'm still paranoid though and worried. haha! But I did make a backup this time.

[.Tim]

Whenever I send an attachment in a PM, nothing shows up in the message the user gets. I have attachments allowed on the forum, so that can't be why. If I copy and paste the attachment link after I upload it it works but it never shows up in the message. Hope that makes sense.

[jancarlo]

are you running RC2?

yes... :ermm:

vBulletin Versione 3.5.0 Release Candidate 2
Copyright ?2000 - 2005, Jelsoft Enterprises Ltd.

[dookie]

*Subscribes to this thread*
Very interesting. Hope it will be released as a product soon. :)

[.Tim]

Works great with 3.5 gold, my problem above is now resolved. :D

[mahdiyat`]

I installed it but when I clicked manage attachment bottun the error will show $idname error , and advice to contact admin
any help

[Boofo]

Works great with 3.5 gold, my problem above is now resolved. :D

How did you solve the problem?

[MaXxed]

Id love to offer this as a premium service to users...can this be controlled by usergroup? Both sending and receiving?

[.Tim]

How did you solve the problem?

I don't know, I removed the hack after having the problems and after installing 3.5 gold I reinstalled it for the hell of it to see if it'd work and it did.

[Snake]

I'm hoping to see this as a product or plugin.

[Colin F]

I'm hoping to see this as a product or plugin.

Snake, it is a plugin.

[Snake]

Oh really... Sorry my bad. I just woke up so I was kinda sleepy. :P

[troux]

<font color="Lime">*installed*</font>

It works great, but It'd be awesome if only certain groups could use the feature!

[Bubble #5]

Id love to offer this as a premium service to users...can this be controlled by usergroup?
Wow this is a great idea. Hope we can see it happen soon :)

[paulomt1]

Is not working on vb 3.5.0
Error: Invalid Post specified. If you followed a valid link, please notify the administrator

[Snake]

And who said it will work on 3.5.0 Gold?

[Keyser S?ze]

this is something ive never understood, why not give the PM attachments its own table in the database, so it doesnt have to run off the normal attachments table

my site the attachment table is 785MBs (rard), so its big, and it would run better if it had its own database table

-----------------

also, what if u have changed to file-system attachments, will that cause a problem for this hack?

snake - thats a rather snotty answer, the thread title does say 3.5, doesnt say RCx or gold, however the version does say RC2, but so many times i have seen known coders say "there were little changes from any of the RC versions to gold, so u can assume all 3.5 hacks work on gold"

tsk tsk

[Snake]

I think you're wrong buddy because according to the hack info it says...

vB Version: 3.5.0 RC2

Which means it doesn't and will NOT work on 3.5.0 Gold. ;)

[Boofo]

Is not working on vb 3.5.0
Error: Invalid Post specified. If you followed a valid link, please notify the administrator

Read the Quick FAQ in the first post for your answer. ;)

[Keyser S?ze]

was still a snotty answer regaurdless, we can always be polite

[.Tim]

And who said it will work on 3.5.0 Gold?

Me. I have 3.5.0 Gold and it works just fine. (my attachments don't have the "attached images" text or border but I promise you it's an attachment)

[TTG]

I think you're wrong buddy because according to the hack info it says...



Which means it doesn't and will NOT work on 3.5.0 Gold. ;)

Added image and zip to PM on 3.5.0 .. no problems on 3.5.0 gold :)

[Keyser S?ze]

may i ask, does this work if u r using a filesystem for attachments, and not the database?

[TTG]

may i ask, does this work if u r using a filesystem for attachments, and not the database?

I'm using a file system.

[DivisionByZero]

Works great with 3.5 gold, my problem above is now resolved. :Dsame here... works like a champ :)

[Snake]

Hmm great I'll definitly install this tonight!

[paulomt1]

Read the Quick FAQ in the first post for your answer. ;)

Thanks Boofo, it's working now.

[misuse]

Works great for me! Thanks for the hack very useful on my site.

[theArchitect]

The hack is working, however when I click on the attachments link in the User CP the attachment in the PM is not listed.

Does this mean that PM attachments will not be counted toward attachment quotas?

Edit: Plus, I don't like that it does not check if a user has attachment permissions. I have had to add an <if> statement to stop users without attachment permission from using the attachments in PMs system.

[BluPhoenix]

I've been busy working on a rewrite for this seeing as how 3.5 is now Gold, I'm hoping to release it in beta form by the end of the week..

[nexialys]

we're friday. end of week... lol

[WildSharky]

Sorry for being dumb lol But im getting this Sorry! This forum is not accepting new posts. and i cant find the Find: $_pmt = 1;

Replace the "1" with the threadid

To replace it.. where you said you look for it.

[BluPhoenix]

we're friday. end of week... lol

???

End of the week is Sunday in my World..

[BluPhoenix]

Sorry for being dumb lol But im getting this Sorry! This forum is not accepting new posts. and i cant find the Find: $_pmt = 1;


Replace the "1" with the threadid

To replace it.. where you said you look for it.

Go to Plugin Manager and click on "private attachments - get posthash and allow attachments" It's near the top.

[illusions]

I dont know what I seem to be doing wrong...I followed the instructions but when I select the manage upload button ..a window opens followed by the following error message:

Invalid Post specified. If you followed a valid link, please notify the administrator

I tried changing the threadid but still geting the same msg...any help here plz?

[Terminator1138]

Thanks works as intended.

illusions: how did you get the thread ID? I used one of mine and it worked perfectly.

[Aeolian]

its about time to change the topic title..
either compatible with vb 3.5 gold or not..

its been while now..

[Snake]

Yeah you're right!

[BluPhoenix]

Sorry, the true 3.5 Gold Version is being delayed because of problems with quotas, I hope to release it soon..

Although this version as is does work with 3.5 Gold.. IF You just follow the instructions as they are set out, always take care when installing a modification, make sure code is added in the right place and that your editing the right templates.

[LeeWicKeD]

When i attach a file, it uploads without an error, but when i want to send the PM i get a Database error:


Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='2477';

MySQL-Fehler : Unbekanntes Tabellenfeld 'attach' in field list.
Fehler-Nr. : 1054
Datum : Saturday, October 15th 2005 @ 12:00:33 AM
Skript : http://www.xxx.de/forum/private.php
Referrer : http://www.xxx.de/forum/private.php?do=newpm&u=1
IP-Adresse : xxx
Benutzername : xxx
Klassenname : vb_database

edit: a i've got vb3.5 gold...seems not to work with.

[BluPhoenix]

Don't fully understand the language but it looks like you've not run all the sql queries needed when installing the hack. You need to add an attach to the pmtext table which it looks like you haven't done..

ALTER TABLE pmtext add attach int not null;

but make sure you've done all the other sql queries too (they are towards the very end of the install instructions)

[akanevsky]

Hey bro, are you sure this should use thread permissions for whether they can attach or not? I think this should be separate :)

[Andreas]

Yeah, would be nice if it was separate - unfortunately that doesn't seem to be that easy (without file edits).

[akanevsky]

How about a new user permission - "can attach files in PM"? :)

[Andreas]

That's not the problem. newattachment.php is :)

[akanevsky]

Umm... Doesn't newattachment.php receive something like posthash or something of that kind that identifies whether what it's for? I am not sure, but when I did the "attachment in calendar" hack, I did something like that to distinguish between attachment that were intended for posts and attachments that were intended for calendar entries :)

EDIT:

Oh... I remember - the way I did it was I added a new field to the attachment table that identified where the attachment had to belong.. didn't use permissions for threads... I'm sure this can be done for PMs too :)

[Mastar]

I ran this:
ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid)

And got this:
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 attachment add itemid int not null;
ALTER TABLE

Any Ideas??

[BluPhoenix]

Hey bro, are you sure this should use thread permissions for whether they can attach or not? I think this should be separate :)

Yes the true 3.5 Gold Version allows for seperate quotes and permissions for attachments in pm's than to threads.. So you can have a user set to no for pm attachments but yes for threads, and vice versa.. also a usergroup can have an unlimited quota for threads, but only 100Mb for PMs.. pm attachments are now stored in a seperate table or directory (depending on your file storage settings) right now it does require a number of edits but they are slowly being worked out of the final product..

A "Lite" Version (Zend Encoded and with a max of fifty pm attachments sent. so you can get a feel for how the system works) will be available shortly.

A "FULL" Version (Not Encoded and no Limits) is available now but due to the amount of work that has gone into this isn't free. As all commercial talk is a no-no. PM me for details.

[BluPhoenix]

I ran this:
ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid)

And got this:
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 attachment add itemid int not null;
ALTER TABLE


Any Ideas??

I assume your using the SQL Queries option in the AdminCP? If so Each Query must be run seperately one at a time.

[Mastar]

I assume your using the SQL Queries option in the AdminCP? If so Each Query must be run seperately one at a time.


Yes, thank you! No errors and everything seem to work great so far. Will post if anything changes. Thanks again!

[Robru]

version 3.5.0 GOLD

Please, see attachments. How I can showing the image?

[BluPhoenix]

version 3.5.0 GOLD

Please, see attachments. How I can showing the image?

You need to add a zip.gif file to your images/attach folder.

[BluPhoenix]

Installs: 69

*childish giggle*

[davidw]

ALTER TABLE pmtext add attach int not null; would not work (the others did)
#1060 - Duplicate column name 'attach'

Also, attachments can be uploaded, but none will be sent or displayed in pm.

[FleaBag]

Any idea if this is working with 3.5.0 Gold?

[.Tim]

Works for me:

https://vborg.vbsupport.ru/showpost.php?p=786494&postcount=37

[cbr929rrerion]

Almost did not get it to work but I did.. Great tool !

Anyway to make the image show up in the private message rather than being a link..

?

[davidw]

I've not been able to get it to work yet. I've set it up 3 times already and I'm just going to wait until its "official" before I reattempt it.

[General_]

It work's fine. Great Work!

Here is the German Translation for German Users... I postet it here, because of Kentaurus rules... :nervous:

[redlabour]

It work's fine. Great Work!

Here is the German Translation for German Users... I postet it here, because of Kentaurus rules... :nervous:


Perfect Thanks @General_ and BluPhoenix ! ;)

But i get this at online.php if a User is attaching a File !

[Kuimera]

I get this when i click "Manage Attachments"

Invalid Post specified. If you followed a valid link, please notify the administrator

This the code i have, I cant find the $_pmt = 1;

$extraattachmentinfo = $db->query_first("
SELECT userid,itemid,usedin
FROM " . TABLE_PREFIX . "attachment AS attachment
WHERE attachmentid = " . $vbulletin->GPC['attachmentid'] . ""
);

if ($extraattachmentinfo['usedin'] == 'pmtextid')
{
$pmUsers = $db->query_first("SELECT toUserArray FROM ".TABLE_PREFIX."pmtext WHERE pmtextid='".$extraattachmentinfo['itemid']."'");
$toUserArray = unserialize($pmUsers['toUserArray']);

if ($toUserArray[$vbulletin->userinfo['userid']] != $vbulletin->userinfo['username'] && $extraattachmentinfo['userid'] != $vbulletin->userinfo['userid'])
{
print_no_permission();
}

// bad thing to do, modify the main array with an int so the & operations will be true, any suggestions to improve this? (no file mods allowed!!)
$vbulletin->userinfo['permissions'] = $vbulletin->bf_ugp_forumpermissions['canview'] + $vbulletin->bf_ugp_forumpermissions['canviewthreads'] + $vbulletin->bf_ugp_forumpermissions['cangetattachment'] + $vbulletin->bf_ugp_forumpermissions['canviewothers'];

$imodcache = array();
$imodcache[0] = array("".$vbulletin->userinfo['userid']."" => 1, 'permissions' => $vbulletin->bf_misc_moderatorpermissions["canmoderateposts"]);

}

[VBUsers]

ok i fixed my issue but now i try to load a regular small image and it takes too long. it doesnt load it can you please tell me why? i followed the steps thanks

[Kuimera]

*bump*

[VBUsers]

I get this when i click "Manage Attachments"

Invalid Post specified. If you followed a valid link, please notify the administrator

This the code i have, I cant find the $_pmt = 1;

$extraattachmentinfo = $db->query_first("
SELECT userid,itemid,usedin
FROM " . TABLE_PREFIX . "attachment AS attachment
WHERE attachmentid = " . $vbulletin->GPC['attachmentid'] . ""
);

if ($extraattachmentinfo['usedin'] == 'pmtextid')
{
$pmUsers = $db->query_first("SELECT toUserArray FROM ".TABLE_PREFIX."pmtext WHERE pmtextid='".$extraattachmentinfo['itemid']."'");
$toUserArray = unserialize($pmUsers['toUserArray']);

if ($toUserArray[$vbulletin->userinfo['userid']] != $vbulletin->userinfo['username'] && $extraattachmentinfo['userid'] != $vbulletin->userinfo['userid'])
{
print_no_permission();
}

// bad thing to do, modify the main array with an int so the & operations will be true, any suggestions to improve this? (no file mods allowed!!)
$vbulletin->userinfo['permissions'] = $vbulletin->bf_ugp_forumpermissions['canview'] + $vbulletin->bf_ugp_forumpermissions['canviewthreads'] + $vbulletin->bf_ugp_forumpermissions['cangetattachment'] + $vbulletin->bf_ugp_forumpermissions['canviewothers'];

$imodcache = array();
$imodcache[0] = array("".$vbulletin->userinfo['userid']."" => 1, 'permissions' => $vbulletin->bf_misc_moderatorpermissions["canmoderateposts"]);

}

the code your looking for is at the top of the template you need to look in
about 5 or 6th line i think

[predatorkill]

I ve run this query:

ALTER TABLE xxxx_attachment add usedin varchar(30) not null;

AND

I get the following mysql error:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT attachmentid
FROM xxxx_attachment AS attachment
LEFT JOIN xxxx_pmtext AS pmtext ON attachment.usedin='pmtextid' AND attachment.itemid=pmtext.pmtextid
WHERE
pmtext.pmtextid IS NULL
AND usedin<>''
AND itemid<>'';

MySQL Error : Unknown column 'usedin' in 'where clause'
Error Number : 1054

any solutions?Thanks in advance!

How can i revert the table back to normal?

[Kuimera]

the code your looking for is at the top of the template you need to look in
about 5 or 6th line i think

Hey m8, I put there the code I got, if you make a search, you will not find the "$_pmt = 1;"

Prob I?m dumb, dont know...

[WNxWakko]

Were do the attachments go? I attach to a PM, it lists it in the popup window, I submit. When I do it again, the popup window doesnt show it in my attach inventory, nor does it in my main attachment inventory. Is it just a floating attachment or something? Oh and where it would normally list my attach inventory, it says array and nothing more.

[Sychev_S]

I get this error when tryign to send pm with attachment:
Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='333';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Sunday, November 13th 2005 @ 01:54:34 PM
Script : http://www.talkinto.com/forums/private.php
Referrer : http://www.talkinto.com/forums/private.php?do=newpm&u=5
IP Address : 209.158.71.16
Username : Administrator
Classname : vb_database

I can also NO longer add regualr attachments to post...
anybody knows how to fix that?

[Sychev_S]

Nvermind.
I configured config.php to allow me run quiries from admincp (used to run form phpmyadmin).
I ran them, everything is back to normal but I still cannot send attachments. I attach them, but when other person opens pm he sees no attachments there. No errors.

[Sychev_S]

okey, I just deleted plugin and installed it again.
Works perfectly now! vb 3.5.0
Thank you!

[zendiver]

Will this work for 3.5.1?

[Snake]

Yes it will.

[zendiver]

Installed and works great.

[zendiver]

A little hasty I was. It works for me, BUT others get this error:

Close this window Manage Attachments
Upload Errors
Picture 23.jpg:
File system directory is not writable.

I thought this was storing the attachments to the same place the threads are? I checked my permissions there and they are set to 777

[zendiver]

BP, any news on an update to this?

Happy Holidays all.

[zooman]

Sorry to be thick but this is new to me. Right it is not working and it prop because of this

QuickFaq
I'm getting Invalid Post specified:
That means the plugin was unable to get attachments permissions for the user. The solution is to locate a thread in your forum (one that shouldn't be deleted in a long time, it doesn't matter if it's closed). Remember it's threadid
Go to Plugin Manager and click on "private attachments - get posthash and allow attachments"

Find: $_pmt = 1;


Replace the "1" with the threadid

this much I get.

Right now how should the replacement look?

1.
Find: $_pmt = the threadid ;
or something similar.

2.
Find: $_pmt = 123;


Or am I looking at this the wrong way?

Please help a vaild eg. would be very good.

[zooman]

bump

[zendiver]

zooman, the second way. It needs an integer number of an active thread that is on your board. What I would do would be find the BIGGEST forum, go to the very last page and the last post and use that thread id number.

[zooman]

Cheers all working now, used number post #2 :) I now understand why. I will have deleted the frist post as it will have been a test.

Again Cheers

[zendiver]

Glad I could help and that you got it working.

[matthias.m]

Does it work with vB 3.5.3???

And other Question: Can Picture-Attachments set to be visible in the PM instead of being a Link?

Greetings,
Matthias Moench

[redlabour]

It does !

[matthias.m]

It does !

Danke redlabour ;)

PS: Was tut es? Mit 3.5.3 funktionieren und/oder Bilder in der PM anzeigen?

---

Because it`s not fair to speak German on an International Board - here comes the Translation ;):

Thanks redlabour!

Post Scriptum: What does it do? Working with vB 3.5.3 and/or show Pictures in the PM?

Gr??e,
Greetings,
Matthias Moench

[redlabour]

Danke redlabour ;)

PS: Was tut es? Mit 3.5.3 funktionieren und/oder Bilder in der PM anzeigen?

---

Because it`s not fair to speak German on an International Board - here comes the Translation ;):

Thanks redlabour!

Post Scriptum: What does it do? Working with vB 3.5.3 and/or show Pictures in the PM?

Gr??e,
Greetings,
Matthias Moench

Schau mal hier : http://www.vbhacks-germany.com/forum/showthread.php?goto=newpost&t=2060

Take a look : http://www.vbhacks-germany.com/forum/showthread.php?goto=newpost&t=2060

;)

[himerus]

Schweeeeet....
worked like a charm. 3.5.2
Nice Hack

INSTALL

[IntoXiqu?]

I've the problem that only the admins and mods can use this function... When a normal user want to attach some files he get the message that he hasn't enough rights!

How can i change that?
I've the Version 3.5.3.

Thanks,
Cheers!

[Keyser S?ze]

i hate to sound like a fool but im still getting the invalid post error

i went to the right plugin and change the 1 to a thread that is very old and wont ever be seen or deleted (110)

but still i get the error also i tried other threads, but all give me the same error

wouldnt it be better to just make a new table for PMattachments

anyways, any suggestions?

[ConKien]

Sorry for a lil. off topic but can someone use this mod and make it for the calendar instead? I've spent so many days try to make a calendar attachment and ended up wipped out my forum after 2 months built it up!

[da_judge]

Running 3.5.3... Installed every thing twice... dont get any errors... but dont get attachments button / section at the bottom of the PM box... any ideas.. i have read all that is in this thread....

Cheers Judge

[Mickie D]

is this hack going to support usergroup permissions ?

also this hack would be better as said to use its own database or file DIR, i dont know why this is not a feature in vbulletin for members to allow sending files in private messages (as long as file sizes are limited and or there is a certain amount of space a user can have before they need to clean there storage box ?

well i think so anyway lol

[da_judge]

Running 3.5.3... Installed every thing twice... dont get any errors... but dont get attachments button / section at the bottom of the PM box... any ideas.. i have read all that is in this thread....

Cheers Judge


Sorry to be pain..

Judge

[Keyser S?ze]

did u do the template edits?

[da_judge]

yes m8... done both... files... well strange hey... like i say done em twice... I just saved.. or u think i should Save & Reload...

Cheers Judge

All sorted now... works a treat...
I forgot to enable plugins LMAO

[bashy]

Hi

EDIT: Sorted now, had to redo an edit :)

[LincolnForums]

couldnt get to work on my php5 and mysql5 server, could it be just an issue with that?

[DruidToolz]

I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='175';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance

[Kimah72]

Hi, I got everything changed but when I went to do the SQL Queries, I ran into error number: 1146
error desc: Table 'momswit_Forum.attachment' doesn't exist

also when running all of them at the same time, I get this error.

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 attachment add itemid int not null;
ALTER TABLE

I don't know what I am missing. Could you please help? This would be a nice hack to have on my board. Thanks! :)

[dsotmoon]

is this working ok in 3.5.4 ?

[DruidToolz]

Well i have all the modifications setup up on 3.5.4 I just wish there was an easier way then editing the sql query tables.. The reason i say this is i got a failed message which i didn't want to try it again unless i either backup my database or write over it and hope it doesn't mess up.. So please can someone help me with this.. Thnx

[GoodKarmaKid]

I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

https://vborg.vbsupport.ru/external/2006/03/3.jpg

[Rickie3]

I was cruising right through the installation with no problems right up until the sql query. I wasn't able to execute an sql query from the vb control panel? I've installed several other hacks without a problem.

Presumably has something to do with access read/write permissions for the database? Opened up the file manager from my web control panel and the folder permissions seemed to be set correctly. I opend up myphpadmin and was going to try and run the querys from the tables following the instructions but quickly got in over my head.

The easiest thing for me would probably be just to execute the query from the vb control panle.

Any help in pointing me in the right direction to execute the sql query would be appreciated.

Thanks,
Jason

https://vborg.vbsupport.ru/external/2006/03/3.jpg
you need to edit your config.php with your id to allow to run queries,go to your server where your forum is installed then find includes folder inside the includes folder you will find config.php look for this code note in my code id is set at 1,edit to your user id then save you will now be able to run queries from your admin CP hope that helps
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '1';

[gcphost]

Hey all I am able to upload images and possibly other items but im trying to upload a tar.gz, it uploads with no problem (so it seems) but when adding to mysql its adding the content of the binary to the db causing this:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO vb_attachment
(dateline, thumbnail_dateline, visible, userid, extension, filename, posthash, filehash, filesize, filedata)
VALUES
(1143537565, 1143537565, 1, 1, 'gz', 'GameCP-Master-Stable-0.9.9.85.tar.gz', 'd59e42333cabdd9a8beefd91d82bc5c3', '46ed6412a916564e3579c79019515e88', 1135938, '‹\0<’$D\0?Z xU?Š@J?(*?M?!,?5d%K?H\',K*?•?\"?UEUuw:,2+#?€ˆ

Any thoughts?

[Rickie3]

installed and working great thanx

[defcon_420]

I am also having a problem getting this to work.. What i am getting is this...

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE pmtext SET attach='1' WHERE pmtextid='175';

MySQL Error : Unknown column 'attach' in 'field list'
Error Number : 1054
Date : Monday, February 6th 2006 @ 05:18:56 PM
Script : http://**********/forum/private.php
Referrer : http://**********/forum/private.php?do=newpm&u=31
IP Address : **.***.**.**
Username : DruidToolz
Classname : vbdatabase

Could someone help me please.. Thnx in advance

i'm using 3.5.4 and get the same error as well... looks like there is no support for this one :confused:

[bashy]

Hi

Is there a way wo get this to work with the VBHack database please
cause when i try to download an attachment in the PM it says that
iam not allowed to download hacks in this forum lol??

[Ntfu2]

it doesnt work anyway bashy

[bashy]

this hack you mean?
It used to untill i installed the vbhack database :(

[kurtbarker]

hey mate, installed this, but when I click 'manage attachments' in a new PM, I get a permissions error saying I don't have the permission to view that page. any suggestions?

[Avalon111]

so this does not work with 3.5.4?
if not is there a alternative?

[kurtbarker]

don't worry bout that last error, it's right ;)

[kurtbarker]

works fine with 3.5.4, if you wanna test it let me know. i'll give you a test username and password to my forum, and send a pic via PM to yourself. See first hand how it works.

the problem I had is that it gets the attachment permissions from thread '1' by default, but if thread 1 is deleted, or has restircted access to certain usergroups, then it won't work. There are instructions in the initial post to change the thread to one that won't get deleted, and that everyone has access too

[Avalon111]

the problem I had is that it gets the attachment permissions from thread '1' by default, but if thread 1 is deleted, or has restircted access to certain usergroups, then it won't work. There are instructions in the initial post to change the thread to one that won't get deleted, and that everyone has access too
thanks for the info, i will test it @ my testforum

[redlabour]

Will it work in the Future with vBulletin 3.6 (http://www.vbulletin.com/forum/showthread.php?t=187654) ?

[precharge]

Tried it, after an hour, gave up :(

I think the problem is in the $_pmt

I tried several options.

I am using VbSEO, not sure if that matters.

Using vBulletin 3.5.4

Tried the first thread id and the last and several in betwen, nothing worked. Doesn't seem to be calling the hook. Can I recommend a product install?

[redlabour]

Still works with 3.6 ! :)

[Muellmann]

Very good! Runs also with Gold ;)

I was glad to early :p
If I click on any attachment in the PM, the Message
"Invalid Attachment specified" comes as "vBulletin Message".
The other Things on the Hack work. I can attach something to a PM,
then I can send it and even receive it, but the attachment is not
downloadable from the received PM in finally.

Another important Information:

This Hack is not compatible with the "Welcome PM" of vBulletin 3.60
If you enabled Welcome-PM, nobody can register on your Forum, all
People get a white Page. I lost about 250 new Members till I in finally
understood, that the PM-Hack not works with the Welcome-PM!

[version2]

I re-installed under 3.6 and well, it looks like it is uploading, but when viewing the PM all I get is a red X that is not clickable to view the attachement.

Any ideas?

[version2]

Some screenshots of what I see...

[redlabour]

@version2 - reinstall again. It works !

BluPhoenix was online at January last Time. Anyone can make a Port of 3.6 ?

[version2]

@version2 - reinstall again. It works !

BluPhoenix was online at January last Time. Anyone can make a Port of 3.6 ?
o_O

I did a complete reinstall. Made sure all of the sql queries were right. Everything. Ok. I will try again. I revert the templates and see if that makes a difference.

[parajsa]

i was going to unistall this plugin, coz is not working on vb3.6.0.

but i need a help, during install is been run this query:
ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid);

i deleted manually the first three fields usedin itemid attach , how about the last queue is there any problem, how can i deal with that?

[Paul M]

Open the table in phpmyadmin, find the index and delete it.

[parajsa]

ALTER TABLE attachment add index (usedin,itemid);

Hey Paul i cant find any index field in the attachment?
Maybe is something else?

[TVNettet]

can it be set so only admins can send attachments?

[kether1]

Does this really work in 3.6? I read in this thread it does and then others say it does not. Anyone using this in 3.6 on a regular forum?

Thanks!
Kether

[version2]

Does this really work in 3.6? I read in this thread it does and then others say it does not. Anyone using this in 3.6 on a regular forum?

Thanks!
Kether
Damn! I did a complete reinstall of all the vb 3.6 files. I uninstalled PM attachments fully and did a completely clean install and I am still getting the same errors that I attached above. Clicking on the screwed up thumbnail just says invalid link specified.

[version2]

And these are the errors I am talking about.

https://vborg.vbsupport.ru/showpost.php?p=1050280&postcount=134

[hotwheels]

I am getting the same error man.............

[Aeolian]

no luck here too..
would wait a stable release..

[kether1]

Any updates planned for this? I really would like to use this in 3.6.

Regards,
Kether

[hotwheels]

I have tried for several day's to get this to work, for what ever reason, i can't get it to pull the image......hopefully someone with better skills can get this working, it is really a kewl mod to have......

[redlabour]

Shit ... i really need this Hack.

I will never understand why this is not a Default Feature by vBulletin.

3.6.1 - invalid Links

[Spenser]

Is there any chance to get this thing working with 3.6.1?

[redlabour]

Watch this Suggestions :

English (http://www.vbulletin.com/forum/showthread.php?t=201267)

German (http://www.vbulletin-germany.com/forum/showthread.php?t=25888)

[Stoebi]

Is there any chance to get this thing working with 3.6.1?

Hi

Still working on it. Think i'll include options for usergroups and users. (can/can't upload attachs, can/can't see attachs within PM). Main part is ready.

Any suggestions? For 3.6.x only, sorrry.


Regards, Stoebi

[redlabour]

Any suggestions? For 3.6.x only, sorrry.


Suggestions ? Yes - please release it as a new Hack in 3.6 Section. :)

[Stoebi]

Suggestions ? Yes - please release it as a new Hack in 3.6 Section. :)
Yes :)

For your information:
Usergroup permissions -> can (not) download, can (not) upload PM attachments <- finally implemented.

ToDo:
User permissions -> can (not) download, can (not) upload <- PM attachments.



Regards, Stoebi

[redlabour]

Yes :)

For your information:
Usergroup permissions -> can (not) download, can (not) upload PM attachments <- finally implemented.

ToDo:
User permissions -> can (not) download, can (not) upload <- PM attachments.



Regards, Stoebi

Sounds very nice !

Will it be able to update the old Hack or did i need to uninstall ?

[Stoebi]

Sounds very nice !

Will it be able to update the old Hack or did i need to uninstall ?

Should be possible to overwrite the old hack.

User part is done. Product ready. Only the documentation is missing yet. Hate this....

Edit:
All done -> https://vborg.vbsupport.ru/showthread.php?p=1079188


Regards, Stoebi

[hotwheels]

It works............woot

I attached an a screen picture's showing it in use...... https://vborg.vbsupport.ru/showthread.php?p=1079655#post1079655

[Mys]

Does anyone have this installed and running with 3.6?

Any info is appreciated.

Thx.

:D

[bashy]

Hi

I had the thi hack installed but as it never worked i have decided to uninstall it.
Now since doing this i am getting db errors, such as below

When i installed the hack i had to run the following queries


ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid);

Now in the instructions there is no advice as to uninstalling the hack nor removing the said queries, it looks like my db error is something to do with the said queries as well.

Can anyone advise on how to undo what the queries did please?

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT userid,itemid,usedin
FROM attachment AS attachment
WHERE attachmentid = 3920;

MySQL Error : Unknown column 'itemid' in 'field list'
Error Number : 1054
Date : Sunday, March 25th 2007 @ 04:41:36 PM
Script : http://www.bashys-place.com/forums/a...0&d=1174816559 (http://www.bashys-place.com/forums/attachment.php?attachmentid=3920&d=1174816559)
Referrer : http://www.bashys-place.com/forums/s...ad.php?t=20049 (http://www.bashys-place.com/forums/showthread.php?t=20049)