SQL:
/*
Navicat MySQL Data Transfer
Source Server : Localhost
Source Server Version : 50505
Source Host : localhost:3306
Source Database : regisztracio
Target Server Type : MYSQL
Target Server Version : 50505
File Encoding : 65001
Date: 2016-11-03 17:33:44
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `felhasznalok`
-- ----------------------------
DROP TABLE IF EXISTS `felhasznalok`;
CREATE TABLE `felhasznalok` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`JatekosNev` varchar(24) NOT NULL DEFAULT \'Nincs\',
`Jelszo` varchar(32) NOT NULL DEFAULT \'----\',
`Penz` int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of felhasznalok
-- ----------------------------
INSERT INTO `felhasznalok` VALUES (\'1\', \'Her0ic\', \'A8F5F167F44F4964E6C998DEE827110C\', \'0\');
Pawn:
#include <a_samp>
#include <a_mysql>
#include <md5>
new sql_ID;
new adatok[128];
#define mysql_get_int(%1,%2,%3) (%3 = cache_get_field_content_int(%1,%2))
#define mysql_get_float(%1,%2,%3) (%3 = cache_get_field_content_float(%1,%2))
#define mysql_get_string cache_get_field_content
#define doQuery(%0,%1) mysql_tquery(sql_ID,(Format(adatok,(%0), %1), adatok),\"\",\"\")
#define Format(%1,%2,%3) format(%1,sizeof(%1),(%2),%3)
#define forpublic%0(%1) forward%0(%1); public%0(%1)
main(){}
enum
{
DIALOG_LOGIN,
DIALOG_REG
}
public OnGameModeInit()
{
mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG, LOG_TYPE_TEXT);
// Host User Adatbazis Jelszo
sql_ID = mysql_connect(\"localhost\",\"root\",\"regisztracio\",\"asdasd\");
SetGameModeText(\"Alap Mysql es Regisztracio\");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}
stock PlayerName(playerid)
{
new nev[MAX_PLAYER_NAME];
GetPlayerName(playerid,nev,MAX_PLAYER_NAME);
return nev;
}
enum PlayerEnum
{
pBelepve,
pPenz
}
new PlayerInfo[MAX_PLAYERS][PlayerEnum];
public OnGameModeExit()
{
mysql_close(sql_ID);
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
TogglePlayerSpectating(playerid, true);
if(PlayerInfo[playerid][pBelepve] == 0)
{
new query[128];
Format(query,\"SELECT * FROM felhasznalok WHERE JatekosNev=\'%s\'\",PlayerName(playerid));
mysql_tquery(sql_ID,query,\"Belepes\",\"i\",playerid);
}
return 1;
}
forpublic Belepes(playerid)
{
new nums,fields;
cache_get_data(nums,fields);
if(nums)
{
SendClientMessage(playerid,-1,\"Be vagy Regisztrálva!\");
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,\"Belépés\",\"Írd be a jelszavad\",\"OK\",\"\");
}
else
{
SendClientMessage(playerid,-1,\"Nem vagy beregisztrálva!\");
ShowPlayerDialog(playerid,DIALOG_REG,DIALOG_STYLE_INPUT,\"Regisztráció\",\"Írd be a jelszavad!\",\"OK\",\"\");
}
}
public OnPlayerConnect(playerid)
{
PlayerInfo[playerid][pBelepve] = 0;
PlayerInfo[playerid][pPenz] = 0;
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
return 1;
}
public OnPlayerSpawn(playerid)
{
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerText(playerid, text[])
{
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
if (strcmp(\"/mycommand\", cmdtext, true, 10) == 0)
{
// Do something here
return 1;
}
return 0;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
forpublic Beleptetes(playerid)
{
new nums,fields;
cache_get_data(nums,fields);
if(nums)
{
mysql_get_int(0,\"Penz\",PlayerInfo[playerid][pPenz]);
TogglePlayerSpectating(playerid, false);
SpawnPlayer(playerid);
GivePlayerMoney(playerid,PlayerInfo[playerid][pPenz]);
SetPlayerPos(playerid,0,0,5);
}
else
{
SendClientMessage(playerid,-1,\"Helytelen jelszó!\");
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,\"Belépés\",\"Írd be a jelszavad\",\"OK\",\"\");
}
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case DIALOG_LOGIN:
{
new query[128];
new szoveg[32];
Format(szoveg,\"%s\",inputtext);
mysql_real_escape_string(szoveg,szoveg);
Format(query,\"SELECT * FROM felhasznalok WHERE JatekosNev=\'%s\' AND Jelszo=\'%s\'\",PlayerName(playerid),md5(szoveg));
mysql_tquery(sql_ID,query,\"Beleptetes\",\"i\",playerid);
}
case DIALOG_REG:
{
new szoveg[32]
Format(szoveg,\"%s\",inputtext);
mysql_real_escape_string(szoveg,szoveg);
doQuery(\"INSERT INTO felhasznalok (JatekosNev,Jelszo) VALUES (\'%s\',\'%s\')\",PlayerName(playerid),md5(szoveg));
SendClientMessage(playerid,-1,\"Sikeresen Beregisztráltál, most már beléphetsz!\");
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,\"Belépés\",\"Írd be a jelszavad\",\"OK\",\"\");
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}
Link:
Itt pluginnal meg includeval letölthetőFunkciók:
belépés, regisztráció,pénz betöltés
Alap kari: Her0ic PW: asdasd
MD5 ös kódolás
TESZTELVE! MŰKÖDIK!
Üzenetek megjelenítése
en is kifogok esni de neked nem szabad