/** * function to activate the cpanel login for customer * @param integer $idcontacts * @param string $email * @param integer $idorganization * @return string */ public function activate_cpanel_login($idcontacts, $email, $idorganization) { $pass = CommonUtils::generate_random_string(10); $qry = "\n\t\tselect * from `cpanel_user`\n\t\twhere \n\t\t`idcontacts` = ?\n\t\tand `idorganization` = ?\n\t\t"; $stmt = $this->getDbConnection()->executeQuery($qry, array($idcontacts, $idorganization)); if ($stmt->rowCount() > 0) { $data = $stmt->fetch(); $id = $data['idcpanel_user']; $upd = "\n\t\t\tupdate `cpanel_user`\n\t\t\tset \n\t\t\t`email` = ?,\n\t\t\t`password` = ?\n\t\t\twhere `idcpanel_user` = ?\n\t\t\t"; $this->getDbConnection()->executeQuery($upd, array($email, md5($pass), $id)); } else { $ins = "\n\t\t\tinsert into `cpanel_user`\n\t\t\t(`email`,`password`,`idcontacts`,`idorganization`)\n\t\t\tvalues\n\t\t\t(?,?,?,?)\n\t\t\t"; $this->getDbConnection()->executeQuery($ins, array($email, md5($pass), $idcontacts, $idorganization)); } return $pass; }