Location: PHPKode > scripts > HTTP class > http-class/keymodify.php
<?php
	require_once("../common/mysql.php");
	require_once("../common/si_define.php");
	$db = &new CMySql;
	$flag = false;
	$id = 0;
	if (isset($_GET['id']))
		$id = $_GET['id'];
	
	if ($id)
	{		    
		if ($db->Connect(SI_DB_SERVER, SI_DB_LOGIN_USER, SI_DB_LOGIN_PASS))
		{
			if ($db->SelectDatabase(SI_DATABASE))
			{
				if ($expire || $bidfailed || $gesdownloads || $downloads || $enabled)
				{
					//ändern
					if ($expire!=$expiremain) {
						
						$expirespansum=$expirespan."+TO_DAYS("."'".$expire."'".")-TO_DAYS("."'".$expiremain."'".")+1";
						
						echo $expirespansum;
						echo $expire;
						echo $expiremain;
						echo $expirespansum;
						
						
						$row="ExpireSpan=".$expirespansum;
						echo $row;
						$db->UpdateRow(SI_KS_KEY_TABLE, $row, "KeyVal="."'".$id."'");
					}
					$row="InitDownloads="."'".$gesdownloads."'";
					$db->UpdateRow(SI_KS_KEY_TABLE, $row, "KeyVal="."'".$id."'");
					$row="Downloads="."'".$downloads."'";
					$db->UpdateRow(SI_KS_KEY_TABLE, $row, "KeyVal="."'".$id."'");
					$row="BIDFailed="."'".$bidfailed."'";
					$db->UpdateRow(SI_KS_KEY_TABLE, $row, "KeyVal="."'".$id."'");
					$row="Enabled="."'".$enabled."'";
					$db->UpdateRow(SI_KS_KEY_TABLE, $row, "KeyVal="."'".$id."'");
					$row="ExpireDate="."'".$expire."'";
					if($db->UpdateRow(SI_KS_KEY_TABLE, $row, "KeyVal="."'".$id."'"));
						{
						//echo "alle geändert auf Key Server";
						}
						
				}
				//löschen - erst Umleitung, löschen auf DS-Server, dann löschen auf KS-Server
				if ($del) {
				$strSelect = "SELECT ServerID FROM ".SI_KS_KEY_TABLE." WHERE KeyVal=".$db->MakeSqlString($id);
				if ($result =$db->Select($strSelect)) 
				{
					$data =$db->FetchArray($result);
					$serverid =$data['ServerID'];
					
					$strSelect = "SELECT ID, DNS, HTTP_User, HTTP_Pass, HTTP_InternPhpDir FROM ".SI_KS_SERVER_TABLE." WHERE ID=".$db->MakeSqlString($serverid);
					if ($result = $db->Select($strSelect))
					{
						//echo "löschen u. ändern auf DServer";
						require_once("../common/http.php");
						require_once("../common/sihelper.php");
						$http = &new CHttp;
						if ($serverData = $db->FetchArray($result))
						{
							$flag = false;
							$http->user = $serverData['HTTP_User'];
							$http->pass = $serverData['HTTP_Pass'];
							$http->server = $serverData['DNS'];
							$array['id'] = $id;
							$array['expire'] = $expire;
							$array['downloads'] = $downloads;
							$array['bidfailed'] = $bidfailed;
							$array['keyproperties'] = $keyproperties;
							$array['bid'] = $bid;
							$array['bidgenau'] = $bidgenau;
							$array['enabled'] = $enabled;
							$array['del'] = $del;
							if ($http->RequestFile($serverData['HTTP_InternPhpDir'].SI_KSDS_PROPERTIES, $response, $array) && IsResponseOk($response))
								$flag = true;
							echo $response;
									//echo $serverData['DNS'].$serverData['HTTP_InternPhpDir'].SI_KSDS_PROPERTIES;
						}
					}
				}	
				//löschen auf Keyserver
				$strSelect = "DELETE FROM ".SI_KS_KEY_TABLE." WHERE KeyVal=".$db->MakeSqlString($id);
									//echo $strSelect."löschen auf KSserver";
									if ($db->Select($strSelect)===true)
										{
											//echo "gelöscht auf KS-Server";
										}	
				}
								
				//Suche Datenserver
				//bei Änderung der Daten relevant - Umleitung auf Datenserver
				$strSelect = "SELECT ServerID FROM ".SI_KS_KEY_TABLE." WHERE KeyVal=".$db->MakeSqlString($id);
				if ($result =$db->Select($strSelect)) 
				{
					$data =$db->FetchArray($result);
					$serverid =$data['ServerID'];
					
					$strSelect = "SELECT ID, DNS, HTTP_User, HTTP_Pass, HTTP_InternPhpDir FROM ".SI_KS_SERVER_TABLE." WHERE ID=".$db->MakeSqlString($serverid);
					if ($result = $db->Select($strSelect))
					{
						
						require_once("../common/http.php");
						require_once("../common/sihelper.php");
						$http = &new CHttp;
						if ($serverData = $db->FetchArray($result))
						{
							$flag = false;
							$http->user = $serverData['HTTP_User'];
							$http->pass = $serverData['HTTP_Pass'];
							$http->server = $serverData['DNS'];
							$array['id'] = $id;
							$array['expire'] = $expire;
							$array['downloads'] = $downloads;
							$array['bidfailed'] = $bidfailed;
							$array['bid'] = $bid;
							$array['bidgenau'] = $bidgenau;
							$array['keyproperties'] = $keyproperties;
							$array['enabled'] = $enabled;
							$array['del'] = $del;
							$array['mod'] = $mod;
							if ($http->RequestFile($serverData['HTTP_InternPhpDir'].SI_KSDS_PROPERTIES, $response, $array) && IsResponseOk($response))
								$flag = true;
							echo $response;
									//echo $serverData['DNS'].$serverData['HTTP_InternPhpDir'].SI_KSDS_PROPERTIES;
						}
					}
				}
			}
		}
	}
	require_once("keyprop.php");	
	
?>
Return current item: HTTP class