[English]Discussion

    Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

    • shay2243;33698 schrieb:

      How to change the prices of cs shop?

      I don`t know but I see that you runed server. Could you give me a little guide how to correctly set up OCBC and .ini files?
      I mean I want to know what should I write in:
      [list]DSN_NAME_CHARACTER
      DB_ADMIN_ID_CHARACTER

      DSN_NAME_LOG
      DB_ADMIN_ID_LOG

      DSN_NAME_LOGIN
      DB_ADMIN_ID_LOGIN[/list]


      And which users for what DataBase, for example:
      [list]login for Acccount_DBF[/list]

    • You need:
      An OBDC for account Database, Character Database and Log01 Database.
      You name the connections for account login, for Character character01 and for Log01 log01.

      DSN_NAME_CHARACTER "character01"
      DB_ADMIN_ID_CHARACTER "sa"

      DSN_NAME_LOG "log01"
      DB_ADMIN_ID_LOG "sa"

      DSN_NAME_LOGIN "login"
      DB_ADMIN_ID_LOGIN "sa"

      This work for me. But don´t forgett to write the password for your sa account in the password lines!

    • xpr0keksx;33731 schrieb:

      You need:
      An OBDC for account Database, Character Database and Log01 Database.
      You name the connections for account login, for Character character01 and for Log01 log01.

      DSN_NAME_CHARACTER "character01"
      DB_ADMIN_ID_CHARACTER "sa"

      DSN_NAME_LOG "log01"
      DB_ADMIN_ID_LOG "sa"

      DSN_NAME_LOGIN "login"
      DB_ADMIN_ID_LOGIN "sa"

      This work for me. But don´t forgett to write the password for your sa account in the password lines!


      Thank you.
      And it work fine for you? You can enter in to game and play?

    • xpr0keksx;33731 schrieb:

      You need:
      An OBDC for account Database, Character Database and Log01 Database.
      You name the connections for account login, for Character character01 and for Log01 log01.

      DSN_NAME_CHARACTER "character01"
      DB_ADMIN_ID_CHARACTER "sa"

      DSN_NAME_LOG "log01"
      DB_ADMIN_ID_LOG "sa"

      DSN_NAME_LOGIN "login"
      DB_ADMIN_ID_LOGIN "sa"

      This work for me. But don´t forgett to write the password for your sa account in the password lines!


      This doesn't work for me. The account server is unable to connect to the database when I change them.

    • Linker4;33768 schrieb:

      This doesn't work for me. The account server is unable to connect to the database when I change them.

      Do you have a sa account? Or have you put your password in the lines for the passwords?

      @Cavatina:
      Yes it works fine i can play ingame. But you must delete the nProtect Line in the Loginserver.ini, too, because you don´t have a license for nProtect.

    • xpr0keksx;33800 schrieb:

      Do you have a sa account? Or have you put your password in the lines for the passwords?

      @Cavatina:
      Yes it works fine i can play ingame. But you must delete the nProtect Line in the Loginserver.ini, too, because you don´t have a license for nProtect.


      Okay thanks.
      Now I will test it.
      If something will be wrong can I ask you?

    • xpr0keksx;33731 schrieb:

      You need:
      An OBDC for account Database, Character Database and Log01 Database.
      You name the connections for account login, for Character character01 and for Log01 log01.

      Look on the 4th post.


      ----------------------------------------------------------
      I have got strage error when I executing Character_01_DBF

      Quellcode

      1. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 14
      2. Invalid column name 'INSERT INTO G_TOP_CHARACTER SELECT TOP '.
      3. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 14
      4. Invalid column name ' a.m_szName, a.m_nLevel'.
      5. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 15
      6. Invalid column name ' FROM CHARACTER_TBL a JOIN'.
      7. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 16
      8. Invalid column name ' ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL b'.
      9. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 17
      10. Invalid column name ' ON a.account = b.account WHERE'.
      11. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 18
      12. Invalid column name ' a.account NOT IN (SELECT * FROM G_TOP_VOID_ACCOUNT) AND'.
      13. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 19
      14. Invalid column name ' a.m_szName NOT IN (SELECT * FROM G_TOP_VOID_CHAR) AND'.
      15. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 20
      16. Invalid column name ' a.m_nLevel >= '.
      17. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 20
      18. Invalid column name ' AND a.m_chAuthority='F' AND'.
      19. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 21
      20. Invalid column name ' b.m_chLoginAuthority='F' AND'.
      21. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 22
      22. Invalid column name ' (b.BlockTime <= '.
      23. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 22
      24. Invalid column name ' AND b.WebTime <= '.
      25. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 23
      26. Invalid column name ') ORDER BY a.m_nLevel DESC, a.TotalPlayTime ASC'.
      27. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 24
      28. Invalid column name 'SELECT TOP '.
      29. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 24
      30. Invalid column name ' a.m_szName, a.m_nLevel, a.m_nJob'.
      31. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 25
      32. Invalid column name ' FROM CHARACTER_TBL a JOIN'.
      33. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 26
      34. Invalid column name ' ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL b'.
      35. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 27
      36. Invalid column name ' ON a.account = b.account WHERE'.
      37. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 28
      38. Invalid column name ' a.account NOT IN (SELECT * FROM G_TOP_VOID_ACCOUNT) AND'.
      39. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 29
      40. Invalid column name ' a.m_szName NOT IN (SELECT * FROM G_TOP_VOID_CHAR) AND'.
      41. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 30
      42. Invalid column name ' a.m_nLevel >= '.
      43. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 30
      44. Invalid column name ' AND a.m_chAuthority='F' AND'.
      45. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 31
      46. Invalid column name ' b.m_chLoginAuthority='F' AND'.
      47. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 32
      48. Invalid column name ' (b.BlockTime <= '.
      49. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 32
      50. Invalid column name ' AND b.WebTime <= '.
      51. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 33
      52. Invalid column name ') ORDER BY a.m_nLevel DESC, a.TotalPlayTime ASC'.
      Alles anzeigen


      What do you think about this?
      It is error in G_TOP_CHARACTER procedure.

    • I did look the 4th post, but so they have to be like

      login > for ACCOUNT_DBF
      character01 > for CHARACTER_01_DBF
      log01 > for LOG_01_DBF

      and I have done them, but i don't understand why the databaseserver.exe closes and doesnt load even if i set it up in the

      Quellcode

      1. ResourceFolder "C:\Users\Mirko\Desktop\NeuroSpace\Resource"
      3. Sys 1
      4. Account "127.0.0.1"
      6. DSN_NAME_CHARACTER "character01"
      7. DB_ADMIN_ID_CHARACTER "eocrm"
      9. DSN_NAME_LOG "log01"
      10. DB_ADMIN_ID_LOG "sa"
      12. LANG 6
      14. // 6
      15. DB_PWD_LOG "blabla"
      16. DB_PWD_CHARACTER "blabla"
      17. DB_PWD_BACKEND "blabla"
      18. DB_PWD_ITEMUPDATE "blabla"
      Alles anzeigen

    • xpr0keksx;33800 schrieb:

      Do you have a sa account? Or have you put your password in the lines for the passwords?



      Yes, there is an account called "sa", with the password 1234. And yes, I've put the paswords in the .ini files, where it was required... But as soon as I start the database server, I face an error message like this: "Can't connect to the database", so...?
      Cavatina, try to re-execute the procedure "mail_str_realtime".