X-Cart forums

[metinex]

create_array is a function that I had created before figuring out func_query function.

I haven't tested but if you use func_query instead the code might work. I also added the code for create_array above in my first post. You need to place that code somewhere in include/func.php

[banzai]

Hi,

thank you, I forgot to upload the modified func.php

I changed "mow_report.php" to "sales_report.php" in two of the files because it was giving me file not found errors. Now it works.

thank you for your help!

[jackel]

when searching for orders in previous days , weeks etc nothing happens. Any ideas?

[metinex]

Make sure the form tag is referring to sales_report.php ot whatever file name you assigned it in admin folder.

<form name="report" method="post" action="sales_report.php">

[jackel]

Hi I did that and it still doesnt do the business!. Any further ideas?

[metinex]

I think that the problem might be related to html form issues.

Just check generated output to see everything is fine ti submit the form.

Other than that I have limited information about your problem to help.

[jackel]

<TABLE border="0" cellpadding="0" cellspacing="0">
<FORM action="/shop/admin/sales_report.php" method="POST" name="asl_form">
<TR>
<TD>Current language:</TD>
<TD>
<INPUT type="hidden" name="redirect" value="">
<SELECT name="asl" onChange="javascript: document.asl_form.submit()">
<OPTION value="DE">German</OPTION>
<OPTION value="ES">Spanish</OPTION>
<OPTION value="FR">French</OPTION>
<OPTION value="GB" selected>English</OPTION>
<OPTION value="IT">Italian</OPTION>
</SELECT>
</TD></TR>
</FORM>
</TABLE>

<form name="report" method="post" action="http://secure.tommeetippee.com/shop/admin/sales_report.php"> 
<input type="radio" name="lastday" value="0" checked> Today
 
<input type="radio" name="lastday" value="1" > Last 1 day
 
<input type="radio" name="lastday" value="7" > Last 7 day
 
  <input type="radio" name="lastday" value="30" > Last 30 day
 
   <input type="radio" name="lastday" value="365" > Last 365 day
 
<input type="submit" style="margin-top:5px"> 
<div style="line-height:10px"></div> 

    

 
   There are 1 orders. 
 

<table>
 

 
 
    
 
<tr> 
   <th align="left" width="160px">Login</th> 
   <th style="padding-right:15px">Name</th> 
   <th>Total</th> 
   <th>Count</th> 
   <th>Last Order</th> 
   <th>Last
 Order #</th> 
   <th>Referer</th> 
   <th>Status</th>       
      </tr>    
 
   <tr> 
      <td> 
            <input style="padding-left:0px; padding-right:10px" onClick="document.report.action='sales_report.php?login=anonymous646'" title="anonymous646" type="submit" class="submitLink" value="anonymous646"> 
            <input name='orderid' type='hidden' value='anonymous646' /> 
      </td> 
      <td>Name removed for data protection act</td>             
      <td align="right">бё</td> 
      <td align="center">1</td> 
      <td width="105">Aug 16  08:11 AM</td> 
      <td align="center">2666</td>   <td></td>    
      <td align="center">P</td> 
   </tr> 
 
      <tr><td>TOTAL</td><td></td><td align="right" >бёtotal</td> 
      <td></td><td></td></tr> 
</table> 
 
<h2>NEW USERS WITH NO ORDER</h2> 
<table> 
    
 
<tr> 
   <th align="left" width="160px">Login</th> 
   <th style="padding-right:15px">Name</th> 
   <th>Total</th> 
   <th>Count</th> 
   <th>Last Order</th> 
   <th>Last
 Order #</th> 
   <th>Referer</th> 
   <th>Status</th>       
      </tr>    
 
   <tr> 
      <td> 
            <input style="padding-left:0px; padding-right:10px" onClick="document.report.action='sales_report.php?login=removed for data protection act'" title="removed" type="submit" class="submitLink" value="Noonoo"> 
            <input name='orderid' type='hidden' value='Noonoo' /> 
      </td> 
      <td>removed name for data protection act</td>             
      <td align="right"></td> 
      <td align="center"></td> 
      <td width="105">Aug 16  12:40 AM</td> 
      <td align="center"></td>   <td>other</td>    
      <td align="center"></td> 
   </tr> 
 
</table> 
 

</form>

[ShishaPipeUK]

I have followed the mod and displays the page, but i get a error which is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\maxking\shisha\shopcart\include\func.php on line 5891

Now looking at the line the error is:

while ($query_result= mysql_fetch_array($result))

I am using x-cart 4.18

The full file that i put into the include/func.php is:

function create_array($query) 
{ 

$result= mysql_query($query);          
$array_final = array();              
while ($query_result= mysql_fetch_array($result)) 
      array_push($array_final, $query_result);        
return ($array_final); 

} 

As described in the installation instructions.

[jackel]

Hi,

any solutions to the problem I have posted about? the forms look fine to me but if someone can offer any other suggestions I would be greatful.

As for this guys error above i'd say it could be that this function is not available to you on IIS with PHP, I used to find IIS very temperamental when it came to php!

[Learner]

Hi,
Though it was an old thread.But anyone can successfully test and implement on X cart pro 4.1.x based store.I want to see a demo.