[Script] SQL Register

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:
http://img.photobucket.com/albums/v2...SCF/guide1.jpg
Step 2:
http://img.photobucket.com/albums/v2...SCF/guide2.jpg
Step 3:
http://img.photobucket.com/albums/v2...SCF/guide3.jpg
Step 4:
http://img.photobucket.com/albums/v2...SCF/guide4.jpg
Finishing product:
http://img.photobucket.com/albums/v2...SCF/guide5.jpg

The Code to put in SQL Query manager:

Code:

---

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

Nice guide Stup :)

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

Just relised this isnt a release lol

can a mod move to guide section? :P
Thanks

thanks i needed this :D..

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

Better is to just

Code:

---

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

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).

Indeed :p

Also

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

b) Use some loginsoftware that removes the binary passwords.

Quote:

---

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

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

PHP Code:

---

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.

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






.

KOAM is a total crap.
HF with using it.

Dragons lair? wtf. should I know it?

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

But as stated rombojumbo, this is quicker and easier then downloading extraction and looking thru options blah blah all the bullshit... 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.