Hanashi

how to select remove all inventory items from the database and change group id of a certain account using sql script?

simply it creates account and add them to the sql database @account <userid>,<user_pass>,<sex> it still checks the following: *must be 4 or not more than 50 character length in userid/user_pass *only accepts alphanumeric key *doesnt accept if the userid already exist *doesnt accept if the gender is not M/F *[email protected] should be the default email purpose: easy access,monitoring,allowing only few staff to create account

already done lmao it has nothing to do with my custom command i just fix the boolean codes of pc_getitemfromcart

ohh got it thanks

ok so i'll just add return 0; or return -1 in each line or something?

i only base on @dropall command

@inventorycart {<item type>} transfer all items from cart to inventory based on the item type. Valid item types: -1 = All Items (default) 0 = Healing Items 2 = Useable Items 3 = Etc Items 4 = Armors 5 = Weapons 6 = Cards 7 = Pet Eggs 8 = Pet Armors 10 = Ammunition Items example: you want to transfer all healing items from cart to inventory @inventorycart 0

/*========================================== where it transfer cart items to inventory ==========================================*/ ACMD_FUNC(inventorycart) { int8 type = -1; uint16 i, count = 0, count2 = 0; struct item_data *item_data = NULL; nullpo_retr(-1, sd); if( message[0] ) { type = atoi(message); if( type != -1 && type != IT_HEALING && type != IT_USABLE && type != IT_ETC && type != IT_WEAPON && type != IT_ARMOR && type != IT_CARD && type != IT_PETEGG && type != IT_PETARMOR && type != IT_AMMO ) return -1; } if (pc_iscarton(sd) != 0) { for( i = 0; i < MAX_CART; i++ ) { if( sd->status.cart[i].amount ) { if( (item_data = itemdb_exists(sd->status.cart[i].nameid)) == NULL ) { ShowDebug("Non-existant item %d on inventoryall list (account_id: %d, char_id: %d)\n", sd->status.cart[i].nameid, sd->status.account_id, sd->status.char_id); continue; } if( type == -1 || type == (uint8)item_data->type ) { if(pc_getitemfromcart(sd, i, sd->status.cart[i].amount)) count += sd->status.cart[i].amount; else count2 += sd->status.cart[i].amount; } } } } return 0; } 3>c:\users\my\desktop\ragnarok\rathena\src\map\pc.c(5162): warning C4033: 'pc_getitemfromcart' must return a value 3>c:\users\my\desktop\ragnarok\rathena\src\map\pc.c(5165): warning C4033: 'pc_getitemfromcart' must return a value 3>c:\users\my\desktop\ragnarok\rathena\src\map\pc.c(5170): warning C4033: 'pc_getitemfromcart' must return a value 3>c:\users\my\desktop\ragnarok\rathena\src\map\pc.c(5177): warning C4716: 'pc_getitemfromcart': must return a value

i tried to change void to bool on pc_getitemfromcart in pc.c and pc.h but it gives me warning on compiling if i use pc_getitemfromcart on custom @command

thanks it works fine

i dont know either im still looking for the function

moves the item from one place to another @moveitem <item name/ID/all>,<current location of item>,<destined location> -1 =all items on specific storage 1=inventory 2=storage 3=cart example: i want to move all items from inventory to cart @moveitem -1,1,3 i hope someone could do this

my reason requesting this is to check item in characters inventory if can be drop or not in scripting and to avoid the duplicate issue in this link https://rathena.org/board/topic/60636-player-item-drop-when-it-killed/ it can be done through @dropall - script DeathHandle -1,{ OnPCDieEvent: nude; atcommand "@dropall -1"; end; }

same function as @dropall but it drops all item in cart

where can i edit this?

anyone knows how to make custom diff for nemo making client dependent to another program? like it will open only if you use launcher.exe,it will automatically close without shield.exe

i will try to make a program that would prevent this third parties so if you could list them that would be huge help to our community and i will make it free service

[solved]

i already did that fcp bypass facepalm* =,=' please use google search

[solved] answers are in here https://www.midgard-community.com/forums/

[solved]

does anyone knew how to cast end chasewalk using hiding skill?

thanks ^^

as title says

solved in holy light but not in charge attack i tried the charge attack but it gives two type of damage at once(one is the distance and the other is splash attack) how to make it the distance damage go along with the splash damage?