Private Message Sound Notification

[350Chevy]

Private Message Sound Notification plays a random .wav file whenever your users recieve a Private Message. I have included 10 .wav files in the zip that you can use or you can find and replace the .wav files with any file(s) of your choosing.

This is installed at: http://www.lssix.com (You will have to register and just PM yourself to test.)

- This used to be installed on my site running vB2 and was originally requested by myself and written by EvilLS1 (https://vborg.vbsupport.ru/showthread.php?t=45812).

DATABASE QUERY (1)

FILE MODIFICATIONS (2)

global.php
profile.php


TEMPLATE MODIFICATIONS (2)

navbar
modifyoptions


ADD PHRASE (1)

FEATURES:


Plays ten(10) random .wav files when a user recieves a PM (you can change this to any number)
User CP option to allow your users to turn the sounds on/off
Plays the .wav file from any page on your forum as the code is located in the navbar template
Sounds are ON by default
Sounds do NOT play when you enter the User CP or when entering the Private Messages. Thanks to EvilLS1! (https://vborg.vbsupport.ru/showpost.php?p=516738&postcount=17)
Sounds do NOT play if the member is a part of a special usergroup who does not have access to read PMs. Thanks to Onkel_Tom! (https://vborg.vbsupport.ru/showpost.php?p=524737&postcount=56)


* Last Updated 06/20/2004

For more sounds click here (https://vborg.vbsupport.ru/showpost.php?p=516604&postcount=10) - Thanks to colicab-d for providing a few more sounds. :)

[EvilLS1]

I'll add this one 350. Thanks! :)

[dcevoclub]

*installed* :)

[Boofo]

Installing and clicking! ;)

[shelaby]

Nice Hack!
*installed and klicked* :D

[RichieBoy67]

Installing now! Thanks...nice one...

[350Chevy]

Didn't realise anyone else would want this, I wasn't even going to release it because I didn't want to waste anyone's time. Thank EvilLS1 for talking me into it. https://vborg.vbsupport.ru/external/2004/05/1.gif

Glad everyone likes it. :)

[RichieBoy67]

I love this hack! Installed in about 5 minutes without a hitch... Totally cool bro..

Thanks

[Boofo]

Didn't realise anyone else would want this, I wasn't even going to release it because I didn't want to waste anyone's time. Thank EvilLS1 for talking me into it. http://www.lssix.com/forums/images/smilies/icon_lol.gif

Glad everyone likes it. :)
If EvilLS1 backs it up, then it is the hack to have. ;)

[colicab-d]

Great hack heres some new sounds :)

Classic Beep
Txt Messge

[MaxScript]

is there an AOL sounds package ?

[Revenge]

Hm, plays also sound when I go in the Usercp and click any link... every time a new page is loaded...???

[mharmon]

This is a great hack but I agree with the above comment... Is there anyway to make this so it will play ONCE per session? You have to listen to it 3 times before you actually read your message.

[350Chevy]

I did this so it played on every page no matter what page your users were viewing.

You can take the $sound out of the navbar template and just place it in the FORUMHOME template anywhere you wish. If you do that it will only play the wav file when they're on the Forum's home page. Since it's a random sound I don't think users mind hearing a different sound two times more before reading thier message. And with the option to turn it off they can disable it if choosen.

Adding the option not to play a sound when entering the private messages would require much more hacking and not really worth it. ;)

[350Chevy]

is there an AOL sounds package ?


What are you looking for?

Here you can find some AOL "YOU GOT MAIL" type message .wav files. :)

http://www.emailgifsandsounds.com/index-eng.html

[350Chevy]

I've also noticed about 3 or 4 of you that posted haven't clicked the "installed" link. :) Please click it if you plan to keep it.

As for the sound being played after you enter the Private Message panel I'll look into changing that. Pretty tired now though and the weekend ahead I doubt I'll be able to get to it until Monday (if I can even do it at all.. lol)

[EvilLS1]

Adding the option not to play a sound when entering the private messages would require much more hacking and not really worth it. ;)

You could use a conditional in the navbar template like this:


<if condition="THIS_SCRIPT!='private'">
$sound
</if>


If ya also want to stop the sound when viewing the usercp use this:

<if condition="THIS_SCRIPT!='private' and THIS_SCRIPT!='usercp'">
$sound
</if>


