v-Sro Happy Event Fixed %100 Work

[Xanaxius]

Hello RaGEZONE..

We share the happy running smoothly events.

Added evetword.txt (Media)

1    ITEM_ETC_E110125_HAPPY_H    H
2    ITEM_ETC_E110125_HAPPY_A    A
3    ITEM_ETC_E110125_HAPPY_P    P
4    ITEM_ETC_E110125_HAPPY_P_2    P
5    ITEM_ETC_E110125_HAPPY_Y    Y

edited textevent.txt (Media)

1    SN_QEV_EVENT_HAPPY    0    0    0    0    0    0    0    Happy Event    Happy Event    0    0    0    0    0
1    SN_TALK_QEV_CH_EVENT_HAPPY_A    0    0    0    0    0    0    0    Hello. I am So-Ok~ I wish you a happy new year and have brought an event of luck as I welcome the year 2011~ If you catch monsters and get event letters(5), I will give you a gift. Well! Then, get going and bring them to me~ Please remember unused event letters(5) will be deleted when the event is over!    Hello. I am So-Ok~ I wish you a happy new year and have brought an event of luck as I welcome the year 2011~ If you catch monsters and get event letters(5), I will give you a gift. Well! Then, get going and bring them to me~ Please remember unused event letters(5) will be deleted when the event is over!    0    0    0    0    0
1    SN_TALK_QEV_CH_EVENT_HAPPY_B    0    0    0    0    0    0    0    Receive a gift with event letters(5).    Receive a gift with event letters(5).    0    0    0    0    0
1    SN_TALK_QEV_CH_EVENT_HAPPY_C    0    0    0    0    0    0    0    Oh, These are event letters(5). Thank you for getting them. Then, since you have gotten me the event letters(5), I will give you a gift. Check your inventory.    Oh, These are event letters(5). Thank you for getting them. Then, since you have gotten me the event letters(5), I will give you a gift. Check your inventory.    0    0    0    0    0
1    SN_TALK_QEV_CH_EVENT_HAPPY_D    0    0    0    0    0    0    0    I was about to get event letters(5) and give you a gift. But I cannot because your inventory is full. Empty your inventory and visit me again.    I was about to get event letters(5) and give you a gift. But I cannot because your inventory is full. Empty your inventory and visit me again.    0    0    0    0    0
1    SN_TALK_QEV_CH_EVENT_HAPPY_E    0    0    0    0    0    0    0    I can give you a gift only when you have event letters(5). If you catch a monster, the event letters(5) drop. If you keep those event letters in your inventory and visit me, I am exchanging them into gifts.    I can give you a gift only when you have event letters(5). If you catch a monster, the event letters(5) drop. If you keep those event letters in your inventory and visit me, I am exchanging them into gifts.    0    0    0    0    0

Download Link = v-Sro_Happy_Event_Work.rar
Jotti= http://virusscan.jotti.org/tr/scanre...87d04924ebc29e


Note: Server Files,Script,VIETNAM change to Event and EvetList.

ScreenShot







Thanks.

[MentaL]

[MarcoTozzi]

Nice, but this will replace all other events if you have done custom already.

[lemoniscool]

in case you want to add this event to your own custom events here are the lines to add:
These lines were not made by me, i decompiled the files Xanaxius shared in this thread and took them from it
[@Eventlist.lua]

LuaInsertEvent(TYPE_ID, "event.sct", "QEV_EVENT_HAPPY")

[@SN_QEV_110221.lua]

