} if (isset($_REQUEST["action"]) && $_REQUEST["action"] == "vps_server_list_remove") { $q = "SELECT * FROM {$pro_mysql_vps_server_table} WHERE id='" . $_REQUEST["edithost"] . "';"; $r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error()); $a = mysql_fetch_array($r); $q = "DELETE FROM {$pro_mysql_vps_server_lists_table} WHERE hostname='" . $a["hostname"] . "' AND list_name='" . $_REQUEST["list_name"] . "';"; $r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error()); resubscribe_VPS_server_list_users($_REQUEST["list_name"]); } if (isset($_REQUEST["action"]) && $_REQUEST["action"] == "vps_server_list_add") { $q = "SELECT * FROM {$pro_mysql_vps_server_table} WHERE id='" . $_REQUEST["edithost"] . "';"; $r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error()); $a = mysql_fetch_array($r); $q = "INSERT INTO {$pro_mysql_vps_server_lists_table} (id,hostname,list_name) VALUES ('','" . $a["hostname"] . "','" . $_REQUEST["name"] . "');"; $r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error()); resubscribe_VPS_server_list_users($_REQUEST["name"]); } ///////////////////////// // Renewal managements // ///////////////////////// // Delete a pending if (isset($_REQUEST["action"]) && $_REQUEST["action"] == "delete_renewal") { $q = "DELETE FROM {$pro_mysql_pending_renewal_table} WHERE id='" . $_REQUEST["id"] . "';"; $r = mysql_query($q) or die("Cannot execute query \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said: " . mysql_error()); } // Validate a renew if (isset($_REQUEST["action"]) && $_REQUEST["action"] == "validate_renewal") { validateRenewal($_REQUEST["id"]); } // action=add_vps_to_user&vps_server_ip=66.251.193.60&vps_mem=1&vps_hdd=1&vps_duration=0000-01-00 if (isset($_REQUEST["action"]) && $_REQUEST["action"] == "add_vps_to_user") {
function VPS_Server_Subscribe_To_Lists($vps_server_hostname) { global $pro_mysql_vps_server_lists_table; $q = "SELECT * FROM {$pro_mysql_vps_server_lists_table} WHERE hostname='{$vps_server_hostname}';"; $r = mysql_query($q) or die("Cannot query : \"{$q}\" line " . __LINE__ . " file " . __FILE__ . " sql said " . mysql_error()); $n = mysql_num_rows($r); for ($i = 0; $i < $n; $i++) { $a = mysql_fetch_array($r); resubscribe_VPS_server_list_users($a["list_name"]); } }