Gotta love template conditionals. :)

[350Chevy]

Oh yeah.. never thought of that. Too tired lastnight. Thnx Evil. :)

First post updated. :)

[The Realist]

Installed.

Thanks M8 :)

[Revenge]

Perhaps there is an easy way, that the sound only plays once, so if the user does not read the mail it is still playing until he reads it?

[The Realist]

This is a good thing. At lease by playing the sound all the time, it makes them clear there inbox.

Perhaps there is an easy way, that the sound only plays once, so if the user does not read the mail it is still playing until he reads it?

[350Chevy]

Are you asking if you can make the sound play over and over?

Or are you asking that the sound only be played once?

I'm not sure I understand the question but both of those are easily possible. :)

[MindTrix]

Works perfect for me, thanks

[gmarik]

valuable one!

[Revenge]

>only be played once

Me and my english :D the last one... only one time to play. Perhaps in the moment the popup box popups :D

[alfaowner]

i agree, it should only play once really, any more than that and it would get disabled, which means no point in installing. great hack. if it does only play once until you read it, then rock on, ill install and click the button. keep up the great work. like your site btw

[gopherhockey]

I'm not sure whats going on, but I get this error every time I try change the PM sound option in the usercp:

Invalid SQL:
UPDATE user SET

showvbcode = 2,
pmpopup = 1,
pmsound = ,
maxposts = -1,
daysprune = 0,
timezoneoffset = '0',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = 1,
options = 35159
WHERE userid = 2

The only thing I think I did different was run the initial SQL query from the admincp rather than from phpMyAdmin like I ususally do...

If I look there is nothing in the pmsound table for any user..

The sound itself works fine though.

[alfaowner]

Hi chevy,

Do you know the code to only make it play once full stop, once I have that, id gladly install it.

Thanks

[350Chevy]

Sorry guys, been really busy with work and at home,

Revenge and alfaowner try putting this code in global.php:


if ($bbuserinfo['pmpopup'] == 2 AND $bbuserinfo['pmsound'] == 0)


instead of:

if ($bbuserinfo['pmsound'] == 0)


And that should make the sound play only once. But it will not play a sound at all if they have PM pop-up notifications turned off. I'll see if I can find away around that as well if you'd like.

Glad you liked my site alfaowner. :)

gopherhockey, if you're still having that problem check the lines of code in global.php and profile.php very closly. More then likely something is botched up in there. I've installed this on 3 test boards and my own without a hitch. Are you running any other hacks that could conflict with this one?

Thanks to everyone who likes it. :)

[will_lean]

this hack c :surprised: :surprised: l

one question before i install this how can i use this hack with the option to play the wav files on a seperate server.
(my host doesnt allow sound files) :ermm:

[350Chevy]

this hack c :surprised: :surprised: l

one question before i install this how can i use this hack with the option to play the wav files on a seperate server.
(my host doesnt allow sound files) :ermm:


Hrmmm... Server doesn't allow sound files? How strange! :)

in global.php edit this line to point to your sound files

find:

$sound = iif($bbuserinfo['pmunread'], '<embed src="sounds/message'.$srand_snd.'.wav" autostart="true" loop="0" hidden="true"></embed>');

change to example:


$sound = iif($bbuserinfo['pmunread'], '<embed src="http://www.lssix.com/forums/sounds/message'.$srand_snd.'.wav" autostart="true" loop="0" hidden="true"></embed>');


the above example should pull the sounds from my server..

if you wish to place the sounds elsewhere make sure you have the wav files installed on the other server all named messagexx.wav (xx denotes the number 1-10) and point it to that server and folder name. I haven't tested the above but don't see why it wouldn't work.

[neocorteqz]

Sweet addition.

/me clicks install.

Question, how many queries does it add? My guess would be one?

Thanks again for a cool hack.

[neocorteqz]

where do i set it to use more sounds?

Edit:

is anyone having problems in Mozilla??

And the pop up box is not popping up.

[350Chevy]

Sweet addition.

* neocorteqz clicks install.


Question, how many queries does it add? My guess would be one?

Thanks again for a cool hack.


I never tested, it shouldn't add any queries until a PM is sent. If anything then yes, one query.


where do i set it to use more sounds?


In global.php


srand(make_seed()); $srand_snd = rand (1,10);


