Modify

Opened 8 years ago

#1187 new enhancement

Send Reminders to all existing trac-users

Reported by: anonymous Owned by: zerodeux
Priority: normal Component: TracReminderScript
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

I have implemented it already at my script. If you find it usefull you can integrate it into your script. Adapted sqlite to sqlite3.

28a29
>   echo "Send to all trac-users: $0 <trac-path> --trac-users"
36c37
< tickets=`sqlite "$db" "select id,owner,status,summary from ticket where status='new' order by id desc"`
---
> tickets=`sqlite3 "$db" "select id,owner,status,summary from ticket where status='new' order by id desc"`
49c50
< # Send news. Properly fill in RFC 822 fields (especially To and Cc).
---
> 
50a52
> # Send news. Properly fill in RFC 822 fields (especially To and Cc).
51a54,62
> 
> # J. Erik Heinz: 2007-02-07
> # Get email adresses of all trac-users from the system 
> # Usage with option: --trac-users
> if test "$1" == '--trac-users'; then
>       emails=`sqlite3 "$db" "select var_value from session where var_name='email'"`
>       all=`echo $emails | sed -e 's/,/ /g'`
> fi
> 

Cheers -- Erik

Attachments (0)

Change History (0)

Add Comment

Modify Ticket

Action
as new The owner will remain zerodeux.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.