[phpws-comm-commits] modules/ads/boost boost.php, 1.5, 1.6 update.php, 1.2, 1.3

[Greg M. <bli...@us...>]

Update of /cvsroot/phpwebsite-comm/modules/ads/boost
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7344/boost

Modified Files:
	boost.php update.php 
Log Message:
Preparing for 1.3.0

Index: boost.php
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/ads/boost/boost.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** boost.php	22 Jun 2008 20:04:15 -0000	1.5
--- boost.php	16 Aug 2008 23:07:57 -0000	1.6
***************
*** 24,28 ****
  
  $proper_name  = 'Ads';
! $version      = '1.2.0';
  $register     = FALSE;
  $unregister   = FALSE;
--- 24,28 ----
  
  $proper_name  = 'Ads';
! $version      = '1.3.0';
  $register     = FALSE;
  $unregister   = FALSE;

Index: update.php
===================================================================
RCS file: /cvsroot/phpwebsite-comm/modules/ads/boost/update.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** update.php	22 Jun 2008 20:04:15 -0000	1.2
--- update.php	16 Aug 2008 23:07:57 -0000	1.3
***************
*** 42,45 ****
--- 42,86 ----
              $content[] = '- Added empty messages to DBPager.';
              $content[] = '- Corrected a few phrases that were not being translated.';
+ 
+         case version_compare($currentVersion, '1.3.0', '<'):
+             /* Step 1: Update advertiser ids in campaign table to user ids. */
+             $db = new PHPWS_DB('ads_campaigns');
+             PHPWS_Error::logIfError($db->query('UPDATE ads_campaigns,ads_advertisers
+                                                 SET ads_campaigns.advertiser_id = ads_advertisers.user_id
+                                                 WHERE ( ads_campaigns.advertiser_id = ads_advertisers.id )'));
+ 
+             /* Step 2: Read out current contents of advertisers table. */
+             $db2 = new PHPWS_DB('ads_advertisers');
+             $results = $db2->select();
+             PHPWS_Error::logIfError($results);
+ 
+             /* Step 3: Change advertisers table to new structure. */
+             PHPWS_Error::logIfError($db2->dropTableColumn('id'));
+             PHPWS_Error::logIfError($db2->dropTableColumn('business'));
+             PHPWS_Error::logIfError($db2->createTableIndex('user_id', 'userid_idx', true));
+ 
+             /* Step 4: Update demographics table with advertiser business name. */
+             if (!empty($results))
+             {
+                 PHPWS_Core::initModClass('ads', 'advertiser.php');
+                 Demographics::register('ads');
+ 
+                 foreach ($results as $row)
+                 {
+                     $advertiser = new Ads_Advertiser($row['user_id']);
+                     $advertiser->setBusinessName($row['business']);
+                     PHPWS_Error::logIfError($advertiser->save());
+                 }
+             }
+ 
+             /* Step 5: Update the templates. */
+             $files = array('templates/advertiser/list.tpl',
+                            'templates/advertiser/select.tpl',
+                            'templates/advertiser/add.tpl');
+             ads_update_files($files, $content);
+ 
+             /* Done */
+             $content[] = '- Now use demographics module to store the business name of advertisers.';
+             $content[] = '- Removed call to help module which wasn\'t working anyway.';
      }