change the number 10 in rand (1,10) to whatever number you wish. :)


And the pop up box is not popping up.


I just tested my board and the popups work fine for me with this. The code should not have any effect on the popups. ;)

[neocorteqz]

I never tested, it shouldn't add any queries until a PM is sent. If anything then yes, one query.



In global.php


srand(make_seed()); $srand_snd = rand (1,10);


change the number 10 in rand (1,10) to whatever number you wish. :)



I just tested my board and the popups work fine for me with this. The code should not have any effect on the popups. ;)


Thank you sir, other than popups not popping up, it works great. Nice Job. :)

I'll see if I messed something up. ;)

[Onkel_Tom]

nice hack, thanks !
clicked install

[Flow Fusion]

Very cool hack I get errors as well but yes I do have other hacks as well installed so my members will live.

[TTG]

Works well .. took 10mins to install ..

Thanks for that.

[350Chevy]

Very cool hack I get errors as well but yes I do have other hacks as well installed so my members will live.

What type of errors? Anything I can do to help?

[monstergamer]

some members are reporting that they dont hear any thing
what could be the problem?

[350Chevy]

some members are reporting that they dont hear any thing
what could be the problem?


Just some not all? Could be the type of browser they're using. Could be their volume control. Could be a number of other things. As long as you're using IE, Netscape, Mozilla and you yourself hear the sound when you receive a PM then you know you installed it correct. It's a user error on their end. ;)

[iceman11111]

Good stuff!

I love it!

[Flow Fusion]

Database error in vBulletin 3.0.1:

Invalid SQL:
UPDATE user SET
styleid = 22,
showvbcode = 1,
pmpopup = 1,
pmsound = 0,
maxposts = -1,
daysprune = -1,
timezoneoffset = '-5',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
options = 8055
WHERE userid = 241

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

mysql error number: 1054

Date: Saturday 12th of June 2004 11:30:58 AM
Script: http://www.giftedsouls.com/gs/profile.php
Referer: http://www.giftedsouls.com/gs/profile.php?do=editoptions

[350Chevy]

Database error in vBulletin 3.0.1:

Invalid SQL:
UPDATE user SET
styleid = 22,
showvbcode = 1,
pmpopup = 1,
pmsound = 0,
maxposts = -1,
daysprune = -1,
timezoneoffset = '-5',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
options = 8055
WHERE userid = 241

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

mysql error number: 1054

Date: Saturday 12th of June 2004 11:30:58 AM
Script: http://www.giftedsouls.com/gs/profile.php
Referer: http://www.giftedsouls.com/gs/profile.php?do=editoptions
did you add the query?

ALTER TABLE user ADD pmsound varchar(7) NOT NULL

:)

[zahco]

Thanks a lot
350Chevy
For this nice hack
and also i thank
colicab-d
For the Ziped sound files

Best regards
zahco

[Flow Fusion]

yeah that did it thanks alot this makes today a good day.

[dreamhost]

not sure why, but i get no sounds at all. I also get no errors anywhere. I made sure to change the sql injection to reflect my db prefix and that went in ok.
I also put the sounds dir in my site.com/sounds and also site.com/vb/sounds/ just in case it didn't have the path correct.
All themplates and both files were edited as instructed.
ideas?

[350Chevy]

What's the address of the site? I'll see if they work on my end or check the source code of the output on the page. Might just be a typo somewhere.. :)

[350Chevy]

yeah that did it thanks alot this makes today a good day.


Anytime, glad I could help and glad you like it. :)

[350Chevy]

not sure why, but i get no sounds at all. I also get no errors anywhere. I made sure to change the sql injection to reflect my db prefix and that went in ok.
I also put the sounds dir in my site.com/sounds and also site.com/vb/sounds/ just in case it didn't have the path correct.
All themplates and both files were edited as instructed.
ideas?


Just visited your site. Strange, it doesn't even call for the sound file. :ermm: Are you sure you dropped the $sound string in the navbar or somewhere in the header?

[zahco]

Dir 350Chevy
i installed the hack on my server and it works good with the sound and there are No proplems .

But i Am Asking about how Is the blinking Done (( when a Private Message arive the baner blink with red color ))
like this picture
http://arabswell.net/upload/users/notification1.gif

Best regards
zahco

[350Chevy]

