Ulisses Carvalho

Ajay,

Quick update! I must tell you that I have deleted both database tables (wp_top_ten and wp_top_ten_daily) before deleting the Top 10 plugin as well. I have since reinstalled it and here’s where it stands right now:

Alter trigger: wp_top_ten_daily
Time AFTER
Event UPDATE
Type FOR EACH ROW
Name: wp_top_ten_daily
UPDATE wp_top_ten_daily SET blog_id = 1 WHERE blog_id = 0

It seems I have managed to make the changes to the database tables. Top 10, however, tracked only one post and only once. That’s it!

Thanks a lot!

Ajay,

I decided to give it a go! Here’s what I’ve got so far:

Table: wp_top_ten_daily
Select data Show structure Alter table New item
Column Type Comment
postnumber bigint(20)
cntaccess bigint(20)
dp_date datetime
blog_id bigint(20)
Indexes
PRIMARY postnumber, dp_date, blog_id
Alter indexes
Triggers
Add trigger

—

Then I went on to create the trigger:

Create trigger

Time: (I’ve tried with both BEFORE and AFTER)
Event: UPDATE
Type: FOR EACH ROW (that’s the only alternative available)
Name: wp_top_ten_daily

SET blog_id = 1 WHERE blog_id = 0

But then I got the following error message:

Unknown system variable ‘blog_id’ 00:39:47 SQL command

Am I close enough? Should I forget all about it and hire a pro? Thanks again!

Take care

Ajay,

Thank you for the outstanding support. This is however way out of my league. I might as well hire a developer just to be on the safe side.

Thanks again!

Ajay,

Quick update: I managed to get your plugin running again by disabling the alternative home page in LeadPages then reinstalling Top 10. And, yes, you’re right, the daily code is not working at all. The overall rank seems to be ok though.

I have now inserted the code in functions.php.

Here’s the info you requested. I hope that’s what you need.

wp_top_ten_daily

postnumber int(11)
cntaccess int(11)
dp_date date
Indexes
PRIMARY postnumber, dp_date

wp_top_ten

postnumber bigint(20)
cntaccess bigint(20)
blog_id bigint(20)
Indexes
PRIMARY postnumber, blog_id

Thanks again. I really appreciate your help.

Ajay,

Thank you for your reply. The URL is https://www.teclasap.com.br

I’ve also tried adding the function to a couple of places in the functions.php but I’m not a developer. I just don’t know where exactly to put it. Could you please let me know where I should insert the piece of code you sent me? Thank you! This is the functions.php file of the Parabola theme:

<?php
/*
* Functions file
* Calls all other required files
* PLEASE DO NOT EDIT THIS FILE IN ANY WAY
*
* @package parabola
*/

// variable for theme version
define (“PARABOLA_VERSION”,”1.4.2″);

require_once(dirname(__FILE__) . “/admin/main.php”); // Load necessary admin files

//Loading include files
require_once(dirname(__FILE__) . “/includes/theme-setup.php”); // Setup and init theme
require_once(dirname(__FILE__) . “/includes/theme-styles.php”); // Register and enqeue css styles and scripts
require_once(dirname(__FILE__) . “/includes/theme-loop.php”); // Loop functions
require_once(dirname(__FILE__) . “/includes/theme-meta.php”); // Meta functions
require_once(dirname(__FILE__) . “/includes/theme-frontpage.php”); // Frontpage styling
require_once(dirname(__FILE__) . “/includes/theme-comments.php”); // Comment functions
require_once(dirname(__FILE__) . “/includes/theme-functions.php”); // Misc functions
require_once(dirname(__FILE__) . “/includes/theme-hooks.php”); // Hooks

add_action( ‘bbp_theme_after_reply_author_details’, ‘add_rank_in_author_details’ );
function add_rank_in_author_details()
{
$reply_id = bbp_get_reply_id();
if ( bbp_is_reply_anonymous( $reply_id ) ) return;
$user_id = bbp_get_reply_author_id( $reply_id );
if ( mycred_exclude_user( $user_id ) ) return;

// Second the logo (but you can change this)
echo mycred_get_users_rank( $user_id, ‘logo’ );
}
?>

Thank you!