query("update $prodtable set prodordmax=$maxord"); if($res){ echo 'Done! Do not forget to set max order qty for any product you add!
'; echo 'Please check several products to verify that they have been updated correctly.'; } }else{ if(file_exists('../functions.php')){ require('../functions.php'); $custid=$instid; } if(!file_exists('../functions.php')){ if(file_exists('../cartid.php3')){ echo 'cartidphp3 bestaat'; $file="../cartid.php3"; if (file_exists($file)){ $fileh=fopen($file, "r"); while($fbuffer = fgets($fileh, 4096)) { $comp='$custid'; $doel=substr("$fbuffer",0,7); if($doel==$comp){ $precust=stripslashes($fbuffer); $cust=explode('"',stripslashes($precust)); $custid=$cust['1']; } } } }else{if(file_exists('../cartid.php')){ $file="../cartid.php"; if (file_exists($file)){ $fileh=fopen($file, "r"); while($fbuffer = fgets($fileh, 4096)) { $comp='$custid'; $doel=substr("$fbuffer",0,7); if($doel==$comp){ $precust=stripslashes($fbuffer); $cust=explode('"',stripslashes($precust)); $custid=$cust['1']; } } } } } } ?> FishCart database fix tool
FishCart Database fix tool

This tool should only be used to apply a maximum order quantity per product.

It will set a Max Order Qty for all products in one single step. Do not set this to high, 1000 will probably be appropriate for most (I hope :-)) if 500 is enough you should set it to 500. After running this tool you will need to check several products and verify that the value entered below matches the values in your database.
Please make sure the custid below matches your custid or instid (depends on version).
If it does not mach you will see an SQL error.
Custid:
Max order qty:
Please report any bugs to: bvo at bvanouwerkerk.nl
When reporting bugs, please include which version FishCart you're running.
Do not forget to include the actual error message you got.
Support: contact the FishCart support list.
You can subscribe here