public static function setLastPageScrapped($location) { // $page = array(); $page = Database::selectV1('fs_invited', '*', "location = '{$location}' && scrape_version = 1 order by invited_date desc limit 1"); echo "<pre>"; print_r($page); self::$page = !empty($page[0]['page']) ? $page[0]['page'] : 1; }
<?php session_start(); include 'http://fashionsponge.com/fs_folders/php_functions/Database/Database.php'; $database = new Database(); $database->connect(); $mno = $_SESSION['mno']; $user_account = $database->selectV1('fs_member_accounts', '*', "mno = {$mno}"); $user_profile = $database->selectV1('fs_members', '*', "mno = {$mno}"); $lastname = !empty($user_profile[0]['lastname']) ? $user_profile[0]['lastname'] : ''; $firstname = !empty($user_profile[0]['firstname']) ? $user_profile[0]['firstname'] : ''; $username = !empty($user_account[0]['username']) ? $user_account[0]['username'] : ''; // print_r($user_profile); // print_r($user_account); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Latest compiled and minified CSS --> <!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css">--> <!-- Optional theme --> <!--<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap-theme.min.css">-->
// add in the field for row and time // $_GET['row'] = 'DateTimeSend2'; // $_GET['time'] = '10:21:20'; $_GET['time'] = $time->getTimeRemoveDate($_GET['dateTime']); //convert string ids to array $idArray = explode(',', $_GET['invitedIds']); foreach ($idArray as $id) { // get specific data the dateTimeSend1 or 2 or 3 $dbDateTime = $lookBookDatabase->getSpecificData('fs_invited', $_GET['row'], 'invited_id', $id); //update the time of the specific row dateTimeSend1 or 2 or 3 $response = $time->updateTimeSend($_GET['row'], $dbDateTime, $_GET['time'], $id, $database, $location); } // update all first time row location } else { echo "version 2 and its updating the time only<br>"; $_GET['time'] = $time->getTimeRemoveDate($_GET['dateTime']); // get specific data the dateTimeSend1 or 2 or 3 // get specific row value $response = Database::selectV1('fs_invited', '*', "invited_status = 1 and location = '{$location}' order by invited_id desc limit 1"); print_r($response); $dbDateTime = $response[0][$row]; echo "date time {$dbDateTime}"; //update the time of the specific row dateTimeSend1 or 2 or 3 $response = $time->updateTimeSend($row, $dbDateTime, $_GET['time'], $id, $database, $location); } break; } $log = Time::$log; echo "<response>{$response}<response>"; echo "<reason>{$log}<reason>"; //$lookBookDatabase->getSpecificData('fs_invited','DateTimeSend1', 'location', $location);
include '../../../fs_folders/php_functions/Database/Database.php'; //$mno = $_SESSION['mno']; //1016; $mno = $_SESSION['mno']; echo "mno = {$mno} <br><br>"; $database = new Database(); $database->connect(); $response = ''; $fname = $_POST['fname']; $lname = $_POST['lname']; $uname = $_POST['uname']; $checkbox = $_POST['checkbox']; $gender = $_POST['gender']; $fullName = $fname . ' ' . $lname; print_r($_POST); //check if username exist return true or false $username = $database->selectV1('fs_member_accounts', '*', "username = '******' and mno <> {$mno}"); //print_r($username); if ($username != TRUE) { //SAVE DATA if ($database->update('fs_members', array('fullname' => $fullName, 'firstname' => $fname, 'lastname' => $lname, 'gender' => $gender), "mno = {$mno}")) { echo "fs_members info successfully updated<br>"; if ($database->update('fs_member_accounts', array('username' => $uname), "mno = {$mno}")) { echo "account updated<br>"; if ($database->update('fs_members', array('tlog' => 3), "mno = {$mno}")) { echo "<br> success to updated tlog = 3"; } else { echo "<br> faled to update tlog = 3"; } } else { echo "account failled to save<br>"; }
<?php /** * Created by PhpStorm. * User: jesus * Date: 12/02/2015 * Time: 2:56 PM */ $db = '../Database'; $time = '../Time'; require_once "{$db}/Database.php"; require_once "{$db}/Invited.php"; require_once "{$db}/InvitedActivity.php"; require_once "{$db}/InvitedLocation.php"; require_once "{$db}/InvitedQueue.php"; require_once "{$time}/Time.php"; //initialized $database = new Database(); $invited = new Invitation\Invited(); $invitedActivity = new Invitation\InvitedActivity(); $invitedQueue = new Invitation\InvitedQueue(); $invitedLocation = new FashionSponge\InvitedLocation(); //connect $database->connect(); $response = $database->selectV1('fs_invited', 'distinct city', 'invited_id > 0'); echo "<pre>"; print_r($response); echo "<pre>";
public function printScrapperMenu($sc, $mc, $location, $invited_status, $totalApprovedEmail, $invited1, $database) { $invited1->_setInvitedTotals($database); /* echo 'total pending ' . $invited1->getTotalPending_() . "\n" . 'official signup ' . $invited1->getTotalOfficialSignUp_() . "\n" . 'official member' . $invited1->getTotalOfficialMember_() . "\n" . 'pending signup' . $invited1->getTotalPendingSignUp_() . "\n" . 'send sent' . $invited1->getTotalSendSent_() . "\n" ; */ // $total = $sc->get_total_results_invitedstatus();//get total results of the invited_status $topCity = $this->getTopCityArray(); // get top city // $location = 'NEW YORK'; // sorting of the location // $invited_status = '0'; // pending $invited = Database::selectV1('fs_invited', '*', "location = '{$location}' and invited_Status = 1 ORDER BY invited_id DESC limit 1"); // print_r($invited); $DateTimeSend = !empty($invited[0]['DateTimeSend']) ? $invited[0]['DateTimeSend'] : ''; $DateTimeSend1 = !empty($invited[0]['DateTimeSend1']) ? $invited[0]['DateTimeSend1'] : ''; $DateTimeSend2 = !empty($invited[0]['DateTimeSend2']) ? $invited[0]['DateTimeSend2'] : ''; $this->setTimeZone($location); Time::setTimeZoneDateTime($this->getTimeZone()); // initialized timezone $totalEmailAllowed = 200; $totalAvailable = $totalEmailAllowed - $totalApprovedEmail; ?> <tr> <td> <!-- 0 - pending 12 - Send / Sent 7 - Pending Sign Up 2 - Official Sign Up 3 - Official Member --> <select onchange="invited_person ( 'invited-person' , 'change-content' , '' , '#invited-people-sort' )" id='invited-people-sort' style='padding:10px;' > <!-- 0 - pending --> <?php if ($invited_status == 0) { ?> <option value='0' selected="selected" > pending (<?php echo $invited1->getTotalPending_(); ?> )</option> <?php } else { ?> <option value='0' > pending (<?php echo $invited1->getTotalPending_(); ?> )</option> <?php } ?> <!-- 12 - Send / Sent --> <?php if ($invited_status == 12) { ?> <option value='12' selected="selected" > Send / Sent (<?php echo $invited1->getTotalSendSent_(); ?> )</option> <?php } else { ?> <option value='12' > Send / Sent (<?php echo $invited1->getTotalSendSent_(); ?> )</option> <?php } ?> <!-- 7 - Pending Sign Up --> <?php if ($invited_status == 7) { ?> <option value='7' selected="selected" > Pending Sign Up (<?php echo $invited1->getTotalPendingSignUp_(); ?> )</option> <?php } else { ?> <option value='7' > Pending Sign Up (<?php echo $invited1->getTotalPendingSignUp_(); ?> )</option> <?php } ?> <!-- 2 - Official Sign Up --> <?php if ($invited_status == 2) { ?> <option value='2' selected="selected" > Official Sign Up (<?php echo $invited1->getTotalOfficialSignUp_(); ?> )</option> <?php } else { ?> <option value='2' > Official Sign Up (<?php echo $invited1->getTotalOfficialSignUp_(); ?> )</option> <?php } ?> <!-- 3 - Official Member --> <?php if ($invited_status == 3) { ?> <option value='3' selected="selected" > Official Member (<?php echo $invited1->getTotalOfficialMember_(); ?> )</option> <?php } else { ?> <option value='3' > Official Member (<?php echo $invited1->getTotalOfficialMember_(); ?> )</option> <?php } ?> <!-- 4 deleted !--> <?php if ($invited_status == 4) { ?> <option value='4' selected="selected" >Deleted (<?php echo $invited1->getTotalDeleted_(); ?> )</option> <?php } else { ?> <option value='4' > Deleted (<?php echo $invited1->getTotalDeleted_(); ?> )</option> <?php } ?> <!-- <?php if ($invited_status == 0) { ?> <option value='0' selected="selected" > pending (<?php echo $total['tPending']; ?> )</option> <?php } else { ?> <option value='0' > pending (<?php echo $total['tPending']; ?> )</option> <?php } ?> <?php if ($invited_status == 1) { ?> <option value='1' selected="selected" >approved (<?php echo $total['tApproved']; ?> )</option> <?php } else { ?> <option value='1' > approved (<?php echo $total['tApproved']; ?> )</option> <?php } ?> <?php if ($invited_status == 5) { ?> <option value='5' selected="selected" >need personal invite(<?php echo $total['tNeedPersonalInvite']; ?> )</option> <?php } else { ?> <option value='5' > need personal invite(<?php echo $total['tNeedPersonalInvite']; ?> )</option> <?php } ?> <?php if ($invited_status == 2) { ?> <option value='2' selected="selected" >sign-up (<?php echo $total['tSignup']; ?> )</option> <?php } else { ?> <option value='2' > sign-up (<?php echo $total['tSignup']; ?> )</option> <?php } ?> <?php if ($invited_status == 3) { ?> <option value='3' selected="selected" >officially (<?php echo $total['tOfficiallyMember']; ?> )</option> <?php } else { ?> <option value='3' > officially (<?php echo $total['tOfficiallyMember']; ?> )</option> <?php } ?> <?php if ($invited_status == 4) { ?> <option value='4' selected="selected" > deleted (<?php echo $total['tDeleted']; ?> )</option> <?php } else { ?> <option value='4' > deleted (<?php echo $total['tDeleted']; ?> )</option> <?php } ?> <?php if ($invited_status == 6) { ?> <option value='6' selected="selected" > pending but no email (<?php echo $total['tPendingButNoEmail']; ?> )</option> <?php } else { ?> <option value='6' > pending but no email (<?php echo $total['tPendingButNoEmail']; ?> )</option> <?php } ?> <?php if ($invited_status == 7) { ?> <option value='7' selected="selected" > signup from pending (<?php echo $total['tSignUpPending']; ?> )</option> <?php } else { ?> <option value='7' > signup from pending (<?php echo $total['tSignUpPending']; ?> )</option> <?php } ?> <?php if ($invited_status == 8) { ?> <option value='8' selected="selected" > signup anonymous people(<?php echo $total['tSignUpAnonymous']; ?> )</option> <?php } else { ?> <option value='8' > signup anonymous people (<?php echo $total['tSignUpAnonymous']; ?> )</option> <?php } ?> <?php if ($invited_status == 9) { ?> <option value='9' selected="selected" > signup refferal (<?php echo $total['tSignUpReferral']; ?> )</option> <?php } else { ?> <option value='9' > signup refferal (<?php echo $total['tSignUpReferral']; ?> )</option> <?php } ?> <?php if ($invited_status == 10) { ?> <option value='10' selected="selected" > signup from deleted (<?php echo $total['tSignUpDeleted']; ?> )</option> <?php } else { ?> <option value='10' > signup from deleted (<?php echo $total['tSignUpDeleted']; ?> )</option> <?php } ?> <?php if ($invited_status == 11) { ?> <option value='11' selected="selected" > signup from personal invited(<?php echo $total['tSignUpPersonalInvite']; ?> )</option> <?php } else { ?> <option value='11' > signup from personal invited(<?php echo $total['tSignUpPersonalInvite']; ?> )</option> <?php } ?> --> </select> </td> <td style="width:10" > <?php $mc->image(array('type' => 'loader', 'id' => 'invited-people-sort-loader', 'style' => 'visibility:hidden;height:10px;')); ?> </td> <td> <select onchange="invited_person ( 'invited-person' , 'change-content' , '' , '#invited-people-sort' )" id='invited-people-sort-location' > <option value="LOCATION" >LOCATION</option> <?php $response = select_v4(array('type' => 'select', 'tablename' => 'fs_invited', 'rows' => 'count(*) as total , location', 'where' => "invited_status = {$invited_status} GROUP BY location")); for ($i = 0; $i < count($response); $i++) { $locationDb = $response[$i]['location']; $totalDb = $response[$i]['total']; if ($location == $locationDb) { echo "<option value= '{$locationDb}' selected=\"selected\">{$locationDb}({$totalDb})</option>"; } else { echo "<option value= '{$locationDb}' >{$locationDb}({$totalDb})</option>"; } } ?> </select> </td> <!-- <td> <div> <?php echo " " . Time::getTimeZoneDateTime12() . ' ' . $this->getTimeZone(); ?> </div> </td> <td> <select onchange="setTimeInviteTime('<?php echo date('Y-m-d'); ?> ' , this, 'dateTime', '', '<?php echo $location; ?> ', '<?php echo $this->getTimeZone(); ?> ' )" > <option value="Time" >TIME</option> <?php foreach (Time::getTimeDbFormatArray() as $key => $value) { echo '<option value=' . $key . '>' . $value . '</option>'; } ?> </select> <?php echo "<br>" . Time::convertTimeToReadableDate($DateTimeSend); ?> </td> <td> <select onchange="setTimeInviteTime('<?php echo date('Y-m-d'); ?> ' , this, 'time', 'DateTimeSend1','<?php echo $location; ?> ', '<?php echo $this->getTimeZone(); ?> ')" > <option value="Time" >TIME</option> <?php foreach (Time::getTimeDbFormatArray() as $key => $value) { echo '<option value=' . $key . '>' . $value . '</option>'; } ?> </select> <?php echo "<br>" . Time::convertTimeToReadableDate($DateTimeSend1); ?> </td> <td> <select onchange="setTimeInviteTime('<?php echo date('Y-m-d'); ?> ' , this, 'time', 'DateTimeSend2', '<?php echo $location; ?> ', '<?php echo $this->getTimeZone(); ?> ')" > <option value="Time" >TIME</option> <?php foreach (Time::getTimeDbFormatArray() as $key => $value) { echo '<option value=' . $key . '>' . $value . '</option>'; } ?> </select> <?php echo "<br>" . Time::convertTimeToReadableDate($DateTimeSend2); ?> </td> <td> <div><?php echo $totalAvailable; ?> emails available</div> </td> --> <td> <input class="btn btn-lg btn-danger" type="button" onclick="fs_popup( 'popup-small' , 'invited-person' , '' , 'method' , 'table_id' , 'table_name' )" value="add new" > </td> <?php }
require_once "../../../fs_folders/php_functions/Extends/LookbookExtends.php"; require_once "../../../fs_folders/php_functions/Class/Lookbook.php"; require_once "../../../fs_folders/php_functions/String/String.php"; $string = new String(); $database = new Database(); $lookBook = new Lookbook(); $lookbookDatabase = new LookbookDatabase(); $database->connect(); //print_r($lookBook->getTopCityArray()); //echo "<pre>"; //print_r($lookBook->getTopCityTotalPages()); //echo "</pre>"; /** * i hear code query scrapping */ $iHeartMax = $database->selectV1('fs_invited', "*", "scrape_src LIKE '%heartifb%' ORDER BY invited_id desc limit 1"); $page_iHeart = $iHeartMax[0]['page']; $scrape_src_iHeart = $iHeartMax[0]['scrape_src']; // echo "this is amazing "; // print_r($iHeartMax); ?> <!----> <!--<!DOCTYPE html>--> <!--<html>--> <!--<head lang="en">--> <!-- <!--header meta for responsive mobile--> <!-- <meta charset="utf-8">--> <!-- <meta http-equiv="X-UA-Compatible" content="IE=edge">--> <!-- <meta name="viewport" content="width=device-width, initial-scale=1">--> <!-- <meta name="description" content="">-->