Starlight Celebration Decorations and Music (SQL)

[tagban]

Turns all decorations on for Xmas.

SantaTagban!

Code: Select all

-- Christmas Decoration Awesomeness. 
-- SanD South START STATUS =1 for ON =2 for OFF
UPDATE npc_list SET status = '1' WHERE npcid = '17719790';
UPDATE npc_list SET status = '1' WHERE npcid = '17719791';
UPDATE npc_list SET status = '1' WHERE npcid = '17719792';
UPDATE npc_list SET status = '1' WHERE npcid = '17719793';
UPDATE npc_list SET status = '1' WHERE npcid = '17719794';
UPDATE npc_list SET status = '1' WHERE npcid = '17719796';
UPDATE npc_list SET status = '1' WHERE npcid = '17719800';
UPDATE npc_list SET status = '1' WHERE npcid = '17719802';
UPDATE npc_list SET status = '1' WHERE npcid = '17719803';
UPDATE npc_list SET status = '1' WHERE npcid = '17719804';
UPDATE npc_list SET status = '1' WHERE npcid = '17719805';
UPDATE npc_list SET status = '1' WHERE npcid = '17719806';
UPDATE npc_list SET status = '1' WHERE npcid = '17719807';
UPDATE npc_list SET status = '1' WHERE npcid = '17719808';
UPDATE npc_list SET status = '1' WHERE npcid = '17719809';
UPDATE npc_list SET status = '1' WHERE npcid = '17719810';
UPDATE npc_list SET status = '1' WHERE npcid = '17719811';
UPDATE npc_list SET status = '1' WHERE npcid = '17719812';
UPDATE npc_list SET status = '1' WHERE npcid = '17719813';
UPDATE npc_list SET status = '1' WHERE npcid = '17719814';
UPDATE npc_list SET status = '1' WHERE npcid = '17719815';
UPDATE npc_list SET status = '1' WHERE npcid = '17719816';
UPDATE npc_list SET status = '1' WHERE npcid = '17719817';
UPDATE npc_list SET status = '1' WHERE npcid = '17719818';
UPDATE npc_list SET status = '1' WHERE npcid = '17719819';
UPDATE npc_list SET status = '1' WHERE npcid = '17719820';
UPDATE npc_list SET status = '1' WHERE npcid = '17719821';
UPDATE npc_list SET status = '1' WHERE npcid = '17719822';
-- North San D
UPDATE npc_list SET status = '1' WHERE npcid = '1772377364';
UPDATE npc_list SET status = '1' WHERE npcid = '1772377464';
UPDATE npc_list SET status = '1' WHERE npcid = '1772377664';
UPDATE npc_list SET status = '1' WHERE npcid = '77237810';
UPDATE npc_list SET status = '1' WHERE npcid = '77237820';
UPDATE npc_list SET status = '1' WHERE npcid = '77237830';
UPDATE npc_list SET status = '1' WHERE npcid = '77237840';
UPDATE npc_list SET status = '1' WHERE npcid = '77237850';
UPDATE npc_list SET status = '1' WHERE npcid = '77237860';
UPDATE npc_list SET status = '1' WHERE npcid = '77237870';
UPDATE npc_list SET status = '1' WHERE npcid = '77237880';
UPDATE npc_list SET status = '1' WHERE npcid = '77237890';
UPDATE npc_list SET status = '1' WHERE npcid = '77237900';
UPDATE npc_list SET status = '1' WHERE npcid = '77237910';
UPDATE npc_list SET status = '1' WHERE npcid = '77237920';
UPDATE npc_list SET status = '1' WHERE npcid = '77237930';
UPDATE npc_list SET status = '1' WHERE npcid = '77237940';
UPDATE npc_list SET status = '1' WHERE npcid = '77237950';
UPDATE npc_list SET status = '1' WHERE npcid = '77237960';
UPDATE npc_list SET status = '1' WHERE npcid = '77237970';
UPDATE npc_list SET status = '1' WHERE npcid = '77237980';
-- Bastok Mines
UPDATE npc_list SET status = '1' WHERE npcid = '17735946';
UPDATE npc_list SET status = '1' WHERE npcid = '17735936';
UPDATE npc_list SET status = '1' WHERE npcid = '17735937';
UPDATE npc_list SET status = '1' WHERE npcid = '17735938';
UPDATE npc_list SET status = '1' WHERE npcid = '17735940';
UPDATE npc_list SET status = '1' WHERE npcid = '17735944';
UPDATE npc_list SET status = '1' WHERE npcid = '17735947';
-- BASTOK MARKETS
UPDATE npc_list SET status = '1' WHERE npcid = '17740102';
UPDATE npc_list SET status = '1' WHERE npcid = '17740103';
UPDATE npc_list SET status = '1' WHERE npcid = '17740104';
UPDATE npc_list SET status = '1' WHERE npcid = '17740105';
UPDATE npc_list SET status = '1' WHERE npcid = '17740106';
UPDATE npc_list SET status = '1' WHERE npcid = '17740108';
UPDATE npc_list SET status = '1' WHERE npcid = '17740112';
UPDATE npc_list SET status = '1' WHERE npcid = '17740113';
UPDATE npc_list SET status = '1' WHERE npcid = '17740114';
UPDATE npc_list SET status = '1' WHERE npcid = '17740115';
UPDATE npc_list SET status = '1' WHERE npcid = '17740116';
UPDATE npc_list SET status = '1' WHERE npcid = '17740117';
UPDATE npc_list SET status = '1' WHERE npcid = '17740118';
UPDATE npc_list SET status = '1' WHERE npcid = '17740119';
UPDATE npc_list SET status = '1' WHERE npcid = '17740120';
UPDATE npc_list SET status = '1' WHERE npcid = '17740121';
UPDATE npc_list SET status = '1' WHERE npcid = '17740122';
UPDATE npc_list SET status = '1' WHERE npcid = '17740123';
UPDATE npc_list SET status = '1' WHERE npcid = '17740124';
UPDATE npc_list SET status = '1' WHERE npcid = '17740125';
UPDATE npc_list SET status = '1' WHERE npcid = '17740126';
UPDATE npc_list SET status = '1' WHERE npcid = '17740127';
UPDATE npc_list SET status = '1' WHERE npcid = '17740128';
-- PORT BASTOK
UPDATE npc_list SET status = '1' WHERE npcid = '17744122';
UPDATE npc_list SET status = '1' WHERE npcid = '17744123';
UPDATE npc_list SET status = '1' WHERE npcid = '17744124';
UPDATE npc_list SET status = '1' WHERE npcid = '17744125';
UPDATE npc_list SET status = '1' WHERE npcid = '17744126';
UPDATE npc_list SET status = '1' WHERE npcid = '17744127';
UPDATE npc_list SET status = '1' WHERE npcid = '17744128';
UPDATE npc_list SET status = '1' WHERE npcid = '17744129';
UPDATE npc_list SET status = '1' WHERE npcid = '17744130';
UPDATE npc_list SET status = '1' WHERE npcid = '17744131';
UPDATE npc_list SET status = '1' WHERE npcid = '17744132';
UPDATE npc_list SET status = '1' WHERE npcid = '17744133';
UPDATE npc_list SET status = '1' WHERE npcid = '17744134';
UPDATE npc_list SET status = '1' WHERE npcid = '17744135';
UPDATE npc_list SET status = '1' WHERE npcid = '17744136';
UPDATE npc_list SET status = '1' WHERE npcid = '17744137';
UPDATE npc_list SET status = '1' WHERE npcid = '17744138';
UPDATE npc_list SET status = '1' WHERE npcid = '17744139';
UPDATE npc_list SET status = '1' WHERE npcid = '17744140';
UPDATE npc_list SET status = '1' WHERE npcid = '17744141';
UPDATE npc_list SET status = '1' WHERE npcid = '17744142';
UPDATE npc_list SET status = '1' WHERE npcid = '17744143';
UPDATE npc_list SET status = '1' WHERE npcid = '17744144';
UPDATE npc_list SET status = '1' WHERE npcid = '17744145';
UPDATE npc_list SET status = '1' WHERE npcid = '17744146';
UPDATE npc_list SET status = '1' WHERE npcid = '17744147';
UPDATE npc_list SET status = '1' WHERE npcid = '17744148';
UPDATE npc_list SET status = '1' WHERE npcid = '17744149';
-- Windy Waters
UPDATE npc_list SET status = '1' WHERE npcid = '17752297'; -- GOB START
UPDATE npc_list SET status = '1' WHERE npcid = '17752298';
UPDATE npc_list SET status = '1' WHERE npcid = '17752299';
UPDATE npc_list SET status = '1' WHERE npcid = '17752300';
UPDATE npc_list SET status = '1' WHERE npcid = '17752301';
UPDATE npc_list SET status = '1' WHERE npcid = '17752302';
UPDATE npc_list SET status = '1' WHERE npcid = '17752303';
UPDATE npc_list SET status = '1' WHERE npcid = '17752304';
UPDATE npc_list SET status = '1' WHERE npcid = '17752305';
UPDATE npc_list SET status = '1' WHERE npcid = '17752306';
UPDATE npc_list SET status = '1' WHERE npcid = '17752307'; -- End Gob
UPDATE npc_list SET status = '1' WHERE npcid = '17752478'; 
UPDATE npc_list SET status = '1' WHERE npcid = '17752469';
UPDATE npc_list SET status = '1' WHERE npcid = '17752470';
UPDATE npc_list SET status = '1' WHERE npcid = '17752471';
UPDATE npc_list SET status = '1' WHERE npcid = '17752472';
UPDATE npc_list SET status = '1' WHERE npcid = '17752474';
UPDATE npc_list SET status = '1' WHERE npcid = '17752479';
UPDATE npc_list SET status = '1' WHERE npcid = '17752480';
UPDATE npc_list SET status = '1' WHERE npcid = '17752482';
UPDATE npc_list SET status = '1' WHERE npcid = '17752483';
UPDATE npc_list SET status = '1' WHERE npcid = '17752484';
UPDATE npc_list SET status = '1' WHERE npcid = '17752485';
UPDATE npc_list SET status = '1' WHERE npcid = '17752486';
UPDATE npc_list SET status = '1' WHERE npcid = '17752487';
UPDATE npc_list SET status = '1' WHERE npcid = '17752488';
UPDATE npc_list SET status = '1' WHERE npcid = '17752489';
UPDATE npc_list SET status = '1' WHERE npcid = '17752490';
UPDATE npc_list SET status = '1' WHERE npcid = '17752491';
UPDATE npc_list SET status = '1' WHERE npcid = '17752492';
UPDATE npc_list SET status = '1' WHERE npcid = '17752493';
-- Windy Walls
UPDATE npc_list SET status = '1' WHERE npcid = '17756384';
UPDATE npc_list SET status = '1' WHERE npcid = '17756385';
UPDATE npc_list SET status = '1' WHERE npcid = '17756386';
UPDATE npc_list SET status = '1' WHERE npcid = '17756387';
UPDATE npc_list SET status = '1' WHERE npcid = '17756388';
UPDATE npc_list SET status = '1' WHERE npcid = '17756389';
UPDATE npc_list SET status = '1' WHERE npcid = '17756390';
UPDATE npc_list SET status = '1' WHERE npcid = '17756391';
UPDATE npc_list SET status = '1' WHERE npcid = '17756392';
UPDATE npc_list SET status = '1' WHERE npcid = '17756393';
UPDATE npc_list SET status = '1' WHERE npcid = '17756424';
-- PORT WINDY
UPDATE npc_list SET status = '1' WHERE npcid = '17760482';
UPDATE npc_list SET status = '1' WHERE npcid = '17760483';
UPDATE npc_list SET status = '1' WHERE npcid = '17760484';
UPDATE npc_list SET status = '1' WHERE npcid = '17760485';
UPDATE npc_list SET status = '1' WHERE npcid = '17760486';
UPDATE npc_list SET status = '1' WHERE npcid = '17760487';
UPDATE npc_list SET status = '1' WHERE npcid = '17760488';
UPDATE npc_list SET status = '1' WHERE npcid = '17760489';
UPDATE npc_list SET status = '1' WHERE npcid = '17760490';
UPDATE npc_list SET status = '1' WHERE npcid = '17760491';
UPDATE npc_list SET status = '1' WHERE npcid = '17760492';
UPDATE npc_list SET status = '1' WHERE npcid = '17760493';
UPDATE npc_list SET status = '1' WHERE npcid = '17760494';
UPDATE npc_list SET status = '1' WHERE npcid = '17760495';
UPDATE npc_list SET status = '1' WHERE npcid = '17760496';
-- WINDY WOODS
UPDATE npc_list SET status = '1' WHERE npcid = '17764735';
UPDATE npc_list SET status = '1' WHERE npcid = '17764737';
UPDATE npc_list SET status = '1' WHERE npcid = '17764738';
UPDATE npc_list SET status = '1' WHERE npcid = '17764739';
UPDATE npc_list SET status = '1' WHERE npcid = '17764740';
UPDATE npc_list SET status = '1' WHERE npcid = '17764741';
UPDATE npc_list SET status = '1' WHERE npcid = '17764743';
UPDATE npc_list SET status = '1' WHERE npcid = '17764747';
UPDATE npc_list SET status = '1' WHERE npcid = '17764748';
UPDATE npc_list SET status = '1' WHERE npcid = '17764749';
UPDATE npc_list SET status = '1' WHERE npcid = '17764750';
UPDATE npc_list SET status = '1' WHERE npcid = '17764751';
UPDATE npc_list SET status = '1' WHERE npcid = '17764752';
UPDATE npc_list SET status = '1' WHERE npcid = '17764760';
UPDATE npc_list SET status = '1' WHERE npcid = '17764761';
UPDATE npc_list SET status = '1' WHERE npcid = '17764762';

