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;