All pastes #450981 Raw Edit

Anonymous

public php v1 · immutable
·published 2007-04-21 05:33 UTC
rendered paste body
function update_records ($id,$reseller,$server_hostname) {	$reseller_data = curl_reseller_data($id,$reseller,$server_hostname);	$diskusage = $reseller_data[1];	$disklimit = $reseller_data[2];	$bwusage = $reseller_data[3];	$bwlimit = $reseller_data[4];	$update = "UPDATE `tblhosting` SET diskusage='".$diskusage."', SET disklimit='".$disklimit."', bwusage='".$bwusage."', bwlimit='".$bwlimit."' WHERE username='".$reseller."'";	mysql_query($update) or die(mysql_error());}require "dbconnect.php";// Make a MySQL Connection$query = "SELECT server,username FROM `tblhosting` WHERE packageid IN (SELECT id FROM `tblproducts` WHERE type= 'reselleraccount')"; 	 $result = mysql_query($query) or die(mysql_error());while($row = mysql_fetch_array($result)){	$id = $row['server'];	$server_hostname = get_server_name ($id);	$reseller = $row['username'];	update_records($id,$reseller,$server_hostname);	echo $id.'<br>';	echo $server_hostname.'<br>';	echo $reseller.'<br><br>';}