how i can add npcs to the game?? or summon tham?
I know how but first I need your help.
How to fix my MAIL_STR_REALITIME error?
Beiträge von Cavatina
-
-
Hello ppl.
I have a stupid error which crash my Trans Server.
It looks:
Anyone know how to fix it?
-
Zitat
DB_ADMIN_ID_CHARACTER "eocrm"
It should be:ZitatDB_ADMIN_ID_CHARACTER "sa"
-
Zitat von xpr0keksx;33731
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_DBFCode
Alles anzeigenMsg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 14 Invalid column name 'INSERT INTO G_TOP_CHARACTER SELECT TOP '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 14 Invalid column name ' a.m_szName, a.m_nLevel'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 15 Invalid column name ' FROM CHARACTER_TBL a JOIN'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 16 Invalid column name ' ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL b'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 17 Invalid column name ' ON a.account = b.account WHERE'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 18 Invalid column name ' a.account NOT IN (SELECT * FROM G_TOP_VOID_ACCOUNT) AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 19 Invalid column name ' a.m_szName NOT IN (SELECT * FROM G_TOP_VOID_CHAR) AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 20 Invalid column name ' a.m_nLevel >= '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 20 Invalid column name ' AND a.m_chAuthority='F' AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 21 Invalid column name ' b.m_chLoginAuthority='F' AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 22 Invalid column name ' (b.BlockTime <= '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 22 Invalid column name ' AND b.WebTime <= '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 23 Invalid column name ') ORDER BY a.m_nLevel DESC, a.TotalPlayTime ASC'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 24 Invalid column name 'SELECT TOP '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 24 Invalid column name ' a.m_szName, a.m_nLevel, a.m_nJob'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 25 Invalid column name ' FROM CHARACTER_TBL a JOIN'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 26 Invalid column name ' ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL b'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 27 Invalid column name ' ON a.account = b.account WHERE'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 28 Invalid column name ' a.account NOT IN (SELECT * FROM G_TOP_VOID_ACCOUNT) AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 29 Invalid column name ' a.m_szName NOT IN (SELECT * FROM G_TOP_VOID_CHAR) AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 30 Invalid column name ' a.m_nLevel >= '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 30 Invalid column name ' AND a.m_chAuthority='F' AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 31 Invalid column name ' b.m_chLoginAuthority='F' AND'. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 32 Invalid column name ' (b.BlockTime <= '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 32 Invalid column name ' AND b.WebTime <= '. Msg 207, Level 16, State 1, Procedure G_TOP_CHARACTERS, Line 33 Invalid column name ') ORDER BY a.m_nLevel DESC, a.TotalPlayTime ASC'.What do you think about this?
It is error in G_TOP_CHARACTER procedure. -
Zitat von xpr0keksx;33800
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? -
Zitat von xpr0keksx;33731Alles anzeigen
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? -
Zitat von shay2243;33698
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:DSN_NAME_CHARACTER
DB_ADMIN_ID_CHARACTERDSN_NAME_LOG
DB_ADMIN_ID_LOGDSN_NAME_LOGIN
DB_ADMIN_ID_LOGINAnd which users for what DataBase, for example:
login for Acccount_DBF
-
Hello
Could anyone upload the RANKING_DBF or full Database?
Thank you so much.