function QEV_EVENT_HAPPY()
  EventID = 10168
  SetEventOne(EventID, "SN_QEV_EVENT_HAPPY", 1, 1, 5)
  SetEventTwo(2, "SN_TALK_QEV_CH_EVENT_HAPPY_B", "SN_TALK_COMMON_EXIT")
  NPC_COUNT = 1
  LuaInsertNpc(NPC_COUNT, "NPC_CH_EVENT_KISAENG1")
  InsertPayItemCodeName(20, "ITEM_EVENT_AVATAR_M_FAIRY", "ITEM_EVENT_AVATAR_W_FAIRY", "ITEM_EVENT_AVATAR_M_FAIRY_HAT", "ITEM_EVENT_AVATAR_W_FAIRY_HAT", "ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_SHIELD_B", "ITEM_ETC_ALL_POTION_05", "ITEM_ETC_ALL_SPOTION_01", "ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B", "ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_WEAPON_B", "ITEM_ETC_E080723_SKILL_EXP_5", "ITEM_ETC_E080723_SKILL_EXP_10", "ITEM_ETC_E080723_SKILL_EXP_15", "ITEM_ETC_E080723_SKILL_EXP_20", "ITEM_EVENT_HP_INC_1900_POTION", "ITEM_EVENT_HP_INC_4100_POTION", "ITEM_ETC_ARCHEMY_MAGICSTONE_STR_10", "ITEM_ETC_ARCHEMY_MAGICSTONE_INT_10", "ITEM_ETC_E090930_HIT_SUPER_SCROLL", "ITEM_ETC_E090930_EVATION_SUPER_SCROLL", "ITEM_ETC_E060526_SUMMON_PARTY_SCROLL_A")
  InsertPayItemRatio(20, 10, 10, 15, 7, 5, 15, 15, 7, 3, 2, 1, 0.6, 0.5, 1.8, 1, 1, 1, 1, 1, 3)
  LuaInsertDropItem(5, "ITEM_ETC_E110125_HAPPY_H", 15, "ITEM_ETC_E110125_HAPPY_A", 15, "ITEM_ETC_E110125_HAPPY_P", 15, "ITEM_ETC_E110125_HAPPY_P_2", 15, "ITEM_ETC_E110125_HAPPY_Y", 15)
  InsertMenuStringList("NPC_CH_EVENT_KISAENG1", 5, "EVENT_MENUSTRING_GREETING", "SN_NPC_CH_EVENT_KISAENG1_QS", "EVENT_MENUSTRING_REQUEST_ACCEPT_QUEST", "SN_TALK_QEV_CH_EVENT_HAPPY_A", "EVENT_MENUSTRING_NOT_ACHIEVED", "SN_TALK_QEV_CH_EVENT_HAPPY_E", "EVENT_MENUSTRING_INVENTORY_FULL", "SN_TALK_QEV_CH_EVENT_HAPPY_D", "EVENT_MENUSTRING_ACHIEVED", "SN_TALK_QEV_CH_EVENT_HAPPY_C")
  CONVERSATION_SINGLE = 0
  LuaInsertFunctionStringList(1, "CONVERSATION_SINGLE", "KISAENG_100315_Conversation")
end

btw works like a charm, thanks!

[RevoLand]

add virustotal & jotti.

[lemoniscool]

after i got these files i finally played around with the events and got similar things like HAPPY event working, will release it if someone wants them but what im thinking about now is someting ive seen on another pserver thats the Fanous Event .. it was like once a day everyone can get 1 Fanous Scroll without collecting anything

i know how to make an event without items needed to collect in order to complete the event, but i dont know how to make it available only once a day for every character .. any ideas on this?

//Edit
just tried to execute sql queries from the lua event scripts but .. its not working and im not even recieving any error messages .. everything goes through fine only the sql query isnt executed .. thats what i wrote:

function testsql()
	-- load the ODBC dll
	assert (package.loadlib ("odbc.dll", "luaopen_luasqlodbc")) ()

	-- create environment object
	env = assert (luasql.odbc())

	-- connect to data source
	con = assert (env:connect ("SRO_VT_SHARD",     -- DSN name
							   "XXXX",        -- user name
							   "XXXXXXXX"))  -- password
	assert (con:execute"UPDATE _Char SET HwanLevel = 10 WHERE CharName16 like 'lulz'")
end

this function is then called instead of the GiveEventRewardItem function inside the conversation function
the idea was to make something like a table for this where the last date the user finished the event is saved to create a check function if he finished the event already on that day

i put the ODBC dll into the server files folder as i thought thats where the scripts are being loaded in some server executable but its either not loaded or not supported by the lua engine the server executable uses ....

[nandyyto]

