Author Topic: Disabling Cubbies Stickers  (Read 1982 times)

Eric Berry

  • Full Member
  • ***
  • Posts: 44
Disabling Cubbies Stickers
« on: October 08, 2011, 06:14:48 PM »
What is the SQL commannd to remove all of the Cubbies stickers as awards?  I don't need to be notified about every single sticker that needs to be given out.

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 339
    • Approved Workman
Re: Disabling Cubbies Stickers
« Reply #1 on: October 09, 2011, 10:42:59 AM »
Notice on the Award Message dialog there is a checkbox that says "For Cubbies, do not show this Award Message for all subequent awards today."  Using this checkbox you will only see ONE notification.

I know this is not exactly what you asked for, but I think it solves the problem.
Rick at Leffler Systems
Murfreesboro, Tennessee

Eric Berry

  • Full Member
  • ***
  • Posts: 44
Re: Disabling Cubbies Stickers
« Reply #2 on: October 11, 2011, 05:06:31 PM »
That also seems to disable notification of the patches too, which I don't want to do.

Rick Leffler

  • Administrator
  • Sr. Member
  • *****
  • Posts: 339
    • Approved Workman
Re: Disabling Cubbies Stickers
« Reply #3 on: October 11, 2011, 07:26:36 PM »
If you want to clear all of the award triggers for all of the individual Cubbies Stickers for all sections in all of the Cubbies books, you can run the following SQL:

update Gen_Section set Award_1=null, Award_2=null,
Award_1_Item_Number=null, Award_2_Item_Number=null
where Book_ID in (300,301,302,303,304)


Note: Running this SQL statement will NOT affect the award triggers for the Cubbies patches since the patches are part of the Section GROUP award records you see on the last page of the generic handbook screen.
Rick at Leffler Systems
Murfreesboro, Tennessee