Making an account system using MSSQL

[Irlandec]

Hello everyone! Can someone explain me how to code these commands like /create ,  /save , /login , /logout , using MSSQL by Dual ?

I think I can understand the usage of this functions

[CurryWurst]

Hold on. Currently I'm writing an update for it, will be out soon.
Dealing with a database will be much easier then

[Irlandec]

Hold on. Currently I'm writing an update for it, will be out soon.
Dealing with a database will be much easier then

That's nice to hear.

I was thinking about these things: or example, define values of 'name' 'pass' (pass in MD5) , so it looks like this:

Code: [Select]

function OnPlayerCommand(ID: Byte; Text: string): boolean;
var
  name: string;
  pass: integer;
  Logged: array[1..32] of boolean;
begin
  name := GetPiece(LowerCase(Text), ' ', 1);
  pass := MD5String(inttostr(GetPiece(LowerCase(Text), ' ', 2));
 if GetPiece(LowerCase(Text), ' ', 0) = '/create' then begin
   if not Logged[ID] then begin
     _CreateRow(name + #9 + pass + #9 + 'MyData' + #9 + '10');
     end;
  end;
It is wrong , but i hope someone will get an idea what im trying to do

[Irlandec]

Kudos to CurryWurst , these commands were explained and coded.


BTW, If someone wants to create account system , using MSSQL functions , feel free to ask questions here - I will try to explain