astralprojection

July 29, 2018

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

July 29, 2018

too fast.. to furious! Thanks @Dastgir

July 29, 2018

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

July 29, 2018

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

July 9, 2018

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

July 3, 2018

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

June 6, 2018

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

June 3, 2018

On 3/30/2018 at 8:29 AM, BrOgBr said:

Hello @4144 no news about the patch: Remove Hourly Announce at client 2018.

yes please

May 21, 2018

On ‎16‎/‎05‎/‎2018 at 7:05 AM, Virtue said:

I'm still having this issues on 2018-04-04b. buttons still not disappearing even if it should be hidden.

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

May 20, 2018

16 hours ago, AnnieRuru said:

I hope you are not asking dump question


safesnprintf(atcmd_output, CHAT_SIZE_MAX, "Price: %u | Amount: %d | Map: %s (%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);
clif->message(fd, atcmd_output);
safesnprintf(atcmd_output, CHAT_SIZE_MAX, "Shop: %s +%d %d[%d][%d][%d][%d]",
	    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]);
clif->message(fd, atcmd_output);

It did good as expected. Thank you @AnnieRuru

May 20, 2018

				    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.

May 2, 2018

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?

April 24, 2018

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: (
   )
},

April 23, 2018

On 4/21/2018 at 10:42 PM, Myriad said:

Locate to tools folder where it's located and run
./petdbconverter.py pre-re ../ ../db/pet_db2.txt > pet_db2.conf

should generate conf file in the tools folder
change pre-re to re if renewal

Quote

should generate conf file in the tools folder

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

April 21, 2018

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

master@ragna · March 29, 2018

@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!!!

March 15, 2018

34 minutes ago, 4144 said:

probably you getting other error?

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 ----------------------------------------

March 15, 2018

9 hours ago, 4144 said:
In lines like
| SQL_ERROR == SQL->StmtBindColumn(stmt, 0, SQLDT_UINT, &p->woe_statistics.top_damage, 0, NULL, NULL)
you should replace 0 to field size what you using

for example line it should be like this:
| SQL_ERROR == SQL->StmtBindColumn(stmt, 0, SQLDT_UINT, &p->woe_statistics.top_damage, sizeof p->woe_statistics.top_damage, NULL, NULL)
do same for other fields

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)

March 14, 2018

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 */

March 13, 2018

That solves my problem @Myriad thank you for this.

March 12, 2018

	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?

February 23, 2018

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

February 15, 2018

3 hours ago, Beret said:

@4144 This has to do with the cooldown, was reported the hercules in 2014, the ind came to add the command @cddebug not to need restart the server. But the real problem has never been fixed.

Link Bug Track

yes it did fix @cddebug. Thanks @Beret

February 15, 2018

1 hour ago, 4144 said:

@astralprojection before this error, you probably should see other and real errors about timers. can you show them?

this one:
(02/09/2018 07:52:33) [ Error ] : timer_do_delete error : function mismatch [2683]0x51ac10(mob_delayspawn) != 0x5caae0(skill_blockpc_end)

February 15, 2018

i recently experince this problem at the current git. the only way i deal with it is to restart the server. that is very bad solution.

Sign In

Profiles

Forums

Downloads

Staff Applications

Calendar

Posts posted by astralprojection

Important Information