Check this file.

Results 1 to 7 of 7
  1. #1
    Proficient Member advenire is offline
    MemberRank
    Jan 2004 Join Date
    Seoul, Korea.Location
    180Posts

    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.
    Attached Files Attached Files
    Last edited by advenire; 06-09-04 at 11:14 PM.


  2. #2
    Valued Member BentLaser is offline
    MemberRank
    May 2004 Join Date
    120Posts
    Great job .. any progess on the english version?
    With quests fixed and bm working ... it might be time rollout the 4.4

  3. #3
    Member KEMBL is offline
    MemberRank
    May 2004 Join Date
    RussiaLocation
    65Posts
    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
    Last edited by KEMBL; 23-09-04 at 04:10 PM.

  4. #4
    Member KEMBL is offline
    MemberRank
    May 2004 Join Date
    RussiaLocation
    65Posts
    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
    ftp://wu.aaanet.ru/redmoon/procedure...ate_tables.txt
    Last edited by KEMBL; 24-09-04 at 02:04 PM.

  5. #5
    Proficient Member advenire is offline
    MemberRank
    Jan 2004 Join Date
    Seoul, Korea.Location
    180Posts

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

    Quote Originally Posted by 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
    ftp://wu.aaanet.ru/redmoon/procedure...ate_tables.txt
    Attached Files Attached Files
    Last edited by advenire; 08-11-04 at 04:02 AM.

  6. #6
    Proficient Member advenire is offline
    MemberRank
    Jan 2004 Join Date
    Seoul, Korea.Location
    180Posts

    BattleMatch Edition DB Script (English Version)

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

  7. #7
    Member Nickyy is offline
    MemberRank
    Jan 2005 Join Date
    62Posts
    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.



Advertisement