exec($sql); $data['success'] = true; $data['message'] = TRANS('OK_DEL'); $_SESSION['flash'] = message('success', '', $data['message'], ''); echo json_encode($data); return false; } catch (Exception $e) { $erro = true; } } elseif (!empty($data['action']) && ($data['action'] == 'autoconfirm' || $data['action'] == 'adminconfirm')) { $term = " utmp_rand = '" . $data['random'] . "' "; if ($data['action'] == 'adminconfirm') { $term = " utmp_cod = '" . $data['cod'] . "' "; } $sql = "SELECT * FROM utmp_usuarios WHERE {$term} "; try { $res = $conn->query($sql); $found = $res->rowCount(); if ($found) { $qryconfig = $QRY["useropencall"]; $execconfig = $conn->query($qryconfig); $rowconfig = $execconfig->fetch(); $row = $res->fetch(); $sqlchk = "SELECT user_id FROM usuarios WHERE login = '" . $row['utmp_login'] . "' "; $reschk = $conn->query($sqlchk); if ($reschk->rowCount()) { $data['success'] = false; $data['message'] = TRANS('USERNAME_ALREADY_EXISTS'); $_SESSION['flash'] = message('danger', '', $data['message'], ''); echo json_encode($data); return false; } $hash = $row['utmp_hash']; if (empty($row['utmp_hash'])) { /* usuarios gerados antes da versao do 4.x */ $hash = pass_hash($row['utmp_passwd']); } $sql = "INSERT INTO usuarios ( user_id, user_client, login, nome, hash, data_inc, data_admis, email, fone, nivel, AREA ) VALUES ( null, " . dbField($rowconfig['conf_scr_auto_client']) . ", '" . $row['utmp_login'] . "', '" . $row['utmp_nome'] . "', '" . $hash . "', '" . date("Y-m-d H:i:s") . "','" . date("Y-m-d H:i:s") . "','" . $row['utmp_email'] . "', '" . $row['utmp_phone'] . "', 3, '" . $rowconfig['conf_ownarea'] . "' ) "; try { $conn->exec($sql); // $sqlDel = "DELETE FROM utmp_usuarios WHERE utmp_rand = '".$data['random']."'"; $sqlDel = "DELETE FROM utmp_usuarios WHERE {$term} "; $conn->exec($sqlDel); $data['success'] = true; $data['message'] = TRANS('SUBSCRIPTION_CONFIRMED'); $_SESSION['flash'] = message('success', '', $data['message'], ''); echo json_encode($data); return false; } catch (Exception $e) { $erro = true; } } else { $data['success'] = false; $data['message'] = TRANS('EMAIL_CONFIRMATION_EXPIRED'); $_SESSION['flash'] = message('danger', '', $data['message'], ''); echo json_encode($data); return false; } } catch (Exception $e) { $data['success'] = false; $data['message'] = TRANS('MSG_ERR_SAVE_RECORD'); $_SESSION['flash'] = message('danger', '', $data['message'], ''); echo json_encode($data); return false; } } echo json_encode($data);