how to read guild info from sql initially

[RyanB]

anyway to do it?

[Brian]

What guild info do you want to read from SQL?

(guilds? guild castles? guild members?)

What do you want to do with this information?

(read it into a script? and then what?)

[RyanB]

Actually i need info of guilds, guild castles, guild members, guild alliances.

I'm trying to make a script/atcommand that can check guilds' info.

And check alliance relations by script, using sql is not accurate coz do not update instantly.

Edited January 23, 2013 by RyanB

[Brian]

I'm trying to make a script/atcommand that can check guilds' info.

And check alliance relations by script, using sql is not accurate coz do not update instantly.

But once this NPC reads the guild info from SQL (when the server starts), how will the NPC be updated when guild info changes?

Maybe you could just reduce autosave_time so guild info is saved to SQL more frequently (it's already set to 60 seconds). trunk/conf/char_athena.conf

// How often should the server save all files? (In seconds)
// Note: Applies to all data files on TXT servers.
// On SQL servers, it applies to guilds (character save interval is defined on the map config)
autosave_time: 60

[RyanB]

int mapif_parse_GuildInfo(int fd,int guild_id)

{

struct guild * g = inter_guild_fromsql(guild_id); //We use this because on start-up the info of castle-owned guilds is requied. [skotlex]

if(g)

{

if (!guild_calcinfo(g)) {

int i;

mapif_guild_info(fd,g);

for(i=0;i<MAX_GUILDALLIANCE;i++) {

struct guild * a = inter_guild_fromsql(g->alliance.guild_id);

if(a) mapif_guild_info(-1,a);

}

}

}

else

mapif_guild_noinfo(fd,guild_id); // Failed to load info

return 0;

}

I did this but i dunno would it crash anything or not