<td>
<div class="checkbox">
<input id="checkbox2" type="checkbox" />
<label for="checkbox2"></label>
</div>
</td>
<td><?php
echo re_db_output($row_banner['url']);
?>
</td>
<td><?php
echo "<a href='user_profile_data.php?mid=" . $row_banner['memb_id'] . "' target='_blank'>" . re_db_output($row_banner['uname']) . "</a>";
?>
</td>
<td><?php
echo re_db_output(date('m-d-Y H:i:s', strtotime($row_banner['date_time'])));
?>
</td>
</tr>
<?php
}
// end of while loop
} else {
?>
<tr><td style="text-align: center;" class="subheading" colspan="4">No Record Found</td></tr>
<?php
}
?>
<tr>
<td colspan="4" style="text-align: center;"><?php
echo isset($prev) ? $prev : '';
$set_query = " set client_id='" . re_db_input($_GET['siteid']) . "',member_id='" . $member_id . "',\n insta_id='" . re_db_input($_GET['ig_id']) . "',full_name='" . re_db_input($_GET['full_name']) . "',username='******'username']) . "',bio='" . re_db_input($_GET['bio']) . "',profile_pic='" . re_db_input($_GET['profile_pic']) . "',\n website='" . re_db_input($_GET['website']) . "',email='" . re_db_input($_GET['email']) . "',bday='" . intval($_GET['bday']) . "',bmonth='" . intval($_GET['bmonth']) . "',byear='" . intval($_GET['byear']) . "'";
$select_user = "******" . mysql_real_escape_string($_GET['email']) . "' and client_id='" . mysql_real_escape_string($_GET['siteid']) . "'";
$res_user = re_db_query($select_user);
$csuser_id = 0;
if (mysql_num_rows($res_user) > 0) {
$row_user = mysql_fetch_array($res_user);
$csuser_id = $row_user['id'];
$update_query = "update cs_ig_data";
$where = " where email='" . mysql_real_escape_string($_GET['email']) . "' and client_id='" . mysql_real_escape_string($_GET['siteid']) . "'";
} else {
$update_query = "insert into cs_ig_data";
$where = "";
}
$set_query = $update_query . $set_query . $where;
re_db_query($set_query);
echo re_db_output($_GET['email']) . "~" . re_db_input($_GET['ig_id']);
exit;
}
if (isset($_GET['is_ig']) && $_GET['is_ig'] == '1') {
$select_email = "select id,email from cs_users where is_ig='1' and ig_id='" . re_db_input($_GET['ig_id']) . "' and client_id='" . re_db_input($_GET['siteid']) . "'";
$res_email = re_db_query($select_email);
$set_query = "set client_id='" . re_db_input($_GET['siteid']) . "',\n insta_id='" . re_db_input($_GET['ig_id']) . "',full_name='" . re_db_input($_GET['full_name']) . "',username='******'username']) . "',bio='" . re_db_input($_GET['bio']) . "',profile_pic='" . re_db_input($_GET['profile_pic']) . "',\n website='" . re_db_input($_GET['website']) . "'";
if (re_db_num_rows($res_email) > 0) {
$row_user = re_db_fetch_array($res_email);
$member_id = $row_user['id'];
echo $row_user['email'] . "~" . $_GET['ig_id'] . "~" . $row_user['id'];
$update_query = "update cs_ig_data " . $set_query . ",member_id='" . $member_id . "' where insta_id='" . re_db_input($_GET['ig_id']) . "' and client_id='" . re_db_input($_GET['siteid']) . "'";
re_db_query($update_query);
} else {
/*$insert_into="insert into cs_users set is_ig='1',client_id='".re_db_input($_GET['site_id'])."',ig_id='".$_GET['ig_id']."'";
re_db_query($insert_into);*/
<label for="checkbox<?php
//echo $i;
?>
"></label>
</div>
</td-->
<td><?php
echo re_db_output($row_banner['url']);
?>
</td>
<td><?php
echo re_db_output($row_banner['email']);
?>
</td>
<td><?php
echo re_db_output($row_banner['clicked_by']);
?>
</td>
<td><?php
echo $is_from_arr[$row_banner['is_from']];
?>
</td>
</tr>
<?php
}
} else {
?>
<tr><td style="text-align: center;" class="subheading" colspan="4">No Record Found</td></tr>
<?php
}
?>
<tr>
<th>Home Town</th>
<td><?php
echo $row_data['hometown'];
?>
</td>
<th>Friends</th>
<td><?php
echo $row_data['friends'];
?>
</td>
</tr>
<tr>
<th>Likes</th>
<td colspan="3"><?php
echo utf8_decode(re_db_output($row_data['likes']));
?>
</td>
</tr>
</table>
</div>
</section>
</div>
</div>
</main>
</div>
<!-- The Loader. Is shown when pjax happens -->
<div class="loader-wrap hiding hide">
<i class="fa fa-circle-o-notch fa-spin-fast"></i>
</div>
echo re_db_output($yahoo_app_id);
?>
" />
</div>
<div class="form-group">
<div><strong>Instagram API Key</strong></div>
<input type="text" name="insta_app_id" class="form-control" id="insta_app_id" placeholder="Instagram API Key" value="<?php
echo re_db_output($insta_app_id);
?>
" />
</div>
<div class="form-group">
<div><strong>Email</strong></div>
<input type="text" name="email" class="form-control" id="exampleInputEmail1" placeholder="Email" value="<?php
echo re_db_output($email);
?>
" />
</div>
<div class="form-group">
<div><strong>Password</strong></div>
<input class="form-control" name="pass" id="pswd" type="password" placeholder="Password" />
</div>
<div class="clearfix">
<div class="btn-toolbar pull-right">
<input type="submit" name="update_account" class="btn btn-inverse btn-sm" value="Update Account" />
</div>
</div>
</form>
</div>
</section>
</tr>
</thead>
<tbody>
<?php
if (re_db_num_rows($res_tlp) > 0) {
while ($row_tlp = re_db_fetch_array($res_tlp)) {
?>
<tr>
<td><?php
echo re_db_output($row_tlp['page_title']);
?>
</td>
<td><?php
echo re_db_output($row_tlp['total']);
?>
</td>
<td><a href="<?php
echo $row_tlp['fb_page_id'] ? "https://www.facebook.com/" . $row_tlp['fb_page_id'] . "" : "#";
?>
" target="_blank">View</a></td>
</tr>
<?php
}
} else {
?>
<tr><td style="text-align: center;" class="subheading" colspan="4">No Record Found</td></tr>
<?php
?>
</td>
<td><?php
echo re_db_output($row_banner['is_dislike']);
?>
</td>
<td><?php
echo re_db_output($row_banner['is_tweet']);
?>
</td>
<td><?php
echo re_db_output($row_banner['is_li']);
?>
</td>
<td><?php
echo re_db_output($row_banner['is_gp']);
?>
</td>
</tr>
<?php
}
} else {
?>
<tr><td style="text-align: center;" class="subheading" colspan="6">No Record Found</td></tr>
<?php
}
?>
<tr>
<td colspan="6" style="text-align: center;"><?php
echo isset($prev) ? $prev : '';
?>
<tr>
<td><?php
echo re_db_output($client_rec['site_url']);
?>
</td>
<td><?php
echo re_db_output($client_rec['firstname']);
?>
</td>
<td><?php
echo re_db_output($client_rec['lastname']);
?>
</td>
<td><?php
echo re_db_output($client_rec['admin_email']);
?>
</td>
<td>
<?php
if ($client_rec['is_approved'] == "0") {
?>
<a href="<?php
echo SITE_URL;
?>
cs_approve_client.php?action=approve&id=<?php
echo $client_rec['id'];
?>
">Approve</a><?php
} else {
if ($client_rec['is_approved'] == "1") {
?>
<tr>
<!--td>
<div class="checkbox">
<input id="checkbox<?php
//echo $i;
?>
" type="checkbox" />
<label for="checkbox<?php
//echo $i;
?>
"></label>
</div>
</td-->
<td><?php
echo re_db_output($row_banner['email']);
?>
</td>
<td><?php
echo $row_banner['is_fb'] == "1" ? "Yes" : "No";
?>
</td>
<td><?php
echo $row_banner['is_li'] == "1" ? "Yes" : "No";
?>
</td>
<td><?php
echo $row_banner['is_tw'] == "1" ? "Yes" : "No";
?>
</td>
<td><?php
?>
</td>
</tr>
<tr>
<th>Friends</th>
<td><?php
echo $fb_data_rec['friends'];
?>
</td>
<th> </th>
<td> </td>
</tr>
<tr>
<th>Likes</th>
<td colspan="3"><?php
echo utf8_decode(re_db_output($fb_data_rec['likes']));
?>
</td>
</tr>
</table>
<?php
} else {
?>
<table class="table" style="border: medium none;">
<tr>
<td><h2 style="text-align: center;">No FB Data Found</h2></td>
</tr>
</table>
<?php
}
?>
