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="">-->
