Mercurial > defr > drupal > ad

annotate ad.install @ 1:948362c2a207 ad

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
update advertisement
author pierre
date Thu, 02 Apr 2009 15:28:21 +0000
parents d8a3998dac8e
children e5584a19768b
rev   line source
pierre@0 1 <?php
pierre@1 2 // $Id: ad.install,v 1.2.2.4.2.27.2.7.2.3 2009/03/27 20:11:13 jeremy Exp $
pierre@0 3
pierre@0 4 /**
pierre@0 5 * @file
pierre@0 6 * Advertisement module database schema.
pierre@0 7 *
pierre@0 8 * Copyright (c) 2005-2009.
pierre@0 9 * Jeremy Andrews <jeremy@tag1consulting.com>.
pierre@0 10 */
pierre@0 11
pierre@0 12 /**
pierre@0 13 * Ad module database schema.
pierre@0 14 */
pierre@0 15 function ad_schema() {
pierre@0 16 /**
pierre@0 17 * The ad table stores administrative information about each ad. The
pierre@0 18 * actual ad itself can be found in the appropriate ad type table.
pierre@0 19 */
pierre@0 20 $schema['ads'] = array(
pierre@0 21 'description' => 'The ad table stores administrative information about each ad. The actual ad itself can be found in the appropriate ad type table.',
pierre@0 22 'fields' => array(
pierre@0 23 'aid' => array(
pierre@0 24 'type' => 'int',
pierre@0 25 'not null' => TRUE,
pierre@0 26 'unsigned' => TRUE,
pierre@0 27 'default' => 0,
pierre@0 28 'description' => 'Unique ad ID. Equals to ad nid.',
pierre@0 29 ),
pierre@0 30 'uid' => array(
pierre@0 31 'type' => 'int',
pierre@0 32 'not null' => TRUE,
pierre@0 33 'unsigned' => TRUE,
pierre@0 34 'default' => 0,
pierre@0 35 'description' => 'The {users}.uid that owns this node; initially, this is the user that created it.',
pierre@0 36 ),
pierre@0 37 'adstatus' => array(
pierre@0 38 'type' => 'varchar',
pierre@0 39 'length' => 255,
pierre@0 40 'not null' => TRUE,
pierre@0 41 'default' => '',
pierre@0 42 'description' => 'Ad status',
pierre@0 43 ),
pierre@0 44 'adtype' => array(
pierre@0 45 'type' => 'varchar',
pierre@0 46 'length' => 255,
pierre@0 47 'not null' => TRUE,
pierre@0 48 'default' => '',
pierre@0 49 'description' => 'Ad type',
pierre@0 50 ),
pierre@0 51 'redirect' => array(
pierre@0 52 'type' => 'varchar',
pierre@0 53 'length' => 255,
pierre@0 54 'not null' => TRUE,
pierre@0 55 'default' => '',
pierre@0 56 'description' => 'Ad redirect URL',
pierre@0 57 ),
pierre@0 58 'autoactivate' => array(
pierre@0 59 'type' => 'int',
pierre@0 60 'not null' => TRUE,
pierre@0 61 'unsigned' => TRUE,
pierre@0 62 'default' => 0,
pierre@0 63 'description' => 'Is ad autoactivating?',
pierre@0 64 ),
pierre@0 65 'autoactivated' => array(
pierre@0 66 'type' => 'int',
pierre@0 67 'not null' => TRUE,
pierre@0 68 'unsigned' => TRUE,
pierre@0 69 'default' => 0,
pierre@0 70 'description' => 'Is ad autoactivated?',
pierre@0 71 ),
pierre@0 72 'autoexpire' => array(
pierre@0 73 'type' => 'int',
pierre@0 74 'not null' => TRUE,
pierre@0 75 'unsigned' => TRUE,
pierre@0 76 'default' => 0,
pierre@0 77 'description' => 'Is ad autoexpiring?',
pierre@0 78 ),
pierre@0 79 'autoexpired' => array(
pierre@0 80 'type' => 'int',
pierre@0 81 'not null' => TRUE,
pierre@0 82 'unsigned' => TRUE,
pierre@0 83 'default' => 0,
pierre@0 84 'description' => 'Is ad autoexpired?',
pierre@0 85 ),
pierre@0 86 'activated' => array(
pierre@0 87 'type' => 'int',
pierre@0 88 'not null' => TRUE,
pierre@0 89 'unsigned' => TRUE,
pierre@0 90 'default' => 0,
pierre@0 91 'description' => 'Is ad activated?',
pierre@0 92 ),
pierre@0 93 'maxviews' => array(
pierre@0 94 'type' => 'int',
pierre@0 95 'not null' => TRUE,
pierre@0 96 'unsigned' => TRUE,
pierre@0 97 'default' => 0,
pierre@0 98 'description' => 'Maximum ad impressions',
pierre@0 99 ),
pierre@0 100 'maxclicks' => array(
pierre@0 101 'type' => 'int',
pierre@0 102 'not null' => TRUE,
pierre@0 103 'unsigned' => TRUE,
pierre@0 104 'default' => 0,
pierre@0 105 'description' => 'Maximum ad clicks',
pierre@0 106 ),
pierre@0 107 'expired' => array(
pierre@0 108 'type' => 'int',
pierre@0 109 'not null' => TRUE,
pierre@0 110 'unsigned' => TRUE,
pierre@0 111 'default' => 0,
pierre@0 112 'description' => 'Is ad expired?',
pierre@0 113 ),
pierre@0 114 ),
pierre@0 115 'primary key' => array('aid'),
pierre@0 116 'indexes' => array(
pierre@0 117 'uid' => array('uid'),
pierre@0 118 'autoactivate' => array('autoactivate'),
pierre@0 119 'autoactivate' => array('autoactivate'),
pierre@0 120 ),
pierre@0 121 );
pierre@0 122
pierre@0 123 /**
pierre@0 124 * This table counts each time a given action occurs on an ad. Actions
pierre@0 125 * include when the ad is viewed, clicked, enabled and disabled.
pierre@0 126 * Statistics are collected at an hourly granularity.
pierre@0 127 *
pierre@0 128 * The source column is used for tracking statistics for externally
pierre@0 129 * hosted ads.
pierre@0 130 *
pierre@0 131 * Actions:
pierre@0 132 * 'view', 'click', 'enable', 'disable'
pierre@0 133 */
pierre@0 134 $schema['ad_statistics'] = array(
pierre@0 135 'description' => 'Stores ad statistics.',
pierre@0 136 'fields' => array(
pierre@0 137 'sid' => array(
pierre@0 138 'type' => 'serial',
pierre@0 139 'not null' => TRUE,
pierre@0 140 'unsigned' => TRUE,
pierre@0 141 'description' => 'Statistics entry ID.',
pierre@0 142 ),
pierre@0 143 'aid' => array(
pierre@0 144 'type' => 'int',
pierre@0 145 'not null' => TRUE,
pierre@0 146 'unsigned' => TRUE,
pierre@0 147 'default' => 0,
pierre@0 148 'description' => 'Ad id.',
pierre@0 149 ),
pierre@0 150 'date' => array(
pierre@0 151 'type' => 'int',
pierre@0 152 'not null' => TRUE,
pierre@0 153 'unsigned' => TRUE,
pierre@0 154 'default' => 0,
pierre@0 155 'description' => 'Date when action was made.',
pierre@0 156 ),
pierre@0 157 'action' => array(
pierre@0 158 'type' => 'varchar',
pierre@0 159 'length' => 255,
pierre@0 160 'not null' => TRUE,
pierre@0 161 'default' => '',
pierre@0 162 'description' => 'Actions: "view", "click", "enable", "disable".',
pierre@0 163 ),
pierre@0 164 'adgroup' => array(
pierre@0 165 'type' => 'varchar',
pierre@0 166 'length' => 255,
pierre@0 167 'not null' => FALSE,
pierre@0 168 'default' => '',
pierre@0 169 'description' => 'Ad group.',
pierre@0 170 ),
pierre@0 171 'hostid' => array(
pierre@0 172 'type' => 'varchar',
pierre@0 173 'length' => 32,
pierre@0 174 'not null' => TRUE,
pierre@0 175 'default' => '',
pierre@0 176 'description' => 'Host from which acion was made.',
pierre@0 177 ),
pierre@0 178 'count' => array(
pierre@0 179 'type' => 'int',
pierre@0 180 'not null' => TRUE,
pierre@0 181 'unsigned' => TRUE,
pierre@0 182 'default' => 0,
pierre@0 183 'description' => 'Count of actions triggered.',
pierre@0 184 ),
pierre@0 185 ),
pierre@0 186 'primary key' => array('sid'),
pierre@0 187 'indexes' => array(
pierre@0 188 'aid' => array('aid'),
pierre@0 189 'date' => array('date'),
pierre@0 190 'action' => array('action'),
pierre@0 191 'adgroup' => array('adgroup'),
pierre@0 192 'hostid' => array('hostid'),
pierre@0 193 ),
pierre@0 194 );
pierre@0 195
pierre@0 196 /**
pierre@0 197 * The ad_clicks table tracks when a given advertisement was clicked,
pierre@0 198 * who clicked it (uid if any and IP address), and what page they were
pierre@0 199 * on when they clicked it.
pierre@0 200 */
pierre@0 201 $schema['ad_clicks'] = array(
pierre@0 202 'description' => 'The ad_clicks table tracks when a given advertisement was clicked, who clicked it (uid if any and IP address), and what page they were on when they clicked it.',
pierre@0 203 'fields' => array(
pierre@0 204 'cid' => array(
pierre@0 205 'type' => 'serial',
pierre@0 206 'not null' => TRUE,
pierre@0 207 'unsigned' => TRUE,
pierre@0 208 'description' => 'Statistics entry ID.',
pierre@0 209 ),
pierre@0 210 'aid' => array(
pierre@0 211 'type' => 'int',
pierre@0 212 'not null' => TRUE,
pierre@0 213 'unsigned' => TRUE,
pierre@0 214 'default' => 0,
pierre@0 215 'description' => 'Ad id.',
pierre@0 216 ),
pierre@0 217 'uid' => array(
pierre@0 218 'type' => 'int',
pierre@0 219 'not null' => TRUE,
pierre@0 220 'unsigned' => TRUE,
pierre@0 221 'default' => 0,
pierre@0 222 'description' => '',
pierre@0 223 ),
pierre@0 224 'status' => array(
pierre@0 225 'type' => 'int',
pierre@0 226 'size' => 'tiny',
pierre@0 227 'not null' => TRUE,
pierre@0 228 'unsigned' => TRUE,
pierre@0 229 'default' => 0,
pierre@0 230 'description' => '',
pierre@0 231 ),
pierre@0 232 'hostname' => array(
pierre@0 233 'type' => 'varchar',
pierre@0 234 'length' => 128,
pierre@0 235 'not null' => TRUE,
pierre@0 236 'default' => '',
pierre@0 237 'description' => 'Host from which acion was made.',
pierre@0 238 ),
pierre@0 239 'user_agent' => array(
pierre@0 240 'type' => 'varchar',
pierre@0 241 'length' => 255,
pierre@0 242 'not null' => TRUE,
pierre@0 243 'default' => '',
pierre@0 244 'description' => 'Clicker\'s browser agent.',
pierre@0 245 ),
pierre@0 246 'adgroup' => array(
pierre@0 247 'type' => 'varchar',
pierre@0 248 'length' => 255,
pierre@0 249 'not null' => TRUE,
pierre@0 250 'default' => '',
pierre@0 251 'description' => 'Ad group.',
pierre@0 252 ),
pierre@0 253 'hostid' => array(
pierre@0 254 'type' => 'varchar',
pierre@0 255 'length' => 32,
pierre@0 256 'not null' => TRUE,
pierre@0 257 'default' => '',
pierre@0 258 'description' => 'Host from which acion was made.',
pierre@0 259 ),
pierre@0 260 'url' => array(
pierre@0 261 'type' => 'varchar',
pierre@0 262 'length' => 255,
pierre@0 263 'not null' => FALSE,
pierre@0 264 'default' => '',
pierre@0 265 'description' => 'Clicked URL.',
pierre@0 266 ),
pierre@0 267 'timestamp' => array(
pierre@0 268 'type' => 'int',
pierre@0 269 'not null' => TRUE,
pierre@0 270 'unsigned' => TRUE,
pierre@0 271 'default' => 0,
pierre@0 272 'description' => 'Date when action was made.',
pierre@0 273 ),
pierre@0 274 ),
pierre@0 275 'primary key' => array('cid'),
pierre@0 276 'indexes' => array(
pierre@0 277 'aid' => array('aid'),
pierre@0 278 'status' => array('status'),
pierre@0 279 'hostname' => array('hostname'),
pierre@0 280 'user_agent' => array('user_agent'),
pierre@0 281 'adgroup' => array('adgroup'),
pierre@0 282 'hostid' => array('hostid'),
pierre@0 283 'url' => array('url'),
pierre@0 284 ),
pierre@0 285 );
pierre@0 286
pierre@0 287 return $schema;
pierre@0 288 }
pierre@0 289
pierre@0 290 /**
pierre@0 291 * Ad module installation.
pierre@0 292 */
pierre@0 293 function ad_install() {
pierre@0 294 // Create tables.
pierre@0 295 drupal_install_schema('ad');
pierre@0 296 }
pierre@0 297
pierre@0 298 /**
pierre@0 299 * Allow complete uninstallation of the ad module.
pierre@0 300 */
pierre@0 301 function ad_uninstall() {
pierre@0 302 // Delete all ad content.
pierre@0 303 $result = db_query("SELECT nid FROM {node} WHERE type = 'ad'");
pierre@0 304 while ($node = db_fetch_object($result)) {
pierre@0 305 node_delete($node->nid);
pierre@0 306 variable_del("ad_autoactivate_warning_$node->nid");
pierre@0 307 }
pierre@0 308
pierre@0 309 // Delete all remaining ad module variables.
pierre@0 310 $variables = array('ad_cron_timestamp', 'ad_link_target', 'ad_cache', 'ad_cache_file', 'adserve', 'ad_group_vid', 'ad_groups', 'ad_validate_url', 'ad_display');
pierre@0 311 foreach ($variables as $variable) {
pierre@0 312 variable_del($variable);
pierre@0 313 }
pierre@0 314 db_query("DELETE FROM {variable} WHERE name LIKE 'ad_block_quantity_%'");
pierre@1 315
pierre@1 316 // Remove tables.
pierre@1 317 drupal_uninstall_schema('ad');
pierre@0 318 }
pierre@0 319
pierre@0 320 /**
pierre@0 321 * Convert some things from absolete dev. schema to new schema API
pierre@0 322 */
pierre@0 323 function ad_update_6001() {
pierre@0 324 $ret = array();
pierre@0 325 // When we touching index columns, we should first remove it from schema
pierre@0 326 db_drop_index($ret, 'ad_clicks', 'status');
pierre@0 327 db_change_field($ret, 'ad_clicks', 'status', 'status',
pierre@0 328 array(
pierre@0 329 'type' => 'int',
pierre@0 330 'size' => 'tiny',
pierre@0 331 'not null' => TRUE,
pierre@0 332 'unsigned' => TRUE,
pierre@0 333 'default' => 0,
pierre@0 334 'description' => '',
pierre@0 335 ),
pierre@0 336 array('indexes' => array(
pierre@0 337 'status' => array('status'),
pierre@0 338 ),
pierre@0 339 )
pierre@0 340 );
pierre@0 341 db_drop_index($ret, 'ad_hosts', 'status');
pierre@0 342 db_change_field($ret, 'ad_hosts', 'status', 'status',
pierre@0 343 array(
pierre@0 344 'type' => 'int',
pierre@0 345 'size' => 'tiny',
pierre@0 346 'not null' => TRUE,
pierre@0 347 'unsigned' => TRUE,
pierre@0 348 'default' => 0,
pierre@0 349 'description' => '',
pierre@0 350 ),
pierre@0 351 array('indexes' => array(
pierre@0 352 'status' => array('status'),
pierre@0 353 ),
pierre@0 354 )
pierre@0 355 );
pierre@0 356
pierre@0 357 db_drop_index($ret, 'ad_statistics', 'hostid');
pierre@0 358 db_change_field($ret, 'ad_statistics', 'hostid', 'hostid',
pierre@0 359 array(
pierre@0 360 'type' => 'varchar',
pierre@0 361 'length' => 32,
pierre@0 362 'not null' => TRUE,
pierre@0 363 'default' => '',
pierre@0 364 'description' => 'Host from which acion was made.',
pierre@0 365 ),
pierre@0 366 array('indexes' => array(
pierre@0 367 'hostid' => array('hostid'),
pierre@0 368 ),
pierre@0 369 )
pierre@0 370 );
pierre@0 371
pierre@0 372 db_drop_index($ret, 'ad_hosts', 'hostid');
pierre@0 373 db_change_field($ret, 'ad_hosts', 'hostid', 'hostid',
pierre@0 374 array(
pierre@0 375 'type' => 'varchar',
pierre@0 376 'length' => 32,
pierre@0 377 'not null' => TRUE,
pierre@0 378 'default' => '',
pierre@0 379 'description' => 'Host from which acion was made.',
pierre@0 380 ),
pierre@0 381 array('indexes' => array(
pierre@0 382 'hostid' => array('hostid'),
pierre@0 383 ),
pierre@0 384 )
pierre@0 385 );
pierre@0 386 return $ret;
pierre@0 387 }
pierre@0 388
pierre@0 389 /**
pierre@0 390 * Rebuild menu for anyone using the ad_embed module.
pierre@0 391 */
pierre@0 392 function ad_update_6002() {
pierre@0 393 menu_rebuild();
pierre@0 394 return array();
pierre@0 395 }
pierre@0 396
pierre@0 397 /**
pierre@0 398 * Flush all caches for new themeable ad display functions.
pierre@0 399 */
pierre@0 400 function ad_update_6003() {
pierre@0 401 drupal_flush_all_caches();
pierre@0 402 return array();
pierre@0 403 }
pierre@1 404
pierre@1 405 /**
pierre@1 406 * Introduce "extra" field for ad statistics and clicks, optionally allowing
pierre@1 407 * add-on modules to provide additional granularity.
pierre@1 408 */
pierre@1 409 function ad_update_6004() {
pierre@1 410 $ret = array();
pierre@1 411 db_add_field($ret, 'ad_statistics', 'extra',
pierre@1 412 array(
pierre@1 413 'type' => 'varchar',
pierre@1 414 'length' => 255,
pierre@1 415 'not null' => TRUE,
pierre@1 416 'default' => '',
pierre@1 417 'description' => 'Alow add-on modules to provide additional statistics granularity.',
pierre@1 418 ),
pierre@1 419 array('indexes' => array(
pierre@1 420 'extra' => array('extra'))
pierre@1 421 ));
pierre@1 422 db_add_field($ret, 'ad_clicks', 'extra',
pierre@1 423 array(
pierre@1 424 'type' => 'varchar',
pierre@1 425 'length' => 255,
pierre@1 426 'not null' => TRUE,
pierre@1 427 'default' => '',
pierre@1 428 'description' => 'Alow add-on modules to provide additional statistics granularity.',
pierre@1 429 ),
pierre@1 430 array('indexes' => array(
pierre@1 431 'extra' => array('extra'))
pierre@1 432 ));
pierre@1 433 return $ret;
pierre@1 434 }
pierre@1 435
pierre@1 436 /**
pierre@1 437 * Flush all caches for AHAH ad type switcher to work.
pierre@1 438 */
pierre@1 439 function ad_update_6005() {
pierre@1 440 drupal_flush_all_caches();
pierre@1 441 return array();
pierre@1 442 }
pierre@1 443