Development

Navigation

← Previous Changeset
Next Changeset →

Changeset 1287

Timestamp:

07/21/08 23:29:32 (4 months ago)

Author:

scitech

Message:

* Corrected link for update hosting plan in ispcp/gui/themes/omega_original/client/hosting_plan_update.tpl "
* Corrected output for subdomain mail in ispcp/gui/client/mail_accounts.php * Remove residual data from table on user remove.

Files:

trunk/CHANGELOG (modified) (1 diff)
trunk/gui/admin/user_delete.php (modified) (1 diff)
trunk/gui/client/mail_accounts.php (modified) (9 diffs)
trunk/gui/include/admin-functions.php (modified) (3 diffs)
trunk/gui/themes/omega_original/client/hosting_plan_update.tpl (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

trunk/CHANGELOG

r1286	r1287
1	1	ispCP ω 1.0.0 Changelog
2	2	~~~~~~~~~~~~~~~~~~~~~~~~~~~
	3
	4	2008-07-21 Daniel Andreca
	5	- GUI:
	6	* Corrected link for update hosting plan in ispcp/gui/themes/omega_original/client/hosting_plan_update.tpl
	7	* Corrected output for subdomain mail in ispcp/gui/client/mail_accounts.php
	8	* Remove residual data from table on user remove.
3	9
4	10	2008-07-21 Daniel Andreca

trunk/gui/admin/user_delete.php

r1263	r1287
26	26
27	27	if (!isset($_GET['delete_id']) or !is_numeric($_GET['delete_id'])) {
28		header( "Location: manage_users.php" );
29		die();
	28	header( "Location: manage_users.php" );
	29	die();
30	30	}
31	31
32	32	$delete_id = $_GET['delete_id'];
33	33
34		$query = <<<SQL_QUERY
35		select
36		admin_type
37		from
38		admin
39		where
40		admin_id=?
41		SQL_QUERY;
	34	$query = "SELECT `admin_type` FROM `admin` WHERE `admin_id`=?";
	35
42	36	$rs = exec_query($sql, $query, array($delete_id));
43	37
44	38	$local_admin_type = $rs->fields['admin_type'];
45	39
	40	if ($local_admin_type == 'admin' \|\| $local_admin_type == 'reseller') {
	41	$query = "SELECT count(`admin_id`) as children FROM `admin` WHERE `created_by` = ?";
	42	$rs = exec_query($sql, $query, array($delete_id));
	43	if ($rs->fields['children'] > 0) {
	44	/* this user have domain ! */
	45	$hdomain = 1;
	46	$_SESSION['hdomain'] = 1;
	47	header("Location: manage_users.php");
	48	die();
	49	}
	50	}
	51
46	52	if ($local_admin_type == 'admin') {
47		$query = <<<SQL_QUERY
48		select
49		count(admin_id) as children
50		from
51		admin
52		where
53		created_by = ?
54		SQL_QUERY;
55
	53	$query = "DELETE FROM `email_tpls` WHERE `owner_id` = ? AND `name` = 'add-user-auto-msg'";
	54	$rs = exec_query($sql, $query, array($delete_id));
	55
	56	remove_users_common_properties($delete_id);
	57
56	58	} else if ($local_admin_type == 'reseller') {
57		$query = <<<SQL_QUERY
58		select
59		count(admin_id) as children from admin
60		where
61		created_by = ?
62		SQL_QUERY;
63
64		} else if ($local_admin_type == 'user') {
65		$query = <<<SQL_QUERY
66		select
67		count(domain_id) as children from domain
68		where
69		domain_admin_id = ?
70		SQL_QUERY;
71
72		}
73		$rs = exec_query($sql, $query, array($delete_id));
74
75		if ($rs->fields['children'] > 0 && $local_admin_type !== 'user') {
76		/* this user have domain ! */
77		$hdomain = 1;
78		$_SESSION['hdomain'] = 1;
79		header("Location: manage_users.php");
80		die();
81		} else {
82		if ($local_admin_type == 'admin') {
83		$query = <<<SQL_QUERY
84		delete
85		from email_tpls
86		where
87		owner_id = ? and
88		name = 'add-user-auto-msg'
89		SQL_QUERY;
90		$rs = exec_query($sql, $query, array($delete_id));
91
92		} else if ($local_admin_type == 'reseller') {
93		$query = <<<SQL_QUERY
94		delete
95		from email_tpls
96		where
97		owner_id = ? and
98		name = 'add-user-auto-msg'
99		SQL_QUERY;
100		$rs = exec_query($sql, $query, array($delete_id));
101
102		$query = <<<SQL_QUERY
103		delete
104		from reseller_props
105		where
106		reseller_id = ?
107		SQL_QUERY;
	59	$query = "DELETE FROM `email_tpls` WHERE `owner_id` = ? AND `name` = 'add-user-auto-msg'";
	60	$rs = exec_query($sql, $query, array($delete_id));
	61
	62	$query = "DELETE FROM `reseller_props` WHERE `reseller_id` = ?";
108	63	$rs = exec_query($sql, $query, array($delete_id));
109	64
110	65	// delete orders
111		$query = <<<SQL_QUERY
112		delete from
113		orders
114		where
115		user_id = ?
116
117		SQL_QUERY;
	66	$query = "DELETE FROM `orders` WHERE `user_id` = ?";
118	67	$rs = exec_query($sql, $query, array($delete_id));
119	68
120	69	// delete orders settings
121		$query = <<<SQL_QUERY
122		delete from
123		orders_settings
124		where
125		user_id = ?
126
127		SQL_QUERY;
	70	$query = "DELETE FROM `orders_settings` WHERE `user_id` = ?";
128	71	$rs = exec_query($sql, $query, array($delete_id));
129	72
	73	$query = "DELETE FROM `hosting_plans` WHERE `reseller_id` = ?";
	74	$rs = exec_query($sql, $query, array($delete_id));
	75
	76	remove_users_common_properties($delete_id);
130	77
131		$query = <<<SQL_QUERY
132		delete
133		from hosting_plans
134		where
135		reseller_id = ?
136		SQL_QUERY;
137		$rs = exec_query($sql, $query, array($delete_id));
138
139		} else if ($local_admin_type == 'user') {
140		rm_rf_user_account($delete_id);
141		check_for_lock_file();
142		send_request();
143		}
144
145		$query = <<<SQL_QUERY
146		delete
147		from admin
148		where
149		admin_id = ?
150		SQL_QUERY;
151		$rs = exec_query($sql, $query, array($delete_id));
152
153		$query = <<<SQL_QUERY
154		delete
155		from user_gui_props
156		where
157		user_id = ?
158		SQL_QUERY;
159		$rs = exec_query($sql, $query, array($delete_id));
160		$user_logged= $_SESSION['user_logged'];
161		$local_admin_name = $_GET['delete_username'];
162		write_log("$user_logged: deletes user $local_admin_name, $local_admin_type, $delete_id!");
163		$_SESSION['user_deleted'] = 1;
164		header("Location: manage_users.php");
165		die();
	78	} else if ($local_admin_type == 'user') {
	79	rm_rf_user_account($delete_id);
	80	check_for_lock_file();
	81	send_request();
166	82	}
167	83
	84	$user_logged= $_SESSION['user_logged'];
	85	$local_admin_name = $_GET['delete_username'];
	86	write_log("$user_logged: deletes user $local_admin_name, $local_admin_type, $delete_id!");
	87	$_SESSION['user_deleted'] = 1;
	88	header("Location: manage_users.php");
	89	die();
168	90	?>

trunk/gui/client/mail_accounts.php

r1272	r1287
36	36
37	37	$tpl->assign(
38		array('TR_CLIENT_MANAGE_USERS_PAGE_TITLE' => tr('ispCP - Client/Manage Users'),
39		'THEME_COLOR_PATH' => "../themes/$theme_color",
40		'THEME_CHARSET' => tr('encoding'),
41		'ISP_LOGO' => get_logo($_SESSION['user_id'])
42		)
43		);
	38	array('TR_CLIENT_MANAGE_USERS_PAGE_TITLE' => tr('ispCP - Client/Manage Users'),
	39	'THEME_COLOR_PATH' => "../themes/$theme_color",
	40	'THEME_CHARSET' => tr('encoding'),
	41	'ISP_LOGO' => get_logo($_SESSION['user_id'])
	42	)
	43	);
