Lottery - Revision history

Kins at 09:43, 6 April 2026

2026-04-06T09:43:51Z

← Older revision		Revision as of 09:43, 6 April 2026
Line 1:		Line 1:
	~~{{DISPLAYTITLE:Jackpot Lottery}}~~
	[[Category:Custom NPCs]]		[[Category:Custom NPCs]]

2026-04-06T07:37:34Z

Database Tables

← Older revision		Revision as of 07:37, 6 April 2026
Line 37:		Line 37:

	A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.		A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.

	~~== Database Tables ==~~

	~~The system creates two tables automatically on first load:~~

	~~; <code>lottery_tickets</code>~~
	~~: Stores ticket purchases per player per round. Cleared at the end of each round.~~

	~~; <code>lottery_winnings</code>~~
	~~: Holds unclaimed prizes. A row persists until the winner visits the NPC and claims their winnings. On duplicate wins the prize column accumulates.~~

2026-04-06T07:37:28Z

2026-04-06T07:37:22Z

Technical Notes

← Older revision		Revision as of 07:37, 6 April 2026
Line 37:		Line 37:

	A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.		A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.

	~~== Technical Notes ==~~

	* Prize and pool totals are computed in SQL to avoid 32-bit integer overflow on high-volume servers.
	* Prizes are written directly to the winner's character row in the database, so they are received even if the player is offline at the time of the draw.
	* The chatroom display updates after every ticket purchase, every scheduled draw, and every minute tick so that passersby always see the current jackpot.
	* Changing <code>.draw_interval</code> only affects the ''next'' scheduled draw. To reset the timer immediately, delete the global variable <code>$lottery_next_draw</code> via <code>@setglobalvar</code> and then reload the NPC with <code>@reloadnpc</code>.
	* If a winner accumulates multiple prizes before claiming (e.g., wins back-to-back rounds), the unclaimed amounts stack and are paid out together.

	== Database Tables ==		== Database Tables ==

2026-04-06T07:37:11Z

GM Commands

← Older revision		Revision as of 07:37, 6 April 2026
Line 37:		Line 37:

	A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.		A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.

	~~== GM Commands ==~~

	~~{\| class="wikitable"~~
	~~! Command !! Minimum Level !! Description~~
	\|-
	~~\| <code>@lottodraw</code> \|\| 99 \|\| Forces an immediate draw and announces it server-wide~~
	\|}

	== Technical Notes ==		== Technical Notes ==

2026-04-06T07:36:31Z

NPC Locations

← Older revision		Revision as of 07:36, 6 April 2026
Line 37:		Line 37:

	A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.		A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.

	~~== NPC Locations ==~~

	~~{\| class="wikitable"~~
	~~! NPC Name !! Map !! Coordinates !! Sprite~~
	\|-
	~~\| Lottery Master \|\| prontera \|\| 147, 174, South \|\| 717~~
	\|}

	~~Additional locations can be added by duplicating the <code>Lottery Master</code> NPC block:~~
	~~<syntaxhighlight lang="text">~~
	~~prontera,X,Y,D duplicate(Lottery Master) Lottery Master#2 717~~
	~~</syntaxhighlight>~~

	== GM Commands ==		== GM Commands ==

2026-04-06T07:36:18Z

Configuration

← Older revision		Revision as of 07:36, 6 April 2026
Line 37:		Line 37:

	A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.		A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.

	~~== Configuration ==~~

	~~All configurable values are set inside the <code>LotteryController</code> script NPC:~~

	~~{\| class="wikitable"~~
	~~! Variable !! Default !! Description~~
	\|-
	~~\| <code>.ticket_price</code> \|\| 100,000z \|\| Zeny cost per ticket~~
	\|-
	~~\| <code>.max_tickets</code> \|\| 10 \|\| Maximum tickets a single player may hold per round~~
	\|-
	~~\| <code>.prize_ratio</code> \|\| 95 \|\| Percentage of the total pool paid to the winner; the rest is a zeny sink~~
	\|-
	~~\| <code>.draw_interval</code> \|\| 604800 (7 days) \|\| Seconds between automatic draws~~
	\|}

	~~=== Common Draw Intervals ===~~
	~~{\| class="wikitable"~~
	~~! Interval !! Seconds~~
	\|-
	~~\| Daily \|\| 86,400~~
	\|-
	~~\| Weekly \|\| 604,800~~
	\|-
	~~\| Monthly \|\| 2,592,000~~
	\|}

	== NPC Locations ==		== NPC Locations ==

2026-04-06T07:36:02Z

Odds

← Older revision		Revision as of 07:36, 6 April 2026
Line 31:		Line 31:
	Odds are proportional to the number of tickets held relative to the total tickets sold that round.		Odds are proportional to the number of tickets held relative to the total tickets sold that round.

	:~~<math>\text{~~Win probability} = ~~\frac{\text{~~Your tickets~~}}{\text{~~Total tickets sold}~~}</math>~~		{\| style="margin-left:2em; font-size:1.05em;"
			\|-
			\| '''Win probability''' \|\|  =  \|\| Your tickets ÷ Total tickets sold
			\|}

	A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.		A player holding 5 of 50 tickets sold has a 10% chance of winning. Buying more tickets always improves odds, up to the per-player cap.

2026-04-06T07:34:40Z

← Older revision		Revision as of 07:34, 6 April 2026
Line 21:		Line 21:
	# Computes the prize as a percentage of the total pool ('''95%''').		# Computes the prize as a percentage of the total pool ('''95%''').
	# Selects a winning ticket at random - each ticket a player holds represents one entry, so more tickets means proportionally better odds.		# Selects a winning ticket at random - each ticket a player holds represents one entry, so more tickets means proportionally better odds.
	# ~~Deposits the prize into a pending winnings table and makes a~~ server-wide ~~announcement.~~		# The winner will be announced server-wide and can collect their winnings any time at the NPC.
	~~# Advances to~~ the ~~next round~~.

	If no tickets were sold when the draw fires, the round is simply skipped and a new one begins.		If no tickets were sold when the draw fires, the round is simply skipped and a new one begins.

2026-04-06T07:33:57Z

The Draw

← Older revision		Revision as of 07:33, 6 April 2026
Line 20:		Line 20:
	# Totals all tickets sold in the current round.		# Totals all tickets sold in the current round.
	# Computes the prize as a percentage of the total pool ('''95%''').		# Computes the prize as a percentage of the total pool ('''95%''').
	# Selects a winning ticket at random — each ticket a player holds represents one entry, so more tickets means proportionally better odds.		# Selects a winning ticket at random - each ticket a player holds represents one entry, so more tickets means proportionally better odds.
	# Deposits the prize into a pending winnings table and makes a server-wide announcement.		# Deposits the prize into a pending winnings table and makes a server-wide announcement.
	# Advances to the next round.		# Advances to the next round.

← Older revision		Revision as of 07:37, 6 April 2026
Line 47:		Line 47:
	; <code>lottery_winnings</code>		; <code>lottery_winnings</code>
	: Holds unclaimed prizes. A row persists until the winner visits the NPC and claims their winnings. On duplicate wins the prize column accumulates.		: Holds unclaimed prizes. A row persists until the winner visits the NPC and claims their winnings. On duplicate wins the prize column accumulates.

	~~== See Also ==~~
	* [[Economy]]
	* [[Zeny]]
	* [[Prontera]]