/**
* Get accounts from db
*
* @param string $type Type of account (=site)
* @return array
*/
public static function get_accounts_object($type)
{
global $wpdb;
$table_accounts = $wpdb->prefix . 'microblogposter_accounts';
$table_user_accounts = $wpdb->prefix . 'microblogposter_user_accounts';
$sql = "SELECT * FROM {$table_accounts} WHERE type='{$type}'";
if (MicroblogPoster_Poster::is_method_callable('MicroblogPoster_Poster_Ultimate', 'resolve_sql')) {
$sql .= MicroblogPoster_Poster_Ultimate::resolve_sql();
} else {
$sql .= " AND account_id NOT IN (SELECT DISTINCT account_id FROM {$table_user_accounts})";
}
$rows = $wpdb->get_results($sql);
return $rows;
}
/**
* Get the shortened url
*
* @param string $long_url
* @return string
* @access public
*/
public function shorten($long_url)
{
$googl_api_client_id_name = "microblogposter_plg_googl_api_client_id";
$googl_api_client_secret_name = "microblogposter_plg_googl_api_client_secret";
$googl_api_refresh_token_name = "microblogposter_plg_googl_api_refresh_token";
$googl_api_client_id_value = get_option($googl_api_client_id_name, "");
$googl_api_client_secret_value = get_option($googl_api_client_secret_name, "");
$googl_api_refresh_token_value = get_option($googl_api_refresh_token_name, "");
if ($googl_api_client_id_value && $googl_api_client_secret_value && $googl_api_refresh_token_value) {
$url = "https://accounts.google.com/o/oauth2/token";
$post_args = array('refresh_token' => $googl_api_refresh_token_value, 'grant_type' => 'refresh_token', 'client_id' => $googl_api_client_id_value, 'client_secret' => $googl_api_client_secret_value);
$curl = new MicroblogPoster_Curl();
$json_res = $curl->send_post_data($url, $post_args);
$response = json_decode($json_res, true);
if (isset($response['access_token']) && isset($response['token_type']) && $response['token_type'] == 'Bearer') {
$url = 'https://www.googleapis.com/urlshortener/v1/url';
$headers = array('Authorization' => "Bearer " . $response['access_token'], 'Content-type' => 'application/json');
$curl = new MicroblogPoster_Curl();
$curl->set_headers($headers);
$post_args = array('longUrl' => $long_url);
$results_enc = $curl->send_post_data_json($url, json_encode($post_args));
$results = json_decode($results_enc, true);
if (isset($results['id']) && isset($results['longUrl'])) {
return $results['id'];
} else {
$log_data = array();
$log_data['account_id'] = 0;
$log_data['account_type'] = "goo.gl";
$log_data['username'] = '******';
$log_data['post_id'] = 0;
$log_data['action_result'] = 0;
$log_data['update_message'] = '';
$log_data['log_message'] = $results_enc;
MicroblogPoster_Poster::insert_log($log_data);
return false;
}
} else {
$log_data = array();
$log_data['account_id'] = 0;
$log_data['account_type'] = "goo.gl";
$log_data['username'] = '******';
$log_data['post_id'] = 0;
$log_data['action_result'] = 0;
$log_data['update_message'] = '';
$log_data['log_message'] = $json_res;
MicroblogPoster_Poster::insert_log($log_data);
return false;
}
}
}
/**
* Shorten long url
*
* @param string $long_url
* @return array
*/
public static function shorten_long_url($long_url)
{
$url_shortener_name = "microblogposter_plg_url_shortener";
$url_shortener_value = get_option($url_shortener_name, "default");
$shortened_permalink = '';
$shortened_permalink_twitter = '';
if ($url_shortener_value == "default" || $url_shortener_value == "bitly") {
$bitly_api = new MicroblogPoster_Bitly();
$bitly_api_user_value = get_option("microblogposter_plg_bitly_api_user", "");
$bitly_api_key_value = get_option("microblogposter_plg_bitly_api_key", "");
$bitly_access_token_value = get_option("microblogposter_plg_bitly_access_token", "");
if ($bitly_api_user_value and $bitly_api_key_value or $bitly_access_token_value) {
$bitly_api->setCredentials($bitly_api_user_value, $bitly_api_key_value, $bitly_access_token_value);
$shortened_permalink = $bitly_api->shorten($long_url);
if ($shortened_permalink) {
$shortened_permalink_twitter = $shortened_permalink;
}
}
} elseif ($url_shortener_value == "googl") {
$googl_api = new MicroblogPoster_Googl();
$shortened_permalink = $googl_api->shorten($long_url);
if ($shortened_permalink) {
$shortened_permalink_twitter = $shortened_permalink;
}
} elseif ($url_shortener_value == "adfly") {
if (MicroblogPoster_Poster::is_method_callable('MicroblogPoster_Poster_Enterprise', 'shorten_with_adfly')) {
$shortened_permalink = MicroblogPoster_Poster_Enterprise::shorten_with_adfly($long_url, false);
if ($shortened_permalink) {
$adfly_api_domain_name = "microblogposter_plg_adfly_api_domain_type";
$adfly_api_domain_value = get_option($adfly_api_domain_name, "");
if ($adfly_api_domain_value == 'adfly') {
$shortened_permalink_twitter = MicroblogPoster_Poster_Enterprise::shorten_with_adfly($long_url, true);
} else {
$shortened_permalink_twitter = $shortened_permalink;
}
}
}
} elseif ($url_shortener_value == "adfocus") {
if (MicroblogPoster_Poster::is_method_callable('MicroblogPoster_Poster_Enterprise', 'shorten_with_adfocus')) {
$shortened_permalink = MicroblogPoster_Poster_Enterprise::shorten_with_adfocus($long_url);
if ($shortened_permalink) {
$shortened_permalink_twitter = $shortened_permalink;
}
}
} elseif ($url_shortener_value == "ppw") {
if (MicroblogPoster_Poster::is_method_callable('MicroblogPoster_Poster_Enterprise', 'shorten_with_ppw')) {
$shortened_permalink = MicroblogPoster_Poster_Enterprise::shorten_with_ppw($long_url);
if ($shortened_permalink) {
$shortened_permalink_twitter = $shortened_permalink;
}
}
}
return array('shortened_permalink' => $shortened_permalink, 'shortened_permalink_twitter' => $shortened_permalink_twitter);
}
/**
* Shows the MicroblogPoster's control dashboard
*
* @return string (html)
*/
function microblogposter_show_mini_control_dashboard_old()
{
?>
<br />
<style>
.mbp_social-network-accounts-site-old
{
margin-top: 10px;
margin-left: 20px;
width: 100%;
}
.mbp_social-network-accounts-site-old h4
{
background-color: #EBEBEB;
margin: 0px 0px;
padding: 3px 5px;
border-radius: 5px;
display: inline-block;
vertical-align: top;
font-size: 14px;
width: 90%;
}
.mbp_social-network-accounts-site-old a
{
font-size: 10px;
}
.mbp_social-network-accounts-site-old div
{
margin-left: 210px;
}
.mbp_social-network-accounts-site-old div span.description-small
{
margin-left: 5px;
}
.mbp_social-network-accounts-accounts
{
margin-left: 45px;
}
.mbp_social_account_microblogposter_msgcc
{
width: 290px;
/*resize: none;*/
}
</style>
<input type="hidden" name="mbp_control_dashboard_microblogposter" value="1" />
<?php
$twitter_accounts = MicroblogPoster_Poster::get_accounts_object_all('twitter');
if (!empty($twitter_accounts)) {
microblogposter_show_common_account_dashboard_head_old('twitter');
foreach ($twitter_accounts as $twitter_account) {
microblogposter_show_common_account_dashboard_old($twitter_account, 'twitter');
?>
<?php
}
}
?>
<?php
$plurk_accounts = MicroblogPoster_Poster::get_accounts_object_all('plurk');
if (!empty($plurk_accounts)) {
microblogposter_show_common_account_dashboard_head_old('plurk');
foreach ($plurk_accounts as $plurk_account) {
microblogposter_show_common_account_dashboard_old($plurk_account, 'plurk');
?>
<?php
}
}
?>
<?php
$friendfeed_accounts = MicroblogPoster_Poster::get_accounts_object_all('friendfeed');
if (!empty($friendfeed_accounts)) {
microblogposter_show_common_account_dashboard_head_old('friendfeed');
foreach ($friendfeed_accounts as $friendfeed_account) {
microblogposter_show_common_account_dashboard_old($friendfeed_account, 'friendfeed');
?>
<?php
}
}
?>
<?php
$delicious_accounts = MicroblogPoster_Poster::get_accounts_object_all('delicious');
if (!empty($delicious_accounts)) {
microblogposter_show_common_account_dashboard_head_old('delicious');
foreach ($delicious_accounts as $delicious_account) {
microblogposter_show_common_account_dashboard_old($delicious_account, 'delicious');
?>
<?php
}
}
?>
<?php
$facebook_accounts = MicroblogPoster_Poster::get_accounts_object_all('facebook');
if (!empty($facebook_accounts)) {
microblogposter_show_common_account_dashboard_head_old('facebook');
foreach ($facebook_accounts as $facebook_account) {
microblogposter_show_common_account_dashboard_old($facebook_account, 'facebook');
?>
<?php
}
}
?>
<?php
$diigo_accounts = MicroblogPoster_Poster::get_accounts_object_all('diigo');
if (!empty($diigo_accounts)) {
microblogposter_show_common_account_dashboard_head_old('diigo');
foreach ($diigo_accounts as $diigo_account) {
microblogposter_show_common_account_dashboard_old($diigo_account, 'diigo');
?>
<?php
}
}
?>
<?php
$linkedin_accounts = MicroblogPoster_Poster::get_accounts_object_all('linkedin');
if (!empty($linkedin_accounts)) {
microblogposter_show_common_account_dashboard_head_old('linkedin');
foreach ($linkedin_accounts as $linkedin_account) {
microblogposter_show_common_account_dashboard_old($linkedin_account, 'linkedin');
?>
<?php
}
}
?>
<?php
$tumblr_accounts = MicroblogPoster_Poster::get_accounts_object_all('tumblr');
if (!empty($tumblr_accounts)) {
microblogposter_show_common_account_dashboard_head_old('tumblr');
foreach ($tumblr_accounts as $tumblr_account) {
microblogposter_show_common_account_dashboard_old($tumblr_account, 'tumblr');
?>
<?php
}
}
?>
<?php
$blogger_accounts = MicroblogPoster_Poster::get_accounts_object_all('blogger');
if (!empty($blogger_accounts)) {
microblogposter_show_common_account_dashboard_head_old('blogger');
foreach ($blogger_accounts as $blogger_account) {
microblogposter_show_common_account_dashboard_old($blogger_account, 'blogger');
?>
<?php
}
}
?>
<?php
$instapaper_accounts = MicroblogPoster_Poster::get_accounts_object_all('instapaper');
if (!empty($instapaper_accounts)) {
microblogposter_show_common_account_dashboard_head_old('instapaper');
foreach ($instapaper_accounts as $instapaper_account) {
microblogposter_show_common_account_dashboard_old($instapaper_account, 'instapaper');
?>
<?php
}
}
?>
<?php
$vkontakte_accounts = MicroblogPoster_Poster::get_accounts_object_all('vkontakte');
if (!empty($vkontakte_accounts)) {
microblogposter_show_common_account_dashboard_head_old('vkontakte');
foreach ($vkontakte_accounts as $vkontakte_account) {
microblogposter_show_common_account_dashboard_old($vkontakte_account, 'vkontakte');
?>
<?php
}
}
?>
<?php
$xing_accounts = MicroblogPoster_Poster::get_accounts_object_all('xing');
if (!empty($xing_accounts)) {
microblogposter_show_common_account_dashboard_head_old('xing');
foreach ($xing_accounts as $xing_account) {
microblogposter_show_common_account_dashboard_old($xing_account, 'xing');
?>
<?php
}
}
?>
<?php
}
