WP File Manager
Current Path:
/
home
/
argothem
/
www
/
organecyberpresse
/
plugins
/
auto
/
mailshot
/
v4.0.1
/
base
/
Name
Action
..
mailshot.php
Edit
Editing: mailshot.php
<?php /** * Plugin mailshots * (c) 2012 Cédric Morin * Licence GNU/GPL v3 */ if (!defined('_ECRIRE_INC_VERSION')) return; /** * Déclaration des alias de tables et filtres automatiques de champs * @param array $interfaces * @return array */ function mailshot_declarer_tables_interfaces($interfaces) { $interfaces['table_des_tables']['mailshots'] = 'mailshots'; return $interfaces; } /** * Déclaration des objets éditoriaux * @param array $tables * @return array */ function mailshot_declarer_tables_objets_sql($tables) { $tables['spip_mailshots'] = array( 'editable' => false, // pas d'edition 'page'=>'', 'principale' => "oui", // auto-increment 'field'=> array( "id_mailshot" => "bigint(21) NOT NULL", "id" => "varchar(32) DEFAULT '' NOT NULL", "sujet" => "text NOT NULL DEFAULT ''", "html" => "longtext NOT NULL DEFAULT ''", "texte" => "longtext NOT NULL DEFAULT ''", "listes" => "text NOT NULL DEFAULT ''", "graceful" => "tinyint(1) NOT NULL DEFAULT 0", "from_name" => "text NOT NULL DEFAULT ''", "from_email" => "text NOT NULL DEFAULT ''", "total" => "bigint(21) NOT NULL", "current" => "bigint(21) NOT NULL", "failed" => "bigint(21) NOT NULL", "nb_read" => "bigint(21) NOT NULL", "nb_clic" => "bigint(21) NOT NULL", "nb_spam" => "bigint(21) NOT NULL", "date" => "datetime NOT NULL DEFAULT '0000-00-00 00:00:00'", "date_start" => "datetime NOT NULL DEFAULT '0000-00-00 00:00:00'", "date_alerte_fail" => "datetime NOT NULL DEFAULT '0000-00-00 00:00:00'", "statut" => "varchar(20) DEFAULT 'processing' NOT NULL", "maj" => "TIMESTAMP", ), 'key' => array( "PRIMARY KEY" => "id_mailshot", "KEY statut" => "statut", ), 'titre' => "sujet AS titre, '' AS lang", 'date' => "date", 'champs_editables' => array(), 'champs_versionnes' => array(), 'rechercher_champs' => array(), 'tables_jointures' => array(), 'statut_images' => array( 'init'=>'puce-planifier-8.png', 'pause'=>'puce-preparer-8.png', 'processing'=>'puce-proposer-8.png', 'end'=>'puce-publier-8.png', 'cancel'=>'puce-refuser-8.png', 'poubelle'=>'puce-supprimer-8.png', 'archive'=>'puce-archiver-8.png', ), 'statut_titres' => array( 'init'=>'mailshot:info_statut_init', 'pause'=>'mailshot:info_statut_pause', 'processing'=>'mailshot:info_statut_processing', 'end'=>'mailshot:info_statut_end', 'cancel'=>'mailshot:info_statut_cancel', 'poubelle'=>'mailshot:info_statut_poubelle', 'archive'=>'mailshot:info_statut_archive', ), 'statut_textes_instituer' => array( 'init'=>'mailshot:texte_statut_init', 'pause'=>'mailshot:texte_statut_pause', 'processing'=>'mailshot:texte_statut_processing', 'end'=>'mailshot:texte_statut_end', 'cancel'=>'mailshot:texte_statut_cancel', 'poubelle' => 'texte_statut_poubelle', 'archive' => 'mailshot:texte_statut_archive', ), 'texte_changer_statut' => 'mailshot:texte_changer_statut_mailshot', ); return $tables; } /** * Déclaration des tables secondaires (liaisons) * @param array $tables * @return array */ function mailshot_declarer_tables_auxiliaires($tables) { $tables['spip_mailshots_destinataires'] = array( 'field' => array( "id_mailshot" => "bigint(21) DEFAULT '0' NOT NULL", "email" => "varchar(255) NOT NULL DEFAULT ''", "date" => "datetime NOT NULL DEFAULT '0000-00-00 00:00:00'", "statut" => "char(4) DEFAULT 'todo' NOT NULL", // todo, sent, fail, [read, [clic]],[spam], [kill] "raw_feedback" => "varchar(25) DEFAULT '' NOT NULL", // le dernier feedback raw tel que remonte par le presta d'envoi "try" => "tinyint NOT NULL DEFAULT 0", // nombre d'essais ), 'key' => array( "PRIMARY KEY" => "id_mailshot,email", "KEY email" => "email", "KEY statut" => "statut" ) ); return $tables; }