Glad you like it! :)

The blink PM bar is a template hack located on www.vbulletintemplates.com here:

Blink PM (http://www.vbulletintemplates.com/mods/showthread.php?t=5623)

[zahco]

Dir 350Chevy
i have no words to thank you with.
thank you a lot

best regards

zahco

[RetroDreams]

350Chevy: Any chance there would be a future update that makes the WAV user selectable?

[350Chevy]

350Chevy: Any chance there would be a future update that makes the WAV user selectable?

Unfortunately I have no plans or use for this. I just wanted something simple that would make a noise when getting a PM is all. :)

[Onkel_Tom]

Hi, a small problem with this hack if the access to the PN system is not allowed by the admin for a special usergroup like "awaiting confirmation" and having the "New user welcome PN (https://vborg.vbsupport.ru/showthread.php?t=63269)" Hack installed.
The user get's the sound message that he has new PN but can't read the mail unless he confirms his registration and an admin has activated his account.

Solution:

find in Template Navbar:
<if condition="THIS_SCRIPT!='private' and THIS_SCRIPT!='usercp'">

$sound

</if>

replace it with:
<if condition="THIS_SCRIPT!='private' and THIS_SCRIPT!='usercp'">

<if condition="$show['pmstats']">$sound </if>

</if>

With this change vB first check if the PN system is activated and then play the sound. Otherwise no sound will played.

[350Chevy]

Nice work Tom! Thnx..

First post updated and credit given.. :)

[Spacey]

is there a way to get this to work as well at the pop up message? Only the sound works when you get a pm on my site now :(

[The Realist]

Im getting a Mysql error when A user tries and changed the sound notification.

I found out that I cannot find this from the install file:

OPEN profile.php

***** FIND *****

globalize($_POST, array('newstyleset' => INT, 'dst' => INT, 'showvbcode' => INT, 'pmpopup' => INT, 'umaxposts' => INT, 'prunedays' => INT,
'timezoneoffset', 'startofweek' => INT, 'languageid' => INT, 'threadedmode' => INT, 'invisible' => INT, 'autosubscribe' => INT,
'options', 'modifyavatar'));

Its not in my profile.php

HELP!

[The Realist]

Problem solved.

Im getting a Mysql error when A user tries and changed the sound notification.

I found out that I cannot find this from the install file:

OPEN profile.php

***** FIND *****

globalize($_POST, array('newstyleset' => INT, 'dst' => INT, 'showvbcode' => INT, 'pmpopup' => INT, 'umaxposts' => INT, 'prunedays' => INT,
'timezoneoffset', 'startofweek' => INT, 'languageid' => INT, 'threadedmode' => INT, 'invisible' => INT, 'autosubscribe' => INT,
'options', 'modifyavatar'));

Its not in my profile.php

HELP!

[350Chevy]

is there a way to get this to work as well at the pop up message? Only the sound works when you get a pm on my site now :(


Double check your code. It works perfectly fine with the pop-up window. I have tested this on a few sites with zero hacks installed and on my main site with multiple hacks installed and the pop up message for new PM works perfectly fine. ;)

Make sure you're adding below pmpopup = $pmpopup, and not replacing it. Also make sure profile.php has the 'pmpopup' => INT.


globalize($_POST, array('newstyleset' => INT, 'dst' => INT, 'showvbcode' => INT, 'pmpopup' => INT, 'pmsound' => INT, 'umaxposts' => INT, 'prunedays' => INT, 'timezoneoffset', 'startofweek' => INT, 'languageid' => INT, 'threadedmode' => INT, 'invisible' => INT, 'autosubscribe' => INT, 'options', 'modifyavatar'));


More than likely you have another hack installed that may have overwritten a piece of the popup message code or you replaced a line instead of added below. Either way this hack in no way shape or form if applied correctly henders the pmpopup. :)

[mackers8923]

* Installed

However, how would I go about getting the sound to play on my home portal page. Working fine on the forums page but it would be nice to have it playing on both..

I'm running VbPortal 3.0.0 Beta 2 & Vbulletin 3.0.3

[350Chevy]

I've never messed with vBPortal however it should be about the same as vBAdvanced. If your vBPortal calls for the navbar then it should already have the neccessary code to play the sound. If it does not call for the navbar template then you could simply add

$sound

