Jump to content

dr_lucas

Members
  • Content count

    357
  • Joined

  • Last visited

  • Days Won

    7

Everything posted by dr_lucas

  1. This code is nicer and easier indeed, but it is incomplete. If you want to edit a product on page 2, for example, when you click the product the right page column (with the edit, delete, copy, move to buttons) will disappear. Same problem with the search results. Also if you edit a product from page 2, for example, when you finish and click the update, it will redirect you to the wrong products page and also not display the right column. Hope you can fix all these issue, I would love to have it running, as I am sure many more would... cheers ;)
  2. Thanks. The last code causes the following SQL error when I click the back button: "1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '$limite_1, $limite_2' at line 1 select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_cost, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_qty_blocks, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '26' order by pd.products_name LIMIT $limite_1, $limite_2 Do you how I can fix it? Also, I just found another similar bug in the mod. When you edit an existing product, preview it and then click the "update" button, it won't know the limits...
  3. Thanks A LOT, mate! You are my new hero! ;)
  4. Thanks, Gotz, was waiting for this solution for such a long time...works like a charm! :) The only thing missing in this contribution now is the ability to limit the displayed (products) search results per page as well. Do you know how to do it by any chance?
  5. You probably did... Read and follow the bold part of my post as well...
  6. dr_lucas

    Time Zone Offset Contribution Support

    That's not true, mate. this code: case 'now()': $query .= $columns . ' = now(), '; Is *NOT* the same as this code, that I instructed to modify: case 'now()': $query .= 'now(), '; And I do believe that I have been 100% clear when I wrote my instructions...
  7. dr_lucas

    Time Zone Offset Contribution Support

    IMHO the instructions are very clear (if someone fail to follow such simple and short instructions and revise other parts that I clearny never stated, then he should probably give up modding his shop and give it to someone who know what he's doing, no offence) but if you think you can do better then by all means - be my guest, mate...
  8. dr_lucas

    Time Zone Offset Contribution Support

    Such a simple mod, no idea what make you have such issues with it... By the way, the sql does not create any new table, it only add 1 value to the configuration table...
  9. dr_lucas

    Time Zone Offset Contribution Support

    No, the bottom one was not as you wrote it...it was (and should stay): case 'now()': $query .= $columns . ' = now(), '; break; case 'null': $query .= $columns .= ' = null, '; break;
  10. dr_lucas

    Time Zone Offset Contribution Support

    It happens because you revised the now() function twice in your php files instead of only once in each file... You should have revised only the first now() case... It should be changed back to the original: while (list(, $value) = each($data)) { switch ((string)$value) { case 'now()': // Added a time offset function here $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), '; break; case 'null': $query .= 'null, '; break; default: $query .= '\'' . tep_db_input($value) . '\', '; break; } } $query = substr($query, 0, -2) . ')'; } elseif ($action == 'update') { $query = 'update ' . $table . ' set '; while (list($columns, $value) = each($data)) { switch ((string)$value) { ****************************************************CHANGE IT BACK BELOW: (In both files) case 'now()': // Added a time offset function here $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), '; break; case 'null': $query .= $columns .= ' = null, '; break;
  11. dr_lucas

    Time Zone Offset Contribution Support

    This info is insufficient. Please copy & paste here the complete content of the following files: catalog/includes/functions/database.php catalog/admin/includes/functions/database.php
  12. dr_lucas

    NEW! Complete Order Editing Tool!

    Alright mate, will try that, thanks
  13. dr_lucas

    NEW! Complete Order Editing Tool!

    I installed version 2.2.1 about 1 month ago, are there any changes in the installation of 2.5 or I can just overwirte admin/edit_orders.php and that's it? TIA.
  14. Forgot to say: You may check your host server DNS IP by running a DNS lookup (Choose ALL in the drop-down menu) in the following URL: http://www.dnsstuff.com/ Use this as your $dns value
  15. Yes, I found your information useful, and revised the user_tracking 1.4.2 file to not use the gethostbyaddr function, but still show the host name by running a reverse dns lookup using a customized function. To use it you just have to copy and past the following code into your admin/user_tracking.php, overwriting all the previous code and uploading it to its directory. You MUST revise the $dns value to be your host dns IP address instead of the 222.222.222.222 and you may increase the timeout as well, in case it is not showing many hosts, or if it doesn't show them at all If this doesn't work for you it can mean 1 or both of these value is incorrect... <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License User Tracking with Admin Version 1.4.3 Modified by dr_lucas to have optimal script speed by replacing the gethostbyaddr function to a customized function which is changing the timeout of the reverse DNS lookup April 27th, 2006 */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_USER_TRACKING); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); require(DIR_WS_INCLUDES . 'geoip.inc'); $gi = geoip_open(DIR_WS_INCLUDES . 'GeoIP.dat',GEOIP_STANDARD); $LIMIT_DISPLAY_SESSIONS = CONFIG_USER_TRACKING_SESSION_LIMIT; // $MIN_CLICK_COUNT = 1; ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td class="smallText"> <?php if ($custmid == '0') { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " where customer_id = 0"); echo "<font color=red>" . TEXT_DELETE_CUSTOMER_GUEST . '</font><p>'; } if ($purge == '72') { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " where time_last_click < '" . (time() - ($purge * 3600))."'"); echo "<font color=red>" . TEXT_HAS_BEEN_PURGED . '</font><p>'; } if ($purge == '0') { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " where time_last_click < '" . (time() - ($purge * 3600))."'"); echo "<font color=red>" . TEXT_HAS_BEEN_PURGED . '</font><p>'; } if ($delip == '1') { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE ip_address = '" . CONFIG_USER_TRACKING_EXCLUDED . "'"); echo "<font color=red>" . TEXT_DELETE_IP_OK_1 . CONFIG_USER_TRACKING_EXCLUDED . ' ' . TEXT_DELETE_IP_OK_2 . '.</font><p>'; $delip='0'; } if ($delip == '2') { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE ip_address = '" . $user_tracking_excluded . "'"); echo TEXT_DELETE_IP_OK_1 . $user_tracking_excluded . ' ' . TEXT_DELETE_IP_OK_2 . '.<p>'; $delip='0'; } if ($delnosession == '1') { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE session_id = ''"); echo TEXT_DELETE_OK . '<p>'; $delnosession='0'; } if ($delsession) { tep_db_query("DELETE FROM " . TABLE_USER_TRACKING . " WHERE session_id = '" . $delsession . "'"); echo $delsession . ' has been deleted. <p>'; } echo EXPLAINATION, "<p>"; // some time routines $time_frame = time(); if ($HTTP_GET_VARS['time']) { $time_frame = $HTTP_GET_VARS['time']; } // only display if all sessions are displayed if (!isset($HTTP_GET_VARS['viewsession']) && $HTTP_GET_VARS['viewsession'] == '') { echo '<b>' . TEXT_SELECT_VIEW .': </b>'; echo '<a href="' . FILENAME_USER_TRACKING . '?time='; echo $time_frame - 86400 . '">' . "<font color=blue><b>" . TEXT_BACK_TO . ' ' . date("d M Y", $time_frame - 86400) . '</b></font color></a> '; if (time() > $time_frame + 86400) { echo '| <a href="' . FILENAME_USER_TRACKING . '?time='; echo $time_frame + 86400 . '">' . "<font color=blue><b>" . TEXT_FORWARD_TO . date("d M Y", $time_frame + 86400) . '</b></font color></a>'; } echo "<p>" . TEXT_DISPLAY_START . $LIMIT_DISPLAY_SESSIONS . TEXT_DISPLAY_END . '<p>'; echo TEXT_PURGE_START . ' <a href="' . FILENAME_USER_TRACKING . '?purge=72">'. "<font color=blue><b>" . TEXT_PURGE_RECORDS. '</a></b></font color> ' . TEXT_PURGE_END. '</font><p>'; echo TEXT_PURGE_START . ' <a href="' . FILENAME_USER_TRACKING . '?custmid=0">'. "<font color=blue><b>" . TEXT_PURGE_RECORDS. '</a></b></font color> ' . TEXT_PURGE_CUSTMID_END. '</font><p>'; echo TEXT_PURGE_START . ' <a href="' . FILENAME_USER_TRACKING . '?purge=0">'. "<font color=blue><b>" . TEXT_PURGE_RECORDS. '</a></b></font color> ' . TEXT_PURGE_ALL. ' </font>' . '<font color=red><b>' . TEXT_BEWAREDELETE . '</b></font color><p>'; echo TEXT_DELETE_IP . CONFIG_USER_TRACKING_EXCLUDED . ' <a href="' . FILENAME_USER_TRACKING . '?delip=1">'. "<font color=blue><b>" . TEXT_PURGE_RECORDS. '</a></b></font><p>'; echo TEXT_DELETE_NOIP . ' <a href="' . FILENAME_USER_TRACKING . '?delnosession=1">' . "<font color=blue><b>" . TEXT_DELETE_NOW . '</b></a> ' . '</font><p>'; php?> <tr> <form name="del_ip" <?php echo 'action="' . tep_href_link(FILENAME_USER_TRACKING . '?delip=2') . '"'; ?> method="post"> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo '<font size="1">' . TEXT_DELETE_IP . '</font>'; ?> </td> <td class="main"><?php echo tep_draw_input_field('user_tracking_excluded', (isset($sInfo->user_tracking_excluded) ? $sInfo->user_tracking_excluded : '')); ?></td> <td class="main" valign="top"><?php echo (($form_action == 'user_tracking_excluded') ? tep_image_submit('button_insert.gif', IMAGE_INSERT) : tep_image_submit('button_delete.gif', IMAGE_DELETE)). '</a>'; ?></td> </tr> </table></td> </form> </tr> <? } // we need to slurp all the customer tracking information out of the database if (isset($HTTP_GET_VARS['viewsession']) && $HTTP_GET_VARS['viewsession'] != '') { // display selected session $whos_online_query = tep_db_query("select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, referer_url," . " session_id from " . TABLE_USER_TRACKING . " where session_id = '" . $HTTP_GET_VARS['viewsession'] . "' order by time_last_click desc"); } else { // read all sessions $whos_online_query = tep_db_query("select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, page_desc, referer_url," . " session_id from " . TABLE_USER_TRACKING . " where time_entry > " . ($time_frame - 86400) . " and time_entry < " . $time_frame . " order by time_last_click desc"); } $results = 0; while ($whos_online = tep_db_fetch_array($whos_online_query)) { $user_tracking[$whos_online['session_id']]['session_id']=$whos_online['session_id']; $user_tracking[$whos_online['session_id']]['ip_address']=$whos_online['ip_address']; $user_tracking[$whos_online['session_id']]['customer_id']=$whos_online['customer_id']; $user_tracking[$whos_online['session_id']]['referer_url']=$whos_online['referer_url']; if ($whos_online['full_name'] != 'Guest') $user_tracking[$whos_online['session_id']]['full_name'] = '<font color="0000ff"><b>' . $whos_online['full_name'] . '</b></font>'; $user_tracking[$whos_online['session_id']]['last_page_url'][$whos_online['time_last_click']] = $whos_online['last_page_url']; $user_tracking[$whos_online['session_id']]['page_desc'][$whos_online['time_last_click']] = $whos_online['page_desc']; if (($user_tracking[$whos_online['session_id']]['time_entry'] > $whos_online['time_entry']) || (!$user_tracking[$whos_online['session_id']]['time_entry'])) $user_tracking[$whos_online['session_id']]['time_entry'] = $whos_online['time_entry']; if (($user_tracking[$whos_online['session_id']]['end_time'] < $whos_online['time_entry']) || (!$user_tracking[$whos_online['session_id']]['end_time'])) $user_tracking[$whos_online['session_id']]['end_time'] = $whos_online['time_entry']; $results ++; } ?> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top" align=center><table border="0" width="95%" cellspacing="0" cellpadding="2"> <?php // now let's display it $listed=0; if ($results) while (($ut = each($user_tracking)) && ($listed++ < $LIMIT_DISPLAY_SESSIONS)) { // if (count($ut['value']['last_page_url']) > $MIN_CLICK_COUNT) { if (count($ut['value']['last_page_url']) > CONFIG_USER_TRACKING_CLICK_COUNT) { $time_online = (time() - $ut['value']['time_entry']); if ( ((!$HTTP_GET_VARS['info']) || (@$HTTP_GET_VARS['info'] == $ut['value']['session_id'])) && (!$info) ) { $info = $ut['value']['session_id']; } echo ' <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent" colspan="5">'.TABLE_HEADING_SESSION_ID .'</td> <td class="dataTableHeadingContent" colspan="1 width="150">'.TEXT_USER_SHOPPING_CART.'</td> </tr>'; echo ' <tr class="dataTableRowSelected">' . "\n"; if ($ut['value']['full_name'] == "") $ut['value']['full_name'] = "Guest"; ?> <td colspan = "5" class="dataTableContent" valign="top"></b><a name="<?php echo $ut['value']['session_id'];?>"><?php echo $ut['value']['full_name'] . '</b> (' . $ut['value']['session_id'] . ") <a href=\"user_tracking.php?time=" . $time_frame . "&delsession=" . $ut['value']['session_id'] . "\"><font color=red>[" . TEXT_DELETE_SESSION . "]</font></a>" . " <a href=\"user_tracking.php?time=" . $time_frame . "&viewsession=" . $ut['value']['session_id'] . "#" . $ut['value']['session_id'] . "\"><font color=green>[" . TEXT_VIEW_SESSION . "]</font></a>";?></td> <?php // shopping cart decoding $session_data = tep_db_query("select value from " . TABLE_SESSIONS . " WHERE sesskey = '" . $ut['value']['session_id'] . "'"); if (tep_db_num_rows($session_data)) { $session_data = tep_db_fetch_array($session_data); $session_data = trim($session_data['value']); } else { $session_data = @file(tep_session_save_path() . '/sess_' . $ut['value']['session_id']); $session_data = trim($session_data[0]); } $cart = ""; // $referer_url = ""; $num_sessions ++; session_decode($session_data); $contents = array(); if (is_object($cart)) { $products = $cart->get_products(); for ($i=0; $i<sizeof($products); $i++) { $contents[] = array('text' => $products[$i]['quantity'] . ' x ' . $products[$i]['name']); } if (sizeof($products) > 0) { $contents[] = array('text' => tep_draw_separator('pixel_black.gif', '100%', '1')); $contents[] = array('align' => 'right', 'text' => TEXT_SHOPPING_CART_SUBTOTAL . ' ' . $currencies->format($cart->show_total(), true, $currency)); } else { $contents[] = array('text' => ' '); } } $heading = array(); if (tep_not_null($contents)) { echo ' <td rowspan="4" valign="top">' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } else { echo ' <td rowspan="4" valign="top" class="dataTableContent" align="center">session expired' . "\n"; echo ' </td>' . "\n"; } ?> </tr> <tr> <td class="dataTableContent" align="right" valign="top"><b>Click Count:</b></td> <td class="dataTableContent" valign="top"><font color=FF0000><b><?php echo count($ut['value']['last_page_url']);?></b></font></td> <td class="dataTableContent" colspan=2 rowspan=4 align="center"> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php $today = getdate(); $midnight = mktime(0, 0, 0, $today['mon'], $today['mday'], $today['year']); ?> <tr> <td class="dataTableContent" align="right" valign="top"><b><?php echo TABLE_HEADING_ENTRY_TIME; ?></b></td> <td class="dataTableContent" colspan="2" valign="top"><?php echo date('d/m/Y H:i:s', $ut['value']['time_entry']); ?></td> <td class="dataTableContent" align="right" valign="top"><b><?php echo TEXT_IDLE_TIME ?></b></td> <td class="dataTableContent" colspan="2" valign="top"><?php echo date('H:i:s', ($midnight + time() - $ut['value']['end_time'])); ?></td> </tr> <tr> <td class="dataTableContent" align="right" valign="top"><b><?php echo TABLE_HEADING_END_TIME; ?></b></td> <td class="dataTableContent" colspan="2" valign="top"><?php echo date('d/m/Y H:i:s', $ut['value']['end_time']); ?></td> <td class="dataTableContent" align="right" valign="top"><b><?php echo TEXT_TOTAL_TIME ?></b></td> <td class="dataTableContent" colspan="2" valign="top"><b><?php echo date('H:i:s', ($midnight + $ut['value']['end_time'] - $ut['value']['time_entry'])); ?></b></td> </tr> </table> </td> </tr> <tr> <td class="dataTableContent" align="right" valign="top"><b><?php echo TABLE_HEADING_COUNTRY ?></b></td> <td class="dataTableContent" valign="top"><?php echo tep_image(DIR_WS_FLAGS . strtolower(geoip_country_code_by_addr($gi, $ut['value']['ip_address'])) . '.gif', geoip_country_name_by_addr($gi, $ut['value']['ip_address'])); ?> <?php echo geoip_country_name_by_addr($gi, $ut['value']['ip_address']); ?></td> </tr> <tr> <td class="dataTableContent" align="right" valign="top"><b><?php echo TABLE_HEADING_IP_ADDRESS ?></b></td> <td class="dataTableContent" valign="top"><?php echo '<a href="' . USER_TRACKING_WHOIS_URL . $ut['value']['ip_address']; ?>" target="_new"><?php echo $ut['value']['ip_address']; ?></a></td> </tr> <tr> <td class="dataTableContent" align="right" valign="top"><b><?php echo TABLE_HEADING_HOST ?></b></td> <? //Dr_Lucas BOF: No more slow user_tracking contribution $ip = ($ut['value']['ip_address']); $dns = "222.222.222.222"; //<--This value must be changed to your HOST DNS server IP instead if ( function_exists('gethostbyaddr_timeout') ) { echo; } else { function gethostbyaddr_timeout($ip, $dns, $timeout=30) //<--The timeout miliseconds value can be changed to a one suitable for you, note that the longer the allowed timeout, the longer time this function has to find the host name ///// { // random transaction number (for routers etc to get the reply back) $data = rand(0, 99); // trim it to 2 bytes $data = substr($data, 0, 2); // request header $data .= "\1\0\0\1\0\0\0\0\0\0"; // split IP up $bits = explode(".", $ip); // error checking if (count($bits) != 4) return "ERROR"; // there is probably a better way to do this bit... // loop through each segment for ($x=3; $x>=0; $x--) { // needs a byte to indicate the length of each segment of the request switch (strlen($bits[$x])) { case 1: // 1 byte long segment $data .= "\1"; break; case 2: // 2 byte long segment $data .= "\2"; break; case 3: // 3 byte long segment $data .= "\3"; break; default: // segment is too big, invalid IP return "INVALID"; } // and the segment itself $data .= $bits[$x]; } // and the final bit of the request $data .= "\7in-addr\4arpa\0\0\x0C\0\1"; // create UDP socket $handle = @fsockopen("udp://$dns", 53); // send our request (and store request size so we can cheat later) $requestsize=@fwrite($handle, $data); @socket_set_timeout($handle, $timeout - $timeout%1000, $timeout%1000); // hope we get a reply $response = @fread($handle, 1000); @fclose($handle); if ($response == "") return $ip; // find the response type $type = @unpack("s", substr($response, $requestsize+2)); if ($type[1] == 0x0C00) // answer { // set up our variables $host=""; $len = 0; // set our pointer at the beginning of the hostname // uses the request size from earlier rather than work it out $position=$requestsize+12; // reconstruct hostname do { // get segment size $len = unpack("c", substr($response, $position)); // null terminated string, so length 0 = finished if ($len[1] == 0) // return the hostname, without the trailing . return substr($host, 0, strlen($host) -1); // add segment to our host $host .= substr($response, $position+1, $len[1]) . "."; // move pointer on to the next segment $position += $len[1] + 1; } while ($len != 0); // error - return the hostname we constructed (without the . on the end) return $ip; } return $ip; } } $revhost=gethostbyaddr_timeout($ip,$dns); ?> <td class="dataTableContent" valign="top"><?php echo $revhost; ?></td> <? //Dr_Lucas EOF: No more slow user_tracking contribution ?> </tr> <tr> <td class="dataTableContent" align="right" valign="top"><b><?php echo TEXT_ORIGINATING_URL ?></b></td> <?php $ref_name = chunk_split($referer_url,40,"<br>"); ?> <td class="dataTableContent" align="left" valign="top" colspan=3><?php echo '<a href="'. $ut['value']['referer_url'] .'" target="_new">'. $ut['value']['referer_url'] .'</a>'; ?> </td> </tr> <tr> <td class="dataTableContent"></td> <td class="dataTableContent" colspan=3> <table border="0" cellspacing="1" cellpadding="2" bgcolor=999999 width=100%> <?php // View session if ($viewsession != '' && $viewsession == $ut['value']['session_id']){ while (($pu = each($ut['value']['last_page_url']))&&($du = each($ut['value']['page_desc']))) { ?> <tr bgcolor=ffffff> <td class="dataTableContent" valign=top align="right"><?php echo date('H:i:s', $pu['key']); ?></td> <td class="dataTableContent" nowrap valign=top align="left"> <a href="<?php echo $pu['value']; ?>" target="_new"><?php if ($du['value']!=''){ echo $du['value'];} ?></a> </td> <td class="dataTableContent" width=100% align="left"><a href="<?php echo $pu['value']; ?>" target="_new"><?php echo chunk_split($pu['value'],40,"<br>"); ?></a></td> </tr> <?php } } echo' </table> </td> </tr> '; } } ?> <tr> <td class="smallText" colspan="7"><b><font color=blue><?php echo sprintf(TEXT_NUMBER_OF_PAGES, tep_db_num_rows($whos_online_query)); echo TEXT_NUMBER_OF_CUSTOMERS, $num_sessions . "."; ?></font></b></td> </tr> </table></td> </tr> </table> </td> </tr> </table></td> <!-- body_text_eof //--> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  16. dr_lucas

    Quickly Update Product Stock

    If you want to sort it differently than it is now, do the following: /admin/quick_stockupdate.php Find: $sql2 = tep_db_query("SELECT p.products_model, p.products_id, p. products_quantity, p.products_status, p.products_weight, p.products_price, pd.products_name from products p, products_to_categories ptc, products_description pd where p.products_id = ptc.products_id and p.products_id = pd.products_id and language_id = $languages_id and ptc.categories_id = '" . $HTTP_POST_VARS['cat_id'] . "' order by pd.products_name"); And change the end (ie. change order by pd.products_name) to order by any value that you wish, for example if you wish to make it sort my product's id, then change it to look like this: $sql2 = tep_db_query("SELECT p.products_model, p.products_id, p. products_quantity, p.products_status, p.products_weight, p.products_price, pd.products_name from products p, products_to_categories ptc, products_description pd where p.products_id = ptc.products_id and p.products_id = pd.products_id and language_id = $languages_id and ptc.categories_id = '" . $HTTP_POST_VARS['cat_id'] . "' order by p.products_id");
  17. I have exactly the same problem. Did you find the solution, mate?
  18. dr_lucas

    Database Admin support thread

    Love this contribution! So simple to install and so effective! Exactly what I was looking for. Huge props to the author!!! :) My only wish for this one, if possible, is to add checkboxes near the table names and allow multiple modifications on the checked tables (ie. drop, empty etc.) as in phpmyadmin. Thanks again!
  19. dr_lucas

    Time Zone Offset Contribution Support

    The complete list of supported time zones can be found here: http://us3.php.net/manual/en/timezones.php
  20. dr_lucas

    [Contribution] STS v4

    WoW, thanx for the quick fix man!
  21. dr_lucas

    [Contribution] STS v4

    Just wondering, did you have a chance to test the included footer.php and see if it works? If you haven't, extract it from the mod packagae and overwrite your original... Any change?
  22. dr_lucas

    [Contribution] STS v4

    I got the header tags contribution installed as well (together with some other contributions and personal modifications that I made).
  23. dr_lucas

    [Contribution] STS v4

    I forgot to mention that I installed it on my heavily modded store, and it behave the way I described it in the previous post. I just tried to install it on a brand new osC installation and everything seems to be working fine with the STS. I also triple checked all the files that needed to be modified in the catalog section and everything there seems to be as it should. This is the link to my store: (that shows a blank page) http://www.skpiercing.com/index.php?sts_debug=debug And this is the link to my clean osC test site (that shows fine): http://www.skpiercing.com/test/index.php?sts_debug=debug Thanks in advance for any help.
  24. dr_lucas

    [Contribution] STS v4

    I just installed the STS for the first time, quite an easy installation process, but after installing and trying to open the page I keep getting a blank page, tried it in normal mode and also in debug mode (index.php?sts_debug=debug)... I enabled the mod in my admin (the default one) am I doing something wrong?
  25. dr_lucas

    EasyPopulate and Powweb

    Get rid of powweb (I did long ago), move to a normal host, mate. They restrict their customers too much, and IMHO offer a crappy control panel, to save the costs of using the industry standard cPanel (with Fantastico)... I personally recommend the extremely popular Lunarpages.com, I am a very happy customer of LP, but you may choose any other decent host (search google for top 10 web hosting and/or check out www.webhostingtalk.com)
×