Changeset 1291
- Timestamp:
- 08/03/08 20:56:25
(4 months ago)
- Author:
- scitech
- Message:
Fixed #1079: Error adding user when opening new tab/window
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r1290 |
r1291 |
|
| 1 | 1 | ispCP ω 1.0.0 Changelog |
|---|
| 2 | 2 | ~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|---|
| | 3 | |
|---|
| | 4 | 2008-08-03 Daniel Andreca |
|---|
| | 5 | - GUI: |
|---|
| | 6 | * Fixed #1079: Error adding user when opening new tab/window |
|---|
| 3 | 7 | |
|---|
| 4 | 8 | 2008-08-02 Benedikt Heintel |
|---|
| r1241 |
r1291 |
|
| 356 | 356 | $glToUnset[] = 'step_two_data'; |
|---|
| 357 | 357 | $glToUnset[] = 'ch_hpprops'; |
|---|
| 358 | | $glToUnset[] = 'rau3_added'; |
|---|
| | 358 | $glToUnset[] = 'user_add3_added'; |
|---|
| 359 | 359 | $glToUnset[] = 'user_has_domain'; |
|---|
| 360 | 360 | $glToUnset[] = 'local_data'; |
|---|
| … | … | |
| 378 | 378 | |
|---|
| 379 | 379 | foreach ($glToUnset as $toUnset) { |
|---|
| 380 | | if (isset($GLOBALS[$toUnset])) |
|---|
| | 380 | if (array_key_exists($toUnset,$GLOBALS)) |
|---|
| 381 | 381 | unset($GLOBALS[$toUnset]); |
|---|
| 382 | 382 | } |
|---|
| … | … | |
| 385 | 385 | $sessToUnset[] = 'reseller_added'; |
|---|
| 386 | 386 | $sessToUnset[] = 'dmn_name'; |
|---|
| 387 | | $sessToUnset[] = 'rau3_added'; |
|---|
| | 387 | $sessToUnset[] = 'dmn_tpl'; |
|---|
| | 388 | $sessToUnset[] = 'chtpl'; |
|---|
| | 389 | $sessToUnset[] = 'step_one'; |
|---|
| | 390 | $sessToUnset[] = 'step_two_data'; |
|---|
| | 391 | $sessToUnset[] = 'ch_hpprops'; |
|---|
| | 392 | $sessToUnset[] = 'user_add3_added'; |
|---|
| 388 | 393 | $sessToUnset[] = 'user_has_domain'; |
|---|
| 389 | 394 | $sessToUnset[] = 'user_added'; |
|---|
| … | … | |
| 404 | 409 | |
|---|
| 405 | 410 | foreach ($sessToUnset as $toUnset) { |
|---|
| 406 | | if (isset($_SESSION[$toUnset])) |
|---|
| | 411 | if (array_key_exists($toUnset,$_SESSION)) |
|---|
| 407 | 412 | unset($_SESSION[$toUnset]); |
|---|
| 408 | 413 | } |
|---|
| r1265 |
r1291 |
|
| 98 | 98 | |
|---|
| 99 | 99 | if (isset($_POST['dmn_name'])) { |
|---|
| 100 | | $dmn_name = strtolower($_POST['dmn_name']); |
|---|
| | 100 | $dmn_name = strtolower(trim($_POST['dmn_name'])); |
|---|
| 101 | 101 | $dmn_name = encode_idna($dmn_name); |
|---|
| 102 | 102 | } |
|---|
| … | … | |
| 163 | 163 | ) |
|---|
| 164 | 164 | ); |
|---|
| 165 | | |
|---|
| 166 | 165 | $tpl->assign('MESSAGE', ''); |
|---|
| 167 | 166 | } //End of get_empty_au1_page() |
|---|
| r1265 |
r1291 |
|
| 78 | 78 | ); |
|---|
| 79 | 79 | |
|---|
| 80 | | get_pageone_param(); |
|---|
| 81 | | |
|---|
| 82 | | if (isset($_POST['uaction']) && ("user_add2_nxt" === $_POST['uaction']) && (!isset($_SESSION['step_one_data']))) { |
|---|
| | 80 | if(!get_pageone_param()){ |
|---|
| | 81 | set_page_message(tr("Domain data has been altered. Please enter again")); |
|---|
| | 82 | unset_messages(); |
|---|
| | 83 | header("Location: user_add1.php"); |
|---|
| | 84 | die(); |
|---|
| | 85 | } |
|---|
| | 86 | |
|---|
| | 87 | if (isset($_POST['uaction']) && ("user_add2_nxt" === $_POST['uaction']) && (!isset($_SESSION['step_one']))) { |
|---|
| 83 | 88 | if (check_user_data($tpl)) { |
|---|
| 84 | 89 | $_SESSION["step_two_data"] = "$dmn_name;0;"; |
|---|
| … | … | |
| 91 | 96 | } |
|---|
| 92 | 97 | } else { |
|---|
| 93 | | unset($_SESSION['step_one_data']); |
|---|
| | 98 | unset($_SESSION['step_one']); |
|---|
| 94 | 99 | global $dmn_chp; |
|---|
| 95 | 100 | get_hp_data($dmn_chp, $_SESSION['user_id']); |
|---|
| … | … | |
| 115 | 120 | global $dmn_pt; |
|---|
| 116 | 121 | |
|---|
| 117 | | if (isset($_SESSION['dmn_name'])) |
|---|
| | 122 | if (isset($_SESSION['dmn_name'])){ |
|---|
| 118 | 123 | $dmn_name = $_SESSION['dmn_name']; |
|---|
| 119 | | |
|---|
| 120 | | if (isset($_SESSION['dmn_tpl'])) |
|---|
| | 124 | } else { |
|---|
| | 125 | return false; |
|---|
| | 126 | } |
|---|
| | 127 | |
|---|
| | 128 | if (isset($_SESSION['dmn_tpl'])){ |
|---|
| 121 | 129 | $dmn_chp = $_SESSION['dmn_tpl']; |
|---|
| 122 | | |
|---|
| 123 | | if (isset($_SESSION['chtpl'])) |
|---|
| | 130 | } else { |
|---|
| | 131 | return false; |
|---|
| | 132 | } |
|---|
| | 133 | |
|---|
| | 134 | if (isset($_SESSION['chtpl'])){ |
|---|
| 124 | 135 | $dmn_pt = $_SESSION['chtpl']; |
|---|
| | 136 | } else { |
|---|
| | 137 | return false; |
|---|
| | 138 | } |
|---|
| | 139 | |
|---|
| | 140 | return true; |
|---|
| 125 | 141 | } // End of get_pageone_param() |
|---|
| 126 | 142 | |
|---|
| … | … | |
| 274 | 290 | set_page_message(tr('Incorrect FTP accounts limit!')); |
|---|
| 275 | 291 | } |
|---|
| 276 | | if (!ispcp_limit_check($hp_sql_user, -1)) { |
|---|
| | 292 | if (!ispcp_limit_check($hp_sql_db, -1)) { |
|---|
| 277 | 293 | set_page_message(tr('Incorrect SQL databases limit!')); |
|---|
| 278 | 294 | } |
|---|
| … | … | |
| 280 | 296 | set_page_message(tr('SQL users limit is <i>disabled</i>!')); |
|---|
| 281 | 297 | } |
|---|
| 282 | | if (!ispcp_limit_check($hp_sql_db, -1)) { |
|---|
| | 298 | if (!ispcp_limit_check($hp_sql_user, -1)) { |
|---|
| 283 | 299 | set_page_message(tr('Incorrect SQL users limit!')); |
|---|
| 284 | 300 | } |
|---|
| 285 | | else if ($hp_sql_db == -1 && $hp_sql_user != -1) { |
|---|
| 286 | | set_page_message(tr('SQL databases limit is <i>disabled</i>!')); |
|---|
| | 301 | else if ($hp_sql_user == -1 && $hp_sql_db!= -1) { |
|---|
| | 302 | set_page_message(tr('SQL databases limit is not <i>disabled</i>!')); |
|---|
| 287 | 303 | } |
|---|
| 288 | 304 | if (!ispcp_limit_check($hp_traff, null)) { |
|---|
| r1265 |
r1291 |
|
| 83 | 83 | ); |
|---|
| 84 | 84 | |
|---|
| 85 | | init_in_values(); |
|---|
| | 85 | if(!init_in_values()){ |
|---|
| | 86 | set_page_message(tr("Domain data has been altered. Please enter again")); |
|---|
| | 87 | unset_messages(); |
|---|
| | 88 | header("Location: user_add1.php"); |
|---|
| | 89 | die(); |
|---|
| | 90 | } |
|---|
| | 91 | |
|---|
| 86 | 92 | // Process the action ... |
|---|
| 87 | 93 | if (isset($_POST['uaction']) && ("user_add3_nxt" === $_POST['uaction']) && !isset($_SESSION['step_two_data'])) { |
|---|
| … | … | |
| 132 | 138 | // $dmn_user_name = preg_replace("/\./", "_", $dmn_name); |
|---|
| 133 | 139 | $dmn_user_name = $dmn_name; |
|---|
| | 140 | if(!chk_dname($dmn_name) || ($hpid==''))return false; |
|---|
| | 141 | return true; |
|---|
| 134 | 142 | } // End of init_in_values() |
|---|
| 135 | 143 | |
|---|
| … | … | |
| 218 | 226 | } else { |
|---|
| 219 | 227 | if (Config::exists('HOSTING_PLANS_LEVEL') && strtolower(Config::get('HOSTING_PLANS_LEVEL')) == 'admin') { |
|---|
| 220 | | $query = 'select props from hosting_plans where id = ?'; |
|---|
| | 228 | $query = 'SELECT `props` FROM `hosting_plans` WHERE `id` = ?'; |
|---|
| 221 | 229 | $res = exec_query($sql, $query, array($hpid)); |
|---|
| 222 | 230 | } else { |
|---|
| 223 | | $query = "select props from hosting_plans where reseller_id = ? and id = ?"; |
|---|
| | 231 | $query = "SELECT `props` FROM `hosting_plans` WHERE `reseller_id` = ? AND `id` = ?"; |
|---|
| 224 | 232 | $res = exec_query($sql, $query, array($reseller_id, $hpid)); |
|---|
| 225 | 233 | } |
|---|
| … | … | |
| 254 | 262 | |
|---|
| 255 | 263 | check_for_lock_file(); |
|---|
| | 264 | /*Daniel Andreca: If this check is disabled why execute query? |
|---|
| 256 | 265 | // check again if a user like that exits |
|---|
| 257 | | $query = <<<OMEGA_SQL_QUERY |
|---|
| 258 | | select |
|---|
| 259 | | count(*) as count |
|---|
| 260 | | from |
|---|
| 261 | | admin |
|---|
| 262 | | where |
|---|
| 263 | | admin_name = ? |
|---|
| 264 | | limit 1 |
|---|
| 265 | | OMEGA_SQL_QUERY; |
|---|
| | 266 | $query = " |
|---|
| | 267 | SELECT |
|---|
| | 268 | COUNT(*) as count |
|---|
| | 269 | FROM |
|---|
| | 270 | `admin` |
|---|
| | 271 | WHERE |
|---|
| | 272 | `admin_name` = ? |
|---|
| | 273 | LIMIT 1 |
|---|
| | 274 | "; |
|---|
| 266 | 275 | |
|---|
| 267 | 276 | $res = exec_query($sql, $query, $dmn_user_name); |
|---|
| 268 | | $data = $res->FetchRow(); |
|---|
| | 277 | $data = $res->FetchRow();*/ |
|---|
| 269 | 278 | |
|---|
| 270 | 279 | /* |
|---|
| … | … | |
| 274 | 283 | }*/ |
|---|
| 275 | 284 | |
|---|
| 276 | | $query = <<<ISPCP_SQL_QUERY |
|---|
| 277 | | insert into admin |
|---|
| 278 | | ( |
|---|
| 279 | | admin_name, admin_pass, admin_type, domain_created, |
|---|
| 280 | | created_by, fname, lname, |
|---|
| 281 | | firm, zip, city, |
|---|
| 282 | | country, email, phone, |
|---|
| 283 | | fax, street1, street2, customer_id, gender |
|---|
| 284 | | ) |
|---|
| 285 | | values |
|---|
| 286 | | ( |
|---|
| 287 | | ?, ?, 'user', unix_timestamp(), |
|---|
| 288 | | ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? |
|---|
| 289 | | ) |
|---|
| 290 | | ISPCP_SQL_QUERY; |
|---|
| | 285 | $query = " |
|---|
| | 286 | INSERT INTO `admin` ( |
|---|
| | 287 | `admin_name`, `admin_pass`, `admin_type`, `domain_created`, |
|---|
| | 288 | `created_by`, `fname`, `lname`, |
|---|
| | 289 | `firm`, `zip`, `city`, |
|---|
| | 290 | `country`, `email`, `phone`, |
|---|
| | 291 | `fax`, `street1`, `street2`, `customer_id`, `gender` |
|---|
| | 292 | ) |
|---|
| | 293 | VALUES ( |
|---|
| | 294 | ?, ?, 'user', unix_timestamp(), |
|---|
| | 295 | ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? |
|---|
| | 296 | ) |
|---|
| | 297 | "; |
|---|
| 291 | 298 | |
|---|
| 292 | 299 | $res = exec_query($sql, $query, array( |
|---|
| … | … | |
| 302 | 309 | $record_id = $sql->Insert_ID(); |
|---|
| 303 | 310 | |
|---|
| 304 | | $query = <<<ISPCP_SQL_QUERY |
|---|
| 305 | | insert into domain ( |
|---|
| 306 | | domain_name, domain_admin_id, |
|---|
| 307 | | domain_created_id, domain_created, |
|---|
| 308 | | domain_mailacc_limit, domain_ftpacc_limit, |
|---|
| 309 | | domain_traffic_limit, domain_sqld_limit, |
|---|
| 310 | | domain_sqlu_limit, domain_status, |
|---|
| 311 | | domain_subd_limit, domain_alias_limit, |
|---|
| 312 | | domain_ip_id, domain_disk_limit, |
|---|
| 313 | | domain_disk_usage, domain_php, domain_cgi |
|---|
| 314 | | ) |
|---|
| 315 | | values ( |
|---|
| 316 | | ?, ?, |
|---|
| 317 | | ?, unix_timestamp(), |
|---|
| 318 | | ?, ?, |
|---|
| 319 | | ?, ?, |
|---|
| 320 | | ?, 'toadd', |
|---|
| 321 | | ?, ?, |
|---|
| 322 | | ?, ?, '0', |
|---|
| 323 | | ?, ? |
|---|
| 324 | | ) |
|---|
| 325 | | ISPCP_SQL_QUERY; |
|---|
| | 311 | $query = " |
|---|
| | 312 | INSERT INTO `domain` ( |
|---|
| | 313 | `domain_name`, `domain_admin_id`, |
|---|
| | 314 | `domain_created_id`, `domain_created`, |
|---|
| | 315 | `domain_mailacc_limit`, `domain_ftpacc_limit`, |
|---|
| | 316 | `domain_traffic_limit`, `domain_sqld_limit`, |
|---|
| | 317 | `domain_sqlu_limit`, `domain_status`, |
|---|
| | 318 | `domain_subd_limit`, `domain_alias_limit`, |
|---|
| | 319 | `domain_ip_id`, `domain_disk_limit`, |
|---|
| | 320 | `domain_disk_usage`, `domain_php`, `domain_cgi` |
|---|
| | 321 | ) |
|---|
| | 322 | VALUES ( |
|---|
| | 323 | ?, ?, |
|---|
| | 324 | ?, unix_timestamp(), |
|---|
| | 325 | ?, ?, |
|---|
| | 326 | ?, ?, |
|---|
| | 327 | ?, 'toadd', |
|---|
| | 328 | ?, ?, |
|---|
| | 329 | ?, ?, '0', |
|---|
| | 330 | ?, ? |
|---|
| | 331 | ) |
|---|
| | 332 | "; |
|---|
| 326 | 333 | |
|---|
| 327 | 334 | $res = exec_query($sql, $query, array( |
|---|
| … | … | |
| 353 | 360 | $user_theme_color = $_SESSION['user_theme']; |
|---|
| 354 | 361 | |
|---|
| 355 | | $query = <<<SQL_QUERY |
|---|
| 356 | | insert into |
|---|
| 357 | | user_gui_props |
|---|
| 358 | | (user_id, lang, layout) |
|---|
| 359 | | values |
|---|
| 360 | | (?, ?, ?) |
|---|
| 361 | | SQL_QUERY; |
|---|
| | 362 | $query = " |
|---|
| | 363 | INSERT INTO `user_gui_props` |
|---|
| | 364 | (`user_id`, `lang`, `layout`) |
|---|
| | 365 | VALUES |
|---|
| | 366 | (?, ?, ?) |
|---|
| | 367 | "; |
|---|
| 362 | 368 | |
|---|
| 363 | 369 | $res = exec_query($sql, $query, array($record_id, |
|---|
| r1265 |
r1291 |
|
| 50 | 50 | $domain_id = $_SESSION['dmn_id']; |
|---|
| 51 | 51 | |
|---|
| 52 | | $query = <<<SQL_QUERY |
|---|
| 53 | | select |
|---|
| 54 | | domain_id |
|---|
| 55 | | from |
|---|
| 56 | | domain |
|---|
| 57 | | where |
|---|
| 58 | | domain_id = ? |
|---|
| 59 | | and |
|---|
| 60 | | domain_created_id = ? |
|---|
| 61 | | SQL_QUERY; |
|---|
| | 52 | $query = " |
|---|
| | 53 | SELECT |
|---|
| | 54 | `domain_id` |
|---|
| | 55 | FROM |
|---|
| | 56 | `domain` |
|---|
| | 57 | WHERE |
|---|
| | 58 | `domain_id` = ? |
|---|
| | 59 | AND |
|---|
| | 60 | `domain_created_id` = ? |
|---|
| | 61 | "; |
|---|
| 62 | 62 | |
|---|
| 63 | 63 | $rs = exec_query($sql, $query, array($domain_id, $reseller_id)); |
|---|
| … | … | |
| 72 | 72 | $add_status = Config::get('ITEM_ADD_STATUS'); |
|---|
| 73 | 73 | |
|---|
| 74 | | $query = <<<SQL_QUERY |
|---|
| 75 | | select |
|---|
| 76 | | domain_id |
|---|
| 77 | | from |
|---|
| 78 | | domain |
|---|
| 79 | | where |
|---|
| 80 | | domain_id = ? |
|---|
| 81 | | and |
|---|
| 82 | | (domain_status = ? or domain_status = ?) |
|---|
| 83 | | SQL_QUERY; |
|---|
| | 74 | $query = " |
|---|
| | 75 | SELECT |
|---|
| | 76 | `domain_id` |
|---|
| | 77 | FROM |
|---|
| | 78 | `domain` |
|---|
| | 79 | WHERE |
|---|
| | 80 | `domain_id` = ? |
|---|
| | 81 | AND |
|---|
| | 82 | (`domain_status` = ? or `domain_status` = ?) |
|---|
| | 83 | "; |
|---|
| 84 | 84 | |
|---|
| 85 | 85 | $rs = exec_query($sql, $query, array($domain_id, $ok_status, $add_status)); |
|---|
| … | … | |
| 160 | 160 | $dmn_id = $_SESSION['dmn_id']; |
|---|
| 161 | 161 | |
|---|
| 162 | | $query = <<<SQL_QUERY |
|---|
| 163 | | select |
|---|
| 164 | | alias_id, |
|---|
| 165 | | alias_name, |
|---|
| 166 | | alias_status |
|---|
| 167 | | from |
|---|
| 168 | | domain_aliasses |
|---|
| 169 | | where |
|---|
| 170 | | domain_id = ? |
|---|
| 171 | | SQL_QUERY; |
|---|
| | 162 | $query = " |
|---|
| | 163 | SELECT |
|---|
| | 164 | `alias_id`, |
|---|
| | 165 | `alias_name`, |
|---|
| | 166 | `alias_status` |
|---|
| | 167 | FROM |
|---|
| | 168 | `domain_aliasses` |
|---|
| | 169 | WHERE |
|---|
| | 170 | `domain_id` = ? |
|---|
| | 171 | "; |
|---|
| 172 | 172 | |
|---|
| 173 | 173 | $rs = exec_query($sql, $query, array($dmn_id)); |
|---|
| … | … | |
| 227 | 227 | } |
|---|
| 228 | 228 | } else { |
|---|
| 229 | | $res = exec_query($sql, "select domain_id from domain_aliasses where alias_name=?", array($alias_name)); |
|---|
| 230 | | $res2 = exec_query($sql, "select domain_id from domain where domain_name =?", array($alias_name)); |
|---|
| | 229 | $query="SELECT `domain_id` FROM `domain_aliasses` WHERE `alias_name`=?"; |
|---|
| | 230 | $res = exec_query($sql, $query, array($alias_name)); |
|---|
| | 231 | $query="SELECT `domain_id` FROM `domain` WHERE `domain_name` =?"; |
|---|
| | 232 | $res2 = exec_query($sql, $query, array($alias_name)); |
|---|
| 231 | 233 | if ($res->RowCount() > 0 or $res2->RowCount() > 0) { |
|---|
| 232 | 234 | // we already have domain with this name |
|---|
| 233 | 235 | $err_al = tr("Domain with this name already exist"); |
|---|
| 234 | 236 | } |
|---|
| 235 | | |
|---|
| | 237 | |
|---|
| | 238 | $query="SELECT COUNT(`subdomain_id`) AS cnt FROM `subdomain` WHERE `domain_id`=? AND `subdomain_mount`=?"; |
|---|
| 236 | 239 | $subdomres = exec_query($sql, |
|---|
| 237 | | "select count(subdomain_id) as cnt from subdomain where domain_id=? and subdomain_mount=?", |
|---|
| | 240 | $query, |
|---|
| 238 | 241 | array($cr_user_id, $mount_point)); |
|---|
| 239 | 242 | $subdomdata = $subdomres->FetchRow(); |
|---|
| … | … | |
| 250 | 253 | check_for_lock_file(); |
|---|
| 251 | 254 | $status = Config::get('ITEM_ADD_STATUS'); |
|---|
| 252 | | |
|---|
| 253 | | exec_query($sql, |
|---|
| 254 | | "insert into domain_aliasses(domain_id, alias_name, alias_mount, alias_status, alias_ip_id, url_forward) values (?, ?, ?, ?, ?, ?)", |
|---|
| 255 | | array($cr_user_id, $alias_name, $mount_point, $status, $domain_ip, $forward)); |
|---|
| | 255 | |
|---|
| | 256 | $query="insert into domain_aliasses(domain_id, alias_name, alias_mount, alias_status, alias_ip_id, url_forward) values (?, ?, ?, ?, ?, ?)"; |
|---|
| | 257 | exec_query($sql, $query, array( |
|---|
| | 258 | $cr_user_id, |
|---|
| | 259 | $alias_name, |
|---|
| | 260 | $mount_point, |
|---|
| | 261 | $status, |
|---|
| | 262 | $domain_ip, |
|---|
| | 263 | $forward |
|---|
| | 264 | ) |
|---|
| | 265 | ); |
|---|
| 256 | 266 | send_request(); |
|---|
| 257 | 267 | $admin_login = $_SESSION['user_logged']; |
|---|
|