Check this file.

[advenire]

BM, GW and all known quests is working now!!

We made this sql file for 4.4 free server DB.

This is working on guild war, battle match and all known events within 4.4 version.

We have some minor bugs with it and all texts working with Korean windows, so we will convert to English soon.

 

[BentLaser]

Great job .. any progess on the english version?
With quests fixed and bm working ... it might be time rollout the 4.4

 

[KEMBL]

Good job, after i apply that, any problems with db in server log disappear....
There, you can find how to solve some RM server problems
http://forum.ragezone.com/showthread.php?p=365325

 

[KEMBL]

There is mistake, the deal in table names, it must to be up to date, so tables name like 'tblUserLog1_200407' is not valid in that example from your file (and others)

--- example from battlematch(kor).zip ------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblUserLog1_200407]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblUserLog1_200407]
GO
---------------------------------------------------

The way to solve that problem is rename bases or recreate it with valid names and indexes, check this file

To view the content, you need to sign in or register

 

[advenire]

Just build a new db with this ...

Just build new and empty db with name of 'redmoon' than using quarry tool to add script into db ... will build all possible tables whatever you need with this.

You may use backup db ...

There is mistake, the deal in table names, it must to be up to date, so tables name like 'tblUserLog1_200407' is not valid in that example from your file (and others)

--- example from battlematch(kor).zip ------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblUserLog1_200407]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblUserLog1_200407]
GO
---------------------------------------------------

The way to solve that problem is rename bases or recreate it with valid names and indexes, check this file

To view the content, you need to sign in or register

 

[advenire]

BattleMatch Edition DB Script (English Version)

Sorry I'm so lazzy -_- :chair:

 

[Nickyy]

hmm I have gone thru this db schema and its pretty much the same as what I have already, any progress with Quests? I can set all quests complete but I'd rather have all the quests working, including wedding system. There is definatly still some missing elements to the quest system and I'd love to see that completed. I'd even take a korean version I'd be happy to translate or hell even make up any relavent text. lol. While I have to admit having all quests complete is much better than nothing, allowing free map movement, honor, and things like schooldun 4 warp up and running I think players would enjoy some new stuff to do lol. Wedding quest be real cool right now I'm forced to makin a wedding web page to do marriages but that aspect of quests be cool as well.

I have yet to try usin Battlematch , havnt had time to figure out the necessary setup to use it, if someone has done that already and has instructions post em here pls it be a huge time saver , otherwise I'll have to figure out whats what when I find time. I have some of it figured out (common sense lol) but have tested nothing.