Deprecated Darkstar fourms

Go to LandSandBoat
http://forums.dspt.info:80/

Starlight Celebration Decorations and Music (SQL)

http://forums.dspt.info:80/viewtopic.php?f=19&t=2918

Page 1 of 1

Starlight Celebration Decorations and Music (SQL)

Posted: Sun Dec 20, 2015 11:22 am
by tagban
Turns all decorations on for Xmas.
SantaTagban.JPG
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.

Re: Starlight Celebration Decorations and Music (SQL)

Posted: Sun Dec 20, 2015 11:48 am
by 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

Re: Starlight Celebration Decorations and Music (SQL)

Posted: Mon Dec 21, 2015 1:32 am
by 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.

Re: Starlight Celebration Decorations and Music (SQL)

Posted: Mon Dec 21, 2015 10:07 am
by 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.

Re: Starlight Celebration Decorations and Music (SQL)

Posted: Mon Dec 21, 2015 7:56 pm
by 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.

Re: Starlight Celebration Decorations and Music (SQL)

Posted: Tue Dec 22, 2015 9:37 am
by 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"
All times are UTC-05:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/