astralprojection

Can you check on this @Dastgir. I was using the latest Herc updated today.

check your cardprefix and postfix if that item on the slot is included in the lis. also the item db entry.

too fast.. to furious! Thanks @Dastgir

As I tested on CTF, my original guild member was also included in my BG guild.

1. at line 1770 of eBG_common.c, can you check here @Dastgir 2. Some sql error: : DB error - Field 'score' doesn't have a default value. This happens if i bring flag to my base. 3. @commands not loaded. there might be some issue on setting so it did not proceed to load other settings. (07/29/2018 10:23:11) [ Debug ] : Function: setarray (14 parameters): (07/29/2018 10:23:11) [ Debug ] : Data: variable name='$bg_flavius_ctf' index=0 (07/29/2018 10:23:11) [ Debug ] : Data: number value=3 (07/29/2018 10:23:11) [ Debug ] : Data: number value=5 (07/29/2018 10:23:11) [ Debug ] : Data: number value=5 (07/29/2018 10:23:11) [ Debug ] : Data: number value=2000 (07/29/2018 10:23:11) [ Debug ] : Data: variable name='BF_Badge2' index=0 (07/29/2018 10:23:11) [ Debug ] : Data: number value=15 (07/29/2018 10:23:11) [ Debug ] : Data: number value=10 (07/29/2018 10:23:11) [ Debug ] : Data: number value=10 (07/29/2018 10:23:11) [ Debug ] : Data: number value=0 (07/29/2018 10:23:11) [ Debug ] : Data: number value=0 (07/29/2018 10:23:11) [ Debug ] : Data: number value=0 (07/29/2018 10:23:11) [ Debug ] : Data: number value=0 (07/29/2018 10:23:11) [ Debug ] : Data: number value=1 (07/29/2018 10:23:11) [ Debug ] : Source (NPC): BG_Settings (invisible/not on a map) (07/29/2018 10:23:11) [ Warning ] : script_get_val: cannot access player variable 'BF_Badge2', defaulting to 0

./configure make clean && make sql && make plugins

anyone has able to make the source edit work on the latest git? thanks

I'm testing 2018-04-04bRagexe and set deletion delay to 1sec. But char selection says 6 month 7 day 0 hour 30 min 57 sec. It did turn blue (ready for deletion) after a sec. Is there any fix on that message

yes please

yes, patch to hide buttons seems not working properly with 2018-04+ . anyone has solution for this?

It did good as expected. Thank you @AnnieRuru

snprintf(atcmd_output, CHAT_SIZE_MAX, "Price: %u | Amount: %d | Map: %s (%d,%d) | Shop: %s <how to show the next data in newline?> +%d %d[%d][%d][%d][%d]" ,pl_sd->vending[j].value ,pl_sd->vending[j].amount ,map->list[pl_sd->bl.m].name ,pl_sd->bl.x,pl_sd->bl.y ,pl_sd->message ,pl_sd->status.cart[pl_sd->vending[j].index].refine ,pl_sd->status.cart[pl_sd->vending[j].index].nameid ,pl_sd->status.cart[pl_sd->vending[j].index].card[0] ,pl_sd->status.cart[pl_sd->vending[j].index].card[1] ,pl_sd->status.cart[pl_sd->vending[j].index].card[2] ,pl_sd->status.cart[pl_sd->vending[j].index].card[3]); I tried to put \n but it keeps displaying in same line.

It was too easy to get BADGE without actually spending time and waste lot of pots killing someone at BG. How? - ask a friend playing BG to pm you when session is about to end. They see message "1 min to end the bg" something like that. - join BG and wait until finish. You get reward. HOW TO PREVENT THIS?

