Database Structure

Technical discussion for developers and service providers

Database Structure

Postby lygie » 5:46am, Thu 27 Sep, 2007

Hi,

does anyone know how a massage is marked for being send via prozessque in the database.

I am trying to put data from an other application directly into the database for being send via phplist.

There is no problem with data like footer, fromfield or the message text. But when I try to send the message queue from the phplist backend or via command line, my message is not being send.

Thanks
lygie
PL Nut
 
Posts: 19
Joined: 11:17am, Tue 24 Jul, 2007

sending email programmatically

Postby James Price » 1:52am, Thu 28 Feb, 2008

Here's the sql setup for the code I use. It works if I process the queue manually... now if I can get my host to run a cron job I will be in business:

Code: Select all
      
             $sendformat = "html";
         $template = "0"; 
           
                         //$table_prefix is from phplists config.php file
         //add the message, with a status of 'submitted'
         $addMessageQuery = "insert into " . $table_prefix . "message
            (
               subject,
               message,
               entered,
               modified,
               embargo,
               repeatuntil,
               sendformat,
               template,
               status,
               owner
               ) VALUES (
               '$subject',
               '$email',
               '$now',
               '$now',
               '$embargo',
               '$repeatuntil',
               '$sendformat',
               '$template',
               'submitted',
               '1')";//assign admin as owner of all messages, for now.
James Price
phpLister
 
Posts: 10
Joined: 2:52pm, Fri 22 Feb, 2008


Return to Developers Space

Who is online

Users browsing this forum: No registered users and 2 guests