Location: PHPKode > projects > Esvon Personals > esvon-personals/modules/Mailing_Lists/hw_info.php
<?php

// --------------------------------------------------------------------------
//
// Esvon Classifieds v.4.0
// Copyright(C), Esvon LTD, 2001-2010, All Rights Reserved.
// E-mail: hide@address.com
//
// All forms of reproduction, including, but not limited to, internet posting, 
// printing, e-mailing, faxing and recording are strictly prohibited.
// One license required per site running Esvon Classifieds. 
// To obtain a license for using Esvon Classifieds, please register at
// http://www.esvon.com/pg/products/p_classifieds/
//
// --------------------------------------------------------------------------

$A_MOD = array(
  'dir' => 'Mailing_Lists',
  'descr' => 'Mailing Lists for visitors of this site',
);

$A_CFG = array(
  'EN_OPT_IN' => 1,
);

$A_TBL = array(
  
  'list' => "CREATE TABLE list (
   id int(11) unsigned NOT NULL auto_increment,
   list_id smallint(5) unsigned NOT NULL,
   email varchar(80) NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE (list_id, email))",

  'pending' => "CREATE TABLE pending (
   list_id smallint(5) unsigned NOT NULL,
   email varchar(80) NOT NULL,
   code varchar(20) NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (list_id, email))",

  'temp' => "CREATE TABLE temp (
   log_id int(11) unsigned NOT NULL,
   email varchar(80) NOT NULL,
   extra text NOT NULL,
   PRIMARY KEY (log_id, email))",
      
  'idx' => "CREATE TABLE idx (
   id smallint(5) NOT NULL auto_increment,
   name varchar(100) NOT NULL,
   hide tinyint(3) unsigned NOT NULL,
   capture tinyint(3) unsigned NOT NULL,
   bottom_text text NOT NULL,
   descr text NOT NULL,
   PRIMARY KEY (id))",

  'log' => "CREATE TABLE log (
   id int(11) unsigned NOT NULL auto_increment,
   list_id smallint(5) NOT NULL,
   date date DEFAULT '0000-00-00' NOT NULL,
   is_html tinyint(3) unsigned NOT NULL,
   subj varchar(255) NOT NULL,
   content text NOT NULL,
   amount int(11) unsigned NOT NULL,
   status tinyint(3) unsigned NOT NULL,
   extra text NOT NULL,
   PRIMARY KEY (id),
   KEY list_id (list_id))",

  'unsub' => "CREATE TABLE unsub (
   list_id tinyint(5) NOT NULL,
   email varchar(80) NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   PRIMARY KEY (list_id, email))",

);

$A_FIELDS = array(

  TBL_USER => array(
    'hw_ml_list varchar(255) NOT NULL',
  ),

);

$A_EXTRA_SQL = array(

  "INSERT INTO idx (id,name,bottom_text,descr) VALUES 
   ('-2', 'Members with Ads', '', ''),
   ('-1', 'Registered Members', '', ''),
   ('1', 'General Info & Updates', ' To subscribe or unsubscribe via the World Wide Web, \n visit ##unsub_url##', 'General Information, Announces & Site Updates')",

);

?>
Return current item: Esvon Personals