Questions to SQL, Namings in FDB and Loot table

Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Questions to SQL, Namings in FDB and Loot table

    Questions to SQL, Namings in FDB and Loot table
    I have the 6.4.2 Files of Lifefire running (with an old raservermonitor and controller). On the first sight everything is working good. I'm on Patchlevel 6.4.2.2753

    Off course thx to @beardilus for his files, otherweise i were still on 6.07 client. So this is awesome! Sorry, if this was'n pronounced correctly.

    But i got a lot of SQL-Errors from datacenter.log
    (5)18:24:28 SQL ERROR Select [count],ability,createtime,durable,exvalue,guid,imageobjectid,message,mode,orgobjid,serial From WebShopBag WHERE Account_ID = 'sheila' and ( WorldID=-1 or WorldID=1 ) and ( PlayerDBID=-1 or PlayerDBID=1 ) and DestroyTime = 0(5)18:24:28 SQLERR [RETCODE]=-1 [SqlState]=S0022 [NativeError]=207 [BkSqlCmd]COMMIT TRANSACTION [SQLCMD]Select [count],ability,createtime,durable,exvalue,guid,imageobjectid,message,mode,orgobjid,serial From WebShopBag WHERE Account_ID = 'sheila' and ( WorldID=-1 or WorldID=1 ) and ( PlayerDBID=-1 or PlayerDBID=1 ) and DestroyTime = 0 [ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Account_ID'. [SuccessCmd]0(5)18:24:28 SQLERR [RETCODE]=-1 [SqlState]=S1010 [NativeError]=0 [ErrorCode][Microsoft][ODBC Driver Manager] Fehler in der Funktionsreihenfolge(5)18:24:28 SQL ERROR SELECT [GUID] FROM [LoginBonusStamp] WHERE [Account] = 0x736865696c61 AND [PlayerDBID] = 1 AND (FLOOR(CAST([Date] AS float)) = 43690)(5)18:24:28 SQLERR [RETCODE]=-1 [SqlState]=S0002 [NativeError]=208
    Also from DBErr_Datacenter.log

    (5)18:24:00 DB Write Error SELECT Day, ZoneGroupID FROM WeekInstances(5)18:24:05 DB Write Error SELECT GroupID, ProductID, ProductCount, SourceID1, SourceID2, SourceID3, SourceID4, SourceID5, SourceCount1,SourceCount2, SourceCount3, SourceCount4, SourceCount5 FROM Table_ItemCombine(5)18:24:13 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)(5)18:24:22 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)(5)18:24:28 DB Write Error Select [count],ability,createtime,durable,exvalue,guid,imageobjectid,message,mode,orgobjid,serial From WebShopBag WHERE Account_ID = 'sheila' and ( WorldID=-1 or WorldID=1 ) and ( PlayerDBID=-1 or PlayerDBID=1 ) and DestroyTime = 0(5)18:24:33 DB Write Error SELECT [GUID] FROM [LoginBonusStamp] WHERE [Account] = 0x736865696c61 AND [PlayerDBID] = 1 AND (FLOOR(CAST([Date] AS float)) = 43690)(5)18:24:38 DB Write Error INSERT INTO [LoginBonusStamp] ([Account], [PlayerDBID], [Date]) VALUES(0x736865696c61, 1, 43690)(5)18:24:43 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)(5)18:24:48 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)(5)18:24:53 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)
    I'm not able to programm in SQL, but maybe someone who runs 6.4 can provide a bit of the SQL Data as download ( I guess there are "simply" some tables missing, so it isn't possible to write?)
    Well, i did not do extensive playing the thing, but in general it basically is working. I guess some things are missing to call it a "real" 6.4.2 server.


    2nd Question:

    Is it possible to give items without a name a name ? In DB Editor its under system, but it's not possible to write something in it.


    3rd:

    My world bosses do not drop proof of legends. I killed Taren and Kolanda (with gm kill and with a megapet). They have 190 guild runes, but not a single proof of legends. The loot table looks ok though. Only thing i wonder, treasure item 726129 pronounces
    LuaCheckscript "Lua_Hao_WorldBoss_EasyMode(1)".
    Is this script maybe missing ?
    I'm not 100% sure, but i think that was working with 6.0.7 release.
    Last edited by Mageoski; 18-08-19 at 05:16 PM.


  2. #2
    Hardcore Member Lifefire is offline
    MemberRank
    May 2018 Join Date
    USALocation
    142Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    You are correct that you are missing database tables, yours are still 6.0.7 which is why you are getting errors, you will have to add all of the missing tables to get it 100% working. I do not know the tables formats from memory and do not have time to make backups until late this weekend so if someone can provide them for you in the meantime that would be great... alternatively you can look through the datacenter source code and search for parts of each select query to find the tables it needs and above those in the code is each type for the table... like INT and REAL and String

  3. #3
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    I have the source code from beardilus, i will take a look into it. Just saw a funny thing in it:

    PrintToFile( LV5 , "ODBC ERROR", "CRITICAL ODBC DRIVER ERROR! FUCK ME ALREADY! FUCK YOU TOO!" ); printf("\n\n\n\n\n\n\n\n\n\n\n\n\n\nCRITICAL ODBC DRIVER ERROR! FUCK ME ALREADY! FUCK YOU TOO!\n\n\n\n\n\n\n\n\n\n\n\n\n\n");

    Runewaker guys, lol...

    But other than that, i guess source code is like chinese for me ^^

    Edith:

    I GUESS i have found some SQL Scripts, inserted them and now some errors are gone:

    WebshopBag Error seems fixed, also the LoginBonusStamp from loginbonusbase table(?).

    I still get constantly this as error in
    DBErr_DataCenter.log

    (5)10:56:54 DB Write Error SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1)


    and still getting this in datacenter.log

    (5)11:01:11 SQLERR [RETCODE]=-1 [SqlState]=S0002 [NativeError]=208 [BkSqlCmd]SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETD [SQLCMD]SELECT ZoneID , CAST( EndTime as float) , BuffID , BuffLv FROM BuffSchedule Where (StartTime < GETDATE()) and (EndTime > GETDATE()) and ( worldID=-1 or worldID = 1) [ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'BuffSchedule'. [SuccessCmd]0


    Last edited by Mageoski; 16-08-19 at 11:02 AM.

  4. #4
    Hardcore Member Lifefire is offline
    MemberRank
    May 2018 Join Date
    USALocation
    142Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    You need to create the table "BuffSchedule" in your database

  5. #5
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Something like that ? (Dont laught ^^)

    Code:
    CREATE TABLE [dbo].[BuffSchedule] (
            [GUID]            [int]     IDENTITY(1, 1) NOT NULL,
        [WorldID]               [int]    NOT NULL,
            [StartTime] [smalldatetime]      NOT NULL,
            [EndTime]   [smalldatetime]      NOT NULL,
        [ZoneID]        [int]     NOT NULL,
        [Cast]                 [int]     NOT NULL,
        [BuffID]        [int]     NOT NULL,
        [BuffLv]            [int]     NOT NULL
    ) ON [PRIMARY]
    GO
    And where can you exactly see in which table it has to be ?
    Last edited by Mageoski; 16-08-19 at 06:43 PM.

  6. #6
    Hardcore Member Lifefire is offline
    MemberRank
    May 2018 Join Date
    USALocation
    142Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    I believe it goes in your import database, try it there... if you still get the errors then delete it and put it in the world database

  7. #7
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    I have an unexpected question, maybe someone has some help to it.
    yesterday i quested in weeeping coast to test to get into heart of ocean. I then realized that i'm NOT able to set the difficulty of it. Its always easy (i have both instances in Monitor running.
    I then tested other instances...and well...my client is only on easy. i can't change it.
    Someone has a hint to it ?

    Edith: It's working now, don't know why. ;P
    More Edith: Nevermind. Its just not my day. There is no Hardmode for Hall of Survivors.
    Last edited by Mageoski; 19-08-19 at 07:59 PM.

  8. #8
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Ok, got the SQL thing with weekinstance/Buffschedule-Error fixed now (Its in ImportDB, so Lifefire was right. Thx to Reaperman for it.

    Anyone knows what this Buffschedule table does ?

    At least i don't have an DBErr_Datacenter.log anymore so far. :D

  9. #9
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Someone can tell me where this SQL Error comes from or how to fix it ?
    Its coming right up starting Common -> Account. All others are still off.

    It seems its not disturbing running the server, but i wonder why its there. I checked my old logs from last year and it seems it wasn't always there.

    (5)20:22:05 SQL ERROR COMMIT TRANSACTION(5)20:22:05 SQLERR [RETCODE]=-1 [SqlState]=25000 [NativeError]=3902 [BkSqlCmd]UPDATE PlayerAccount SET IsMd5Password = 1 , Password= CAST( 0x383144433942444235465874512303033364442443833313345443035 [SQLCMD]COMMIT TRANSACTION [ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. [SuccessCmd]0(5)20:22:06 SQLERR [SQLBaseClass] INFO: Connection re-established.(5)20:22:06 SQL ERROR COMMIT TRANSACTION(5)20:22:06 SQLERR [RETCODE]=-1 [SqlState]=25000 [NativeError]=3902 [BkSqlCmd]UPDATE PlayerAccount SET IsMd5Password = 1 , Password= CAST( 0x383144433942444235465874512303033364442443833313345443035 [SQLCMD]COMMIT TRANSACTION [ErrorCode][Microsoft][ODBC SQL Server Driver][SQL Server]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. [SuccessCmd]0(5)20:22:06 ##Start Server## Time 20:22:06

  10. #10
    Hardcore Member CDWriter is offline
    MemberRank
    Aug 2004 Join Date
    iowa/usaLocation
    144Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Our you could have looked for the fixes for them here

    http://forum.ragezone.com/f884/missi...m-6-a-1171779/

    will fix all your issues up to 6.4.2

  11. #11
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Yes i know them, and i put them all in (the ones i dont had), but its still there. It may be there because i'm not running 6.4.2 files but 6.5.3 (fdb/wdb).

  12. #12
    Hardcore Member CDWriter is offline
    MemberRank
    Aug 2004 Join Date
    iowa/usaLocation
    144Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Cant help you with Nothing i dont have the sql files and table i posted will fix it all the way to 6.4.2 ....Nice on the 6.5.3.....If it came with new Sql backups the 100% congrats ....

  13. #13
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Pushing my own thread:

    Is there meanwhile a tool to change names in FDB in sys section like this ?

    Click image for larger version. 

Name:	Rom DB Editor.jpg 
Views:	19 
Size:	81.9 KB 
ID:	168315

    I tried the following:

    Open data.fdb -> extract string_de.db Change the value from the stat (Its 510713 Demon of Rites). Now in my understanding i have to repack data.fdb with changed string_de.db. But thats not working. Its not much russian language here, but i'm not sure what the tool is saying to me. I have tried almost every menu option. At least hes not exchanging my modified string_de.db.


    Click image for larger version. 

Name:	Rom DB Repack.jpg 
Views:	21 
Size:	177.6 KB 
ID:	168316

    Also the question if this is working this way anyway.

    The Item "Demon of Rites" is in my database, but its called like in the first screenshot.

    Someone has a similar tool in englisch ? ^^

  14. #14
    Hardcore Member Beerpyrs is online now
    MemberRank
    Jul 2015 Join Date
    120Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Just run everything in a data folder, no need to repack.

    Anyway dont have that tool in english, but you wanna delete the old string_de.db then click the first left tab and then one of the buttons will let you add the new .db to the fdb, then exporting should have it saved.

    But yea unless you're going to use runewaker patch tools, no need to repack the fdb.
    Last edited by Beerpyrs; 04-10-20 at 09:33 PM.

  15. #15
    Account Upgraded | Title Enabled! Mageoski is offline
    True MemberRank
    Jul 2015 Join Date
    205Posts

    Re: Questions to SQL, Namings in FDB and Loot table

    Thx for the tipp, will play with it. If i expand the string_de and put in C:\Runewaker\Resource\data the master crashes. Same if i rip it out of the data.fdb.

    Surprisingly i have already a string_de in that directory and it is working. If i alter the file with the stat the master crashes.

    Maybe i have to get some patches back because i run 6.5.x files.

    Will test that the next days.

    Edith, first test:

    If i rename the data directory on my server in resources the master starts. If i extract the string_de.db of the used data.fdb and put in a new data directory as single file the master crashes. Strange behaviour.
    Last edited by Mageoski; 05-10-20 at 09:39 AM.



Page 1 of 2 12 LastLast

Advertisement