MySql Store System Base PAWN by Rokzlive

#define FILTERSCRIPT

#include <a_samp>
#include <mysql>
#include <streamer>
#include <sscanf2>
#include <ZCMD>
#define SQL_Host "yourhost"
#define SQL_Username "yourusername"
#define SQL_Password "yourpassword"
#define SQL_Database "yourdatabase"
#define COLOR_LIGHTBLUE 0x33CCFFFF
#define COLOR_RED 0xAA3333FF
#define COLOR_GREY 0xAFAFAFFF
#define COLOR_YELLOW 0xFFFF00FF
#define COLOR_PINK 0xFF66FFFF
#define COLOR_BLUE 0x0000BBFF
#define COLOR_WHITE 0xFFFFFFFF
#define COLOR_DARKRED 0x660000FF
#define COLOR_ORANGE 0xFF9900FF
#define COLOR_BRIGHTRED 0xFF0000FF
#define COLOR_INDIGO 0x4B00B0FF
#define COLOR_VIOLET 0x9955DEFF
#define COLOR_LIGHTRED 0xFF99AAFF
#define COLOR_SEAGREEN 0x00EEADFF
#define COLOR_GRAYWHITE 0xEEEEFFFF
#define COLOR_LIGHTNEUTRALBLUE 0xabcdefF
#define COLOR_GREENISHGOLD 0xCCFFDDFF
#define COLOR_LIGHTBLUEGREEN 0x0FFDD3FF
#define COLOR_NEUTRALBLUE 0xABCDEFFF
#define COLOR_LIGHTCYAN 0xAAFFCCFF
#define COLOR_LEMON 0xDDDD23FF
#define COLOR_MEDIUMBLUE 0x63AFF0FF
#define COLOR_NEUTRAL 0xABCDEFFF
#define COLOR_BLACK 0x000000FF
#define COLOR_NEUTRALGREEN 0x81CFABFF
#define COLOR_DARKGREEN 0x12900BFF
#define COLOR_LIGHTGREEN 0x24FF0AFF
#define COLOR_DARKBLUE 0x300FFAFF
#define COLOR_BLUEGREEN 0x46BBAAFF
#define COLOR_PINK 0xFF66FFFF
#define COLOR_LIGHTBLUE 0x33CCFFFF
#define COLOR_DARKRED 0x660000FF
#define COLOR_ORANGE 0xFF9900FF
#define COLOR_PURPLE 0x800080FF
#define COLOR_GRAD1 0xB4B5B7FF
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_RED1 0xFF0000FF
#define COLOR_GREY 0xAFAFAFFF
#define COLOR_GREEN 0x33AA33FF
#define COLOR_RED 0xAA3333FF
#define COLOR_YELLOW 0xFFFF00FF
#define COLOR_WHITE 0xFFFFFFFF
#define COLOR_BROWN 0x993300FF
#define COLOR_CYAN 0x99FFFFFF
#define COLOR_TAN 0xFFFFCCFF
#define COLOR_PINK 0xFF66FFFF
#define COLOR_KHAKI 0x999900FF
#define COLOR_LIME 0x99FF00FF
#define COLOR_SYSTEM 0xEFEFF7FF
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_GRAD4 0xD8D8D8FF
#define COLOR_GRAD6 0xF0F0F0FF
#define COLOR_GRAD2 0xBFC0C2FF
#define COLOR_GRAD3 0xCBCCCEFF
#define COLOR_GRAD5 0xE3E3E3FF
#define COLOR_GRAD1 0xB4B5B7FF
#define GELTONA 0xFFFF00FF
#define BALTA 0xFFFFFFFF
#define blue 0x375FFFFF
#define yellow 0xFFFF00FF
#define green 0x33AA33FF
#define red 0xFF0000FF
#define white 0xFFFFFFFF
#define skyblue 0x99FFFFFF
#define orange 0xFF9900FF
#define purple 0xB360FDFF
#define lightgreen 0x38FF06FF
#define darkpink 0xE100E1FF
#define darkgreen 0x008040FF
#define announcment 0x00CACAFF
#define system 0xEFEFF7FF
#define gray 0xCECECEFF
#define MAPICONDISTANCE         500.0
#define TEXTLABELDISTANCE       100.0
#define PICKUPDISTANCE          100.0
#define MAX_DYNAMIC_PICKUPS 1000

enum pInfo
{
	Type
};
new pickupdata[MAX_DYNAMIC_PICKUPS][pInfo];

public OnFilterScriptInit()
{
	print("----------------------------------------------------------");
	print("MySql Store System by ROkzlive(Whatcha)(Hammy The Hamster)");
	print("----------------------------------------------------------");
	mysql_init(LOG_ALL,1);
	mysql_connect(SQL_Host,SQL_Username,SQL_Password,SQL_Database);
	AddStoresFromMysql();
	return 1;
}

public OnFilterScriptExit()
{
	return 1;
}

public OnPlayerPickUpDynamicPickup(playerid, pickupid)
{
    if(pickupdata[pickupid][Type]==1)
    {
        SendClientMessage(playerid,COLOR_RED,"You must code in the dialogs and stuff you want in your store! This script is just to get you started!");
    }
    return 1;
}

stock AddStore(Float:X, Float:Y, Float:Z)
{
	new Query[200];
	format(Query, sizeof(Query), "INSERT INTO `stores` (X, Y, Z) VALUES(%f, %f, %f)",
	X, Y, Z);
	mysql_query(Query);
	mysql_free_result();
	return 1;
}

stock AddStoresFromMysql()
{
    new Str[1000], id, Float:X, Float:Y, Float:Z, STotal;
    mysql_query("SELECT * FROM `stores`");
    mysql_store_result();


	while(mysql_fetch_row(Str, "|"))
	{
	    if(!mysql_num_rows()) continue;
		sscanf(Str, "p<|>ifff",id, X, Y, Z);
		print(Str);
		CreateDynamicPickup(1274, 23, X, Y, Z, -1, -1, -1, PICKUPDISTANCE);
		pickupdata[id][Type]=1;
		CreateDynamic3DTextLabel("Store", COLOR_YELLOW, X, Y, Z, 100.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, TEXTLABELDISTANCE);
		CreateDynamicMapIcon(X, Y, Z, 38, 0, -1, -1, -1, MAPICONDISTANCE);
		printf("Store spawned at %f %f %f!",X,Y,Z);
		STotal++;
	}
    mysql_free_result();
    printf("** %i\t<->\tStores Loaded From\t<->\tMySQL\t\t   **", STotal);
    return 1;
}

COMMAND:addstore(playerid, params[])
{
	new Msg[50], storepickup, Float:X, Float:Y, Float:Z;
	GetPlayerPos(playerid, X, Y, Z);
	storepickup = CreateDynamicPickup(1274, 23, X, Y, Z, -1, -1, -1, PICKUPDISTANCE);
	pickupdata[storepickup][Type]=1;
	CreateDynamicMapIcon(X, Y, Z, 38, 0, -1, -1, -1, MAPICONDISTANCE);
	CreateDynamic3DTextLabel("Store", COLOR_YELLOW, X, Y, Z, 100.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, TEXTLABELDISTANCE);
	AddStore(X, Y, Z);
	format(Msg, sizeof(Msg), "A new store has been added!");
	return SendClientMessage(playerid, COLOR_YELLOW, Msg);
}