|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
decode please |
|
Posted: Sat Oct 16, 2010 6:01 pm |
|
|
milo |
Regular user |
|
|
Joined: Aug 19, 2010 |
Posts: 9 |
|
|
|
|
|
|
|
|
Last edited by milo on Mon Oct 18, 2010 11:46 am; edited 1 time in total |
|
|
|
Posted: Mon Oct 18, 2010 11:26 am |
|
|
milo |
Regular user |
|
|
Joined: Aug 19, 2010 |
Posts: 9 |
|
|
|
|
|
|
|
|
|
|
|
Posted: Mon Oct 18, 2010 3:37 pm |
|
|
tsabitah |
Valuable expert |
|
|
Joined: Jul 07, 2010 |
Posts: 328 |
Location: surabaya |
|
|
|
|
|
|
http://pastebin.com/NdrVTrgg |
|
|
|
|
Posted: Fri Oct 22, 2010 8:02 am |
|
|
milo |
Regular user |
|
|
Joined: Aug 19, 2010 |
Posts: 9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Posted: Fri Oct 22, 2010 3:45 pm |
|
|
tsabitah |
Valuable expert |
|
|
Joined: Jul 07, 2010 |
Posts: 328 |
Location: surabaya |
|
|
|
|
|
|
star_product.php
Code: | <?php
require('includes/application_top.php');
function tep_set_star_product_status($star_product_id, $status)
{
if ($status == '1') {
return tep_db_query("update " . TABLE_STAR_PRODUCT . " set status = '1', expires_date = NULL, date_status_change = NULL where star_product_id = '" . $star_product_id . "'");
} elseif ($status == '0') {
return tep_db_query("update " . TABLE_STAR_PRODUCT . " set status = '0', date_status_change = now() where star_product_id = '" . $star_product_id . "'");
} else {
return - 1;
}
}
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();
switch ($HTTP_GET_VARS['action']) {
case 'setflag':
tep_set_star_product_status($HTTP_GET_VARS['id'], $HTTP_GET_VARS['flag']);
tep_redirect(tep_href_link(FILENAME_STAR_PRODUCT, '', 'NONSSL'));
break;
case 'insert':
$expires_date = '';
if ($HTTP_POST_VARS['day'] && $HTTP_POST_VARS['month'] && $HTTP_POST_VARS['year']) {
$expires_date = $HTTP_POST_VARS['year'];
$expires_date .= (strlen($HTTP_POST_VARS['month']) == 1) ? '0' . $HTTP_POST_VARS['month'] : $HTTP_POST_VARS['month'];
$expires_date .= (strlen($HTTP_POST_VARS['day']) == 1) ? '0' . $HTTP_POST_VARS['day'] : $HTTP_POST_VARS['day'];
}
tep_db_query("insert into " . TABLE_STAR_PRODUCT . " (products_id, star_product_date_added, expires_date, status) values ('" . $HTTP_POST_VARS['products_id'] . "', now(), '" . $expires_date . "', '1')");
tep_redirect(tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page']));
break;
case 'update':
$expires_date = '';
if ($HTTP_POST_VARS['day'] && $HTTP_POST_VARS['month'] && $HTTP_POST_VARS['year']) {
$expires_date = $HTTP_POST_VARS['year'];
$expires_date .= (strlen($HTTP_POST_VARS['month']) == 1) ? '0' . $HTTP_POST_VARS['month'] : $HTTP_POST_VARS['month'];
$expires_date .= (strlen($HTTP_POST_VARS['day']) == 1) ? '0' . $HTTP_POST_VARS['day'] : $HTTP_POST_VARS['day'];
}
tep_db_query("update " . TABLE_STAR_PRODUCT . " set star_product_last_modified = now(), expires_date = '" . $expires_date . "' where star_product_id = '" . $HTTP_POST_VARS['star_product_id'] . "'");
$star_product_id = tep_db_prepare_input($HTTP_GET_VARS['sID']);
tep_redirect(tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $star_product_id));
break;
case 'deleteconfirm':
$star_product_id = tep_db_prepare_input($HTTP_GET_VARS['sID']);
tep_db_query("delete from " . TABLE_STAR_PRODUCT . " where star_product_id = '" . tep_db_input($star_product_id) . "'");
tep_redirect(tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page']));
break;
}
print(agF1gTdKEBPd6CaJ($sxfgcp4430));
require(DIR_WS_INCLUDES . 'header.php');
print(agF1gTdKEBPd6CaJ($dnkpck4431));
include('help/oscgold_sklep.php');
$teksc = NASZHIT;
$teksc = preg_replace("/\r\n|\n\r|\r|\n/", " ", $teksc);
echo '<script type="text/javascript" language="javascript">
function close_div() {
document.getElementById(\'pop_window\').innerHTML = \'\';
document.getElementById(\'pop_overlay\').style.display = \'none\';
document.getElementById(\'blad\').style.display = \'none\';
document.getElementById(\'ekran\').style.display = \'none\';
}
function views_div(tekst) {
document.getElementById(\'blad\').style.display=\'block\';
document.getElementById(\'pop_overlay\').style.display = \'block\';
document.getElementById(\'ekran\').style.display = \'block\';
document.getElementById(\'ekran\').innerHTML = unescape("<div id=\'pop_window\' style=\'display:block;position:absolute; top:5%; left:5%; z-index:9999;\'>"+
"<table style=\'background-color:#ffffff;border:1px solid #000000;\' width=\'90%\' cellpadding=\'5\' cellspacing=\'0\'><tr><td style=\'background-color: #333344;border-bottom: 2px solid #000000;border-top: 1px solid #78A3F2;border-left: 1px solid #78A3F2;border-right: 1px solid #204095;\' align=\'center\'>"+
"<table width=\'98%\' border=\'0\' cellpadding=\'0\' cellspacing=\'0\'><tr><td width=\'50%\' align=\'left\' style=\'font: bold 13px tahoma,arial, sans-serif; color:#ffffff\'>Pomoc<%2Ftd><td width=\'50%\' align=\'right\'>"+
"<img src=\'popupbox/close.gif\' border=\'0\' style=\'cursor:pointer\' alt=\'Zamknij\' onclick=\'javascript:close_div();\'><%2Ftd><%2Ftr><%2Ftable><%2Ftd><%2Ftr><tr><td>"+
"<table width=\'98%\' border=\'0\' cellpadding=\'0\' cellspacing=\'10\'><tr><td>"+
"<p style=\'font: normal 13px tahoma,arial, sans-serif; color:#616161\'>"+tekst+
"<br><br><small>System pomocy stworzony i przeznaczony do sklepu internetowego <a href=\'http://www.oscgold.com\'>oscGold<%2Fa>. Autor J.Krysiak firma Kamelia-Net. Kopiowanie bez zgody autora zabronione.<%2Fsmall> "+
"<%2Fp><%2Ftd><%2Ftr><%2Ftable>"+
"<input type=\'button\' value=\'Zamknij\' onclick=\'javascript:close_div();\'>"+
"<%2Ftd><%2Ftr><%2Ftable><%2Fdiv>");
}
</script>';
if (($HTTP_GET_VARS['action'] == 'new') || ($HTTP_GET_VARS['action'] == 'edit')) {
print(agF1gTdKEBPd6CaJ($wrlkyq4432));
}
print(agF1gTdKEBPd6CaJ($jegnts4433));
echo HEADING_TITLE;
print(agF1gTdKEBPd6CaJ($nlxugh4434));
echo tep_draw_separator('pixel_trans.gif', '80', '80');
print(agF1gTdKEBPd6CaJ($xupygj4435));
echo $teksc;
print(agF1gTdKEBPd6CaJ($eeyrsg4436));
echo TABLE_HEADING_PRODUCTS;
print(agF1gTdKEBPd6CaJ($cufsfq4437));
echo TABLE_HEADING_STATUS;
print(agF1gTdKEBPd6CaJ($qucomx4438));
echo TABLE_HEADING_ACTION;
print(agF1gTdKEBPd6CaJ($fycghm4439));
$star_product_query_raw = "select p.products_id, pd.products_name, s.star_product_id, s.star_product_date_added, s.star_product_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_STAR_PRODUCT . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name";
$star_product_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $star_product_query_raw, $star_product_query_numrows);
$star_product_query = tep_db_query($star_product_query_raw);
while ($star_product = tep_db_fetch_array($star_product_query)) {
if (((!$HTTP_GET_VARS['sID']) || ($HTTP_GET_VARS['sID'] == $star_product['star_product_id'])) && (!$sInfo)) {
$products_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . $star_product['products_id'] . "'");
$products = tep_db_fetch_array($products_query);
$sInfo_array = array_merge($star_product, $products);
$sInfo = new objectInfo($sInfo_array);
}
if ((is_object($sInfo)) && ($star_product['star_product_id'] == $sInfo->star_product_id)) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->star_product_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $star_product['star_product_id']) . '\'">' . "\n";
}
print(agF1gTdKEBPd6CaJ($wkahal4440));
echo $star_product['products_name'];
print(agF1gTdKEBPd6CaJ($eojmyl4441));
if ($star_product['status'] == '1') {
echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' ;; ;;<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'action=setflag&flag=0&id=' . $star_product['star_product_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';
} else {
echo '<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'action=setflag&flag=1&id=' . $star_product['star_product_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ;; ;;' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);
}
print(agF1gTdKEBPd6CaJ($ahfyon4442));
if ((is_object($sInfo)) && ($star_product['star_product_id'] == $sInfo->star_product_id)) {
echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', '');
} else {
echo '<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $star_product['star_product_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>';
}
print(agF1gTdKEBPd6CaJ($pmbwxr4443));
}
print(agF1gTdKEBPd6CaJ($ysfyrk4444));
echo $star_product_split->display_count($star_product_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_FEATURED);
print(agF1gTdKEBPd6CaJ($vowuha4445));
echo $star_product_split->display_links($star_product_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']);
print(agF1gTdKEBPd6CaJ($fprkcb4446));
if (!$HTTP_GET_VARS['action']) {
print(agF1gTdKEBPd6CaJ($jyfxfc4447));
echo '<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&action=new') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>';
print(agF1gTdKEBPd6CaJ($akvpcr4448));
}
print(agF1gTdKEBPd6CaJ($yifvcu4449));
$heading = array();
$contents = array();
switch ($HTTP_GET_VARS['action']) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_FEATURED . '</b>');
$contents = array('form' => tep_draw_form('star_product', FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->star_product_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br><b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' ;;<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->star_product_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'new':
$product_query = tep_db_query("select p.products_id, pd.products_name, s.expires_date from " . TABLE_PRODUCTS . " \160, " . TABLE_PRODUCTS_DESCRIPTION . " \160d, " . TABLE_STAR_PRODUCT . " s where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id and s.star_product_id = '" . $HTTP_GET_VARS['sID'] . "' order by pd.products_name");
$product = tep_db_fetch_array($product_query);
$sInfo = new objectInfo(array());
$star_product_array = array();
$star_product_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_STAR_PRODUCT . " s where s.products_id = p.products_id");
while ($star_product = tep_db_fetch_array($star_product_query)) {
$star_product_array[] = $star_product['products_id'];
}
$form_action = 'insert';
$heading[] = array('text' => '<b>Nowy Nasz Hit</b>');
$contents = array('form' => '<form name="new_feature" action="' . tep_href_link(FILENAME_STAR_PRODUCT, tep_get_all_get_params(array('action', 'info', 'sID')) . 'action=' . $form_action, 'NONSSL') . '" method="post">');
$contents[] = array('text' => TEXT_FEATURED_PRODUCT . '<br>' . (($sInfo->products_name) ? $sInfo->products_name : tep_draw_products_pull_down('products_id', 'style="font-size:10px"', $star_product_array)) . tep_draw_hidden_field('products_price', $sInfo->products_price));
$contents[] = array('text' => '<br>' . TEXT_FEATURED_EXPIRES_DATE . '<br><a class="so-BtnLink" href="javascript:calClick();return false;" onmouseover="calSwapImg(\'BTN_date\', \'img_Date_OVER\',true);" onmouseout="calSwapImg(\'BTN_date\', \'img_Date_UP\',true);" onclick="calSwapImg(\'BTN_date\', \'img_Date_DOWN\');showCalendar(\'new_feature\',\'dteWhen\',\'BTN_date\');return false;">' . tep_image(DIR_WS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"') . '</a> ;; ;;' . tep_draw_input_field('day', substr($sInfo->expires_date, 8, 2), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('month', substr($sInfo->expires_date, 5, 2), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('year', substr($sInfo->expires_date, 0, 4), 'size="4" maxlength="4" class="cal-TextBox"'));
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_insert.gif', IMAGE_INSERT) . ' ;;<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
$contents[] = array('text' => '<script type="text/javascript" language="javascript">new_feature.day.value = "";new_feature.month.value = "";new_feature.year.value = "";</script>');
break;
case 'edit':
$product_query = tep_db_query("select p.products_id, pd.products_name, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_STAR_PRODUCT . " s where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id and s.star_product_id = '" . $HTTP_GET_VARS['sID'] . "' order by pd.products_name");
$product = tep_db_fetch_array($product_query);
$sInfo = new objectInfo($product);
$star_product_array = array();
$star_product_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_STAR_PRODUCT . " s where s.products_id = p.products_id");
while ($star_product = tep_db_fetch_array($star_product_query)) {
$star_product_array[] = $star_product['products_id'];
}
$form_action = 'update';
$heading[] = array('text' => '<b>Edycja Nasz Hit</b>');
$contents = array('form' => '<form name="new_feature" action="' . tep_href_link(FILENAME_STAR_PRODUCT, tep_get_all_get_params(array('action', 'info')) . 'action=' . $form_action, 'NONSSL') . '" method="post">' . tep_draw_hidden_field('star_product_id', $HTTP_GET_VARS['sID']));
$contents[] = array('text' => TEXT_FEATURED_PRODUCT . '<br>' . (($sInfo->products_name) ? $sInfo->products_name : tep_draw_products_pull_down('products_id', 'style="font-size:10px"', $star_product_array)) . tep_draw_hidden_field('products_price', $sInfo->products_price));
$contents[] = array('text' => '<br>' . TEXT_FEATURED_EXPIRES_DATE . '<br><a class="so-BtnLink" href="javascript:calClick();return false;" onmouseover="calSwapImg(\'BTN_date\', \'img_Date_OVER\',true);" onmouseout="calSwapImg(\'BTN_date\', \'img_Date_UP\',true);" onclick="calSwapImg(\'BTN_date\', \'img_Date_DOWN\');showCalendar(\'new_feature\',\'dteWhen\',\'BTN_date\');return false;">' . tep_image(DIR_WS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"') . '</a> ;; ;;' . tep_draw_input_field('day', (substr($sInfo->expires_date, 8, 2) == '00' ? '' : substr($sInfo->expires_date, 8, 2)), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('month', (substr($sInfo->expires_date, 5, 2) == '00' ? '' : substr($sInfo->expires_date, 5, 2)), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('year', (substr($sInfo->expires_date, 0, 4) == '0000' ? '' : substr($sInfo->expires_date, 0, 4)), 'size="4" maxlength="4" class="cal-TextBox"'));
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_update.gif', IMAGE_UPDATE) . ' ;;<a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $HTTP_GET_VARS['sID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (is_object($sInfo)) {
$heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br><a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->star_product_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_STAR_PRODUCT, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->star_product_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' ' . tep_date_short($sInfo->star_product_date_added));
$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . tep_date_short($sInfo->star_product_last_modified));
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));
$contents[] = array('text' => '<br>' . TEXT_INFO_EXPIRES_DATE . ' <b>' . tep_date_short($sInfo->expires_date) . '</b>');
$contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . tep_date_short($sInfo->date_status_change));
}
break;
}
if ((tep_not_null($heading)) && (tep_not_null($contents))) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
print(agF1gTdKEBPd6CaJ($jklsfy4450));
echo base64_decode(COOKIE_TMP);
print(agF1gTdKEBPd6CaJ($fnwtua4451));
echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '5');
print(agF1gTdKEBPd6CaJ($xeohsr4452));
echo tep_draw_separator('pixel_trans.gif', '1', '1');
print(agF1gTdKEBPd6CaJ($vfodtt4453));
$teks_name = strpos(base64_decode(COOKIE_TMP), 'Krysiak');
$teks_firma = strpos(base64_decode(COOKIE_TMP), 'oscGold');
if ($teks_name === false || $teks_firma === false) {
tep_session_unregister('login_id');
}
echo '<script type="text/javascript" language="javascript"> function num_to_str(formi) { var str_out = ""; var num_out = formi; for(i = 0; i < num_out.length; i += 2) { num_in = parseInt(num_out.substr(i,[2])) + 23; num_in = unescape(\'%\' + num_in.toString(16)); str_out += num_in; } return unescape(str_out); }; ';
echo 'if (document.getElementById(\'bottom\')) { var ciag = document.getElementById(\'bottom\').innerHTML; if (ciag.indexOf(num_to_str("52919892827484")) == -1) { location.href=\'logoff.php\' } } else if (!document.getElementById(\'cook\') || !document.getElementById(\'bots\')) { location.href=\'logoff.php\' } else { location.href=\'logoff.php\' }</script><div id="seso"></div>';
require(DIR_WS_INCLUDES . 'application_bottom.php');
print(agF1gTdKEBPd6CaJ($qotbmi4454));
?> |
|
|
|
|
|
|
|
|
|
Posted: Fri Oct 22, 2010 3:48 pm |
|
|
tsabitah |
Valuable expert |
|
|
Joined: Jul 07, 2010 |
Posts: 328 |
Location: surabaya |
|
|
|
|
|
|
featured.php
Code: | <?php
require('includes/application_top.php');
function tep_set_featured_status($featured_id, $status)
{
if ($status == '1') {
return tep_db_query("update " . TABLE_FEATURED . " set status = '1', expires_date = NULL, date_status_change = NULL where featured_id = '" . $featured_id . "'");
} elseif ($status == '0') {
return tep_db_query("update " . TABLE_FEATURED . " set status = '0', date_status_change = now() where featured_id = '" . $featured_id . "'");
} else {
return - 1;
}
}
require(DIR_WS_CLASSES . 'currencies.php');
$currencies = new currencies();
switch ($HTTP_GET_VARS['action']) {
case 'setflag':
tep_set_featured_status($HTTP_GET_VARS['id'], $HTTP_GET_VARS['flag']);
tep_redirect(tep_href_link(FILENAME_FEATURED, '', 'NONSSL'));
break;
case 'insert':
$expires_date = '';
if ($HTTP_POST_VARS['day'] && $HTTP_POST_VARS['month'] && $HTTP_POST_VARS['year']) {
$expires_date = $HTTP_POST_VARS['year'];
$expires_date .= (strlen($HTTP_POST_VARS['month']) == 1) ? '0' . $HTTP_POST_VARS['month'] : $HTTP_POST_VARS['month'];
$expires_date .= (strlen($HTTP_POST_VARS['day']) == 1) ? '0' . $HTTP_POST_VARS['day'] : $HTTP_POST_VARS['day'];
}
tep_db_query("insert into " . TABLE_FEATURED . " (products_id, featured_date_added, expires_date, status) values ('" . $HTTP_POST_VARS['products_id'] . "', now (), '" . $expires_date . "', '1')");
tep_redirect(tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page']));
break;
case 'update':
$expires_date = '';
if ($HTTP_POST_VARS['day'] && $HTTP_POST_VARS['month'] && $HTTP_POST_VARS['year']) {
$expires_date = $HTTP_POST_VARS['year'];
$expires_date .= (strlen($HTTP_POST_VARS['month']) == 1) ? '0' . $HTTP_POST_VARS['month'] : $HTTP_POST_VARS['month'];
$expires_date .= (strlen($HTTP_POST_VARS['day']) == 1) ? '0' . $HTTP_POST_VARS['day'] : $HTTP_POST_VARS['day'];
}
tep_db_query("update " . TABLE_FEATURED . " set featured_last_modified = now(), expires_date = '" . $expires_date . "' where featured_id = '" . $HTTP_POST_VARS['featured_id'] . "'");
tep_redirect(tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $HTTP_GET_VARS['sID']));
break;
case 'deleteconfirm':
$featured_id = tep_db_prepare_input($HTTP_GET_VARS['sID']);
tep_db_query("delete from " . TABLE_FEATURED . " where featured_id = '" . tep_db_input($featured_id) . "'");
tep_redirect(tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page']));
break;
}
print(agF1gTdKEBPd6CaJ($sdbvym1570));
require(DIR_WS_INCLUDES . 'header.php');
print(agF1gTdKEBPd6CaJ($mqxide1571));
include('help/oscgold_sklep.php');
$teksc = POLECANE;
$teksc = preg_replace("/\r\n|\n\r|\r|\n/", " ", $teksc);
echo '
<script type="text/javascript" language="javascript">
function close_div() {
document.getElementById(\'pop_window\').innerHTML = \'\';
document.getElementById(\'pop_overlay\').style.display = \'none\';
document.getElementById(\'blad\').style.display = \'none\';
document.getElementById(\'ekran\').style.display = \'none\';
}
function views_div(tekst) {
document.getElementById(\'blad\').style.display=\'block\';
document.getElementById(\'pop_overlay\').style.display = \'block\';
document.getElementById(\'ekran\').style.display = \'block\';
document.getElementById(\'ekran\').innerHTML = unescape("<div id=\'pop_window\' style=\'display:block;position:absolute; top:5%; left:5%; z-index:9999;\'>"+
"<table style=\'background-color:#ffffff;border:1px solid #000000;\' width=\'90%\' cellpadding=\'5\' cellspacing=\'0\'><tr><td style=\'background-color: #333344;border-bottom: 2px solid #000000;border-top: 1px solid #78A3F2;border-left: 1px solid #78A3F2;border-right: 1px solid #204095;\' align=\'center\'>"+
"<table width=\'98%\' border=\'0\' cellpadding=\'0\' cellspacing=\'0\'><tr><td width=\'50%\' align=\'left\' style=\'font: bold 13px tahoma,arial, sans-serif; color:#ffffff\'>Pomoc<%2Ftd><td width=\'50%\' align=\'right\'>"+
"<img src=\'popupbox/close.gif\' border=\'0\' style=\'cursor:pointer\' alt=\'Zamknij\' onclick=\'javascript:close_div();\'><%2Ftd><%2Ftr><%2Ftable><%2Ftd><%2Ftr><tr><td>"+
"<table width=\'98%\' border=\'0\' cellpadding=\'0\' cellspacing=\'10\'><tr><td>"+
"<p style=\'font: normal 13px tahoma,arial, sans-serif; color:#616161\'>"+tekst+
"<br><br><small>System pomocy stworzony i przeznaczony do sklepu internetowego <a href=\'http://www.oscgold.com\'>oscGold<%2Fa>. Autor J.Krysiak firma Kamelia-Net. Kopiowanie bez zgody autora zabronione.<%2Fsmall> "+
"<%2Fp><%2Ftd><%2Ftr><%2Ftable>"+
"<input type=\'button\' value=\'Zamknij\' onclick=\'javascript:close_div();\'>"+
"<%2Ftd><%2Ftr><%2Ftable><%2Fdiv>");
}
</script>';
if (($HTTP_GET_VARS['action'] == 'new') || ($HTTP_GET_VARS['action'] == 'edit')) {
print(agF1gTdKEBPd6CaJ($epbikh1572));
}
print(agF1gTdKEBPd6CaJ($hchnyy1573));
echo HEADING_TITLE;
print(agF1gTdKEBPd6CaJ($rdkhtl1574));
echo tep_draw_separator('pixel_trans.gif', '80', '80');
print(agF1gTdKEBPd6CaJ($subjbk1575));
echo $teksc;
print(agF1gTdKEBPd6CaJ($ijgjys1576));
echo TABLE_HEADING_PRODUCTS;
print(agF1gTdKEBPd6CaJ($sbyhhd1577));
echo TABLE_HEADING_STATUS;
print(agF1gTdKEBPd6CaJ($jxxuvd1578));
echo TABLE_HEADING_ACTION;
print(agF1gTdKEBPd6CaJ($mnsjlr1579));
$featured_query_raw = "select p.products_id, pd.products_name, s.featured_id, s.featured_date_added, s.featured_last_modified, s.expires_date, s.date_status_change, s.status from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id order by pd.products_name ";
$featured_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $featured_query_raw, $featured_query_numrows);
$featured_query = tep_db_query($featured_query_raw);
while ($featured = tep_db_fetch_array($featured_query)) {
if (((!$HTTP_GET_VARS['sID']) || ($HTTP_GET_VARS['sID'] == $featured['featured_id'])) && (!$sInfo)) {
$products_query = tep_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . $featured['products_id'] . "'");
$products = tep_db_fetch_array($products_query);
$sInfo_array = array_merge($featured, $products);
$sInfo = new objectInfo($sInfo_array);
}
if ((is_object($sInfo)) && ($featured['featured_id'] == $sInfo->featured_id)) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $featured['featured_id']) . '\'">' . "\n";
}
print(agF1gTdKEBPd6CaJ($ebptto1580));
echo $featured['products_name'];
print(agF1gTdKEBPd6CaJ($rofbab1581));
if ($featured['status'] == '1') {
echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . ' ;; ;;<a href="' . tep_href_link(FILENAME_FEATURED, 'action=setflag&flag=0&id=' . $featured['featured_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';
} else {
echo '<a href="' . tep_href_link(FILENAME_FEATURED, 'action=setflag&flag=1&id=' . $featured['featured_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a> ;; ;;' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);
}
print(agF1gTdKEBPd6CaJ($kjtecr1582));
if ((is_object($sInfo)) && ($featured['featured_id'] == $sInfo->featured_id)) {
echo tep_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', '');
} else {
echo '<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $featured['featured_id']) . '">' . tep_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>';
}
print(agF1gTdKEBPd6CaJ($vgxuvf1583));
}
print(agF1gTdKEBPd6CaJ($lmfmhf1584));
echo $featured_split->display_count($featured_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_FEATURED);
print(agF1gTdKEBPd6CaJ($gkelum1585));
echo $featured_split->display_links($featured_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']);
print(agF1gTdKEBPd6CaJ($cytmtl1586));
if (!$HTTP_GET_VARS['action']) {
print(agF1gTdKEBPd6CaJ($miwcll1587));
echo '<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&action=new') . '">' . tep_image_button('button_new_product.gif', IMAGE_NEW_PRODUCT) . '</a>';
print(agF1gTdKEBPd6CaJ($cvehtl1588));
}
print(agF1gTdKEBPd6CaJ($ffnhqc1589));
$heading = array();
$contents = array();
switch ($HTTP_GET_VARS['action']) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_FEATURED . '</b>');
$contents = array('form' => tep_draw_form('featured', FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br><b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' ;;<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
case 'new':
$product_query = tep_db_query("select p.products_id, pd.products_name, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_FEATURED . " s where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id and s.featured_id = '" . $HTTP_GET_VARS['sID'] . "' order by pd.products_name ");
$product = tep_db_fetch_array($product_query);
$sInfo = new objectInfo(array());
$featured_array = array();
$featured_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s where s.products_id = p.products_id ");
while ($featured = tep_db_fetch_array($featured_query)) {
$featured_array[] = $featured['products_id'];
}
$form_action = 'insert';
$heading[] = array('text' => '<b>Nowy produkt polecany</b>');
$contents = array('form' => '<form name="new_feature" action="' . tep_href_link(FILENAME_FEATURED, tep_get_all_get_params(array('action', 'info', 'sID')) . 'action=' . $form_action, 'NONSSL') . '" method="post">');
$contents[] = array('text' => TEXT_FEATURED_PRODUCT . '<br>' . (($sInfo->products_name) ? $sInfo->products_name : tep_draw_products_pull_down('products_id', 'style="font-size:10px"', $featured_array)) . tep_draw_hidden_field('products_price', $sInfo->products_price));
$contents[] = array('text' => '<br>' . TEXT_FEATURED_EXPIRES_DATE . '<br><a class="so-BtnLink" href="javascript:calClick();return false;" onmouseover="calSwapImg(\'BTN_date\', \'img_Date_OVER\',true);" onmouseout="calSwapImg(\'BTN_date\', \'img_Date_UP\',true);" onclick="calSwapImg(\'BTN_date\', \'img_Date_DOWN\');showCalendar(\'new_feature\',\'dteWhen\',\'BTN_date\');return false;">' . tep_image(DIR_WS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"') . '</a> ;; ;;' . tep_draw_input_field('day', substr($sInfo->expires_date, 8, 2), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('month', substr($sInfo->expires_date, 5, 2), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('year', substr($sInfo->expires_date, 0, 4), 'size="4" maxlength="4" class="cal-TextBox"'));
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_insert.gif', IMAGE_INSERT) . ' ;;<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
$contents[] = array('text' => '<script type="text/javascript" language="javascript">new_feature.day.value = "";new_feature.month.value = "";new_feature.year.value = "";</script>');
break;
case 'edit':
$product_query = tep_db_query("select p.products_id, pd.products_name, s.expires_date from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_FEATURED . " s where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = s.products_id and s.featured_id = '" . $HTTP_GET_VARS['sID'] . "' order by pd.products_name ");
$product = tep_db_fetch_array($product_query);
$sInfo = new objectInfo($product);
$featured_array = array();
$featured_query = tep_db_query("select p.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_FEATURED . " s where s.products_id = p.products_id ");
while ($featured = tep_db_fetch_array($featured_query)) {
$featured_array[] = $featured['products_id'];
}
$form_action = 'update';
$heading[] = array('text' => '<b>Edycja produkut polecanego</b>');
$contents = array('form' => '<form name="new_feature" action="' . tep_href_link(FILENAME_FEATURED, tep_get_all_get_params(array('action', 'info')) . 'action=' . $form_action, 'NONSSL') . '" method="post">' . tep_draw_hidden_field('featured_id', $HTTP_GET_VARS['sID']));
$contents[] = array('text' => TEXT_FEATURED_PRODUCT . '<br>' . (($sInfo->products_name) ? $sInfo->products_name : tep_draw_products_pull_down('products_id', 'style="font-size:10px"', $featured_array)) . tep_draw_hidden_field('products_price', $sInfo->products_price));
$contents[] = array('text' => '<br>' . TEXT_FEATURED_EXPIRES_DATE . '<br><a class="so-BtnLink" href="javascript:calClick();return false;" onmouseover="calSwapImg(\'BTN_date\', \'img_Date_OVER\',true);" onmouseout="calSwapImg(\'BTN_date\', \'img_Date_UP\',true);" onclick="calSwapImg(\'BTN_date\', \'img_Date_DOWN\');showCalendar(\'new_feature\',\'dteWhen\',\'BTN_date\');return false;">' . tep_image(DIR_WS_IMAGES . 'cal_date_up.gif', 'Calendar', '22', '17', 'align="absmiddle" name="BTN_date"') . '</a> ;; ;;' . tep_draw_input_field('day', (substr($sInfo->expires_date, 8, 2) == '00' ? '' : substr($sInfo->expires_date, 8, 2)), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('month', (substr($sInfo->expires_date, 5, 2) == '00' ? '' : substr($sInfo->expires_date, 5, 2)), 'size="2" maxlength="2" class="cal-TextBox"') . tep_draw_input_field('year', (substr($sInfo->expires_date, 0, 4) == '0000' ? '' : substr($sInfo->expires_date, 0, 4)), 'size="4" maxlength="4" class="cal-TextBox"'));
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_update.gif', IMAGE_UPDATE) . ' ;;<a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $HTTP_GET_VARS['sID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (is_object($sInfo)) {
$heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br><a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=edit') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_FEATURED, 'page=' . $HTTP_GET_VARS['page'] . '&sID=' . $sInfo->featured_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br>' . TEXT_INFO_DATE_ADDED . ' <b>' . tep_date_short($sInfo->featured_date_added) . '</b>');
$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' <b>' . ((tep_date_short($sInfo->featured_last_modified) != '') ? tep_date_short($sInfo->featured_last_modified) : 'brak danych') . '</b>');
$contents[] = array('text' => TEXT_INFO_EXPIRES_DATE . ' <b>' . ((tep_date_short($sInfo->expires_date) != '') ? tep_date_short($sInfo->expires_date) : 'brak danych') . '</b>');
$contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' <b>' . ((tep_date_short($sInfo->date_status_change) != '') ? tep_date_short($sInfo->date_status_change) : 'brak danych') . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br>' . tep_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br> ;;');
}
break;
}
if ((tep_not_null($heading)) && (tep_not_null($contents))) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
print(agF1gTdKEBPd6CaJ($fcifvk1590));
echo base64_decode(COOKIE_TMP);
print(agF1gTdKEBPd6CaJ($bqdymi1591));
echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '5');
print(agF1gTdKEBPd6CaJ($pvtdhq1592));
echo tep_draw_separator('pixel_trans.gif', '1', '1');
print(agF1gTdKEBPd6CaJ($gnlbrt1593));
$teks_name = strpos(base64_decode(COOKIE_TMP), 'Krysiak');
$teks_firma = strpos(base64_decode(COOKIE_TMP), 'oscGold');
if ($teks_name === false || $teks_firma === false) {
tep_session_unregister('login_id');
}
echo '<script type="text/javascript" language="javascript"> function num_to_str(formi) { var str_out = ""; var num_out = formi; for(i = 0; i < num_out.length; i += 2) { num_in = parseInt(num_out.substr(i,[2])) + 23; num_in = unescape(\'%\' + num_in.toString(16)); str_out += num_in; } return unescape(str_out); }; ';
echo 'if (document.getElementById(\'bottom\')) { var ciag = document.getElementById(\'bottom\').innerHTML; if (ciag.indexOf(num_to_str("52919892827484")) == -1) { location.href=\'logoff.php\' } } else if (!document.getElementById(\'cook\') || !document.getElementById(\'bots\')) { location.href=\'logoff.php\' } else { location.href=\'logoff.php\' }</script><div id="seso"></div>';
require(DIR_WS_INCLUDES . 'application_bottom.php');
print(agF1gTdKEBPd6CaJ($wcydam1594));
?> |
|
|
|
|
|
|
|
|
|
Posted: Fri Oct 22, 2010 6:10 pm |
|
|
milo |
Regular user |
|
|
Joined: Aug 19, 2010 |
Posts: 9 |
|
|
|
|
|
|
|
|
|
|
|
Posted: Sat Oct 23, 2010 3:56 am |
|
|
tsabitah |
Valuable expert |
|
|
Joined: Jul 07, 2010 |
Posts: 328 |
Location: surabaya |
|
|
|
|
|
|
http://pastebin.com/iEMKdSBW |
|
|
|
|
Posted: Sun Oct 24, 2010 11:06 pm |
|
|
milo |
Regular user |
|
|
Joined: Aug 19, 2010 |
Posts: 9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Posted: Mon Oct 25, 2010 3:32 am |
|
|
tsabitah |
Valuable expert |
|
|
Joined: Jul 07, 2010 |
Posts: 328 |
Location: surabaya |
|
|
|
|
|
|
cennik.php
Code: | <?php
function podaj_nazwe($id_produktu)
{
global $prod_array;
$prd = array('');
foreach ($prod_array as $produkt) {
if ($produkt['prod_id'] == $id_produktu) {
$prd = array($produkt['prod_id'], $produkt['prod_name'], $produkt['prod_price'], $produkt['prod_vat']);
return $prd;
}
}
return $prd;
}
function podaj_promocje($id_produktu)
{
global $promocja_array;
$prd = array('');
if (sizeof($promocja_array) > 0) {
foreach ($promocja_array as $produkt) {
if ($produkt['prod_id'] == $id_produktu) {
$prd = array($produkt['prod_id'], $produkt['prod_price']);
return $prd;
}
}
}
return $prd;
}
require('includes/application_top.php');
$breadcrumb->add(CENNIK_NAGLOWEK, tep_href_link('cennik.php'));
$content = 'cennik';
if (PHP_VERSION > '5.2') {
if (isset($_GET['type'])) {
$name_query = tep_db_query("select c.products_id, c.products_name, cd.products_price, cd.products_tax_class_id, cd.products_status, cd.products_id from" . TABLE_PRODUCTS_DESCRIPTION . " c, " . TABLE_PRODUCTS . " cd where cd.products_status = '1' and c.products_id = cd.products_id and c.language_id = '$languages_id'");
while ($name = tep_db_fetch_array($name_query)) {
$prod_array[] = array('prod_id' => $name['products_id'], 'prod_name' => $name['products_name'], 'prod_price' => $name['products_price'], 'prod_vat' => $name['products_tax_class_id']);
}
$promocja_query = tep_db_query("select products_id,specials_new_products_price from " . TABLE_SPECIALS);
while ($promocja = tep_db_fetch_array($promocja_query)) {
$promocja_array[] = array('prod_id' => $promocja['products_id'], 'prod_price' => $promocja['specials_new_products_price']);
}
error_reporting(E_ALL);
ini_set('display_errors', '1');
require_once 'xls/Classes/PHPExcel.php';
require_once 'xls/Classes/PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator(STORE_NAME)->setLastModifiedBy(STORE_NAME)->setTitle("Cennik")->setSubject("Cennik")->setDescription("Dokument wygnerowany w PHP classes.")->setKeywords("office openxml php")->setCategory("Cennik");
$tresc_nowa = '';
if (CZY_NAGLOWEK_CENNIK == true) {
$licznik_wierszy = 5;
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4);
$objPHPExcel->getActiveSheet()->getPageSetup()->setHorizontalCentered(true);
$objPHPExcel->getActiveSheet()->getStyle('A1:D4')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_DARKBLUE);
$objPHPExcel->getActiveSheet()->getStyle('A1:D4')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1:D4')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FFF7F7F7');
if ($_GET['type'] == 'pdf') {
$objPHPExcel->getActiveSheet()->getStyle('A1:D4')->getFont()->setSize(10);
}
if ($_GET['type'] == 'excel') {
$objPHPExcel->getActiveSheet()->getStyle('A1:D4')->getFont()->setSize(10);
}
if ($_GET['type'] == 'html') {
$objPHPExcel->getActiveSheet()->getStyle('A1:D4')->getFont()->setSize(13);
}
$objPHPExcel->getActiveSheet()->setCellValue('A1', STORE_NAME);
$adrs = STORE_NAME_ADDRESS;
$adrs = str_replace("\n", ' ', $adrs);
$adrs = str_replace("\r", '', $adrs);
$objPHPExcel->getActiveSheet()->setCellValue('A2', $adrs);
$objPHPExcel->getActiveSheet()->setCellValue('A3', STORE_OWNER_EMAIL_ADDRESS);
$objPHPExcel->getActiveSheet()->setCellValue('A4', HTTP_SERVER . DIR_WS_HTTP_CATALOG);
$objPHPExcel->getActiveSheet()->mergeCells('A1:D1');
$objPHPExcel->getActiveSheet()->mergeCells('A2:D2');
$objPHPExcel->getActiveSheet()->mergeCells('A3:D3');
$objPHPExcel->getActiveSheet()->mergeCells('A4:D4');
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FF2C2C2C');
$objPHPExcel->getActiveSheet()->setCellValue('A5', TABLE_HEADING_QUANTITY);
$objPHPExcel->getActiveSheet()->setCellValue('B5', TEXT_PRICE . ' ' . TEXT_BRUTTO);
$objPHPExcel->getActiveSheet()->setCellValue('C5', TEXT_PRICE . ' ' . TEXT_NETTO);
$objPHPExcel->getActiveSheet()->setCellValue('D5', str_replace(':', '', strip_tags(TEXT_PRODUCTS_PRICE_SPECIAL_INFO)));
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setBold(true);
if ($_GET['type'] == 'excel') {
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setSize(9);
}
if ($_GET['type'] == 'pdf') {
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setSize(9);
}
if ($_GET['type'] == 'html') {
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getFont()->setSize(12);
}
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A5:D5')->getAlignment()->setWrapText(true);
} else {
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FF2C2C2C');
$objPHPExcel->getActiveSheet()->setCellValue('A1', TABLE_HEADING_QUANTITY);
$objPHPExcel->getActiveSheet()->setCellValue('B1', TEXT_PRICE . ' ' . TEXT_BRUTTO);
$objPHPExcel->getActiveSheet()->setCellValue('C1', TEXT_PRICE . ' ' . TEXT_NETTO);
$objPHPExcel->getActiveSheet()->setCellValue('D1', str_replace(':', '', strip_tags(TEXT_PRODUCTS_PRICE_SPECIAL_INFO)));
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setBold(true);
if ($_GET['type'] == 'excel') {
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setSize(9);
}
if ($_GET['type'] == 'pdf') {
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setSize(9);
}
if ($_GET['type'] == 'html') {
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getFont()->setSize(12);
}
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A1:D1')->getAlignment()->setWrapText(true);
$licznik_wierszy = 1;
}
$tab_cat_to_prod = tep_db_query("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = " . (int)$_GET['cPath']);
$licznik_wierszy++;
while ($produkt = tep_db_fetch_array($tab_cat_to_prod)) {
$nazwa_produktu = podaj_nazwe($produkt['products_id']);
if ($nazwa_produktu[0] != '') {
$produkt_promocja = podaj_promocje($produkt['products_id']);
if ($produkt_promocja[0] != '') {
$cena_promocja = $currencies->display_price_nodiscount($nazwa_produktu[0], $produkt_promocja[1], tep_get_tax_rate($nazwa_produktu[3]));
} else {
$cena_promocja = 0;
}
$cena = $currencies->display_price($nazwa_produktu[0], $nazwa_produktu[2], tep_get_tax_rate($nazwa_produktu[3]));
$cena_netto = $currencies->display_price($nazwa_produktu[0], $nazwa_produktu[2], 0);
$objPHPExcel->getActiveSheet()->setCellValue('A' . $licznik_wierszy, $nazwa_produktu[1]);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $licznik_wierszy, $cena);
$objPHPExcel->getActiveSheet()->getStyle('B' . $licznik_wierszy)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $licznik_wierszy, $cena_netto);
$objPHPExcel->getActiveSheet()->getStyle('C' . $licznik_wierszy)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
if ($cena_promocja != 0) {
$objPHPExcel->getActiveSheet()->setCellValue('D' . $licznik_wierszy, $cena_promocja);
$objPHPExcel->getActiveSheet()->getStyle('D' . $licznik_wierszy)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
$objPHPExcel->getActiveSheet()->getStyle('D' . $licznik_wierszy)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('D' . $licznik_wierszy)->getFont()->setBold(true);
} else {
if ($_GET['type'] == 'html') {
$objPHPExcel->getActiveSheet()->setCellValue('D' . $licznik_wierszy, '-');
$objPHPExcel->getActiveSheet()->getStyle('D' . $licznik_wierszy)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
}
}
$objPHPExcel->getActiveSheet()->getStyle('A' . $licznik_wierszy . ':D' . $licznik_wierszy)->getAlignment()->setWrapText(true);
$objPHPExcel->getActiveSheet()->getStyle('A' . $licznik_wierszy . ':D' . $licznik_wierszy)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
if ($_GET['type'] == 'excel') {
$objPHPExcel->getActiveSheet()->getStyle('A' . $licznik_wierszy . ':D' . $licznik_wierszy)->getFont()->setSize(8);
}
if ($_GET['type'] == 'html') {
$objPHPExcel->getActiveSheet()->getStyle('A' . $licznik_wierszy . ':D' . $licznik_wierszy)->getFont()->setSize(10);
}
if ($_GET['type'] == 'pdf') {
$objPHPExcel->getActiveSheet()->getStyle('A' . $licznik_wierszy . ':D' . $licznik_wierszy)->getFont()->setSize(8);
}
$licznik_wierszy++;
}
}
if ($_GET['type'] == 'excel' && CZY_EXCEL_CENNIK == true) {
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(45);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(13);
$objPHPExcel->getActiveSheet()->setTitle('Cennik');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="cennik.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
if ($_GET['type'] == 'pdf' && CZY_PDF_CENNIK == true) {
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(60);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(18);
$objPHPExcel->getActiveSheet()->setTitle('Cennik');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: applications/vnd.pdf');
header('Content-Disposition: attachment;filename="cennik.pdf"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
$objWriter->save('php://output');
}
if ($_GET['type'] == 'html' && CZY_HTML_CENNIK == true) {
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(80);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->setTitle('Cennik');
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: text/html');
header('Content-Disposition: attachment;filename="cennik.html"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');
}
} else {
$kategorie = tep_get_categories();
include(bts_select('main', $content_template));
}
}
require(DIR_WS_INCLUDES . 'application_bottom.php');
?> |
|
|
|
|
|
|
|
|
|
Posted: Mon Oct 25, 2010 3:35 am |
|
|
tsabitah |
Valuable expert |
|
|
Joined: Jul 07, 2010 |
Posts: 328 |
Location: surabaya |
|
|
|
|
|
|
|
|
|
|
www.waraxe.us Forum Index -> PHP script decode requests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|