Capuche

Post the script

I misread, you want to exclude the castle.. in the previous post it should be if ( preg_match( "prtg_cas0[123]",strcharinfo(3) ) == 0 ) query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ getcharid(2); .@map$ = strcharinfo(3); if ( preg_match( "prtg_cas0[123]",.@map$ ) == 0 && preg_match( "payg_cas0[45]",.@map$ ) == 0 && preg_match( "aldeg_cas0[2]",.@map$ ) == 0 ) query_sql "update guild set woe_points = woe_points +1 where guild_id = "+ getcharid(2); prtg_cas0[123] to exclude prtg_cas01, prtg_cas02, prtg_cas03 payg_cas0[45] to exclude castle 4, 5 etc..

if ( preg_match( "prtg_cas0[123]",strcharinfo(3) ) )

an if miss a bracket if( compare( .map_list$,"|"+strcharinfo(3)+"|" ) )

Like whosell

Infos The owner no longer provide support for this script.

- script junoio -1,{ OnPCBaseLvUpEvent: switch( BaseLevel ) { case 10: callsub L_gift, 50000000;// zeny case 50: callsub L_gift, 50000000; case 100: callsub L_gift, 50000000; case 150: callsub L_gift, 50000000; case 200: callsub L_gift, 50000000; case 250: callsub L_gift, 50000000; case 255: callsub L_gift, 150000000; default: } end; L_gift: dispbottom "Relog and check your mail! you got "+ getarg(0) +" zeny for being level "+ BaseLevel; query_sql( "INSERT INTO `mail` (send_name,dest_id,title,message,nameid,amount,identify,zeny,time) VALUES "+ "( 'no-reply',"+ getcharid(0) +",'Level reward',"+ "'you got "+ getarg(0) +" zeny for being level "+ BaseLevel +"',"+ "0,0,0,"+ getarg(0) +",UNIX_TIMESTAMP(NOW()) )" ); end; }

Add the ai folder in your client http://dfiles.eu/files/luueel9x0

- script WoE_IP_Kick -1,{ OnInit: setmapflag "prtg_cas01", mf_loadevent; setmapflag "prtg_cas02", mf_loadevent; setmapflag "prtg_cas03", mf_loadevent; set .map_list$, "prtg_cas01 | prtg_cas02 | prtg_cas03"; set .whitelist$, "127.0.0.1 | xx.xx.xx.xx"; end; // Trigger when a player enters a map with "loadevent" mapflag. OnPCLoadMapEvent: // Only run for map in the list. if ( compare( .map_list$,strcharinfo(3) ) == 0 ) end; set .@my_ip$, getcharip(); if ( compare( .whitelist$,.@my_ip$ ) ) .@right = 2; else .@right = 1; // Get list of name online with attached character's IP address. set .@size, query_sql("SELECT `char`.`name` FROM `login` join `char` on `char`.account_id = login.account_id WHERE online = 1 and `last_ip` = '"+ .@my_ip$ +"' and `char`.`account_id` != "+ getcharid(3), .@name$ ); // Passed check if only the attached player is returned. if ( .@size < .@right ) end; setd ".@count_"+ strcharinfo(3), 1; // Check all online characters using the IP address if they are on a Battlegrounds map. for( ; .@i<.@size; set .@i,.@i+1) { getmapxy .@map$, .@x, .@y, 0, .@name$[.@i]; if ( compare( .map_list$,.@map$ ) ) { setd ".@count_"+ .@map$, getd( ".@count_"+ .@map$ ) +1; setd ".@name_"+ .@map$ +"$", getd( ".@name_"+ .@map$ +"$" ) + .@name$[.@i] + ( ( getd( ".@name_"+ .@map$ +"$" ) == "" && .@right == 2 ) ? "," : "" ); if ( getd( ".@count_"+ .@map$ ) == .@right +1 ) { message strcharinfo(0),"Characters "+ getd( ".@name_"+ .@map$ +"$" ) +" already present in a map with your IP. Kicking...."; sleep2 2000; atcommand "@kick "+ strcharinfo(0); end; } } } // Passed check. end; }

Use a function function script F_openmyboxplease { .@item_id = 601;// id box if ( Weight * 100 >= 40 * MaxWeight ) { getitem .@item_id, 1; dispbottom "you are overweight"; end; } getinventorylist; if ( @inventorylist_count >= 100 ) { getitem .@item_id, 1; dispbottom "You need to have space on your inventory to open this box"; end; } getitem 501,1;// item gift return; }

- script WoE_IP_Kick -1,{ OnInit: setmapflag "prtg_cas01", mf_loadevent; setmapflag "prtg_cas02", mf_loadevent; setmapflag "prtg_cas03", mf_loadevent; set .map_list$, "prtg_cas01 | prtg_cas02 | prtg_cas03"; set .whitelist$, "xx.xx.xx.xx | xx.xx.xx.xx"; end; // Trigger when a player enters a map with "loadevent" mapflag. OnPCLoadMapEvent: // Only run for map in the list. if ( compare( .map_list$,strcharinfo(3) ) == 0 ) end; set .@my_ip$, getcharip(); if ( compare( .@my_ip$, .whitelist$ ) ) .@right = 2; else .@right = 1; // Get list of name online with attached character's IP address. set .@size, query_sql("SELECT `char`.`name` FROM `login` join `char` on `char`.account_id = login.account_id WHERE online = 1 and `last_ip` = '"+ .@my_ip$ +"' and `char`.`account_id` != "+ getcharid(3), .@name$ ); // Passed check if only the attached player is returned. if ( .@size < .@right ) end; setd ".@count_"+ strcharinfo(3), 1; // Check all online characters using the IP address if they are on a Battlegrounds map. for( ; .@i<.@size; set .@i,.@i+1) { getmapxy .@map$, .@x, .@y, 0, .@name$[.@i]; if ( compare( .map_list$,.@map$ ) ) { if ( getd( ".@count_"+ .@map$ ) == .@right ) { message strcharinfo(0),"Characters "+ getd( ".@name_"+ .@map$ +"$" ) +" are already present in a map with your IP. Kicking...."; sleep2 2000; atcommand "@kick "+ strcharinfo(0); end; } setd ".@count_"+ .@map$, getd( ".@count_"+ .@map$ ); setd ".@name_"+ .@map$ +"$", getd( ".@name_"+ .@map$ +"$" ) + .@name$[.@i] + ( ( getd( ".@name_"+ .@map$ +"$" ) == "" && .@right == 2 ) ? "," : "" ); } } // Passed check. end; }

Possible. Include the query about the mail at the end of your event script

I mean I edited my post http://rathena.org/board/topic/94550-every-50-levels/?p=253274 Retry

And now?

The name is Mapflag#novending, not vending_cell

It seems working for me. I got the mail and the item in the mail. The player of the guild must be online for @guildmail and the player must relog to see the mail

? I don't understand

or like this? - script junoio -1,{ OnPCBaseLvUpEvent: switch( BaseLevel ) { case 10: callsub L_gift, 50000000;// zeny case 50: callsub L_gift, 50000000; case 100: callsub L_gift, 50000000; case 150: callsub L_gift, 50000000; case 200: callsub L_gift, 50000000; case 250: callsub L_gift, 50000000; case 255: callsub L_gift, 150000000; default: } end; L_gift: dispbottom "Relog and check your mail! you got "+ getarg(0) +" zeny for being level "+ BaseLevel; query_sql( "INSERT INTO `mail` (send_name,dest_id,title,message,nameid,amount,identify,zeny,time) VALUES "+ "( 'no-reply',"+ getcharid(0) +",'Level reward',"+ "'you got "+ getarg(0) +" zeny for being level "+ BaseLevel +"',"+ "0,0,0,"+ getarg(0) +",UNIX_TIMESTAMP(NOW())" ); end; }

- script atcmd_mail -1,{ OnInit: bindatcmd "mailall",strnpcinfo(3)+"::OnMailall",99,99; bindatcmd "guildmail",strnpcinfo(3)+"::OnGuildmail",99,99; end; OnMailall: .name$ = strcharinfo(0); if ( getiteminfo( atoi( .@atcmd_parameters$[0] ),0 ) == -1 ) { message .name$, "invalid item id"; end; } if ( atoi( .@atcmd_parameters$[1] ) < 1 ) .@atcmd_parameters$[1] = "1"; query_sql( "INSERT INTO `mail` (send_name,dest_id,title,message,nameid,amount,identify,zeny,time) select "+ "'no-reply',"+ "`char_id`"+ ",'GM reward',"+ "'You got a mail from "+ .name$ +"',"+ .@atcmd_parameters$[0] +","+ .@atcmd_parameters$[1] +",0,0,UNIX_TIMESTAMP(NOW()) from `char` where online = 1 and char_id != "+ getcharid(0) ); addrid 0; if ( strcharinfo(0) != .name$ ) message strcharinfo(0), "You got a mail from "+ .name$; end; OnGuildmail: .name$ = strcharinfo(0); if ( getiteminfo( atoi( .@atcmd_parameters$[0] ),0 ) == -1 ) { message .name$, "invalid item id"; end; } if ( atoi( .@atcmd_parameters$[1] ) < 1 ) .@atcmd_parameters$[1] = "1"; query_sql "select guild_id from guild where name = '"+ escape_sql( .@atcmd_parameters$[2] ) +"'", .@guild_id; if ( .@guild_id == 0 ) { message .name$, "wrong guild name"; end; } query_sql( "INSERT INTO `mail` (send_name,dest_id,title,message,nameid,amount,identify,zeny,time) select "+ "'no-reply',"+ "`char`.`char_id`"+ ",'GM reward',"+ "'You got a mail from "+ .name$ +"',"+ .@atcmd_parameters$[0] +","+ .@atcmd_parameters$[1] +",0,0,UNIX_TIMESTAMP(NOW()) from `char` "+ "where guild_id = "+ .@guild_id +" and online = 1 and char_id != "+ getcharid(0) ); addrid 3,0, .@guild_id; if ( strcharinfo(0) != .name$ ) message strcharinfo(0), "You got a mail from "+ .name$; end; }

//==================== Informacion ========================== //==== Recompensa Diaria========================== //************************************************************************* //=========================== Conf ================================================================================== //******************************************************************************************************************** prontera,150,206,4 script Prize 563,{ set .@rewname$,"^0000FF[ Premio Diario ]^000000"; setarray .items[0],507,506,508,509,510; //items .@tick = gettimetick(2); if(.@tick - lastTimeTalked > (60 * 60 * 24)) { query_sql "select 1 from login join `char` on `char`.account_id = login.account_id join global_reg_value as g on g.char_id = `char`.char_id where last_ip = '"+ getcharip() +"' "+ "and g.`str` = 'lastTimeTalked' and value > ("+ .@tick +" - 86400)", .@tmp; if ( .@tmp == 0 ) { mes .@rewname$; mes "Wanna get your daily reward?"; next; switch(select("-Yush!:-No,thx!:-Cancel")) { case 1: set lastTimeTalked,gettimetick(2); mes .@rewname$; mes "Allright!"; getitem .items[ rand( getarraysize(.items) ) ], rand( 1,25 ); close; case 2: mes .@rewname$; mes "Okay bye!"; close; case 3: close; } } } mes .@rewname$; mes "Sry "+strcharinfo(0)+", you already got this"; mes "Wait 24 hours!!"; close; }

//*/ //CREATE TABLE IF NOT EXISTS `rebirth_system` ( // `account_id` int(11) unsigned NOT NULL default '0', // `name` varchar(255) NOT NULL DEFAULT 'NULL', // `num_rebirth` int(11) unsigned NOT NULL default '0', // `last_ip` varchar(100) NOT NULL default '', // PRIMARY KEY (`account_id`) //) ENGINE=MyISAM; //*/ alberta,185,139,5 script Fairy King 624,{ function checkItem; // check if player have all item required function colorItemrequired; // color the text. Red : not enough item, green otherwise function deleteItem; // delete all items required function displayItemneed; // display all items need at start function getItemReward; // give the items reward function weightreq; // check if your current weight is highter than weight high novice .@eac = eaclass(); if ( num_rebirth == .reset_max ) { mes "You can only rebirth x"+ .reset_max +"."; emotion e_gasp; close; } else if( NextJobExp || NextBaseExp || !( .@eac&EAJL_2 ) || !Upper ) { mes "Your Base & Job Lv must be maximum before you rebirth."; close; } mes "Items need :"; displayItemneed(); next; switch( select( "^777777~ Rebirth", "~ Informations", "~ Good bye^000000" ) ) { case 1: weightreq(); checkItem(); deleteItem(); break; case 2: mes "You can only rebirth ^ff0000x"+ .reset_max +"^000000. You already have ^ff0000x"+ num_rebirth +"^000000 Rebirth."; mes "Each rebirth you get ^ff0000"+ .num_status +"^000000 Stat Points and after ^ff0000"+ .change_reward +"^000000 rebirth, you can receive Random as a reward!"; close; case 3: mes "Bye."; close; } num_rebirth += 1; if ( Upper ) { // just in case the user change the setting... lastJob = roclass( .@eac&EAJ_UPPERMASK ); jobchange Job_Novice_High; } else jobchange Job_Novice; resetlvl 1; if ( num_rebirth < .change_reward ) StatusPoint = StatusPoint + .num_status * num_rebirth; else { StatusPoint = StatusPoint + .num_status * .change_reward; getItemReward(); } query_sql "insert into `rebirth_system` values ( "+ getcharid(3) +", '"+ escape_sql( strcharinfo(0) ) +"', '"+ num_rebirth +"', '"+ getcharip() +"' ) on duplicate key update `num_rebirth` = `num_rebirth` +1"; announce " "+ strcharinfo(0) +" has been Reborn "+ num_rebirth +" Times!", 0; set ClassHelper,0; close; function checkItem { for ( ; .@i < .size_item; .@i += 2 ) if ( countitem( .item_req[.@i] ) < .item_req[ .@i+1 ] + num_rebirth ) { mes "You don't have enought "+ getitemname( .item_req[.@i] ) +". ^ff0000["+ countitem( .item_req[.@i] ) +"/"+ ( .item_req[ .@i+1 ] + num_rebirth ) +"]^000000"; close; } if ( num_rebirth >= .change_reward ) if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) { mes "You don't have enought "+ getitemname( .add_item_req[0] ) +". ^ff0000["+ countitem( .add_item_req[0] ) +"/"+ ( .add_item_req[1] + num_rebirth - .change_reward ) +"]^000000"; close; } return; } function colorItemrequired { if ( countitem( .item_req[ getarg(0) ] ) < .item_req[ getarg(0)+1 ] + num_rebirth ) return "^ff0000"; return "^00ff00"; } function deleteItem { for ( ; .@i < .size_item; .@i += 2 ) delitem .item_req[.@i], ( .item_req[ .@i+1 ] + num_rebirth ); if ( num_rebirth >= .change_reward ) delitem .add_item_req[0], ( .add_item_req[1] + num_rebirth - .change_reward ); return; } function displayItemneed { for ( ; .@i < .size_item; .@i += 2 ) mes colorItemrequired( .@i ) +" - x"+ ( .item_req[ .@i+1 ] + num_rebirth ) +" "+ getitemname( .item_req[.@i] ); if ( num_rebirth >= .change_reward ) { if ( .add_item_req[1] + num_rebirth - .change_reward > countitem( .add_item_req[0] ) ) .@color$ = "^ff0000"; else .@color$ = "^00ff00"; mes .@color$ +"- x"+ ( .add_item_req[1] + ( num_rebirth - .change_reward ) ) +" "+ getitemname( .add_item_req[0] ); } return; } function getItemReward { for ( ; .@i < .size_reward; .@i += 2 ) getitem .reward[.@i], .reward[ .@i+1 ]; return; } function weightreq { if ( Weight > 35000 ) { mes "You have too much items on you. Your weight will be too high after rebirth."; close; } return; } OnInit: .reset_max = 999; // how much reset max .change_reward = 900; // after 30 rebirth, change reward .num_status = 200; // + X number of status points // item required <item ID>, <number> setarray .item_req, 750, 5, 751, 5, 7029, 3; .size_item = getarraysize( .item_req ); // additionnal items after rebirth >> .change_reward // <item ID>, <number> setarray .add_item_req, 7029, 3; end; OnClock0939: OnClock1200: enablenpc strnpcinfo(3); announce "The rebirth npc appear!", 0; end; OnClock0945: OnClock1210: disablenpc strnpcinfo(3); announce "The rebirth npc is gone!", 0; end; }

- script WoE_IP_Kick -1,{ OnInit: setmapflag "prtg_cas01", mf_loadevent; setmapflag "prtg_cas02", mf_loadevent; setmapflag "prtg_cas03", mf_loadevent; set .map_list$, "prtg_cas01 | prtg_cas02 | prtg_cas03"; set .whitelist$, "xx.xx.xx.xx | xx.xx.xx.xx"; end; // Trigger when a player enters a map with "loadevent" mapflag. OnPCLoadMapEvent: // Only run for map in the list. if ( compare( .map_list$,strcharinfo(3) ) == 0 ) end; set .@my_ip$, getcharip(); if ( compare( .@my_ip$, .whitelist$ ) ) end; // Get list of name online with attached character's IP address. set .@size, query_sql("SELECT `char`.`name` FROM `login` join `char` on `char`.account_id = login.account_id WHERE online = 1 and `last_ip` = '"+ .@my_ip$ +"' and `char`.`account_id` != "+ getcharid(3), .@name$ ); // Passed check if only the attached player is returned. if ( .@size < 2 ) end; setd ".@count_"+ strcharinfo(3), 1; // Check all online characters using the IP address if they are on a Battlegrounds map. for( ; .@i<.@size; set .@i,.@i+1) { getmapxy .@map$, .@x, .@y, 0, .@name$[.@i]; if ( compare( .map_list$,.@map$ ) ) { if ( getd( ".@count_"+ .@map$ ) == 2 ) { message strcharinfo(0),"Characters "+ getd( ".@name_"+ .@map$ +"$" ) +" are already present in a map with your IP. Kicking...."; sleep2 2000; atcommand "@kick "+ strcharinfo(0); end; } setd ".@count_"+ .@map$, getd( ".@count_"+ .@map$ ); setd ".@name_"+ .@map$ +"$", getd( ".@name_"+ .@map$ +"$" ) + .@name$[.@i] + ( getd( ".@name_"+ .@map$ +"$" ) == "" ? "," : "" ); } } // Passed check. end; } A map in the list allows 2 characters with the same ip (ip in the list) on the same map The others players (others ip) can play with more than 3 clients btw (a bit weird?)

- script WoE_IP_Kick -1,{ OnInit: setmapflag "prtg_cas01", mf_loadevent; setmapflag "prtg_cas02", mf_loadevent; setmapflag "prtg_cas03", mf_loadevent; set .map_list$, "prtg_cas01 | prtg_cas02 | prtg_cas03"; set .whitelist$, "xx.xx.xx.xx | xx.xx.xx.xx"; end; // Trigger when a player enters a map with "loadevent" mapflag. OnPCLoadMapEvent: // Only run for map "prtg_cas01". if ( compare( .map_list$,strcharinfo(3) ) == 0 ) end; set .@my_ip$, getcharip(); if ( compare( .@my_ip$, .whitelist$ ) ) end; // Get list of accounts with attached character's IP address. set .@size, query_sql("SELECT `char`.`name` FROM `login` join `char` on `char`.account_id = login.account_id WHERE online = 1 and `last_ip` = '"+ .@my_ip$ +"' and `char`.`account_id` != "+ getcharid(3), .@name$ ); // Passed check if only the attached player is returned. if ( .@size < 2 ) end; .@count++; // Check all online characters using the IP address if they are on a Battlegrounds map. for( ; .@i<.@size; set .@i,.@i+1) { getmapxy .@map$, .@x, .@y, 0, .@name$[.@i]; if ( compare( .map_list$,.@map$ ) ) { .@count++; .@name_on_map$ = .@name_on_map$ + .@name$[.@i] + ( .@name_on_map$ == "" ? "," : "" ); if ( .@count > 2 ) { message strcharinfo(0),"Characters "+ .@name_on_map$ +" is already present in a map with your IP. Kicking...."; sleep2 2000; atcommand "@kick "+ strcharinfo(0); end; } } } // Passed check. end; } I assume you want to kick the third player regardless the maps of the others (prontera, geffen in the map list ; 1st player in prontera, 2nd geffen, 3rd geffen kicked)

- script WoE_IP_Kick -1,{ OnInit: setmapflag "prtg_cas01", mf_loadevent; setmapflag "prtg_cas02", mf_loadevent; setmapflag "prtg_cas03", mf_loadevent; set .map_list$, "prtg_cas01 | prtg_cas02 | prtg_cas03"; set .whitelist$, "xx.xx.xx.xx | xx.xx.xx.xx"; end; // Trigger when a player enters a map with "loadevent" mapflag. OnPCLoadMapEvent: // Only run for map "prtg_cas01". if ( compare( .map_list$,strcharinfo(3) ) == 0 ) end; set .@my_ip$, getcharip(); if ( compare( .@my_ip$, .whitelist$ ) ) end; // Get list of accounts with attached character's IP address. set .@size, query_sql("SELECT `char`.`name` FROM `login` join `char` on `char`.account_id = login.account_id WHERE online = 1 and `last_ip` = '"+ .@my_ip$ +"' and `char`.`account_id` != "+ getcharid(3), .@name$ ); // Passed check if only the attached player is returned. if ( .@size == 0 ) end; // Check all online characters using the IP address if they are on a Battlegrounds map. for( ; .@i<.@size; set .@i,.@i+1) { getmapxy .@map$, .@x, .@y, 0, .@name$[.@i]; if ( compare( .map_list$,.@map$ ) ) { message strcharinfo(0),"Character "+.@name$[.@i]+" is already present in a map with your IP. Kicking...."; sleep2 2000; atcommand "@kick "+ strcharinfo(0); end; } } // Passed check. end; }

/* CREATE TABLE IF NOT EXISTS `guildpack` ( `id` int(11) NOT NULL auto_increment, `account_id` int(11) NOT NULL default '0', `name` varchar(23) NOT NULL default '', `last_ip` varchar(100) NOT NULL default '', PRIMARY KEY (`account_id`), KEY (`id`) ) ENGINE=MyISAM; */ //====================================================================================================== prontera,130,172,5 script Guild Pack Info 468,{ if ( getcharid(2) == 0 ) { mes "You have no guild!"; close; } if ( #gpack || callsub( L_check ) ) { #gpack = 1; mes "^616D7EYou already given a Guild Package"; close; } mes "[Guild Pack NPC]"; mes "Hello there, it seems you are claiming for a Guild Pack."; next; mes "[Guild Pack NPC]"; mes "Let me gift you a guild pack for joining and"; mes "playing in Lunar RO, we hope you enjoy them."; next; mes "These guild pack is not duplicable and not dropable."; next; switch(select("Yes:No")) { case 1: .@myip$ = getcharip(); if ( callsub( L_check ) ) { mes "^616D7EIt seems you have same IP Address among Guild Mates: ^ff0000" + .@myip$ + "^000000. Sorry, but its not allowed."; close; } setarray .@item_id[0], 29828,29851,29868,29834,29804,29835,2607,4035,4064,4079, 14175,671,607,12045,12060,12050,12055,12065,12070; setarray .@amount[0], 1,1,1,1,1,1,2,5,2,2, 1,1,300,100,100,100,100,100,100; .@size = getarraysize( .@item_id ); // add items getitem2 setarray .@item_id[.@size], 5170,2319,2114,2528,2424; setarray .@amount[.@size], 1,1,1,1,1; if ( checkweight2( .@item_id,.@amount ) == 0 ) { mes "you can't carry all the items"; close; } query_sql("INSERT INTO `guildpack` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@myip$ + "')"); //THIS PART WERE all items they will get for ( ; .@i < .@size; .@i++ ) getitem .@item_id[.@i], .@amount[.@i]; getitem2 5170,1,1,7,0,0,0,0,0; getitem2 2319,1,1,7,0,4141,0,0,0; getitem2 2114,1,1,7,0,4058,0,0,0; getitem2 2528,1,1,7,0,4133,0,0,0; getitem2 2424,1,1,7,0,4097,0,0,0; set #gpack, 1; warp "prontera",156,172; close; case 2: mes "^616D7ENevermind~, You can come back again later!"; close; } end; L_check: return query_sql("SELECT 1 FROM `guildpack` join login on login.`last_ip` = `guildpack`.`last_ip` where login.account_id = "+ getcharid(3), .@tmp ); OnInit: waitingroom "Guild Package",0; end; }