My way of setting up official server files

[kainijssen]

I even dont know how to start up server...where are server starters?

Thx for this guide anyway

[jason145]

Lol. Go into Program folder and start each server

[Mohanddo]

Seriously you guys if you have no coding experiance at all and hoping this would just be a few clicks/number changes then you're wrong. These files were originally coded for people in asia to play and (I think don't quote me on this) ported over to be English. The ini's are hard to understand and the SQL files are buggy. I only got the SQL files because my friend found on with the character_01_dbf and the two fixes mixed.

It took me a couple hours playing with the settings and looking at the errors trying to find out what works.

So trust me if you don't actually want these up really bad or if you don't have any programming knowledge then you'll probably never end up getting this stuff working.

I could write a tutorial but I won't because alot of the stuff depends on your server, it's setup, it's specs, your mssql setup, etc.

Which is the whole reason most of your are having problems even when Mohanddo says he ran through this to make sure it was perfect. I also won't write a tutorial because then you'd never learn anything from it.

Actually even though i said it was perfect there are still some things i intentionally didnt say so that atleast people would use a little common sense ;) hence all the problems people are having.

[alist3r06]

can u make me step by step instruction for this one how to and were to open this Databases:
Enter sql server management studio and execute the databases that i provided. But after you create your CHARACTER_01_DBF, do not execute the query for it. Before that run 1.sql from the fixes. You should then have 5 databases with the names: ACCOUNT_DBF - CHARACTER_01_DBF - ITEM_DBF - LOG_01_DBF - LOGGING_01_DBF.

Im assuming you know how to execute sql but if you dont 'heathj' explains it well on his guide.

After all the DBs have been executed run the 2nd fix for the character db

[litester]

Creating an account:

You can execute the following query:

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'acount name', N'md5(nForceIsGay+pass)', N'T', N'A', NULL, N'md5(nForceIsGay+pass)', 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'account name', 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

Or as i learned from heathj you can use the stored procedure 'WebCreatAcc'.

For the people who dont understand what 'md5(nForceIsGay+pass)' means:

The fame neuz uses md5 hashes to check pass and it uses the nForceIsGay prefix before encrypting into md5. For example if you wanted your pass to be test you would convery nForceIsGaytest to md5 and store it in the database. Just as you would kikugalanettest for a normal neuz.

Finally:
I do not claim these files and databases as my own in anyway. I am not obliged to give you support and these files and this guide are FOR EDUCATIONAL PURPOSES ONLY. I do not claim responsibility for your actions regarding this guide. As everyone else has said, if you want to make a server public with these files, goodluck keeping them up.

great guie...

omhhhjjjhh.... in me server i can make account in web page xdd

okey too grat job!

[timmeijers]

hi,

i don't know there is a solution posted yet but i done like everthing good

so i used character database then fix 1 and 2

when i start my AccountServer i get this



if someone know how to fix it well i would be happy as hell xD

ty for ur time already then

[alist3r06]

aw where can i find this executing thing...

[ultimatic]

hey i have solved my login server problem but i cant create an account why?

[jason145]

hi,

i don't know there is a solution posted yet but i done like everthing good

so i used character database then fix 1 and 2

when i start my AccountServer i get this



if someone know how to fix it well i would be happy as hell xD

ty for ur time already then

Looks to me as if the LOGINJOIN_STR has not executed correctly. Try deleteing the db then executeing again.

[ecKo9321]

Looks to me as if the LOGINJOIN_STR has not executed correctly. Try deleteing the db then executeing again.

Jason can you send me a PM with your msn or yahoo? want to ask you some things about mssql, if you think you could help a bit a nub rofl, and ofc have time.

Cheers

[dudekill]

i dont get only part how to put db into my sql 2005 someone help me add me in msn rohan_3@live.ca(to do teamviewer)

[extra300]

How to edit rates.

How to create a GM account.

pls help

[jason145]

Look in the release section. You will find them there. Don't spam this thread.

[dudekill]

hi guys who ever made this guide should make video guide so we can understand everthing

[ecKo9321]

hi guys who ever made this guide should make video guide so we can understand everthing

His write, we need video, on how to execute db meng, i dont get it, entr mssql and you are saying about char_01, and etc.

Be more explicite

[ikenna1]

i have everything working but now.stupid question i got v11 client and fame nuez now what to do

[ptuser]

hi guys who ever made this guide should make video guide so we can understand everthing

Someone once said if you're stuck already, it's better not to bother, cuz obviously you'll be asking a lot of helps on each and every steps of your way through.

[KING5]

i think the DB part is the most problematic

[DeltaBurnt]

i think the DB part is the most problematic

No there's much more problems you can run into besides just the DB.

[BBim]

Isnt a tutorial enough? You now want a video? Want people to do it for you too?

[Mohanddo]

It took me 3 days to get these files up and you want me to release a video guide so everyone can make one in 10 minutes? No ty... maybe instead of wanting everything spoon fed to you, you should try something yourself...

[Diumelia]

It took me 3 days to get these files up and you want me to release a video guide so everyone can make one in 10 minutes? No ty... maybe instead of wanting everything spoon fed to you, you should try something yourself...

You are absolutely right! I hate it when somebody is spamming the help section before they even searched the forum or google.

[dudekill]

greate guide i got all working but i get confued at making account so someone plz help me. and how to i start client i edited nuez.ini ip "127.0.0.1" and then i start Fame.exe? But says Server Not avaiable.

MSN: rohan_3@live.ca

[necrorandy]

well...i tried...wenever i try to create a char game exits...any idea?...then also i get this error:
"CCU:0
frame:991 tick:1
Respawn:4 Object:9581
warning - tick:158
WdMadrigal WdKebaras random_map ect all maps"
and also this error:
"2009/11/13 13:39:51
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find server 'RANKING' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers."
any help?...

[tGxi]

One issue that I was having, was a really basic one, Not sure if someone already posted, but when you tried to excute the sql query for LOGGING_01_DBF. The Database is suppose to be called LOGGIN_01_DBF

Simple reading can get you far in life:

Msg 911, Level 16, State 1, Line 1
Database 'LOGGIN_01_DBF' does not exist. Make sure that the name is entered correctly.

So just simply change the name of the Database: LOGGING_01_DBF, to LOGGIN_01_DBF