· 8 years ago · Mar 12, 2018, 09:24 PM
1cmd:kreirajkapiju(playerid, params[]) {
2
3 new Float:X, Float:Y, Float:Z, objid, query[ 221 ];
4 if(sscanf(params, "d", objid)) return SCM(playerid, -1, "Picka si - /kreirajkapiju [ID Objekta]");
5 GetPlayerPos(playerid, X,Y,Z);
6 KapijaInfo[ Test+1 ][ PosX ] = X;
7 KapijaInfo[ Test+1 ][ PosY ] = Y;
8 KapijaInfo[ Test+1 ][ PosZ ] = Z;
9 KapijaInfo[ Test+1 ][ objID ] = objid;
10 mysql_format(g_SQL, query, sizeof query, "INSERT INTO `kapije` (`Lokacija_X`, `Lokacija_Y`, `Lokacija_Z`, `Object_ID`) VALUES ('%f', '%f', '%f', '%e')", X, Y, Z, objid);
11 mysql_tquery(g_SQL, "CREATE TABLE IF NOT EXISTS `kapije` (`id` int(11) NOT NULL AUTO_INCREMENT,`Lokacija_X` varchar(24) NOT NULL,`password` char(64) NOT NULL,`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`deaths` mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");
12 return 1;
13}