at the top in your vBPortal template header or index template. You will have to copy the "/sounds" folder and all the wav files in the folder to your vbPortal folder (most likely the root of your website.)

Example: If you have your forum here: /home/www/forums. Your sound folder is here: /home/www/forums/sounds. You will have to copy that folder to /home/www so that you will also have a folder containing all the sounds called /home/www/sounds. That should do the trick. ;)

[mackers8923]

Hey it worked thank you very much, took all of 2 minutes to do.

Me is happy thanks again.....

[350Chevy]

Glad I could help and I'm very happy that you enjoy it.. :)

[turbidblue]

Okay so heres the deal, everything istalled fine, but,

some people can hear it, and others hear nothing...i dont even hear it. none of the members i tested with have it disabled...

i used the re-directing of the wav file from another server, cause my host doesnt allow sound files..

but the problem is (besides ME not hearing it) is that my member who did hear, it opened her windows media player and played the file...she said she got two pop ups, one for the notification of the PM and another that was a blank white page...

any thoughts on these problems???

[350Chevy]

i used the re-directing of the wav file from another server, cause my host doesnt allow sound files..

There in lies the problem. How are you trying to redirect? It's a bit strange that your host doesn't allow .wav files. I think I'd have to have a talk with my host if I were you. ;)

[turbidblue]

Hi,

I am using this redirect code for the wav file, i say wav file cause i am only using one..

$sound = iif($bbuserinfo['pmunread'], '<embed src="http://www.lssix.com/forums/sounds/message'.$srand_snd.'.wav" autostart="true" loop="0" hidden="true"></embed>');

mine looks like this

$sound = iif($bbuserinfo['pmunread'], '<embed src="http://www.washmeclean.com/downloads/sounds/message'.$srand_snd.'.wav" autostart="true" loop="0" hidden="true"></embed>');


any idea?

i am contacting my host to see if i can get 1 wav file to be accepted, to try and solve this :)

[350Chevy]

only one file? That could be it also. When the page loads it maybe looking for the other 9 wav files to play and not playing anything because there's no wav file. But it will play once it finally randomly hits that one wav file..

Since you're only using one wav file, instead of using:


$sound = iif($bbuserinfo['pmunread'], '<embed src="http://www.washmeclean.com/downloads/sounds/message'.$srand_snd.'.wav" autostart="true" loop="0" hidden="true"></embed>');

try using:

$sound = iif($bbuserinfo['pmunread'], '<embed src="http://www.washmeclean.com/downloads/sounds/message1.wav" autostart="true" loop="0" hidden="true"></embed>');

or change message1.wav to the name of the wav file you're using(testing) and see what happens. :)

[350Chevy]

Also, are you sure the file is at http://www.washmeclean.com/downloads/sounds/message1.wav? I could not find a folder on www.washmeclean.com called downloads/sounds?

[turbidblue]

omg! that worked!

well atleast for me it did!

thank you so much!

;)

[turbidblue]

Also, are you sure the file is at http://www.washmeclean.com/downloads/sounds/message1.wav? I could not find a folder on www.washmeclean.com called downloads/sounds?

its http://washmeclean.com/sounds/message1.wav

:) theres nothing on that site, its just for music and video files

i am so happy its working now!

:)

[350Chevy]

Glad you got it.. ;)

[Traxdata]

did you add the query?

ALTER TABLE user ADD pmsound varchar(7) NOT NULL

:)

Where do I add this query? :ermm:

[350Chevy]

You should be able to add this query through your Admin CP or by using a program called MyPHPAdmin.

In the Control Panel goto "Import & Maintenance" (usually located at the bottom of the control panel), then click on "Execute SQL Query". In the "Manual Query" box you can type the SQL query


ALTER TABLE user ADD pmsound varchar(7) NOT NULL


then click on "continue" to apply it.

Hope that helps. :)

[YLP1]

I would like to install this mod but I am not sure that it will work with VB 3.0.03? Can you tell if it will?

[turbidblue]

works fine on my 3.0.3 :)

[350Chevy]

I would like to install this mod but I am not sure that it will work with VB 3.0.03? Can you tell if it will?

Aye, like turbidblue states, works fine with 3.0.3. It should work fine with any 3.x.x :)

[WreckRman2]

Pretty neat... I installed it. Thanks!

