EOSERV Forum > Announcements > Seose2EOSERV database converter and EOSERV 0.5.3
Topic is locked.
Page: << 1 2 >>
Seose2EOSERV database converter and EOSERV 0.5.3
Author Message
Post #118418 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
12 years, 18 weeks ago
Post #118419 Re: Seose2EOSERV database converter and EOSERV 0.5.3


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

---
Qbot/null
12 years, 18 weeks ago
Post #118420 Re: Seose2EOSERV database converter and EOSERV 0.5.3

Good work like always.

12 years, 18 weeks ago
Post #118440 Re: Seose2EOSERV database converter and EOSERV 0.5.3

Such an amazing program. Nice release Sausage!!

---
Why am I still here...
12 years, 18 weeks ago
Post #118555 Re: Seose2EOSERV database converter and EOSERV 0.5.3

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

---
-.-
12 years, 17 weeks ago
Post #118558 Re: Seose2EOSERV database converter and EOSERV 0.5.3
Hollow posted: (8th Dec 2011, 01:20 pm)

Good work like always.



---
...
12 years, 17 weeks ago
Post #118562 Re: Seose2EOSERV database converter and EOSERV 0.5.3
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!
12 years, 17 weeks ago
Post #118564 Re: Seose2EOSERV database converter and EOSERV 0.5.3

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 :/

---
-.-
12 years, 17 weeks ago
Post #118570 Re: Seose2EOSERV database converter and EOSERV 0.5.3
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
12 years, 17 weeks ago
Post #118598 Re: Seose2EOSERV database converter and EOSERV 0.5.3

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

---
-.-
12 years, 17 weeks ago
Post #118624 Re: Seose2EOSERV database converter and EOSERV 0.5.3

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

12 years, 17 weeks ago
Post #118639 Re: Seose2EOSERV database converter and EOSERV 0.5.3

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]..

---
-.-
12 years, 17 weeks ago
Post #118707 Re: Seose2EOSERV database converter and EOSERV 0.5.3
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

12 years, 17 weeks ago
Post #118718 Re: Seose2EOSERV database converter and EOSERV 0.5.3

ok thanks got it :D

---
-.-
12 years, 17 weeks ago
Post #119311 Re: Seose2EOSERV database converter and EOSERV 0.5.3

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

-- Link Removed -- (Desmond Taylor)
12 years, 16 weeks ago
Page: << 1 2 >>
Topic is locked.
EOSERV Forum > Announcements > Seose2EOSERV database converter and EOSERV 0.5.3