44	44
45	45	// page functions.
…	…
58	58	if ($mail_auto_respond == false) {
59	59	$tpl->assign(
60		array('AUTO_RESPOND_DISABLE' => tr('Enable'),
61		'AUTO_RESPOND_DISABLE_SCRIPT' => "mail_autoresponder_enable.php?id=$mail_id",
62		'AUTO_RESPOND_EDIT' => '',
63		'AUTO_RESPOND_EDIT_SCRIPT' => '',
64		'AUTO_RESPOND_VIS' => 'inline'
	60	array('AUTO_RESPOND_DISABLE' => tr('Enable'),
	61	'AUTO_RESPOND_DISABLE_SCRIPT' => "mail_autoresponder_enable.php?id=$mail_id",
	62	'AUTO_RESPOND_EDIT' => '',
	63	'AUTO_RESPOND_EDIT_SCRIPT' => '',
	64	'AUTO_RESPOND_VIS' => 'inline'
65	65	));
66	66	} else {
67	67	$tpl->assign(
68		array('AUTO_RESPOND_DISABLE' => tr('Disable'),
69		'AUTO_RESPOND_DISABLE_SCRIPT' => "mail_autoresponder_disable.php?id=$mail_id",
70		'AUTO_RESPOND_EDIT' => tr('Edit'),
71		'AUTO_RESPOND_EDIT_SCRIPT' => "mail_autoresponder_edit.php?id=$mail_id",
	68	array('AUTO_RESPOND_DISABLE' => tr('Disable'),
	69	'AUTO_RESPOND_DISABLE_SCRIPT' => "mail_autoresponder_disable.php?id=$mail_id",
	70	'AUTO_RESPOND_EDIT' => tr('Edit'),
	71	'AUTO_RESPOND_EDIT_SCRIPT' => "mail_autoresponder_edit.php?id=$mail_id",
72	72	'AUTO_RESPOND_VIS' => 'inline'
73		));
	73	));
74	74	}
75	75	} else {
…	…
80	80	'AUTO_RESPOND_EDIT_SCRIPT' => '',
81	81	'AUTO_RESPOND_VIS' => 'inline'
82		));
	82	));
