The Arcive of vBulletin Modifications Site.

Mail users... · **Released**: 12-17-2002

I have a subforum called Updates.....now whenever I post a message in here all users should get an e-mail.

I tried to solve this by creating a mailing list and then copy all e-mailadresses and paste them in Moderation Options (Emails addresses to notify when there is a new post) of the Update forum.

BUT the PROBLEM is that this field is too short in length for all those e-mail adresses. Could someone help me? Do i need to change something in the database type or so?

Thanx

TECK · #2 12-19-2002, 04:30 AM

Is a template edit... I think. Just remove the field limit...

leon2u · #3 12-20-2002, 04:52 PM

....or is it in a PHP-file???

NTLDR · #4 12-20-2002, 06:08 PM

Most likly admin/forum.php

leon2u · #5 12-21-2002, 04:51 AM

It is not an template edit but a database edit.

I have changed the types VARCHAR(255) of the colums NEWPOSTEMAIL and NEWTHREADEMAIL in the table Forum to LONGBLOB which stands for LONG BINARY LARGE OBJECTS !

A LONGBLOB-field can hold up to 4,294,967,295 characters .
You can have also other binary field types such as mediumblob (which can hold up to 16,777,215 bytes), blob (which can hold up to 65535 characters), and tinyblob (which can hold up to 255 characters).

Now it works fine......cya