[RELEASE] BOI Server Files + Server Tools + GM tools

07/31/2012 22:30 Hackheaven#736
Edit trying one more thing i think will work....


Register page doesnt work at all for me either
07/31/2012 22:32 Siqko#737
Can someone send me a register page that works? ( Sorry for leeching :( )
07/31/2012 22:38 buriks#738
Check these out I custom made these
-[Only registered and activated users can see links. Click Here To Register...] <<Gives out Primal Gear for all classes
-[Only registered and activated users can see links. Click Here To Register...] <<Gives out eloquent items for all classes and an extra suprise:)
-[Only registered and activated users can see links. Click Here To Register...] <<Cleaned out the old one and uploaded you could possibly need and I tried making it as neat as possible also its has all major pet stuff, fashions and mounts.
07/31/2012 22:40 Hackheaven#739
SELECT @userid = id FROM account where name = @username

This is telling it to give zen to mssql in the account table.... yet there are no accounts in the account table to give zen to

The chars are in mysql on linux i could not find any account or char info in mssql


So what i get from that is we need a register page that registers a user in mssql (so we dont use blah/123 as a login


So myself i can not get zen since i odnt have an account/user/char in mssql

So i guess ill tyr to get the register page to work in mssql and see if it then does add zen since there are no *zen* tables in mysql only in mssql (called cash not zen in the tables)
07/31/2012 22:45 xXSuperflyXx#740
Quote:
Originally Posted by buriks View Post
Check these out I custom made these
-[Only registered and activated users can see links. Click Here To Register...] <<Gives out Primal Gear for all classes
-[Only registered and activated users can see links. Click Here To Register...] <<Gives out eloquent items for all classes and an extra suprise:)
-[Only registered and activated users can see links. Click Here To Register...] <<Cleaned out the old one and uploaded you could possibly need and I tried making it as neat as possible also its has all major pet stuff, fashions and mounts.
i cant d/l from there any chance u can put in rar file and attach to post?
07/31/2012 22:48 Hackheaven#741
The password you get from the register page on here wont even work in the mssql table it says wrong info

We need to convert it to binary
07/31/2012 22:49 buriks#742
Here
07/31/2012 22:54 Hackheaven#743
What is the password md5? or salt or nothing?
07/31/2012 22:55 MWO#744
can someone to help me to setup the server ... or learning me how i must to do what files must run ... programes etc please
07/31/2012 22:57 buriks#745
I use this website [Only registered and activated users can see links. Click Here To Register...]
To create the md5 then I add 0x to the front of it. Ex: Austin=229979fce5174c17d4645bf8752dae1e
So to input the password into MSSQL it would be 0x229979fce5174c17d4645bf8752dae1e
And to register this is the code
Code:
Insert Into users
(id, birthday, name, prompt, answer, idnumber, email, gender, passwd2)
Values
(ID#, 'YEAR-MONTH-DAY', 'Username', 123123, 123123, 123123, 'EMAIL', 1, PASSWORD)
Password=0xMD5

Make sure when you go to execute query that it is pointed toward PASSPORTBOIOLD db
07/31/2012 22:59 Hackheaven#746
Invalid value for cell (row 1, column 16)

The changed value in this cell was not recongnized as valied
.Net Framework Data Type: Byte[]

Trying paste 0x229979fce5174c17d4645bf8752dae1e into passwd2
07/31/2012 23:07 buriks#747
Make sure you replace
ID#= Integer
'YEAR-MONTH-DAY'=1993-01-01
'Username'= Username
Leave all 123123's alone
EMAIL= email
PASSWORD= 0xMD5
07/31/2012 23:09 MWO#748
hey can someone help me ?? i need to work in local please
07/31/2012 23:11 buriks#749
:D[Only registered and activated users can see links. Click Here To Register...]
07/31/2012 23:19 Hackheaven#750
I know how to do that :P i did it but i did this once and wasnt able to login using the info

Trying again with an id of 2 not 1 this time and im still getting -1 when i enter zen code so kinda sure it isnt working (and shouldnt be since there is still no data in accounts only in users)

Password wrong when i try to enter with 0xmd5