Affiliate Edit.php:
<?php // $Revision: 2.1.2.7 $
/************************************************************************/
/* phpPgAds */
/* ======== */
/* */
/* Copyright (c) 2001-2005 by the phpPgAds developers */
/* For more information visit: http://phppgads.sourceforge.net */
/* */
/* 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. */
/************************************************************************/
// Include required files
require ("config.php");
require ("lib-statistics.inc.php");
require ("lib-zones.inc.php");
require ("lib-languages.inc.php");
// Register input variables
phpAds_registerGlobal ('move', 'name', 'website', 'contact', 'email', 'language', 'publiczones',
'errormessage', 'username', 'password', 'affiliatepermissions', 'submit',
'publiczones_old', 'pwold', 'pw', 'pw2');
// Security check
phpAds_checkAccess(phpAds_Admin+phpAds_Affiliate);
/*********************************************************/
/* Affiliate interface security */
/*********************************************************/
if (phpAds_isUser(phpAds_Affiliate))
{
if (phpAds_isAllowed(phpAds_ModifyInfo))
{
$affiliateid = phpAds_getUserID();
}
else
{
phpAds_PageHeader("1");
phpAds_Die ($strAccessDenied, $strNotAdmin);
}
}
/*********************************************************/
/* Process submitted form */
/*********************************************************/
if (isset($submit))
{
$errormessage = array();
// Get previous values
if (isset($affiliateid) && $affiliateid)
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
WHERE
affiliateid = '".$affiliateid."'
") or phpAds_sqlDie();
if (phpAds_dbNumRows($res))
{
$affiliate = phpAds_dbFetchArray($res);
}
}
// Name
if (phpAds_isUser(phpAds_Admin))
$affiliate['name'] = trim($name);
// Website
if (isset($website) && $website == 'http://')
$affiliate['website'] = '';
else
$affiliate['website'] = trim($website);
// Default fields
$affiliate['contact'] = trim($contact);
$affiliate['email'] = trim($email);
$affiliate['language'] = trim($language);
// Public
$affiliate['publiczones'] = isset($publiczones) ? 't' : 'f';
if (phpAds_isUser(phpAds_Admin))
{
// Password
if (isset($password))
{
if ($password == '')
$affiliate['password'] = '';
elseif ($password != '********')
$affiliate['password'] = md5($password);
}
// Username
if (isset($username) && $username != '')
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_clients']."
WHERE
LOWER(clientusername) = '".strtolower($username)."'
") or phpAds_sqlDie();
$duplicateclient = (phpAds_dbNumRows($res) > 0);
$duplicateadmin = (strtolower($phpAds_config['admin']) == strtolower($username));
if ($affiliateid == '')
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
WHERE
LOWER(username) = '".strtolower($username)."'
") or phpAds_sqlDie();
if (phpAds_dbNumRows($res) > 0 || $duplicateclient || $duplicateadmin)
$errormessage[] = $strDuplicateClientName;
}
else
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
WHERE
LOWER(username) = '".strtolower($username)."' AND
affiliateid != '$affiliateid'
") or phpAds_sqlDie();
if (phpAds_dbNumRows($res) > 0 || $duplicateclient || $duplicateadmin)
$errormessage[] = $strDuplicateClientName;
}
if (count($errormessage) == 0)
{
// Set username
$affiliate['username'] = $username;
}
}
// Permissions
$affiliate['permissions'] = 0;
if (isset($affiliatepermissions) && is_array($affiliatepermissions))
{
for ($i=0;$i<sizeof($affiliatepermissions);$i++)
{
$affiliate['permissions'] += $affiliatepermissions[$i];
}
}
}
else
{
// Password
if (isset($pwold) && strlen($pwold) ||
isset($pw) && strlen($pw) ||
isset($pw2) && strlen($pw2))
{
if (md5($pwold) != $affiliate['password'])
$errormessage[] = $strPasswordWrong;
elseif (!strlen($pw) || strstr("\\", $pw))
$errormessage[] = $strInvalidPassword;
elseif (strcmp($pw, $pw2))
$errormessage[] = $strNotSamePasswords;
else
$affiliate['password'] = md5($pw);
}
}
if (count($errormessage) == 0)
{
if ($affiliateid && (!isset($publiczones) || $publiczones != 't') && $publiczones_old == 't')
{
// Reset append codes which called this affiliate's zones
$res = phpAds_dbQuery("
SELECT
zoneid
FROM
".$phpAds_config['tbl_zones']."
WHERE
affiliateid = '$affiliateid'
");
$zones = array();
while ($currentrow = phpAds_dbFetchArray($res))
$zones[] = $currentrow['zoneid'];
if (count($zones))
{
$res = phpAds_dbQuery("
SELECT
zoneid,
append
FROM
".$phpAds_config['tbl_zones']."
WHERE
appendtype = ".phpAds_ZoneAppendZone." AND
affiliateid <> '$affiliateid'
");
while ($currentrow = phpAds_dbFetchArray($res))
{
$append = phpAds_ZoneParseAppendCode($currentrow['append']);
if (in_array($append[0]['zoneid'], $zones))
{
phpAds_dbQuery("
UPDATE
".$phpAds_config['tbl_zones']."
SET
appendtype = ".phpAds_ZoneAppendRaw.",
append = ''
WHERE
zoneid = '".$currentrow['zoneid']."'
");
}
}
}
}
if (!isset($affiliateid) || $affiliateid == '')
{
$keys = array();
$values = array();
while (list($key, $value) = each($affiliate))
{
$keys[] = $key;
$values[] = $value;
}
$query = "INSERT INTO ".$phpAds_config['tbl_affiliates']." (";
$query .= implode(", ", $keys);
$query .= ") VALUES ('";
$query .= implode("', '", $values);
$query .= "')";
// Insert
phpAds_dbQuery($query)
or phpAds_sqlDie();
$affiliateid = phpAds_dbInsertID($phpAds_config['tbl_affiliates'].'_affiliateid_seq');
// Go to next page
if (isset($move) && $move == 't')
{
// Move loose zones to this affiliate
$res = phpAds_dbQuery("
UPDATE
".$phpAds_config['tbl_zones']."
SET
affiliateid = '".$affiliateid."'
WHERE
affiliateid IS NULL OR
affiliateid = 0
");
header ("Location: affiliate-zones.php?affiliateid=".$affiliateid);
}
else
{
header ("Location: zone-edit.php?affiliateid=".$affiliateid);
}
}
else
{
$pairs = array();
while (list($key, $value) = each($affiliate))
$pairs[] = " ".$key."='".$value."'";
$query = "UPDATE ".$phpAds_config['tbl_affiliates']." SET ";
$query .= trim(implode(", ", $pairs))." ";
$query .= "WHERE affiliateid = ".$affiliateid;
// Update
phpAds_dbQuery($query)
or phpAds_sqlDie();
// Go to next page
if (phpAds_isUser(phpAds_Affiliate))
{
// Set current session to new language
$Session['language'] = $language;
phpAds_SessionDataStore();
}
header ("Location: affiliate-zones.php?affiliateid=".$affiliateid);
}
exit;
}
else
{
// If an error occured set the password back to its previous value
$affiliate['password'] = $password;
}
}
/*********************************************************/
/* HTML framework */
/*********************************************************/
if ($affiliateid != "")
{
if (phpAds_isUser(phpAds_Admin))
{
if (isset($Session['prefs']['affiliate-index.php']['listorder']))
$navorder = $Session['prefs']['affiliate-index.php']['listorder'];
else
$navorder = '';
if (isset($Session['prefs']['affiliate-index.php']['orderdirection']))
$navdirection = $Session['prefs']['affiliate-index.php']['orderdirection'];
else
$navdirection = '';
// Get other affiliates
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
".phpAds_getAffiliateListOrder ($navorder, $navdirection)."
") or phpAds_sqlDie();
while ($row = phpAds_dbFetchArray($res))
{
phpAds_PageContext (
phpAds_buildAffiliateName ($row['affiliateid'], $row['name']),
"affiliate-edit.php?affiliateid=".$row['affiliateid'],
$affiliateid == $row['affiliateid']
);
}
phpAds_PageShortcut($strAffiliateHistory, 'stats-affiliate-history.php?affiliateid='.$affiliateid, 'images/icon-statistics.gif');
phpAds_PageHeader("4.2.2");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>".phpAds_getAffiliateName($affiliateid)."</b><br><br><br>";
phpAds_ShowSections(array("4.2.2", "4.2.3"));
}
else
{
phpAds_PageHeader("2.2");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>".phpAds_getAffiliateName($affiliateid)."</b><br><br><br>";
phpAds_ShowSections(array("2.1", "2.2"));
}
// Do not get this information if the page
// is the result of an error message
if (!isset($affiliate))
{
$res = phpAds_dbQuery("
SELECT
*
FROM
".$phpAds_config['tbl_affiliates']."
WHERE
affiliateid = '".$affiliateid."'
") or phpAds_sqlDie();
if (phpAds_dbNumRows($res))
{
$affiliate = phpAds_dbFetchArray($res);
}
// Set password to default value
if ($affiliate['password'] != '')
$affiliate['password'] = '********';
}
}
else
{
phpAds_PageHeader("4.2.1");
echo "<img src='images/icon-affiliate.gif' align='absmiddle'> <b>".phpAds_getAffiliateName($affiliateid)."</b><br><br><br>";
phpAds_ShowSections(array("4.2.1"));
// Do not set this information if the page
// is the result of an error message
if (!isset($affiliate))
{
$affiliate['name'] = $strUntitled;
$affiliate['website'] = 'http://';
$affiliate['contact'] = '';
$affiliate['email'] = '';
$affiliate['publiczones'] = 'f';
$affiliate['username'] = '';
$affiliate['password'] = '';
$affiliate['permissions'] = 0;
}
}
$tabindex = 1;
/*********************************************************/
/* Main code */
/*********************************************************/
echo "<br><br>";
echo "<form name='affiliateform' method='post' action='affiliate-edit.php' onSubmit='return phpAds_formCheck(this);'>";
echo "<input type='hidden' name='affiliateid' value='".(isset($affiliateid) && $affiliateid != '' ? $affiliateid : '')."'>";
echo "<input type='hidden' name='move' value='".(isset($move) && $move != '' ? $move : '')."'>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='3'><b>".$strBasicInformation."</b></td></tr>";
echo "<tr height='1'><td width='30'><img src='images/break.gif' height='1' width='30'></td>";
echo "<td width='200'><img src='images/break.gif' height='1' width='200'></td>";
echo "<td width='100%'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
// Name
echo "<tr><td width='30'> </td><td width='200'>".$strName."</td>";
if (phpAds_isUser(phpAds_Admin))
echo "<td width='100%'><input onBlur='phpAds_formUpdate(this);' class='flat' type='text' name='name' size='35' style='width:350px;' value='".phpAds_htmlQuotes($affiliate['name'])."' tabindex='".($tabindex++)."'></td>";
else
echo "<td width='100%'>".(isset($affiliate['name']) ? $affiliate['name'] : '');
echo "</td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
// Website
echo "<tr><td width='30'> </td><td width='200'>".$strWebsite."</td><td>";
echo "<input onBlur='phpAds_formUpdate(this);' class='flat' type='text' name='website' size='35' style='width:350px;' dir='ltr' value='".phpAds_htmlQuotes($affiliate['website'])."' tabindex='".($tabindex++)."'>";
echo "</td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
// Contact
echo "<tr><td width='30'> </td><td width='200'>".$strContact."</td><td>";
echo "<input onBlur='phpAds_formUpdate(this);' class='flat' type='text' name='contact' size='35' style='width:350px;' value='".phpAds_htmlQuotes($affiliate['contact'])."' tabindex='".($tabindex++)."'>";
echo "</td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
// Email
echo "<tr><td width='30'> </td><td width='200'>".$strEMail."</td><td>";
echo "<input onBlur='phpAds_formUpdate(this);' class='flat' type='text' name='email' size='35' style='width:350px;' value='".phpAds_htmlQuotes($affiliate['email'])."' tabindex='".($tabindex++)."'>";
echo "</td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
// Language
echo "<tr><td width='30'> </td><td width='200'>".$strLanguage."</td><td>";
echo "<select name='language' tabindex='".($tabindex++)."'>";
echo "<option value='' SELECTED>".$strDefault."</option>\n";
$languages = phpAds_AvailableLanguages();
while (list($k, $v) = each($languages))
{
if (isset($affiliate['language']) && $affiliate['language'] == $k)
echo "<option value='$k' selected>$v</option>\n";
else
echo "<option value='$k'>$v</option>\n";
}
echo "</select></td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
// Public?
echo "<tr><td width='30'> </td><td colspan='2'>";
echo "<input type='hidden' name='publiczones_old' value='".$affiliate['publiczones']."'>";
echo "<input type='checkbox' name='publiczones' value='t'".($affiliate['publiczones'] == 't' ? ' CHECKED' : '')." tabindex='".($tabindex++)."'> ";
echo $strMakePublisherPublic;
echo "</td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "</table>";
echo "<br><br>";
echo "<br><br>";
echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
echo "<tr><td height='25' colspan='3'><b>".$strLoginInformation."</b></td></tr>";
echo "<tr height='1'><td width='30'><img src='images/break.gif' height='1' width='30'></td>";
echo "<td width='200'><img src='images/break.gif' height='1' width='200'></td>";
echo "<td width='100%'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
// Error message?
if (isset($errormessage) && count($errormessage))
{
echo "<tr><td> </td><td height='10' colspan='2'>";
echo "<table cellpadding='0' cellspacing='0' border='0'><tr><td>";
echo "<img src='images/error.gif' align='absmiddle'> ";
while (list($k, $v) = each($errormessage))
echo "<font color='#AA0000'><b>".$v."</b></font><br>";
echo "</td></tr></table></td></tr><tr><td height='10' colspan='3'> </td></tr>";
echo "<tr><td><img src='images/spacer.gif' height='1' width='100%'></td>";
echo "<td colspan='2'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td></tr>";
}
// Username
echo "<tr><td width='30'> </td><td width='200'>".$strUsername."</td>";
if (phpAds_isUser(phpAds_Admin))
echo "<td width='370'><input onBlur='phpAds_formUpdate(this);' class='flat' type='text' name='username' size='25' value='".phpAds_htmlQuotes($affiliate['username'])."' tabindex='".($tabindex++)."'></td>";
else
echo "<td width='370'>".(isset($affiliate['username']) ? $affiliate['username'] : '');
echo "</tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
// Password
if (phpAds_isUser(phpAds_Admin))
{
echo "<tr><td width='30'> </td><td width='200'>".$strPassword."</td>";
echo "<td width='370'><input class='flat' type='password' name='password' size='25' value='".$affiliate['password']."' tabindex='".($tabindex++)."'></td>";
echo "</tr><tr><td height='10' colspan='3'> </td></tr>";
}
else
{
echo "<tr><td width='30'> </td><td width='200'>".$strOldPassword."</td><td width='100%'>";
echo "<input onBlur='phpAds_formUpdate(this);' class='flat' type='password' name='pwold' size='25' value='' tabindex='".($tabindex++)."'>";
echo "</td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
echo "<tr><td width='30'> </td><td width='200'>".$strNewPassword."</td><td width='100%'>";
echo "<input onBlur='phpAds_formUpdate(this);' class='flat' type='password' name='pw' size='25' value='' tabindex='".($tabindex++)."'>";
echo "</td></tr><tr><td><img src='images/spacer.gif' height='1' width='30'></td>";
echo "<td colspan='1'><img src='images/break-l.gif' height='1' width='200' vspace='6'></td><td><img src='images/spacer.gif' height='1' width='100%'></tr>";
echo "<tr><td width='30'> </td><td width='200'>".$strRepeatPassword."</td><td width='100%'>";
echo "<input onBlur='phpAds_formUpdate(this);' class='flat' type='password' name='pw2' size='25' value='' tabindex='".($tabindex++)."'>";
echo "</td></tr>";
}
// Permissions
if (phpAds_isUser(phpAds_Admin))
{
echo "<tr height='1'><td colspan='3' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "<tr><td width='30'> </td><td colspan='2'>";
echo "<input type='checkbox' name='affiliatepermissions[]' value='".phpAds_ModifyInfo."'".(phpAds_ModifyInfo & $affiliate['permissions'] ? ' CHECKED' : '')." tabindex='".($tabindex++)."'> ";
echo $strAllowAffiliateModifyInfo;
echo "</td></tr>";
echo "<tr><td width='30'> </td><td colspan='2'>";
echo "<input type='checkbox' name='affiliatepermissions[]' value='".phpAds_EditZone."'".(phpAds_EditZone & $affiliate['permissions'] ? ' CHECKED' : '')." tabindex='".($tabindex++)."'> ";
echo $strAllowAffiliateModifyZones;
echo "</td></tr>";
echo "<tr><td width='30'> </td><td colspan='2'>";
echo "<input type='checkbox' name='affiliatepermissions[]' value='".phpAds_LinkBanners."'".(phpAds_LinkBanners & $affiliate['permissions'] ? ' CHECKED' : '')." tabindex='".($tabindex++)."'> ";
echo $strAllowAffiliateLinkBanners;
echo "</td></tr>";
echo "<tr><td width='30'> </td><td colspan='2'>";
echo "<input type='checkbox' name='affiliatepermissions[]' value='".phpAds_AddZone."'".(phpAds_AddZone & $affiliate['permissions'] ? ' CHECKED' : '')." tabindex='".($tabindex++)."'> ";
echo $strAllowAffiliateAddZone;
echo "</td></tr>";
echo "<tr><td width='30'> </td><td colspan='2'>";
echo "<input type='checkbox' name='affiliatepermissions[]' value='".phpAds_DeleteZone."'".(phpAds_DeleteZone & $affiliate['permissions'] ? ' CHECKED' : '')." tabindex='".($tabindex++)."'> ";
echo $strAllowAffiliateDeleteZone;
echo "</td></tr>";
}
echo "<tr><td height='10' colspan='3'> </td></tr>";
echo "</table>";
echo "<br><br>";
echo "<input type='submit' name='submit' value='".(isset($affiliateid) && $affiliateid != '' ? $strSaveChanges : $strNext.' >')."' tabindex='".($tabindex++)."'>";
echo "</form>";
/*********************************************************/
/* Form requirements */
/*********************************************************/
// Get unique affiliate
$unique_names = array();
$res = phpAds_dbQuery("SELECT * FROM ".$phpAds_config['tbl_affiliates'].(isset($affiliateid) && $affiliateid ? " WHERE affiliateid != '".$affiliateid."'" : ''));
while ($row = phpAds_dbFetchArray($res))
$unique_names[] = $row['name'];
// Get unique username
$unique_users = array($phpAds_config['admin']);
$res = phpAds_dbQuery("SELECT * FROM ".$phpAds_config['tbl_affiliates']." WHERE username != ''".(isset($affiliateid) && $affiliateid ? " AND affiliateid != '".$affiliateid."'" : ''));
while ($row = phpAds_dbFetchArray($res))
$unique_users[] = $row['username'];
$res = phpAds_dbQuery("SELECT * FROM ".$phpAds_config['tbl_clients']." WHERE clientusername != '' AND parent IS NULL");
while ($row = phpAds_dbFetchArray($res))
$unique_users[] = $row['clientusername'];
?>
<script language='JavaScript'>
<!--
phpAds_formSetRequirements('contact', '<?php echo addslashes($strContact); ?>', true);
phpAds_formSetRequirements('website', '<?php echo addslashes($strWebsite); ?>', true, 'url');
phpAds_formSetRequirements('email', '<?php echo addslashes($strEMail); ?>', true, 'email');
<?php if (phpAds_isUser(phpAds_Admin)) { ?>
phpAds_formSetRequirements('name', '<?php echo addslashes($strName); ?>', true, 'unique');
phpAds_formSetRequirements('username', '<?php echo addslashes($strUsername); ?>', false, 'unique');
phpAds_formSetUnique('name', '|<?php echo addslashes(implode('|', $unique_names)); ?>|');
phpAds_formSetUnique('username', '|<?php echo addslashes(implode('|', $unique_users)); ?>|');
<?php } ?>
//-->
</script>
<?php
/*********************************************************/
/* HTML framework */
/*********************************************************/
phpAds_PageFooter();
?>
Other Ad Management Scripts:
