mass email DB help!

This mod, will add the ability to make "newsletters" and other customised mass emails, status is showen while sending mass email
It will also be posible to grant other users permissions to send mass email to a specific usergroup
Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

mass email DB help!

Postby kfc on Fri 17. Oct, 2003 21:52

The first thing this mod tells me to do when installing is this...

Code: Select all
#
#-----[ ADD SQL ]------------------------------------------
#
ALTER TABLE groups ADD group_allow_email TINYINT (2) DEFAULT "5" NOT NULL


But I don't know how to add it! I copied ALTER TABLE groups ADD group_allow_email TINYINT (2) DEFAULT "5" and put it in a sql file and had the db update from that file. But it gave me an error that phpbb.grous didnt exist. So what do i do?

THANKS
kfc
Poster
Poster
 
Posts: 2
Joined: Fri 17. Oct, 2003 21:45

Postby Niels on Fri 17. Oct, 2003 23:05

phpBB2 can use a prefix on your DB tables, usually this is phpbb_
if you are executing the db_update.php file, this file will automatically use the prefix you are using.

you may also look this up in ACP -> general config and change the SQL so it uses your prefix.

e.g.
ALTER TABLE phpbb_groups ADD group_allow_email TINYINT (2) DEFAULT "5" NOT NULL
(if a how-to is EM ready, it will mostly be bullet prof, since a machine is more picky than a human. :D)
User avatar
Niels
Poster
Poster
 
Posts: 4390
Joined: Sat 27. Jul, 2002 15:46

Postby kfc on Fri 17. Oct, 2003 23:53

okay 1 second after i posted this i found out what i was doing wrong.

but btw.. i think the readme is written fairly bad. because this line makes no sence...

Code: Select all
#
#-----[ FIND ]------------------------------------------
#
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_type =

#
#-----[ IN-LINE FIND ]------------------------------------------
#
$group_moderator

#
#-----[ IN-LINE AFTER,ADD ]------------------------------------------
#
, group_allow_email='$group_allow_email'


I think that I'll just hack apart at the admin_send_email.tpl since it will do what I want anyways.

and this folder does not even exist...

Code: Select all
#
#-----[ COPY ]------------------------------------------
#
copy lang_mass_email.php to language/english/lang_mass_email.php
kfc
Poster
Poster
 
Posts: 2
Joined: Fri 17. Oct, 2003 21:45

Postby Niels on Tue 21. Oct, 2003 01:17

Nice to hear you go it working :D
for a user, witch try instal a mod for the first time, it might not make sence, but this is the way a how-to should be written - with as small as posible find tag.

a FIND tag should not include the complete line, only some ditigues words from it.
this is due to the fact that automatically installation will fail if meny mods are install AND the find tags are to long.
so even thogh the FIND does not mentioned the IN-LINE FIND, it could be pressent latter in the same line.

hope you understand.


as for your secound problem.
the folder language/lang_english should exist, as this is installed as default - and should NEVER be removed - english is a ecential language for the script to work - simply due to the fact that it will default to this if something goes wrong.
(if a how-to is EM ready, it will mostly be bullet prof, since a machine is more picky than a human. :D)
User avatar
Niels
Poster
Poster
 
Posts: 4390
Joined: Sat 27. Jul, 2002 15:46


Return to Custom mass email [2.0.8/EM]

Who is online

Users browsing this forum: No registered users and 0 guests

cron