First Game Account

[Dr.Oro]

Hi Epvpers,

Which is the exact path to create the first Acc of my pServer. I know it starts under PS_Userdata - dbo.Users_Master ,i try it with " Search" to find appropriate Treaths, but thats all i know ... ;(

[nephren]

INSERT INTO PS_UserData.dbo.Users_Master
(UserID,Pw,JoinDate,Admin,AdminLevel,UseQueue,Stat us,Leave,LeaveDate,UserType,Point,EnPassword,UserIp)
VALUES ('USERNAME','PASSWD',GETDATE(),1,255,'false',16,0,GETDATE(),'N',0,'','127.0.0.1')

[JohnHeatz]

#Moved to the right section

[Dr.Oro]

Ok. Verzeiht einem der sich gerade erst reinfindet in dieses Thema, aber anscheinend fehlt mir in dieser Masterdatei iwas um diesen Code überhaupt nutzen zu können. Finde unter z.B. Design keine Tabelle in welcher ich diese Werte eintragen könnte.

[TeddyBear94]

learn reading in epvpers or using youtube to search in. there are alot way to find out what u need to do just do it these questions u are asking was already answered like 1000 times. use the search engine.

[Dr.Oro]

Ty you Teddy for this nice answer. I´ve search the hole day in many tutorials and threads here and in google to become an answer. But it feels like an puzzle. In many threads with similar themes, the DEV Team answer with ; "learn to use the search" . But a real good link for an easy Tutorial with this themes i cant find. So to use "search" is very long puzzle game and a street with many dead ends for people they are new.

[rempieremco153]

Double click ps_userdata, double click tables, right click dbo.Users_Master
And click edit first 200 rows or select first 1000

[TeddyBear94]

1 min searching

[Dr.Oro]

real ty

ok new Problem, i started server, loged in, clicked on server and ---> connection with server has been disconnected, here is the log ;

(Spoiler)
([2013-01-04 10:45:29 PS_GAME__system log start (Game01) [KR]

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/sorp1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/croco1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/croco2

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Troll1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Spink1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/GoldenPig

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Sorp3

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/SorpNamed1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/SorpNamed2

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Sorp2

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/CrocoNamed1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/CrocoNamed2

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/CrocoNamed3

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/OrcNamed1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/OrcNamed2

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/OrcNamed3

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/TrollNamed1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Deinos

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Parridalis

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Alcarian

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/ZinAlcaria

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Belizabeth

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Kirhiross

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/CrypticOne

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Haruhion

2013-01-04 10:45:29 Loaded Behavior In Factory : data/ai/Freezing

2013-01-04 10:45:31 connect mgr 1344

2013-01-04 10:45:31 connect dbagent 1348

2013-01-04 10:45:31 connect dbagent2 1352

2013-01-04 10:45:31 connect gamelog 1368

2013-01-04 10:45:31 Market End -----------------------

2013-01-04 10:45:32 Load Shaiya.SData 0

2013-01-04 10:46:04 <Console input> /nprotectoff

2013-01-04 10:46:04 <Console output> cmd NProtect off ok

2013-01-04 10:46:53 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

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

2013-01-04 10:41:32 PS_SESSION__system log start (Session)

2013-01-04 10:41:34 connect login

2013-01-04 10:41:35 connect game

2013-01-04 10:44:17 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=3,RCS=0, RB=77,RBS=0, SC=1,SCS=0, SB=5,SBS=0

2013-01-04 10:44:17 disconnect game

2013-01-04 10:44:17 3 1 SERVICE_CONTROL_STOP

2013-01-04 10:44:18 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:18 1 1 T=000:02:00:000, RC=18,RCS=0, RB=193,RBS=1, SC=5,SCS=0, SB=121,SBS=0

2013-01-04 10:44:18 disconnect login

2013-01-04 10:44:19 1 1 SAgent:isconnect: (3, 1236)

2013-01-04 10:44:19 1 1 T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-01-04 10:44:19 log system server disconnection

2013-01-04 10:44:19 PS_SESSION__system log end (Session)

2013-01-04 10:44:19 3 1 SService::ServiceCtrlDispatcher(): service shutdown

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

2013-01-04 10:41:32 PS_USERLOG__system log start (UserLog)

2013-01-04 10:41:33 connect

2013-01-04 10:41:34 connect

2013-01-04 10:41:34 connect

2013-01-04 10:44:17 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=2,RCS=0, RB=105,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-01-04 10:44:17 disconnect

2013-01-04 10:44:18 3 1 SERVICE_CONTROL_STOP

2013-01-04 10:44:18 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:18 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-01-04 10:44:18 disconnect

2013-01-04 10:44:19 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:19 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-01-04 10:44:19 disconnect

2013-01-04 10:44:19 PS_USERLOG__system log end (UserLog)

2013-01-04 10:44:19 3 1 SService::ServiceCtrlDispatcher(): service shutdown

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

//PS_DBAGENT__charsave log start (DBAgent01)

//PS_DBAGENT__charsave log start (DBAgent01)

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

2013-01-04 10:41:33 PS_DBAGENT__system log start (DBAgent01)

2013-01-04 10:41:34 connect game, Name=



2013-01-04 10:41:34 connect game, Name=



2013-01-04 10:44:17 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=5,RCS=0, RB=165,RBS=1, SC=5,SCS=0, SB=2189,SBS=13

2013-01-04 10:44:17 disconnect game, Name=Game01



2013-01-04 10:44:17 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=3,SCS=0, SB=2064,SBS=12

2013-01-04 10:44:17 disconnect game, Name=Game01



2013-01-04 10:44:17 save market... wait plz...



2013-01-04 10:44:17 save all... wait plz... enter /uc



2013-01-04 10:44:17 3 1 SERVICE_CONTROL_STOP

2013-01-04 10:44:17 PS_DBAGENT__system log end (DBAgent01)


2013-01-04 10:44:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown

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

2013-01-04 10:41:33 Loaded Behavior In Factory : data/ai/Kirhiross

2013-01-04 10:41:33 Loaded Behavior In Factory : data/ai/CrypticOne

2013-01-04 10:41:33 Loaded Behavior In Factory : data/ai/Haruhion

2013-01-04 10:41:33 Loaded Behavior In Factory : data/ai/Freezing

2013-01-04 10:41:34 connect mgr 1340

2013-01-04 10:41:34 connect dbagent 1344

2013-01-04 10:41:34 connect dbagent2 1348

2013-01-04 10:41:34 connect gamelog 1364

2013-01-04 10:41:35 Market End -----------------------

2013-01-04 10:41:35 Load Shaiya.SData 0

2013-01-04 10:44:17 3 1 SERVICE_CONTROL_STOP

2013-01-04 10:44:17 Call save all waiting...

2013-01-04 10:44:17 1 1 SAgent:isconnect: (3, 1236)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=1,RCS=0, RB=5,RBS=0, SC=3,SCS=0, SB=77,SBS=0

2013-01-04 10:44:17 1 1 SAgent:isconnect: (3, 1236)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=5,RCS=0, RB=2189,RBS=13, SC=5,SCS=0, SB=165,SBS=1

2013-01-04 10:44:17 1 1 SAgent:isconnect: (3, 1236)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=3,RCS=0, RB=2064,RBS=12, SC=1,SCS=0, SB=37,SBS=0

2013-01-04 10:44:17 1 1 SAgent:isconnect: (3, 1236)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=0, SB=105,SBS=0

2013-01-04 10:44:17 discon mgr ((3,1236, 5,77)

2013-01-04 10:44:17 mgr Connection Lost INFO : T=000:02:00:000, RC=1,RCS=0, RB=5,RBS=0, SC=3,SCS=0, SB=77,SBS=0

2013-01-04 10:44:17 mgr server disconnection

2013-01-04 10:44:17 discon dbagent ((3,1236, 2189,165)

2013-01-04 10:44:17 discon dbagent2 ((3,1236, 2064,37)

2013-01-04 10:44:17 dbagent Connection Lost INFO : T=000:02:00:000, RC=5,RCS=0, RB=2189,RBS=13, SC=5,SCS=0, SB=165,SBS=1

2013-01-04 10:44:17 dbagent2 Connection Lost INFO : T=000:02:00:000, RC=3,RCS=0, RB=2064,RBS=12, SC=1,SCS=0, SB=37,SBS=0

2013-01-04 10:44:17 db agent server disconnected...

2013-01-04 10:44:17 db agent2 server disconnected...

2013-01-04 10:44:17 call disconnectAll...

2013-01-04 10:44:17 discon userlog ((3,1236, 0,105)

2013-01-04 10:44:17 userlog Connection Lost INFO : T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=0, SB=105,SBS=0

2013-01-04 10:44:17 userlog log server disconnection

2013-01-04 10:44:17 1 1 SAgent:isconnect: (3, 1236)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-01-04 10:44:17 discon gamelog ((3,1236, 0,37)

2013-01-04 10:44:17 gamelog Connection Lost INFO : T=000:02:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=1,SCS=0, SB=37,SBS=0

2013-01-04 10:44:17 game log server disconnection

2013-01-04 10:44:17 server shutdown Connection INFO : T=000:02:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2013-01-04 10:44:17 Save Shaiya.SData 0

2013-01-04 10:44:17 PS_GAME__system log end (Game01)

2013-01-04 10:44:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown

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

2013-01-04 10:41:33 PS_GAMELOG__system log start (GameLog01)

2013-01-04 10:41:34 connect game

2013-01-04 10:44:17 1 1 SAgent:isconnect: (4, 64)

2013-01-04 10:44:17 1 1 T=000:02:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2013-01-04 10:44:17 disconnect game

2013-01-04 10:44:17 3 1 SERVICE_CONTROL_STOP

2013-01-04 10:44:17 PS_GAMELOG__system log end (GameLog01)

2013-01-04 10:44:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown)]

----------------------------
thats all

i have checked all ini, i have checked TCP , dont know where is the error with db connect

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

ok the problem is then solved by deleting the PS_Userdata01 under PS_GameData

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

Now there is sgraphic error after klick ok on server login

[Truth1010]

That log doesn't really show much that could let us help you. Try post the other logs into (spoiler) (/spoiler) tags for us. Replace ( with [ and ) with ]

 Spoiler

log here

[rempieremco153]

Originally Posted by Dr.Oro

real ty

ok new Problem, i started server, loged in, clicked on server and ---> connection with server has been disconnected, here is the log ;

If you actually check your log, before posting here,
You can see that the connection with the database dropped.
Make sure the connection to database is set up in all .ini files correctly
also make sure your ip in game.ini is correct.

[Dr.Oro]

The IPs are all ok in all ini . But now the SQL Manager doesnt works , i have nothing change there

TITLE: Connect to Server
------------------------------

Cannot connect to 127.0.0.1.

------------------------------
ADDITIONAL INFORMATION:

Netzwerkbezogener oder instanzspezifischer Fehler beim Herstellen einer Verbindung mit SQL Server. Der Server wurde nicht gefunden, oder auf ihn kann nicht zugegriffen werden. Überprüfen Sie, ob der Instanzname richtig ist und ob SQL Server Remoteverbindungen zulässt. (provider: Named Pipes-Provider, error: 40 - Verbindung mit SQL Server konnte nicht geöffnet werden) (Microsoft SQL Server, Error: 2)




------------------------------
BUTTONS:

OK
------------------------------





ok SQL is fine now














can someone (from DEV Team?) look with TV over the problems??

[Truth1010]

Sounds like your service is turned off via SQL.

Open your SQL Server Config Manager and check that "SQL Server (MSSQLSERVER)" is running and not stopped.

[Dr.Oro]

ok new problem.

after solve the DC after klicking on server. Now there comes an "sgrahic" error. I try to solve it with lower graphics, with new NPC.Data, with lilpros tool (it doesnt works, or im to stupid use it correctly) but nothing helps. The Error comes again. Please help.

[Dreameh]

Did you make sure to encrypt the sdata's with the data file tool? That could be causing the error.