05.12.2016, 18:45
PHP код:
/////////--------------------------------------------XMAS OR NEW YEAR EVENT BY SHAHEEN---------------------///////////////
#include <a_samp>
#include <streamer>
#include <a_mysql>
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB "sanaviation"// You'll have to change this to the name of the database created in phpmyadmin
#define FILTERSCRIPT
new eventfinished[MAX_PLAYERS];
new gift1;
new gift2;
new gift3;
new gift4;
new gift5;
new gift6;
new gift7;
new gift8;
new gift9;
new gift10;
new gift11;
new gift12;
new gift13;
new gift14;
new gift15;
new gift16;
new gift17;
new gift18;
new gift19;
new gift20;
new pGiftTaken1;
new pGiftTaken2;
new pGiftTaken3;
new pGiftTaken4;
new pGiftTaken5;
new pGiftTaken6;
new pGiftTaken7;
new pGiftTaken8;
new pGiftTaken9;
new pGiftTaken10;
new pGiftTaken11;
new pGiftTaken12;
new pGiftTaken13;
new pGiftTaken14;
new pGiftTaken15;
new pGiftTaken16;
new pGiftTaken17;
new pGiftTaken18;
new pGiftTaken19;
new pGiftTaken20;
stock ConnectMySQL()
{
mysql_connect(SQL_HOST,SQL_USER,SQL_DB,SQL_PASS);
if(mysql_ping() == 1)
{
mysql_debug(1);
printf("[MYSQL]: Connection to `%s` succesful!",SQL_DB);
}
else
{
printf("[MYSQL]: [ERROR]: Connection to `%s` failed!",SQL_DB);
}
return 1;
}
forward OnAccountCheck(playerid);
public OnAccountCheck(playerid)
{
new Query[128];
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
format(Query, sizeof(Query), "SELECT * FROM `xmas` WHERE `nickname` = '%s'", name);
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows() > 0)
{
}
}
public OnPlayerConnect(playerid)
{
new
query[128],
playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
format(query, sizeof(query), "SELECT `pGiftTaken1`, `pGiftTaken2` FROM `xmas` WHERE `nickname` = '%e' LIMIT 1", playername);
mysql_reconnect();
mysql_query(query);
return true;
}
public OnFilterScriptInit()
{
print("\n--------------------------------------");
print(" Xmas Event by Shaheen Loaded");
print("--------------------------------------\n");
ConnectMySQL();
//--------------------------presents below below----------------------------//
gift1 = CreateDynamicPickup(19054, 2, 2056.8623,-2371.2200,16.1250, -1);
gift2 = CreateDynamicPickup(19055, 2, 2473.0042,-2696.7883,3.0000, -1);
gift3 = CreateDynamicPickup(19056, 2, 1503.5959,-2087.5537,28.6624, -1);
gift4 = CreateDynamicPickup(19057, 2, 293.9831,-1500.7661,24.9219, -1);
gift5 = CreateDynamicPickup(19078, 2, 366.5381,-2072.0442,8.0156, -1);
gift6 = CreateDynamicPickup(19078, 2, -1354.5767,-1.1554,6.0000, -1);
gift7 = CreateDynamicPickup(19057, 2, -1944.6064,275.6864,41.0471, -1);
gift8 = CreateDynamicPickup(19056, 2, -1968.7198,110.4410,27.6875, -1);
gift9 = CreateDynamicPickup(19055, 2, -1965.6179,-795.4418,35.2953, -1);
gift10 = CreateDynamicPickup(19054, 2, 1319.4631,1253.9078,14.2731, -1);
gift11 = CreateDynamicPickup(19054, 2, 1319.5500,2211.8184,12.0156, -1);
gift12 = CreateDynamicPickup(19054, 2, 2095.8318,2521.6245,10.8225, -1);
gift13 = CreateDynamicPickup(19078, 2, 2005.7183,2923.4695,48.3125, -1);
gift14 = CreateDynamicPickup(19078, 2, 279.0525,1989.7212,26.4634, -1);
gift15 = CreateDynamicPickup(19056, 2, -2316.5928,-1712.1986,481.3264, -1);
gift16 = CreateDynamicPickup(19056, 2, -1996.5066,-1546.1266,84.7252, -1);
gift17 = CreateDynamicPickup(19056, 2, -62.5364,44.3937,6.4766, -1);
gift18 = CreateDynamicPickup(19078, 2, 154.9342,-273.4686,5.4838, -1);
gift19 = CreateDynamicPickup(19078, 2, 2367.1040,-112.5147,29.7294, -1);
gift20 = CreateDynamicPickup(19056, 2, 1976.1938,-2380.4646,13.5469, -1);//lv present
return 1;
}
/*public OnPlayerConnect(playerid)
{
SendClientMessage(playerid,0xFF9900AA,"Santa Clause has lost his present around Sanandreas. Find it and steal his Gifts !");
return 1;
}*/
public OnPlayerPickUpDynamicPickup(playerid, pickupid)
{
if(pickupid == gift1)
{
if(pGiftTaken1 == 0)
{
pGiftTaken1 = 1;
SendClientMessage(playerid,0x912334,"You have Found Present Number 1. Keep Searching for the remaining presents !");
}
i am now stucked at getting data retrieved from database
how to do it >
the default port is 3306 but mysql8 is faster and better than 5.7