Jump to content

Capuche

Developer
  • Posts

    2407
  • Joined

  • Last visited

  • Days Won

    52

Everything posted by Capuche

  1. Mapflag#restricted.txt ? trunk/npc/mapflag/restricted.txt
  2. Check at the end of the script... set .ThirdClass,1; // Enable third classes? (1: yes / 0: no)
  3. OnPCKillEvent: .@lvl_opponent = readparam( 11, rid2name( killedrid ) ); end; Using readparam (param number 11 is baselevel)
  4. Replace yours lines by this line query_sql "INSERT INTO `mvp` VALUES (" + getcharid(0) + ",'" + escape_sql( strcharinfo(0) ) + "',1,1) on duplicate key update `kills` = `kills` + 1, `points` = `points` +1"; If you still have some error, report it
  5. trunk/db/pre-re/item_db.txt
  6. In data/ChatWndInfo_U.lua or SaveData/ChatWndInfo_U.lua, client side
  7. Add ""+ in all compare function compare( ""+ getarg
  8. prontera,168,179,5 script Registros 757,{ mes "Digite o ID do item o qual você quer saber a quantidade existente no servidor no momento."; mes "Exemplo: ^0b85f8Rondel [1] (id: 13017).^000000"; mes "^0b85f8Chifres Místicos de Bafomé (id: 5518).^000000"; input .@item_id; if( getitemname( .@item_id ) != "null" ){ for( set .@i,0; .@i < .sql_size; set .@i,.@i + 1 ){ query_sql( "SELECT SUM(`amount`) FROM `"+.sql_table$[.@i]+"` WHERE `nameid`='"+.@item_id+"'",.@amount ); query_sql( "SELECT COUNT(`card0`) FROM `"+.sql_table$[.@i]+"` WHERE `card0`='"+.@item_id+"'",.@card0 ); query_sql( "SELECT COUNT(`card1`) FROM `"+.sql_table$[.@i]+"` WHERE `card1`='"+.@item_id+"'",.@card1 ); query_sql( "SELECT COUNT(`card2`) FROM `"+.sql_table$[.@i]+"` WHERE `card2`='"+.@item_id+"'",.@card2 ); query_sql( "SELECT COUNT(`card3`) FROM `"+.sql_table$[.@i]+"` WHERE `card3`='"+.@item_id+"'",.@card3 ); set .@total,.@total + ( .@amount + .@card0 + .@card1 + .@card2 + .@card3 ); } mes "Encontrado "+.@total+" x "+getitemname( .@item_id ); if ( getgmlevel() >= 99 && .@total ) { next; if ( select( "Close", "Delete this item" ) == 2 ) { for( set .@i,0; .@i < .sql_size; set .@i,.@i + 1 ) { query_sql "delete from `"+.sql_table$[.@i]+"` WHERE ( `nameid`='"+.@item_id+"' or `card0`='"+.@item_id+"' or "+ "`card1`='"+.@item_id+"' or `card2`='"+.@item_id+"' or `card3`='"+.@item_id+"' )"; } set .@count, query_sql( "select `account_id` from `char` where `online` = 1", .@account_id ); set .@origin, getcharid(3); for( set .@i,0; .@i < .@count; set .@i,.@i + 1 ){ attachrid .@account_id; set .@amount, countitem( .@item_id ); delitem .@item_id, .@amount; } attachrid .@origin; mes "Done."; } } }else{ mes "ID Item inválido"; } close; OnInit: setarray .sql_table$[0],"inventory","cart_inventory","guild_storage","storage","mail"; set .sql_size,getarraysize( .sql_table$ ); end; } Don't forget to save you database, just in case... Also players online can dupe the npc when you delete the items : there aren't any commands (in svn) to delete the items in a storage already opened or in a cart
  9. mes "[Premium Disguise]"; mes "Alright, thank you! You can now access the "+getarg(2)+" headgear."; delitem 7227, getarg(1); setd "#"+getarg(0)+getarg(3),1; You were right
  10. Post your current poring catcher
  11. .. or in group.conf accinfo: false for others group?
  12. Or like this trunk/npc/custom/card_remover.txt
  13. It opens only once... it never closes?
  14. Capuche

    Poring race

    Poring Race 3th link
  15. A menu to select one name? for(set .@i,0; .@i < .@nb; set .@i,.@i+1){ mes (.@i+1)+". "+.@name$[.@i]+" ("+.@account_id[.@i]+")"; .@menu$ = .@menu$ + "+.@name$[.@i]+" ("+.@account_id[.@i]+"):"; } .@s = select( .@menu$ ) -1;
  16. Disable the mvp arena in script_custom.conf //npc: npc/custom/etc/mvp_arena.txt
  17. compare's command can only compare the difference into 2 strings. This warning tells you that one of the string is an integer variable in argument. Add a +"" with the integer argument to stop this warning.
  18. You can make several shop in the main npc prontera,142,172,5 script Recorn's Customs#1 998,{ callfunc "qshop",1,2,3,4; }// call shop 1,2,3,4 ra_temple,144,190,11 script Primelda's Headgear Machine#1 562,{ callfunc "qshop",5; }// call shop 5 setarray .Shops$[1],"Headgears","Wings","Weapons","Other","Cute Headgears"; Add(1,5022,1,1000000,0,7086,1,969,10,999,40,1003,50,984,2); Add(1,5032,1,100000,0,1059,250,2221,1,2227,1,7063,600); Add(1,5027,1,100000,0,2252,1,1036,400,7001,50,4052,1); Add(1,5045,1,100000,0,2252,1,1054,450,943,200); Add(1,5372,1,30000000,0,5058,1,7166,1000,982,10); Add(1,18600,1,45000000,0,5016,1,2747,5,4257,1,4195,1,983,10); Add(1,5457,1,20000000,0,10007,10,1234,1,2214,1,982,10); add(1,5442,1,5000000,0,7441,10,1034,100,5052,1,978,1); add(1,5495,1,15000000,0,12028,10,1468,1,996,50,7162,100,615,5); add(1,5293,1,20000000,0,7134,100,577,100,523,100,12085,10,544,10); add(1,5401,1,20000000,0,2276,1,7799,10,734,100,4412,1); add(1,5325,1,35000000,0,5104,1,5034,1,4021,1,7095,500,1971,5); add(1,5362,1,15000000,0,4230,1,7157,200,7156,400,7117,250); add(1,18505,1,5000000,0,1615,1,932,300,628,100); add(1,5305,1,30000000,0,2287,10,5019,1,4337,1,7110,500); add(1,5574,1,10000000,0,7315,100,7201,150,738,1); Add(2,26002,1,0,0,7063,1000,2254,1,2743,2,674,5); Add(2,26003,1,0,0,7063,1000,2255,1,2680,2,674,5); Add(3,1224,1,0,0,7297,30,969,10,999,50,714,10); Add(3,1225,1,0,0,7292,30,969,10,999,50,714,10); Add(4,531,1,3,0,512,1,713,1); Add(4,532,1,3,0,513,1,713,1); Add(4,533,1,3,0,514,1,713,1); Add(4,534,1,3,0,515,1,713,1); Add(5,5133,1,0,0,671,1,4150,1,7107,300,7106,500); Add(5,5151,1,0,0,671,1,5001,1,7319,200,4001,2); Add(5,5182,1,0,0,671,1,4023,1,920,400,9010,1); Add(5,5454,1,0,0,671,1,4029,1,7030,300,9010,1); Add(5,5186,1,0,0,671,1,4280,1,1032,300,12002,20); Add(5,5455,1,0,0,671,1,4280,1,1033,300,12002,20); Add(5,5129,1,0,0,671,1,4015,1,574,30,916,100,7203,100); Add(5,5183,1,0,0,671,1,1049,1,574,30,916,100,7203,100); Add(5,5020,1,0,0,671,1,2210,1,1059,300,7166,300); Add(5,5387,1,0,0,671,1,2213,1,1059,300,7165,300); Add(5,5099,1,0,0,671,1,2213,1,4195,1,6394,100,980,1); Add(5,5185,1,0,0,671,1,7298,300,706,10,7198,300,2270,1); Add(5,5187,1,0,0,671,1,5085,1,7213,300,975,5); Add(5,5776,1,0,0,671,1,994,10,7097,500,7098,500,7451,1); Add(5,5297,1,0,0,671,1,2254,1,2282,1,7063,200,6394,100); Add(5,5456,1,0,0,671,1,2227,1,582,250,568,250,976,1); Add(5,5317,1,0,0,671,1,2227,1,995,10,544,100,1249,1); Add(5,5382,1,0,0,671,1,2244,1,5083,1,530,100,538,100); Add(5,5339,1,0,0,671,1,2272,1,7151,50,7111,50); Add(5,5336,1,0,0,671,1,2272,1,7151,50,7111,50); Add(5,5337,1,0,0,671,1,2272,1,7151,50,7111,50); Add(5,5338,1,0,0,671,1,2272,1,7151,50,7111,50); Add(5,5346,1,0,0,671,1,2272,1,7151,50,7111,50); Add(5,5474,1,0,0,671,1,2272,1,7151,50,7111,50,983,1);
  19. In misc.conf A map with the Mapflag#town enabled is a safe map.
  20. The first value start at index 0 to index ( .@nb - 1 ) in yours variables so you need for(set .@i,0; .@i < .@nb; set .@i,.@i+1){ mes (.@i+1)+". "+.@name$[.@i]+" ("+.@account_id[.@i]+")"; }
  21. according to the docs : Your item is a garment or something ? must be type 4 for weapon Type: 0 Healing item. 2 Usable item. 3 Etc item 4 Weapon 5 Armor/Garment/Boots/Headgear I don't uderstand your question. The item is supposed to damage yourself (-500 hp) ? or add base attack to your character ?
  22. getargcount function : r15340
  23. set Zeny,Zeny-100000; mercenary_heal -1000000,0; warp "ordeal_2-1",156,155; nb. Your gold room is on ordeal_2-1 or bossnia_02... ? warp "ordeal_2-1",156,155; bossnia_02,203,203,5 script Gold Miner 807,{
  24. mercenary_heal -1000000,0; after being warp will kill the mercenary
×
×
  • Create New...