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;
$classieraTable = $wpdb->prefix.'author_followers';
$wpdb->insert($classieraTable, array('author_id' => $author_id, 'follower_id' => $follower_id), array('%d', '%d'));
}
function betube_authors_unfollow($author_id, $follower_id) {
global $wpdb;
$classieraTable = $wpdb->prefix.'author_followers';
$wpdb->delete($classieraTable, array('author_id' => $author_id, 'follower_id' => $follower_id), array('%d', '%d'));
}
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';
$wpdb->insert($classieraTable, array('author_id' => $author_id, 'post_id' => $post_id), array('%d', '%d'));
}
function betube_authors_unfavorite($author_id, $post_id) {
global $wpdb;
$classieraTable = $wpdb->prefix.'author_favorite';
$wpdb->delete($classieraTable, array('author_id' => $author_id, 'post_id' => $post_id), array('%d', '%d'));
}
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 = %s", $userID);
$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*/