Jeuno Xmas Music (I prefer it in all Jeuno zones, modify to your own liking

Code: Select all

# Jeuno Xmas Music
UPDATE zone_settings SET music_day = '239' WHERE zoneid >'242' and zoneid < '247';
UPDATE zone_settings SET music_night = '239' WHERE zoneid >'242' and zoneid < '247';

After these are run, you can reboot the server and voila. Decorated! If only my house was decorated this easily.

[tagban]

Store for some of the fun stuff from 2015 version of Starlight.

Code: Select all

---------------------------------------------------------------------------------------------------
-- func: Merry Fu**ing Christmas!
-- auth: Tagban
-- desc: Opens Shop for Xmas 
---------------------------------------------------------------------------------------------------

cmdprops =
{
    permission = 0,
    parameters = ""
};
function onTrigger(player)
	
stock = {
-- Gear'
15179,30, -- Dream Hat +1
10383,30, -- Dream Mittens +1
11968,30, -- Dream Pants +1
11966,30, -- Dream Trousers +1
14520,30, -- Dream Robe +1

-- Other
5543,5, -- N0mz
4218,1, -- AIR RIDER (Santa) Firework
3886,5, -- Bastok Case Kit
3887,5, -- Other Kit Windy
3885,5, -- SanD Kit
21098,50, -- Leafkin Bopper +1
 
-- Prizes?
3621,25, -- WINDY
3620,25, -- Bastok
3619,25, -- San D

	}
 
showShop(player, STATIC, stock);
end

[TeoTwawki]

Just FYI, the music is script-able and can be automated by date in the zone.lua.

I already did this in Jeuno ages ago.

p.s. local yer vars and indent your code dude.

[tagban]

At one point, either you or demon had helped me create a command to change it on the fly but we abandoned it because of I'd shifting.

[TeoTwawki]

We'd have to keep database updated and make sure the IDs are correct before activating but it could still be rigged up in a global to activate every year, like the now busted Halloween event was (nobody kept that maintained). The music at least got its command and automation though.

In the future we need a way to fake names (like via instantiate, fake pet object rigged to be a clickable npc, for example) so we can use NPC's that won't be seasonally removed or shifted in the client dat during a client side update.

SE sometimes leaves an NPC in from a seasonal event from months, and sometimes removes them for the rest of the year as well. Someday when the game shuts down the client will be left with whatever is there at the end and if we want an NPC that is missing we'll be stuck using NPCs name d"NPC" or dat modding, unless we have a way to fake them by then.

[tagban]

What would be ideal would be for individual servers to be able to 'push' client updates. To update NPCID's themselves. But I doubt that will ever happen. We can't even get a popup to come up when the server c rashes to tell the client "REPORT THIS DOWNTIME HERE: FISHFISHFISH.com/DowntimeReport"