[fortnox]

Does it go with an WMA or MP3 Audioformat.

Becaus at Sounddogs (http://www.sounddogs.com/catsearch.asp?Type=1) , i`ve found alot of sounds. :surprised:

Thanks for your help!

[Warlord]

I can't get this dang thing to work, and I have no idea why.

I thought maybe because my navbar is actually in my header I should try it in there and see if it works (I tried it in the navbar template, and it didn't work), but that didn't work either.

I get no errors, pop ups or sounds in mozilla.

In IE, I get sounds, but no pop-ups.

[WreckRman2]

I have a problem with this code:


globalize($_POST, array('newstyleset' => INT, 'dst' => INT, 'showvbcode' => INT, 'pmpopup' => INT, 'pmsound' => INT, 'umaxposts' => INT, 'prunedays' => INT,
'timezoneoffset', 'startofweek' => INT, 'languageid' => INT, 'threadedmode' => INT, 'invisible' => INT, 'autosubscribe' => INT,
'options', 'modifyavatar'));

When I change it I get an error when updating the profile options. I ran the Mysql update. Anyone else having this problem?

[Flow Fusion]

OK I don't know what I did wrong but for some reason I can't turn it back on. I mean I can't turn on the PM sound notification for myself. It won't stay selected.

[eblivion]

Sounds are ON by default
I want the sounds to be OFF by default. I changed the default value of the db field to "1". Is that all I need to do?

[xzibit]

resound together!

I get after the installation hacks always this error if I with the attitudes which change möchet.
e.g. pop the UP window activate or deaktiviern.
to me can one say where drann lies?

thank you

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
UPDATE user SET
styleid = 0,
showvbcode = 2,
pmpopup = 0,
pmsound = 0,
maxposts = 40,
daysprune = -1,
timezoneoffset = '1',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
options = 3415
WHERE userid = 2

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

mysql error number: 1054

[xzibit]

what do I have to make hereby?
perhaps is that my error?

***** QUERY *****
ALTER TABLE user ADD pmsound varchar(7) NOT NULL

[RetroDreams]

I've never messed with vBPortal however it should be about the same as vBAdvanced. If your vBPortal calls for the navbar then it should already have the neccessary code to play the sound. If it does not call for the navbar template then you could simply add

$sound

at the top in your vBPortal template header or index template. You will have to copy the "/sounds" folder and all the wav files in the folder to your vbPortal folder (most likely the root of your website.)

Example: If you have your forum here: /home/www/forums. Your sound folder is here: /home/www/forums/sounds. You will have to copy that folder to /home/www so that you will also have a folder containing all the sounds called /home/www/sounds. That should do the trick. ;)
It does not call the wav even though it uses the navbar?

Anyone have this working with vbAdvanced CMS?

[Elfo King]

I have a big little problem....the sound go only for me....for other admins & user not play the sound...im a superadmin...where is the problem ??
U can hel me?

[BoYagoob]

Is there any ability to let the user choose which sound he wants to here when reciving a new PM ?

Regards ..

[sim tech]

Ok - sorry to bug you on this one...

I have version 3.0.7 (nice and fresh - installed today)

I did the 2 php mods and triple checked them.

I did the 2 template mods and triple checked them as well.

I added the phrase in GLOBAL. checked okay too.

So I'm guessing there's only one thing left, and that's:
***** QUERY *****
ALTER TABLE user ADD pmsound varchar(7) NOT NULL
So I go to execute a SQL Query and choose the manual...

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

Help - my brain is too fried from doing the board upgrade and all the other hacks! :dead:

[AxEsLoCkEd]

*clicks install /me is happy*

[Snake]

Ok, when I run the query I get this error.

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

Any help?

[weaver]

Great hack :)

[Lee]

Great hack :)
I have installed the hack and it is working, but I have some that are trying to disable the feature and when they do they get an error...

Database error in vBulletin 3.0.7:

Invalid SQL:
UPDATE user SET
styleid = 0,
showvbcode = 1,
pmpopup = 1,
pmsound = ,
maxposts = 20,
daysprune = -1,
timezoneoffset = '-6',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = 1,
options = 7639
WHERE userid = 14699

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 '
maxposts = 20,
daysprune = -1,
timezoneoffset = '-

mysql error number: 1064

[Lee]

