Index: /trunk/htdocs/stats.bml
===================================================================
--- /trunk/htdocs/stats.bml (revision 857)
+++ /trunk/htdocs/stats.bml (revision 919)
@@ -48,5 +48,4 @@
  $usedlastday = $stat{'userinfo'}->{'updated_last1'}+0;
  $allow_getljnews = $stat{'userinfo'}->{'allow_getljnews'}+0;
- $allow_getpromos = $stat{'userinfo'}->{'allow_getpromos'}+0;
 
  $ret .= "(=H1 Users H1=)\n";
@@ -89,8 +88,7 @@
  unless ($LJ::DISABLED{'stats-newsadv'}) {
      $ret .= "(=H1 Receiving News/Advertising H1=)\n";
-     $ret .= "(=P This information says how many users of the ones with validated email addresses subscribe to the LiveJournal news that we send out, and how many people say they wouldn't mind getting advertisement/promotions sent to them by email. <UL>";
-     $ret .= "<LI><B>Users getting LiveJournal news: </B> $allow_getljnews\n";
-     $ret .= "<LI><B>Users getting promotions by mail: </B> $allow_getpromos\n";
-     $ret .= "</UL> P=)\n";
+     $ret .= "(=P This information says how many users of the ones with validated email addresses subscribe to the LiveJournal news that we send out. <ul>";
+     $ret .= "<li><b>Users getting LiveJournal news: </b> $allow_getljnews</li>\n";
+     $ret .= "</ul> P=)\n";
  }
 
Index: /trunk/bin/upgrading/update-db-general.pl
===================================================================
--- /trunk/bin/upgrading/update-db-general.pl (revision 914)
+++ /trunk/bin/upgrading/update-db-general.pl (revision 919)
@@ -819,5 +819,4 @@
   allow_contactshow char(1) NOT NULL default 'Y',
   allow_getljnews char(1) NOT NULL default 'N',
-  allow_getpromos char(1) NOT NULL default 'N',
   opt_showtalklinks char(1) NOT NULL default 'Y',
   opt_whocanreply enum('all','reg','friends') NOT NULL default 'all',
Index: /trunk/bin/maint/stats.pl
===================================================================
--- /trunk/bin/maint/stats.pl (revision 857)
+++ /trunk/bin/maint/stats.pl (revision 919)
@@ -111,5 +111,5 @@
             my $last = $skip+$pagesize;
             print "  getting records $first-$last...\n";
-            $sth = $dbr->prepare("SELECT DATE_FORMAT(uu.timecreate, '%Y-%m-%d') AS 'datereg', u.user, u.caps, FLOOR((TO_DAYS(NOW())-TO_DAYS(u.bdate))/365.25) AS 'age', UNIX_TIMESTAMP(uu.timeupdate) AS 'timeupdate', u.status, u.allow_getljnews, u.allow_getpromos FROM user u, userusage uu WHERE u.userid=uu.userid LIMIT $skip,$pagesize");
+            $sth = $dbr->prepare("SELECT DATE_FORMAT(uu.timecreate, '%Y-%m-%d') AS 'datereg', u.user, u.caps, FLOOR((TO_DAYS(NOW())-TO_DAYS(u.bdate))/365.25) AS 'age', UNIX_TIMESTAMP(uu.timeupdate) AS 'timeupdate', u.status, u.allow_getljnews FROM user u, userusage uu WHERE u.userid=uu.userid LIMIT $skip,$pagesize");
             $sth->execute;
             while (my $rec = $sth->fetchrow_hashref)
@@ -143,5 +143,5 @@
                 if ($rec->{'status'} eq "A")
                 {
-                    for (qw(allow_getljnews allow_getpromos))
+                    for (qw(allow_getljnews))
                     {
                         $userinfo{$_}++ if ($rec->{$_} eq "Y");