I have done everything I can at the moment to fix these SUN Server Files except update the maps which I'm still working on.
Here is a list of things that need to be addressed when rebuilding the SUN Server for EP1:
1) Queries need to be updated in the Server.
[*=2]Database stored procedures cannot be updated because the server queries do not match.
[*=2]Server queries can only read T_Friend (Friendslist), T_GuildMain (Main Guild info w/ Guild Master), T_Warehouse (Account Storage), T_Character, T_User (Accounts), and some other minor tables.
[*=2]The following tables with their stored procedures attached cannot perform correctly:
T_GuildMain (doesn't update T_Character therefore guild doesn't attach to the character),
T_Warehouse (doesn't access the account storage),
T_Character (doesn't transfer character data to T_CharacterDelete and actually delete the entry from T_Character),
T_Friend (doesn't add the character when inputting a name), and
T_User (cannot read any changes to account creation).
2) Update Server to give more detailed errors.
[*=2]This can be achieved through listing the errors in the window as it already does or producing a text file as logs (like what some of the newer files do).
Other suggestions or things to consider:
1) Temple of Blood may need to be added.
[*=2]Not sure yet since I'm still working on the maps.
2) Add in EP2 Characters.
[*=2]If you want to convert the Server Files to EP2.
Also, some of query issues can be taken care of through a website or 3rd party programs such as launchers (creating encrypted accounts, deleting characters, and maybe creating guilds). Please keep in mind this is a list of the problems I have come across, if you find a way to fix some of these problems without receiving any errors, please let me know. Thank you.
