[English]Discussion

How to change the prices of cs shop?

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_CHARACTER

DSN_NAME_LOG
DB_ADMIN_ID_LOG

DSN_NAME_LOGIN
DB_ADMIN_ID_LOGIN

And which users for what DataBase, for example:

login for Acccount_DBF

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!

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.

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!

Alles anzeigen

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

I get

"2009/ 9/28 23:26:02 Not TransServer Connect"

When I open core server, what can i do to fix this? o.O

KingNoobie

you have to start the DatabaseServer

DataBaseServer= Transserver

Zitat von Linker4;33768

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.

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?

Can someone tell me what I have to put in the ODBC please?

Like, what name, and what DB, and which one of them, im thinking its the ODBC that doesnt let me connect to the DB, so i cant go to core server. .-.

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_DBF

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

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

ResourceFolder		"C:\Users\Mirko\Desktop\NeuroSpace\Resource"


Sys		1
Account		"127.0.0.1"


DSN_NAME_CHARACTER		"character01"
DB_ADMIN_ID_CHARACTER		"eocrm"


DSN_NAME_LOG		"log01"
DB_ADMIN_ID_LOG		"sa"


LANG 6


// 6
DB_PWD_LOG		"blabla"	
DB_PWD_CHARACTER	"blabla"
DB_PWD_BACKEND		"blabla"
DB_PWD_ITEMUPDATE	"blabla"

Zitat

DB_ADMIN_ID_CHARACTER "eocrm"

It should be:

Zitat

DB_ADMIN_ID_CHARACTER "sa"

Hello ppl.

I have a stupid error which crash my Trans Server.

It looks:

Anyone know how to fix it?

how i can add npcs to the game?? or summon tham?

Zitat von shay2243;33980

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?

I need help with registration page. Somone can give me registration page for this?

thanks anyway..

Zitat von Linker4;34007

Cavatina, try to re-execute the procedure "mail_str_realtime".

I did that 100 times and nothing T.T
Could you give me your Mail_STR_Realtime procedure please? :>