Edit 8/28/2020 - dlrgames
Updated the wording displayed when the addon is building the database.
Please see the comments channel for a VERY useful process to speed up processing of Guild bank records.


Edit 4/17/2020 - dlrgames

New version with API updated for Harrowstorm. No other changes have been made.
Please note that due to the Guild data API changes collecting all the deposit info for a Guild raffle can take a LONG time. Even a small number of records may require over an hour!
If the addon tells you it needs to update the database, please be patient and let it run. It will tell you when it is ready.

Edit 1/2/2020 - dlrgames

I've uploaded a new version updated for the new API introduced with Scalebreaker (U23) and made a few small corrections in the tooltips. All functionality remains the same.

The embedded libraries have been removed, you will need to install the latest LibAddonMenu-2.0 seperately.

If you need an updated version of the addon with the Regrouper Workaround slash commands, you can find it here.

------------------------------------------------------------------------------
Raffle Gold is a convenient method for handling raffle percentages for gold while in-game.

Invalid Start / End Date: If you receive a message about an invalid start and/or end date after an update to the API and/or game client, select a different date, choose your previously selected date and the addon will work as intended.

You can access Raffle Gold by going to Settings -> Addon Settings -> Raffle Gold
or type in your chat window: /rafflegold

------------------------------------------------------------------------------
How to manually install addons:

