Zikula_Value_Addons
[ class tree: Zikula_Value_Addons ] [ index: Zikula_Value_Addons ] [ all elements ]
Packages:
Zikula 1.0.1
axmls
PHPLayersMenu
PHPMailer
phpSniff
pnForm
PostNuke_Core
RC4Crypt
SafeHTML
Services_JSON
SimplePie
Smarty
Xanthia_Templating_Environment
XML_HTMLSax3
ZikulaTemplate_Plugins
Zikula_Core
Zikula_Docs
Zikula_System_Modules
Zikula_Template_Plugins
Zikula_Themes
Zikula_Value_Addons

Source for file pntables.php

Documentation is available at pntables.php

  1. <?php
  2. /**
  3.  * Zikula Application Framework
  4.  *
  5.  * @copyright (c) 2002, Zikula Development Team
  6.  * @link http://www.zikula.org
  7.  * @version $Id: pntables.php 24342 2008-06-06 12:03:14Z markwest $
  8.  * @license GNU/GPL - http://www.gnu.org/copyleft/gpl.html
  9.  * @package Zikula_Value_Addons
  10.  * @subpackage Banners
  11.  */
  12.  
  13. /**
  14.  * This function is called internally by the core whenever the module is
  15.  * loaded.  It adds in the information
  16.  */
  17. function Banners_pntables()
  18. {
  19.     // Initialise table array
  20.     $pntable = array();
  21.  
  22.     // Main banners column
  23.     $pntable['banners'] = DBUtil::getLimitedTablename('banners');
  24.     $pntable['banners_column'] = array('bid'       => 'pn_bid',
  25.                                        'cid'       => 'pn_cid',
  26.                                        'type'      => 'pn_type',
  27.                                        'imptotal'  => 'pn_imptotal',
  28.                                        'impmade'   => 'pn_impmade',
  29.                                        'clicks'    => 'pn_clicks',
  30.                                        'imageurl'  => 'pn_imageurl',
  31.                                        'clickurl'  => 'pn_clickurl',
  32.                                        'date'      => 'pn_date');
  33.     $pntable['banners_column_def'] = array('bid'      => 'I AUTOINCREMENT PRIMARY',
  34.                                            'cid'      => "I NOTNULL DEFAULT '0'",
  35.                                            'type'     => "C(2) NOTNULL DEFAULT '0'",
  36.                                            'imptotal' => "I NOTNULL DEFAULT '0'",
  37.                                            'impmade'  => "I NOTNULL DEFAULT '0'",
  38.                                            'clicks'   => "I NOTNULL DEFAULT '0'",
  39.                                            'imageurl' => "C(255) NOTNULL DEFAULT ''",
  40.                                            'clickurl' => "C(255) NOTNULL DEFAULT ''",
  41.                                            'date'     => 'T DEFAULT NULL');
  42.     // add standard data fields
  43.     ObjectUtil::addStandardFieldsToTableDefinition ($pntable['banners_column'], 'pn_');
  44.     ObjectUtil::addStandardFieldsToTableDataDefinition($pntable['banners_column_def']);
  45.  
  46.  
  47.     // Advertising clients
  48.     $pntable['bannersclient'] = DBUtil::getLimitedTablename('bannersclient');
  49.     $pntable['bannersclient_column'] = array('cid'       => 'pn_cid',
  50.                                              'name'      => 'pn_name',
  51.                                              'contact'   => 'pn_contact',
  52.                                              'email'     => 'pn_email',
  53.                                              'login'     => 'pn_login',
  54.                                              'passwd'    => 'pn_passwd',
  55.                                              'extrainfo' => 'pn_extrainfo');
  56.     $pntable['bannersclient_column_def'] = array('cid'       => 'I AUTOINCREMENT PRIMARY',
  57.                                                  'name'      => 'C(60) NOTNULL',
  58.                                                  'contact'   => 'C(60) NOTNULL',
  59.                                                  'email'     => 'C(60) NOTNULL',
  60.                                                  'login'     => 'C(10) NOTNULL',
  61.                                                  'passwd'    => 'C(10) NOTNULL',
  62.                                                  'extrainfo' => "X2 NOTNULL");
  63.     // add standard data fields
  64.     ObjectUtil::addStandardFieldsToTableDefinition ($pntable['bannersclient_column'], 'pn_');
  65.     ObjectUtil::addStandardFieldsToTableDataDefinition($pntable['bannersclient_column_def']);
  66.  
  67.     // completed banners
  68.     $pntable['bannersfinish'] = DBUtil::getLimitedTablename('bannersfinish');
  69.     $pntable['bannersfinish_column'] = array('bid'         => 'pn_bid',
  70.                                              'cid'         => 'pn_cid',
  71.                                              'impressions' => 'pn_impressions',
  72.                                              'clicks'      => 'pn_clicks',
  73.                                              'datestart'   => 'pn_datestart',
  74.                                              'dateend'     => 'pn_dateend');
  75.     $pntable['bannersfinish_column_def'] = array('bid'         => 'I AUTOINCREMENT PRIMARY',
  76.                                                  'cid'         => "I NOTNULL DEFAULT '0'",
  77.                                                  'impressions' => "I NOTNULL DEFAULT '0'",
  78.                                                  'clicks'      => "I NOTNULL DEFAULT '0'",
  79.                                                  'datestart'   => 'T DEFAULT NULL',
  80.                                                  'dateend'     => 'T DEFAULT NULL');
  81.     // add standard data fields
  82.     ObjectUtil::addStandardFieldsToTableDefinition ($pntable['bannersfinish_column'], 'pn_');
  83.     ObjectUtil::addStandardFieldsToTableDataDefinition($pntable['bannersfinish_column_def']);
  84.  
  85.     // Return the table information
  86.     return $pntable;
  87.  
  88. }
Documentation generated on Fri, 18 Jul 2008 21:54:25 +0200 by phpDocumentor 1.4.1