[Script] SQL Register

[Stup]

Not really a release, but very handly for the people who just want to make files, log on and test them, log off... No XAMPP Crap.

Credits first off to Swarm133 for telling me this, found old msn logs, saved me ^^

Screenshot step by step:
Step 1:

Step 2:

Step 3:

Step 4:

Finishing product:

The Code to put in SQL Query manager:

SET IDENTITY_INSERT Login On INSERT INTO Login(UID, ID, PWD, Birth, Type, ExpTime) VALUES ('1', 'andy', 0x488D094B, '19000101', '0', '4000') SET IDENTITY_INSERT Login Off

This Code makes your login
id: andy
pass: andy

If you already have UID's in your database (Accounts) simply change:
('1', 'andy', 0x488D094B, '19000101', '0', '4000')
the bold red underline number to lets say "5432" or whatever you want that isnt already taken in the db (My db has only 2 accounts, so i could make that ('3', .....)

Thats it.. it think ^^

Have fun..
hope it helps

 

[2Kxx]

Nice guide Stup

 

[RuleZ]

and if i want change pw? ......... just kidding nice guide for people who want local server

 

[Stup]

Just relised this isnt a release lol

can a mod move to guide section?
Thanks

 

[tulhio]

thanks i needed this ..

 

[General]

Hmm not a good idea to use identity insert... Then you have to manually add every UID.

Better is to just

INSERT INTO Login(ID, PWD, Birth, Type, ExpTime) VALUES ('andy', 0x488D094B, '19000101', '0', '4000')

Then the column will automatically assign a UID 1 greater than the previous

 

[DeathArt]

Just to let you know, IDENTITY columns work for the Login table, but not for the player table.

The DB server is designed to manually calculate the increment value, and thus having a IDENTITY column causes a error (since you're not allowed to set it manually).

 

[General]

Indeed

 

[DeathArt]

Also

a) Stop using SQLServer 2000 ffs! Use 2005 Express, it's FREE and LEGAL.
http://www.microsoft.com/sql/editions/express/default.mspx

b) Use some loginsoftware that removes the binary passwords.

 

[Stup]

Not really a release, but very handly for the people who just want to make files, log on and test them, log off... No XAMPP Crap.

is what i stated in first post

 

[DeathArt]

Yes, but everybody who didden't knew this allready, won't have a clue how to make the binary passwords

 

[mejniok]

unit crypto;

interface

uses SysUtils;

 const
        CharAr : array[1..91] of char =
        ('!','"','#','$','%','&','\',
        '(',')','*','+',',','-','.',
        '/','0','1','2','3','4','5',
        '6','7','8','9',':',';','<',
        '=','>','?','@','A','B','C',
        'D','E','F','G','H','I','J',
        'K','L','M','N','O','P','Q',
        'R','S','T','U','V','W','X',
        'Y','Z','[','\',']','^','_',
        '`','a','b','c','d','e','f',
        'g','h','i','j','k','l','m',
        'n','o','p','q','r','s','t',
        'u','v','w','x','y','z','{');

 const
        ByteAr : array[1..91] of byte =
        ($95,$88,$9D,$4C,$F2,$3E,$BB,
         $C0,$7F,$18,$70,$A6,$E2,$EC,
         $77,$2C,$3A,$4A,$91,$5D,$7A,
         $29,$BC,$6E,$D4,$40,$17,$2E,
         $CB,$72,$9C,$A1,$FF,$F3,$F8,
         $9B,$50,$51,$6D,$E9,$9A,$B8,
         $84,$A8,$14,$38,$CE,$92,$5C,
         $F5,$EE,$B3,$89,$7B,$A2,$AD,
         $71,$E3,$D5,$BF,$53,$28,$44,
         $33,$48,$DB,$FC,$09,$1F,$94,
         $12,$73,$37,$82,$81,$39,$C2,
         $8D,$7D,$08,$4F,$B0,$FE,$79,
         $0B,$D6,$23,$7C,$4B,$8E,$06);

function ConvertString(Str: String): String;

implementation

function CharAsByte(Ch: Char): Byte;
var i: byte;
begin
Result:=0;

for i:=1 to 91 do
 if CharAr[i]=Ch then
  Result:=ByteAr[i];
end;

function ConvertString(Str: String): String;
var i: integer;
    r: string;
begin
r:='';

 for i:=1 to length(str) do
  begin
   r:=r+IntToHex(CharAsByte(Str[i]),2);
  end;
  Result:='0x'+r;
end;

end.

Maybe for some1 will be useful.
Rgrdz.

 

[ronjambo]

maybe a quick visit to deatharts repository on dragonslair ,
would be usefull to that same somebody and void this thread

or server tools thread koam






.

 

[mejniok]

KOAM is a total crap.
HF with using it.

Dragons lair? wtf. should I know it?

 

[Stup]

dragons lair is Deatharts lil tools area ^^
useful poop in there.

But as stated rombojumbo, this is quicker and easier then downloading extraction and looking thru options blah blah all the shenanigans... as stated its just for a offline to server to test you files.
if u want to pimp your own weapons ? or whatever and run around training with no one else lol, i dunno... thats just sad ^^

mod can just lock this?, the extra info needed and the primary guide is all there. Thanks and all that, i dont need it, but appreciated.

 

[Stup]

Im not a mod :S

 

[ronjambo]

lock it yourself

click the thread tools button at top of page

 

[hero322]

uh nub... alpha members dont have the lock options... or donated red members...

its a gay thing admins forgot to add... alpha is so useless really all they got is an access to the request to change name poop lol....... *hidden thread*

 

[foxx]

alpha is so useless really all they got is an access to the request to change name poop lol....... *hidden thread*

Unfortunately, you are not right.