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 } } }