Count Views For Manga Chapters

If you don’t understand about coding, this is the full code for lazy ones. Just copy the code and paste it into your child theme /functions.php file. After that, switch to parent theme and the switch back to child theme to activate the code.

Click to expand...

sharcy said:

can you help me too?
Version 1.7.3.1

Click to expand...

slvrsteele said:

You have to activate child theme after you paste the function.

Also this is the full code that have to be added to functions.php in your child theme

Code:

/**
* Add columns "views" to table manga_chapters
**/
add_action("after_switch_theme", "my_manga_add_columns");
function my_manga_add_columns(){
global $wpdb;


$db = WP_MANGA_DATABASE::get_instance();
if(!$db->column_exists($wpdb->prefix . 'manga_chapters', 'views')){
$db->alter_add_column($wpdb->prefix . 'manga_chapters', 'views', 'int');
}
}


/**
* Show the views
**/
add_action('wp_manga_after_chapter_name', 'my_manga_chapter_name_info', 10, 2);


function my_manga_chapter_name_info($chapter, $manga_id){
$views = manga_get_chapter_views($chapter['chapter_id']);


echo '<span class="view"><i class="fa fa-eye"></i> ' . $views . '</span>';
}


function manga_get_chapter_views($chapter_id){
global $wpdb;
$sql = "SELECT views from {$wpdb->prefix}manga_chapters WHERE chapter_id=%d" ;


$views = $wpdb->get_var($wpdb->prepare($sql, $chapter_id));


return $views ? $views : 0;
}


add_action('wp_manga_after_update_manga_views', 'my_wp_manga_after_update_manga_views');


function my_wp_manga_after_update_manga_views(){


$manga_id = intval($_POST['manga']);
$chapter_slug = '';
if(isset($_POST['chapter']) && $_POST['chapter'] != 'undefined'){
$chapter_slug = $_POST['chapter'];
}


if($chapter_slug != ''){
global $wp_manga_chapter;


$chapter = $wp_manga_chapter->get_chapter_by_slug( $manga_id, $chapter_slug);


if($chapter){
$chapter_id = $chapter['chapter_id'];
global $wpdb;
$views = manga_get_chapter_views($chapter_id);


$wpdb->update("{$wpdb->prefix}manga_chapters", array('views'=>++$views), array('chapter_id' => $chapter_id));
}
}


}

As I said, if you have kept reading there is this paragraph: Full code for Madara-Core 1.6+ :

Click to expand...

lazyboyyy said:

my sql table name is njgxm2_
Can you edit the code properly for me? please

Click to expand...

/**
* Add columns "views" to table njgxm2_manga_chapters
**/
add_action("after_switch_theme", "my_manga_add_columns");
function my_manga_add_columns(){
global $wpdb;


$db = WP_MANGA_DATABASE::get_instance();
if(!$db->column_exists($wpdb->prefix . 'njgxm2_manga_chapters', 'views')){
$db->alter_add_column($wpdb->prefix . 'njgxm2_manga_chapters', 'views', 'int');
}
}


/**
* Show the views
**/
add_action('wp_manga_after_chapter_name', 'my_manga_chapter_name_info', 10, 2);


function my_manga_chapter_name_info($chapter, $manga_id){
$views = manga_get_chapter_views($chapter['chapter_id']);


echo '<span class="view"><i class="fa fa-eye"></i> ' . $views . '</span>';
}


function manga_get_chapter_views($chapter_id){
global $wpdb;
$sql = "SELECT views from {$wpdb->prefix}njgxm2_manga_chapters WHERE chapter_id=%d" ;


$views = $wpdb->get_var($wpdb->prepare($sql, $chapter_id));


return $views ? $views : 0;
}


add_action('wp_manga_after_update_manga_views', 'my_wp_manga_after_update_manga_views');


function my_wp_manga_after_update_manga_views(){


$manga_id = intval($_POST['manga']);
$chapter_slug = '';
if(isset($_POST['chapter']) && $_POST['chapter'] != 'undefined'){
$chapter_slug = $_POST['chapter'];
}


if($chapter_slug != ''){
global $wp_manga_chapter;


$chapter = $wp_manga_chapter->get_chapter_by_slug( $manga_id, $chapter_slug);


if($chapter){
$chapter_id = $chapter['chapter_id'];
global $wpdb;
$views = manga_get_chapter_views($chapter_id);


$wpdb->update("{$wpdb->prefix}njgxm2_manga_chapters", array('views'=>++$views), array('chapter_id' => $chapter_id));
}
}


}

magic597 said:

PHP:

/**
* Add columns "views" to table njgxm2_manga_chapters
**/
add_action("after_switch_theme", "my_manga_add_columns");
function my_manga_add_columns(){
global $wpdb;


$db = WP_MANGA_DATABASE::get_instance();
if(!$db->column_exists($wpdb->prefix . 'njgxm2_manga_chapters', 'views')){
$db->alter_add_column($wpdb->prefix . 'njgxm2_manga_chapters', 'views', 'int');
}
}


/**
* Show the views
**/
add_action('wp_manga_after_chapter_name', 'my_manga_chapter_name_info', 10, 2);


function my_manga_chapter_name_info($chapter, $manga_id){
$views = manga_get_chapter_views($chapter['chapter_id']);


echo '<span class="view"><i class="fa fa-eye"></i> ' . $views . '</span>';
}


function manga_get_chapter_views($chapter_id){
global $wpdb;
$sql = "SELECT views from {$wpdb->prefix}njgxm2_manga_chapters WHERE chapter_id=%d" ;


$views = $wpdb->get_var($wpdb->prepare($sql, $chapter_id));


return $views ? $views : 0;
}


add_action('wp_manga_after_update_manga_views', 'my_wp_manga_after_update_manga_views');


function my_wp_manga_after_update_manga_views(){


$manga_id = intval($_POST['manga']);
$chapter_slug = '';
if(isset($_POST['chapter']) && $_POST['chapter'] != 'undefined'){
$chapter_slug = $_POST['chapter'];
}


if($chapter_slug != ''){
global $wp_manga_chapter;


$chapter = $wp_manga_chapter->get_chapter_by_slug( $manga_id, $chapter_slug);


if($chapter){
$chapter_id = $chapter['chapter_id'];
global $wpdb;
$views = manga_get_chapter_views($chapter_id);


$wpdb->update("{$wpdb->prefix}njgxm2_manga_chapters", array('views'=>++$views), array('chapter_id' => $chapter_id));
}
}


}

Click to expand...