en_dev

below OnAgitEnd resets the value where he can get the prize again, if you remove all the sets inside that OnAgitEnd, it will only allow the guild master to get prize once only. if you want it on certain date, you can modify and add the example below, prontera,141,176,5 script Agit Reward#Agit1-1::Reward Giver 950,{ OnClock2100: set $castle_claimed[0], 0; // everytime woe ends the variable resets set $castle_claimed[1], 0; set $castle_claimed[2], 0; set $castle_claimed[3], 0; set $castle_claimed[4], 0; set $castle_claimed[5], 0; set $castle_claimed[6], 0; set $castle_claimed[7], 0; set $castle_claimed[8], 0; set $castle_claimed[9], 0; set $castle_claimed[10], 0; set $castle_claimed[11], 0; set $castle_claimed[12], 0; set $castle_claimed[13], 0; set $castle_claimed[14], 0; set $castle_claimed[15], 0; set $castle_claimed[16], 0; set $castle_claimed[17], 0; set $castle_claimed[18], 0; set $castle_claimed[19], 0; set $castle_claimed[20], 0; set $castle_claimed[21], 0; set $castle_claimed[22], 0; set $castle_claimed[23], 0; set $castle_claimed[24], 0; set $castle_claimed[25], 0; set $castle_claimed[26], 0; set $castle_claimed[27], 0; set $castle_claimed[28], 0; set $castle_claimed[29], 0;

hmm, set a value for what ? can you explain more what you're trying to accomplish ?

have you forwarded your server ports ? 6900, 6121 and 5121.

oh ahaha, np. It was just a guess, lol ;P

try this, query_sql "UPDATE `char` SET `name` = '"+.@newname$+"' WHERE `char_id` = '"+getcharid(0)+"'";

Can I see the full script ?, I just wanna see where ##owner is come from or being set.

and also, make sure your client date is set in your mmo.h, not sure if that will fix that, but at least double check that date issued in mmo.h, cuz im pretty sure ur client hexed right cuz you can login etc, but after creating the character theres goes the error, cuz its output is null, so it means no character id has been passed thats why it doesnt exist, prolly mmo.h is not set. not sure. but please double check.

hmm, I'm pretty sure you have your grf set up right and client hexed ?

for database error, check if those table even exist in your database. its looking for log.login, check your database log if you have, if not, import one under your server files, sql-files->logs , then look for you inter_athena.conf ( not sure the name of the file ) check if the settings for your logs point to your database logs. and yes before we used to have level column under login, they are now using group_id, set the group_id 99 for admin, or check the conf->groups.conf file, groups are listed there, you can assign or just use the default.

did it let you create a character at your first login before those error occurs ?

Its kinda a lot of work, modification of guild is inside guild.c under src->map folder. just to give you idea, In a sense, It could be done inside int guild_invite() , where loop each of your current member, get their sd->status.class_ , create an array of classes, then loop through each of that classes along with the sd->status.class_ of your guild, if they exist, return a message that you cant invite same class or class already exist, else continue inviting.

Aww im late, sorry was sleeping. good to hear that its been solved.

Okay, follow this steps, you need to turnoff your hidden folder options by going to control panel, on right side, view by -> small icons, then click folder options -> tab view -> Tick Show hidden files, folders, and drivers under Hidden files and folders, apply. Delete C:\Program Files\MySQL Delete C:\Program Files (x86)\MySQL Delete C:\ProgramData\MySQL Delete from any Users' AppData folders. Example: C:\Users\urNamehere\AppData\Roaming\MySQL Reinstall MySQL

It looks like your old config for mysql still on your computer, what windows are you using ?