get_row("select * from ".$wpdb->prefix."_3xs_settings where id = 1");
$tw_configured = $settings->tw_cs && $settings->tw_ck ? true : false;
$fb_configured = $settings->fb_app_id && $settings->fb_app_secret ? true : false;
$ln_configured = $settings->ln_cs && $settings->ln_ck ? true : false;
$tw_acs = $wpdb->get_results("SELECT * FROM ".$this->tbl_tw_accounts);
$ln_acs = $wpdb->get_results("SELECT * FROM ".$this->tbl_ln_accounts);
$fb_acs = $wpdb->get_results("SELECT * FROM ".$this->tbl_fb_accounts);
$account_sets = $wpdb->get_results("SELECT * FROM `" . $this->tbl_account_sets . "`", ARRAY_A);
$account_types = array(
'tw' => 'Twitter',
'fb' => 'Facebook',
'ln' => 'LinkedIn'
);
?>
Accounts and Account Sets Management
activated && $settings->licence_type=='3xSocializer_developer') {?>
Account Sets
$record): ?>
+ Add new account set
Applications
Twitter
here first.";
echo "
plugin_url."help/twitter.php')\" style='position: relative; top: 6px; left: 6px; cursor: pointer;' src='".$this->plugin_url."images/help_icon.png'>";
echo generatePopupForm('tw', $action_url);
}
?>
Facebook
here first.";
echo "
plugin_url."help/facebook.php')\" style='position: relative; top: 6px; left: 6px; cursor: pointer;' src='".$this->plugin_url."images/help_icon.png'>";
echo generatePopupForm('fb', $action_url);
}
?>
Linkedin
here first.";
echo "
plugin_url."help/linkedin.php')\" style='position: relative; top: 6px; left: 6px; cursor: pointer;' src='".$this->plugin_url."images/help_icon.png'>";
echo generatePopupForm('ln', $action_url);
}
?>
Twitter Accounts
tw_ck, $settings->tw_cs);
/* Get temporary credentials. */
$request_token = $connection->getRequestToken($action_url."&twitter_callback=true");
/* Save temporary credentials to session. */
// $_SESSION['tw_oauth_token'] =
$token = isset($request_token['oauth_token']) ? $request_token['oauth_token'] : "nothing";
update_option('tw_oauth_token', $token);
update_option('tw_oauth_token_secret', isset($request_token['oauth_token_secret']) ? $request_token['oauth_token_secret'] : "nothing");
// echo var_dump($_SESSION);
/* If last connection failed don't display authorization link. */
// var_dump($connection);
switch ($connection->http_code) {
case 200:
/* Build authorize URL and redirect user to Twitter. */
$url = $connection->getAuthorizeURL($token);
echo "
Add your twitter account ";// header('Location: ' . $url);
break;
default:
/* Show notification if something went wrong. */
echo 'Could not connect to Twitter. Please check your Twitter consumer key / consumer secret
and also check if there is read and write access in your Twitter application settings (not just read access).
Please review the
plugin_url.'help/twitter.php")>instructions for further assistance.';
}
} else {
echo "
Please, enter your Twitter application credentials first ";
}
?>
Facebook Pages
$settings->fb_app_id,
'secret' => $settings->fb_app_secret,
);
$facebook = new SocializerFacebook($config);
//echo strpos(var_dump($facebook),"[\"state\":protected]=> NULL");
//echo strpos(print_r($facebook), "[state:protected] => [accessToken:protected]");
$user_id = $facebook->getUser();
if($user_id) {
try {
$user_profile = $facebook->api('/me','GET');
if (isset($_GET['facebook_callback']) && $_GET['facebook_callback'] == true){
$wpdb->query($wpdb->prepare('delete from '.$this->tbl_fb_accounts));
$pages = $facebook->api($user_profile['username']."/accounts", 'GET');
$data = $pages['data'];
$wpdb->insert($this->tbl_fb_accounts, array('username' => $user_profile['username'], 'name' => 'My feed', 'page_id' => 'me'));
foreach($data as $page){
if(isset($page['perms'])){
foreach($page['perms'] as $permission){
if ($permission == "ADMINISTER"){
$wpdb->show_errors();
// echo "Page: ".$page['name']."
";
$wpdb->insert($this->tbl_fb_accounts, array('username' => $user_profile['username'], 'name' => $page['name'], 'page_id' => $page['id']));
}
}
}
}
} else {
$login_array = array();
$login_array['scope'] = 'publish_stream, manage_pages';
$login_array['redirect_uri'] = $action_url."&facebook_callback=true";
$login_url = $facebook->getLoginUrl($login_array);
}
} catch(FacebookApiException $e) {
echo "Please check your Facebook App credentials and try once more";
// var_dump($e);
}
}
}
$fb_acs = $wpdb->get_results("SELECT * FROM ".$this->tbl_fb_accounts);
foreach ($fb_acs as $record): ?>
getLoginUrl($login_array);
echo '
Refresh your facebook pages. ';
// } else {
// echo "
You provided invalid Facebook App credentials ";
// }
} else {
echo "
Please, enter your Facebook application credentials first ";
}
?>
ln_ck, $settings->ln_cs, NULL);
$callback = $action_url."&linkedin_callback=true";
$req_req = OAuthRequest::from_consumer_and_token($test_consumer, NULL, "POST", $domain . "/requestToken");
$req_req->set_parameter("oauth_callback", $callback); # part of OAuth 1.0a - callback now in requestToken
$req_req->sign_request($sig_method, $test_consumer, NULL);
$ch = curl_init();
curl_setopt($ch, CURLOPT_POSTFIELDS, '');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(
$req_req->to_header()
));
curl_setopt($ch, CURLOPT_URL, $domain . "/requestToken");
curl_setopt($ch, CURLOPT_POST, 1);
$output = curl_exec($ch);
curl_close($ch);
parse_str($output, $oauth);
update_option('ln_oauth_token', $oauth['oauth_token']);
update_option('ln_oauth_token_secret', $oauth['oauth_token_secret']);
if(!isset($oauth['oauth_token'])) {
echo "Something wrong, please recheck your LinkedIn App Credentials". $output;
} else {
$url = "https://api.linkedin.com/uas/oauth/authorize?oauth_token=".$oauth['oauth_token'];
echo "
Add your LinkedIn account ";
}
}
// } else {
if (false){
echo "
Please, enter your LinkedIn application credentials first ";
}
?>
'Twitter',
'fb' => 'Facebook',
'ln' => 'LinkedIn'
);
$ck_value = null;
$cs_value = null;
$ck_name = null;
$ck_value = null;
switch($type):
case 'fb':
$ck_value = $values ? $values->fb_app_id : null;
$cs_value = $values ? $values->fb_app_secret : null;
$ck_name = 'App ID';
$cs_name = 'App Secret';
break;
case 'tw':
$ck_value = $values ? $values->tw_ck : null;
$cs_value = $values ? $values->tw_cs : null;
$ck_name = 'Consumer key';
$cs_name = 'Consumer secret';
break;
case 'ln':
$ck_value = $values ? $values->ln_ck : null;
$cs_value = $values ? $values->ln_cs : null;
$ck_name = 'API Key';
$cs_name = 'Secret Key';
break;
default:
break;
endswitch;
?>