Reward groups

[info2862]

Hi,

How does one remove reward groups?
Let's say I only want Group A, B, and C. Right now it goes until G and I can't figure out how to remove a group.

 

[ysmods]

You can de-select the countries in the group by holding down ctrl and clicking on the active/selected countries.
That will in theory disable the groups, but I'm not sure if the listing for the groups will continue to show on the rewards info page.

 

[info2862]

I tried that, but then it still lists it and says "other"

 

[ysmods]

I'll have a look at the code in the morning. Its currently 6am here and I've not slept yet.

 

[info2862]

Any luck?

 

[ysmods]

Easiest way to remove listings is to actually delete the database rows from the "plugin_reward_ppd_group" table.



Depending on which groups you want to delete will depend on which query you want to use.

DO NOT RUN ALL QUERIES, ONLY USE THE QUERY FOR THE GROUPS YOU DO NOT WANT TO USE

Will delete group "A"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =1 LIMIT 1;

Will delete group "B"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =2 LIMIT 1;

Will delete group "C"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =3 LIMIT 1;

Will delete group "D"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =4 LIMIT 1;

Will delete group "E"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =5 LIMIT 1;

Will delete group "F"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =6 LIMIT 1;

Will delete group "G"

DELETE FROM  `plugin_reward_ppd_group` WHERE  `plugin_reward_ppd_group`.`id` =7 LIMIT 1;

 

[dizo20082850]

That worked well for getting rid of some groups
but still the last group adds up the "other" at the end. how can I get rid of that?
(see attached)