tmav94
-
Content Count
55 -
Joined
-
Last visited
Reputation Activity
-
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.
-
tmav94 reacted to iCORE in Thor Patcher wont update
start from
100 yourthor.thor101 yourthor1.thor102 yourthor2.thor103 yourthor3.thor105 yourthor4.thorand so on.... -
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;} -
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)
-
tmav94 reacted to Dastgir in 2014-10-22 msgstring tables
https://github.com/ROClientSide/Translation -
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.
-
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.
-
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
-
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??
-
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) -
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/
-
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]; -
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
-
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 } -
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; -
tmav94 reacted to evilpuncker in How to wipe all MvP cards on database?
update is to remove the card from the equipment
-
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
-
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)
-
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.
-
-
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.
-
tmav94 reacted to evilpuncker in How to Diff the 2014 client?
use NEMO http://herc.ws/board/topic/2905-nemo-client-patcher/