_( 'AHApage Content Shared' ),
'second' => _( 'Login user share' )
);
$page= wp_unslash($_SERVER['QUERY_STRING']);
echo $setting->aha_menu_tab($_GET , $tabs, $page) ;
$get = (isset($_GET['tab']) ? sanitize_text_field($_GET['tab']) : 'first' );
global $wpdb;
$prefix = $wpdb->prefix ;
$id = (isset($_GET['id']) ? intval($_GET['id']) : '' );
$resultz = $wpdb->get_results( 'SELECT * FROM '.$prefix.'aha_api WHERE id = ' .$id );
if(!empty($resultz)){
$key = ($resultz[0]->api_key != '' ? $resultz[0]->api_key : '' );
}
}
if(sanitize_text_field($_GET['page']) == 'AHAthat_widget'){
global $wpdb;
$prefix = $wpdb->prefix ;
if(isset($_GET['order']) AND sanitize_text_field($_GET['order']) == 'desc'){
$order = "ORDER BY ".$prefix."aha_api.name DESC" ;
}else{
$order = "ORDER BY ".$prefix."aha_api.name ASC" ;
}
$data = $wpdb->get_results( "SELECT SUM(".$prefix."aha_report.twitter) as twitter,SUM(".$prefix."aha_report.linkedin) as linkedin,SUM(".$prefix."aha_report.fb) as fb,".$prefix."aha_report.book_name,".$prefix."aha_api.name FROM ".$prefix."aha_report INNER JOIN ".$prefix."aha_api ON ".$prefix."aha_report.w_id=".$prefix."aha_api.id WHERE ".$prefix."aha_report.w_id = '".$id."' GROUP BY ".$prefix."aha_report.book_id ".$order.";" );
}else{
global $wpdb;
$prefix = $wpdb->prefix ;
if(isset($_GET['order']) AND sanitize_text_field($_GET['order']) == 'desc'){
$order = "ORDER BY ".$prefix."aha_api.name DESC" ;
}else{
$order = "ORDER BY ".$prefix."aha_api.name ASC" ;
}
require dirname (dirname( __FILE__ ) ) .'/functions/aha_setting_function.php' ;
$setting = new Aha_setting_function;
$tabs = array(
'first' => "All Content Shared"
);
$page = wp_unslash($_SERVER['QUERY_STRING']);
echo $setting->aha_tabs($_GET , $tabs, $page) ;
$get = (isset($_GET['tab']) ? sanitize_text_field($_GET['tab']) : 'first' );
$data = $wpdb->get_results( "SELECT SUM(".$prefix."aha_report.twitter) as twitter,SUM(".$prefix."aha_report.linkedin) as linkedin,SUM(".$prefix."aha_report.fb) as fb,".$prefix."aha_report.book_name,".$prefix."aha_api.name FROM ".$prefix."aha_report INNER JOIN ".$prefix."aha_api ON ".$prefix."aha_report.w_id=".$prefix."aha_api.id GROUP BY ".$prefix."aha_report.book_id ".$order.";" );
}
?>
All Content Shared
AHApage Content Shared
get_results( "SELECT * FROM ".$prefix."aha_report WHERE app_id = '".$key."' AND user_id != 0" );
}else{
$data = $wpdb->get_results( "SELECT * FROM ".$prefix."aha_report WHERE user_id != 0" );
} ?>
Share Record
AHAbook Shares
| Name |
Email |
AHAbook |
Facebook |
Twitter |
Linkedin |
get_results("SELECT * FROM `".$prefix."bookData` WHERE `id` = '".$datas->book_id."' LIMIT 1") ; */
?>
| name;?> |
email;?> |
book_name;?> |
fb ;?> |
twitter ;?> |
linkedin ;?> |