[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
phplist forums • View topic - Basic sql query for plugin

Basic sql query for plugin

Technical discussion for developers and service providers

Basic sql query for plugin

Postby E15BAER » 7:14pm, Tue 09 Apr, 2013

I am building a very basic plugin which simply adds a menu item and link to execute a sql query which moves messages from Drafts to Sent. We often wind up viewing sent messages in edit mode which moves them to Drafts.

The direct query is:
'UPDATE phplist_message SET status = "sent" WHERE processed > 0'

I have the plugin, page, and link ready to execute whatever function I add to refreshsent.php when clicked.

What is the best way to approach this function so it properly utilizes phplist's sql abstraction and sanitation?
phpList newbie
Posts: 3
Joined: 9:41pm, Wed 23 Jan, 2013

Re: Basic sql query for plugin

Postby duncanc » 8:57am, Wed 10 Apr, 2013

Posts: 2440
Joined: 6:34am, Sat 08 May, 2010
Location: London

Return to Developers Space

Who is online

Users browsing this forum: No registered users and 1 guest