Issue information

Issue ID
#6447
Status
Working as Intended
Severity
None
Started
Hercules Elf Bot
Aug 10, 2012 0:24
Last Post
Hercules Elf Bot
Aug 10, 2012 14:53
Confirmation
Yes (0)
No (2)

Hercules Elf Bot - Aug 10, 2012 0:24

Originally posted by [b]XiiiX[/b]
[b]RESUME:[/b] The table guild_castles is missing two entries, that, without them, make the char-server crash.

[b]EXPLANATION:[/b] The map-server would ask the castles to the char-server, and it would query for two more entries ("visibleG8" and "visibleG9"), therefore, it wouldn't find them, would crash, and also, wouldn't pass the list of the castles to the map-server.

[b]RESOLUTION:[/b] Insert at line 261 of Main.sql the entries:
[CODE]
`visibleG8` int(11) unsigned NOT NULL default '0',
`visibleG9` int(11) unsigned NOT NULL default '0',
[/CODE]

[b]CREDITS:[/b] The problem was found by me at the emulator Cronus-Emulator, a brazillian-portuguese-based emulator.

Hercules Elf Bot - Aug 10, 2012 0:27

Originally posted by [b]Raizen[/b]
Actually, this is a bug in guild.c and this correction alleviates the problem.

Hercules Elf Bot - Aug 10, 2012 1:40

Originally posted by [b]Aleos[/b]
It's working as intended.
common/mmo.h
[code]#define MAX_GUARDIANS 8 //Local max per castle. [Skotlex][/code]
char/int_guild.c
[code] StringBuf_Printf(&buf, "REPLACE INTO `%s` SET `castle_id`='%d', `guild_id`='%d', `economy`='%d', `defense`='%d', "
"`triggerE`='%d', `triggerD`='%d', `nextTime`='%d', `payTime`='%d', `createTime`='%d', `visibleC`='%d'",
guild_castle_db, gc->castle_id, gc->guild_id, gc->economy, gc->defense,
gc->triggerE, gc->triggerD, gc->nextTime, gc->payTime, gc->createTime, gc->visibleC);
for (i = 0; i < MAX_GUARDIANS; ++i)
StringBuf_Printf(&buf, ", `visibleG%d`='%d'", i, gc->guardian[i].visible);[/code]

Did you increase your MAX_GUARDIANS value? More columns will be needed if you increase the maximum guardians that are per castle.