ma4B34uT

1#include a_samp
2#include mysql
3#include pawncmd
4#include sscanf
5
6#define P4S_HN "HostName"
7#define P4S_UN "UserName"
8#define P4S_PW "PassWord"
9#define P4S_DB "DataBase"
10
11public OnGameModeInit()
12{
13	new Query0[768];
14
15	mysql_init();
16	mysql_connect(P4S_HN, P4S_UN, P4S_PW, P4S_DB);
17
18	format(Query0, sizeof(Query0), "CREATE TABLE IF NOT EXISTS `P4S_TP` (`Name` VARCHAR(50) NOT NULL, `PosX` FLOAT NOT NULL, `PosY` FLOAT NOT NULL, `PosZ` FLOAT NOT NULL)");
19	mysql_query(Query0);
20	return 1;
21}
22
23public OnGameModeExit()
24{
25	mysql_close();
26	return 1;
27}
28
29CMD:warp(playerid, cmdtext[])
30{
31	new Teleport[32];
32	new Format0[256];
33	new Query0[384];
34	new Float:fX, Float:fY, Float:fZ;
35
36	if(sscanf(cmdtext, "s[32]", Teleport))
37	{
38	    return SendClientMessage(playerid, -1, "{FFFFFF}Wpisz {00FF00}/Warp [Teleport]");
39	}
40
41	format(Query0, sizeof(Query0), "SELECT * FROM `P4S_TP` WHERE `Name` = '%s'", Teleport);
42	mysql_query(Query0);
43
44	mysql_store_result();
45
46    if(mysql_num_rows() == 1)
47	{
48		mysql_fetch_field("Name", Teleport);
49		mysql_fetch_field("PosX", Query0);
50		fX = floatstr(Query0);
51		mysql_fetch_field("PosY", Query0);
52		fY = floatstr(Query0);
53		mysql_fetch_field("PosZ", Query0);
54		fZ = floatstr(Query0);
55
56	    SetPlayerPos(playerid, fX, fY, fZ);
57
58	    format(Format0, sizeof(Format0), "{FFFFFF}Teleportowałeś/aś się na {00FF00}%s", Teleport);
59	    SendClientMessage(playerid, -1, Format0);
60	}
61
62	mysql_free_result();
63	return 1;
64}
65
66CMD:addwarp(playerid, cmdtext[])
67{
68	new Name[32];
69	new Format0[1024];
70	new Query0[384];
71    new Float:fX, Float:fY, Float:fZ;
72
73	if(sscanf(cmdtext, "s[32]", Name))
74	{
75	    return SendClientMessage(playerid, -1, "{FFFFFF}Wpisz {00FF00}/Addwarp [Name]");
76	}
77	
78	GetPlayerPos(playerid, fX, fY, fZ);
79	
80	format(Query0, sizeof(Query0), "INSERT INTO `P4S_TP` (`Name`, `PosX`, `PosY`, `PosZ`) VALUES ('%s', '%f', '%f', '%f')", Name, fX, fY, fZ);
81	mysql_query(Query0);
82	
83	format(Format0, sizeof(Format0), "{FFFFFF}Dodałeś/aś teleport o nazwie {00FF00}%s {FFFFFF}w miejscu o koordynatach {00FF00}%f{FFFFFF}X, {00FF00}%f{FFFFFF}Y, {00FF00}%f{FFFFFF}Z", Name, fX, fY, fZ);
84    SendClientMessage(playerid, -1, Format0);
85	return 1;
86}
87
88CMD:delwarp(playerid, cmdtext[])
89{
90	new Name[32];
91	new Format0[256];
92	new Query0[384];
93	
94	if(sscanf(cmdtext, "s[32]", Name))
95	{
96	    return SendClientMessage(playerid, -1, "{FFFFFF}Wpisz {00FF00}/Delwarp [Name]");
97	}
98	
99	format(Query0, sizeof(Query0), "DELETE FROM `P4S_TP` WHERE `Name` = '%s'", Name);
100	mysql_query(Query0);
101	
102	format(Format0, sizeof(Format0), "{FFFFFF}UsunÄ…Å‚eÅ›/aÅ› teleport o nazwie {00FF00}%s", Name);
103	SendClientMessage(playerid, -1, Format0);
104	return 1;
105}