[Denis Miller]

in reply to: Filter out spammers #8666

In wordpress I pressed button ‘spam’ against the user and I could find this flag here:

select * from wp_users where user_status = 1

This query returns all spammers.

I don’t know. Maybe it’s BuddyPress feature. Not sure.

[Denis Miller]

in reply to: Monthly Top #8606

Hmm… small mistake. This script works better

	INSERT INTO badgeos_leaderboard (day, user_id, total, points)	
		SELECT CURDATE(), u.user_id, u.meta_value, cast(u.meta_value AS SIGNED) - IFNULL(l.total, 0)
			FROM wp_usermeta u
				LEFT JOIN badgeos_leaderboard l ON u.user_id = l.user_id and l.day = DATE_ADD(CURDATE(), INTERVAL -1 DAY)
			WHERE u.meta_key = '_badgeos_points' 

[Denis Miller]

in reply to: Monthly Top #8605

Actually it counts ‘internal points’ (not visible for user) 🙁

I created daily script and cron it. I create table badgeos_leaderboard and store current total amount (total) and today earned amount (points).

INSERT INTO badgeos_leaderboard (day, user_id, total, points)	
	SELECT CURDATE(), u.user_id, u.meta_value, u.meta_value - l.points
		FROM wp_usermeta u
			LEFT JOIN badgeos_leaderboard l ON u.user_id = l.user_id and l.day = DATE_ADD(CURDATE(), INTERVAL -1 DAY)
		WHERE u.meta_key = '_badgeos_points' 

[Denis Miller]

in reply to: Monthly Top #8598

Here is an extension:

https://www.dropbox.com/sh/m6l3mlpc4u26i2b/AABgxFUVY1-U5VBdc1C68tlsa?dl=0

[badgeos_leaderboard name=”Points” days=”31″]

Some ideas, hope it will be reviewed, improved and included into new version 🙂

[Denis Miller]

in reply to: How to translate header: UserName – Points #8453

…deleted…

[Denis Miller]

in reply to: Monthly Top #8417

Dennis, I mean something like this:

[badgeos_leaderboard name=”Points” days=”31″]

Or maybe some hard-coded solutions is also fine.

Only show for the last 31 days. Actually I did customization and got results. But It so ugly.

BTW, the new idea is

[badgeos_leaderboard name=”Points” period=”month”]

This case is more interesting. Because each month we could start from the scratch. And do some ramification around this. It will show for the current month only. From the first day of the month.

[badgeos_leaderboard name=”Points” period=”month/year/week/quarter”]

I just want to put some competition in my community. Using only Reports is not good enough. Because people could not see it.

PS. Or maybe it could be part of leaderboard configuration (as setting)

[Denis Miller]

in reply to: Filter admin and support team accounts #8413

Ok. I will do hack 🙂

wp-content/plugins/BadgeOS-Leaderboard-Add-on/includes/display.php

// Only continue if we have non-corrupt user metrics
		if ( is_array( $user_metrics) &&  $user_metrics['user_id'] != 1 ) {

where 1 is admin user id.

[Denis Miller]

in reply to: WooCommerce crashed #8396

This reply has been marked as private.

[Denis Miller]

in reply to: Monthly Top #8394

Any guideline or any recommendation how to make it quickly?

[Denis Miller]

in reply to: Active User Report Shows Double Activity #8393

Do you have any plans to extend this functionality?

Reason: I have monthly client review and I would like to send some gifts. But now it’s difficult to understand the “real” status.

[Denis Miller]

in reply to: Display Name Vs User Name #8388

Nice solution! Thanks!

[Denis Miller]

in reply to: Monthly Top #8387

Any news how to make it? Maybe it was done by somebody?

[Denis Miller]

in reply to: Active User Report Shows Double Activity #8386

But how to get report about earned points? Not partial steps.

Points are shown in the widget or user profile.

[Denis Miller]

in reply to: WooCommerce crashed #8385

This reply has been marked as private.

[Denis Miller]

in reply to: WooCommerce crashed #8379

Today I tried to use again AutoMessage. It still doesn’t work 🙁

WooCommerce + Auto Message are still not working properly.

Here is repro steps:
https://www.youtube.com/watch?v=0JK2DppC1jw

Try to use test environment:

http://TEST.DENISMILLER.RU/PRODUCT/TEST-PRODUCT/

user: test1
psw: test1

[Denis Miller]

in reply to: Doesn't work witg comments #8378

sorry, wrong thread

WooCommerce crashed

[Denis Miller]

in reply to: WooCommerce crashed #7208

Unfortunatly hotfix doesn’t work.

And cart problem is reproduced here:
http://lobowa.ru/product/idealmuz/

Details:
https://www.dropbox.com/s/dxyx1tx4qm9qxdz/cart.png?dl=0

[Denis Miller]

in reply to: Leaderboard and Report show different numbers #7207

More issues:

https://www.dropbox.com/s/8v28ygwsm9awmor/more%20errors.png?dl=0

[Denis Miller]

in reply to: Leaderboard and Report show different numbers #7197

The problem is value for the leaders are the same for any time frame.

Looks like leaderboard shows correct number. But reports shows random 🙁

[Denis Miller]

in reply to: WooCommerce crashed #7191

What aboud BadgeOS Auto Messages Add-On?
It removes cart while creating the order 🙁

https://www.dropbox.com/s/dxyx1tx4qm9qxdz/cart.png?dl=0

[Author]

Posts