I hope this will be possible. I have a zone where I only want to allow specific items . On the current code, what I did is list ALL disabled item and got around 100+ lines on the list. Is there a better way to do? { name: "Test" disabled_skills: { BS_GREED: "PLAYER" CG_HERMODE: "PLAYER" } allowed_items: { // Please add this where only items listed here can be equip or use. Knife_: true Bow_: true Poring_Card: true Lunatic_Card: true } disabled_items: { } mapflags: ( ) },

Thank you @Myriad i keep trying and trying .... OHHH generated pet_db2.conf is at tool folder.

can someone show me how to use that petdbconvert.py? thanks.

@Master@Ragna helped me cleaned up my website and added cool features. I can rate 5/5 on this service based on availability, his expertise, affordability and his dedication to meet best expectation on every costumer. Yes, you can contact him anytime for adjustment even the job is completed already, unlike that other blood sucking web dev, after completion you will not be entertained anymore. Keep up the good work!!!

still this error sir. [Error]: --- failed assertion -------------------------------------------- [Error]: sql.c:479: 'buffer_len == sizeof(int)' in function `Sql_P_BindSqlDataType' [Error]: ./char-server(assert_report+0x83) [0x455f63] [Error]: ./char-server() [0x46813a] [Error]: ./char-server(char_mmo_char_fromsql+0x1e84) [0x41c8b4] [Error]: ./char-server(char_parse_char_select+0x200) [0x420230] [Error]: ./char-server(char_parse_char+0x62a) [0x4226aa] [Error]: ./char-server(do_sockets+0x27e) [0x463b1e] [Error]: ./char-server(main+0x182) [0x413b42] [Error]: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f77c229bc05] [Error]: ./char-server() [0x413c08] [Error]: --- end failed assertion ----------------------------------------

thank you @4144yes i did already but still giving me error. Does SQLDT_UINT or SQLDT_INT matters? /* [Sanasol] Current WoE Statistics */ //read WoE Statistics if (SQL_ERROR == SqlStmt_Prepare(stmt, "SELECT `top_damage`, `damage_done`, `damage_received`, `emperium_damage`," "`guardian_damage`, `barricade_damage`, `gstone_damage`, `emperium_kill`, `guardian_kill`," "`barricade_kill`, `gstone_kill`, `sp_heal_potions`, `hp_heal_potions`, `yellow_gemstones`," "`red_gemstones`, `blue_gemstones`, `poison_bottles`, `acid_demostration`, `acid_demostration_fail`," "`support_skills_used`, `healing_done`, `wrong_support_skills_used`, `wrong_healing_done`, `sp_used`," "`zeny_used`, `spiritb_used`, `ammo_used`, `kill_count`, `death_count`, `score`" " FROM `char_woe_statistics` WHERE `char_id` = ? AND `date`=CURRENT_DATE()") || SQL_ERROR == SQL->StmtBindParam(stmt, 0, SQLDT_INT, &char_id, sizeof char_id) || SQL_ERROR == SQL->StmtExecute(stmt) || SQL_ERROR == SQL->StmtBindColumn(stmt, 0, SQLDT_UINT, &p->woe_statistics.top_damage, sizeof p->woe_statistics.top_damage, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 1, SQLDT_UINT, &p->woe_statistics.damage_done, sizeof p->woe_statistics.damage_done, NULL, NULL)

I'm getting issue after I update my Hercules. I hope some could point me on this piece of code This is the original code + /* [Sanasol] Current WoE Statistics */ + if (SQL_ERROR == SqlStmt_Prepare(stmt, "SELECT `top_damage`, `damage_done`, `damage_received`, `emperium_damage`, `guardian_damage`, `barricade_damage`, `gstone_damage`, `emperium_kill`, `guardian_kill`, `barricade_kill`, `gstone_kill`, `sp_heal_potions`, `hp_heal_potions`, `yellow_gemstones`, `red_gemstones`, `blue_gemstones`, `poison_bottles`, `acid_demostration`, `acid_demostration_fail`, `support_skills_used`, `healing_done`, `wrong_support_skills_used`, `wrong_healing_done`, `sp_used`, `zeny_used`, `spiritb_used`, `ammo_used`, `kill_count`, `death_count`, `score` FROM `char_woe_statistics` WHERE `char_id` = ? and `date`=CURRENT_DATE()") + || SQL_ERROR == SQL->StmtBindParam(stmt, 0, SQLDT_INT, &char_id, 0) + || SQL_ERROR == SQL->StmtExecute(stmt) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 0, SQLDT_UINT, &p->woe_statistics.top_damage, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 1, SQLDT_UINT, &p->woe_statistics.damage_done, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 2, SQLDT_UINT, &p->woe_statistics.damage_received, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 3, SQLDT_UINT, &p->woe_statistics.emperium_damage, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 4, SQLDT_UINT, &p->woe_statistics.guardian_damage, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 5, SQLDT_UINT, &p->woe_statistics.barricade_damage, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 6, SQLDT_UINT, &p->woe_statistics.gstone_damage, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 7, SQLDT_USHORT, &p->woe_statistics.emperium_kill, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 8, SQLDT_USHORT, &p->woe_statistics.guardian_kill, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 9, SQLDT_USHORT, &p->woe_statistics.barricade_kill, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 10, SQLDT_USHORT, &p->woe_statistics.gstone_kill, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 11, SQLDT_UINT, &p->woe_statistics.sp_heal_potions, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 12, SQLDT_UINT, &p->woe_statistics.hp_heal_potions, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 13, SQLDT_UINT, &p->woe_statistics.yellow_gemstones, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 14, SQLDT_UINT, &p->woe_statistics.red_gemstones, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 15, SQLDT_UINT, &p->woe_statistics.blue_gemstones, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 16, SQLDT_UINT, &p->woe_statistics.poison_bottles, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 17, SQLDT_UINT, &p->woe_statistics.acid_demostration, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 18, SQLDT_UINT, &p->woe_statistics.acid_demostration_fail, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 19, SQLDT_UINT, &p->woe_statistics.support_skills_used, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 20, SQLDT_UINT, &p->woe_statistics.healing_done, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 21, SQLDT_UINT, &p->woe_statistics.wrong_support_skills_used, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 22, SQLDT_UINT, &p->woe_statistics.wrong_healing_done, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 23, SQLDT_UINT, &p->woe_statistics.sp_used, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 24, SQLDT_UINT, &p->woe_statistics.zeny_used, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 25, SQLDT_UINT, &p->woe_statistics.spiritb_used, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 26, SQLDT_UINT, &p->woe_statistics.ammo_used, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 27, SQLDT_USHORT, &p->woe_statistics.kill_count, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 28, SQLDT_USHORT, &p->woe_statistics.death_count, 0, NULL, NULL) + || SQL_ERROR == SQL->StmtBindColumn(stmt, 29, SQLDT_USHORT, &p->woe_statistics.score, 0, NULL, NULL) + || SQL_SUCCESS != SQL->StmtNextRow(stmt)) + { + p->woe_statistics.score = 2000; + } + strcat(t_msg, " woestats"); + /* [Sanasol] Current WoE Statistics */ but after this update: https://github.com/HerculesWS/Hercules/commit/872844f1d5368329acbbc46c13dc68f3e5b415d7#diff-e4a2452beec0c729136e0da00eaaa6e8 im getting this error in char-server: [Error]: --- failed assertion -------------------------------------------- [Error]: sql.c:479: 'buffer_len == sizeof(int)' in function `Sql_P_BindSqlDataType' [Error]: ./char-server(assert_report+0x83) [0x455f63] [Error]: ./char-server() [0x46813a] [Error]: ./char-server(char_mmo_char_fromsql+0x1e84) [0x41c8b4] [Error]: ./char-server(char_parse_char_select+0x200) [0x420230] [Error]: ./char-server(char_parse_char+0x62a) [0x4226aa] [Error]: ./char-server(do_sockets+0x27e) [0x463b1e] [Error]: ./char-server(main+0x182) [0x413b42] [Error]: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f77c229bc05] [Error]: ./char-server() [0x413c08] [Error]: --- end failed assertion ---------------------------------------- I tried to revise but still getting same error. What did i missed?: /* [Sanasol] Current WoE Statistics */ //read WoE Statistics if (SQL_ERROR == SqlStmt_Prepare(stmt, "SELECT `top_damage`, `damage_done`, `damage_received`, `emperium_damage`," "`guardian_damage`, `barricade_damage`, `gstone_damage`, `emperium_kill`, `guardian_kill`," "`barricade_kill`, `gstone_kill`, `sp_heal_potions`, `hp_heal_potions`, `yellow_gemstones`," "`red_gemstones`, `blue_gemstones`, `poison_bottles`, `acid_demostration`, `acid_demostration_fail`," "`support_skills_used`, `healing_done`, `wrong_support_skills_used`, `wrong_healing_done`, `sp_used`," "`zeny_used`, `spiritb_used`, `ammo_used`, `kill_count`, `death_count`, `score`" " FROM `char_woe_statistics` WHERE `char_id` = ? AND `date`=CURRENT_DATE()") || SQL_ERROR == SQL->StmtBindParam(stmt, 0, SQLDT_INT, &char_id, sizeof char_id) || SQL_ERROR == SQL->StmtExecute(stmt) || SQL_ERROR == SQL->StmtBindColumn(stmt, 0, SQLDT_UINT, &p->woe_statistics.top_damage, sizeof p->woe_statistics.top_damage, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 1, SQLDT_UINT, &p->woe_statistics.damage_done, sizeof p->woe_statistics.damage_done, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 2, SQLDT_UINT, &p->woe_statistics.damage_received, sizeof p->woe_statistics.damage_received, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 3, SQLDT_UINT, &p->woe_statistics.emperium_damage, sizeof p->woe_statistics.emperium_damage, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 4, SQLDT_UINT, &p->woe_statistics.guardian_damage, sizeof p->woe_statistics.guardian_damage, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 5, SQLDT_UINT, &p->woe_statistics.barricade_damage, sizeof p->woe_statistics.barricade_damage, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 6, SQLDT_UINT, &p->woe_statistics.gstone_damage, sizeof p->woe_statistics.gstone_damage, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 7, SQLDT_INT, &p->woe_statistics.emperium_kill, sizeof p->woe_statistics.emperium_kill, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 8, SQLDT_INT, &p->woe_statistics.guardian_kill, sizeof p->woe_statistics.guardian_kill, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 9, SQLDT_INT, &p->woe_statistics.barricade_kill, sizeof p->woe_statistics.barricade_kill, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 10, SQLDT_INT, &p->woe_statistics.gstone_kill, sizeof p->woe_statistics.gstone_kill, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 11, SQLDT_UINT, &p->woe_statistics.sp_heal_potions, sizeof p->woe_statistics.sp_heal_potions, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 12, SQLDT_UINT, &p->woe_statistics.hp_heal_potions, sizeof p->woe_statistics.hp_heal_potions, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 13, SQLDT_UINT, &p->woe_statistics.yellow_gemstones, sizeof p->woe_statistics.yellow_gemstones, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 14, SQLDT_UINT, &p->woe_statistics.red_gemstones, sizeof p->woe_statistics.red_gemstones, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 15, SQLDT_UINT, &p->woe_statistics.blue_gemstones, sizeof p->woe_statistics.blue_gemstones, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 16, SQLDT_UINT, &p->woe_statistics.poison_bottles, sizeof p->woe_statistics.poison_bottles, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 17, SQLDT_UINT, &p->woe_statistics.acid_demostration, sizeof p->woe_statistics.acid_demostration, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 18, SQLDT_UINT, &p->woe_statistics.acid_demostration_fail, sizeof p->woe_statistics.acid_demostration_fail, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 19, SQLDT_UINT, &p->woe_statistics.support_skills_used, sizeof p->woe_statistics.support_skills_used, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 20, SQLDT_UINT, &p->woe_statistics.healing_done, sizeof p->woe_statistics.healing_done, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 21, SQLDT_UINT, &p->woe_statistics.wrong_support_skills_used, sizeof p->woe_statistics.wrong_support_skills_used, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 22, SQLDT_UINT, &p->woe_statistics.wrong_healing_done, sizeof p->woe_statistics.wrong_healing_done, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 23, SQLDT_UINT, &p->woe_statistics.sp_used, sizeof p->woe_statistics.sp_used, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 24, SQLDT_UINT, &p->woe_statistics.zeny_used, sizeof p->woe_statistics.zeny_used, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 25, SQLDT_UINT, &p->woe_statistics.spiritb_used, sizeof p->woe_statistics.spiritb_used, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 26, SQLDT_UINT, &p->woe_statistics.ammo_used, sizeof p->woe_statistics.ammo_used, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 27, SQLDT_INT, &p->woe_statistics.kill_count, sizeof p->woe_statistics.kill_count, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 28, SQLDT_INT, &p->woe_statistics.death_count, sizeof p->woe_statistics.death_count, NULL, NULL) || SQL_ERROR == SQL->StmtBindColumn(stmt, 29, SQLDT_INT, &p->woe_statistics.score, sizeof p->woe_statistics.score, NULL, NULL) || SQL_SUCCESS != SQL->StmtNextRow(stmt)) { p->woe_statistics.score = 2000; } strcat(t_msg, " woestats"); /* [Sanasol] Current WoE Statistics */

That solves my problem @Myriad thank you for this.

getinventorylist; .@i = 0; while ( .@i < @inventorylist_count ) { /* Filter only items that is not bound */ if (!@inventorylist_bound[.@i]){ .@itemname$ = callfunc( "getitemname2", @inventorylist_id[.@i], @inventorylist_identify[.@i], @inventorylist_refine[.@i], @inventorylist_attribute[.@i], @inventorylist_card1[.@i], @inventorylist_card2[.@i], @inventorylist_card3[.@i], @inventorylist_card4[.@i], @inventorylist_bound[.@i]); .@menu$ = .@menu$ + @itemname2_info$ + .@itemname$ +":"; } .@i++; } .@s = select(.@menu$) -1; /* Now display ItemID of selected inventory */ mes "You have selected "+@inventorylist_id[.@s]; // this did not return correct info because it reads [.@s] index from getinventorylist but not the filtered menu. 1. I list all inventory. 2. I remove all bound items 3. i want to get correct index of items selected from the menu. Any suggestion how to handle this?

it looks like you have many instances of the game running. try ./athena-start restart or restart the machine and run again

yes it did fix @cddebug. Thanks @Beret