creating new accounts

[wellmonster]

Hi all,

So far everything is working great. I just need to know how i can make an account(s). is there a php script or something?

thanks in advance.

[MentaL]

[Supicioso]

Look at my guide in the release section. I just added one.

Also If you have everything working I wouldn't mind helping you test it.

[terzo]

INSERT INTO tUser (sUserID, sUserPW, sUserName) VALUES ('username', 'userpassword', 'username')

Working fine

[wellmonster]

Ok last thing i need help with for now.. OpTools. i'm getting this error in debug.

"000000 2010-04-05 17:30:32 OK - 'CharacterTitleData.shn' Read.
000001 2010-04-05 17:30:33 Reload Server info 'Data\ServerInfo\OPToolServerInfo-RUT'
000002 2010-04-05 17:30:33 Reload Server info 'Data\ServerInfo\OPToolServerInfo-RUT'
000003 2010-04-05 17:30:34 OP DB Connect Fail - error ODBC connection"

So I've edited "OPToolServerInfo-Common.otd" changed passwords and IP's, still nothing. do i have to change anything in

"OPToolServerInfo-RUF.otd", "OPToolServerInfo-RUT.otd" or "ServerInfoList.otd"

thx.

[Trimatic]

000003 2010-04-05 17:30:34 OP DB Connect Fail - error ODBC connection"

Go to Run > odbcad32 > System DSN > Add > Scroll down > Choose SQL Server > Enter Details.

[wellmonster]

*sigh ... spelling error.. OPToll instead of OPTool. =/. well all that is good now. what about log in credetials. what account do I use or do I have to create a new one. my log in and password for account on server do not work. any ideas?

[Psytrunks]

i want to know, how to create anadmin or gm account. someone says, you have to edit tuser in sql but i don´t know how. cn someone make a short tutorial or script?

thanks

[Trimatic]

Please make a new thread since the OP's problem has been solved.

[thunderbrit07]

i want to know, how to create anadmin or gm account. someone says, you have to edit tuser in sql but i don´t know how. cn someone make a short tutorial or script?

thanks

You just go to dbo.tCharacter and enter and admin lvl of 100 (10 allows warping, immortal, and hide)

Or you could use this script

UPDATE [World00_Character].[dbo].[tCharacter]
   SET [sID] = '[GM]Name'
      ,[nLevel] = '150'
      ,[nAdminLevel] = '100'
      
 WHERE [sID] = 'Character your changing to GM'
GO