Jump to content

Feilor

Members
  • Posts

    135
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by Feilor

  1. Looks like we can't disable it with NEMO anymore... At least I tried with some lastest hexeds and couldn't, does anyone know which packets or where is the function that return the information to hexeds?
  2. View File Sky Fortress weapons enchantmet Since rA hasn't the possibility to make a easy way to the weapon comes enchanted, this NPC gives the power to the player enchant their Vicious Weapons with 3 sets of differents properties: Slot 1 Weapon Element (Fire, Water, Wind, Earth, Poison, Holy, or Shadow) Damage/Magic Damage to enemy's Element +1% ~ 20% Healing Power 20% Weapon unaffected by Size Penalty Weapon cannot be broken in battle Slot 2 Damage/Magic Damage to enemy's Race +1% ~ 20% Bypass DEF/MDEF of enemy's Race by 1% ~ 30% Bypass DEF/MDEF of Normal enemies by 16% ~ 25% Damage to Boss monsters +20% Slot 3 Stat +1 ~ 10 ATK +4 ~ 47 MATK +4 ~ 50 CRIT +10 ~ 19 Critical Damage +1% ~ 20% ASPD +1% ~ 5% Variable Cast Time -1% ~ 20% Cast Delay -5% ~ 20% Skill SP Cost -5% Ranged Damage +13 ~ 20% WARNINGS Need support or want to contact me? Onlye here in rA; This scripts work is only granted in rA, the use in another emulators is your responsibility or if you want assist on it, I will charge. LICENSE You ARE NOT allowed to redistribute this script in any way; All rights to this scripts are mine; Chargeback scams are not tolerated if any of them happens the script will be removed from this store; Terms above may be changed or adjusted without prior notification. Submitter Feilor Submitted 01/22/2018 Category Utilities Video Content Author Feilor  
  3. i love how you treats people, maybe you think that are a god divine, i didn't harassing any staff member, unless to get the information that paid files need to be accepted by you. Maybe you need to think more before answer people, I just asked a simple question and looks like you got offended.
  4. The mainly thing here is to get all characters ids from account X even the deleted ones and join with pick to see how many item Y the account got, in my case i save the mac addres and hardware id so i want to get all characters that has the same mac address/hardware id but the point here is... if we have a account_id in pick log, this work would be easier since we can skip some joins, plus, if we want to display logs to players in fluxcp it would be nice as well since less joins more performance...
  5. are you saying to use this if i want a better query: select * from login l JOIN acc_reg_num an ON an.account_id = l.account_id JOIN `char` c ON c.account_id = l.account_id JOIN picklog pl ON pl.char_id = c.char_id JOIN charlog cl ON cl.account_id = l.account_id WHERE c.char_id IN (SELET GROUP_CONCAT(',',pl.char_id) FROM pl WHERE cl.message like %ID%) this is a bad example that i made, in this example if i want to use the ID to join and get character name and account_id i need to make alot of workarouns (i didn't the one that will split CID from char_id but i hope you get my point) I'm not a expertise in SQL and this is a example that i made to apply what you said
  6. @Tokei i didn't knew about this table, thought all logs table was in log file, anyway... I take a look on it and this is a weird way to log things, i mean... if this is a char log, why there doesn't has a char_id? When we delete a char we has this message "Deleted char (CID 150368)", if we want to make things directly in querys, just can't because this is a varchar... If the emulator provide a better and clean log system we couldn't has any problem to find or make systems with those dbs
  7. Hello rA community! I want to propose a change in picklog db... why? It's simple, the picklog db only saves the char_id, if the player delete it we lose any reference and we can't find the account, therefore losing the power to find the account that wasn't suppoused to be. My suggestion is to insert account_id on it or create a table to log when the the char gets deleted.
  8. I'm curious to know why my script didn't got published yet and another two files got it. sent pm to Akkarin and didn't got any answer until today, the script was sent 01/22.
  9. Version 1.0.2

    30 downloads

    Since rA hasn't the possibility to make a easy way to the weapon comes enchanted, this NPC gives the power to the player enchant their Vicious Weapons with 3 sets of differents properties: Slot 1 Weapon Element (Fire, Water, Wind, Earth, Poison, Holy, or Shadow) Damage/Magic Damage to enemy's Element +1% ~ 20% Healing Power 20% Weapon unaffected by Size Penalty Weapon cannot be broken in battle Slot 2 Damage/Magic Damage to enemy's Race +1% ~ 20% Bypass DEF/MDEF of enemy's Race by 1% ~ 30% Bypass DEF/MDEF of Normal enemies by 16% ~ 25% Damage to Boss monsters +20% Slot 3 Stat +1 ~ 10 ATK +4 ~ 47 MATK +4 ~ 50 CRIT +10 ~ 19 Critical Damage +1% ~ 20% ASPD +1% ~ 5% Variable Cast Time -1% ~ 20% Cast Delay -5% ~ 20% Skill SP Cost -5% Ranged Damage +13 ~ 20% WARNINGS Need support or want to contact me? Onlye here in rA; This scripts work is only granted in rA, the use in another emulators is your responsibility or if you want assist on it, I will charge. LICENSE You ARE NOT allowed to redistribute this script in any way; All rights to this scripts are mine; Chargeback scams are not tolerated if any of them happens the script will be removed from this store; Terms above may be changed or adjusted without prior notification.
    20.00 USD
  10. I know that, was there where i tried to learn but looks like i failed
  11. could someone help me with getd? i have this: explode(.@opcoes$,getd(".@"+"enchantgroup"+(atoi(getarg(1))+1)+"$")[(rand(1,getarraysize(getd(".@"+"enchantgroup"+(atoi(getarg(1))+1)+"$")))-1)],","); and i'm getting this error:
  12. Hi! I'm trying to use random option in a NPC but i got some confused with the sample in rA doc folder. This give this exemple: setrandomoption(EQI_HAND_R,0,RDMOPT_WEAPON_ATTR_NOTHING + rand(10),0,0); does + rand(10) in option ID means that it will loop through ATTR options and rand the element? If yes, can it be used in all, like if i want to add race atributes the same can be done?
  13. Well, to make the official way it's get hard, but you can do it as NPC way, players drop the weapon and go to a NPC to get the options, it's a better way since you need only to create group 1, 2 and 3 and in the npc make it random
  14. All banks in Brazil uses the same security module Warsaw, this module makes the client crash before open, the solution is try to execute more than one time and sometimes it open.
  15. did you found it? i'm enchanted with this system want to try
  16. @Alayne Looks like some maps from YProject are missing could you take a look please!? I really enjoyed this system and want to try it! So for the ones that I didn't found in git: dep_lb, tortuga, invek, casp_dun02, casp_step, casp_cave, zhakastia, revencia, mysterio, crash, caspen, thier_vlg and any yggmaze maps
  17. Hi Alayne!! Could you add the maps please!?
  18. What I want is to consume a item in @warp command, but Idk how check if player has the item and if true, delete it.
  19. could someone point me how can I check if player has a item and delete that item from inventory in source please? I want to use in atcommand, thanks!
  20. I'm making a new server and want to use the login from the old one, followed this guide: https://github.com/rathena/rathena/wiki/Multiple_Servers When I tries to login in the second server I get stuck in please wait, the first one works fine. I created two users with S sex, one for each. Changed the ports and created a new table for the new one since i'm using only login.
  21. anyone getting problem where when you try to buy from a item you get message saying the seller hasn't weight?
  22. @sader1992 @SBK_ I have the same problem with all 2015+ hexeds, did you found any fix for it?
  23. is possible to enable the old crash log window in 2015~2016 hexeds?
×
×
  • Create New...