Request Restock Mod Thread

[100asa]

<!-- header_eof //-->
  <table border="0" width="100%" cellspacing="0" cellpadding="0">
   <tr>
    <td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td>
   </tr>
   <tr>
    <td class="pageHeading">Request Restock Admin</td>
   </tr>
   <tr>

    <td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="15"></td>
   </tr>
  </table>
 
<div id="actionSelector">
<form name="request_restock" action="http://www.100asa.it/back100asa/request_restock.php" method="GET">    <fieldset id="actionSelectorForm">
        <label class="inputLabel" for="option" style="float:left; width: 7em;">Options</label>
        <input type="hidden" name="action" value="send" />
        <select rel="dropdown" name="option"><option value=""></option><option value=""></option><option value=""></option><option value=""></option><option value=""></option></select>    </fieldset>

<div><input type="submit" value="Go!" /></div>
</form>
</div>

  <table border="0" cellspacing="1" cellpadding="2" align="center">
   <tr>
    <td colspan="2">
        <span class="forward">
            Visualizzati da<strong>1</strong> a <strong>4</strong> (di <strong>4</strong> prodotti)Pagina 1 di 1        </span>

    </td>
   </tr>
   <tr class="dataTableHeadingRow">
    <td class="dataTableHeadingContent">Product Name</td>
    <td class="dataTableHeadingContent">Request Quantity</td>
    <!--<td class="dataTableHeadingContent"></td>-->
   </tr>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">

    <td class="dataTableContent">
        <a href="http://www.100asa.it/index.php?main_page=product_info&products_id=1504" target="_blank">SONY 2 rulli di carta 10x</a>...    </td>
    <td class="dataTableContent">
        20    </td>
    <!--<td class="dataTableContent">
            </td>-->
   </tr>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">

    <td class="dataTableContent">
        <a href="http://www.100asa.it/index.php?main_page=product_info&products_id=380" target="_blank">Zebra Ribbon wax 64x74</a>    </td>
    <td class="dataTableContent">
        40    </td>
    <!--<td class="dataTableContent">
            </td>-->
   </tr>
    <tr>

    <td colspan="2">
        <span class="forward">
            Visualizzati da<strong>1</strong> a <strong>4</strong> (di <strong>4</strong> prodotti)Pagina 1 di 1        </span>
    </td>

   </tr>
</table>

<!-- body_eof //-->
<!-- footer //-->
<div class="footer-area">
<table border="0" width="100%" cellspacing="8" cellpadding="8">
  <tr>
    <td align="center" class="smallText" height="100" valign="bottom">100asa.it &copy; 2003 - 2006 <br />Versione <a href="http://www.100asa.it/back100asa/server_info.php">Zen Cart v1.3.5/v1.3.5</a></td>

  </tr>
</table>
</div>
<!-- footer_eof //-->
<br />
</body>
</html> 

[yellow1912]

Download the latest version, reupload admin/request_restock.php

[100asa]

I've already installed the latest version alpha 3.3 !

[yellow1912]

Yes, but request_restock.php is not doing what it should do, that's why I ask you to re-download and the re-upload it.

[100asa]

Done! re-download, re-upload it.
The same! :-(

[yellow1912]

Yes, but request_restock.php is not doing what it should do, that's why I ask you to re-download and the re-upload it.

BTW, what is the version of your php?

[100asa]

PHP Version 4.4.7
it's strange, but I don't find solution!
another strange thing: the second request you see, I've write it for test, 20 quantity; why show me 40?
it's possible send automatic notification email when stock back to >1?

[yellow1912]

First thing first, we have to solve the mystery why the drop down list does not appear. So attach the content of that file(request_restock.php) on your server here

[100asa]

the file I use in admin, request_restock.php is the same of your mod, alpha 3.3

<?php
/**
 * Request Restock Alpha 3/2
 * By RubikIntegration team @ RubikIntegration.com
 * Made for ZC 1.3.7
 * Released under the GNU General Public License
 */

require('includes/application_top.php');

$options = array (0 => array(id => 1,
                             text => 'List total requested quantity per product'),
                  1 => array(id => 2,
                             text => 'List all requests sort by product'),
                  2 => array(id => 3,
                             text => 'Check and Update deleted products'),
                  3 => array(id => 4,
                             text => 'Send notices to customers'),
                  4 => array(id => 5,
                             text => 'Clean up requests')
                        );

if (!isset($_GET['option']) || !is_numeric($_GET['option']) || (int)$_GET['option'] < 1 || $_GET['option'] > 5)
    $_GET['option'] = 1;

switch($_GET['option']){
    case 1:
        $products_query_raw = "select r.product_id, sum(r.request_quantity) as request_quantity, d.products_name from ".TABLE_PRODUCTS_REQUEST_RESTOCK_RECORDS." r,".TABLE_PRODUCTS_DESCRIPTION." d WHERE r.request_status = 0 and d.products_id = r.product_id group by r.product_id order by d.products_name asc";
        $products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
        $products_values = $db->Execute($products_query_raw);
    break;
    case 2:
        $requests_query_raw = "select c.name, c.email_address, r.request_quantity, r.request_message, r.product_id, d.products_name from ".TABLE_PRODUCTS_REQUEST_RESTOCK_RECORDS." r,".TABLE_PRODUCTS_REQUEST_RESTOCK_CUSTOMERS." c,".TABLE_PRODUCTS_DESCRIPTION." d WHERE r.request_status = 0 and d.products_id = r.product_id AND c.id = r.customer_id order by r.product_id asc";
        $requests_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $requests_query_raw, $requests_query_numrows);
        $requests_values = $db->Execute($requests_query_raw);
    break;
    case 3:
        update_requests();
    break;
    case 4:
        process_notices();
    break;
    case 5:
        clean_up_requests();        
    break;
}

