Jump to content

tmav94

Members
  • Content Count

    55
  • Joined

  • Last visited


Reputation Activity

  1. Upvote
    tmav94 got a reaction from Xsoid in Packet_key for 2014-04-10b Client   
    Hi, guys!
    Anyone have the packet_keys for fix the Quest Issues in this client?
    If you try to get more than 1 quest on 2014-04-10, after disconnect or relog, you can't enter in your whitout get gravity error.

    To fix it, you need to remove the additional quests in "Quest" Table MySQL.
  2. Upvote
    tmav94 reacted to iCORE in Thor Patcher wont update   
    start from
    100 yourthor.thor101 yourthor1.thor102 yourthor2.thor103 yourthor3.thor105 yourthor4.thorand so on....
  3. Upvote
    tmav94 reacted to Winterfox in Ways to convert script to function   
    @@tmav94
     
    - script whiteList -1,{ OnWhisperGlobal: mes "Lista Atualizada"; $whiteList$ = "2000000,2000794,2000839,2000637,2000624,2000016,2004000,2003933,2003884"; mes $whiteList$; close;}function script restrictedCode { .@query_result = query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE login.last_ip=(SELECT last_ip FROM login WHERE account_id="+getcharid(3)+") AND `char`.online=1", .@account_id); if ( .@query_result > 1 && compare( $whiteList$, getcharid(3) ) == 0 ) { mes "[WARNING]"; mes "Access Denied"; close; }}prontera,166,206,5 script Example 405,{ callfunc( "restrictedCode" ); mes "Access granted!"; close;}prontera,164,200,5 script Example2 405,{ callfunc( "restrictedCode" ); mes "Access granted!"; close;}
  4. Upvote
    tmav94 reacted to Dastgir in 2014-10-22, Roulette and per-char gender!   
    That's not implemented(Maybe because it's not yet a complete feature coded in client itself)
  5. Upvote
    tmav94 reacted to Dastgir in 2014-10-22 msgstring tables   
    https://github.com/ROClientSide/Translation
  6. Upvote
    tmav94 reacted to Mystery in Migration rAthena to Hercules   
    Yes it is. Also, why not setup a "test" server to test out the features? Also, search 'migrate' in our search box. You'll find some things.
  7. Upvote
    tmav94 reacted to Garr in MapFlags, cells, Skill abuse and KvM(BG)   
    Well, the problem is a bit larger than that, it's just that most AoE skills (like EQ, songs, Meteor Assault) pass though walls. I had to make modifications in src to prevent that, but I'm not really sure if it's intended behavior or not. I'll try to look for my old remarks on what I changed, and if I won't find them I'll check out again if you need this change.
  8. Upvote
    tmav94 reacted to evilpuncker in How to check if the character are in Autotrade with mysql   
    not possible I guess, but if you try to explain what exactly you are trying to do we may think of another way of achieving it
  9. Upvote
    tmav94 reacted to Dastgir in [Release] ExtendedBG for Hercules (with eAmod BG modes)   
    Hello Hercules Community,
     
    Let me explain it first.
    It is ExtendedBG, which tends to contain all eAmodBG modes and extra modes(as and when coded).
    Some Previews:
    http://imgur.com/a/2SSVR
    Ohh, and the last thing I forgot to tell,
    Its 100% Plugin and Script, no Source Edits ..
     
    Special Thanks To:
    jaBote co-founded this project(and really thanks to him , that he motivated me at start at provided some functions and idea of how the base should be, and what we should do it to give flavor of Hercules in it).
     
    Repository Link: https://github.com/dastgirp/eBG (Please read README.md for installation steps)
     
    Leave Comments/Suggestions if you find something.
    NOTE:
     There might be some(/many) debug messages left in map-server which will be cleaned up. I will add battle.conf soon (you have to add it yourself for now or edit the plugin) The plugin might be a big mess to read/understand (I did many experiments over the year) There might be some bugs Thanks to @Rebel and @Myriad for testing and providing initial feedback
    Contact me on Discord: @Dastgir#1460 if there's some urgent issue or else open the issue in github. keep this topic for support.
     
    Want to encourage me??

     
  10. Upvote
    tmav94 reacted to Dastgir in Query_sql to check if the players is online   
    why use query_sql
    you can use this method
    .@acc_id = charid2rid(.@char_id);if (!.@acc_id){ debugmes "Char not online"; end;}//DO anything with .@char_id and .@acc_id here.(Character is Online)
  11. Upvote
    tmav94 reacted to Kuya Jeo in Produce a Unservant Mob to help a player and fight against another mob.   
    @@tmav94 read this topic from rAthena

    https://rathena.org/board/topic/74316-event-mvp-vs-mvp/
  12. Upvote
    tmav94 reacted to mleo1 in Help with some multiples query_sql   
    query_sql( "SELECT `x` FROM `y` WHERE `char_id` = '"+escape_sql( getcharid(0) )+"'",.@status);
     
    https://rathena.org/wiki/Query_sql
     

     
     
    you need to look at
    picklog table: type field
    mysql limit, you need to offset to show them all

        Not Tested Samplequery last 20 items that you sent in storage sample
    set .@nb, query_logsql("SELECT nameid, amount FROM picklog WHERE type='R' AND amount<0 AND char_id=150000 ORDER BY time DESC LIMIT 20",.@item,.@amount); for(set .@i,0; .@i < .@nb; set .@i,.@i+1) mes .@item[.@i] +" "+ .@amount[.@i];
  13. Upvote
    tmav94 reacted to evilpuncker in Help me with MySql + Scripts + Restrictions.   
    it is selecting 'login' that got an 'online'(0 = offline) character from the same 'last_ip', since they are two different tables, it uses left join
  14. Upvote
    tmav94 reacted to evilpuncker in Help me with MySql + Scripts + Restrictions.   
    if (query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE login.last_ip=(SELECT last_ip FROM login WHERE account_id="+getcharid(3)+") AND `char`.online=1", .@account_id) > 1)   { end script } else { run script }
  15. Upvote
    tmav94 reacted to Rand in Some itens bonus ^^   
    use https://github.com/HerculesWS/Hercules/blob/master/doc/item_bonus.txt
     
    bonus2 bSPRegenRate,1,10000; bonus2 bHPRegenRate,1,10000; 
  16. Upvote
    tmav94 reacted to evilpuncker in How to wipe all MvP cards on database?   
    update is to remove the card from the equipment
  17. Upvote
    tmav94 reacted to Dastgir in What's the packet and what can i do with it?   
    add packets in src/map/packets.h
     
    but , imo, use 2014-02-05(the last stable client) and hercules emulator have it on packets.h
     
    P.S:  Don't forget to edit "#define PACKETVER" in src/common/mmo.h to your client-date
  18. Upvote
    tmav94 reacted to Dastgir in Where are the packets for 2014-06-13aRagexe.exe   
    Not yet added (maybe no one have time to grab its packets)
  19. Upvote
    tmav94 reacted to Dastgir in What's the packet and what can i do with it?   
    Packets are used to communicate between server and client and share some informations regarding it.
  20. Upvote
    tmav94 reacted to Dastgir in Data for Rebellion!   
    By Updating your kRO
  21. Upvote
    tmav94 reacted to Dastgir in How to Diff the 2014 client?   
    For data and system folder, use : https://github.com/ROClientSide/TranslationNemo dont have read lua before lub, because it conflicts with some ofthe file, causing client to not behave properly.
    And yes, you dont need any diff file for using nemo patcher.
  22. Upvote
    tmav94 reacted to evilpuncker in How to Diff the 2014 client?   
    use NEMO http://herc.ws/board/topic/2905-nemo-client-patcher/
×
×
  • Create New...

Important Information

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