1. Locate the "Elder Scrolls Online" folder in your Documents
   For Windows: C:\Users\<username>\Documents\Elder Scrolls Online\<version>\
   For Mac: ~/Documents/Elder Scrolls Online/<version>/
   (replace <version> with the client you're using - "live" or "liveeu")
2. You should find an AddOns folder, if you don't, create one.
3. Extract the addon from the downloaded zip file into the AddOns folder.
4. Log into the game, and on the character creation/selection screen you'll find the Addons menu. Enable your addons from there.

------------------------------------------------------------------------------

Raffle Gold offers two options for selecting raffle winners.

Option 1 - Basic Raffle Drawing

• Entry Price: Amount required to purchase raffle tickets. Required only if not using Total Amount below.
• 1st Place %: The percentage that the first place winner wins, based on the total amount of tickets purchased.
• 2nd Place %: The percentage that the second place winner wins. (a zero amount will negate this, and 3rd, option)
• 3rd Place %: The percentage that the third place winner wins. (see 1st and 2nd place for more information)
• Total Entries: The total number of entries, not tickets, purchased.
• Total Amount: The total amount generated from the raffle. Only required if Entry Price is empty above. If both Entry Price and this have values, then the addon will check the math.
• Draw Raffle: This will check the information above and output the winning raffle ticket numbers and the amount that each place wins into the chat window.

Option 2 - Guild Bank Raffle Drawing

• Entry Price: Amount required to purchase raffle tickets. (Required)
• (OPTIONAL) Price per Ticket: The actual ticket price. Example: entry fee is $1k, but you get 10x tickets, this would be $100 per ticket
• 1st Place %: The percentage that the first place winner wins, based on the total amount of tickets purchased.
• 2nd Place %: The percentage that the second place winner wins. (a zero amount will negate this, and 3rd, option)
• 3rd Place %: The percentage that the third place winner wins. (see 1st and 2nd place for more information)
• Guild: The guild that you would like to use to draw the raffle.
• Exclude Guild Rank(s) #: The guild rank(s) to exclude, in the order they appear in the guild pane, and above for any deposits made in increments of the "Entry Price". 1 = Guild Master
  For example: selecting #3 will exclude that rank as well as #1 and #2
• Starting Amount $: This is the base amount being offered, without any raffle tickets even being purchased. (Any raffle tickets purchased will only build upon this amount, but can help if there is minimal participation for those that do enter)
• Starting Date: This is the date that entries started being deposited for the raffle.
• Starting Time: This is the time that entries started being deposited. (this should be based on your system time and not server)
• Ending Date: This is the date that the entries finished being deposited for the raffle.
• Ending Time: Any deposits made after this time, on the Ending Date, will be excluded from this raffle.
• Prizes Per Username: The number of allowed prizes per username.
  • One: Can only win one of the 3 places
  • Multiple: Winners selected based on first ticket # drawn
• Guild Raffle: This will compile the guild bank's history and output to the chat window when it is ready to continue.
  Clicking this again will let you know how many entries, the number of tickets (if different from entries), the amount, time remaining (if it hasn't ended yet), the username of each winner (once the raffle has finished), the ticket number and amount won.
• Display Results: This does the same thing as Guild Raffle, but will include the amount that the guild earned, if the raffle has ended.

------------------------------------------------------------------------------
Slash Commands

/rafflegold - Opens the settings menu UI
/rg help - Displays the list of commands
/rg help set - Displays the command settings
/rg help list - Displays the commands for showing the current setting(s)
/rg help draw - Displays the commands for drawing the raffle
/rg help reset - Displays the commands for resetting the raffle

Raffle Settings

/rg set entry price <AMOUNT> - Sets the "Entry Price"
/rg set ticket price <AMOUNT> - Sets the "Ticket Price"
/rg set first place <PERCENT> - Sets the "1st Place" percentage
/rg set second place <PERCENT> - Sets the "2nd Place" percentage
/rg set third place <PERCENT> - Sets the "3rd Place" percentage
/rg set total entries <AMOUNT> - Sets the "Total Entries" for Basic Raffle
/rg set total amount <AMOUNT> - Sets the "Total Amount $" for Basic Raffle
/rg set guild <GUILD_NAME> - Sets the "Guild" for Guild Bank Raffle (case sensitive)
/rg set rank <GUILD_RANK_NUMBER> - Sets the "Exclude Guild Rank(s)" for Guild Bank Raffle (numeric value)
/rg set start amount <AMOUNT> - Sets the "Starting Amount $" for Guild Bank Raffle
/rg set start date <M/D/YYYY> - Sets the "Starting Date" for Guild Bank Raffle
/rg set start time <H:MM> - Sets the "Starting Time" for Guild Bank Raffle (military format)
/rg set end date <M/D/YYYY> - Sets the "Ending Date" for Guild Bank Raffle
/rg set end time <H:MM> - Sets the "Ending Time" for Guild Bank Raffle (military format)
/rg set prizes <One OR Multiple> - Sets the number of prizes a username can win per raffle
/rg set bonus <AMOUNT> <QUANTITY> - Gives QUANTITY of free tickets when AMOUNT of tickets purchased, per deposit, not username
/rg set bonus multi <YES or NO> - Sets whether a deposit can receive multiple bonuses, default is "YES"

List Raffle Settings

/rg list entry price - Displays the "Entry Price" amount
/rg list ticket price - Displays the "Price per Ticket" amount
/rg list percents - Displays the percentages for 1st, 2nd and 3rd
/rg list first place - Displays the "1st Place" percentage
/rg list second place - Displays the "2nd Place" percentage
/rg list third place - Displays the "3rd Place" percentage
/rg list basic settings - Displays the "Basic Raffle" specific settings
/rg list total entries - Displays the "Total Entries" for the Basic Raffle
/rg list total amount - Displays the "Total Amount" for the Basic Raffle
/rg list guild settings - Displays the "Guild Bank Raffle" specific settings
/rg list guild - Displays the "Guild" for the Guild Bank Raffle
/rg list rank - Displays the "Exclude Guild Rank(s)" for the Guild Bank Raffle
/rg list start amount - Displays the "Starting Amount" for the Guild Bank Raffle
/rg list start date - Displays the "Starting Date" for the Guild Bank Raffle
/rg list start time - Displays the "Starting Time" for the Guild Bank Raffle
/rg list end date - Displays the "Ending Date" for the Guild Bank Raffle
/rg list end time - Displays the "Ending Time" for the Guild Bank Raffle
/rg list prizes - Displays the "Prizes Per Username" for the Guild Bank Raffle
/rg list bonus - Displays all ticket purchase amounts and the number of free tickets for that amount

Raffle Drawing

/rg draw basic - This will draw the Basic Raffle
/rg basic results - Results from the last Basic Raffle drawing
/rg draw guild - This will run the Guild Bank Raffle\n(In-progress displays information; Ended displays winners)
/rg guild results - Results from the last Guild Bank Raffle drawing\n(A new draw will overwrite this information)
/rg entry <ENTRY_NUMBER> - Displays username, number of tickets, ticket numbers and amount deposited
/rg entry <USERNAME> - Displays all entries for the username, with a total deposited amount
/rg draw first - This will draw only the 1st place winner
/rg draw second - This will draw only the 2nd place winner
/rg draw third - This will draw only the 3rd place winner

Reset Raffle Settings

/rg reset all - Resets ALL of the stored information
/rg reset defaults - Resets only the default UI information
/rg reset bonus - Resets all bonus ticket amounts
/rg remove bonus <AMOUNT> - Removes bonus tickets for the specified amount

------------------------------------------------------------------------------

How does Raffle Gold work?
Raffle Gold does nothing more than simple math and selecting random numbers when using the basic raffle option.
The guild bank raffle utilizes the game's built-in API calls to query and compile the guild bank transactions within the timeframe specified. This does not interact with anything in the guild bank, whether items or currency. Using the guild bank raffle system ensures that there is a record available to all guild members of those that made a deposit.

For anyone concerned about Raffle Gold doing anything while in the guild bank, just keep in mind that you cannot access the settings menu, which is how you would interact with Raffle Gold, while using the guild bank.

The following Q and A directly pertains to the guild bank raffle option...

Can I make a deposit into the guild bank without buying raffle tickets?
Yes. You will just need to make a deposit that is not in increments of the entry price.
For example: if the entry price is $1k, $3,001 or $2999 would not count towards the raffle

Can I buy raffle tickets in bulk?
Yes. As long as the amount deposited can be divided by the entry amount it will be considered a raffle ticket purchase.
For example: if the entry price is $500, $9k and $16.5k would both be considered raffle ticket purchases

How are the raffle ticket numbers assigned?
In the order purchased, oldest to newest deposits.
For example: entry amount = 1k, price per ticket = zero
Guild Member #1 deposits 3k, they'd have ticket numbers 1, 2 and 3
Guild Member #2 deposits 1k, they'd have ticket number 4
Guild Member #3 deposits 5k, they'd have ticket numbers 5 - 9
Guild Member #1 deposits 2k, they'd also have ticket numbers 10 and 11

Why are there options to select just 1st, 2nd or 3rd place?
If you have any players that would like to donate to the raffle, but do not want to actually be selected during the drawing, you can use this feature to choose a different winner. It is recommended that you run for the entire raffle and update/replace anyone that was selected that didn't intend/want to be chosen.

Can I list items using Raffle Gold
No. But you could use the Raffle Unlimited addon that allows you to raffle items, gold (at a flat rate) and/or free raffle tickets (for the next raffle).

Will Raffle Gold interfere with other addons?
Raffle Gold will only scan your guild bank history when you draw and/or check the stats for the current raffle that is in-progress. It is a completely on-demand addon, and once it has compiled the information it will be dormant, until you run it again.

Limitations

• Deposits that are made within the last minute might not appear when using the "Guild Raffle" to get the (current) results.
  Try waiting ~1 minute to use the "Guild Raffle" ability, which should include the deposit(s) in question.

• The guild history on the server stores only 10 days worth of information, so it is important that this tool is used in a timely manner once a raffle has ended, to ensure that the information isn't lost.

• Guilds that have plenty of guild bank transactions can take longer to build the information, but Raffle Gold will let you know in the chat window when it has finished and is ready for use.

• There currently is no method for exporting in-game data to an external file, but any of the saved variables are stored in a file. IF you would like to access the information for the entrants when using the Guild Bank Raffle Drawing, the SavedVariables\RaffleGold.lua contains the entrant's information, i.e. entry number, username, number of tickets, amount deposited and raffle ticket number(s).
  The only issue is you will need to parse this information, if you would like to post it anywhere in a readable format. A parsing tool for Raffle Gold can be found at http://www.juliabedriy.com/rafflegold.html, where you can upload the raw LUA data file, found in the SavedVariables folder, directly into it.

This addon requires the following library:

• LibAddonMenu-2.0