Yasunari Ishibashi Posted January 9, 2012 Group: Members Topic Count: 49 Topics Per Day: 0.01 Content Count: 157 Reputation: 2 Joined: 01/06/12 Last Seen: August 25, 2014 Share Posted January 9, 2012 (edited) So the script function is to give the gift of each end of WoE to the owner of a certain castle & gifts directly given to all players in a guild that won the WoE, so I want to give gifts Item ID: 7539 & Cashpoint +10 every time WoE ends. only an online player who get the prize. if anyone can make a simple script? thanks. Edited January 9, 2012 by Yasunari Ishibashi Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 3, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 3, 2012 Hi Emistry Goddameit's updated script: http://pastebin.com/raw.php?i=Mdm6iFaR i think must put in agit controller right? Quote Link to comment Share on other sites More sharing options...
Emistry Posted July 3, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: 21 hours ago Share Posted July 3, 2012 no need Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 3, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 3, 2012 Noted. I will try. Thanks Quote Link to comment Share on other sites More sharing options...
PapaZola Posted July 3, 2012 Group: Members Topic Count: 318 Topics Per Day: 0.07 Content Count: 925 Reputation: 32 Joined: 12/05/11 Last Seen: September 20, 2023 Share Posted July 3, 2012 is this sql? Quote Link to comment Share on other sites More sharing options...
Euphy Posted July 3, 2012 Group: Members Topic Count: 72 Topics Per Day: 0.02 Content Count: 2997 Reputation: 1130 Joined: 05/27/12 Last Seen: June 1, 2017 Share Posted July 3, 2012 Yes it's SQL. (You shouldn't be using TXT anyway...) Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 4, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 4, 2012 Hi Euphy If i Copy and paste in notepad and load to custom npc this script should be run or not? Thanks Quote Link to comment Share on other sites More sharing options...
Euphy Posted July 4, 2012 Group: Members Topic Count: 72 Topics Per Day: 0.02 Content Count: 2997 Reputation: 1130 Joined: 05/27/12 Last Seen: June 1, 2017 Share Posted July 4, 2012 Hi Euphy If i Copy and paste in notepad and load to custom npc this script should be run or not? Thanks Yes, it will run automatically after WOE ends no matter where you put the script. Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 4, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 4, 2012 Noted Sir. Thanks for your kindly assist . Quote Link to comment Share on other sites More sharing options...
PapaZola Posted July 4, 2012 Group: Members Topic Count: 318 Topics Per Day: 0.07 Content Count: 925 Reputation: 32 Joined: 12/05/11 Last Seen: September 20, 2023 Share Posted July 4, 2012 its works GM Incarnation? Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 5, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 5, 2012 (edited) PapaZola u can try in your server. I think its work. Edited July 5, 2012 by GM Incarnation Quote Link to comment Share on other sites More sharing options...
VyL0w Posted July 5, 2012 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 27 Reputation: 0 Joined: 05/12/12 Last Seen: December 30, 2014 Share Posted July 5, 2012 thanks for this!! nice script Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted July 5, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted July 5, 2012 (edited) There is a bug that N characters in the same account the same guuild will receive N times WoE Reward Edited July 5, 2012 by QQfoolsorellina Quote Link to comment Share on other sites More sharing options...
Ragnar Lothbrok Posted July 5, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted July 5, 2012 got error.. [Error]: run_script: infinity loop ! [Debug]: Source (NPC): AGME (invisible/not on a map) Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 5, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 5, 2012 Sir Euphy and Emistry This script can add random reward? Pls advise. Goddameit's updated script: http://pastebin.com/raw.php?i=Mdm6iFaR and this error will show after woe finish. Quote Link to comment Share on other sites More sharing options...
Ragnar Lothbrok Posted July 5, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted July 5, 2012 Yeah Same Problem... Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted July 5, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted July 5, 2012 (edited) try my woe reward script Woeautoreward.txt Edited July 5, 2012 by QQfoolsorellina Quote Link to comment Share on other sites More sharing options...
Ragnar Lothbrok Posted July 5, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted July 5, 2012 @QQfoolsorellina i try ur script and i got this error [Error]: Loading NPC file: npc/infi/woereward.txt script error on npc/infi/woereward.txt line 18 parse_callfunc: expected ')' to close argument list 13 : 14 : if (isloggedin(.@gmaid[.@i],.@gmcid[.@i]) && att achrid(.@gmaid[.@i])) 15 : { 16 : if(checkvending()) 17 : continue; * 18 : if(.maxw > 1 && query_sql("SELECT char_i d FROM `char` LEFT JOIN login ON `char`.account_id=login.account_id WHERE login. last_ip=(SELECT last_ip FROM login WHERE account_id="+.@gmaid[.@i]+") AND `char` .party_id ="+gecharid'('1), .@dcid) > .maxw) 19 : continue; 20 : 21 : query_sql "insert into mail ( send_name, dest_id, title, message, nameid, amount, identify, time ) values ( 'Angelmeolod y╝·└y¿t▓╬',"+.@gmcid[.@i]+", '½░╛╘╝·└y', '«Ñ│▀! ▒z¬║ñu╖|ª√╗Γ "+ getcastlename($@ castlemap$[.@j]) +" │o¼O¿t▓╬╡╣ºA¬║╝·└yº╞▒µºAªAÑ[¬o',"+.prize+", 1, 1, unix_times tamp( now() ) )"; 22 : 23 : } Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted July 5, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted July 5, 2012 (edited) @QQfoolsorellina i try ur script and i got this error [Error]: Loading NPC file: npc/infi/woereward.txt script error on npc/infi/woereward.txt line 18 parse_callfunc: expected ')' to close argument list 13 : 14 : if (isloggedin(.@gmaid[.@i],.@gmcid[.@i]) && att achrid(.@gmaid[.@i])) 15 : { 16 : if(checkvending()) 17 : continue; * 18 : if(.maxw > 1 && query_sql("SELECT char_i d FROM `char` LEFT JOIN login ON `char`.account_id=login.account_id WHERE login. last_ip=(SELECT last_ip FROM login WHERE account_id="+.@gmaid[.@i]+") AND `char` .party_id ="+gecharid'('1), .@dcid) > .maxw) 19 : continue; 20 : 21 : query_sql "insert into mail ( send_name, dest_id, title, message, nameid, amount, identify, time ) values ( 'Angelmeolod y╝·└y¿t▓╬',"+.@gmcid[.@i]+", '½░╛╘╝·└y', '«Ñ│▀! ▒z¬║ñu╖|ª√╗Γ "+ getcastlename($@ castlemap$[.@j]) +" │o¼O¿t▓╬╡╣ºA¬║╝·└yº╞▒µºAªAÑ[¬o',"+.prize+", 1, 1, unix_times tamp( now() ) )"; 22 : 23 : } sorry, it's a typo gecharid'('1) --->getcharid'('1) update Edited July 5, 2012 by QQfoolsorellina Quote Link to comment Share on other sites More sharing options...
Ragnar Lothbrok Posted July 5, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted July 5, 2012 (edited) Great it works!! Thank you so much QQfoolsorellina!! Q: can this be change, item will recieve in inventory not in email?? coz i disable mail in my server bec. of coins bug... Edited July 5, 2012 by arnie2302 Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 5, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 5, 2012 This script can change and update with random reward like berry box or fish box Quote Link to comment Share on other sites More sharing options...
Ragnar Lothbrok Posted July 5, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted July 5, 2012 Are you asking to change the reward or your telling about the cript reward? Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 5, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 5, 2012 Sorry actually i want ask this script can put random reward after woe finish Quote Link to comment Share on other sites More sharing options...
QQfoolsorellina Posted July 5, 2012 Group: Members Topic Count: 40 Topics Per Day: 0.01 Content Count: 587 Reputation: 104 Joined: 11/19/11 Last Seen: July 7, 2019 Share Posted July 5, 2012 (edited) can this be change, item will recieve in inventory not in email?? replace this line query_sql "insert into mail................. with getitem .prize,1; Sorry actually i want ask this script can put random reward after woe finish yes you can create a box and in item script to write what you want to do Edited July 5, 2012 by QQfoolsorellina Quote Link to comment Share on other sites More sharing options...
GM Incarnation Posted July 5, 2012 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 75 Reputation: 0 Joined: 03/19/12 Last Seen: October 25, 2012 Share Posted July 5, 2012 can this be change, item will recieve in inventory not in email?? replace this line query_sql "insert into mail................. with getitem .prize,1; Sorry actually i want ask this script can put random reward after woe finish yes you can create a box and in item script to write what you want to do Hi QQfoolsorellina how to make this reward random prize after woe finish. Can add more then 2 or 3 prize random after woe finish? Thanks. Quote Link to comment Share on other sites More sharing options...
Ragnar Lothbrok Posted July 5, 2012 Group: Members Topic Count: 91 Topics Per Day: 0.02 Content Count: 309 Reputation: 6 Joined: 04/24/12 Last Seen: January 7, 2016 Share Posted July 5, 2012 (edited) @QQfoolsorellina i try this i got error: replace this line query_sql "insert into mail................. with getitem .prize,1; how to fix this?? btw im using eathena.. [Debug]: at ..\src\map\script.c:14691 - getitem .prize,1; ( send_name, dest_id, title, message, nameid, amount, identify, time ) values ( 'Angelmeolody╝·└y¿t▓╬' ,150004, '½░╛╘╝·└y', '«Ñ│▀! ▒z¬║ñu╖|ª√╗Γ Sacred Altar │o¼O¿t▓╬╡╣ºA¬║╝·└yº╞▒µºAªA Ñ[¬o',501, 1, 1, unix_timestamp( now() ) ) [Debug]: Source (NPC): Woeautoreward (invisible/not on a map) : DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'getitem.prize,1; ( send_name, dest_id, title, message, nameid, amount, identify' at line 1 Edited July 5, 2012 by arnie2302 Quote Link to comment Share on other sites More sharing options...
Question
Yasunari Ishibashi
So the script function is to give the gift of each end of WoE to the owner of a certain castle & gifts directly given to all players in a guild that won the WoE, so I want to give gifts Item ID: 7539 & Cashpoint +10 every time WoE ends.
only an online player who get the prize.
if anyone can make a simple script?
thanks.
Edited by Yasunari IshibashiLink to comment
Share on other sites
Top Posters For This Question
14
11
10
8
Popular Days
Jul 5
28
Jan 14
9
Jul 3
9
Jul 4
4
Top Posters For This Question
GM Incarnation 14 posts
Ragnar Lothbrok 11 posts
Yasunari Ishibashi 10 posts
QQfoolsorellina 8 posts
Popular Days
Jul 5 2012
28 posts
Jan 14 2012
9 posts
Jul 3 2012
9 posts
Jul 4 2012
4 posts
Posted Images
64 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.