minx123

thank you.

sorry i not understand where is.. script means script provide selling item?

how to wipe previous data? after i follow your step.

hello.. i need some help to make newbie npc can give reward to newbie base on ip. newbie can choose vk box / diabolus box. or auto reward when login and can choose. { Id: 30233 AegisName: "Valkyries_Box" Name: "Valkyries Box" Type: 18 Buy: 20 Weight: 10 Trade: { nodrop: true noselltonpc: true nogstorage: true } Script: <" getitem 2357,1; getitem 2524,1; getitem 2421,1; getitem 2115,1; getitem 4305,4; getitem 4302,1; getitem 4142,2; getitem 4047,1; getitem 4128,1; getitem 4174,1; getitem 4131,1; getitem 969,1000; ">},{ Id: 30234 AegisName: "Diabolus_Box" Name: "Diabolus Box" Type: 18 Buy: 20 Weight: 10 Trade: { nodrop: true noselltonpc: true nogstorage: true } Script: <" getitem 2375,1; getitem 2433,1; getitem 2537,1; getitem 2374,1; getitem 2729,2; getitem 4305,4; getitem 4302,1; getitem 4142,2; getitem 4047,1; getitem 4128,1; getitem 4174,1; getitem 4131,1; getitem 969,1000; ">},

thank you.. how about item missing?

hello.. i need somehelp.. why my emulator got error like this?