83	83	}
84	84	} else {
85	85	$tpl->assign(
86		array('AUTO_RESPOND_DISABLE' => tr('Please wait for update'),
87		'AUTO_RESPOND_DISABLE_SCRIPT' => '',
88		'AUTO_RESPOND_EDIT' => '',
89		'AUTO_RESPOND_EDIT_SCRIPT' => '',
90		'AUTO_RESPOND_VIS' => 'none'
91		));
	86	array('AUTO_RESPOND_DISABLE' => tr('Please wait for update'),
	87	'AUTO_RESPOND_DISABLE_SCRIPT' => '',
	88	'AUTO_RESPOND_EDIT' => '',
	89	'AUTO_RESPOND_EDIT_SCRIPT' => '',
	90	'AUTO_RESPOND_VIS' => 'none'
	91	));
92	92	}
93	93	}
94	94
95	95	function gen_page_dmn_mail_list(&$tpl, &$sql, $dmn_id, $dmn_name) {
96		$dmn_query = ~~<<<SQL_QUERY~~
97		SELECT
98		~~mail_id, mail_acc, mail_type, status, mail_auto_respond~~
99		FROM
100		~~mail_users~~
101		WHERE
102		~~domain_id~~ = ?
103		AND
104		~~sub_id~~ = 0
105		AND
106		(~~mail_type LIKE '%normal_mail%' OR mail_type~~ LIKE '%normal_forward%')
107		ORDER BY
108		~~mail_acc~~ ASC,
109		~~mail_type~~ DESC
110		~~SQL_QUERY~~;
	96	$dmn_query ="
	97	SELECT
	98	`mail_id`, `mail_acc`, `mail_type`, `status`, `mail_auto_respond`
	99	FROM
	100	`mail_users`
	101	WHERE
	102	`domain_id` = ?
	103	AND
	104	`sub_id` = 0
	105	AND
	106	(`mail_type` LIKE '%normal_mail%' OR `mail_type` LIKE '%normal_forward%')
	107	ORDER BY
	108	`mail_acc` ASC,
	109	`mail_type` DESC
	110	";
111	111
112	112	$rs = exec_query($sql, $dmn_query, array($dmn_id));
…	…
135	135
136	136	$tpl->assign(
137		array(
138		~~'MAIL_ACC'~~ => $mail_acc . "@" . $show_dmn_name,
139		~~'MAIL_TYPE'~~ => $mail_type,
140		~~'MAIL_STATUS'~~ => translate_dmn_status($rs->fields['status']),
141		~~'MAIL_ACTION'~~ => $mail_action,
142		~~'MAIL_ACTION_SCRIPT'~~ => $mail_action_script,
143		~~'MAIL_EDIT_SCRIPT'~~ => $mail_edit_script
144		)
145		);
	137	array(
	138	'MAIL_ACC' => $mail_acc . "@" . $show_dmn_name,
	139	'MAIL_TYPE' => $mail_type,
	140	'MAIL_STATUS' => translate_dmn_status($rs->fields['status']),
	141	'MAIL_ACTION' => $mail_action,
	142	'MAIL_ACTION_SCRIPT'=> $mail_action_script,
	143	'MAIL_EDIT_SCRIPT' => $mail_edit_script
	144	)
	145	);