?>
<!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">
<link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" src="includes/general.js"></script>
<script type="text/javascript">
  <!--
  function init()
  {
    cssjsmenu('navbar');
    if (document.getElementById)
    {
      var kill = document.getElementById('hoverJS');
      kill.disabled = true;
    }
  }
  // -->
</script>
</head>
<body onload="init()">

<div class="header_area">
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
</div>
<!-- header_eof //-->
  <table border="0" width="100%" cellspacing="0" cellpadding="0">
   <tr>
    <td><?php echo zen_draw_separator('pixel_trans.gif', '100%', '10');?></td>
   </tr>
   <tr>
    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
   </tr>
   <tr>
    <td><?php echo zen_draw_separator('pixel_trans.gif', '100%', '15');?></td>
   </tr>
  </table>
 
<div id="actionSelector">
<?php echo zen_draw_form('request_restock', FILENAME_REQUEST_RESTOCK, '', 'GET'); ?>
    <fieldset id="actionSelectorForm">
        <label class="inputLabel" for="option" style="float:left; width: 7em;"><?php echo OPTION_NAME; ?></label>
        <input type="hidden" name="action" value="send" />
        <?php echo zen_draw_pull_down_menu('option', $options, $_GET['option']); ?>
    </fieldset>
<div><input type="submit" value="Go!" /></div>
</form>
</div>

<?php if (isset($_GET['option']) and $_GET['option'] == 1){ ?>
  <table border="0" cellspacing="1" cellpadding="2" align="center">
   <tr>
    <td colspan="2">
        <span class="forward">
            <?php 
                echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
                echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
            ?>
        </span>
    </td>
   </tr>
   <tr class="dataTableHeadingRow">
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME;?></td>
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REQUEST_QUANTITY;?></td>
    <!--<td class="dataTableHeadingContent"><?php //echo TABLE_HEADING_UPDATE_REQUEST;?></td>-->
   </tr>
<?php
while (!$products_values->EOF) {
?>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
    <td class="dataTableContent">
        <?php echo process_product_name($products_values->fields['products_name'],$products_values->fields['product_id']);?>
    </td>
    <td class="dataTableContent">
        <?php echo $products_values->fields['request_quantity'];?>
    </td>
    <!--<td class="dataTableContent">
        <?php //zen_draw_checkbox_field('selections[]', 1, 1); ?>
    </td>-->
   </tr>
<?php
    $products_values->MoveNext();
}
?>
    <tr>
    <td colspan="2">
        <span class="forward">
            <?php 
                echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS);
                echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
            ?>
        </span>
    </td>
   </tr>
</table>
<?php } elseif(isset($_GET['option']) and $_GET['option'] == 2) { ?>
  <table border="0" cellspacing="1" cellpadding="2" align="center">
   <tr>
    <td colspan="5">
        <span class="forward">
            <?php 
                echo $requests_split->display_count($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_REQESTS);
                echo $requests_split->display_links($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
            ?>
        </span>
   </td>
   </tr>
   <tr class="dataTableHeadingRow">
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCT_NAME;?></td>
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REQUEST_QUANTITY;?></td>
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_NAME;?></td>
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CUSTOMER_EMAIL;?></td>
    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_REQUEST_MESSAGE;?></td>
    
    
   </tr>
<?php
while (!$requests_values->EOF) {
?>
   <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">
    <td class="dataTableContent">
        <?php echo process_product_name($requests_values->fields['products_name'],$requests_values->fields['product_id']);?>
    </td>
    <td class="dataTableContent">
        <?php echo $requests_values->fields['request_quantity'];?>
    </td>
    <td class="dataTableContent">
        <?php echo $requests_values->fields['name'];?>
    </td>
    <td class="dataTableContent">
        <?php echo $requests_values->fields['email_address'];?>
    </td>
    <td class="dataTableContent">
        <?php echo $requests_values->fields['request_message'];?>
    </td>
   </tr>
<?php
    $requests_values->MoveNext();
}
?>
    <tr>
    <td colspan="5">
        <span class="forward">
            <?php 
                echo $requests_split->display_count($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_REQESTS);
                echo $requests_split->display_links($requests_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'action'))); 
            ?>
        </span>
    </td>
   </tr>
</table>
<?php } ?>

<!-- body_eof //-->
<!-- footer //-->
<div class="footer-area">
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
</div>
<!-- footer_eof //-->
<br />
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

this is the source of the page in admin section:

[yellow1912]

This might not be the error, but I have noticed that you use a different language instead of english. There are several language files that needed to be uploaded to 'eng', but since you don't use english to have to upload them to your language folder.