First Steps to go

[nutcrackerz]

can some1 tell me how do i create new accounts..

 

[Shakir]

-> atum2_db_account -> account

 

[nutcrackerz]

do i need to edit it with SQL (i have SQL 2005) or another program and what do i need to edit
PS.:im noob in this stuff
EDIT:is this what i need to edit :S
CREATE UNIQUE INDEX idx_AccountName_on_account ON td_Account(AccountName)
CREATE INDEX idx_ConnectingServerGroupID_on_account ON td_Account(ConnectingServerGroupID) -- 2006-09-21 by cmkwon, Ãß°¡
CREATE INDEX idx_N_td_Account_JuminNumber on td_Account(JuminNumber) -- 2007-10-01 by dhjin,
GO

 

[Shakir]

do i need to edit it with SQL (i have SQL 2005) or another program and what do i need to edit
PS.:im noob in this stuff
EDIT:is this what i need to edit :S
CREATE UNIQUE INDEX idx_AccountName_on_account ON td_Account(AccountName)
CREATE INDEX idx_ConnectingServerGroupID_on_account ON td_Account(ConnectingServerGroupID) -- 2006-09-21 by cmkwon, Ãß°¡
CREATE INDEX idx_N_td_Account_JuminNumber on td_Account(JuminNumber) -- 2007-10-01 by dhjin,
GO

Right Click on atum2_db_account -> New Query

Paste the following with your Data:

INSERT INTO [atum2_db_account].[dbo].[td_Account]
([AccountName]
,[Password]
,[AccountType]
,[Sex]
,[BirthYear]
,[RegisteredDate]
,[LastLoginDate]
,[IsBlocked]
,[ChattingBlocked]
,[MGameEventType]
,[ConnectingServerGroupID]
,[GameContinueTimeInSecondOfToday]
,[LastGameEndDate]
,[JuminNumber]
,[SecondaryPassword])
VALUES
('Your Account Name',
' Your Password',
'130',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'NULL',
'NULL')
GO

After you did that press Execute (upper left with a Red "!")

 

[nutcrackerz]

tnx man i luv u xD

 

[nutcrackerz]

i managed to make one account but after i create another one and when i tri to log on it it says the ID has not ben registered or the ID and PW do not match....do u guys know how to fix this ><

 

[Shakir]

i managed to make a account but when i make another one it says this ID has not ben registered or the ID and PW do not match why cant i create another one ?><

---------- Post added at 02:19 AM ---------- Previous post was at 02:16 AM ----------

i managed to make one account but after i create another one and when i tri to log on it it says the ID has not ben registered or the ID and PW do not match....do u guys know how to fix this ><

What are you using to register a new one ?

 

[nutcrackerz]

INSERT INTO [atum2_db_account].[dbo].[td_Account]
([AccountName]
,[Password]
,[AccountType]
,[Sex]
,[BirthYear]
,[RegisteredDate]
,[LastLoginDate]
,[IsBlocked]
,[ChattingBlocked]
,[MGameEventType]
,[ConnectingServerGroupID]
,[GameContinueTimeInSecondOfToday]
,[LastGameEndDate]
,[JuminNumber]
,[SecondaryPassword])
VALUES
('Your Account Name', <---- i put my name here
' Your Password', <---- and pass here
'130',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'')
GO


EDIT: TNX anyway ..i fix it was the password

 

[nutcrackerz]

how do i edit the succes rate fir enchant
i tried this but it doest work :INSERT INTO [atum2_db_account].[dbo].[ti_EnchantInfo]
([EnchantItemNum]
,[EnchantItemCount]
,[EnchantCost]
,[Prob1]
,[Prob2]
,[Prob3]
,[Prob4]
,[Prob5]
,[Prob6]
,[Prob7]
,[Prob8]
,[Prob9]
,[Prob10]
,[Prob11]
,[Prob12]
,[Prob13]
,[Prob14]
,[Prob15]
,[Prob16]
,[Prob17]
,[Prob18]
,[Prob19]
,[Prob20]
,[Prob21]
,[Prob22]
,[Prob23]
,[Prob24]
,[Prob25]
,[Prob26]
,[Prob27]
,[Prob28]
,[Prob29]
,[Prob30]
,[Prob31]
,[Prob32]
,[Prob33]
,[Prob34]
,[Prob35]
,[Prob36]
,[Prob37]
,[Prob38]
,[Prob39]
,[Prob40])
VALUES
( '',
'1',
'1',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'100',
'10',
'9',
'8',
'7',
'6',
'5',
'4',
'3',
'2',
'1',
'1',
'1')
and how do i edit this one >>:INSERT INTO [atum2_db_1].[dbo].[td_PollDate]
([ApplicationStartDate]
,[ApplicationEndDate]
,[VoteStartDate]
,[VoteEndDate]
,[Election])
VALUES
('8-9 3:00',
'8-30 3:00',
'8-30 4:00',
'8-31 4:00',
'8-31 5:00')
is there any commands for Mothership and StrategicPoint or i need to edit the DB??

 

[nutcrackerz]

if u dont want to help me give me some commands for GM or admin (new commnads):|:-<

 

[sami37]

if u dont want to help me give me some commands for GM or admin (new commnads):|:-<

Just learn to use your SQL server management.....
This is a tutorial not help SQL forum.....

 

[kelalung]

set probxx = 10000 , you mix successful 100%, and do same other table in db.

 

[MigLeader]

ok i am new here plz guys be easy on me, i am complatly new on MSSQL , how can i do:

3. Make a user in MSSQL.
Username: atum
Password: callweb
Select atum2_db_account as default database, and give db_owner rights to this user on atum2_db_account and on atum2_db_1

plz friends i am new to all of this , can anybody help me.


Thanks a lot for ur time

 

[loyalz12]

hey guys ..
the launcher always say that the server is under examination .. how can i fix it ..

 

[fifo789]

@Lounie you need the special code with you can like example :233 for admin so you got to DB Account search for your acc and edit the right and paste the codes