146	146
147	147	gen_user_mail_auto_respond($tpl,
…	…
162	162
163	163	function gen_page_sub_mail_list(&$tpl, &$sql, $dmn_id, $dmn_name) {
164		$sub_query = ~~<<<SQL_QUERY~~
165		SELECT
166		~~t1.subdomain_id~~ AS sub_id,
167		~~t1.subdomain_name~~ AS sub_name,
168		~~t2.mail_id~~,
169		~~t2.mail_acc~~,
170		~~t2.mail_type~~,
171		~~t2.status~~,
172		t2.mail_auto_respond
173		FROM
174		~~subdomain~~ AS t1,
175		~~mail_users~~ AS t2
176		WHERE
177		~~t1.domain_id~~ = ?
178		AND
179		~~t2.domain_id~~ = ?
180		AND
181		~~(t2.mail_type LIKE '%subdom_mail%' OR t2.mail_type~~ LIKE '%subdom_forward%')
182		AND
183		t1.subdomain_id = t2.sub_id
184		ORDER BY
185		~~t2.mail_acc~~ ASC,
186		t2.~~mail_type~~ DESC
187		~~SQL_QUERY~~;
	164	$sub_query = "
	165	SELECT
	166	t1.`subdomain_id` AS sub_id,
	167	t1.`subdomain_name` AS sub_name,
	168	t2.`mail_id`,
	169	t2.`mail_acc`,
	170	t2.`mail_type`,
	171	t2.`status`,
	172	t2.`mail_auto_respond`
	173	FROM
	174	`subdomain` AS t1,
	175	`mail_users` AS t2
	176	WHERE
	177	t1.`domain_id` = ?
	178	AND
	179	t2.`domain_id` = ?
	180	AND
	181	(t2.`mail_type` LIKE '%subdom_mail%' OR t2.`mail_type` LIKE '%subdom_forward%')
	182	AND
	183	t1.`subdomain_id` = t2.`sub_id`
	184	ORDER BY
	185	t2.`mail_acc` ASC,
	186	t2.`mail_type` DESC
	187	";
188	188
189	189	$rs = exec_query($sql, $sub_query, array($dmn_id, $dmn_id));
…	…
216	216
217	217	$tpl->assign(
218		array('MAIL_ACC' => $mail_acc . "@" . $show_sub_name . "." . $show_dmn_name,
219		'MAIL_TYPE' ~~=> user_trans_mail_type($rs->fields['mail_type'])~~,
220		'MAIL_STATUS' ~~=> $mail_type~~,
221		'MAIL_ACTION' => $mail_action,
222		'MAIL_ACTION_SCRIPT' => $mail_action_script,
223		'MAIL_EDIT_SCRIPT' => $mail_edit_script
224		)
225		);
	218	array('MAIL_ACC' => $mail_acc . "@" . $show_sub_name . "." . $show_dmn_name,
	219	'MAIL_TYPE' => $mail_type,
	220	'MAIL_STATUS' => translate_dmn_status($rs->fields['status']),
	221	'MAIL_ACTION' => $mail_action,
	222	'MAIL_ACTION_SCRIPT'=> $mail_action_script,
	223	'MAIL_EDIT_SCRIPT' => $mail_edit_script
	224	)
	225	);
226	226
227	227	gen_user_mail_auto_respond($tpl,
…	…
243	243	function gen_page_als_mail_list(&$tpl, &$sql, $dmn_id, $dmn_name) {
244	244	$als_query = <<<SQL_QUERY
245		SELECT
246		~~t1.alias_id~~ AS als_id,
247		~~t1.alias_name~~ AS als_name,
248		~~t2.mail_id~~,
249		~~t2.mail_acc~~,
250		~~t2.mail_type~~,
251		~~t2.status~~,
252		t2.mail_auto_respond
253		FROM
254		~~domain_aliasses~~ AS t1,
255		~~mail_users~~ AS t2
256		WHERE
257		~~t1.domain_id~~ = ?
258		AND
259		~~t2.domain_id~~ = ?
260		AND
261		t1.alias_id = t2.sub_id
262		AND
263		~~(t2.mail_type LIKE '%alias_mail%' OR t2.mail_type~~ LIKE '%alias_forward%')
264		ORDER BY
265		~~t2.mail_acc~~ ASC,
266		~~t2.mail_type~~ DESC
	245	SELECT
	246	t1.`alias_id` AS als_id,
	247	t1.`alias_name` AS als_name,
	248	t2.`mail_id`,
	249	t2.`mail_acc`,
	250	t2.`mail_type`,
	251	t2.`status`,
	252	t2.`mail_auto_respond`
	253	FROM
	254	`domain_aliasses` AS t1,
	255	`mail_users` AS t2
	256	WHERE
	257	t1.`domain_id` = ?
	258	AND
	259	t2.`domain_id` = ?
	260	AND
	261	t1.`alias_id` = t2.`sub_id`
	262	AND
	263	(t2.`mail_type` LIKE '%alias_mail%' OR t2.`mail_type` LIKE '%alias_forward%')
	264	ORDER BY
	265	t2.`mail_acc` ASC,
	266	t2.`mail_type` DESC
267	267	SQL_QUERY;
268	268
…	…
295	295	$tpl->assign(
296	296	array(
297		'MAIL_ACC' => $mail_acc . "@" . $show_als_name,
298		'MAIL_TYPE' => $mail_type,
299		'MAIL_STATUS' => translate_dmn_status($rs->fields['status']),
300		'MAIL_ACTION' => $mail_action,
301		'MAIL_ACTION_SCRIPT' => $mail_action_script,
302		'MAIL_EDIT_SCRIPT' => $mail_edit_script
	297	'MAIL_ACC' => $mail_acc . "@" . $show_als_name,
	298	'MAIL_TYPE' => $mail_type,
	299	'MAIL_STATUS' => translate_dmn_status($rs->fields['status']),
	300	'MAIL_ACTION' => $mail_action,
	301	'MAIL_ACTION_SCRIPT'=> $mail_action_script,
	302	'MAIL_EDIT_SCRIPT' => $mail_edit_script
303	303	)
304	304	);
…	…
362	362	'MAIL_ITEM' => '',
363	363	'MAILS_TOTAL' => ''
364		)
365		);
	364	)
	365	);
