<?php
include("../../../dbconnect.php");

foreach($_POST as $key => $value){
	if(preg_match("/addon_/",$key,$keym)){
		$addonid = str_replace("addon_","",$key);
		
		$dsabaddon = "delete from sabreseller where addon_id=$addonid";
		mysql_query($dsabaddon);
		
		$isabaddon = "insert into sabreseller (addon_id,product_id) values ($addonid,$value)";
		mysql_query($isabaddon);
		
	}
}



//GETTING LIST OF ALL AVAILABLE PRODUCTS
$getproducts = "select * from tblproducts where servertype='siteautobackup'";
$rs_getproducts = mysql_query($getproducts);
$sabp = mysql_num_rows($rs_getproducts);

while($row = mysql_fetch_array($rs_getproducts, MYSQL_ASSOC))
{
	$id = $row['id'];
	$name = $row['name'];
	$options = $options."<option value=\"$id\">$name";
}

$orgoptions = $options;

if($sabp >0){
print <<<EndOfHtml
	<form action="$modulelink" method="post">
<font size="3">Associate each Backup AddOn to a SiteAutoBackup Product below:</font><br /><br />
EndOfHtml;


//GETTING LIST OF ALL AVAILABLE ADDONS
$getaddons = "select * from tbladdons";
$rs_getaddons = mysql_query($getaddons);

while($row = mysql_fetch_array($rs_getaddons, MYSQL_ASSOC))
{
	$id = $row['id'];
	$name = $row['name'];

	$sqlpid = "select product_id from sabreseller where addon_id = $id";
	$rs_sabpid = mysql_query($sqlpid);
	while($row = mysql_fetch_array($rs_sabpid, MYSQL_ASSOC)){
		$sabpid = $row['product_id'];
	}
		
	
	$options = str_replace("value=\"$sabpid\"","value=\"$sabpid\" selected",$orgoptions);
	
print <<<EndOfHtml
<strong>AddOn: $name</strong> - Product to Auto Setup: 
<select name="addon_$id">
<option value="0">--- Select Backup Product ---
$options
</select><br /><br />
EndOfHtml;

}

print <<<EndOfHtml
<input type="submit" value="Save Configuration" />
</form>
EndOfHtml;

}
else{
	print "<font size=\"3\">No SiteAutoBackup Product Found</font><br />In order to setup a SiteAutoBackup AddOn, you must first setup at
	least one SiteAutoBackup Product in your WHMCS Products.
	
	<br /><Br />
	Set that product as a FREE product and to setup automatically. 
	<Br /><Br />
	Then you can associate that SiteAutoBackup product with your SiteAutoBackup AddOn and set a price for it. 
	<br /><br />
	Whenever the AddOn is ordered, then the associated SiteAutoBackup product will be created for the client.";

}

?>