Jump to content

[WIP] More Readable DB


Recommended Posts

  • Group:  Members
  • Topic Count:  4
  • Topics Per Day:  0.00
  • Content Count:  11
  • Reputation:   1
  • Joined:  03/22/15
  • Last Seen:  

Hello everyone,


I went through most of the SQL files and noticed how atrocious the syntax was and decided to clean it up a bit. Shouldn't have any affect on the actual execution (especially since MySQL supports this new format).

As most of up know, the current syntax is this for all the sql files:

REPLACE INTO `mob_db_re` VALUES (1018,'CREAMY','Creamy','Creamy',23,378,1,144,162,1,61,62,28,20,16,1,1,0,1,20,10,12,0,4,24,0x181,150,1136,720,840,0,0,0,0,0,0,0,924,9000,2322,10,518,150,602,100,2207,2,712,500,692,100,0,0,0,0,4040,1);

Ill be changing the mob,item and mob skill db's to this:

REPLACE INTO `mob_db_re`
VALUES (a,b,c,d,e,f,g,h,i,j,k),

It should work unless there is something I don't know about. Also Ill be adding a lot of whitespace so they all line up nicely in rows and columns in case anyone wants to do some serious editing. Its tedious but it should help everyone out in the long run.


Mob_db_re: 3% complete <- This is a total lie (its more like 1% lol)

Mob_db2_re: 0%

Item_db_re: 0%

Item_db2_re: 0%

mob_skill_db_re: 0%


Edited by substep
  • Upvote 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...