Update of /cvsroot/phpwebsite-comm/modules/ads/boost
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv4340/boost
Modified Files:
dependency.xml install.sql
Added Files:
demographics.php
Log Message:
Now use demographics module to store business name for advertisers.
Index: install.sql
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/ads/boost/install.sql,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** install.sql 22 Jun 2008 20:04:15 -0000 1.11
--- install.sql 16 Aug 2008 20:19:12 -0000 1.12
***************
*** 18,28 ****
CREATE TABLE ads_advertisers (
- id INT NOT NULL,
user_id INT DEFAULT '0' NOT NULL,
! business VARCHAR(100) NOT NULL default '',
! created INT NOT NULL,
! PRIMARY KEY (id)
);
CREATE TABLE ads_campaigns (
id INT NOT NULL,
--- 18,27 ----
CREATE TABLE ads_advertisers (
user_id INT DEFAULT '0' NOT NULL,
! created INT NOT NULL
);
+ CREATE UNIQUE INDEX userid_idx on ads_advertisers(user_id);
+
CREATE TABLE ads_campaigns (
id INT NOT NULL,
--- NEW FILE: demographics.php ---
<?php
/**
* Ads for phpWebSite
*
* See docs/CREDITS for copyright information
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* @author Greg Meiste <blindman1344 at users dot sourceforge dot net>
* @version $Id: demographics.php,v 1.1 2008/08/16 20:19:12 blindman1344 Exp $
*/
/* New field for ads module that matches rolodex module. */
$fields['business_name']['limit'] = 255;
?>
Index: dependency.xml
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/ads/boost/dependency.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** dependency.xml 22 Jun 2008 20:04:15 -0000 1.5
--- dependency.xml 16 Aug 2008 20:19:12 -0000 1.6
***************
*** 13,15 ****
--- 13,21 ----
<url>http://phpwebsite.appstate.edu/downloads/modules/users/</url>
</module>
+ <module>
+ <title>demographics</title>
+ <properName>Demographics</properName>
+ <version>1.1.0</version>
+ <url>http://phpwebsite.appstate.edu/downloads/modules/demographics/</url>
+ </module>
</dependency>
|
