Tessék
/*
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `karakterek`;
CREATE TABLE `karakterek` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Nev` varchar(32) NOT NULL,
`Admin` int(10) NOT NULL,
`Szint` int(10) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
INSERT INTO `karakterek` VALUES (\'1\', \'Kyosuke_Hiroshi\', \'5555\', \'32\');
INSERT INTO `karakterek` VALUES (\'2\', \'Kyosuke_Hirooshi\', \'5554\', \'31\');
*/
#include <a_samp>
#include <a_mysql>
new sql_ID;
#define SQL_Host \"127.0.0.1\"
#define SQL_User \"root\"
#define SQL_Jelszo \"asdasd\"
#define SQL_Adatbazis \"tester\"
#define get_int(%1,%2,%3) (%3 = cache_get_field_content_int(%1,%2))
#define get_string cache_get_field_content
#define DIALOG_1 1
main()
{
}
public OnGameModeInit()
{
mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG, LOG_TYPE_TEXT);
sql_ID = mysql_connect(SQL_Host, SQL_User, SQL_Adatbazis, SQL_Jelszo);
SetGameModeText(\"Blank Script\");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}
public OnGameModeExit()
{
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
if (strcmp(\"/karik\", cmdtext, true, 10) == 0)
{
new query[32];
format(query,sizeof(query),\"SELECT * FROM karakterek\",0);
mysql_tquery(sql_ID,query,\"Karakterek\",\"i\",playerid);
return 1;
}
return 0;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == 1)
{
if(response)
{
new query[128];
format(query,sizeof(query),\"SELECT * FROM karakterek where Nev=\'%s\'\",inputtext);
mysql_tquery(sql_ID,query,\"KarakterekStat\",\"i\",playerid);
}
}
return 1;
}
forward KarakterekStat(playerid);
public KarakterekStat(playerid)
{
new nums,fields;
cache_get_data(nums,fields);
new a,sz,nev[32],adatok[128];
if(nums)
{
get_int(0,\"Admin\",a);
get_int(0,\"Szint\",sz);
get_string(0,\"Nev\",nev);
format(adatok,sizeof(adatok),\"Admin: %d || Szint: %d || Név: %s\",a,sz,nev);
}
ShowPlayerDialog(playerid,0,DIALOG_STYLE_MSGBOX,\"Adatok\",adatok,\"OK\",\"\");
return 1;
}
forward Karakterek(playerid);
public Karakterek(playerid)
{
new nums,fields,formazas[512],nev[32];
cache_get_data(nums, fields);
if(nums)
{
new i = -1;
for(;++i < nums;)
{
get_string(i,\"Nev\",nev);
if(i == 0)
{
format(formazas,sizeof(formazas),\"%s\",nev);
}
else
{
format(formazas,sizeof(formazas),\"%s\\n%s\",formazas,nev);
}
}
ShowPlayerDialog(playerid,DIALOG_1,DIALOG_STYLE_LIST,\"Karakterek\",formazas,\"OK\",\"Mégse\");
}
else
{
SendClientMessage(playerid,-1,\"Nincs karakter!\");
}
return 1;
}
SQL táblával mellékelve amit beimportálsz.
Ez tuti jó leteszteltem.
Üzenetek megjelenítése
kuvva nehéz volt de megérte