/*alter table `char` add column mvp_rank int(11) default 0 after hotkey_rowshift, add index (mvp_rank);create table mvp_rank_archive (`date` datetime,pos tinyint(4) unsigned,cid int(11) unsigned default 0,name varchar(23) default '',points int(11) unsigned not null,primary key ( `date`, pos )) engine innodb;*/prontera,158,176,3 script MVP Ladder 1_F_MARIA,{ mes "[MVP Ladder]"; mes "Hello!"; mes "What are you doing here?"; next; switch(select("Check rankings.:My stats.:Previous Month ranking")) { case 1: mes "[MVP Ladder]"; mes "Rankings :->"; .@nb = query_sql( "select name, mvp_rank from `char` where mvp_rank > 0 order by mvp_rank desc limit 5", .@name$, .@count ); if ( !.@nb ) { mes "no entry"; close; } for ( .@i = 0; .@i < .@nb; .@i++ ) mes ( .@i +1 )+". "+ .@name$[.@i] +" -> "+ .@count[.@i] +" points"; close; case 2: query_sql "select mvp_rank from `char` where char_id = "+ getcharid(0), .@killed; mes "[MVP Ladder]"; mes "You have killed "+ .@killed +" MVPs"; close; case 3: mes "[MVP Ladder]"; mes "Last month ranking"; if ( gettime(MONTH) > 10 ) .@store_date$ = gettime(YEAR) +"-"+( gettime(MONTH) -1 )+"-00 00:00:00"; else if ( gettime(MONTH) > 1 ) .@store_date$ = gettime(YEAR) +"-0"+( gettime(MONTH) -1 )+"-00 00:00:00"; else .@store_date$ = ( gettime(YEAR) -1 ) +"-12-00 00:00:00"; .@nb = query_sql( "select name, points from mvp_rank_archive where `date` = '"+ .@store_date$ +"' order by pos", .@name$, .@count ); if ( !.@nb ) { mes "no entry"; close; } for ( .@i = 0; .@i < .@nb; .@i++ ) mes ( .@i +1 )+". "+ .@name$[.@i] +" -> "+ .@count[.@i] +" points"; close; } close;OnInit: if ( $mvp_ladder_last_given == atoi( gettime(YEAR) +""+ gettime(MONTH) ) ) end; goto L_give;OnClock0000: if ( gettime(DAYOFMONTH) != 1 ) end;L_give: .@nb = query_sql( "select char_id, name, mvp_rank from `char` where mvp_rank > 0 order by mvp_rank desc limit 5", .@cid, .@name$, .@killed ); if ( !.@nb ) end; setarray .@reward, 30316, 7227, 7227, 7227, 7227; // <1st place>, <2nd place>, <3rd place> ... setarray .@amount, 1, 50, 25, 10, 5; for ( .@i = 0; .@i < .@nb; .@i++ ) query_sql "insert into mail ( send_name, dest_id, title, message, nameid, amount, identify, zeny, time ) values ( '"+ escape_sql( .@name$[.@i] ) +"', "+ .@cid[.@i] +", '[MVP RANK]', 'Congratulations for earning No. "+( .@i +1 )+" position in killing Custom MVPs. Here is your reward.', "+ .@reward[.@i] +", "+ .@amount[.@i] +", 1, 0, unix_timestamp( now() ) )"; query_sql "update `char` set mvp_rank = 0"; // reset the ladder $mvp_ladder_last_given = atoi( gettime(YEAR) +""+ gettime(MONTH) ); end;OnNPCKillEvent: if ( killedrid == f_valkyrie) // 2545 query_sql "update `char` set mvp_rank = mvp_rank +1 where char_id = "+ getcharid(0); end;}

How to do that?? I on vps server..

How to remove the old one i already inject in sql?

I need some help.. How to check whats problem with my emulator?? Map server always get offline.. Urgently help to fix this problem..

kro grf is data.grf right? thank you so much.. its work..

i have some problem when create custom card. 1-when put in weapon the icon change to X 2-how to disable cuttin? when i press view it will error. what i miss? 3-data/num2cardillustnametable.txt i dont have in my grf. idnum2itemdesctable.txt30321#^4682B4Custom Card^000000Increase +30% physical damage on non-mvp and player enemy.Class: ^777777Card^000000Compound On: ^777777Weapon^000000Weight: ^7777771^000000#idnum2itemdisplaynametable.txt30321#Seville_Windsor_Card#idnum2itemresnametable.txt30321#À̸§¾ø´ÂÄ«µå#cardprefixnametable.txt30321#Strengh#

yes my mvp is f_valkyrie id 2545 i already run in sql.. nothing error detect.

/*alter table `char` add column mvp_rank int(11) default 0 after delete_date, add index (mvp_rank);create table mvp_rank_archive (`date` datetime,pos tinyint(4) unsigned,cid int(11) unsigned default 0,name varchar(23) default '',points int(11) unsigned not null,primary key ( `date`, pos )) engine innodb;*/mid_campin,376,127,3 script MVP Ladder 100,{ mes "[MVP Ladder]"; mes "Hello!"; mes "What are you doing here?"; next; switch(select("Check rankings.:My stats.:Previous Month ranking")) { case 1: mes "[MVP Ladder]"; mes "Rankings :->"; .@nb = query_sql( "select name, mvp_rank from `char` where mvp_rank > 0 order by mvp_rank desc limit 10", .@name$, .@count ); if ( !.@nb ) { mes "no entry"; close; } for ( .@i = 0; .@i < .@nb; .@i++ ) mes ( .@i +1 )+". "+ .@name$[.@i] +" -> "+ .@count[.@i] +" points"; close; case 2: query_sql "select mvp_rank from `char` where char_id = "+ getcharid(0), .@killed; mes "[MVP Ladder]"; mes "You have killed "+ .@killed +" MVPs"; close; case 3: mes "[MVP Ladder]"; mes "Last month ranking"; if ( gettime(6) > 10 ) .@store_date$ = gettime(7) +"-"+( gettime(6) -1 )+"-00 00:00:00"; else if ( gettime(6) > 1 ) .@store_date$ = gettime(7) +"-0"+( gettime(6) -1 )+"-00 00:00:00"; else .@store_date$ = ( gettime(7) -1 ) +"-12-00 00:00:00"; .@nb = query_sql( "select name, points from mvp_rank_archive where `date` = '"+ .@store_date$ +"' order by pos", .@name$, .@count ); if ( !.@nb ) { mes "no entry"; close; } for ( .@i = 0; .@i < .@nb; .@i++ ) mes ( .@i +1 )+". "+ .@name$[.@i] +" -> "+ .@count[.@i] +" points"; close; } close;OnInit: if ( $mvp_ladder_last_given == atoi( gettime(7) +""+ gettime(6) ) ) end; goto L_give;OnClock0000: if ( gettime(5) != 1 ) end;L_give: .@nb = query_sql( "select char_id, name, custom_mvp_rank from `char` where custom_mvp_rank > 0 order by custom_mvp_rank desc limit 5", .@cid, .@name$, .@killed ); if ( !.@nb ) end; setarray .@reward, 30316, 7227, 7227, 7227, 7227; // <1st place>, <2nd place>, <3rd place> ... setarray .@amount, 1, 50, 25, 10, 5; for ( .@i = 0; .@i < .@nb; .@i++ ) query_sql "insert into mail ( send_name, dest_id, title, message, nameid, amount, identify, zeny, time ) values ( '"+ escape_sql( .@name$[.@i] ) +"', "+ .@cid[.@i] +", '[MVP RANK]', 'Congratulations for earning No. "+( .@i +1 )+" position in killing Custom MVPs. Here is your reward.', "+ .@reward[.@i] +", "+ .@amount[.@i] +", 1, 0, unix_timestamp( now() ) )"; query_sql "update `char` set custom_mvp_rank = 0"; // reset the ladder $mvp_ladder_last_given = atoi( gettime(7) +""+ gettime(6) ); end;OnNPCKillEvent: if ( killedrid == f_valkyrie ) // 1765 query_sql "update `char` set custom_mvp_rank = custom_mvp_rank +1 where char_id = "+ getcharid(0); end;} it is like this? @@AnnieRuru when i load. npc don't have button close. i stuck when choosing.

thx

hello.. i looking for create mvp custom card. but i cant find any guide how to make it from server side to client side. can someone gv me guide to create custom mvp card?

top 5 player mvp Valkyrie every sunday 12am will reset count. time to claim reward in 1 day.

i need some help to get this script.. every Sunday player who are the top kill custom mvp will get reward. only custom mvp not normal mvp auto reset every sunday.

thx @@Dastgir ;)

bump

oh really? hm.. i hope someone can help me to upload here.. i will bump this post.. thx.

https://eathena.ws/board/Npcs-Naruto-Sasuke-Kakashi-Sakura-E-Muitos-Outros-t174198.html i need someone help me to upload the file in here.. i cant register in eathena. hope someone could help me.. thank you guys.

thank you..

can gv me example full script?

help me to create this script. i need disable all event running when woe/koe start it.