Botaring

Yes I did and I've done it twice to make sure. But still the Script doesnt seem to read what is in the SQL on my Private Server only. But on the Test Server it works perfectly.

Then the players will just recreate an account again and again. The IP Based is for that sort of exploit.

So I have this NPC and it's working properly on my Test Server. But when I tried using it on my online server it didn't work as much as I expected. It still gives freebies when they already got it. But it records all of the transactions that's happening to him in the SQL. It is a modified version of this. SCRIPT CORE: poring_w02,89,81,6 script Freebies NPC 100,{ mes "[ ^FF0000Administrator Helper^000000 ]"; mes "Welcome to Ragnarok Online."; next; switch(select("~ How to claim Beginner Rewards:~ I have the items:~ Cancel")){ Case 1: mes "[ ^FF0000Administrator Helper^000000 ]"; mes "To claim your Beginner Rewards."; mes "Gather the following items:"; mes "^FF000015 ^000000"+getitemname(4001); mes "^FF000015 ^000000"+getitemname(4037); mes "^FF000015 ^000000"+getitemname(4074); mes "^FF000010 ^000000"+getitemname(4275); mes "^FF000010 ^000000"+getitemname(4268); mes "^FF000010 ^000000"+getitemname(4194); mes "^FF0000150 ^000000"+getitemname(4129); mes "^FF00003 ^000000"+getitemname(4147); mes "^FF00001 ^000000"+getitemname(4305); close; Case 2: query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@lastip$); query_sql("SELECT last_ip FROM `freebies`", .@freebiesip$); if (.@lastip$ == .@freebiesip$) { mes "[ ^FF0000Administrator Helper^000000 ]"; mes "Sorry, but you've already received your ^43572FBeginner Rewards^000000."; close; } else { mes "[ ^FF0000Administrator Helper^000000 ]"; mes "Let me see if you have gathered all the following items."; mes "^FF000015 ^000000"+getitemname(4001); mes "^FF000015 ^000000"+getitemname(4037); mes "^FF000015 ^000000"+getitemname(4074); mes "^FF000010 ^000000"+getitemname(4275); mes "^FF000010 ^000000"+getitemname(4268); mes "^FF000010 ^000000"+getitemname(4194); mes "^FF0000150 ^000000"+getitemname(4129); mes "^FF00003 ^000000"+getitemname(4147); mes "^FF00001 ^000000"+getitemname(4305); next; if(countitem(4001) < 15) goto L_NoItem; if(countitem(4037) < 15) goto L_NoItem; if(countitem(4074) < 15) goto L_NoItem; if(countitem(4275) < 10) goto L_NoItem; if(countitem(4268) < 10) goto L_NoItem; if(countitem(4194) < 10) goto L_NoItem; if(countitem(4129) < 150) goto L_NoItem; if(countitem(4147) < 3) goto L_NoItem; if(countitem(4305) < 1) goto L_NoItem; mes "[ ^FF0000Administrator Helper^000000 ]"; mes "It seems you've gathered all the items!"; mes "Here's your ^43572FBeginner Rewards^000000."; delitem 4001,15; delitem 4037,15; delitem 4074,15; delitem 4275,10; delitem 4268,10; delitem 4194,10; delitem 4129,150; delitem 4147,3; delitem 4305,1; query_sql("INSERT INTO `freebies` VALUES (NULL," + getcharid(3) + ",'" + escape_sql(strcharinfo(0)) + "','" + .@lastip$ + "')"); for ( set .@x,0; .@x < getarraysize(.freebie_item); set .@x,.@x + 1 ) { getitem .freebie_item[.@x], .quantity[.@x]; } } close; L_NoItem: mes "You don't have:"; if(countitem(4001) < 15) mes "^FF0000"+(15 - countitem(4001)) +"^000000 "+getitemname(4001); if(countitem(4037) < 15) mes "^FF0000"+(15 - countitem(4037)) +"^000000 "+getitemname(4037); if(countitem(4074) < 15) mes "^FF0000"+(15 - countitem(4074)) +"^000000 "+getitemname(4074); if(countitem(4275) < 10) mes "^FF0000"+(10 - countitem(4275)) +"^000000 "+getitemname(4275); if(countitem(4268) < 10) mes "^FF0000"+(10 - countitem(4268)) +"^000000 "+getitemname(4268); if(countitem(4194) < 10) mes "^FF0000"+(10 - countitem(4194)) +"^000000 "+getitemname(4194); if(countitem(4129) < 150) mes "^FF0000"+(150 - countitem(4129)) +"^000000 "+getitemname(4129); if(countitem(4147) < 3) mes "^FF0000"+(3 - countitem(4147)) +"^000000 "+getitemname(4147); if(countitem(4305) < 1) mes "^FF0000"+(1 - countitem(4305)) +"^000000 "+getitemname(4305); close; Case 3: close; } OnInit: setarray .freebie_item[0],2357,2524,2421,2115,40138,7776; setarray .quantity[0],2,2,2,3,3,10; } SQL CODE: CREATE TABLE IF NOT EXISTS `freebies` ( `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;

Please I need a script that deletes all items(storage, inventory, vending, vending storage, cart, and etc that has something to do with their characters), characters, and account of player that who didnt log in for the last 8days or 10days.

SOLVED

SOLVED

I tried using it today but it still enables all the WoECoreSystem. Here is the whole script. I tried doing the best that I can so it would work at properly at the given time. I think the problem is not from the Scheduler. I got five OnClock events that's getting enabled even the host script WoECoresystem<CastleTownName> is disabled. @Emistry is there any way to retract the OnClock script? So they wont be enabled everyday at the same time. If you have time please check the script that I made so you would understand. Thank you. WoE_Controller.txt

