[English]Discussion

Wher im download the odbc?

you dont download ODBC, the ODBC is in control panel folder
go there to managment tools and you will see the ODBC

--------------

now mine problem, can someone send me a complete server files thats working?
[just need to change the pass to get it work]
please? i cant make my own, my databaseserver.exe is wont working = \

i donot have control panel folter? wher tats folder?

when you add an v13 item to v11

and you add

propitem
propitem.txt
defineitem.h
mdldyna

and in database.. why it doesnt spawn in game?
D:

I need a Ban command!! for hackers? what should I do?

smallpoop?
can you give me your .ini fils please?
i know thats your server is working.
and i need help from someone who have the server worked

Zitat von GarbeTz;37545

smallpoop?
can you give me your .ini fils please?
i know thats your server is working.
and i need help from someone who have the server worked

SmallPooP Help me to please :yaeh am not durnk:

what wrong with this?

it's my set:

AccountServer.ini

AddTail( -1, 1, "test(25x)", "192.168.0.128", 0, 1, 0 );
AddTail( 1, 1, "test", "192.168.0.128", 0, 1, 1100 );


DSN_NAME_LOGIN 		"login"
DB_ADMIN_ID_LOGIN 	"sa"


DSN_NAME_LOG 		"log01"
DB_ADMIN_ID_LOG 	"sa"


lang			6
MSG_VER 		"20070712"


DB_PWD_LOGIN 		"123456"
DB_PWD_LOG 		"123456"

CacheServer.ini

Core "192.168.0.128"
Port "15400"

Certifer.ini

Account "192.168.0.128"
DB_PWD_LOGIN "123456"

CoreServer.ini

Sys 1
Database "192.168.0.128"


0101
{
1 0 0 30 30 00 00
2 0 0 5 5 00 00
3 0 0 3 3 00 00
200 0 0 5 5 00 00
201 0 0 5 5 00 00


210 0 0 1 1 00 00
220 0 0 1 1 00 00
230 0 0 1 1 00 00
202 0 0 5 5 00 00


204 0 0 5 5 00 00
205 0 0 2 2 00 00


203 0 0 3 3 00 00
206 0 0 2 2 00 00
207 0 0 2 2 00 00


208 0 0 2 2 00 00
241 0 0 1 1 00 00
242 0 0 1 1 00 00
243 0 0 1 1 00 00
244 0 0 1 1 00 00
}

DatabaseServer.ini

ResourceFolder 		"E:\Use\server\resource"


Sys 			1
Account 		"192.168.0.128"


DSN_NAME_CHARACTER 	"character01"
DB_ADMIN_ID_CHARACTER 	"sa"


DSN_NAME_LOG 		"log01"
DB_ADMIN_ID_LOG 	"sa"


LANG 6


DB_PWD_LOG "123456"
DB_PWD_CHARACTER "123456"
DB_PWD_BACKEND "123456"
DB_PWD_ITEMUPDATE "123456"

LoginServer.ini

DB "192.168.0.1281"
Core "192.168.0.128"


AddCache( "192.168.0.128" );


MSG_VER "20070712"

WorldServer.ini

ResourceFolder 			"E:\Use\server\resource"
Key 				0101
DB 				"192.168.0.128" 
Core 				"192.168.0.128" 
LANG 				6
18
Heartbeat 			10101
GUILDWAR 			1
GUILDBANK 			1
WORMON 				1
DROPITEM_REMOVE 		0


GUILDCOMBAT 			1
ARENA 				1


GUILDCOMBAT1TO1 		1
18
PK 				1
PKCOST 				1
respawn 			1

when i login in game it say "wrong password"

i try to use MD5 but wrong too

is my acc and pwd:

USE [ACCOUNT_DBF]
GO


INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [vers], [attempts], [bantime], [lastip])
VALUES
(N'lols', N'c5ed61147e53612562c2daff238a03ec', N'T', N'A', NULL, N'c5ed61147e53612562c2daff238a03ec', N'F', NULL, 0, NULL, NULL, NULL)
GO


INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [net_enable], [vers], [AccSource], [AccSourceID], [email], [birthday], [ban_reason], [ip])
VALUES
(N'lols', N'A000', N'2', N'F', '20080818 00:51:35.700', N'20010101', N'20990101', N'20050101', N'O', NULL, NULL, 0, N'0', 0, N'a2lsbGEtZGF2QHdlYi5kZQ==', N'MDguMDkuMTk5Mw==', N'', N'test')
GO

UID:lols
PWD:lol

and i use the FlyForGalaxy's client

thanks you help

I get this error @the Account server startup

SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Please tell me how should I give ban to account?
i know only to character on DB.. no command?!

Ingame ban.. rofl0rd.

Look into ACCOUNT_DETAIL_TBL and think about the word "endTime"....

Zitat von vaxtang91;35013

i got a problem when im trying to open database server (after i opend account server seccsesfuly) here is the error

the database server ini is in the script foldet and i changed all the info there to what is sayes in a guide i found in other forum O_O maybe somone allso has a more info guide cuz there its not realy understood ^^ maybe i did somthing wrong

waiting for reply ^^

Please can anybody help? i posted first like a week ago if not more and no one helped me yet O_O some have tryed but with no luck :) please if somone know i have no freaking idea how to fix that! O_O

Directed to vaxtang91

go up one folder and goto the Script folder, have a look for the databaseserver.ini, if u dont find it then copy and paste the one from inside the resource folder there and change the settings to work.

Directed to zerozone

UID:lols
PWD:lol

and i use the FlyForGalaxy's client

thanks you help

What md5 are u using, if you are not using fame files u will need the old kikugalanet if you are using Fame's exe you will need to add nForceIsGay infront of your password for the md5 to work.

any1 got an idea of adding things to shop, cant seem to find any info about items in a shop, just the shops name and stuff, any help would be nice

Zitat von TwiLight;37566

Ingame ban.. rofl0rd.

Look into ACCOUNT_DETAIL_TBL and think about the word "endTime"....

i dont understand... should I write there a date?
are you sure that there isnt any command in game?

SmallPoop remove the user u want giv ban.

what the hell i need to do with this error:

Zitat

2009/10/12 14:15:00
C:\neurospace\PROGRAM\_database\DbManager.cpp, 3973

the error shows up every 3 seconds after i open databaseserver.exe
and i have no folder that called neurospace expect for the server files
what should i do? :S

sorry about the double post
i had lags and pressed twice =S
pelase remove this post

I can't create character in game.
Character does not appear when i click create. (character is created in the database but i can't see it in game)

CQuery-LogFile:

Zitat

2009/10/12 17:39:54
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find server 'RANKING' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

2009/10/12 17:40:49
query:LOG_USER_CNT_STR '01', 0, 0
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'LOG_USER_CNT_STR'.

error:

Zitat

2009/10/12 17:39:54 CDbManager::UpdateGuildRankingżˇĽ* (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ˝ÇĆĐ

Dear GodLikerz,
I am writing to you because you are really great. I have got very stupid bug and I don`t know how to fix it. Probably i have somethin wrong in .ini files or... .
I know that you runned server without any bugs.

My bug look that:
- When I am creating new character it says that name is in use. To play i have to back to server screen and again go to character screen, then I can choose character and play.
I know that it isn`t very big bug but it is strange...

I will give you my settings and if you can please tell me what is wrong, tell me please what I don`t have but you have.
Then...

1. Softwere
- MMSQL Server 2005
- SQL Server Management Studio Express
- Fame files
- Fame DataBase
- ODBC 5.1

2. My ini files

3. My ODBC settings:
- character01 for CHARACTER_01_DBF
- log01 for LOG_01_DBF
- login for ACCOUNT_DBF

So... that is all I think. If I forgot about something say me I will add.

I belive that you will help me. I really don`t know what is may be.

Yours
~Cavatina

when im trying to buy something from Cash Shop Seller it says to me that i need more penya.. and I have alot!!
why?