Forum :: Announcements :: Seose2EOSERV database converter and EOSERV 0.5.3

Warning: Distribution of this release of EOSERV is restricted under the requirements of the GPLv2. The source code used to build it is available from http://files.eoserv.net/source/

With the impending doom on all Seose servers, I've created a tool to convert a Seose database to EOSERV SQL commands. Any SQL database tool capable of setting up EOSERV (aka, executing install.sql) should be able to import these files.

• Download Seose2EOSERV from the Download page
• Extract the zip file and run it from the Seose directory (where Seose.exe should be)
• Hopefully, the tool will generate two files: accounts.sql and characters.sql
• Use your favourite SQL tool to import them in to a freshly created EOSERV database (empty of any accounts or characters)

Note: You will need to use EOSERV 0.5.3 (or revision 240+) and enable the SeoseCompat option in config.ini otherwise the generated passwords won't work.

To accommodate anyone switching from Seose, I've released EOSERV 0.5.3 which has a few changes over 0.5.2 other than the Seose database conversion support. Make sure you check upgrade/0.5.2_to_0.5.3.sql if you're updating, and beware that EOSERV has been permanently unstable since after 0.5.2's release.

IMPORTANT UPDATE: The original Seose2EOSERV posted had a bug where the map ID wasn't transferred properly. A fixed version has been uploaded in it's place and is available on the download page. (10th Jan 2012)

Update #2: A much more stable build of 0.5.3 is available on the download page (marked 0.5.3b). (12th Jan 2012)

Here's a list of changes from 0.5.2 to 0.5.3 (I would have called it 0.6.0 if I knew how long this list was going to be)

---

New features:

• Spells
• Skill masters
• Jukeboxes
• Inkeepers / spawn points
• Boss/child
• Guilds
• Beer!
• Barber
• Stronger enforcement of weight limits
• Cannot waste potions at max HP
• Reports are logged to a specified town board
  
  

Bug fixes:

• Can't deposit 0x items in chests and lockers
• Fixed hit rate formula and direction calculations
• Added some location sensitive packets to the action queue
• Flipped names in trades
• Town board posting checks
• Check keys for doors and chests
• Stop walking through boards
• Accuracy and evasion effectiveness doubled
• Prevent negative heal with potion use
• Text width capping
• Add missing admin/party icons to paperdoll
• No crash possible when killing temporary vendor NPCs while in use
• Reward scroll level up animation
• Free guild joining
• Lore item checks
• Moving while trading
• Friend list online check
• Attacking while standing still limited by server
• Characters ordered by EXP
• Whispers rejected on server
• More stable SLN support
• Can shoot people standing in walls
  
  

Technical updates:

• Number formatting specifiers in config files (e.g. 100%, 2.5x, 1m30s)
• Connection rate throttling
• Timed global save
• Class formula file (completely unused as there's no wise man)
• Explanations on the top of data ini files
• Half of HDIDs that were stored incorrectly now stored properly
• Invalid HDIDs rejected from server
• NPCs removed from view when out of ranged
• Delays between expensive actions / packet rate limiter
• MaxConnectionsPerPC option enforced
• Ability to disable MaxConnectionsPerIP/PC
• Fixed size circular packet buffers (less memory usage per client)
• Pre-allocated packet buffers (less reallocations to build a packet)
• Recovery speed config options
• IgnoreHDID config option
• SeoseCompat config option for Seose2EOSERV tool
  
  

Admin commands:

• $uptime -- Show server uptime
• $repub -- Reload "pub" files (npc/item/class/spell)
• $rehash -- Reloads config files (config/admin/arena/shop/drop etc.)
• $board # -- Opens the town board with the given ID
• $hide -- Hide/show your character
• $inventory Sausage -- Show a characters inventory
• $learn # -- Learn the skill with the given ID
  

/li

very nice! be prepared for idiots who cant manage to do this

---
Qbot/null

Good work like always.

Such an amazing program. Nice release Sausage!!

---
Why am I still here...

hey sausage i need help, when im importing the characters file it says "Error importing data at line 36460481". but account file worked successfully.

Im using SQLite, and not all characters are loaded

-------------------------------- EDIT ---------------------------------

i tried to run eoserv without it and it said missing file Config.local.ini   and Admin.local.ini

---
-.-

Hollow posted: (8th Dec 2011, 01:20 pm)

Good work like always.

---
...

oxyda posted: (10th Dec 2011, 02:33 pm)

hey sausage i need help, when im importing the characters file it says "Error importing data at line 36460481". but account file worked successfully.

Im using SQLite, and not all characters are loaded

-------------------------------- EDIT ---------------------------------

i tried to run eoserv without it and it said missing file Config.local.ini   and Admin.local.ini

I don't know about the rest but the *local.ini files are only information saying that they can not be found and will not stop it running or anything.

---
I am an alien and not crazy!

well i download eosource, and i used the Seose2EOSERV database converter to create a database with my seose accounts and characsters and past it to the eosource folder and everything work successfully but when i try to log in on my char, it wont let me log in , says pass is wrong, tried creating the account, it was already created :/

---
-.-

oxyda posted: (10th Dec 2011, 04:12 pm)

well i download eosource, and i used the Seose2EOSERV database converter to create a database with my seose accounts and characsters and past it to the eosource folder and everything work successfully but when i try to log in on my char, it wont let me log in , says pass is wrong, tried creatingthe account, it was already created :/

EOsource uses not exactly the same database as the normal EOserv, also i suggest just using the Sqlite database that's provided with EOsource. since it's easy and i don't think you got that many/important accounts.

---
opensource isometric game engine ~ www.avac-engine.blogspot.com

yea those accounts are important, and when i try to use eoserv 5.3 it doesn't open, it always show ''need config.local.ini'' and admin.local.ini  , this things aren't in the file, might be on hide file mode but i don't know what to do from than

---
-.-

That's because the seose uses a different password encryption method which has not yet been added in EOsource but will be added soon.

alright but how am i suppose to fix EOSERV 0.5.3 it says on the exe when i open , something about a file name [config.local.ini] and [admin.local.ini]..

---
-.-

oxyda posted: (11th Dec 2011, 03:28 pm)

alright but how am i suppose to fix EOSERV 0.5.3 it says on the exe when i open , something about a file name [config.local.ini] and [admin.local.ini]..

Those are two completely harmless warnings which are just informing you there's no local configuration file. You can "fix" it by creating an empty file, or removing the "INCLUDE = config.local.ini" line from the bottom of config.ini

The proper thing to do, though, is read the first 3 lines of config.ini:

# It is recommended not to edit this file directly, and instead copy
# the options you want to change to a file called config.local.ini and
# keep config.ini synchronized with the latest version of EOSERV

ok thanks got it :D

---
-.-

very nice! be prepared for idiots who cant manage to do this

-- Link Removed -- (Desmond Taylor)