echo $row['ad_id'];
?>
</a></font></td>
<td><font face="Arial" size="2"><?php
$sql = "select * from banners where banner_id=" . $row['banner_id'];
$b_result = mysql_query($sql) or die(mysql_error() . $sql);
$b_row = mysql_fetch_array($b_result);
echo $b_row['name'];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[quantity];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo convert_to_default_currency_formatted($row[currency], $row[price]);
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[status];
?>
<br>
<?php
if ($row[status] == 'cancelled') {
$sql = "select * from transactions where type='CREDIT' and order_id=" . $row[order_id];
$r1 = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($r1) > 0) {
$refunded = true;
echo "(Refunded)";
} else {
$refunded = false;
function process_payment_return()
{
global $label;
if ($_REQUEST['order_id'] != '' && $_REQUEST['nhezk5'] != '') {
//print_r($_SESSION);
if ($_SESSION['MDS_ID'] == '') {
echo "Error: You must be logged in to view this page";
} else {
//require ("../users/header.php");
?>
<div style='background-color: #ffffff; border-color:#C0C0C0; border-style:solid;padding:10px'>
<p align="center"><center>
<?php
$sql = "SELECT * from orders where order_id='" . $_REQUEST['order_id'] . "' and user_id='" . $_SESSION['MDS_ID'] . "'";
$result = mysql_query($sql) or die(mysql_error() . $sql);
$order_row = mysql_fetch_array($result);
$check_amount = convert_to_currency($order_row['price'], $order_row['currency'], CHECK_CURRENCY);
$check_amount = format_currency($check_amount, CHECK_CURRENCY, true);
$label['payment_check_heading'] = str_replace("%INVOICE_AMOUNT%", $check_amount, $label['payment_check_heading']);
//$label['payment_check_note'] = str_replace ("%CONTACT_EMAIL%", SITE_CONTACT_EMAIL, $label['payment_check_note']);
//$label['payment_check_note'] = str_replace ("%INVOICE_CODE%", $_REQUEST['order_id'], $label['payment_check_note']);
if (get_default_currency() != CHECK_CURRENCY) {
echo convert_to_default_currency_formatted($order_row[currency], $order_row['price']) . " = " . $check_amount;
echo "<br>";
}
?>
<table width="70%"><tr><td>
<b><?php
echo $label['payment_check_heading'];
?>
</b><br>
<?php
if (CHECK_NAME != '') {
?>
<b><?php
echo $label['payment_check_payable'];
?>
</b><pre><?php
echo CHECK_PAYABLE;
?>
</pre><br>
<?php
}
?>
<?php
if (CHECK_ADDRESS != '') {
?>
<b><?php
echo $label['payment_check_address'];
?>
</b><pre><?php
echo CHECK_ADDRESS;
?>
</pre><br>
<?php
}
?>
<?php
/*if ( CHECK_ACCOUNT_NAME != '') { ?>
<b><?php echo $label['payment_check_currency'];?></b><pre><?php echo CHECK_CURRENCY; ?></pre><br>
<?php } */
?>
</td></tr>
</table>
</p>
</center>
</div>
<?php
}
}
}
function display_price_table($banner_id)
{
global $label;
if (banner_get_packages($banner_id)) {
return false;
// cannot have custom price zones, this banner has packages.
}
// get the default price
$sql = "select price_per_block as price, currency from banners where banner_id='{$banner_id}' ";
$result2 = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($result2);
$price = $row['price'];
$sql = "SELECT * FROM prices where banner_id='{$banner_id}' order by row_from";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
?>
<p>
<div class='fancy_heading' width="85%"><?php
echo $label['advertiser_pf_table'];
?>
</div>
<p>
<?php
echo $label['advertiser_pf_intro'];
?>
</p>
<table border="0" cellSpacing="1" cellPadding="3" bgColor="#d9d9d9" width="50%">
<tr >
<td><b><font face="Arial" size="2"><?php
echo $label['advertiser_pf_price'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['advertiser_pf_color'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['advertiser_pf_fromrow'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['advertiser_pf_torow'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['advertiser_pf_fromcol'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['advertiser_pf_tocol'];
?>
</font></b></td>
</tr>
<?php
while ($row = mysql_fetch_array($result)) {
?>
<tr bgcolor="#ffffff">
<td ><font face="Arial" size="2"><?php
if ($row['price'] == 0) {
echo $label['free'];
} else {
echo convert_to_default_currency_formatted($row['currency'], $row['price'], true);
}
?>
</font></td>
<td bgcolor="<?php
if ($row[color] == 'yellow') {
echo '#FFFF00';
} elseif ($row['color'] == 'cyan') {
echo '#00FFFF';
} elseif ($row[color] == 'magenta') {
echo '#FF00FF';
}
?>
"><font face="Arial" size="2" ><?php
echo $row['color'];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[row_from];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[row_to];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[col_from];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[col_to];
?>
</font></td>
</tr>
<?php
}
?>
</table>
</p>
<?php
}
}
function display_order($order_id, $BID)
{
global $label;
$order_id = addslashes($order_id);
$sql = "select * from banners where banner_id='{$BID}'";
$result = mysql_query($sql) or die(mysql_error() . $sql);
$b_row = mysql_fetch_array($result);
if (is_numeric($order_id)) {
$sql = "SELECT * from orders where order_id='" . $order_id . "' and banner_id='{$BID}'";
} else {
$sql = "SELECT * from temp_orders where session_id='" . $order_id . "' and banner_id='{$BID}'";
}
$result = mysql_query($sql) or die(mysql_error() . $sql);
$order_row = mysql_fetch_array($result);
?>
<table border="1" width="300">
<?php
if ($order_row['order_id'] != '') {
?>
<tr>
<td><b><?php
echo $label['advertiser_ord_order_id'];
?>
</b></td><td><?php
echo $order_row['order_id'];
?>
</td>
</tr>
<?php
}
?>
<tr>
<td><b><?php
echo $label['advertiser_ord_date'];
?>
</b></td><td><?php
echo $order_row[order_date];
?>
</td>
</tr>
<tr>
<td><b><?php
echo $label['advertiser_ord_name'];
?>
</b></td><td><?php
echo $b_row[name];
?>
</td>
</tr>
<tr>
<td><b><?php
echo $label['advertiser_ord_quantity'];
?>
</b></td><td><?php
echo $order_row[quantity];
?>
<?php
echo $label['advertiser_ord_pix'];
?>
</td>
</tr>
<td><b><?php
echo $label['advertiser_ord_expired'];
?>
</b></td><td><?php
if ($order_row[days_expire] == 0) {
echo $label['advertiser_ord_never'];
} else {
$label['advertiser_ord_days_exp'] = str_replace("%DAYS_EXPIRE%", $order_row[days_expire], $label['advertiser_ord_days_exp']);
echo $label['advertiser_ord_days_exp'];
}
?>
</td>
</tr>
<tr>
<td><b><?php
echo $label['advertiser_ord_price'];
?>
</b></td><td><?php
echo convert_to_default_currency_formatted($order_row[currency], $order_row[price]);
?>
</td>
</tr>
<?php
if ($order_row['order_id'] != '') {
?>
<tr>
<td><b><?php
echo $label['advertiser_ord_status'];
?>
</b></td><td><?php
echo $order_row[status];
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
echo $row[order_id];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $row[quantity];
?>
</font></td>
<td><font face="Arial" size="2"><?php
$sql = "select * from banners where banner_id=" . $row['banner_id'];
$b_result = mysql_query($sql) or die(mysql_error() . $sql);
$b_row = mysql_fetch_array($b_result);
echo $b_row['name'];
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo convert_to_default_currency_formatted($row['currency'], $row['price']);
?>
</font></td>
<td><font face="Arial" size="2"><?php
echo $label[$row['status']];
?>
<br><?php
if (USE_AJAX == 'SIMPLE') {
$order_page = 'order_pixels.php';
$temp_var = '&order_id=temp';
} else {
$order_page = 'select.php';
}
switch ($row['status']) {
case "new":
echo $label['adv_ord_inprogress'] . '<br>';
function display_package_options_table($banner_id, $selected = '', $selection_ability)
{
global $label;
$sql = "SELECT * FROM packages WHERE banner_id='{$banner_id}' ORDER BY price ASC ";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
?>
<div class='fancy_heading' width="85%"><?php
echo $label['advertiser_package_table'];
?>
</div>
<p>
<?php
if ($selection_ability) {
echo $label['advertiser_pa_intro_sel'];
} else {
echo $label['advertiser_pa_intro_show'];
}
?>
</p>
<table border="0" cellSpacing="1" cellPadding="3" bgColor="#d9d9d9" width="50%">
<tr>
<?php
if ($selection_ability) {
?>
<td><b><font face="Arial" size="2"><?php
echo $label['pack_head_select'];
?>
</font></b></td>
<?php
}
?>
<td><b><font face="Arial" size="2"><?php
echo $label['pack_head_price'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['pack_head_exp'];
?>
</font></b></td>
<td><b><font face="Arial" size="2"><?php
echo $label['pack_head_mo'];
?>
</font></b></td>
</tr>
<?php
while ($row = mysql_fetch_array($result)) {
if ($selected != '') {
if ($row['package_id'] == $selected) {
$sel = " checked ";
} else {
$sel = '';
}
} else {
// make sure the fisrt item is selected by default.
if ($first_sel == false) {
$sel = 'checked';
$first_sel = true;
} else {
$sel = '';
}
}
?>
<tr bgcolor="#ffffff">
<?php
if ($selection_ability) {
?>
<td><font face="Arial" size="2"><input <?php
echo $sel;
?>
type="radio" id="P<?php
echo $row['package_id'];
?>
" name="pack" value="<?php
echo $row['package_id'];
?>
"></font></td>
<?php
}
?>
<td><font face="Arial" size="2"><label for="P<?php
echo $row['package_id'];
?>
"><?php
if ($row['price'] == 0) {
echo $label['free'];
} else {
echo convert_to_default_currency_formatted($row['currency'], $row['price'], true);
echo " " . $label['pack_price_per100'];
}
?>
<?php
?>
</label></font></td>
<td><font face="Arial" size="2"><?php
if ($row['days_expire'] == '0') {
echo $label['pack_never'];
} else {
$str = str_replace('%DAYS_EXPIRE%', $row['days_expire'], $label['pack_expires_in']);
echo $str;
}
?>
</font></td>
<td><font face="Arial" size="2"><?php
if ($row['max_orders'] == '0') {
echo $label['pack_unlimited'];
} else {
echo $row['max_orders'];
}
?>
</font></td>
</tr>
<?php
}
?>
</table>
</p>
<?php
}
}
function process_payment_return()
{
global $label;
if ($_REQUEST['order_id'] != '' && $_REQUEST['nhezk5'] != '') {
//session_start();
//print_r($_SESSION);
if ($_SESSION['MDS_ID'] == '') {
echo "Error: You must be logged in to view this page";
} else {
?>
<div style='background-color: #ffffff; border-color:#C0C0C0; border-style:solid;padding:10px'>
<p align="center"><center>
<?php
$sql = "SELECT * from orders where order_id='" . $_REQUEST['order_id'] . "' and user_id='" . $_SESSION['MDS_ID'] . "'";
$result = mysql_query($sql) or die(mysql_error() . $sql);
$order_row = mysql_fetch_array($result);
$bank_amount = convert_to_currency($order_row['price'], $order_row['currency'], BANK_CURRENCY);
$bank_amount = format_currency($bank_amount, BANK_CURRENCY, true);
$label['payment_bank_heading'] = str_replace("%INVOICE_AMOUNT%", $bank_amount, $label['payment_bank_heading']);
$label['payment_bank_note'] = str_replace("%CONTACT_EMAIL%", SITE_CONTACT_EMAIL, $label['payment_bank_note']);
$label['payment_bank_note'] = str_replace("%INVOICE_CODE%", $_REQUEST['order_id'], $label['payment_bank_note']);
if (get_default_currency() != BANK_CURRENCY) {
echo convert_to_default_currency_formatted($order_row[currency], $order_row['price']) . " = " . $bank_amount;
echo "<br>";
}
?>
<table width="70%"><tr><td>
<b><?php
echo $label['payment_bank_heading'];
?>
</b><br>
<?php
if (BANK_NAME != '') {
?>
<b><?php
echo $label['payment_bank_name'];
?>
</b> <?php
echo BANK_NAME;
?>
<br>
<?php
}
?>
<?php
if (BANK_ADDRESS != '') {
?>
<b><?php
echo $label['payment_bank_addr'];
?>
</b> <?php
echo BANK_ADDRESS;
?>
<br>
<?php
}
?>
<?php
if (BANK_ACCOUNT_NAME != '') {
?>
<b><?php
echo $label['payment_bank_ac_name'];
?>
</b> <?php
echo BANK_ACCOUNT_NAME;
?>
<br>
<?php
}
?>
<?php
if (BANK_ACCOUNT_NUMBER != '') {
?>
<b><?php
echo $label['payment_bank_ac_number'];
?>
</b> <?php
echo BANK_ACCOUNT_NUMBER;
?>
<br>
<?php
}
?>
<?php
if (BANK_BRANCH_NUMBER != '') {
?>
<b><?php
echo $label['payment_bank_branch_number'];
?>
</b> <?php
echo BANK_BRANCH_NUMBER;
?>
<br>
<?php
}
?>
<?php
if (BANK_SWIFT != '') {
?>
<b><?php
echo $label['payment_bank_swift'];
?>
</b> <?php
echo BANK_SWIFT;
?>
<br>
<?php
}
?>
<?php
echo $label['payment_bank_note'];
?>
</td></tr>
</table>
</p>
</center>
</div>
<?php
}
}
}
