PDA

View Full Version : Mail users...


leon2u
12-17-2002, 12:22 PM
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
12-19-2002, 04:30 AM
Is a template edit... I think. Just remove the field limit...

leon2u
12-20-2002, 04:52 PM
....or is it in a PHP-file???

NTLDR
12-20-2002, 06:08 PM
Most likly admin/forum.php

leon2u
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