prefix}author_followers (
id int(11) NOT NULL AUTO_INCREMENT,
author_id int(11) NOT NULL,
follower_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1;");
$wpdb->query($sql2);
$sql = ("CREATE TABLE IF NOT EXISTS {$wpdb->prefix}author_favorite (
id int(11) NOT NULL AUTO_INCREMENT,
author_id int(11) NOT NULL,
post_id int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1;");
$wpdb->query($sql);
}
add_action( 'init', 'betube_authors_tbl_create', 1 );
function betube_authors_insert($author_id, $follower_id) {
global $wpdb;
$author_insert = ("INSERT into {$wpdb->prefix}author_followers (author_id,follower_id)value('".$author_id."','".$follower_id."')");
$wpdb->query($author_insert);
}
function betube_authors_unfollow($author_id, $follower_id) {
global $wpdb;
$author_del = ("DELETE from {$wpdb->prefix}author_followers WHERE author_id = $author_id AND follower_id = $follower_id ");
//print_r($author_del);
$wpdb->query($author_del);
}
function betube_authors_follower_check($author_id, $follower_id) {
global $wpdb;
$results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}author_followers WHERE follower_id = $follower_id AND author_id = $author_id", OBJECT );
if(empty($results)){
?>
get_results("SELECT * FROM {$wpdb->prefix}author_followers WHERE author_id = $author_id", OBJECT );
if(!empty($results)){
foreach ( $results as $ids ){
$avatar = $ids->follower_id;
?>
get_results("SELECT * FROM {$wpdb->prefix}author_followers WHERE follower_id = $author_id", OBJECT );
if(!empty($results)){
foreach ( $results as $ids ){
$avatar = $ids->author_id;
?>
prefix}author_favorite (author_id,post_id)value('".$author_id."','".$post_id."')");
//print_r($author_insert); exit();
$wpdb->query($author_insert);
}
function betube_authors_unfavorite($author_id, $post_id) {
global $wpdb;
$author_del = ("DELETE from {$wpdb->prefix}author_favorite WHERE author_id = $author_id AND post_id = $post_id ");
$wpdb->query($author_del);
}
function betube_authors_favorite_check($author_id, $post_id) {
global $wpdb;
$results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}author_favorite WHERE post_id = $post_id AND author_id = $author_id", OBJECT );
if(empty($results)){
?>
get_results("SELECT `post_id` FROM $wpdb->postmeta WHERE `meta_key` ='_wp_page_template' AND `meta_value` = 'template-favorite.php' ", ARRAY_A);
$all_fav_permalink = get_permalink($all_fav[0]['post_id']);
echo '';
}
}
function betube_authors_favorite_remove($author_id, $post_id) {
global $wpdb;
$results = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}author_favorite WHERE post_id = $post_id AND author_id = $author_id", OBJECT );
if(!empty($results)){
?>
prepare( "SELECT post_id FROM {$wpdb->prefix}author_favorite WHERE author_id = $author_id", OBJECT );
$postids = $wpdb->get_col( $prepared_statement );
return $postids;
}
function betubeFollowerCount($author_id) {
global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}author_followers WHERE author_id = $author_id", OBJECT );
$followcounter = count($results);
return $followcounter;
}
function betubeFavoriteCount($author_id){
global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}author_favorite WHERE author_id = $author_id", OBJECT );
$favoritecounter = count($results);
return $favoritecounter;
}
/*End betube Favourite Function*/