function createRows() { $dbh = new PDO(DB_DSN, DB_USERNAME, DB_PASSWORD); $user_insert = <<<EOF insert into users (id, active, approved, username, display_name, email) values (:id, 1, 1, :username, :full_name, :email) EOF; $user_stmt = $dbh->prepare($user_insert); $user_stmt->bindParam(':id', $user_id); $user_stmt->bindParam(':username', $username); $user_stmt->bindParam(':full_name', $full_name); $user_stmt->bindParam(':email', $email); $group_insert = <<<EOF insert into users_groups (id, active, name, user_id) values (:id, 1, :username, :user_id) EOF; $group_stmt = $dbh->prepare($group_insert); $group_stmt->bindParam(':id', $group_id); $group_stmt->bindParam(':username', $username); $group_stmt->bindParam(':user_id', $user_id); $student_insert = <<<EOF insert into tg_student (user_id, first_name, last_name) values (:user_id, :first_name, :last_name) EOF; $student_stmt = $dbh->prepare($student_insert); $student_stmt->bindParam(':user_id', $user_id); $student_stmt->bindParam(':first_name', $first_name); $student_stmt->bindParam(':last_name', $last_name); $user_id_result = $dbh->query('select id from users_seq', PDO::FETCH_ASSOC); $lastUserId = $user_id_result->fetchColumn(); $group_id_result = $dbh->query('select id from users_groups_seq', PDO::FETCH_ASSOC); $lastGroupId = $group_id_result->fetchColumn(); for ($i = 1; $i <= STUDENT_LIMIT; $i++) { $user_id = $lastUserId + $i; $group_id = $lastGroupId + $i; $first_name = getName(1); $last_name = getName(2); $full_name = "{$first_name} {$last_name}"; $username = makeUsername($first_name, $last_name); $email = $username . '@appstate.edu'; $user_stmt->execute(); $group_stmt->execute(); $student_stmt->execute(); echo "Created user {$username}\n"; } $user_seq_stmt = 'update users_seq set id=' . $user_id; $dbh->exec($user_seq_stmt); $group_seq_stmt = 'update users_groups_seq set id=' . $group_id; $dbh->exec($group_seq_stmt); }
function signup() { global $Userservice; global $SKADATE_BOL_AccountTypeToGenderDao; global $BOL_AvatarService_inst; //global $EmailVerifyService; global $SKAPI_BOL_Service_inst; global $language; $app = \Slim\Slim::getInstance(); $app->response->headers->set('Content-Type', 'application/json'); $app->response->setStatus(200); //Lang Call Start $hammu_lang_id = $app->request()->params("lang_id"); if (!empty($hammu_lang_id)) { getCurrentLanguages($hammu_lang_id); } //Lang Call end //$match_sex = $app->request()->params('match_sex'); //$preferences_or_services = $app->request()->params('preferences_or_services'); //$photo = $app->request()->params('photo'); //$photo_data = $_FILES["photo"]; $username = $app->request()->params('username'); $email = $app->request()->params('email'); $password = $app->request()->params('password'); $realname = $app->request()->params('realname'); $sex = $app->request()->params('sex'); $i_m_using = $app->request()->params(HAMMU_DB_IM_USING_HAMMU_AS_KEY); $googlemap_location = $app->request()->params('googlemap_location'); $birthdate = $app->request()->params('birthdate'); $mobile_number = $app->request()->params(HAMMU_DB_MOBILE_NUMBER_KEY); $meeting_point = $app->request()->params(HAMMU_DB_METTING_POINT_KEY); $pay_pal_address = $app->request()->params(HAMMU_DB_PAYMENT_TYPE_KEY); //hardik edited $HOTEL_SERVICE = $app->request()->params(HAMMU_HOTEL_SERVICE); $HOME_VISIT = $app->request()->params(HAMMU_HOME_VISIT); $HAMMU_AVAILABLE_AT = urldecode($app->request()->params(HAMMU_AVAILABLE_AT)); $SECRET_FANTASY = $app->request()->params(HAMMU_SECRET_FANTASY); $HAMMU_LANGUAGE = $app->request()->params(HAMMU_LANGUAGE); $HAMMU_COUNTRY = $app->request()->params(HAMMU_COUNTRY); // $token = $app->request()->params('token'); $type = $app->request()->params('type'); $preferences = $app->request()->params(HAMMU_DB_SERVICES_KEY); $lang = $app->request()->params(HAMMU_LANG); $deviceId = $token; $deviceType = $type; $preferenceArr = explode(",", $preferences); $langArr = explode(",", $lang); //print_r($preferenceArr); $preVal = 0; foreach ($preferenceArr as $key => $value) { $preVal = $preVal + $value; } $langVal = 0; foreach ($langArr as $key => $value) { $langVal = $langVal + $value; } // $HAMMU_AVAILABLE_ATArr = explode(",", $HAMMU_AVAILABLE_AT); //print_r($HAMMU_AVAILABLE_ATArr); // die; // $preVal1 = 0; // foreach ($HAMMU_AVAILABLE_ATArr as $key => $value) { // $preVal1 = $preVal1 + $value; // } $data["email"] = urldecode($email); $data["username"] = $username; $data['password'] = $password; $data["googlemap_location"] = $googlemap_location; $data["birthdate"] = $birthdate; $data[HAMMU_DB_MOBILE_NUMBER_KEY] = $mobile_number; $data["sex"] = $sex; $today_date_timestamp = strtotime(date("d-m-Y")); $birth_date_timestamp = strtotime($birthdate); if ($birth_date_timestamp > $today_date_timestamp) { $message = $language->text("hammu", "signup_error_prorper_date"); //"Please Provide Proper Date!"; $return_data = array("response_status" => "0", "response_message" => $message); $app->response->setBody(json_encode($return_data)); } else { $crdata = checkuserexists($data); if (count($crdata) > 0) { $app->response->setBody(json_encode($crdata)); } else { $username = trim(preg_replace('/[^\\w]/', '', $username)); $username = makeUsername($username); $data['realname'] = $username; $newUser = false; $accountdata = $SKADATE_BOL_AccountTypeToGenderDao->findByGenderValue($sex); $accounttype = $accountdata[0]->accountType; $user = $Userservice->createUser($username, $password, $data["email"], $accounttype, false); $check_exist_value = $SKAPI_BOL_Service_inst->findValueExistOrNot($user->id); if ($check_exist_value) { $table_id = $check_exist_value[0]->id; if ($table_id) { $user_skapi_id = $check_exist_value[0]->id; } else { $user_skapi_id = ""; } } else { $user_skapi_id = ""; } $user_details = $SKAPI_BOL_Service_inst->createUserDetails($user->id, $deviceId, $deviceType, $user_skapi_id); sendUserVerificationMail($user); $newUser = true; unset($data['email']); unset($data['password']); unset($data['username']); //Geo location settings on address $price = $app->request()->params(HAMMU_DB_PRICE_KEY); if (!empty($data["googlemap_location"])) { $urlencode_address = urlencode($data["googlemap_location"]); $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $urlencode_address . '&sensor=false'); $output = json_decode($geocode); if (!empty($output->results[0]->formatted_address)) { $data_location[HAMMU_DB_PRICE_KEY] = $price; $data_location['googlemap_location']['address'] = $output->results[0]->formatted_address; $data_location['googlemap_location']['latitude'] = $output->results[0]->geometry->location->lat; $data_location['googlemap_location']['longitude'] = $output->results[0]->geometry->location->lng; $data_location['googlemap_location']['northEastLat'] = $output->results[0]->geometry->bounds->northeast->lat; $data_location['googlemap_location']['northEastLng'] = $output->results[0]->geometry->bounds->northeast->lng; $data_location['googlemap_location']['southWestLat'] = $output->results[0]->geometry->bounds->southwest->lat; $data_location['googlemap_location']['southWestLng'] = $output->results[0]->geometry->bounds->southwest->lng; $data_location['googlemap_location']['json'] = json_encode($output->results[0]); $data_location['birthdate'] = $data["birthdate"]; $data_location['sex'] = $sex; $data_location['realname'] = $realname; $data_location[HAMMU_DB_MOBILE_NUMBER_KEY] = $data[HAMMU_DB_MOBILE_NUMBER_KEY]; $data_location[HAMMU_DB_SERVICES_KEY] = $preVal; $data_location[HAMMU_DB_PAYMENT_TYPE_KEY] = $pay_pal_address; $data_location[HAMMU_DB_IM_USING_HAMMU_AS_KEY] = $i_m_using; $data_location[HAMMU_DB_METTING_POINT_KEY] = $meeting_point; //hardik edited $data_location[HAMMU_HOTEL_SERVICE] = $HOTEL_SERVICE; $data_location[HAMMU_HOME_VISIT] = $HOME_VISIT; $data_location[HAMMU_AVAILABLE_AT] = $HAMMU_AVAILABLE_ATArr; $data_location[HAMMU_SECRET_FANTASY] = $SECRET_FANTASY; $data_location[HAMMU_LANGUAGE] = $HAMMU_LANGUAGE; $data_location[HAMMU_COUNTRY] = $HAMMU_COUNTRY; $data_location[HAMMU_LANG] = $langVal; // } } // print_r($data_location); // die; $store_to_question = cleanArray($data_location); BOL_QuestionService::getInstance()->saveQuestionsData($store_to_question, $user->id); if (!empty($_FILES)) { $files = $_FILES; //PHOTO_BOL_PhotoService::getInstance()->getPhotoPath($data["photoId"], $data["hash"], 'original'); $path = $_FILES['photo']['tmp_name']; $avtar = $BOL_AvatarService_inst->setUserAvatar($user->id, $path); } $event = new OW_Event(OW_EventManager::ON_USER_REGISTER, array('method' => 'native', 'userId' => $user->id, 'params' => array())); OW::getEventManager()->trigger($event); $avatars = $BOL_AvatarService_inst->getAvatarsUrlList(array($user->id)); $filed_array = array(HAMMU_DB_PREFRENCES_KEY, HAMMU_DB_SERVICES_KEY); $all_services_preferences = getallquestions(array("user_id" => $user->id, "fields" => $filed_array)); if ($i_m_using == "1") { $sex_type = $language->text("hammu", "login_client"); //"client"; $type = "preferences"; } else { $sex_type = $language->text("hammu", "login_escort"); //"escort"; $type = "services"; } $messages = $language->text("hammu", "email_verification_code"); //"Your Verification code has been sent to your Email Address"; $return_data = array("response_status" => '1', "response_message" => $messages, "data" => array("user_id" => $user->id, "user_name" => $username, "email" => urldecode($email), "profile_picture" => $avatars[$user->id], "phone_number" => $mobile_number, "birthday" => $birthdate, "user_type" => $sex_type, $type => $all_services_preferences[0]['userSelectedLabel'])); $app->response->setBody(json_encode($return_data)); } } }
function facebookLogin() { //$data = $_POST; global $Userservice; global $QuestionService; global $getPluginManager; global $BOL_AvatarService_inst; global $getEventManager; $data = array(); $app = \Slim\Slim::getInstance(); $app->response->headers->set('Content-Type', 'application/json'); $app->response->setStatus(200); $facebookid = $app->request()->params('facebookid'); $email = $app->request()->params('email'); $sex = $app->request()->params('gender'); $birthdate = $app->request()->params('birthdate'); $token = $app->request()->params('token'); $type = $app->request()->params('type'); $deviceId = $token; $deviceType = $type; $facebookId = $facebookid; // $data = json_decode($params['data'], true); // $facebookId = (int) $data['facebookid']; // $email = (int) $data['email']; // echo "got her"; // $authAdapter = new OW_RemoteAuthAdapter($facebookId, 'facebook'); //echo "got her 2"; $email = trim($email); $params = array("email" => $email, "deviceid" => $deviceId, "device_type" => $deviceType); $return_data = checkfacebookuserexists($params); //echo "got here 41"; //print_r($return_data); if ($return_data) { // print_r($return_data); $app->response->setBody(json_encode($return_data)); // exit(); } else { //echo "got her 1"; $password = uniqid(); $tmpUsername = explode('@', $email); $username = $tmpUsername[0]; $username = trim(preg_replace('/[^\\w]/', '', $username)); //echo "got her 2"; $username = makeUsername($username); // echo "got her 3"; $newUser = false; $data['realname'] = $username; $accountype = $sex == "female" ? "8cc28eaddb382d7c6a94aeea9ec029fb" : "808aa8ca354f51c5a3868dad5298cd72"; //(int) $data["sex"]; //(1 = Female, 2 = Male) if ($accountype == "8cc28eaddb382d7c6a94aeea9ec029fb") { $sex = 2; //$type = "services"; $sex_type = "lady"; } else { //$type = "preferences"; $sex = 1; $sex_type = "gentleman"; } $data["sex"] = $sex; //$accountype; $UserDob = date("Y/m/d", strtotime($birthdate)); $data["birthdate"] = $UserDob; // echo "got her 3 1"; // echo "come"; $user = $Userservice->createUser($username, $password, $email, $accountype, true); $newUser = true; // echo "got her 3 1 2"; // if (!empty($data["address"])) { // $urlencode_address = urlencode($data["address"]); // $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $urlencode_address . '&sensor=false'); // $output = json_decode($geocode); ////echo print_r(json_encode($output->results)); // if (!empty($output->results[0]->formatted_address)) { // $data['googlemap_location']['address'] = $output->results[0]->formatted_address; // $data['googlemap_location']['latitude'] = $output->results[0]->geometry->location->lat; // $data['googlemap_location']['longitude'] = $output->results[0]->geometry->location->lng; // $data['googlemap_location']['northEastLat'] = $output->results[0]->geometry->bounds->northeast->lat; // $data['googlemap_location']['northEastLng'] = $output->results[0]->geometry->bounds->northeast->lng; // $data['googlemap_location']['southWestLat'] = $output->results[0]->geometry->bounds->southwest->lat; // $data['googlemap_location']['southWestLng'] = $output->results[0]->geometry->bounds->southwest->lng; // $data['googlemap_location']['json'] = json_encode($output->results[0]); // } // } // echo "got here"; $QuestionService->saveQuestionsData(array_filter($data), $user->id); $avatarUrl = 'http://graph.facebook.com/' . $facebookid . '/picture?type=large&height=400&width=400'; //$pluginfilesDir = OW_DIR_ROOT; $pluginfilesDir = $getPluginManager->getPlugin('skapi')->getPluginFilesDir(); $ext = 'jpg'; $tmpFile = $pluginfilesDir . uniqid('avatar-') . (empty($ext) ? '' : '.' . $ext); // echo "cal copy"; //move_uploaded_file($avatarUrl, $tmpFile); // if (!file_exists($path)) { //mkdir($pluginfilesDir, 0777); chmod($pluginfilesDir, 0777); // } // error_reporting(E_ALL); // ini_set('display_errors', true); //copy($avatarUrl, $tmpFile); @copy($avatarUrl, $tmpFile); //echo "failed to copy"; if (file_exists($tmpFile)) { $BOL_AvatarService_inst->setUserAvatar($user->id, $tmpFile); //@unlink($tmpFile); } if ($newUser) { $event = new OW_Event(OW_EventManager::ON_USER_REGISTER, array('method' => 'facebook', 'userId' => $user->id, 'params' => array())); $getEventManager->trigger($event); } //echo "suceees 3"; //$userdata = $this->respondUserData($user->id, $data); //echo json_encode($userdata); //echo "got her 3 2 11"; $avatars = $BOL_AvatarService_inst->getAvatarsUrlList(array($user->id)); $messages = "Login Successfully"; $return_data = array("response_status" => '1', "response_message" => $messages, "data" => array("user_id" => $user->id, "user_name" => $username, "email" => $email, "profile_picture" => $avatars[$user->id], "user_type" => $sex_type)); $app->response->setBody(json_encode($return_data)); } }
function signup() { global $Userservice; global $SKADATE_BOL_AccountTypeToGenderDao; global $BOL_AvatarService_inst; $app = \Slim\Slim::getInstance(); $app->response->headers->set('Content-Type', 'application/json'); $app->response->setStatus(200); //$match_sex = $app->request()->params('match_sex'); //$preferences_or_services = $app->request()->params('preferences_or_services'); //$photo = $app->request()->params('photo'); //$photo_data = $_FILES["photo"]; $username = $app->request()->params('username'); $email = $app->request()->params('email'); $password = $app->request()->params('password'); $realname = $app->request()->params('realname'); $sex = $app->request()->params('sex'); $i_m_using = $app->request()->params(HAMMU_DB_IM_USING_HAMMU_AS_KEY); $googlemap_location = $app->request()->params('googlemap_location'); $birthdate = $app->request()->params('birthdate'); $mobile_number = $app->request()->params(HAMMU_DB_MOBILE_NUMBER_KEY); $meeting_point = $app->request()->params(HAMMU_DB_METTING_POINT_KEY); $pay_pal_address = $app->request()->params(HAMMU_DB_PAYMENT_TYPE_KEY); $token = $app->request()->params('token'); $type = $app->request()->params('type'); $preferences = $app->request()->params(HAMMU_DB_SERVICES_KEY); $deviceId = $token; $deviceType = $type; $preferenceArr = explode(",", $preferences); $preVal = 0; foreach ($preferenceArr as $key => $value) { $preVal = $preVal + $value; } $data["email"] = urldecode($email); $data["username"] = $username; $data['password'] = $password; $data["googlemap_location"] = $googlemap_location; $data["birthdate"] = $birthdate; $data[HAMMU_DB_MOBILE_NUMBER_KEY] = $mobile_number; $data["sex"] = $sex; $today_date_timestamp = strtotime(date("d-m-Y")); $birth_date_timestamp = strtotime($birthdate); if ($birth_date_timestamp > $today_date_timestamp) { $return_data = array("response_status" => "0", "response_message" => "Please Provide Proper Date!"); $app->response->setBody(json_encode($return_data)); } else { $crdata = checkuserexists($data); if (count($crdata) > 0) { $app->response->setBody(json_encode($crdata)); } else { $username = trim(preg_replace('/[^\\w]/', '', $username)); $username = makeUsername($username); $data['realname'] = $username; $newUser = false; $accountdata = $SKADATE_BOL_AccountTypeToGenderDao->findByGenderValue($sex); $accounttype = $accountdata[0]->accountType; $user = BOL_UserService::getInstance()->createUser($username, $password, $data["email"], $accounttype, false); $newUser = true; unset($data['email']); unset($data['password']); unset($data['username']); //Geo location settings on address $price = $app->request()->params(HAMMU_DB_PRICE_KEY); if (!empty($price)) { $final_price = $price; } else { $final_price = ""; } if (!empty($data["googlemap_location"])) { $urlencode_address = urlencode($data["googlemap_location"]); $geocode = file_get_contents('http://maps.google.com/maps/api/geocode/json?address=' . $urlencode_address . '&sensor=false'); $output = json_decode($geocode); if (!empty($output->results[0]->formatted_address)) { $data_location[HAMMU_DB_PRICE_KEY] = $final_price; $data_location['googlemap_location']['address'] = $output->results[0]->formatted_address; $data_location['googlemap_location']['latitude'] = $output->results[0]->geometry->location->lat; $data_location['googlemap_location']['longitude'] = $output->results[0]->geometry->location->lng; $data_location['googlemap_location']['northEastLat'] = $output->results[0]->geometry->bounds->northeast->lat; $data_location['googlemap_location']['northEastLng'] = $output->results[0]->geometry->bounds->northeast->lng; $data_location['googlemap_location']['southWestLat'] = $output->results[0]->geometry->bounds->southwest->lat; $data_location['googlemap_location']['southWestLng'] = $output->results[0]->geometry->bounds->southwest->lng; $data_location['googlemap_location']['json'] = json_encode($output->results[0]); $data_location['birthdate'] = $data["birthdate"]; $data_location['sex'] = $sex; $data_location['realname'] = $realname; $data_location[HAMMU_DB_MOBILE_NUMBER_KEY] = $data[HAMMU_DB_MOBILE_NUMBER_KEY]; $data_location[HAMMU_DB_SERVICES_KEY] = $preVal; $data_location[HAMMU_DB_PAYMENT_TYPE_KEY] = $pay_pal_address; $data_location[HAMMU_DB_IM_USING_HAMMU_AS_KEY] = $i_m_using; $data_location[HAMMU_DB_METTING_POINT_KEY] = $meeting_point; } } if ($i_m_using == "1") { array_shift($data_location); } // print_r($data_location); // exit; BOL_QuestionService::getInstance()->saveQuestionsData(array_filter($data_location), $user->id); if (!empty($_FILES)) { $files = $_FILES; //PHOTO_BOL_PhotoService::getInstance()->getPhotoPath($data["photoId"], $data["hash"], 'original'); $path = $_FILES['photo']['tmp_name']; $avtar = $BOL_AvatarService_inst->setUserAvatar($user->id, $path); } $event = new OW_Event(OW_EventManager::ON_USER_REGISTER, array('method' => 'native', 'userId' => $user->id, 'params' => array())); OW::getEventManager()->trigger($event); $avatars = $BOL_AvatarService_inst->getAvatarsUrlList(array($user->id)); $filed_array = array(HAMMU_DB_PREFRENCES_KEY, HAMMU_DB_SERVICES_KEY); $all_services_preferences = getallquestions(array("user_id" => $user->id, "fields" => $filed_array)); if ($i_m_using == "1") { $sex_type = "client"; $type = "preferences"; } else { $sex_type = "escort"; $type = "services"; } $messages = "SignUp Successfully"; $return_data = array("response_status" => '1', "response_message" => $messages, "data" => array("user_id" => $user->id, "user_name" => $username, "email" => urldecode($email), "profile_picture" => $avatars[$user->id], "phone_number" => $mobile_number, "birthday" => $birthdate, "user_type" => $sex_type, $type => $all_services_preferences[0]['userSelectedLabel'])); $app->response->setBody(json_encode($return_data)); } } }