Sql Files Guide

Sparda · Post by **Sparda** » Sat May 14, 2005 1:23 am

You see the table ACCOUNT_T, you make a new acount in there. Also that table is related to WS1_T and WS2_T. Make sure your account has a iAccountID. Well after that that's where i'm stuck too. Can't seem to login

GoldenBoy · Post by **GoldenBoy** » Sat May 14, 2005 1:28 am

Is there an acct maker my friend (well know extasis admin ) Drazz started to code a tool for that, last time I talked with him he was about to release it.

Sorry guys for releasing that MESH of files, I think I will make some stuff to easy-setup the whole net SQL stuff too. just Im short of time these days folks..

Sparda · Post by **Sparda** » Sat May 14, 2005 1:30 am

hey gb, u know any idea why i can't login? i've made an account and stuff but when i try login it says non-existing account and all servers are active.

GoldenBoy · Post by **GoldenBoy** » Sat May 14, 2005 1:38 am

BTW, Sparda I think I had somewhere my old SQL dump of accounts, maybe you have some mistakes and can't log, there is a little trick.. using the 2.03 client (the one that make accounts in game) you can use it to create 1 account.

Sparda · Post by **Sparda** » Sat May 14, 2005 1:57 am

Tested with the v2.03 client. Doesn't wanna make account either.

GoldenBoy · Post by **GoldenBoy** » Sat May 14, 2005 2:05 am

Sparda wrote: Tested with the v2.03 client. Doesn't wanna make account either.

Check ur user SQL rights, it's looks like your SQL side is not working like it should do.

Sparda · Post by **Sparda** » Sat May 14, 2005 2:42 am

I've configured my tables permission. when i try to make a new account with v2.03 with an account that's i've entered in the table manually it says cannot create new account, it already exists, so that's working alright. the client successfully creates a new account but there's no new account in the table.

i dunno if this helps but when i login with my pre-made account the mainlogserver prints this

(Pay) RequestionLoginHandler: Sparda, 1, WS1
sCheckAccount(0)
(0) sRet Value(1) iAccountID (1002)
(PAY)_cDecodeAccountContents (status : 1) (time left: -858993460)

CDWriter · Post by **CDWriter** » Sat May 14, 2005 3:55 am

Hmmm v2.03 client will do that, someone tell me where to get that?
i have the 2.02 version does nothing to mssql

Drajwer · Post by **Drajwer** » Sat May 14, 2005 8:08 am

is that work with mssql server 2005? :huh:

123456 · Post by **123456** » Sat May 14, 2005 8:55 am

Guys if you have noticed many of those files you have mentioned is missing(there are nowere here in the forum)... because of that you are not able to do nothing. <_<

So I don't see the sense of it.

Regards.

DarkieDuck · Post by **DarkieDuck** » Sat May 14, 2005 10:48 am

isnt there supposed to be a user "hell" aswell?
without that user u get access right errors

Smashing · Post by **Smashing** » Sat May 14, 2005 11:09 am

they have made it to hbss

fucking cunt thieves

tyteman · Post by **tyteman** » Sat May 14, 2005 1:03 pm

$msconnect=mssql_connect("213.149.231.16","outpost","**********");

Raptile · Post by **Raptile** » Sat May 14, 2005 2:02 pm

$dbhost = "xxx.168.x.xxx";

// Enter the username to connect to the db
$dbuser = "sa";

// Enter the password for the SQL Server
$dbpasswd = "xxxxxxxxxxx";
}

//Database Name
$db = 'mainlogin';

$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host","$alogin","$apass");
$msdb=mssql_select_db("$db",$msconnect);

Post by **binarydata** » Mon May 16, 2005 2:59 am

the sql eval is being an igger

and ya, that connects to the db, but make the acct