daim

figured it out: SELECT * FROM `global_reg_value` WHERE `str` LIKE '#CASHPOINTS' ORDER BY CAST(value AS DECIMAL(10,2)) DESC

global_reg_value is VARCHAR type. So i wont know which value is most due it will sort as result like this 111 1111 11111 2 333 3333 not like this: 11111 3333 1111 333 1

Hi guys, Anyone know how to sort #CASHPOINTS in phpmyadmin? I dont want the sorting become like this 1 11 111 2 222 2222 but i want like this 99999 55555 9999 the most on top. thanks

pls dont hijack mi thread.. anyone has solution how to make some cards drop rate lower then global minimum drop rate?

I hope someone can help me in this. Make card drop affect by mob_item_ration setting please.

hi there, I would like to make by default all boss card drop rate is 20% and for some boss like thanatos i would like to set the drop rate to 1%. This setting doable with some mod by dreamunreal named "Advanced common drop rate" unfotunetly this mod is not compatible with Hercules. In mob_item_ratio it said: // - Does not affect card/item-granted drops. To adjust card/item-granted// drops, edit them in item_db. in which section in item_db should i change so i can adjust the drop rate like i wanted Thanks for help

How about wpe protection? Is it robrowser support packet encryption by hercules?

issit multiplie windows available for this client?

Hi there, Im using this client for my new project. Unfortunetly i having few problems. 1. Some button not translated (ie guild disband button showing glibberish text. 2. Item info not translated. (i already put iteminfo.lub inside my grf but still it showing glibberish text on item description) please help. Thanks

The PacketEncryption System is available in 20120424, but the Keys Chosen from kRO are bad(So WPE will work because of those bad keys), so just change the keys which are working, or just change the client. thanks for explanation. May i know how cna i change the keys which are wrkking? How do i know? thanks http://www.robrowser.com/prototype/packet-keys/ (Choose previous client keys which are marked as PASSED, or try to create your own key, and check if it PASS.) Use NEMO Patcher and diff it with custom Packet Keys, and enter the Packet Keys There. Or by IDA(http://herc.ws/board/topic/1105-hercules-wpe-free-june-14th-patch/#entry8001) Also in SErver Side: Change src/map/packets.h to support your custom keys. thanks sir.

The PacketEncryption System is available in 20120424, but the Keys Chosen from kRO are bad(So WPE will work because of those bad keys), so just change the keys which are working, or just change the client. thanks for explanation. May i know how cna i change the keys which are wrkking? How do i know? thanks

can u confirm sir? As posting in here http://herc.ws/board/topic/1105-hercules-wpe-free-june-14th-patch/ this client version 20120424 is working. But from your tools it say broken.

what error u got there?

hi there, Im just switched to 18-04-02012ragexe client. The porblem here is when i use "DISABLENPC" from npc it wont hide at all. It will hide for temporary if we move out of sight then come near to the npc we able to see the npc, but we unable to click it since it's disabled. How to slove this problem? Thanks

thanks sir

hi all.. Could anyone here tell me how to fix the button and text on title box as in the circle pitcure below? Im using 18-4-2012 client thanks in advance.

sir how about server with game guard protector like harmony? Is this function will still be working?

now when i tried to run server i got this error: : DB error - Unknown column 'character_slots' in 'field list' [Debug]: at account_sql.c:528 - SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`,`pincode_change` FROM `login` WHERE `account_id` = 1 anything i miss ?

so we dont have to upgrade manualy? let say im using eathena version 1430, and i no need to update sql manualy? thats what u mean malufett?

Hi, I would like to switch form eathena to herules. Unfortunetly the require UPDATED SQL/ UPGRADE SQL file to uptodate revision of hercules is not included in sql-files/upgrade like it should be. There is only timestamp file.sql any clue?

thats mean look like i have to upgrade my entire debian..

Hi, I tried to compile but i got this error: ../common/obj_all/common.a(mempool.o): In function `InterlockedIncrement64': ../common/atomic.h:100: undefined reference to `__sync_add_and_fetch_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedExchange64': ../common/atomic.h:130: undefined reference to `__sync_lock_test_and_set_8' ../common/atomic.h:130: undefined reference to `__sync_lock_test_and_set_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedExchange64': ../common/spinlock.h:89: undefined reference to `__sync_lock_test_and_set_8' ../common/spinlock.h:89: undefined reference to `__sync_lock_test_and_set_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedExchangeAdd64': ../common/atomic.h:90: undefined reference to `__sync_fetch_and_add_8' ../common/atomic.h:100: undefined reference to `__sync_fetch_and_add_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedIncrement64': ../common/atomic.h:100: undefined reference to `__sync_add_and_fetch_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedExchangeAdd64': ../common/atomic.h:90: undefined reference to `__sync_fetch_and_add_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedDecrement64': ../common/atomic.h:110: undefined reference to `__sync_sub_and_fetch_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedExchange64': ../common/atomic.h:130: undefined reference to `__sync_lock_test_and_set_8' ../common/obj_all/common.a(mempool.o): In function `InterlockedIncrement64': ../common/atomic.h:100: undefined reference to `__sync_add_and_fetch_8' box running with Linux debian 2.6.18-6-686 #1 SMP Thu May 8 07:34:27 UTC 2008 i686 GNU/Linux thanks

ok thanks.

Hi, May i know how to start using github and download hercules repo under linux box. thanks