Hey everyone,
I've been working for the last few months on a group management tool, that will greatly reduce the effort needed to manage a SG group, by automating as much of it as possible.

Tool current features:

  • UserCheckRules - Check if a user (usually candidate) complies with group rules. Response example: https://imgur.com/a/oCL3N
  • CheckMonthly - Returns a list of all users who didn\'t create a "monthyl" giveaway in a given month (according to defined rules). Response example: https://imgur.com/a/4RsM9
  • UserCheckFirstGiveaway - Check if users comply with first giveaway rules (according to defined rules). Response example: https://imgur.com/a/afSBB
  • UserFullGiveawaysHistory - For a single user, show a detailed list of all giveaways he either created or participated in (Game link, value, score, winners, etc.). Response example: https://imgur.com/a/FQaqz
  • GroupUsersSummary - For a given group, return summary of all giveaways created, entered and won by members. Response example: https://imgur.com/a/WSkt1
  • PopularGiveaways - Get most popular giveaways in a group in a given month. Response example: https://imgur.com/a/jeICUOm

The tool is built to run as a Service, and uses MySql DB to store it's data.
Run time of each command (except UserCheckRules) is less than 1 second.

I'm currently using the tool to manage my own group:https://www.steamgifts.com/discussion/jMqJT/quality-games-giveaways-qgg-group-special-gas-life-is-strange-before-the-storm-prey-open
And it's working out well. I have a good overview of what's happening in the group, and a good level of control.
And it takes seconds to check rules compliance, etc.

Source code can be found here: https://github.com/AlexMilman/steamgifts-group-management-tool
Tool demo can be found here: http://www.sgmt.name:8080/SGMT/

1 year ago*

Comment has been collapsed.

Sounds nice, but I would guess it will run rather slow until caching is implemented.

1 year ago
Permalink

Comment has been collapsed.

Yes, it takes minutes - hours (depending on group size) to run each command.
But when you need unfrequent stuff (like checking monthly GAs, which you only need a couple of times a month), it's not that bad.

1 year ago
Permalink

Comment has been collapsed.

I've made some modifications to the tool.
It now runs as a Service, and keeps all it's data in MySql.
Subsequently, most commands take less than 1 second to execute.
In the near future, I'm planning on deploying it on a remote server (probably in AWS) for easier access.

1 year ago
Permalink

Comment has been collapsed.

Added response examples.

1 year ago
Permalink

Comment has been collapsed.

this tool is great lol

1 year ago
Permalink

Comment has been collapsed.

This looks interesting...

1 year ago
Permalink

Comment has been collapsed.

Have a bump for the good work

1 year ago
Permalink

Comment has been collapsed.

Cool!

1 year ago
Permalink

Comment has been collapsed.

Added new feature: Ability to see most popular giveaways per month

8 months ago
Permalink

Comment has been collapsed.

Wow, I was just thinking about asking you how you were able to run the QGG group, and now I know. :)

2 months ago
Permalink

Comment has been collapsed.

That's impressive

2 months ago
Permalink

Comment has been collapsed.

Tool location has moved to http://www.sgmt.name:8080/SGMT/

Anyone using it - please be advised you need to change your links.

4 weeks ago
Permalink

Comment has been collapsed.

Sign in through Steam to add a comment.