I have installed the hack and it is working, but I have some that are trying to disable the feature and when they do they get an error...
any help with my above question please?

[Marco van Herwaarden]

Are you sure you did both edits to profile.php?

[Lee]

Are you sure you did both edits to profile.php?
Thanks so much - when I installed the Community Bulletin hack, I wrote over the first profile.php edit from this hack. Fixed!

[350Chevy]

Thanks MarcoH64. Sorry speedpro50. I haven't had much time for support. I don't think I've even gone through these threads in over 6 months. I will try to check in now and then but my personal life has given me very little time for my computer life. :(

[Snake]

I don't think this will work on Firefox. I've just checked on Internet Explorer and it works fine.

[350Chevy]

Works in firefox just fine. ;)

[Snake]

What about for vB 3.0.7? Will it work? I don't think so.

[Lee]

What about for vB 3.0.7? Will it work? I don't think so.
I have it working on my 3.0.7 and install was fast and easy...:)

[altsounds]

I get the database error everyone was talking about before. I have re-checked the installation and all looks fine. But when you click to disable pm sounds in your options it gives that database error everytime.

[altsounds]

Anyone figured out how to not get the database error if someone tries to disable this??? It's a great feature but some people get annoyed that they can't turn it off.

[350Chevy]

altsounds, try uninstalling and reinstalling it.. Very carefully. It works just fine with no dB errors on 3.0.9 for IE and Firefox. Sounds like you have the same problem Speedpro had. Are you sure you did both edits to profile.php? His is now working properly.

[altsounds]

Ahha!!! Cheers 350Chevy for pointing me in the right direction :). Works fine now.

[350Chevy]

Glad to hear you got it working. :) Sorry for the late replies btw.

[unknowngiver]

Hey
i got this emailk

Database error in vBulletin 3.0.9:

Invalid SQL:
UPDATE user SET
styleid = 3,
showvbcode = 1,
pmpopup = 1,
pmsound = 0,
maxposts = -1,
daysprune = 0,
timezoneoffset = '5',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
options = 7543
WHERE userid = 186

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

mysql error number: 1054

Date: Tuesday 27th of September 2005 03:40:37 PM
Script: http://www.apkafuture.com/profile.php
Referer: http://www.apkafuture.com/profile.php?do=editoptions
Username: awaaz
IP Address: 6*******

[350Chevy]

You forgot to run the Query

ALTER TABLE user ADD pmsound varchar(7) NOT NULL

;)

[markbolyard]

Can anyone help with making this capable of working with vbulletin 3.5? I tried, however it did not work.

Thanks!

[barny11]

Installed on my test forum but having a strange problem with it.

Works great when you first enable it in user cp/edit options but then when i close internet explore and then return to the forum its stoped working.

If i go back to user cp/edit options and just save the page it works again fine untill i close IE.

most probably a problem with IE than with the hack i know, just wondered if anybody's had this Problem and knows how to fix it ?

thanks in advance guys :)

[Nitewalker]

hi im on VB 3.0.10..Justr outta curiosity, i installed this..
Did all edition as the instruction says...havent seen any errors..but its not even looking for those wav files

Thinking, it might be coz of any error in sound path, I copied the same sounds folder outside forums..I dun think i hav any luck on 3.0.10

If you are kind enuf, please check it out @ www.CCMTorrents.com

[49er]

Hi,
Is this mod compatable with V3.5 ?

Thx

[350Chevy]

Unfortunately it is not compatible with 3.5.x but Moya has rewritten the code to work with 3.5.x. Again, unfortunately I have been extremely busy and I didn't recieve his PM about it until recently and he wrote it about a month ago. :(

If he does not release his I will rewrite it and release one for 3.5.x when I find the time. But hopefully he'll release his soon and I'll add a link from this thread to his.

[paul41598]

can someone release this for 3.5?!

[AM Guvnor]

Yeah! I've been after this hack for 3.5!!

What a great Idea!!

Anybody? :)

[DjTaz]

This has been ported to 3.5 for anyone interested :

initially in this post by paul41598 :
https://vborg.vbsupport.ru/showthread.php?t=114234&highlight=pmsound

and i (grrrrr) didnt spot the port myself and re-wrote my own script to do something similar :
https://vborg.vbsupport.ru/showthread.php?p=980579#post980579