I made this script so WoE could be activated at certain date of the month. But my problem is whenever the script is reloaded all of the enablenpc in "OnDay<Month><Day>:" are getting enabled. How can I stop it from enabling all the NPC and make it work at the time given on the Schedule? - script WoEScheduler -1,{ OnDay0701: enablenpc "WoECoreSystemProntera"; end; OnDay0702: enablenpc "WoECoreSystemPayon"; end; OnDay0704: enablenpc "WoECoreSystemGeffen"; end; OnDay0707: enablenpc "WoECoreSystemAldebran"; end; OnDay0710: enablenpc "WoECoreSystemArunafeltz"; end; OnDay0713: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay0716: enablenpc "WoECoreSystemProntera"; end; OnDay0719: enablenpc "WoECoreSystemPayon"; end; OnDay0722: enablenpc "WoECoreSystemGeffen"; end; OnDay0725: enablenpc "WoECoreSystemAldebran"; end; OnDay0728: enablenpc "WoECoreSystemArunafeltz"; end; OnDay0729: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay0801: enablenpc "WoECoreSystemProntera"; end; OnDay0802: enablenpc "WoECoreSystemPayon"; end; OnDay0804: enablenpc "WoECoreSystemGeffen"; end; OnDay0807: enablenpc "WoECoreSystemAldebran"; end; OnDay0810: enablenpc "WoECoreSystemArunafeltz"; end; OnDay0813: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay0816: enablenpc "WoECoreSystemProntera"; end; OnDay0819: enablenpc "WoECoreSystemPayon"; end; OnDay0822: enablenpc "WoECoreSystemGeffen"; end; OnDay0825: enablenpc "WoECoreSystemAldebran"; end; OnDay0828: enablenpc "WoECoreSystemArunafeltz"; end; OnDay0829: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay0901: enablenpc "WoECoreSystemProntera"; end; OnDay0902: enablenpc "WoECoreSystemPayon"; end; OnDay0904: enablenpc "WoECoreSystemGeffen"; end; OnDay0907: enablenpc "WoECoreSystemAldebran"; end; OnDay0910: enablenpc "WoECoreSystemArunafeltz"; end; OnDay0913: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay0916: enablenpc "WoECoreSystemProntera"; end; OnDay0919: enablenpc "WoECoreSystemPayon"; end; OnDay0922: enablenpc "WoECoreSystemGeffen"; end; OnDay0925: enablenpc "WoECoreSystemAldebran"; end; OnDay0928: enablenpc "WoECoreSystemArunafeltz"; end; OnDay0929: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay1001: enablenpc "WoECoreSystemProntera"; end; OnDay1002: enablenpc "WoECoreSystemPayon"; end; OnDay1004: enablenpc "WoECoreSystemGeffen"; end; OnDay1007: enablenpc "WoECoreSystemAldebran"; end; OnDay1010: enablenpc "WoECoreSystemArunafeltz"; end; OnDay1013: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay1016: enablenpc "WoECoreSystemProntera"; end; OnDay1019: enablenpc "WoECoreSystemPayon"; end; OnDay1022: enablenpc "WoECoreSystemGeffen"; end; OnDay1025: enablenpc "WoECoreSystemAldebran"; end; OnDay1028: enablenpc "WoECoreSystemArunafeltz"; end; OnDay1029: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay1101: enablenpc "WoECoreSystemProntera"; end; OnDay1102: enablenpc "WoECoreSystemPayon"; end; OnDay1104: enablenpc "WoECoreSystemGeffen"; end; OnDay1107: enablenpc "WoECoreSystemAldebran"; end; OnDay1110: enablenpc "WoECoreSystemArunafeltz"; end; OnDay1113: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay1116: enablenpc "WoECoreSystemProntera"; end; OnDay1119: enablenpc "WoECoreSystemPayon"; end; OnDay1122: enablenpc "WoECoreSystemGeffen"; end; OnDay1125: enablenpc "WoECoreSystemAldebran"; end; OnDay1128: enablenpc "WoECoreSystemArunafeltz"; end; OnDay1129: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay1201: enablenpc "WoECoreSystemProntera"; end; OnDay1202: enablenpc "WoECoreSystemPayon"; end; OnDay1204: enablenpc "WoECoreSystemGeffen"; end; OnDay1207: enablenpc "WoECoreSystemAldebran"; end; OnDay1210: enablenpc "WoECoreSystemArunafeltz"; end; OnDay1213: enablenpc "WoECoreSystemSchwaltzvalt"; end; OnDay1216: enablenpc "WoECoreSystemProntera"; end; OnDay1219: enablenpc "WoECoreSystemPayon"; end; OnDay1222: enablenpc "WoECoreSystemGeffen"; end; OnDay1225: enablenpc "WoECoreSystemAldebran"; end; OnDay1228: enablenpc "WoECoreSystemArunafeltz"; end; OnDay1229: enablenpc "WoECoreSystemSchwaltzvalt"; end; }

SOLVED

Yes, I did use that Mr. Emistry but my problem is fitting 30 Castles on a tight schedule. I made my own schedule and it works just fine. Im just an amateur scripter. But the problem is I can't kick player from the inactive WoE Grounds and warping the players to the right battlegrounds. I'm trying to make WoE Rewarder Script work. -------------- SOLVED!

Hello, Im in need of help. Im making my custom woe schedule but the current WoE Scheduler isn't easy to handle on its schedules. • Inactive WoE Grounds Kicker - players will be kicked from inactive Castles when they enter the grounds. • WoE Rewarder - once the WoE has ended, the Castle Owner the guild master only will receive items without clicking any NPC. • Active WoE Grounds Warper - like Toasty's once the castle is active there is a warp option on WoE Information.

Im having a problem with ghost pvp ladder. I dont know how to fix it. It doesnt record the kills and many others need help