Db Sql Format

CDWriter · Post by **CDWriter** » Mon May 16, 2005 3:36 am

OK lets finaly put this to bed. Anyone here please reply with a active account...Alot of us here are geting AccountID not found blah blah or something like that , Is what many of us are geting when we try to log on to the mainlog server .......and what we all need to get the 3.51 running .........i have racked my bain long enough iam calling for HELP so yes i guess iam a noob when it comes to MSSQL .....Here is what i have so far and have tryed many different Var. with no luck....

Code: Select all

cAccountID   cPassword   IAccountID   cLoginIpAddress   IsGMAccount    CreateDate   LoginDate   LogoutDate   BlockDate  

Account      outpost      1003         192.168.1.206         1          4/5/2003      <NULL>      <NULL>     <NULL>


  cRealName   cSSN         cEmail          cCharRecord         cQuiz          cAnswer         ValidDate        iValidTime
     
  Steve     555-55-5555 oupost@ruleshb.com    5        Goes on the ground        bug             4/5/2003         1200

ok Someone fill in the blanks that has account on there server lets help everyone out here and finish this login bug off for everyone.......

this above is still incorrect and Does not show any Accounts Avaiable

.....could someone help me and others and give us 1 account to go off of and understand this a lot better .... :rolleyes:

MY Setup in MSSQL

Mainlog
Fixed so now are incorrect Picture

ws1
Fixed so now are incorrect Picture

MSSQL is not my forte.....

Your see anything missing here let me know what to add or if i need to fix something , this way others may follow suit......

BIG thanks
CDWriter

tyteman · Post by **tyteman** » Mon May 16, 2005 3:46 am

put an ss of acc table on ml
and the character on wl
both opened

erm... i need an ss of the character table in wl and the account table in the ml

CDWriter · Post by **CDWriter** » Mon May 16, 2005 4:02 am

ss of ml

hope these help ?

Post by **binarydata** » Mon May 16, 2005 4:43 am

edit: nvm

CDWriter · Post by **CDWriter** » Mon May 16, 2005 8:59 am

Thanks binarydata but this should not have been pined

this is a bug for me....... and i need someone who has set up a account to share there info on how they did it and what they added to it ....

-Pitu- · Post by **-Pitu-** » Mon May 16, 2005 9:38 am

someone answer cd writer!!!!!!!! we all need it!!

Drajwer · Post by **Drajwer** » Mon May 16, 2005 12:13 pm

hmmmm where i can download sql server manager?

cant find on google

DarkieDuck · Post by **DarkieDuck** » Mon May 16, 2005 12:46 pm

i said it in another post , i also had the problem , and if i can remember correct it had somethnig todo with the accountID

I prolly got a sample somewere , will look into it later

Sparda · Post by **Sparda** » Mon May 16, 2005 1:35 pm

Does romeo87920 ring any bells? i found this in MainLServer.exe

GoldenBoy · Post by **GoldenBoy** » Mon May 16, 2005 2:48 pm

CDWriter wrote:

Code: Select all

cAccountID   cPassword   IAccountID   cLoginIpAddress   IsGMAccount    CreateDate   LoginDate   LogoutDate   BlockDate  

Account      outpost      1003         192.168.1.206         1          4/5/2003      <NULL>      <NULL>     <NULL>


  cRealName   cSSN         cEmail          cCharRecord         cQuiz          cAnswer         ValidDate        iValidTime
     
  Steve     555-55-5555 oupost@ruleshb.com    5        Goes on the ground        bug             4/5/2003         1200

joehayashi 2305CTjoe 48317 144.136.80.154 0 4/3/2002 4/5/2004 8:39:00 PM 4/5/2004 10:38:00 PM 1/1/2000 joelim - blackjoe06061979@hotmail.com i happy 3/30/2004 0

Thats one of my SQL acct dump

Slayer · Post by **Slayer** » Mon May 16, 2005 3:44 pm

Sparda wrote: Does romeo87920 ring any bells? i found this in MainLServer.exe

Goldenboy already said it was some old HBChina password or whatever..

Aryes · Post by **Aryes** » Mon May 16, 2005 4:34 pm

Try using a packet reader and get the mssql query that is sent to the mssql server. I'll try something when I get my pc back, but will still take a while...

MorganBlack · Post by **MorganBlack** » Mon May 16, 2005 5:38 pm

Do you know any sniffer that can log loopback device or named pipes?

DarkieDuck · Post by **DarkieDuck** » Mon May 16, 2005 6:10 pm

also input the dates

like
1/1/2000 00:00:00

CDWriter · Post by **CDWriter** » Mon May 16, 2005 8:29 pm

no i think there some stuff missing in MSSQL db that we all dont have ....

example from Mainlogin

select * from CODE_T where cKEYCODE = '%s'

CODE_T - cKETCODE <---- whats this ?

iam going throu the mainlog now so i get any where ill let u all know...

and something has to reflect the accountID based to the Char or cAccount