Searching MySQL Login/register

[BlackNova]

Hey

i´m working on a new Reallife Server for MTA but i need a little bit help

To start working on the GM i need a Base ( Mysql Login/Register System) if i have the base i can learn mysql by looking at the login/register System.

Can any one Code an Simple Login/Register System ? (Only Username,Passwort,first name,lastname,IP,Born Date

Here iss an finished GUI :

Login:

GUIEditor_Window = {}
GUIEditor_Button = {}
GUIEditor_Label = {}
GUIEditor_Edit = {}
 
GUIEditor_Window[1] = guiCreateWindow(436,368,371,378,"Login",false)
GUIEditor_Label[1] = guiCreateLabel(101,153,103,19,"Username:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[1],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[1],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[1],"left",false)
guiSetFont(GUIEditor_Label[1],"default-bold-small")
GUIEditor_Label[2] = guiCreateLabel(102,179,86,21,"Passwort:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[2],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[2],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[2],"left",false)
guiSetFont(GUIEditor_Label[2],"default-bold-small")
username = guiCreateEdit(166,152,108,20,"",false,GUIEditor_Window[1])
passwort = guiCreateEdit(161,177,108,20,"",false,GUIEditor_Window[1])
GUIEditor_Button[1] = guiCreateButton(76,260,111,33,"Login",false,GUIEditor_Window[1])
GUIEditor_Button[2] = guiCreateButton(203,260,111,33,"Regestrieren",false,GUIEditor_Window[1])
GUIEditor_Label[3] = guiCreateLabel(55,37,257,64,"Project Reallife",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[3],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[3],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[3],"left",false)
guiSetFont(GUIEditor_Label[3],"sa-header")

Register :

GUIEditor_Window = {}
GUIEditor_Button = {}
GUIEditor_Checkbox = {}
GUIEditor_Label = {}
GUIEditor_Edit = {}
 
GUIEditor_Window[1] = guiCreateWindow(436,368,371,408,"Regestration",false)
GUIEditor_Label[1] = guiCreateLabel(97,225,168,19,"Geburtsdatum:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[1],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[1],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[1],"left",false)
GUIEditor_Label[2] = guiCreateLabel(98,271,103,21,"Aktivierungs Code:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[2],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[2],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[2],"left",false)
gb_datum = guiCreateEdit(181,224,108,20,"",false,GUIEditor_Window[1])
akt_code = guiCreateEdit(203,269,108,20,"",false,GUIEditor_Window[1])
GUIEditor_Button[1] = guiCreateButton(77,357,111,33,"Regestrieren",false,GUIEditor_Window[1])
GUIEditor_Button[2] = guiCreateButton(204,357,111,33,"Clear",false,GUIEditor_Window[1])
GUIEditor_Label[3] = guiCreateLabel(55,32,257,64,"Project Reallife",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[3],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[3],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[3],"left",false)
guiSetFont(GUIEditor_Label[3],"sa-header")
GUIEditor_Label[4] = guiCreateLabel(9,154,354,13,"-----------------------------------------------------------------------------------------",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[4],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[4],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[4],"left",false)
GUIEditor_Label[5] = guiCreateLabel(97,106,103,21,"Username:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[5],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[5],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[5],"left",false)
GUIEditor_Label[6] = guiCreateLabel(98,132,86,23,"Passwort:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[6],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[6],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[6],"left",false)
username = guiCreateEdit(162,105,108,20,"",false,GUIEditor_Window[1])
passwort[4] = guiCreateEdit(157,130,108,20,"",false,GUIEditor_Window[1])
GUIEditor_Label[7] = guiCreateLabel(97,173,103,21,"Vorname:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[7],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[7],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[7],"left",false)
GUIEditor_Label[8] = guiCreateLabel(98,198,86,23,"Nachname:",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[8],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[8],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[8],"left",false)
vorname = guiCreateEdit(151,172,108,20,"",false,GUIEditor_Window[1])
nachname = guiCreateEdit(161,197,108,20,"",false,GUIEditor_Window[1])
GUIEditor_Label[9] = guiCreateLabel(9,248,354,14,"-----------------------------------------------------------------------------------------",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[9],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[9],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[9],"left",false)
GUIEditor_Checkbox[1] = guiCreateCheckBox(106,307,172,21,"Ich Akzeptiere die Regeln.",false,false,GUIEditor_Window[1])
GUIEditor_Label[10] = guiCreateLabel(9,291,354,14,"-----------------------------------------------------------------------------------------",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[10],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[10],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[10],"left",false)
GUIEditor_Label[11] = guiCreateLabel(318,271,49,20,"Info",false,GUIEditor_Window[1])
guiLabelSetColor(GUIEditor_Label[11],255,255,255)
guiLabelSetVerticalAlign(GUIEditor_Label[11],"top")
guiLabelSetHorizontalAlign(GUIEditor_Label[11],"left",false)
guiSetFont(GUIEditor_Label[11],"default-bold-small")

Database

CREATE TABLE `user` (
 `ID` int(11) NOT NULL AUTO_INCREMENT,
 `username` text NOT NULL,
 `passwort` text NOT NULL,
 `first_name` text NOT NULL,
 `last_name` text NOT NULL,
 `born_date` text NOT NULL,
 `ip` text NOT NULL,
 PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

[dzek (varez)]

this is not a request forum

its cool you have generated GUI, but scripting it's a lot of job.. why somebody would spend few hours for doing something just for you?

this forum is made for helping people when they are stuck and some problem, or need general advice

[50p]

You should never start working on an roleplaying gamemode if you don't understand scripting. What you showed us here is GUI code that was made for you but don't expect us to make the login system for you.