Jump to content

blakbord

Members
  • Posts

    99
  • Joined

  • Last visited

1 Follower

Profile Information

  • Gender
    Not Telling
  • Location
    philippines
  • Server
    OwnServer
  • Github: blakbord
  • Interests
    there's a lot to mention.. lol

Recent Profile Visitors

2,318 profile views

blakbord's Achievements

Newbie

Newbie (1/14)

1

Reputation

3

Community Answers

  1. I think there no one who will help me.. :(
  2. Good Day Everyone, I'm just gonna ask how to delete .exe files or other kind of files inside my RO Folder using Thor Patcher, I've been searching for weeks now but I still don't find the right answer.. I have found the same question Here but it's not the right answer,,
  3. why not use the default refine.txt then change the success rate of refining at /db/(pre)re/refine.txt?
  4. try this one.. //======= 3ceam Script ======================================= //= Prize Giver NPC //===== Modified By: ========================================= //= Keitenai //===== Current Version: ===================================== //= 1.0 //===== Compatible With: ===================================== //= Athena Project //===== Description: ========================================= //= Prize giver for single char, account and more. //===== Additional Comments: ================================= //= 1.0 Modified Version for 3ceam compatibility //============================================================ prontera,147,173,4 script Server Reward 544,{ //cutin "v_sprakki04",2; //Check if setups are loaded. if(!.Setup) { callsub OnLoadSetup; } //Show GM Panel if player is GM. if(getgmlevel() >= .GMin) menu("Take a prize as a player",-,"Give prize", OnManagement,"Reset Item Give", OnDelete,"IP Limit per Item", OnLimit); //Read attached player gifts from SQL table. if(select("Get Account Prize!:Get Character Prize!:Exit") == 1) { set [email protected], query_sql("SELECT * FROM `" + .GiftTableName$ + "` WHERE account_id="+getcharid(3), [email protected]_id, [email protected]_account, [email protected]_char, [email protected]_item, [email protected]_amount, [email protected]_duration, [email protected]_time ); //Account gifts. } else if(@menu == 2) { set [email protected], query_sql("SELECT * FROM `" + .GiftTableName$ + "` WHERE char_id="+getcharid(0), [email protected]_id, [email protected]_account, [email protected]_char, [email protected]_item, [email protected]_amount, [email protected]_duration, [email protected]_time ); //Char gifts. } else goto OnLeave; //Check if player don't have gifts. if([email protected]) { mes "[Reward Giver]"; mes "Sorry, you don't have any prize"; cutin "v_sprakki04",255; close; } //Build menu from query arrays. mes "[" + strnpcinfo(1) + "]"; mes "^009900You got the prize^000000"; for( set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1 ) { mes "(" + [email protected]_amount[[email protected]] + ") " + getitemname([email protected]_item[[email protected]]) + "."; set [email protected]$, [email protected]$ + getitemname([email protected]_item[[email protected]]) + ":"; } next; set [email protected],select([email protected]$); //Show menu. set [email protected],[email protected]; if ([email protected]_time[[email protected]] && [email protected]_time[[email protected]] < gettimetick(2)) { mes "[Reward Giver]"; mes "Sorry, this prize's claim time is already over."; cutin "v_sprakki04",255; close; } //Item is now selected. Choose what you want to do with it. mes "[" + strnpcinfo(1) + "]"; mes "what you want do with (" + [email protected]_amount[[email protected]] + ") " + getitemname([email protected]_item[[email protected]]) + "?"; next; set [email protected],select("^009900Get it^000000:^ff0000Delete it! ^000000:nothings"); //Receive gift selected. if([email protected] == 1) { //Check weight. if(checkweight( [email protected]_item, [email protected]_amount ) || [email protected]_item[[email protected]] == .ZenyID) { mes "[" + strnpcinfo(1) + "]"; mes "^009900Get : (" + [email protected]_amount[[email protected]] + ") " + getitemname([email protected]_item[[email protected]]) + ".^000000"; if (.ip_limit) { // add ip_address to logs [email protected] = query_sql("SELECT item_id, ip_address, claim_count FROM " + .GiftTableNameIP$ + " WHERE last_ip = (SELECT last_ip FROM login WHERE account_id="+getcharid(3)+") AND item_id = "[email protected]_item[[email protected]]+" LIMIT 1", [email protected],[email protected],[email protected]_count); if ([email protected]_count[0] >= .ip_limit) { next; mes "Sorry you have reached the maximum redeem limit for this IP address"; cutin "v_sprakki04",255; close; } if ([email protected]_count[0]) { query_sql("INSERT INTO " + .GiftTableNameIP$ + " (give_id,item_id,last_ip,claim_count) VALUES("[email protected]_id+","[email protected]_item+",'(SELECT last_ip FROM login WHERE account_id="+getcharid(3)+")',1)"); } else { query_sql("UPDATE " + .GiftTableNameIP$ + " SET claim_count = "+([email protected]_count[0]+1)+" WHERE item_id = "[email protected]_item[[email protected]]+" AND last_ip = (SELECT last_ip FROM login WHERE account_id="+getcharid(3)+")"); } } if ([email protected]_item[[email protected]] == .ZenyID) { // detects zeny ID and give zeny. if ([email protected]_amount[[email protected]] > .MaxZeny) { mes "Please make sure that you have enough space to handle all these zennies and come back later."; cutin "v_sprakki04",255; close; } set Zeny,[email protected]_amount[[email protected]]; } else { if ([email protected]_duration) { getitem [email protected]_item[[email protected]], [email protected]_amount[[email protected]]; //Give item to player. } else { rentitem [email protected]_item[[email protected]], [email protected]_duration * 60; } } query_sql( "DELETE FROM `" + .GiftTableName$ + "` WHERE id = " + [email protected]_id[[email protected]] ); //Remove item from table. cutin "v_sprakki04",255; close; } else { //Overweight mes "^ff0000Sorry ^000000 You can't take it " + getitemname([email protected]_item[[email protected]]); mes "Could lose some wight?"; cutin "v_sprakki04",255; close; } } //Remove gift selected. else if([email protected] == 2) { mes "[" + strnpcinfo(1) + "]"; mes "Are you sure you want dellet it?"; mes "Gift: ("[email protected]_amount[[email protected]]+") "+getitemname([email protected]_item[[email protected]])+"."; next; if(select("Yes:No") == 1) { mes "[" + strnpcinfo(1) + "]"; mes "^ff0000Dellet: ("[email protected]_amount[[email protected]]+") "+getitemname([email protected]_item[[email protected]])+".^000000"; query_sql("DELETE FROM `" + .GiftTableName$ + "` WHERE id = " + [email protected]_id[[email protected]]); //Remove item from table. cutin "v_sprakki04",255; close; } else { mes "[" + strnpcinfo(1) + "]"; mes "we will save it"; cutin "v_sprakki04",255; close; } } //Nothing selected. else { goto OnLeave; } //GM Panel below: OnManagement: if(getgmlevel() < .GMin) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Welvome " + strcharinfo(0) + "!"; mes "How I can help you?"; next; if(select("Make Gift:Nothing") != 1) goto OnLeave; //Make new gift. mes "[" + strnpcinfo(1) + "]"; mes "Please input the item id."; mes "Default: 501"; next; mes "What do you want to give?"; set [email protected],0; if(select("Item:Zeny") == 1) { input [email protected]_item, 501, 30000; } next; mes "Do you want to add a claim timer?"; if(select("No:Yes")==2) { next; mes "How many minutes do you want this reward to be claimable?"; input([email protected]); [email protected] = gettimetick(2)+([email protected]*60); } if(select("Continue:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "How many items/zeny?"; mes "Default: 1"; next; //item quantity range of 1 to 1,000. if([email protected]) { input [email protected]_value, 1, .MaxZeny; } else { input [email protected]_value, 1, 1000; } if(select("Continue:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Please select input type:"; mes "1. Single Account"; mes "2. Single Character"; mes "3. All ^009900Online^000000 Accounts."; mes "4. All Accounts."; mes "5. All ^009900Online^000000 Players/Characters."; mes "6. All Players/Characters."; mes "7. ^ff0000Cancel.^000000"; next; switch(select("Single Account:Single Character:^009900Online^000000 Accounts:All Accounts:^009900Online^000000 Characters:All Characters:Cancel")) { //Account gift case 1: mes "[" + strnpcinfo(1) + "]"; mes "Please select input type:"; mes "By AID or Name?"; next; if(select("Account ID:Character Name") == 1) { mes "[" + strnpcinfo(1) + "]"; mes "Write account id:"; next; input [email protected]_account, 2000000, 10000000; //Account id range from 2m to 10m. set [email protected], query_sql("SELECT account_id FROM `" + .CharTableName$ + "` WHERE account_id = " + [email protected]_account, [email protected]_account); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "AID: ^ff0000" + [email protected]_account + "^000000"; mes "------------------"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Duration: " + [email protected] + " Minutes"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; //Create gift. <auto_id>, <account_id> <char_id> <item> <value> query_sql("INSERT INTO `" + .GiftTableName$ + "` (account_id, item, value, duration, timestamp) VALUES(" + [email protected]_account + ", " + [email protected]_item + ", " + [email protected]_value + ", " + [email protected] + ", " + [email protected] + ")"); } else { mes "[" + strnpcinfo(1) + "]"; mes "Write player name:"; next; input [email protected]_name$; set [email protected], query_sql("SELECT account_id FROM `" + .CharTableName$ + "` WHERE name = '" + [email protected]_name$ + "'", [email protected]_account); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "AID: ^ff0000" + [email protected]_account + "^000000"; mes "Name: ^ff0000"+ [email protected]_name$ + "^000000"; mes "------------------"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Duration: " + [email protected] + " Minutes"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; //Check if player is logged in. if(isloggedin([email protected]_account)) { mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; query_sql("INSERT INTO `" + .GiftTableName$ + "` (account_id, item, value, duration, timestamp) VALUES(" + [email protected]_account + ", " + [email protected]_item + ", " + [email protected]_value + ", " + [email protected] + ", " + [email protected] + ")"); } else { //Account was not online. mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; query_sql("INSERT INTO `" + .GiftTableName$ + "` (account_id, item, value, duration, timestamp) VALUES(" + [email protected]_account + ", " + [email protected]_item + ", " + [email protected]_value + ", " + [email protected] + ", " + [email protected] + ")"); // duplicate to other menus - continue here on giver side } } announce "[GM] "+strcharinfo(0)+" successfully sent " + [email protected]_value + "x as a Gift " + getitemname([email protected]_item) + " to " + [email protected]_name$,bc_all; break; //Character gift. case 2: mes "[" + strnpcinfo(1) + "]"; mes "Please select input type:"; mes "By CID or Name?"; next; if(select("Character ID:Character Name") == 1) { mes "[" + strnpcinfo(1) + "]"; mes "Write character id:"; next; input [email protected]_char,150000, 10000000; //Char id range from 150k to 10m. set [email protected], query_sql("SELECT account_id, name FROM `" + .CharTableName$ + "` WHERE char_id = " + [email protected]_char, [email protected]_accountid, [email protected]_name$); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "CID: ^ff0000" + [email protected]_char + "^000000"; mes "Name: ^ff0000" + [email protected]_name$ + "^000000"; mes "------------------"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Duration: " + [email protected] + " Minutes"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; //Check if player is logged in. if(isloggedin([email protected]_accountid)) { mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; //Create gift. <auto_id>, <account_id> <char_id> <item> <value> query_sql("INSERT INTO `" + .GiftTableName$ + "` (char_id, item, value, duration, timestamp) VALUES (" + [email protected]_char + ", " + [email protected]_item + ", " + [email protected]_value + "," + [email protected] + "," + [email protected] + ")"); } else { //not online ask if we still give the gift. mes "[" + strnpcinfo(1) + "]"; mes "The character is not online!"; mes "Would you still like to send the gift?"; next; if(select("Yes:No") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; //Create gift. <auto_id>, <account_id> <char_id> <item> <value> query_sql("INSERT INTO `" + .GiftTableName$ + "` (char_id, item, value, duration, timestamp) VALUES (" + [email protected]_char + ", " + [email protected]_item + ", " + [email protected]_value + "," + [email protected] + "," + [email protected] + ")"); } } else { mes "[" + strnpcinfo(1) + "]"; mes "Write player name:"; next; input [email protected]_name$; set [email protected], query_sql("SELECT char_id, account_id FROM `" + .CharTableName$ + "` WHERE name = '" + [email protected]_name$ + "'", [email protected]_char, [email protected]_accountid); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "CID: ^ff0000" + [email protected]_char + "^000000"; mes "Name: ^ff0000"+ [email protected]_name$ + "^000000"; mes "------------------"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Duration: " + [email protected] + " Minutes"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; //Check if player is logged in. if(isloggedin([email protected]_accountid)) { mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; query_sql("INSERT INTO `" + .GiftTableName$ + "` (char_id, item, value, duration, timestamp) VALUES (" + [email protected]_char + ", " + [email protected]_item + ", " + [email protected]_value + "," + [email protected] + "," + [email protected] + ")"); } else { //not online ask if we still give the gift. mes "[" + strnpcinfo(1) + "]"; mes "The character is not online!"; mes "Would you still like to give the gift?"; next; if(select("Yes:No") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Gift sending success!"; //Create gift. <auto_id>, <account_id> <char_id> <item> <value> query_sql("INSERT INTO `" + .GiftTableName$ + "` (char_id, item, value, duration, timestamp) VALUES (" + [email protected]_char + ", " + [email protected]_item + ", " + [email protected]_value + "," + [email protected] + "," + [email protected] + ")"); } } announce "[GM] "+strcharinfo(0)+" successfully sent " + [email protected]_value + "x as a Gift " + getitemname([email protected]_item) + " to " + [email protected]_name$,bc_all; break; //Register gift to all online accounts! case 3: mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Duration: " + [email protected] + " Minutes"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Please hold..."; set [email protected], 0; //Counting success. set [email protected], query_sql("SELECT account_id FROM `"+.CharTableName$+"` WHERE online=1",[email protected]); for(set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1) { sleep2 25; //Slowdown the loop abit. [email protected] = query_sql("SELECT account_id, char_id FROM "+$GiftTableNameAT$+" WHERE account_id = "[email protected][[email protected]]+"", [email protected]_id, [email protected]_id); // check if in the table if ([email protected]) { query_sql("INSERT INTO `" + .GiftTableName$ + "` (account_id, item, value, duration, timestamp) VALUES(" + [email protected][[email protected]] + ", " + [email protected]_item + ", " + [email protected]_value + ", " + [email protected] + ", " + [email protected] + ")"); } } mes "Gift registered to (" + [email protected] + ") accounts!"; announce "[GM] "+strcharinfo(0)+" successfully sent " + [email protected]_value + "x as a Gift " + getitemname([email protected]_item) + " to all Online!",bc_all; break; //Register gift to all accounts! case 4: mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Please hold..."; set [email protected], query_sql("SELECT account_id FROM `"+.LoginTableName$+"`",[email protected]); for(set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1) { sleep2 25; //Slowdown the loop abit. query_sql("INSERT INTO `" + .GiftTableName$ + "` (account_id, item, value, duration, timestamp) VALUES(" + [email protected][[email protected]] + ", " + [email protected]_item + ", " + [email protected]_value + ", " + [email protected] + ", " + [email protected] + ")"); } mes "Gift registered to (" + [email protected] + ") accounts!"; announce "[GM] "+strcharinfo(0)+" successfully sent " + [email protected]_value + "x as a Gift " + getitemname([email protected]_item) + " to Everyone.",bc_all; break; //Register gift to all online characters! case 5: mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Please hold..."; set [email protected], 0; //Counting success. set [email protected], query_sql("SELECT char_id FROM `"+.CharTableName$+"` WHERE online=1",[email protected]); for(set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1) { sleep2 25; //Slowdown the loop abit. [email protected] = query_sql("SELECT account_id, char_id FROM "+$GiftTableNameAT$+" WHERE char_id = "[email protected][[email protected]]+"", [email protected]_id, [email protected]_id); // check if in the table if ([email protected]) { query_sql("INSERT INTO `" + .GiftTableName$ + "` (char_id, item, value, duration, timestamp) VALUES (" + [email protected][[email protected]] + ", " + [email protected]_item + ", " + [email protected]_value + "," + [email protected] + "," + [email protected] + ")"); } } mes "Gift registered to (" + [email protected] + ") players!"; announce "[GM] "+strcharinfo(0)+" successfully sent " + [email protected]_value + "x as a Gift " + getitemname([email protected]_item) + " to all Online Characters",bc_all; break; //Register gift to all characters! case 6: mes "[" + strnpcinfo(1) + "]"; mes "^009900Gift is ready to go!^000000"; mes "Item: ^ff0000" + getitemname([email protected]_item) + "^000000"; mes "Quantity: ^ff0000" + [email protected]_value + "^000000"; mes "Claim Time: " + [email protected] + " Minutes"; next; if(select("Send Gift:Cancel") != 1) goto OnLeave; mes "[" + strnpcinfo(1) + "]"; mes "Please hold..."; set [email protected], query_sql("SELECT char_id FROM `"+.CharTableName$+"`",[email protected]); for(set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1) { sleep2 25; //Slowdown the loop abit. query_sql("INSERT INTO `" + .GiftTableName$ + "` (char_id, item, value, duration, timestamp) VALUES (" + [email protected][[email protected]] + ", " + [email protected]_item + ", " + [email protected]_value + "," + [email protected] + "," + [email protected] + ")"); } mes "Gift registered to (" + [email protected] + ") players!"; announce "[GM] "+strcharinfo(0)+" successfully sent " + [email protected]_value + "x as a Gift " + getitemname([email protected]_item) + " to " + [email protected]_name$,bc_all; break; //Cancel. Default: mes "[Reward Giver]"; mes "See you later"; break; } close; OnLeave: mes "[Reward Giver]"; mes "See you later"; cutin "v_sprakki04",255; close; OnNotExist: mes "[" + strnpcinfo(1) + "]"; mes "This account does not exist!"; cutin "v_sprakki04",255; close; //============Reset Function========================= OnDelete: mes "Which gifts do you want to reset?"; mes "1. Single Account"; mes "2. Single Character"; mes "3. All ^009900Online^000000 Accounts."; mes "4. All Accounts."; mes "5. All ^009900Online^000000 Players/Characters."; mes "6. All Players/Characters."; mes "7. All cancel"; switch(select("Single Account:Single Character:^009900Online^000000 Accounts:All Accounts:^009900Online^000000 Characters:All Characters:Specific Item:IPLimit Logs:Cancel")) { case 1: //Single Account mes "[" + strnpcinfo(1) + "]"; mes "Please select input type:"; mes "By AID or Name?"; next; if(select("Account ID:Character Name") == 1) { mes "[" + strnpcinfo(1) + "]"; mes "Write account id:"; next; input [email protected]_account, 2000000, 10000000; //Account id range from 2m to 10m. set [email protected], query_sql("SELECT account_id FROM `" + .CharTableName$ + "` WHERE account_id = " + [email protected]_account, [email protected]_account); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; query_sql("DELETE FROM " + .GiftTableName$ + " WHERE account_id = " + [email protected]_account); } else { mes "[" + strnpcinfo(1) + "]"; mes "Write player name:"; next; input [email protected]_name$; set [email protected], query_sql("SELECT account_id FROM `" + .CharTableName$ + "` WHERE name = '" + [email protected]_name$ + "'", [email protected]_account); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; query_sql("DELETE FROM " + .GiftTableName$ + " WHERE account_id = " + [email protected]_account); } break; case 2: //Single Character mes "[" + strnpcinfo(1) + "]"; mes "Please select input type:"; mes "By CID or Name?"; next; if(select("Character ID:Character Name") == 1) { mes "[" + strnpcinfo(1) + "]"; mes "Write character id:"; next; input [email protected]_char,150000, 10000000; //Char id range from 150k to 10m. set [email protected], query_sql("SELECT account_id, name FROM `" + .CharTableName$ + "` WHERE char_id = " + [email protected]_char, [email protected]_accountid, [email protected]_name$); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; query_sql("DELETE FROM " + .GiftTableName$ + " WHERE char_id = " + [email protected]_char); } else { mes "[" + strnpcinfo(1) + "]"; mes "Write player name:"; next; input [email protected]_name$; set [email protected], query_sql("SELECT char_id, account_id FROM `" + .CharTableName$ + "` WHERE name = '" + [email protected]_name$ + "'", [email protected]_char, [email protected]_accountid); if([email protected]) goto OnNotExist; if(select("Continue:Cancel") != 1) goto OnLeave; query_sql("DELETE FROM " + .GiftTableName$ + " WHERE char_id = " + [email protected]_char); } break; case 3: //All Online Accounts. mes "[" + strnpcinfo(1) + "]"; mes "Please hold..."; set [email protected], 0; //Counting success. set [email protected], query_sql("SELECT account_id FROM `"+.CharTableName$+"` WHERE online=1",[email protected]); for(set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1) { sleep2 25; //Slowdown the loop abit. query_sql("DELETE FROM " + .GiftTableName$ + " WHERE account_id = " + [email protected][[email protected]]); } break; case 4: //All Accounts. query_sql("DELETE FROM " + .GiftTableName$ + " WHERE account_id >= 1"); break; case 5: //All Online Players/Characters. mes "[" + strnpcinfo(1) + "]"; mes "Please hold..."; set [email protected], 0; //Counting success. set [email protected], query_sql("SELECT char_id FROM `"+.CharTableName$+"` WHERE online=1",[email protected]); for(set [email protected], 0; [email protected] < [email protected]; set [email protected], [email protected] + 1) { sleep2 25; //Slowdown the loop abit. query_sql("DELETE FROM " + .GiftTableName$ + " WHERE char_id = " + [email protected][[email protected]]); } break; case 6: //All Players/Characters. query_sql("TRUNCATE TABLE " + .GiftTableName$); break; case 7: // Delete specific item mes "Please type the id of the item you wish to delete"; mes "This will delete all entries with the item id you typed"; input([email protected]); next; mes "Are you sure you want to delete all entries of " + [email protected]; if (select("Yes:No")==1) { query_sql("DELETE FROM " + .GiftTableName$ + " WHERE item = " + [email protected] + ""); } else { mes "Deletion cancelled"; close; } case 8: //All ip logs query_sql("TRUNCATE TABLE " + .GiftTableNameIP$); break; default: break; } next; mes "deletion finished"; cutin "v_sprakki04",255; close; OnLimit: mes "Please enter an ip limit, current limit is " + .ip_limit; input(.ip_limit); mes "Done!"; cutin "v_sprakki04",255; close; //============================================================ // Config/Edit: //============================================================ OnLoadSetup: set .Setup, 1; //OnInit is loaded check. set .GMin, 60; //Minimum GM level to use gm panel. set .ZenyID,23500; // put this when asked for which item to give zeny. set .MaxZeny,1000000000; //Your table names: set .CharTableName$, "char"; //Character table name(SQL). set .LoginTableName$, "login"; set .GiftTableName$, "reward"; //Gift table name(SQL). set .GiftTableNameIP$, "reward_ip"; //Gift table name for ip tracker set $GiftTableNameAT$, "reward_at"; //Gift table name for auto trade tracker //Create gift table <auto_id>, <account_id>, <char_id>, <item>, <value> query_sql("CREATE TABLE IF NOT EXISTS `reward` (`id` int(11) NOT NULL AUTO_INCREMENT,`account_id` int(11) unsigned NOT NULL DEFAULT '0',`char_id` int(11) unsigned NOT NULL DEFAULT '0',`item` int(11) NOT NULL DEFAULT '0',`value` int(11) NOT NULL DEFAULT '0',`duration` int(11) NOT NULL DEFAULT '0',`timestamp` int(23) NOT NULL DEFAULT '0',PRIMARY KEY (`id`))"); query_sql("CREATE TABLE IF NOT EXISTS `reward_ip` ( `give_id` int(11) NOT NULL, `item_id` int(11) NOT NULL, `ip_address` varchar(23) NOT NULL, `claim_count` int(11) NOT NULL, PRIMARY KEY (`give_id`))"); query_sql("CREATE TABLE IF NOT EXISTS `reward_at` (`account_id` int(11) NOT NULL,`char_id` int(11) NOT NULL)"); return; OnInit: callsub OnLoadSetup; waitingroom "Prize Giver",0; end; } /* Manual table update for at tracker CREATE TABLE IF NOT EXISTS `reward_at` ( `account_id` int(11) NOT NULL, `char_id` int(11) NOT NULL ); */ - script anti_trader -1,{ OnInit: .is_anti_trade = 1; // 0 to disable end; } function script PG_30Seconds { //dispbottom "anti trader 30sec"; //Check if Vending (normal or @at) if(checkvending() >= 1) { // mark as auto trader [email protected] = query_sql("SELECT account_id, char_id FROM "+$GiftTableNameAT$+" WHERE account_id = "+getcharid(3)+"", [email protected]_id, [email protected]_id); // check if in the table if ([email protected]) { // add if not there yet query_sql("INSERT INTO "+$GiftTableNameAT$+"(account_id,char_id) VALUES("+getcharid(3)+","+getcharid(0)+")"); //dispbottom "you have been marked as auto trader"; stopnpctimer; detachnpctimer; end; } } return; } function script PG_Login { //dispbottom "at delete"; [email protected] = query_sql("SELECT account_id, char_id FROM "+$GiftTableNameAT$+" WHERE account_id = "+getcharid(3)+"", [email protected]_id, [email protected]_id); // check if in the table if ([email protected]) { // remove to reverify vending status query_sql("DELETE FROM "+$GiftTableNameAT$+" WHERE account_id = "+getcharid(3)+""); } }
  5. Good Day Everyone, I found this script https://pastebin.com/raw/W4UXJLw9 made by sir @Emistry I would like to make a request about the script he made, if only possible? here are some customization that I'd like to request.. 1. I want to add more items to the NPC to craft (ex. custom shield, boots, etc..) 2. the NPC need a payment and when the crafting failed the payment increases.. 3. it will increase amount of the item needed when failed also.. thank you in advance
  6. sir @Emistry can I make a request for this script? 1. I want to add more items to craft (ex. custom shield, boots, etc..) 2. need a payment.. and then when it failed to craft, the payment increases.. 3. it will increase amount of the item needed when failed also.. I know this is too much..
  7. sir @Emistry i'm really sorry about this, but what I was searching for is the NPC that makes this items.. anyway thanks for your response..
  8. where can I locate Upgraded Items NPC in my folder? just like Upg Manteau, etc.. thanks..
  9. where can I edit this message? thanks in advance..
  10. @Fratini thanks for helping.. I appreciate it so much.. @Emistry your script works perfectly, thank you.. thanks for the both of you guys..
  11. it's working now, but the problem is this line.. announce "Congratulation NameRO for reaching "[email protected]+"+ Players !!",bc_all; it announces Congratulation NameRO for reaching 0+ Players.. why does the script announce 0 Players? and every time I relog in the game, the script spam announcing.. even though I'm the only player..
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Privacy Policy.