good work man (:

[nemo20122]

nice and 100% work but i need know how change reward and how change reward normal event flag and thank you

when i change any code item here happy event disappered in event so oke

 SN_TALK_QEV_CH_EVENT_HAPPY_B  SN_TALK_COMMON_EXIT 
NPC_COUNT 
LuaInsertNpc  NPC_CH_EVENT_KISAENG1  InsertPayItemCodeName  4@ ITEM_EVENT_AVATAR_M_FAIRY  ITEM_EVENT_AVATAR_W_FAIRY  ITEM_EVENT_AVATAR_M_FAIRY_HAT  ITEM_EVENT_AVATAR_W_FAIRY_HAT - ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_SHIELD_B  ITEM_ETC_ALL_POTION_05  ITEM_ETC_ALL_SPOTION_01 0 ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B - ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_WEAPON_B  ITEM_ETC_E080723_SKILL_EXP_5  ITEM_ETC_E080723_SKILL_EXP_10  ITEM_ETC_E080723_SKILL_EXP_15  ITEM_ETC_E080723_SKILL_EXP_20  ITEM_EVENT_HP_INC_1900_POTION  ITEM_EVENT_HP_INC_4100_POTION # ITEM_ETC_ARCHEMY_MAGICSTONE_STR_10 # ITEM_ETC_ARCHEMY_MAGICSTONE_INT_10 " ITEM_ETC_E090930_HIT_SUPER_SCROLL & ITEM_ETC_E090930_EVATION_SUPER_SCROLL ' ITEM_ETC_E060526_SUMMON_PARTY_SCROLL_A  InsertPayItemRatio  $@ .@ @ @333333م? à?حجججججü? LuaInsertDropItem 

like if i change ITEM_EVENT_AVATAR_M_FAIRY to any code avatar and restart server and when open happy event disappered

plzzz help fast thank you

[ahmedzaki]

Me too when i change reward Happy event disappear
any help

[lemoniscool]

nice and 100% work but i need know how change reward and how change reward normal event flag and thank you

when i change any code item here happy event disappered in event so oke


like if i change ITEM_EVENT_AVATAR_M_FAIRY to any code avatar and restart server and when open happy event disappered

plzzz help fast thank you

i dont know what you did with the code but its totally wrong .. youre missing ( and ) and " and , and numbers were changed to strange symbols and aside of that youre missing
EventID = 10168
SetEventOne(EventID, "SN_QEV_EVENT_HAPPY", 1, 1, 5)
SetEventTwo(2, "SN_TALK_QEV_CH_EVENT_HAPPY_B", "SN_TALK_COMMON_EXIT")
and many other things .. no wonder it doesnt work :D

remember you have to decompile the event.sct and edit the lua script, then recompile it as event.sct

[nemo20122]

i add happy event without any problem but idont like reward ineed know how to change reward item plzz helpp and thank you

[ahmedzaki]

Guys how i make drop H A P P Y from Mobs ? any Help Pleas

[thebigbody]

done added it and work 100% Ty alot
but when i changed the reward it disappeared like this

And here is my new codes after edit

 SN_TALK_QEV_CH_EVENT_HAPPY_B  SN_TALK_COMMON_EXIT 
NPC_COUNT 
LuaInsertNpc  NPC_CH_EVENT_KISAENG1  InsertPayItemCodeName  4@ ITEM_MALL_AVATAR_M_EVENT_WINTER_2011  ITEM_MALL_AVATAR_W_EVENT_WINTER_2011  ITEM_MALL_AVATAR_M_EVENT_WINTER_HAT_2011  ITEM_MALL_AVATAR_W_EVENT_WINTER_HAT_2011 - ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_SHIELD_B  ITEM_ETC_ALL_POTION_05  ITEM_ETC_ALL_SPOTION_01 0 ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B - ITEM_EVENT_ARCHEMY_REINFORCE_RECIPE_WEAPON_B  ITEM_ETC_E080723_SKILL_EXP_5  ITEM_ETC_E080723_SKILL_EXP_10  ITEM_ETC_E080723_SKILL_EXP_15  ITEM_ETC_E080723_SKILL_EXP_20  ITEM_EVENT_HP_INC_1900_POTION  ITEM_EVENT_HP_INC_4100_POTION # ITEM_ETC_ARCHEMY_MAGICSTONE_STR_10 # ITEM_ETC_ARCHEMY_MAGICSTONE_INT_10 " ITEM_ETC_E090930_HIT_SUPER_SCROLL & ITEM_ETC_E090930_EVATION_SUPER_SCROLL ' ITEM_ETC_E060526_SUMMON_PARTY_SCROLL_A  InsertPayItemRatio  $@ .@ @ @333333م? à?حجججججü? LuaInsertDropItem 

[nemo20122]

plzzzzzz any one help us to change reward

[BlackSelection]

i added it but i dont see the text at the event so-ok.
and how to drop H A P P Y ?
:D