[ Index ]
 

Code source de PHP NUKE 7.9

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/modules/Advertising/admin/ -> index.php (source)

   1  <?php
   2  
   3  /************************************************************************/

   4  /* PHP-NUKE: Web Portal System                                          */

   5  /* ===========================                                          */

   6  /*                                                                      */

   7  /* Copyright (c) 2005 by Francisco Burzi                                */

   8  /* http://phpnuke.org                                                   */

   9  /*                                                                      */

  10  /* This program is free software. You can redistribute it and/or modify */

  11  /* it under the terms of the GNU General Public License as published by */

  12  /* the Free Software Foundation; either version 2 of the License.       */

  13  /************************************************************************/

  14  
  15  if (!defined('ADMIN_FILE')) {
  16      die ("Access Denied");
  17  }
  18  
  19  global $prefix, $db, $admin_file;
  20  $aid = substr($aid, 0,25);
  21  $row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
  22  if ($row['radminsuper'] == 1) {
  23  
  24      /*********************************************************/

  25      /* Banners Administration Functions                      */

  26      /*********************************************************/

  27  
  28      $c_num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner_clients"));
  29      if ($c_num == 0) {
  30          $cli = "<i>"._ADDNEWBANNER."</i>";
  31      } else {
  32          $cli = "<a href=\"".$admin_file.".php?op=add_banner\">"._ADDNEWBANNER."</a>";
  33      }
  34      $act = $db->sql_fetchrow($db->sql_query("SELECT active FROM ".$prefix."_modules WHERE title='Advertising'"));
  35      if ($act['active'] == 0) {
  36          $act = "<br><center>"._ADSMODULEINACTIVE."</center>";    
  37      } else {
  38          $act = "";    
  39      }
  40      $ad_admin_menu_main = "<center><font class=\"title\"><b>" . _BANNERSADMIN . "</b></font><br><br>[ <a href=\"".$admin_file.".php?op=ad_positions\">"._ADPOSITIONS."</a> - $cli - <a href=\"".$admin_file.".php?op=add_client\">"._ADDCLIENT."</a> - <a href=\"".$admin_file.".php?op=ad_terms\">"._TERMS."</a> - <a href=\"".$admin_file.".php?op=ad_plans\">"._PLANSPRICES."</a> ]</center>$act";
  41      $ad_admin_menu = "<center><font class=\"title\"><b>" . _BANNERSADMIN . "</b></font><br><br>[ <a href=\"".$admin_file.".php?op=BannersAdmin\">"._BANNERS."</a> - <a href=\"".$admin_file.".php?op=ad_positions\">"._ADPOSITIONS."</a> - $cli - <a href=\"".$admin_file.".php?op=add_client\">"._ADDCLIENT."</a> - <a href=\"".$admin_file.".php?op=ad_terms\">"._TERMS."</a> - <a href=\"".$admin_file.".php?op=ad_plans\">"._PLANSPRICES."</a> ]</center>$act";
  42  
  43  	function BannersAdmin() {
  44          global $prefix, $db, $bgcolor2, $banners, $admin_file, $ad_admin_menu_main, $bgcolor1;
  45          include  ("header.php");
  46          GraphicAdmin();
  47          OpenTable();
  48          echo "$ad_admin_menu_main";
  49          CloseTable();
  50          echo "<br>";
  51          /* Banners List */

  52          echo "<a name=\"top\">";
  53          OpenTable();
  54          echo "<center><font class=\"option\"><b>" . _ACTIVEBANNERS . "</b></font></center><br>"
  55          ."<table width=100% border=1><tr>"
  56          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _BANNERNAME . "</b></td>"
  57          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLIENT . "</b></td>"
  58          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _IMPRESSIONS . "</b></td>"
  59          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _IMPLEFT . "</b></td>"
  60          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLICKS . "</b></td>"
  61          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLICKSPERCENT . "</b></td>"
  62          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _POSITION . "</b></td>"
  63          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLASS . "</b></td>"
  64          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _FUNCTIONS . "</b></td><tr>";
  65          $result = $db->sql_query("SELECT bid, cid, name, imptotal, impmade, clicks, imageurl, date, position, active, ad_class from " . $prefix . "_banner WHERE active='1' order by position,bid");
  66          while ($row = $db->sql_fetchrow($result)) {
  67              $bid = intval($row['bid']);
  68              $cid = intval($row['cid']);
  69              $imptotal = intval($row['imptotal']);
  70              $impmade = intval($row['impmade']);
  71              $clicks = intval($row['clicks']);
  72              $imageurl = $row['imageurl'];
  73              $date = $row['date'];
  74              $type = $row['position'];
  75              $active = intval($row['active']);
  76              $row2 = $db->sql_fetchrow($db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients where cid='$cid'"));
  77              $cid = intval($row2['cid']);
  78              $name = trim($row2['name']);
  79              $ad_class = $row['ad_class'];
  80              if ($row['name'] == "") {
  81                  $row['name'] = _NONE;
  82              } else {
  83                  if ($row['ad_class'] == "image") {
  84                      $row['name'] = "<a href=\"$imageurl\" target=\"_blank\">".$row['name']."</a>";
  85                  }
  86              }
  87              if ($ad_class == "") {
  88                  $ad_class = "image";    
  89              }
  90              $ad_class = ucFirst($ad_class);
  91              if($impmade==0) {
  92                  $percent = 0;
  93              } else {
  94                  $percent = substr(100 * $clicks / $impmade, 0, 5);
  95              }
  96              if($imptotal==0) {
  97                  $left = _UNLIMITED;
  98              } else {
  99                  $left = $imptotal-$impmade;
 100              }
 101              $percent = "$percent%";
 102              if ($ad_class == "Code" || $ad_class == "Flash") {
 103                  $clicks = "N/A";
 104                  $percent = "N/A";
 105              }
 106              $row2 = $db->sql_fetchrow($db->sql_query("SELECT apid, position_name FROM ".$prefix."_banner_positions where position_number='$type'"));
 107              $type = "<a href=\"".$admin_file.".php?op=position_edit&apid=".$row2['apid'] . "\">".$row2['position_name']."</a>";
 108              if ($active == 1) {
 109                  $t_active = "<img src=\"images/active.gif\" alt=\""._ACTIVE."\" title=\""._ACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
 110                  $c_active = "<img src=\"images/inactive.gif\" alt=\""._DEACTIVATE."\" title=\""._DEACTIVATE."\" border=\"0\" width=\"16\" height=\"16\">";
 111              } else {
 112                  $t_active = "<img src=\"images/inactive.gif\" alt=\""._INACTIVE."\" title=\""._INACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
 113                  $c_active = "<img src=\"images/active.gif\" alt=\""._ACTIVATE."\" title=\""._ACTIVATE."\" border=\"0\" width=\"16\" height=\"16\">";
 114              }
 115          echo "<td bgcolor=\"$bgcolor1\" align=center>".$row['name']."</td>"
 116              ."<td bgcolor=\"$bgcolor1\" align=center><a href=\"".$admin_file.".php?op=BannerClientEdit&cid=".$row['cid']."\">$name</a></td>"    
 117              ."<td bgcolor=\"$bgcolor1\" align=center>$impmade</td>"
 118              ."<td bgcolor=\"$bgcolor1\" align=center>$left</td>"
 119              ."<td bgcolor=\"$bgcolor1\" align=center>$clicks</td>"
 120              ."<td bgcolor=\"$bgcolor1\" align=center>$percent</td>"
 121              ."<td bgcolor=\"$bgcolor1\" align=center>$type</td>"
 122              ."<td bgcolor=\"$bgcolor1\" align=center>$ad_class</td>"
 123              ."<td bgcolor=\"$bgcolor1\" align=center>&nbsp;<a href=\"".$admin_file.".php?op=BannerEdit&amp;bid=$bid\"><img src=\"images/edit.gif\" alt=\""._EDIT."\" title=\""._EDIT."\" border=\"0\" width=\"17\" height=\"17\"></a>  <a href=\"".$admin_file.".php?op=BannerStatus&amp;bid=$bid&status=$active\">$c_active</a>  <a href=\"".$admin_file.".php?op=BannerDelete&amp;bid=$bid&amp;ok=0\"><img src=\"images/delete.gif\" alt=\""._DELETE."\" title=\""._DELETE."\" border=\"0\" width=\"17\" height=\"17\"></a>&nbsp;</td><tr>";
 124          }
 125          echo "</td></tr></table><br>"
 126          ."<center><font class=\"option\"><b>" . _INACTIVEBANNERS . "</b></font></center><br>"
 127          ."<table width=100% border=1><tr>"
 128          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _BANNERNAME . "</b></td>"
 129          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLIENT . "</b></td>"
 130          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _IMPRESSIONS . "</b></td>"
 131          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _IMPLEFT . "</b></td>"
 132          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLICKS . "</b></td>"
 133          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLICKSPERCENT . "</b></td>"
 134          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _POSITION . "</b></td>"
 135          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLASS . "</b></td>"
 136          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _FUNCTIONS . "</b></td><tr>";
 137          $result = $db->sql_query("SELECT bid, cid, name, imptotal, impmade, clicks, imageurl, date, position, active, ad_class from " . $prefix . "_banner WHERE active='0' order by position,bid");
 138          while ($row = $db->sql_fetchrow($result)) {
 139              $bid = intval($row['bid']);
 140              $cid = intval($row['cid']);
 141              $imptotal = intval($row['imptotal']);
 142              $impmade = intval($row['impmade']);
 143              $clicks = intval($row['clicks']);
 144              $imageurl = $row['imageurl'];
 145              $date = $row['date'];
 146              $type = $row['position'];
 147              $active = intval($row['active']);
 148              $row2 = $db->sql_fetchrow($db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients where cid='$cid'"));
 149              $cid = intval($row2['cid']);
 150              $name = trim($row2['name']);
 151              $ad_class = $row['ad_class'];
 152              if ($row['name'] == "") {
 153                  $row['name'] = _NONE;
 154              } else {
 155                  if ($row['ad_class'] == "image") {
 156                      $row['name'] = "<a href=\"$imageurl\" target=\"_blank\">".$row['name']."</a>";
 157                  }
 158              }
 159              if ($ad_class == "") {
 160                  $ad_class = "image";    
 161              }
 162              $ad_class = ucFirst($ad_class);
 163              if($impmade==0) {
 164                  $percent = 0;
 165              } else {
 166                  $percent = substr(100 * $clicks / $impmade, 0, 5);
 167              }
 168              if($imptotal==0) {
 169                  $left = _UNLIMITED;
 170              } else {
 171                  $left = $imptotal-$impmade;
 172              }
 173              $percent = "$percent%";
 174              if ($ad_class == "Code" || $ad_class == "Flash") {
 175                  $clicks = "N/A";
 176                  $percent = "N/A";
 177              }
 178              $row2 = $db->sql_fetchrow($db->sql_query("SELECT apid, position_name FROM ".$prefix."_banner_positions where position_number='$type'"));
 179              $type = "<a href=\"".$admin_file.".php?op=position_edit&apid=".$row2['apid'] . "\">".$row2['position_name']."</a>";
 180              if ($active == 1) {
 181                  $t_active = "<img src=\"images/active.gif\" alt=\""._ACTIVE."\" title=\""._ACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
 182                  $c_active = "<img src=\"images/inactive.gif\" alt=\""._DEACTIVATE."\" title=\""._DEACTIVATE."\" border=\"0\" width=\"16\" height=\"16\">";
 183              } else {
 184                  $t_active = "<img src=\"images/inactive.gif\" alt=\""._INACTIVE."\" title=\""._INACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
 185                  $c_active = "<img src=\"images/active.gif\" alt=\""._ACTIVATE."\" title=\""._ACTIVATE."\" border=\"0\" width=\"16\" height=\"16\">";
 186              }
 187          echo "<td bgcolor=\"$bgcolor1\" align=center>".$row['name']."</td>"
 188              ."<td bgcolor=\"$bgcolor1\" align=center><a href=\"".$admin_file.".php?op=BannerClientEdit&cid=".$row['cid']."\">$name</a></td>"    
 189              ."<td bgcolor=\"$bgcolor1\" align=center>$impmade</td>"
 190              ."<td bgcolor=\"$bgcolor1\" align=center>$left</td>"
 191              ."<td bgcolor=\"$bgcolor1\" align=center>$clicks</td>"
 192              ."<td bgcolor=\"$bgcolor1\" align=center>$percent</td>"
 193              ."<td bgcolor=\"$bgcolor1\" align=center>$type</td>"
 194              ."<td bgcolor=\"$bgcolor1\" align=center>$ad_class</td>"
 195              ."<td bgcolor=\"$bgcolor1\" align=center>&nbsp;<a href=\"".$admin_file.".php?op=BannerEdit&amp;bid=$bid\"><img src=\"images/edit.gif\" alt=\""._EDIT."\" title=\""._EDIT."\" border=\"0\" width=\"17\" height=\"17\"></a>  <a href=\"".$admin_file.".php?op=BannerStatus&amp;bid=$bid&status=$active\">$c_active</a>  <a href=\"".$admin_file.".php?op=BannerDelete&amp;bid=$bid&amp;ok=0\"><img src=\"images/delete.gif\" alt=\""._DELETE."\" title=\""._DELETE."\" border=\"0\" width=\"17\" height=\"17\"></a>&nbsp;</td><tr>";
 196          }
 197          echo "</td></tr></table>";
 198          CloseTable();
 199          echo "<br>";
 200          /* Clients List */

 201          OpenTable();
 202          echo "<center><font class=\"option\"><b>" . _ADVERTISINGCLIENTS . "</b></font></center><br>"
 203          ."<table width=\"100%\" border=\"1\"><tr>"
 204          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLIENTNAME . "</b></td>"
 205          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _ACTIVEBANNERS2 . "</b></td>"
 206          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _INACTIVEBANNERS . "</b></td>"
 207          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CONTACTNAME . "</b></td>"
 208          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CONTACTEMAIL . "</b></td>"
 209          ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _FUNCTIONS . "</b></td><tr>";
 210          $result3 = $db->sql_query("SELECT cid, name, contact, email from " . $prefix . "_banner_clients order by cid");
 211          while ($row3 = $db->sql_fetchrow($result3)) {
 212              $cid = intval($row3['cid']);
 213              $name = $row3['name'];
 214              $contact = $row3['contact'];
 215              $email = $row3['email'];
 216              $result4 = $db->sql_query("SELECT cid from " . $prefix . "_banner WHERE cid='$cid' AND active='1'");
 217              $numrows = $db->sql_numrows($result4);
 218              $row4 = $db->sql_fetchrow($result4);
 219              $rcid = intval($row4['cid']);
 220              $numrows2 = $db->sql_numrows($db->sql_query("SELECT cid from " . $prefix . "_banner WHERE cid='$cid' AND active='0'"));
 221              echo "<td bgcolor=\"$bgcolor1\" align=\"center\">$name</td>"
 222              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$numrows</td>"
 223              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$numrows2</td>"
 224              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$contact</td>"
 225              ."<td bgcolor=\"$bgcolor1\" align=\"center\"><a href=\"mailto:$email\">$email</a></td>"
 226              ."<td bgcolor=\"$bgcolor1\" align=\"center\" nowrap>&nbsp;<a href=\"".$admin_file.".php?op=BannerClientEdit&amp;cid=$cid\"><img src=\"images/edit.gif\" alt=\""._EDIT."\" title=\""._EDIT."\" border=\"0\" width=\"17\" height=\"17\"></a>  <a href=\"".$admin_file.".php?op=BannerClientDelete&amp;cid=$cid\"><img src=\"images/delete.gif\" alt=\""._DELETE."\" title=\""._DELETE."\" border=\"0\" width=\"17\" height=\"17\"></a>&nbsp;</td><tr>";
 227          }
 228          echo "</td></tr></table>";
 229          CloseTable();
 230          include ("footer.php");
 231      }
 232  
 233  	function add_banner() {
 234          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
 235          define('NO_EDITOR', 1);
 236          include  ("header.php");
 237          GraphicAdmin();
 238          OpenTable();
 239          echo "$ad_admin_menu";
 240          CloseTable();
 241          echo "<br>";
 242          OpenTable();
 243          $result = $db->sql_query("select * from ".$prefix."_banner_clients");
 244          $numrows = $db->sql_numrows($result);
 245          if($numrows > 0) {
 246              echo "<center><font class=\"title\"><b>" . _ADDNEWBANNER . "</b></font></center><br><br>"
 247              ."<table border=\"0\"><tr><td>"
 248              ."<form action=\"".$admin_file.".php?op=BannersAdd\" method=\"post\">"
 249              ."" . _CLIENTNAME . ":</td>"
 250              ."<td><select name=\"cid\">";
 251              $result = $db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients ORDER BY name");
 252              while ($row = $db->sql_fetchrow($result)) {
 253                  $cid = intval($row['cid']);
 254                  $name = $row['name'];
 255                  echo "<option value=\"$cid\">$name</option>";
 256              }
 257              echo "</select></td></tr>"
 258              ."<tr><td nowrap>" . _BANNERNAME . ":</td><td><input type=\"text\" name=\"adname\" size=\"12\" maxlength=\"50\"></td></tr>"
 259              ."<tr><td nowrap>" . _PURCHASEDIMPRESSIONS . ":</td><td><input type=\"text\" name=\"imptotal\" size=\"12\" maxlength=\"11\"> 0 = " . _UNLIMITED . "</td></tr>"
 260              ."<tr><td>" . _ADCLASS . ":</td><td><select name=\"ad_class\">"
 261              ."<option name=\"type\" value=\"image\">" . _ADIMAGE . "</option>"
 262              ."<option name=\"type\" value=\"code\">" . _ADCODE . "</option>"
 263              ."<option name=\"type\" value=\"flash\">" . _ADFLASH . "</option>"
 264              ."</select></td></tr>"
 265              ."<tr><td>&nbsp;</td><td><i>"._CLASSNOTE."</i></td></tr>"
 266              ."<tr><td>" . _IMAGESWFURL . ":</td><td><input type=\"text\" name=\"imageurl\" size=\"50\" maxlength=\"100\" value=\"http://\"></td></tr>"
 267              ."<tr><td>" . _IMAGESIZE . ":</td><td>"._WIDTH.": <input type=\"text\" name=\"ad_width\" size=\"4\" maxlength=\"4\"> &nbsp; "._HEIGHT.": <input type=\"text\" name=\"ad_height\" size=\"4\" maxlength=\"4\"> &nbsp; "._INPIXELS."</td></tr>"
 268              ."<tr><td>" . _CLICKURL . "</td><td><input type=\"text\" name=\"clickurl\" size=\"50\" maxlength=\"200\" value=\"http://\"></td></tr>"
 269              ."<tr><td>" . _ALTTEXT . ":</td><td><input type=\"text\" name=\"alttext\" size=\"50\" maxlength=\"255\"></td></tr>"
 270              ."<tr><td>" . _ADCODE . ":</td><td><textarea name=\"ad_code\" rows=\"15\" cols=\"70\"></textarea></td></tr>"
 271              ."<tr><td>" . _TYPE . ":</td><td><select name=\"position\">";
 272              $result = $db->sql_query("SELECT position_number, position_name FROM ".$prefix."_banner_positions ORDER BY position_number");
 273              while ($row = $db->sql_fetchrow($result)) {
 274                  echo "<option name=\"position\" value=\"".$row['position_number']."\">".$row['position_number']." - ".$row['position_name']."</option>";
 275              }
 276              echo "</select></td></tr><tr><td>&nbsp;</td><td>"._POSITIONNOTE."</td></tr>"
 277                  ."<tr><td>" . _ACTIVATE . ":</td><td><input type=\"radio\" name=\"active\" value=\"1\" checked>" . _YES . "&nbsp;&nbsp;<input type=\"radio\" name=\"active\" value=\"0\">" . _NO . "</td></tr>"
 278                  ."<tr><td>&nbsp;</td><td><input type=\"hidden\" name=\"op\" value=\"BannersAdd\">"
 279                  ."<input type=\"submit\" value=\"" . _ADDBANNER . "\">"
 280                  ."</form></td></tr></table>";
 281          } else {
 282              echo "<center><font class=\"title\"><b>" . _ADDNEWBANNER . "</b></font></center><br><br>"
 283                  ."<center>"._ADSNOCLIENT."<br><br>"._GOBACK."</center>";
 284          }
 285          CloseTable();
 286          include ("footer.php");
 287      }
 288      
 289  	function add_client() {
 290          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
 291          include  ("header.php");
 292          GraphicAdmin();
 293          OpenTable();
 294          echo "$ad_admin_menu";
 295          CloseTable();
 296          echo "<br>";
 297          OpenTable();
 298          $cl_pass = makePass();
 299          echo"<center><font class=\"title\"><b>" . _ADDCLIENT . "</b></font></center><br><br>
 300              <table border=\"0\"><tr><td>
 301              <form action=\"".$admin_file.".php?op=BannerAddClient\" method=\"post\">
 302              " . _CLIENTNAME . ":</td><td><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"60\"></td></tr>
 303              <tr><td>" . _CONTACTNAME . ":</td><td><input type=\"text\" name=\"contact\" size=\"30\" maxlength=\"60\"></td></tr>
 304              <tr><td>" . _CONTACTEMAIL . ":</td><td><input type=\"text\" name=\"email\" size=\"30\" maxlength=\"60\"></td></tr>
 305              <tr><td>" . _CLIENTLOGIN . ":</td><td><input type=\"text\" name=\"login\" size=\"12\" maxlength=\"10\"></td></tr>
 306              <tr><td>" . _CLIENTPASSWD . ":</td><td><input type=\"text\" name=\"passwd\" size=\"12\" maxlength=\"10\" value=\"$cl_pass\"></td></tr>
 307              <tr><td>" . _EXTRAINFO . ":</td><td><textarea name=\"extrainfo\" cols=\"70\" rows=\"15\"></textarea></td></tr>
 308              <tr><td>&nbsp;</td><td><input type=\"hidden\" name=\"op\" value=\"BannerAddClient\">
 309              <input type=\"submit\" value=\"" . _ADDCLIENT2 . "\">
 310              </form></td></tr></table>";
 311          CloseTable();
 312          include  ("footer.php");
 313      }
 314  
 315  	function BannerStatus($bid, $status) {
 316          global $prefix, $db, $admin_file;
 317          if ($status == 1) {
 318              $active = 0;
 319          } else {
 320              $active = 1;
 321          }
 322          $bid = intval($bid);
 323          $db->sql_query("update " . $prefix . "_banner set active='$active' WHERE bid='$bid'");
 324          Header("Location: ".$admin_file.".php?op=BannersAdmin");
 325      }
 326  
 327  	function BannersAdd($name, $cid, $adname, $imptotal, $imageurl, $clickurl, $alttext, $position, $active, $ad_class, $ad_code, $ad_width, $ad_height) {
 328          global $prefix, $db, $admin_file, $ad_admin_menu;
 329          $alttext = filter($alttext, "nohtml", 1);
 330          $cid = intval($cid);
 331          $imptotal = intval($imptotal);
 332          $active = intval($active);
 333          if (($ad_class == "image" OR $ad_class == "flash") AND ($ad_width == "" OR $ad_height == "")) { $a = 1; }
 334          if (($ad_class == "image") AND ($imageurl == "http://" OR $imageurl == "")) { $a = 1; }
 335          if (($ad_class == "image" OR $ad_class == "flash") AND ((!is_numeric($ad_width) || !is_numeric($ad_height)))) { $a = 1; }
 336          if (($ad_class == "code") AND ($ad_code == "")) { $a = 1; }
 337          if ($a == 1) {
 338              include  ("header.php");
 339              GraphicAdmin();
 340              OpenTable();
 341              echo "$ad_admin_menu";
 342              CloseTable();
 343              echo "<br>";
 344              OpenTable();
 345              echo "<center>"._ADINFOINCOMPLETE."<br><br>"._GOBACK."</center>";
 346              CloseTable();
 347              include ("footer.php");
 348              die();
 349          }
 350          $adname = filter($adname, "nohtml", 1);
 351          $db->sql_query("insert into " . $prefix . "_banner values (NULL, '$cid', '$adname', '$imptotal', '1', '0', '$imageurl', '$clickurl', '$alttext', now(), '00-00-0000 00:00:00', '$position', '$active', '$ad_class', '$ad_code', '$ad_width', '$ad_height')");
 352          Header("Location: ".$admin_file.".php?op=BannersAdmin");
 353      }
 354  
 355  	function BannerAddClient($name, $contact, $email, $login, $passwd, $extrainfo) {
 356          global $prefix, $db, $admin_file;
 357          $name = filter($name, "nohtml", 1);
 358          $contact = filter($contact, "nohtml", 1);
 359          $email = filter($email, "nohtml", 1);
 360          $login = filter($login, "nohtml", 1);
 361          $passwd = filter($passwd, "nohtml", 1);
 362          $extrainfo = filter($extrainfo, "nohtml", 1);
 363          $db->sql_query("insert into " . $prefix . "_banner_clients values (NULL, '$name', '$contact', '$email', '$login', '$passwd', '$extrainfo')");
 364          Header("Location: ".$admin_file.".php?op=BannersAdmin");
 365      }
 366  
 367  	function BannerDelete($bid, $ok=0) {
 368          global $prefix, $db, $admin_file, $bgcolor1, $bgcolor2, $ad_admin_menu;
 369          $bid = intval($bid);
 370          if ($ok == 1) {
 371              $db->sql_query("delete from " . $prefix . "_banner where bid='$bid'");
 372              Header("Location: ".$admin_file.".php?op=BannersAdmin");
 373          } else {
 374              include ("header.php");
 375              GraphicAdmin();
 376              OpenTable();
 377              echo "$ad_admin_menu";
 378              CloseTable();
 379              echo "<br>";
 380              $row = $db->sql_fetchrow($db->sql_query("SELECT cid, name, imptotal, impmade, clicks, imageurl, clickurl, ad_class, ad_code, ad_width, ad_height from " . $prefix . "_banner where bid='$bid'"));
 381              $row['name'] = filter($row['name'], "nohtml");
 382              $cid = intval($row['cid']);
 383              $imptotal = intval($row['imptotal']);
 384              $impmade = intval($row['impmade']);
 385              $clicks = intval($row['clicks']);
 386              $imageurl = $row['imageurl'];
 387              $clickurl = $row['clickurl'];
 388              $ad_class = $row['ad_class'];
 389              $ad_code = $row['ad_code'];
 390              $ad_width = $row['ad_width'];
 391              $ad_height = $row['ad_height'];
 392              if ($row['name'] == "") {
 393                  $row['name'] = _NONE;
 394              }
 395              OpenTable();
 396              echo "<center><font class=\"title\"><b>" . _DELETEBANNER . "</b></font><br><br>";
 397              if ($ad_class == "code") {
 398                  $ad_code = filter($ad_code);
 399                  //$ad_code = stripslashes(FixQuotes($ad_code));

 400                  echo "<table border=\"0\" align=\"center\"><tr><td>$ad_code</td></tr></table><br><br>";
 401              } elseif ($ad_class == "flash") {
 402                  echo "<center>
 403                      <OBJECT classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"
 404                      codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0\"
 405                      WIDTH=\"$ad_width\" HEIGHT=\"$ad_height\" id=\"$bid\">
 406                      <PARAM NAME=movie VALUE=\"$imageurl\">
 407                      <PARAM NAME=quality VALUE=high>
 408                      <EMBED src=\"$imageurl\" quality=high WIDTH=\"$ad_width\" HEIGHT=\"$ad_height\"
 409                      NAME=\"$bid\" ALIGN=\"\" TYPE=\"application/x-shockwave-flash\"
 410                      PLUGINSPAGE=\"http://www.macromedia.com/go/getflashplayer\">
 411                      </EMBED>
 412                      </OBJECT>
 413                      </center><br><br>";
 414              } else {
 415                  echo "<center><img src=\"$imageurl\" border=\"1\" alt=\"$alttext\" title=\"$alttext\" width=\"$ad_width\" height=\"$ad_height\"></center><br><br>";
 416              }
 417              echo "<table width=\"100%\" border=\"1\"><tr>"
 418                  ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _BANNERNAME . "<b></td>"
 419                  ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _IMPRESSIONS . "<b></td>"
 420                  ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _IMPLEFT . "<b></td>"
 421                  ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLICKS . "<b></td>"
 422                  ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLICKSPERCENT . "<b></td>"
 423                  ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _CLIENTNAME . "<b></td><tr>";
 424              $row2 = $db->sql_fetchrow($db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients where cid='$cid'"));
 425              $cid = intval($row2['cid']);
 426              $name = filter($row2['name'], "nohtml");
 427              $percent = substr(100 * $clicks / $impmade, 0, 5);
 428              if($imptotal==0) {
 429                  $left = _UNLIMITED;
 430              } else {
 431                  $left = $imptotal-$impmade;
 432              }
 433              echo "<td bgcolor=\"$bgcolor1\" align=\"center\">".$row['name']."</td>"
 434              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$impmade</td>"
 435              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$left</td>"
 436              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$clicks</td>"
 437              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$percent%</td>"
 438              ."<td bgcolor=\"$bgcolor1\" align=\"center\">$name</td><tr>";
 439          }
 440          echo "</td></tr></table><br>"
 441              ."" . _SURETODELBANNER . "<br><br>"
 442              ."[ <a href=\"".$admin_file.".php?op=BannersAdmin\">" . _NO . "</a> | <a href=\"".$admin_file.".php?op=BannerDelete&amp;bid=$bid&amp;ok=1\">" . _YES . "</a> ]</center><br>";
 443          CloseTable();
 444          include ("footer.php");
 445      }
 446  
 447  	function BannerEdit($bid) {
 448          global $prefix, $db, $admin_file, $ad_admin_menu;
 449          define('NO_EDITOR', true);
 450          include ("header.php");
 451          GraphicAdmin();
 452          OpenTable();
 453          echo "$ad_admin_menu";
 454          CloseTable();
 455          echo "<br>";
 456          $bid = intval($bid);
 457          $row = $db->sql_fetchrow($db->sql_query("SELECT cid, name, imptotal, impmade, clicks, imageurl, clickurl, alttext, date, position, active, ad_class, ad_code, ad_width, ad_height from " . $prefix . "_banner where bid='$bid'"));
 458          $cid = intval($row['cid']);
 459          $imptotal = intval($row['imptotal']);
 460          $impmade = intval($row['impmade']);
 461          $clicks = intval($row['clicks']);
 462          $imageurl = $row['imageurl'];
 463          $clickurl = $row['clickurl'];
 464          $alttext = filter($row['alttext'], "nohtml");
 465          $date = $row['date'];
 466          $date = explode(" ", $date);
 467          $date = "$date[0] @ $date[1]";
 468          $position = $row['position'];
 469          $active = intval($row['active']);
 470          $ad_class = $row['ad_class'];
 471          $ad_code = $row['ad_code'];
 472          $ad_width = $row['ad_width'];
 473          $ad_height = $row['ad_height'];
 474          OpenTable();
 475          echo"<center><font class=\"title\"><b>" . _EDITBANNER . "</b></font></center><br><br>";
 476          if ($ad_class == "code") {
 477              $ad_code = stripslashes(FixQuotes($ad_code));
 478              echo "<table border=\"0\" align=\"center\"><tr><td>$ad_code</td></tr></table><br><br>";
 479          } elseif ($ad_class == "flash") {
 480              echo "<center>
 481                  <OBJECT classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"
 482                  codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0\"
 483                  WIDTH=\"$ad_width\" HEIGHT=\"$ad_height\" id=\"$bid\">
 484                  <PARAM NAME=movie VALUE=\"$imageurl\">
 485                  <PARAM NAME=quality VALUE=high>
 486                  <EMBED src=\"$imageurl\" quality=high WIDTH=\"$ad_width\" HEIGHT=\"$ad_height\"
 487                  NAME=\"$did\" ALIGN=\"\" TYPE=\"application/x-shockwave-flash\"
 488                  PLUGINSPAGE=\"http://www.macromedia.com/go/getflashplayer\">
 489                  </EMBED>
 490                  </OBJECT>
 491                  </center><br><br>";
 492          } else {
 493              echo "<center><img src=\"$imageurl\" border=\"1\" alt=\"$alttext\" title=\"$alttext\" width=\"$ad_width\" height=\"$ad_height\"></center><br><br>";
 494          }
 495  
 496          echo "<table border=\"0\" cellpadding=\"3\"><tr><td>"
 497              ."<form action=\"".$admin_file.".php?op=BannerChange\" method=\"post\">"
 498              ."" . _CLIENTNAME . ":</td><td>"
 499              ."<select name=\"cid\">";
 500          $row2 = $db->sql_fetchrow($db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients where cid='$cid'"));
 501          $cid = intval($row2['cid']);
 502          $name = filter($row2['name'], "nohtml");
 503          echo "<option value=\"$cid\" selected>$name</option>";
 504          $result3 = $db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients");
 505          while ($row3 = $db->sql_fetchrow($result3)) {
 506              $ccid = intval($row3['cid']);
 507              $name = filter($row3['name'], "nohtml");
 508              if($cid!=$ccid) {
 509                  echo "<option value=\"$ccid\">$name</option>";
 510              }
 511          }
 512          echo "</select></td></tr>";
 513          if($imptotal==0) {
 514              $impressions = _UNLIMITED;
 515          } else {
 516              $impressions = $imptotal;
 517          }
 518          if ($active == 1) {
 519              $check1 = "checked";
 520              $check2 = "";
 521          } else {
 522              $check1 = "";
 523              $check2 = "checked";
 524          }
 525          if ($imptotal != 0) {
 526              $unl = "("._XFORUNLIMITED.")";
 527          }
 528          echo "<tr><td>"._BANNERNAME.":</td><td><input type=\"text\" name=\"adname\" size=\"20\" maxlength=\"50\" value=\"".$row['name']."\"></td></tr>";
 529          echo "<tr><td>"._ADDEDDATE.":</td><td>$date</td></tr>";
 530          echo "<tr><td>"._IMPPURCHASED.":</td><td><b>$impressions</b></td></tr>";
 531          echo "<tr><td>"._IMPMADE.":</td><td><b>$impmade</b></td></tr>";
 532          echo "<tr><td>"._ADDIMPRESSIONS.":</td><td><input type=\"text\" name=\"impadded\" size=\"12\" maxlength=\"11\" value=\"0\"> <i>$unl</i></td></tr>";
 533          echo "<tr><td>"._ADCLASS.":</td><td><b>".ucFirst($ad_class)."</b></td></tr>";
 534          if ($ad_class == "code") {
 535              echo "<tr><td>" . _ADCODE . ":</td><td><textarea name=\"ad_code\" rows=\"15\" cols=\"70\">$ad_code</textarea>"
 536                  ."<input type=\"hidden\" name=\"imageurl\" value=\"$imageurl\">"
 537                  ."<input type=\"hidden\" name=\"ad_width\" value=\"$ad_width\">"
 538                  ."<input type=\"hidden\" name=\"ad_height\" value=\"$ad_height\">"
 539                  ."<input type=\"hidden\" name=\"clickurl\" value=\"$clickurl\">"
 540                  ."<input type=\"hidden\" name=\"alttext\" value=\"$alttext\"></td></tr>";
 541          } elseif ($ad_class == "flash") {
 542              echo "<tr><td>" . _FLASHFILEURL . ":</td><td><input type=\"text\" name=\"imageurl\" size=\"50\" maxlength=\"100\" value=\"$imageurl\"> &nbsp; <a href=\"$imageurl\" target=\"_blank\"><img src=\"images/view.gif\" border=\"0\" alt=\""._SHOW."\" title=\""._SHOW."\"></a></td></tr>"
 543                  ."<tr><td>" . _FLASHSIZE . ":</td><td>"._WIDTH.": <input type=\"text\" name=\"ad_width\" size=\"4\" maxlength=\"4\" value=\"$ad_width\"> &nbsp; "._HEIGHT.": <input type=\"text\" name=\"ad_height\" size=\"4\" maxlength=\"4\" value=\"$ad_height\"> &nbsp; "._INPIXELS.""
 544                  ."<input type=\"hidden\" name=\"clickurl\" value=\"$clickurl\">"
 545                  ."<input type=\"hidden\" name=\"alttext\" value=\"$alttext\">"
 546                  ."<input type=\"hidden\" name=\"ad_code\" value=\"$ad_code\"></td></tr>";
 547          } else {
 548              echo "<tr><td>" . _IMAGEURL . ":</td><td><input type=\"text\" name=\"imageurl\" size=\"50\" maxlength=\"100\" value=\"$imageurl\"></td></tr>"
 549                  ."<tr><td>" . _IMAGESIZE . ":</td><td>"._WIDTH.": <input type=\"text\" name=\"ad_width\" size=\"4\" maxlength=\"4\" value=\"$ad_width\"> &nbsp; "._HEIGHT.": <input type=\"text\" name=\"ad_height\" size=\"4\" maxlength=\"4\" value=\"$ad_height\"> &nbsp; "._INPIXELS."</td></tr>"
 550                  ."<tr><td>" . _CLICKURL . ":</td><td><input type=\"text\" name=\"clickurl\" size=\"50\" maxlength=\"200\" value=\"$clickurl\"></td></tr>"
 551                  ."<tr><td>" . _ALTTEXT . ":</td><td><input type=\"text\" name=\"alttext\" size=\"50\" maxlength=\"255\" value=\"$alttext\">"
 552                  ."<input type=\"hidden\" name=\"ad_code\" value=\"$ad_code\"></td></tr>";
 553          }
 554          echo "<tr><td>" . _TYPE . ":</td><td><select name=\"position\">";
 555          $result4 = $db->sql_query("SELECT position_number, position_name FROM ".$prefix."_banner_positions ORDER BY position_number");
 556          while ($row4 = $db->sql_fetchrow($result4)) {
 557              if ($position == $row4['position_number']) {
 558                  $sel = "selected";
 559              } else {
 560                  $sel = "";
 561              }
 562              echo "<option name=\"position\" value=\"".$row4['position_number']."\" $sel>".$row4['position_number']." - ".$row4['position_name']."</option>";
 563          }
 564          echo "</select></td></tr>"
 565              ."<tr><td>" . _ACTIVATE . ":</td><td><input type=\"radio\" name=\"active\" value=\"1\" $check1>" . _YES . "&nbsp;&nbsp;<input type=\"radio\" name=\"active\" value=\"0\" $check2>" . _NO . "</td></tr>"
 566              ."<tr><td>&nbsp;</td><td><input type=\"hidden\" name=\"bid\" value=\"$bid\">"
 567              ."<input type=\"hidden\" name=\"imptotal\" value=\"$imptotal\">"
 568              ."<input type=\"hidden\" name=\"impmade\" value=\"$impmade\">"
 569              ."<input type=\"hidden\" name=\"op\" value=\"BannerChange\">"
 570              ."<input type=\"submit\" value=\"" . _SAVECHANGES . "\">"
 571              ."</form></td></tr></table>";
 572          CloseTable();
 573          include ("footer.php");
 574      }
 575  
 576  	function BannerChange($bid, $cid, $adname, $imptotal, $impadded, $imageurl, $clickurl, $alttext, $position, $active, $ad_code, $ad_width, $ad_height, $impmade) {
 577          global $prefix, $db, $admin_file;
 578          if (!is_numeric($impadded)) {
 579              $impadded = strtoupper($impadded);
 580              if ($impadded == "X") {
 581                  $imp = 0;    
 582              }
 583          } else {
 584              if ($impadded == 0) {
 585                  $imp = $imptotal;
 586              } else {
 587                  if ($imptotal == 0) {
 588                      $imp = $impmade+$impadded;
 589                  } else {
 590                      $imp = $imptotal+$impadded;
 591                  }            
 592              }
 593          }
 594          $alttext = filter($alttext, "nohtml", 1);
 595          $adname = filter($adname, "nohtml", 1);
 596          $cid = intval($cid);
 597          $imp = intval($imp);
 598          $active = intval($active);
 599          $bid = intval($bid);
 600          $db->sql_query("update " . $prefix . "_banner set cid='$cid', name='$adname', imptotal='$imp', imageurl='$imageurl', clickurl='$clickurl', alttext='$alttext', position='$position', active='$active', ad_code='$ad_code', ad_width='$ad_width', ad_height='$ad_height' where bid='$bid'");
 601          Header("Location: ".$admin_file.".php?op=BannersAdmin");
 602      }
 603  
 604  	function BannerClientDelete($cid, $ok=0) {
 605          global $prefix, $db, $admin_file, $ad_admin_menu;
 606          $cid = intval($cid);
 607          if ($ok==1) {
 608              $db->sql_query("delete from " . $prefix . "_banner where cid='$cid'");
 609              $db->sql_query("delete from " . $prefix . "_banner_clients where cid='$cid'");
 610              Header("Location: ".$admin_file.".php?op=BannersAdmin");
 611          } else {
 612              include ("header.php");
 613              GraphicAdmin();
 614              OpenTable();
 615              echo "$ad_admin_menu";
 616              CloseTable();
 617              echo "<br>";
 618              $row = $db->sql_fetchrow($db->sql_query("SELECT cid, name from " . $prefix . "_banner_clients where cid='$cid'"));
 619              $cid = intval($row['cid']);
 620              $name = filter($row['name'], "nohtml");
 621              OpenTable();
 622              echo "<center><b>" . _DELETECLIENT . ": $name</b><br><br>
 623                  " . _SURETODELCLIENT . "<br><br>";
 624              $result2 = $db->sql_query("SELECT imageurl, clickurl, alttext from " . $prefix . "_banner where cid='$cid'");
 625              $numrows = $db->sql_numrows($result2);
 626              if($numrows==0) {
 627                  echo "" . _CLIENTWITHOUTBANNERS . "<br><br>";
 628              } else {
 629                  echo "<b>" . _WARNING . "!!!</b><br>
 630                      " . _DELCLIENTHASBANNERS . ":<br><br>";
 631              }
 632              while ($row2 = $db->sql_fetchrow($result2)) {
 633                  $imageurl = $row2['imageurl'];
 634                  $clickurl = $row2['clickurl'];
 635                  $alttext = filter($row2['alttext'], "nohtml");
 636                  echo "<a href=\"$clickurl\"><img src=\"$imageurl\" border=\"1\" alt=\"$alttext\" title=\"$alttext\"></a><br>
 637                      <a href=\"$clickurl\">$clickurl</a><br><br>";
 638              }
 639          }
 640          echo "" . _SURETODELCLIENT . "<br><br>
 641              [ <a href=\"".$admin_file.".php?op=BannersAdmin#top\">" . _NO . "</a> | <a href=\"".$admin_file.".php?op=BannerClientDelete&amp;cid=$cid&amp;ok=1\">" . _YES . "</a> ]</center><br><br></center>";
 642          CloseTable();
 643          include ("footer.php");
 644      }
 645  
 646  	function BannerClientEdit($cid) {
 647          global $prefix, $db, $admin_file, $ad_admin_menu;
 648          include ("header.php");
 649          GraphicAdmin();
 650          OpenTable();
 651          echo "$ad_admin_menu";
 652          CloseTable();
 653          echo "<br>";
 654          $cid = intval($cid);
 655          $row = $db->sql_fetchrow($db->sql_query("SELECT name, contact, email, login, passwd, extrainfo from " . $prefix . "_banner_clients where cid='$cid'"));
 656          $name = filter($row['name'], "nohtml");
 657          $contact = filter($row['contact'], "nohtml");
 658          $email = filter($row['email'], "nohtml");
 659          $login = filter($row['login'], "nohtml");
 660          $passwd = filter($row['passwd'], "nohtml");
 661          $extrainfo = filter($row['extrainfo'], "nohtml");
 662          OpenTable();
 663          echo "<center><font class=\"option\"><b>" . _EDITCLIENT . "</b></font></center><br><br>"
 664          ."<form action=\"".$admin_file.".php?op=BannerClientChange\" method=\"post\">"
 665          ."" . _CLIENTNAME . ": <input type=\"text\" name=\"name\" value=\"$name\" size=\"30\" maxlength=\"60\"><br><br>"
 666          ."" . _CONTACTNAME . ": <input type=\"text\" name=\"contact\" value=\"$contact\" size=\"30\" maxlength=\"60\"><br><br>"
 667          ."" . _CONTACTEMAIL . ": <input type=\"text\" name=\"email\" size=30 maxlength=\"60\" value=\"$email\"><br><br>"
 668          ."" . _CLIENTLOGIN . ": <input type=\"text\" name=\"login\" size=12 maxlength=\"10\" value=\"$login\"><br><br>"
 669          ."" . _CLIENTPASSWD . ": <input type=\"text\" name=\"passwd\" size=12 maxlength=\"10\" value=\"$passwd\"><br><br>"
 670          ."" . _EXTRAINFO . "<br><textarea name=\"extrainfo\" cols=\"70\" rows=\"15\">$extrainfo</textarea><br><br>"
 671          ."<input type=\"hidden\" name=\"cid\" value=\"$cid\">"
 672          ."<input type=\"hidden\" name=\"op\" value=\"BannerClientChange\">"
 673          ."<input type=\"submit\" value=\"" . _SAVECHANGES . "\">"
 674          ."</form>";
 675          CloseTable();
 676          include ("footer.php");
 677      }
 678  
 679  	function BannerClientChange($cid, $name, $contact, $email, $extrainfo, $login, $passwd) {
 680          global $prefix, $db, $admin_file;
 681          $cid = intval($cid);
 682          $name = filter($name, "nohtml", 1);
 683          $contact = filter($contact, "nohtml", 1);
 684          $email = filter($email, "nohtml", 1);
 685          $login = filter($login, "nohtml", 1);
 686          $passwd = filter($passwd, "nohtml", 1);
 687          $extrainfo = filter($extrainfo, "nohtml", 1);
 688          $db->sql_query("update ".$prefix."_banner_clients set name='$name', contact='$contact', email='$email', login='$login', passwd='$passwd', extrainfo='$extrainfo' where cid='$cid'");
 689          Header("Location: ".$admin_file.".php?op=BannersAdmin#top");
 690      }
 691  
 692  	function ad_positions() {
 693          global $prefix, $db, $banners, $admin_file, $ad_admin_menu, $bgcolor1, $bgcolor2;
 694          include  ("header.php");
 695          GraphicAdmin();
 696          OpenTable();
 697          echo "$ad_admin_menu";
 698          CloseTable();
 699          echo "<br>";
 700          OpenTable();
 701          echo "<center><font class=\"title\"><b>"._CURRENTPOSITIONS."</b></font></center><br><br><table width=\"100%\" border=\"1\"><tr>"
 702              ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _POSITIONNAME . "<b></td>"
 703              ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _POSITIONNUMBER . "<b></td>"
 704              ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _ASSIGNEDADS . "<b></td>"
 705              ."<td bgcolor=\"$bgcolor2\" align=\"center\"><b>" . _FUNCTIONS . "<b></td>";
 706          $result = $db->sql_query("SELECT * FROM ".$prefix."_banner_positions ORDER BY apid");
 707          while ($row = $db->sql_fetchrow($result)) {
 708              $ban_num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner WHERE position='".$row['position_number']."'"));
 709              $row['position_name'] = filter($row['position_name'], "nohtml");
 710              echo "<tr><td bgcolor=\"$bgcolor1\" align=\"center\">".$row['position_name']."</td>"
 711                  ."<td bgcolor=\"$bgcolor1\" align=\"center\">".$row['position_number']."</td>"
 712                  ."<td bgcolor=\"$bgcolor1\" align=\"center\">$ban_num</td>"
 713                  ."<td bgcolor=\"$bgcolor1\" align=\"center\">&nbsp;<a href=\"".$admin_file.".php?op=position_edit&amp;apid=".$row['apid']."\"><img src=\"images/edit.gif\" alt=\""._EDIT."\" title=\""._EDIT."\" border=\"0\" width=\"17\" height=\"17\"></a>  <a href=\"".$admin_file.".php?op=position_delete&amp;apid=".$row['apid']."\"><img src=\"images/delete.gif\" alt=\""._DELETE."\" title=\""._DELETE."\" border=\"0\" width=\"17\" height=\"17\"></a>&nbsp;</td></tr>";
 714          }
 715          echo "</table><br>";
 716          CloseTable();
 717          echo "<br>";
 718          OpenTable();
 719          $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner_positions"));
 720          if ($numrows == 0) {
 721              $pos_num = 0;    
 722          } else {
 723              $row = $db->sql_fetchrow($db->sql_query("SELECT position_number FROM ".$prefix."_banner_positions ORDER BY position_number DESC LIMIT 0,1"));
 724              $pos_num = $row['position_number']+1;
 725          }
 726          echo "<center><font class=\"title\"><b>"._ADDNEWPOSITION."</b></font><br><br>"
 727              ."<form method=\"\" action=\"".$admin_file.".php\">"
 728              .""._POSITIONNAME.": <input type=\"text\" name=\"ad_position_name\"> "._POSITIONNUMBER.": <b>$pos_num</b><input type=\"hidden\" name=\"ad_position_number\" value=\"$pos_num\"><input type=\"hidden\" name=\"position_new\" value=\"1\"><input type=\"hidden\" name=\"op\" value=\"position_save\"><br><br><input type=\"submit\" value=\""._ADDPOSITION."\">"
 729              ."</form></center>";
 730          CloseTable();
 731          echo "<br>";
 732          OpenTable();
 733          echo "<center><b>"._NOTE."</b><br><br>"._POSITIONNOTE."<br>"._POSEXAMPLE."</center>";
 734          CloseTable();
 735          include  ("footer.php");
 736      }
 737      
 738  	function position_save($apid=0, $ad_position_number, $ad_position_name, $position_new=0) {
 739          global $prefix, $db, $admin_file, $ad_admin_menu;
 740          if ($ad_position_name == "") {
 741              include  ("header.php");
 742              GraphicAdmin();
 743              OpenTable();
 744              echo "$ad_admin_menu";
 745              CloseTable();
 746              echo "<br>";
 747              OpenTable();
 748              echo "<center><font class=\"title\"><b>"._ADDNEWPOSITION."</b></font><br><br>"
 749                  .""._POSINFOINCOMPLETE."<br><br>"._GOBACK."</center>";
 750              CloseTable();
 751              include ("footer.php");
 752              die();            
 753          }
 754          $ad_position_name = filter($ad_position_name, "nohtml", 1);
 755          $ad_position_number = intval($ad_position_number);
 756          if ($position_new == 1) {
 757              $db->sql_query("INSERT INTO ".$prefix."_banner_positions VALUES (NULL, '$ad_position_number', '$ad_position_name')");
 758          } else {
 759              $apid = intval($apid);
 760              $db->sql_query("UPDATE ".$prefix."_banner_positions SET position_name='$ad_position_name' WHERE apid='$apid'");
 761          }
 762          Header("Location: ".$admin_file.".php?op=ad_positions");
 763      }
 764      
 765  	function position_edit($apid) {
 766          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
 767          $apid = intval($apid);
 768          if ($apid == "" AND $apid == 0) {
 769              Header("Location: ".$admin_file.".php?op=ad_positions");    
 770              die();
 771          }
 772          include  ("header.php");
 773          GraphicAdmin();
 774          OpenTable();
 775          echo "$ad_admin_menu";
 776          CloseTable();
 777          echo "<br>";
 778          OpenTable();
 779          $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid='$apid'"));
 780          $row['position_name'] = filter($row['position_name'], "nohtml");
 781          echo "<center><font class=\"title\"><b>"._EDITPOSITION."</b></font><br><br>"
 782              ."<form method=\"POST\" action=\"".$admin_file.".php\">"
 783              .""._POSITIONNAME.": <input type=\"text\" name=\"ad_position_name\" value=\"".$row['position_name']."\"> "._POSITIONNUMBER.": <b>".$row['position_number']."</b><input type=\"hidden\" name=\"ad_position_number\" value=\"".$row['position_number']."\"><input type=\"hidden\" name=\"apid\" value=\"$apid\"><input type=\"hidden\" name=\"op\" value=\"position_save\"><br><br><input type=\"submit\" value=\""._SAVEPOSITION."\">"
 784              ."</form></center>";
 785          CloseTable();
 786          include  ("footer.php");
 787      }
 788  
 789  	function position_delete($apid, $ok=0, $active=0, $new_pos=x) {
 790          global $prefix, $db, $admin_file, $ad_admin_menu;
 791          $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner_positions"));
 792          if ($numrows == 1) {
 793              include  ("header.php");
 794              GraphicAdmin();
 795              OpenTable();
 796              echo "$ad_admin_menu";
 797              CloseTable();
 798              echo "<br>";
 799              OpenTable();
 800              echo "<center><b>"._DELETEPOSITION."</b><br><br>
 801                     "._CANTDELETEPOSITION."<br><br>"._GOBACK."";
 802                 CloseTable();
 803                 include ("footer.php");
 804                 die();
 805          }
 806          if ($ok == 1) {
 807              if ($new_pos == "x" OR $new_post == "") {
 808                  $db->sql_query("DELETE FROM ".$prefix."_banner_positions WHERE apid='$apid'");
 809              } else {
 810                  if ($active == "same") {
 811                      $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid='$apid'"));
 812                  $result = $db->sql_query("SELECT * FROM ".$prefix."_banner WHERE position='".$row['position_number']."'");    
 813                      while($row2 = $db->sql_fetchrow($result)) {
 814                          $db->sql_query("UPDATE ".$prefix."_banner SET position='$new_pos' WHERE bid='".$row2['bid']."'");
 815                      }
 816                      $db->sql_query("DELETE FROM ".$prefix."_banner_positions WHERE apid='$apid'");
 817                  } elseif ($active == "active") {
 818                      $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid='$apid'"));
 819                  $result = $db->sql_query("SELECT * FROM ".$prefix."_banner WHERE position='".$row['position_number']."'");    
 820                      while($row2 = $db->sql_fetchrow($result)) {
 821                          $db->sql_query("UPDATE ".$prefix."_banner SET position='$new_pos', active='1' WHERE bid='".$row2['bid']."'");
 822                      }
 823                      $db->sql_query("DELETE FROM ".$prefix."_banner_positions WHERE apid='$apid'");
 824                  } elseif ($active == "inactive") {
 825                      $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid='$apid'"));
 826                  $result = $db->sql_query("SELECT * FROM ".$prefix."_banner WHERE position='".$row['position_number']."'");    
 827                      while($row2 = $db->sql_fetchrow($result)) {
 828                          $db->sql_query("UPDATE ".$prefix."_banner SET position='$new_pos', active='0' WHERE bid='".$row2['bid']."'");
 829                      }
 830                      $db->sql_query("DELETE FROM ".$prefix."_banner_positions WHERE apid='$apid'");
 831                  } elseif ($active == "delete_all") {
 832                      $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid='$apid'"));
 833                      $db->sql_query("DELETE FROM ".$prefix."_banner WHERE position='".$row['position_number']."'");
 834                      $db->sql_query("DELETE FROM ".$prefix."_banner_positions WHERE apid='$apid'");
 835                  }
 836              }
 837              Header("Location: ".$admin_file.".php?op=ad_positions");
 838              die();
 839          } else {
 840              include  ("header.php");
 841              GraphicAdmin();
 842              OpenTable();
 843              echo "$ad_admin_menu";
 844              CloseTable();
 845              echo "<br>";
 846              OpenTable();
 847              $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid='$apid'"));
 848              $row['position_name'] = filter($row['position_name'], "nohtml");
 849              echo "<br><center><b>"._DELETEPOSITION.": ".$row['position_name']."</b><br><br>
 850                  "._SURETODELPOSITION."<br><br>";
 851              $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner WHERE position='".$row['position_number']."'"));
 852              if($numrows != 0) {
 853                  echo ""._POSITIONHASADS."<br><br>";
 854                  echo "<form action=\"".$admin_file.".php\" method=\"POST\">";
 855                  echo ""._MOVEADS.": <select name=\"new_pos\">";
 856                  $result = $db->sql_query("SELECT * FROM ".$prefix."_banner_positions WHERE apid!='$apid'");
 857                  while($row = $db->sql_fetchrow($result)) {
 858                      echo "<option value=\"".$row['position_number']."\">".$row['position_number'].": ".$row['position_name']."</option>";
 859                  }
 860                  echo "</select><br><br>";
 861                  echo ""._MOVEDADSSTATUS.": <select name=\"active\">";
 862                  echo "<option value=\"same\">"._NOCHANGES."</option>";
 863                  echo "<option value=\"active\">"._ACTIVE."</option>";
 864                  echo "<option value=\"inactive\">"._INACTIVE."</option>";
 865                  echo "<option value=\"delete_all\">"._DELETEALLADS." ($numrows)</option>";
 866                  echo "</select><br><br>";
 867                  echo "<input type=\"hidden\" name=\"apid\" value=\"$apid\"><input type=\"hidden\" name=\"ok\" value=\"1\"><input type=\"hidden\" name=\"op\" value=\"position_delete\"><input type=\"submit\" value=\""._DELETE."\">";
 868                  echo "</form>";
 869              } else {
 870                  echo "[ <a href=\"".$admin_file.".php?op=ad_positions\">"._NO."</a> | <a href=\"".$admin_file.".php?op=position_delete&amp;apid=$apid&amp;ok=1\">"._YES."</a> ]</center>";
 871              }
 872          }
 873          CloseTable();
 874          include ("footer.php");
 875      }
 876  
 877  	function ad_terms($save=0, $terms_body=0, $country=0) {
 878          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
 879          if ($save != 0) {
 880              $db->sql_query("UPDATE ".$prefix."_banner_terms SET terms_body='$terms_body', country='$country'");
 881              Header("Location: ".$admin_file.".php?op=ad_terms");
 882              die();
 883          }
 884          include  ("header.php");
 885          GraphicAdmin();
 886          OpenTable();
 887          echo "$ad_admin_menu";
 888          CloseTable();
 889          echo "<br>";
 890          OpenTable();
 891          $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_terms"));
 892          $row['terms_body'] = filter($row['terms_body']);
 893          echo "<center><font class=\"title\"><b>"._EDITTERMS."</b></font><br><br><i>"._SITENAMEADS."</i><br><br>"
 894              ."<form method=\"POST\" action=\"".$admin_file.".php\">"
 895              .""._TERMSOFSERVICEBODY.":<br><br><textarea name=\"terms_body\" rows=\"20\" cols=\"70\">".$row['terms_body']."</textarea><br><br>"
 896              .""._COUNTRYNAME.":<br><br><select name=\"country\">";
 897          $result = $db->sql_query("SELECT DISTINCT country FROM ".$prefix."_cities");
 898          while ($row2 = $db->sql_fetchrow($result)) {
 899              if ($row['country'] == $row2['country']) {
 900                  $sel = "selected";
 901              } else {
 902                  $sel = "";    
 903              }
 904              echo "<option value=\"".$row2['country']."\" $sel>".$row2['country']."</option>";
 905          }
 906          echo "</select><br><br>"
 907              ."<input type=\"hidden\" name=\"save\" value=\"1\"><input type=\"hidden\" name=\"op\" value=\"ad_terms\"><br><br><input type=\"submit\" value=\""._SAVECHANGES."\">"
 908              ."</form></center><br><table border=\"0\" width=\"80%\" align=\"center\"><tr><td align=\"center\"><i>"._TERMSNOTE."</i></td></tr></table>";
 909          CloseTable();
 910          include  ("footer.php");
 911      }
 912      
 913  	function ad_plans() {
 914          global $prefix, $db, $admin_file, $ad_admin_menu, $bgcolor1, $bgcolor2;
 915          define('NO_EDITOR', true);
 916          include  ("header.php");
 917          GraphicAdmin();
 918          OpenTable();
 919          echo "$ad_admin_menu";
 920          CloseTable();
 921          echo "<br>";
 922          $numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_banner_plans"));
 923          if ($numrows != 0) {
 924              OpenTable();
 925              $result = $db->sql_query("SELECT * FROM ".$prefix."_banner_plans");
 926              echo "<center><font class=\"title\"><b>"._ADVERTISINGPLANS."</b></font></center><br>";
 927              echo "<table border=\"1\" width=\"100%\"><tr><td bgcolor=\"$bgcolor2\"><b>&nbsp;"._PLANNAME."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._DELIVERY."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._STATUS."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._PRICE."</b></td><td align=\"center\" bgcolor=\"$bgcolor2\"><b>"._FUNCTIONS."</b></td></tr>";
 928              while ($row = $db->sql_fetchrow($result)) {
 929                  if ($row['delivery_type'] == 0) {
 930                      $type = _IMPRESSIONS;
 931                  } elseif ($row['delivery_type'] == 1) {
 932                      $type = _CLICKS;
 933                  } elseif ($row['delivery_type'] == 2) {
 934                      $type = _DAYS;
 935                  } elseif ($row['delivery_type'] == 3) {
 936                      $type = _MONTHS;
 937                  } elseif ($row['delivery_type'] == 4) {
 938                      $type = _YEARS;
 939                  }
 940                  $active = intval($row['active']);
 941                  if ($active == 1) {
 942                      $t_active = "<img src=\"images/active.gif\" alt=\""._ACTIVE."\" title=\""._ACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
 943                      $c_active = "<img src=\"images/inactive.gif\" alt=\""._DEACTIVATE."\" title=\""._DEACTIVATE."\" border=\"0\" width=\"16\" height=\"16\">";
 944                  } else {
 945                      $t_active = "<img src=\"images/inactive.gif\" alt=\""._INACTIVE."\" title=\""._INACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
 946                      $c_active = "<img src=\"images/active.gif\" alt=\""._ACTIVATE."\" title=\""._ACTIVATE."\" border=\"0\" width=\"16\" height=\"16\">";
 947                  }
 948                  echo "<tr><td bgcolor=\"$bgcolor1\">&nbsp;".$row['name']."</td>"
 949                      ."<td align=\"center\" bgcolor=\"$bgcolor1\">".$row['delivery']." $type</td>"
 950                      ."<td align=\"center\" bgcolor=\"$bgcolor1\">$t_active</td>"
 951                      ."<td align=\"center\" bgcolor=\"$bgcolor1\">".$row['price']."</td>"
 952                      ."<td align=\"center\" bgcolor=\"$bgcolor1\">&nbsp;<a href=\"".$admin_file.".php?op=ad_plans_edit&amp;pid=".$row['pid']."\"><img src=\"images/edit.gif\" alt=\""._EDIT."\" title=\""._EDIT."\" border=\"0\" width=\"17\" height=\"17\"></a>  <a href=\"".$admin_file.".php?op=ad_plans_status&amp;pid=".$row['pid']."&status=$active\">$c_active</a>  <a href=\"".$admin_file.".php?op=ad_plans_delete&amp;pid=".$row['pid']."&amp;ok=0\"><img src=\"images/delete.gif\" alt=\""._DELETE."\" title=\""._DELETE."\" border=\"0\" width=\"17\" height=\"17\"></a>&nbsp;</td></tr>";
 953              }
 954              echo "</table>";
 955              CloseTable();
 956              echo "<br>";
 957          }
 958          OpenTable();
 959          echo "<center><font class=\"title\"><b>"._ADDADVERTISINGPLAN."</b></font></center><br><br>";
 960          echo "<table border=\"0\"><tr><td>";
 961          echo "<form method=\"POST\" action=\"".$admin_file.".php\">";
 962          echo ""._PLANNAME.":</td><td><input type=\"text\" size=\"40\" name=\"name\"></td></tr>";
 963          echo "<tr><td>"._PLANDESCRIPTION.":</td><td><textarea name=\"description\" rows=\"15\" cols=\"70\"></textarea></td></tr>";
 964          echo "<tr><td>"._DELIVERYQUANTITY.":</td><td><input type=\"text\" size=\"10\" name=\"delivery\"></td></tr>";
 965          echo "<tr><td>"._DELIVERYTYPE.":</td><td><select name=\"type\">"
 966              ."<option value=\"0\">"._IMPRESSIONS."</option>"
 967              ."<option value=\"1\">"._CLICKS."</option>"
 968              ."<option value=\"2\">"._PDAYS."</option>"
 969              ."<option value=\"3\">"._PMONTHS."</option>"
 970              ."<option value=\"4\">"._PYEARS."</option>"
 971              ."</select></td></tr>";
 972          echo "<tr><td>"._PRICE.":</td><td><input type=\"text\" size=\"10\" name=\"price\"></td></tr>";
 973          echo "<tr><td>"._PLANBUYLINKS.":</td><td><textarea name=\"buy_links\" rows=\"15\" cols=\"70\"></textarea></td></tr>";
 974          echo "<tr><td>"._INITIALSTATUS.":</td><td><input type=\"radio\" name=\"status\" value=\"1\" checked> "._ACTIVE." &nbsp;&nbsp; <input type=\"radio\" name=\"status\" value=\"0\"> "._INACTIVE."</td></tr>";
 975          echo "<tr><td>&nbsp;</td><td><input type=\"hidden\" name=\"op\" value=\"ad_plans_add\"><input type=\"submit\" value=\""._ADDNEWPLAN."\"></td></tr></table></form><br><center><i>"._PLANSNOTE."</i></center>";
 976          CloseTable();
 977          include  ("footer.php");
 978      }
 979  
 980  	function ad_plans_add($name, $description, $delivery, $type, $price, $buy_links, $status) {
 981          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
 982          if (!empty($name) AND !empty($description) AND !empty($delivery) AND (isset($type) AND is_numeric($type)) AND !empty($price) AND !empty($buy_links) AND !empty($status)) {
 983              $name = filter($name, "nohtml", 1);
 984              $description = filter($description, "", 1);
 985              $price = filter($price, "nohtml", 1);
 986              $buy_links = filter($buy_links, "", 1);
 987              $db->sql_query("INSERT INTO ".$prefix."_banner_plans VALUES (NULL, '$status', '$name', '$description', '$delivery', '$type', '$price', '$buy_links')");
 988              Header("Location: ".$admin_file.".php?op=ad_plans");
 989              die();
 990          } else {
 991              include  ("header.php");
 992              GraphicAdmin();
 993              OpenTable();
 994              echo "$ad_admin_menu";
 995              CloseTable();
 996              echo "<br>";
 997              OpenTable();
 998              echo "<center>"._ADDPLANERROR."<br><br>"._GOBACK."</center>";
 999              CloseTable();
1000              include  ("footer.php");
1001          }
1002      }
1003  
1004  	function ad_plans_edit($pid) {
1005          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
1006          define('NO_EDITOR', true);
1007          include  ("header.php");
1008          GraphicAdmin();
1009          OpenTable();
1010          echo "$ad_admin_menu";
1011          CloseTable();
1012          echo "<br>";
1013          OpenTable();
1014          $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_plans WHERE pid='$pid'"));
1015          echo "<center><font class=\"title\"><b>"._ADVERTISINGPLANEDIT."</b></font></center><br><br>";
1016          echo "<table border=\"0\"><tr><td>";
1017          echo "<form method=\"POST\" action=\"".$admin_file.".php\">";
1018          echo ""._PLANNAME.":</td><td><input type=\"text\" size=\"40\" name=\"name\" value=\"".$row['name']."\"></td></tr>";
1019          echo "<tr><td>"._PLANDESCRIPTION.":</td><td><textarea name=\"description\" rows=\"15\" cols=\"70\">".$row['description']."</textarea></td></tr>";
1020          echo "<tr><td>"._DELIVERYQUANTITY.":</td><td><input type=\"text\" size=\"10\" name=\"delivery\" value=\"".$row['delivery']."\"></td></tr>";
1021          if ($row['delivery_type'] == 0) {
1022              $sel0 = "selected";
1023          }
1024          if ($row['delivery_type'] == 1) {
1025              $sel1 = "selected";
1026          }
1027          if ($row['delivery_type'] == 2) {
1028              $sel2 = "selected";
1029          }
1030          if ($row['delivery_type'] == 3) {
1031              $sel3 = "selected";
1032          }
1033          if ($row['delivery_type'] == 4) {
1034              $sel4 = "selected";
1035          }
1036          echo "<tr><td>"._DELIVERYTYPE.":</td><td><select name=\"type\">"
1037              ."<option value=\"0\" $sel0>"._IMPRESSIONS."</option>"
1038              ."<option value=\"1\" $sel1>"._CLICKS."</option>"
1039              ."<option value=\"2\" $sel2>"._PDAYS."</option>"
1040              ."<option value=\"3\" $sel3>"._PMONTHS."</option>"
1041              ."<option value=\"4\" $sel4>"._PYEARS."</option>"
1042              ."</select></td></tr>";
1043          echo "<tr><td>"._PRICE.":</td><td><input type=\"text\" size=\"10\" name=\"price\" value=\"".$row['price']."\"></td></tr>";
1044          echo "<tr><td>"._PLANBUYLINKS.":</td><td><textarea name=\"buy_links\" rows=\"15\" cols=\"70\">".$row['buy_links']."</textarea></td></tr>";
1045          if ($row['active'] == 1) {
1046              $check0 = "checked";
1047              $check1 = "";
1048          } elseif ($row['active'] == 0) {
1049              $check0 = "";
1050              $check1 = "checked";
1051          }
1052          echo "<tr><td>"._STATUS.":</td><td><input type=\"radio\" name=\"status\" value=\"1\" $check0> "._ACTIVE." &nbsp;&nbsp; <input type=\"radio\" name=\"status\" value=\"0\" $check1> "._INACTIVE."</td></tr>";
1053          echo "<tr><td>&nbsp;</td><td><input type=\"hidden\" name=\"pid\" value=\"$pid\"><input type=\"hidden\" name=\"op\" value=\"ad_plans_save\"><input type=\"submit\" value=\""._SAVECHANGES."\"></td></tr></table></form><br><center><i>"._PLANSNOTE."</i></center>";
1054          CloseTable();
1055          include  ("footer.php");
1056      }
1057      
1058  	function ad_plans_save($pid, $name, $description, $delivery, $type, $price, $buy_links, $status) {
1059          global $prefix, $db, $banners, $admin_file, $ad_admin_menu;
1060          if (!empty($name) AND !empty($description) AND !empty($delivery) AND (isset($type) AND is_numeric($type)) AND !empty($price) AND !empty($buy_links) AND !empty($status)) {
1061              $name = filter($name, "nohtml", 1);
1062              $description = filter($description, "", 1);
1063              $price = filter($price, "nohtml", 1);
1064              $buy_links = filter($buy_links, "", 1);
1065              $db->sql_query("UPDATE ".$prefix."_banner_plans SET active='$status', name='$name', description='$description', delivery='$delivery', delivery_type='$type', price='$price', buy_links='$buy_links' WHERE pid='$pid'");
1066              Header("Location: ".$admin_file.".php?op=ad_plans");
1067              die();
1068          } else {
1069              include  ("header.php");
1070              GraphicAdmin();
1071              OpenTable();
1072              echo "$ad_admin_menu";
1073              CloseTable();
1074              echo "<br>";
1075              OpenTable();
1076              echo "<center>"._ADDPLANERROR."<br><br>"._GOBACK."</center>";
1077              CloseTable();
1078              include  ("footer.php");
1079          }
1080      }
1081      
1082  	function ad_plans_delete($pid, $ok=0) {
1083          global $prefix, $db, $admin_file, $ad_admin_menu;
1084          if ($ok == 1) {
1085              $db->sql_query("DELETE FROM ".$prefix."_banner_plans WHERE pid='$pid'");
1086              Header("Location: ".$admin_file.".php?op=ad_plans");
1087              die();
1088          } else {
1089              include  ("header.php");
1090              GraphicAdmin();
1091              OpenTable();
1092              echo "$ad_admin_menu";
1093              CloseTable();
1094              echo "<br>";
1095              OpenTable();
1096              $row = $db->sql_fetchrow($db->sql_query("SELECT * FROM ".$prefix."_banner_plans WHERE pid='$pid'"));
1097              echo "<center><b>"._DELETEPLAN.": ".$row['name']."</b><br><br>"
1098                  .""._SURETODELPLAN."<br><br>"
1099                  ."[ <a href=\"".$admin_file.".php?op=ad_plans\">"._NO."</a> | <a href=\"".$admin_file.".php?op=ad_plans_delete&amp;pid=$pid&amp;ok=1\">"._YES."</a> ]</center>";
1100              CloseTable();
1101              include ("footer.php");
1102          }
1103      }
1104  
1105  	function ad_plans_status($pid, $status) {
1106          global $prefix, $db, $admin_file;
1107          if ($status == 1) {
1108              $active = 0;
1109          } else {
1110              $active = 1;
1111          }
1112          $pid = intval($pid);
1113          $db->sql_query("UPDATE ".$prefix."_banner_plans SET active='$active' WHERE pid='$pid'");
1114          Header("Location: ".$admin_file.".php?op=ad_plans");
1115      }
1116  
1117  if (!isset($save)) { $save = ""; }
1118  if (!isset($terms_body)) { $terms_body = ""; }
1119  if (!isset($country)) { $country = ""; }
1120  if (!isset($ok)) { $ok = ""; }
1121  if (!isset($active)) { $active = ""; }
1122  if (!isset($new_pos)) { $new_pos = ""; }
1123  
1124      switch($op) {
1125  
1126          case "BannersAdmin":
1127          BannersAdmin();
1128          break;
1129  
1130          case "BannersAdd":
1131          BannersAdd($name, $cid, $adname, $imptotal, $imageurl, $clickurl, $alttext, $position, $active, $ad_class, $ad_code, $ad_width, $ad_height);
1132          break;
1133  
1134          case "BannerAddClient":
1135          BannerAddClient($name, $contact, $email, $login, $passwd, $extrainfo);
1136          break;
1137  
1138          case "BannerDelete":
1139          BannerDelete($bid, $ok);
1140          break;
1141  
1142          case "BannerEdit":
1143          BannerEdit($bid);
1144          break;
1145  
1146          case "BannerChange":
1147          BannerChange($bid, $cid, $adname, $imptotal, $impadded, $imageurl, $clickurl, $alttext, $position, $active, $ad_code, $ad_width, $ad_height, $impmade);
1148          break;
1149  
1150          case "BannerClientDelete":
1151          BannerClientDelete($cid, $ok);
1152          break;
1153  
1154          case "BannerClientEdit":
1155          BannerClientEdit($cid);
1156          break;
1157  
1158          case "BannerClientChange":
1159          BannerClientChange($cid, $name, $contact, $email, $extrainfo, $login, $passwd);
1160          break;
1161  
1162          case "BannerStatus":
1163          BannerStatus($bid, $status);
1164          break;
1165  
1166          case "add_banner":
1167          add_banner();
1168          break;
1169          
1170          case "add_client":
1171          add_client();
1172          break;
1173  
1174          case "ad_positions":
1175          ad_positions();
1176          break;
1177          
1178          case "position_save":
1179          position_save($apid, $ad_position_number, $ad_position_name, $position_new);
1180          break;
1181  
1182          case "position_edit":
1183          position_edit($apid);
1184          break;
1185  
1186          case "position_delete":
1187          position_delete($apid, $ok, $active, $new_pos);
1188          break;
1189  
1190          case "ad_terms":
1191          ad_terms($save, $terms_body, $country);
1192          break;
1193          
1194          case "ad_plans":
1195          ad_plans();
1196          break;
1197  
1198          case "ad_plans_add":
1199          ad_plans_add($name, $description, $delivery, $type, $price, $buy_links, $status);
1200          break;
1201  
1202          case "ad_plans_edit":
1203          ad_plans_edit($pid);
1204          break;
1205  
1206          case "ad_plans_save":
1207          ad_plans_save($pid, $name, $description, $delivery, $type, $price, $buy_links, $status);
1208          break;
1209          
1210          case "ad_plans_delete":
1211          ad_plans_delete($pid, $ok);
1212          break;
1213          
1214          case "ad_plans_status":
1215          ad_plans_status($pid, $status);
1216          break;
1217  
1218      }
1219  
1220  } else {
1221      echo "Access Denied";
1222  }
1223  
1224  ?>


Généré le : Sun Apr 1 11:11:59 2007 par Balluche grâce à PHPXref 0.7