366	366
367	367	$tpl->parse('MAIL_MESSAGE', 'mail_message');

trunk/gui/include/admin-functions.php

r1279	r1287
1993	1993	function rm_rf_user_account($id_user) {
1994	1994	$sql = Database::getInstance();
	1995
1995	1996	// get domain user data
1996		$query = ~~<<<SQL_QUERY~~
	1997	$query = "
1997	1998	SELECT
1998		~~domain_id~~,
1999		~~domain_name~~,
2000		~~domain_gid~~,
2001		~~domain_created_id~~
	1999	`domain_id`,
	2000	`domain_name`,
	2001	`domain_gid`,
	2002	`domain_created_id`
2002	2003	FROM
2003		~~domain~~
	2004	`domain`
2004	2005	WHERE
2005		domain_admin_id = ?
2006		SQL_QUERY;
2007
	2006	`domain_admin_id` = ?
	2007	";
2008	2008	$rs = exec_query($sql, $query, array($id_user));
2009	2009
…	…
2017	2017	// fist we'll delete all FTP Accounts
2018	2018	// delete all FTP Accounts
2019		$query = <<<SQL_QUERY
2020		DELETE FROM
2021		ftp_users
2022		WHERE
2023		gid = ?
2024		SQL_QUERY;
	2019	$query = "DELETE FROM `ftp_users` WHERE `gid` = ?";
2025	2020	$rs = exec_query($sql, $query, array($domain_gid));
2026	2021
2027		~~while (!$rs->EOF) {~~
2028		~~$rs->MoveNext();~~
2029		}
2030	2022	// delete the group
2031		$query = <<<SQL_QUERY
2032		DELETE FROM
2033		ftp_group
2034		WHERE
2035		gid = ?
2036		SQL_QUERY;
	2023	$query = "DELETE FROM `ftp_group` WHERE `gid` = ?";
2037	2024	$rs = exec_query($sql, $query, array($domain_gid));
	2025
2038	2026	// let's delete all Subdomains for this user
2039	2027	$delete_status = Config::get('ITEM_DELETE_STATUS');
2040
2041		$query = <<<SQL_QUERY
2042		UPDATE
2043		subdomain
2044		SET
2045		subdomain_status = ?
2046		WHERE
2047		domain_id = ?
2048		SQL_QUERY;
	2028	$query = "UPDATE `subdomain` SET `subdomain_status` = ? WHERE `domain_id` = ?";
2049	2029	$rs = exec_query($sql, $query, array($delete_status, $domain_id));
	2030
2050	2031	// let's delete all domain aliases for this user
2051		$query = <<<SQL_QUERY
2052		UPDATE
2053		domain_aliasses
2054		SET
2055		alias_status = ?
2056		WHERE
2057		domain_id = ?
2058		SQL_QUERY;
	2032	$query = "UPDATE `domain_aliasses` SET `alias_status` = ? WHERE `domain_id` = ?";
2059	2033	$rs = exec_query($sql, $query, array($delete_status, $domain_id));
2060	2034
2061		~~while (!$rs->EOF) {~~
2062		~~$rs->MoveNext();~~
2063		}
2064	2035	// let's delete all mail accounts for this user
2065		$query = <<<SQL_QUERY
2066		UPDATE
2067		mail_users
2068		SET
2069		status = ?
2070		WHERE
2071		domain_id = ?
2072		SQL_QUERY;
2073
	2036	$query = "UPDATE `mail_users` SET `status` = ? WHERE `domain_id` = ?";
2074	2037	$rs = exec_query($sql, $query, array($delete_status, $domain_id));
	2038
2075	2039	// delete all htaccess entries for this user
2076		$query = <<<SQL_QUERY
2077		DELETE FROM
2078		htaccess
2079		WHERE
2080		dmn_id = ?
2081		SQL_QUERY;
	2040	$query = "DELETE FROM `htaccess` WHERE `dmn_id` = ?";
2082	2041	$rs = exec_query($sql, $query, array($domain_id));
2083	2042
2084		$query = <<<SQL_QUERY
2085		DELETE FROM
2086		htaccess_groups
2087		WHERE
2088		dmn_id = ?
2089		SQL_QUERY;
	2043	$query = "DELETE FROM `htaccess_groups` WHERE `dmn_id` = ?";
2090	2044	$rs = exec_query($sql, $query, array($domain_id));
2091	2045
2092		$query = <<<SQL_QUERY
2093		DELETE FROM
2094		htaccess_users
2095		WHERE
2096		dmn_id = ?
2097		SQL_QUERY;
	2046	$query = "DELETE FROM `htaccess_users` WHERE `dmn_id` = ?";
2098	2047	$rs = exec_query($sql, $query, array($domain_id));
2099	2048	// end of delete htaccess entires
2100		while (!$rs->EOF) {
2101		$rs->MoveNext();
2102		}
	2049
	2050	//delete asociated traffic
	2051	$query = "DELETE FROM `domain_traffic` WHERE `domain_id` = ?";
	2052	$rs = exec_query($sql, $query, array($domain_id));
	2053
	2054	//delete error pages
	2055	$query = "DELETE FROM `error_pages` WHERE `user_id` = ?";
	2056	$rs = exec_query($sql, $query, array($id_user));
	2057
	2058	//delete quotalimits
	2059	$query = "DELETE FROM `quotalimits` WHERE `name` = ?";
	2060	$rs = exec_query($sql, $query, array($domain_name));
	2061
	2062	//delete quotatallies
	2063	$query = "DELETE FROM `quotatallies` WHERE `name` = ?";
	2064	$rs = exec_query($sql, $query, array($domain_name));
	2065
2103	2066	// Lets Delete SQL DBs and Users
2104		$query = <<<SQL_QUERY
2105		SELECT
2106		sqld_id
2107		FROM
2108		sql_database
2109		WHERE
2110		domain_id = ?
2111		SQL_QUERY;
	2067	$query = "SELECT `sqld_id` FROM `sql_database` WHERE `domain_id` = ?";
2112	2068	$rs = exec_query($sql, $query, array($domain_id));
	2069
2113	2070	while (!$rs->EOF) {
2114	2071	$db_id = $rs->fields['sqld_id'];
…	…
2120	2077	// BEGIN - DELETE ALL GUI ENTRIES FOR THIS USER
2121	2078	// delete the layout settings
2122		$query = <<<SQL_QUERY
2123		DELETE FROM
2124		user_gui_props
2125		WHERE
2126		user_id = ?
2127		SQL_QUERY;
	2079
	2080	// delete all tickets for this user
	2081	$query = "DELETE FROM `tickets` WHERE `ticket_from` = ? OR `ticket_to` = ?";
	2082	$rs = exec_query($sql, $query, array($id_user, $id_user));
	2083
	2084	// let's delete the main domain for this user
	2085	$query = "UPDATE `domain` SET `domain_status` = ? WHERE `domain_admin_id` = ?";
	2086	$rs = exec_query($sql, $query, array($delete_status, $id_user));
	2087
	2088	remove_users_common_properties($id_user);
	2089	}
	2090
	2091	function remove_users_common_properties($id_user) {
	2092	$sql = Database::getInstance();
	2093
	2094	$query = "DELETE FROM `admin` WHERE `admin_id` = ?";
2128	2095	$rs = exec_query($sql, $query, array($id_user));
2129		// update reseller props
2130		// delete all tickets for this user
2131		$query = <<<SQL_QUERY
2132		DELETE FROM
2133		tickets
2134		WHERE
2135		ticket_from = ?
2136		OR
2137		ticket_to = ?
2138		SQL_QUERY;
2139		$rs = exec_query($sql, $query, array($id_user, $id_user));
2140		// let's delete the main domain for this user
2141		$query = <<<SQL_QUERY
2142		UPDATE
2143		domain
2144		SET
2145		domain_status = ?
2146		WHERE
2147		domain_admin_id = ?
2148		SQL_QUERY;
2149		$rs = exec_query($sql, $query, array($delete_status, $id_user));
2150		// delete the user acount
2151		$query = <<<SQL_QUERY
2152		DELETE FROM
2153		admin
2154		WHERE
2155		admin_id = ?
2156		SQL_QUERY;
	2096
	2097	$query = "DELETE FROM `user_gui_props` WHERE `user_id` = ?";
2157	2098	$rs = exec_query($sql, $query, array($id_user));
2158	2099	}

trunk/gui/themes/omega_original/client/hosting_plan_update.tpl

r1265	r1287
64	64	<tr>
65	65	<td> </td>
66		<td class="content3"><img src="{THEME_COLOR_PATH}/images/icons/details.png" width="18" height="18" border="0" align="absmiddle"> <a href="~~update_hosting_plan~~.php?{LINK}={ID}" class="linkdark">{TR_PURCHASE}</a></td>
	66	<td class="content3"><img src="{THEME_COLOR_PATH}/images/icons/details.png" width="18" height="18" border="0" align="absmiddle"> <a href="hosting_plan_update.php?{LINK}={ID}" class="linkdark">{TR_PURCHASE}</a></td>
67	67	</tr>
68	68	<!-- EDP: hosting_plans -->

Download in other formats: