1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
how to remove MySQL
wahyumahadir
Little Clucker
**
Posts: 47
Threads: 12
Joined: Dec 2012
Reputation: 0
#1

14.02.2015, 17:24
how to remove MySql and change it to dini save file ?

Code :
Код:
/*                      FURNITURE SYSTEM v1.0 BY KIDDO
                       CREDITS: KIDDO, BLUEG, INCOGNITO, ******
					    (Do not remove this line!)
				        DO NOT (RE)RELEASE THIS SCRIPT!
																			 */
#include <a_samp>
#include <a_mysql>
#include <streamer>
#include <foreach>

// Color Defines
#define COL_RED          "{FF2626}"
#define COL_GREEN        "{86C44D}"
#define COL_WHITE        "{FFFFFF}"
#define COL_GREY         "{CCCCCC}"
#define COL_BLUE         "{4373E6}"
#define COL_ORANGE       "{E6BA43}"
#define COL_PURPLE       "{CD8DD9}"
#define COL_LIGHTRED     "{FA6161}"
#define COL_LIGHTGREEN   "{56ED1A}"
#define COL_LIGHTBLUE    "{61BFFA}"
#define COL_AQUA         "{61FAFA}"
#define COL_LOGIN        "{FA9761}"
#define COL_PINK         "{FA61F7}"
#define COL_YELLOW       "{FFFB00}"
#define COL_BLACK        "{000000}"

#define MYSQL_HOST "localhost"
#define MYSQL_PASS ""
#define MYSQL_DATA "furniture"
#define MYSQL_USER "root"

#define MAX_FOBJECTS 200
#define DIALOG_OBJECTS   	10000
#define DIALOG_USED      	10001
#define DIALOG_NOTUSED   	10002
#define DIALOG_CHOOSETYPE   10003
#define DIALOG_TABLE        10004
#define DIALOG_BUY          10005
#define DIALOG_CHAIR        10006
#define DIALOG_BEDS         10007
#define DIALOG_SOFAS        10008
#define DIALOG_DECORATIONS  10009
#define DIALOG_APPLIANCES   10010

new smallquery[128];
new bigquery[512];
new dbhandle;
new object[MAX_FOBJECTS];
new usingslot[10];
new preview[MAX_PLAYERS];
new objectmodel[MAX_PLAYERS];
new editingobject[MAX_PLAYERS];
new objectprice[MAX_PLAYERS];

forward f_LoadPlayer(playerid);
forward f_ObjectsLoad();

enum table
{
    tid,
    tablename[48],
    tableprice,
}
new Tables[15][table] = {
{1281, "Park Table[$100]",100},
{1432, "Plain Table[$120]",120},
{1594, "Plain table + Chairs[500$]",500},
{1825, "Elegant table + Chairs[500$]",500},
{1827, "Elegant table[800$]",800},
{1433, "Living Room Table 1[[250$]",250},
{1516, "Living Room Table 2[250$]",250},
{1524, "Craps Table[3050$]",3050},
{2311, "TV Table 1[402$]",402},
{2313, "TV Table 2[450$]",450},
{2315, "TV Table 3[420$]",420},
{2346, "Hi Fi Table 1[500$]",500},
{2635, "Pizza Table[150$]",150},
{2762, "Red Table(Cluckin Bell)[402$]",402},
{2799, "Black Table + 2chairs[750$]",750}
};

enum chair
{
    cid,
    chairname[48],
    chairprice,
}
new Chairs[15][chair] = {
{1369, "Wheelchair[$100]",100},
{1663, "Office Chair 1[$200]",200},
{1704, "Chair 1[150$]",150},
{1705, "Chair 2[150$]",150},
{1708, "Chair 3[150$]",150},
{1711, "Chair 4[120$]",120},
{1714, "Elegant office chair[550$]",550},
{1720, "Rest Chair[220$]",220},
{1721, "Waiting room chair[50$]",50},
{1735, "Chair 5[120$]",120},
{1739, "Dinning Chair[230$]",230},
{1806, "Office Chair 3[150$]",150},
{1811, "Low Dinning Chair[100$]",100},
{2079, "Dinning Chair 2[120$]",120},
{2120, "Medium Dinning Chair[120$]",120}
};
enum bed
{
    bid,
    bedname[48],
    bedprice,
}
new Beds[15][bed] = {
{1700, "Sleeping Room Bed[$250]",250},
{1701, "Sleeping Room Bed 2[$250]",250},
{1745, "Sleeping Room Bed 3[$300]",300},
{1793, "Low Bed[$150]",150},
{1794, "Low Bed 2[$170]",170},
{1796, "Low Bed 3[$120]",120},
{1797, "Swank Bed[$150]",150},
{1798, "Swank Bed 2[$150]",150},
{1799, "Medium Bed[$189]",180},
{1800, "Low Bed[$150]",150},
{1802, "Medium Bed[$230]",230},
{1803, "Medium Bed 2[$1230]",230},
{2299, "Elegant Bed[$450]",450},
{2563, "Bed Set 1[$1500]",1500},
{2566, "Bed Set 2[$1700]",1700}
};

enum sofa
{
    sid,
    sofaname[48],
    sofaprice,
}
new Sofas[15][sofa] = {
{1702, "Living Room Couch[$250]",250},
{1703, "Living Room Couch 2[$250]",250},
{1706, "Living Room Couch 3[$250]",250},
{1707, "Living Room Couch 4[$250]",250},
{1712, "Living Room Couch 5[$250]",250},
{1713, "Living Room Couch 6[$250]",250},
{1753, "Swank Couch [$300]",300},
{1756, "Low Couch[$300]",300},
{1757, "Low Couch 2[$300]",300},
{1760, "Medium Couch[$320]",320},
{1761, "Swank Couch 2[$220]",220},
{1763, "Low Couch 3[$308]",308},
{1764, "Low Couch 4[$308]",308},
{1766, "Medium Couch 2 [$350]",350},
{1768, "Low Couch 5[$499]",499}
};

enum decoration
{
    did,
    decname[48],
    decprice,
}
new Decorations[15][decoration] = {
{2833, "Living Grug[$130]",130},
{1834, "Living Grug 2[$130]",130},
{1835, "Living Grug 3[$130]",130},
{1836, "Living Grug 4[$130]",130},
{1811, "Flower Pot 1[$15]",15},
{1834, "Burger Shot bag[$10]",10},
{2510, "Plane Model[$50]",50},
{2502, "Hobby Shelf[$70]",70},
{2353, "Meal object[$10]",10},
{2284, "Frame 1[$40]",40},
{2285, "Frame 2[$40]",40},
{2286, "Frame 3[$40]",40},
{2267, "Frame 4[$40]",40},
{2274, "Frame 5[$40]",40},
{2251, "Plant Pot 1[$20]",20}
};

enum appl
{
    appid,
    appname[48],
    appprice,
}
new Appliances[15][appl] = {
{1429, "Broken TV[$20]",20},
{1518, "TV[$200]",200},
{2297, "TV Unit[$350]",350},
{1429, "Broken TV [$20]",20},
{16377, "TV Stand[$150]",150},
{2131, "Kitchen Fridge[$560]",560},
{2132, "Kitchen Sink[$240]",240},
{2170, "Kitchen Cooker[$170]",170},
{2340, "Kitchen Washer[$250]",250},
{2131, "Cooker + Cabinet[$300]",300},
{2421, "Microwave[$150]",1150},
{2528, "Toilet[$100]",100},
{2526, "Bath[$150]",150},
{1514, "Till[$400]",400},
{1515, "Slot Machine[$1202]",1202}
};

enum fInfo
{
	id,
	Name[MAX_PLAYER_NAME],
	Slot[30]
};
new FurnitureInfo[MAX_PLAYERS][fInfo];

enum oInfo
{
	id,
	modelid,
	Float:x,
	Float:y,
	Float:z,
	Float:rx,
	Float:ry,
	Float:rz,
	worldid,
	interiorid,
};
new ObjectInfo[MAX_FOBJECTS][oInfo];
// -----------------------------------------------------//
public OnFilterScriptInit()
{
    dbhandle = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS);
    if(mysql_ping())
    {
		print("\n");
		print("**********************************************");
		print("\n");
		print("> Furniture System V1.0 By Kiddo Loaded!");
		print("\n");
		print("**********************************************");
		print("\n");
		mysql_format(dbhandle,smallquery,"SELECT * FROM `objects`");
		mysql_function_query(dbhandle,smallquery,true,"f_ObjectsLoad","","");
    }
    return 1;
}
public OnFilterScriptExit()
{
	new counto;
	for(new i = 0; i < MAX_FOBJECTS; i++)
	{
		if(ObjectInfo[i][id] != 0)
		{
			f_ObjectSave(i);
			counto++;
		}
	}
	foreach(new p : Player) f_SavePlayer(p);
	printf("Saving Objects: Saved %d objects!",counto);
    mysql_close();
	return 1;
}
public OnPlayerConnect(playerid)
{
	new name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	SendClientMessage(playerid,-1,""COL_LIGHTBLUE"»"COL_WHITE" This server is using "COL_LIGHTBLUE"Furniture System V1"COL_WHITE" by"COL_LIGHTBLUE" Kiddo"COL_WHITE"!"); // You can remove this line
	mysql_format(dbhandle,smallquery,"SELECT * FROM `players` WHERE `name` = '%e' LIMIT 1",name);
	mysql_function_query(dbhandle,smallquery,true,"f_LoadPlayer","i",playerid);
	usingslot[playerid] = 999;
	editingobject[playerid] = 999;
	return 1;
}
public OnPlayerEditObject(playerid, playerobject, objectid, response, Float:fX, Float:fY, Float:fZ, Float:fRotX, Float:fRotY, Float:fRotZ)
{
	new Float:oldX, Float:oldY, Float:oldZ,Float:oldRotX, Float:oldRotY, Float:oldRotZ;
	GetDynamicObjectPos(objectid, oldX, oldY, oldZ);
	GetDynamicObjectRot(objectid, oldRotX, oldRotY, oldRotZ);
	if(response == EDIT_RESPONSE_FINAL)
	{
    	SetDynamicObjectPos(objectid, fX, fY, fZ);
	    SetDynamicObjectRot(objectid, fRotX, fRotY, fRotZ);
		ObjectInfo[editingobject[playerid]][x] = fX;
		ObjectInfo[editingobject[playerid]][y] = fY;
		ObjectInfo[editingobject[playerid]][z] = fZ;
		ObjectInfo[editingobject[playerid]][rx] = fRotX;
		ObjectInfo[editingobject[playerid]][ry] = fRotY;
		ObjectInfo[editingobject[playerid]][rz] = fRotZ;
		SendClientMessage(playerid,-1,""COL_YELLOW"Furniture System:"COL_WHITE" You've finished editing object!");
		f_ObjectSave(editingobject[playerid]);
		editingobject[playerid] = 999;
	}
	if(response == EDIT_RESPONSE_CANCEL)
	{
    	SetDynamicObjectPos(editingobject[playerid], oldX, oldY, oldZ);
	    SetDynamicObjectRot(editingobject[playerid], oldRotX, oldRotY, oldRotZ);
		SendClientMessage(playerid,-1,""COL_YELLOW"Furniture System:"COL_WHITE" You've canceled editing object!");
		editingobject[playerid] = 999;
	}
}
public OnPlayerDisconnect(playerid, reason)
{
	f_SavePlayer(playerid);
	return 1;
}
public OnPlayerKeyStateChange(playerid,newkeys,oldkeys)
{
	new string[1250];
	new otext[128];
	if(newkeys & 65536) // KEY Y
	{
		for(new i = 0; i < 30; i++)
		{
			if(FurnitureInfo[playerid][Slot][i] != 0) format(otext,sizeof(otext),""COL_WHITE"Slot ID %d "COL_RED"(Used)",i);
			else format(otext,sizeof(otext),""COL_WHITE"Slot ID %d "COL_GREEN"(Not used)",i);
			format(string,sizeof(string),"%s%s\n",string,otext);
		    ShowPlayerDialog(playerid, DIALOG_OBJECTS, DIALOG_STYLE_LIST,""COL_YELLOW"Furniture System",string, "Choose", "Quit");
		}
	}
	return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	switch(dialogid)
	{
		case DIALOG_OBJECTS:
		{
			if(!response) return 1;
			else if(response)
			{
                usingslot[playerid] = listitem;
				new caption[48];
				if(FurnitureInfo[playerid][Slot][listitem] != 0)
				{
					format(caption,sizeof(caption),""COL_YELLOW"Slot ID %d "COL_RED"(Used)",listitem);
					ShowPlayerDialog(playerid,DIALOG_USED,DIALOG_STYLE_LIST,caption,""COL_WHITE"Delete object\nEdit Object","Choose","Quit");
				}
				else
				{
					format(caption,sizeof(caption),""COL_YELLOW"Slot ID %d "COL_LIGHTGREEN"(Not used)",listitem);
					ShowPlayerDialog(playerid,DIALOG_NOTUSED,DIALOG_STYLE_LIST,caption,""COL_WHITE"Create object","Choose","Quit");
				}
			}
		}
		case DIALOG_NOTUSED:
		{
			new string[128];
			if(!response)
         	{
                usingslot[playerid] = 999;
                return 1;
			}
			else if(response)
			{
				format(string,sizeof(string),""COL_YELLOW"Furniture system:"COL_WHITE" You are in process of creating object in slot "COL_LIGHTGREEN"%d!",usingslot[playerid]);
				SendClientMessage(playerid,-1,string);
				SendClientMessage(playerid,-1,"Select from list what type of object you want to create.");
				ShowPlayerDialog(playerid,DIALOG_CHOOSETYPE,DIALOG_STYLE_LIST,""COL_YELLOW"Creating object..",""COL_WHITE"Tables\nChairs\nBeds\nSofas\nDecorations\nAppliances","Choose","Quit");
			}
		}
		case DIALOG_USED:
		{
			new string[128];
			if(!response)
			{
			    usingslot[playerid] = 999;
                return 1;
			}
			else if(response)
			{
				switch(listitem)
				{
				    case 0:
				    {
			    		DestroyDynamicObject(FurnitureInfo[playerid][Slot][usingslot[playerid]]);
                		ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][id] = 0;
               		 	ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][modelid] = 0;
                		ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][x] = 0.0;
                		ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][y] = 0.0;
                		ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][z] = 0.0;
               		    ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][rx] = 0.0;
                		ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][ry] = 0.0;
               			ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][rz] = 0.0;
               		    ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][worldid] = 0;
                		ObjectInfo[FurnitureInfo[playerid][Slot][usingslot[playerid]]][interiorid] = 0;
                		mysql_format(dbhandle,smallquery,"DELETE FROM `objects` WHERE `id` = '%d'",FurnitureInfo[playerid][Slot][usingslot[playerid]]);
						mysql_function_query(dbhandle,smallquery,false,"","");
						FurnitureInfo[playerid][Slot][usingslot[playerid]] = 0;
						format(string,sizeof(string),""COL_YELLOW"Furniture system:"COL_WHITE" You've deleted object from slot ID "COL_LIGHTGREEN"%d"COL_WHITE"!",usingslot[playerid]);
				        SendClientMessage(playerid,-1,string);
						usingslot[playerid] = 999;
				    }
					case 1:
					{
                        EditDynamicObject(playerid,FurnitureInfo[playerid][Slot][usingslot[playerid]]);
                        format(string,sizeof(string),""COL_YELLOW"Furniture system:"COL_WHITE" You are now editing object in slot ID "COL_LIGHTGREEN"%d"COL_WHITE"!",usingslot[playerid]);
                        SendClientMessage(playerid,-1,string);
                        editingobject[playerid] = FurnitureInfo[playerid][Slot][usingslot[playerid]];
						usingslot[playerid] = 999;
					}
				}
			}
		}
		case DIALOG_CHOOSETYPE:
		{
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				new string[1024];
				switch(listitem)
				{
					case 0:
					{
       					for(new i; i < sizeof(Tables); i++)
          		        {
                        	format(string, sizeof(string), "%s%s\n", string,Tables[i][tablename]);
                            ShowPlayerDialog(playerid, DIALOG_TABLE, DIALOG_STYLE_LIST,""COL_YELLOW"Choose table model..",string, "Choose", "Cancel");
						}
					}
					case 1:
					{
       					for(new i; i < sizeof(Chairs); i++)
          		        {
                        	format(string, sizeof(string), "%s%s\n", string,Chairs[i][chairname]);
                            ShowPlayerDialog(playerid, DIALOG_CHAIR, DIALOG_STYLE_LIST,""COL_YELLOW"Choose chair model..",string, "Choose", "Cancel");
						}
					}
					case 2:
					{
       					for(new i; i < sizeof(Beds); i++)
          		        {
                        	format(string, sizeof(string), "%s%s\n", string,Beds[i][bedname]);
                            ShowPlayerDialog(playerid, DIALOG_BEDS, DIALOG_STYLE_LIST,""COL_YELLOW"Choose bed model..",string, "Choose", "Cancel");
						}
					}
					case 3:
					{
       					for(new i; i < sizeof(Sofas); i++)
          		        {
                        	format(string, sizeof(string), "%s%s\n", string,Sofas[i][sofaname]);
                            ShowPlayerDialog(playerid, DIALOG_SOFAS, DIALOG_STYLE_LIST,""COL_YELLOW"Choose sofa model..",string, "Choose", "Cancel");
						}
					}
					case 4:
					{
       					for(new i; i < sizeof(Decorations); i++)
          		        {
                        	format(string, sizeof(string), "%s%s\n", string,Decorations[i][decname]);
                            ShowPlayerDialog(playerid, DIALOG_DECORATIONS, DIALOG_STYLE_LIST,""COL_YELLOW"Choose decoration model..",string, "Choose", "Cancel");
						}
					}
					case 5:
					{
       					for(new i; i < sizeof(Appliances); i++)
          		        {
                        	format(string, sizeof(string), "%s%s\n", string,Appliances[i][appname]);
                            ShowPlayerDialog(playerid, DIALOG_APPLIANCES, DIALOG_STYLE_LIST,""COL_YELLOW"Choose appliance model..",string, "Choose", "Cancel");
						}
					}
				}
			}
		}
		case DIALOG_TABLE:
		{
			new string[128];
			new Float:fx,Float:fy,Float:fz;
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				GetPlayerPos(playerid,fx,fy,fz);
                preview[playerid] = CreateDynamicObject(Tables[listitem][tid],fx,fy+2,fz,0,0,0,0,-1,-1,15);
				objectmodel[playerid] = Tables[listitem][tid];
				objectprice[playerid] = Tables[listitem][tableprice];
			    format(string,sizeof(string),""COL_WHITE"Are you sure that you want to buy "COL_YELLOW"%s"COL_WHITE" for"COL_YELLOW" $%d?",Tables[listitem][tablename],Tables[listitem][tableprice]);
				ShowPlayerDialog(playerid,DIALOG_BUY,DIALOG_STYLE_MSGBOX,""COL_YELLOW"Buying object...",string,"Yes","No");
			}
		}
		case DIALOG_CHAIR:
		{
			new string[128];
			new Float:fx,Float:fy,Float:fz;
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				GetPlayerPos(playerid,fx,fy,fz);
			    preview[playerid] = CreateDynamicObject(Tables[listitem][tid],fx,fy+2,fz,0,0,0,0,-1,-1,15);
				objectmodel[playerid] = Chairs[listitem][cid];
				objectprice[playerid] = Chairs[listitem][chairprice];
			    format(string,sizeof(string),""COL_WHITE"Are you sure that you want to buy "COL_YELLOW"%s"COL_WHITE" for"COL_YELLOW" $%d?",Chairs[listitem][chairname],Chairs[listitem][chairprice]);
				ShowPlayerDialog(playerid,DIALOG_BUY,DIALOG_STYLE_MSGBOX,""COL_YELLOW"Buying object...",string,"Yes","No");
			}
		}
		case DIALOG_BEDS:
		{
			new string[128];
			new Float:fx,Float:fy,Float:fz;
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				GetPlayerPos(playerid,fx,fy,fz);
                preview[playerid] = CreateDynamicObject(Beds[listitem][bid],fx,fy+2,fz,0,0,0,0,-1,-1,15);
				objectmodel[playerid] = Beds[listitem][bid];
				objectprice[playerid] = Beds[listitem][bedprice];
			    format(string,sizeof(string),""COL_WHITE"Are you sure that you want to buy "COL_YELLOW"%s"COL_WHITE" for"COL_YELLOW" $%d?",Beds[listitem][bedname],Beds[listitem][bedprice]);
				ShowPlayerDialog(playerid,DIALOG_BUY,DIALOG_STYLE_MSGBOX,""COL_YELLOW"Buying object...",string,"Yes","No");
			}
		}
		case DIALOG_SOFAS:
		{
			new string[128];
			new Float:fx,Float:fy,Float:fz;
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				GetPlayerPos(playerid,fx,fy,fz);
                preview[playerid] = CreateDynamicObject(Sofas[listitem][sid],fx,fy+2,fz,0,0,0,0,-1,-1,15);
				objectmodel[playerid] = Sofas[listitem][sid];
				objectprice[playerid] = Sofas[listitem][sofaprice];
			    format(string,sizeof(string),""COL_WHITE"Are you sure that you want to buy "COL_YELLOW"%s"COL_WHITE" for"COL_YELLOW" $%d?",Sofas[listitem][sofaname],Sofas[listitem][sofaprice]);
				ShowPlayerDialog(playerid,DIALOG_BUY,DIALOG_STYLE_MSGBOX,""COL_YELLOW"Buying object...",string,"Yes","No");
			}
		}
	    case DIALOG_DECORATIONS:
		{
			new string[128];
			new Float:fx,Float:fy,Float:fz;
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				GetPlayerPos(playerid,fx,fy,fz);
                preview[playerid] = CreateDynamicObject(Decorations[listitem][did],fx,fy+2,fz,0,0,0,0,-1,-1,15);
				objectmodel[playerid] = Decorations[listitem][did];
				objectprice[playerid] = Decorations[listitem][decprice];
			    format(string,sizeof(string),""COL_WHITE"Are you sure that you want to buy "COL_YELLOW"%s"COL_WHITE" for"COL_YELLOW" $%d?",Decorations[listitem][decname],Decorations[listitem][decprice]);
				ShowPlayerDialog(playerid,DIALOG_BUY,DIALOG_STYLE_MSGBOX,""COL_YELLOW"Buying object...",string,"Yes","No");
			}
		}
        case DIALOG_APPLIANCES:
		{
			new string[128];
			new Float:fx,Float:fy,Float:fz;
			if(!response)
			{
				usingslot[playerid] = 999;
				return 1;
			}
			else if(response)
			{
				GetPlayerPos(playerid,fx,fy,fz);
                preview[playerid] = CreateDynamicObject(Appliances[listitem][appid],fx,fy+2,fz,0,0,0,0,-1,-1,15);
				objectmodel[playerid] = Appliances[listitem][appid];
				objectprice[playerid] = Appliances[listitem][appprice];
			    format(string,sizeof(string),""COL_WHITE"Are you sure that you want to buy "COL_YELLOW"%s"COL_WHITE" for"COL_YELLOW" $%d?",Appliances[listitem][appname],Appliances[listitem][appprice]);
				ShowPlayerDialog(playerid,DIALOG_BUY,DIALOG_STYLE_MSGBOX,""COL_YELLOW"Buying object...",string,"Yes","No");
			}
		}
		case DIALOG_BUY:
		{
		    if(!response)
			{
				usingslot[playerid] = 999;
                DestroyDynamicObject(preview[playerid]);
				preview[playerid] = 0;
				objectmodel[playerid] = 0;
				objectprice[playerid] = 0;
				return 1;
			}
			else if(response)
			{
				if(GetPlayerMoney(playerid) < objectprice[playerid])
				{
					SendClientMessage(playerid,-1,""COL_RED"You don't have enough money to buy this item!");
					usingslot[playerid] = 999;
                	DestroyDynamicObject(preview[playerid]);
					preview[playerid] = 0;
					objectmodel[playerid] = 0;
					objectprice[playerid] = 0;
					return 1;
				}
				new Float:oX,Float:oY,Float:oZ;
				new Float:rX,Float:rY,Float:rZ;
				GetDynamicObjectRot(preview[playerid],rX,rY,rZ);
				new wid = GetPlayerVirtualWorld(playerid);
				new pint = GetPlayerInterior(playerid);
				GetDynamicObjectPos(preview[playerid],oX,oY,oZ);
				FurnitureInfo[playerid][Slot][usingslot[playerid]] = preview[playerid];
				ObjectInfo[preview[playerid]][id] = preview[playerid];
				ObjectInfo[preview[playerid]][modelid] = objectmodel[playerid];
				ObjectInfo[preview[playerid]][x] = oX;
				ObjectInfo[preview[playerid]][y] = oY;
				ObjectInfo[preview[playerid]][z] = oZ;
				ObjectInfo[preview[playerid]][rx] = rX;
				ObjectInfo[preview[playerid]][ry] = rY;
				ObjectInfo[preview[playerid]][rz] = rZ;
			    ObjectInfo[preview[playerid]][worldid] = wid;
			    ObjectInfo[preview[playerid]][interiorid] = pint;
			    mysql_format(dbhandle,bigquery,"INSERT INTO `objects` (`id`,`modelid`,`x`,`y`,`z`,`rx`,`ry`,`rz`,`worldid`,`interiorid`) VALUES ('%d','%d','%f','%f','%f','%f','%f','%f','%d','%d')",preview[playerid],objectmodel[playerid],oX,oY,oZ,rX,rY,rZ,wid,pint);
				mysql_function_query(dbhandle,bigquery,false,"","");
                DestroyDynamicObject(preview[playerid]);
          	    object[preview[playerid]] = CreateDynamicObject(ObjectInfo[preview[playerid]][modelid],ObjectInfo[preview[playerid]][x],ObjectInfo[preview[playerid]][y],ObjectInfo[preview[playerid]][z],ObjectInfo[preview[playerid]][rx],ObjectInfo[preview[playerid]][ry],ObjectInfo[preview[playerid]][rz],ObjectInfo[preview[playerid]][worldid],ObjectInfo[preview[playerid]][interiorid],-1,50.0);
				preview[playerid] = 0;
				objectmodel[playerid] = 0;
				objectprice[playerid] = 0;
				SendClientMessage(playerid,-1,""COL_YELLOW"Furniture System:"COL_WHITE" You have bought an object!");
			}
		}
	}
    return 0;
}
//----------------------------------------------------------------------------//
public f_LoadPlayer(playerid)
{
	new rows, fields,name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	cache_get_data(rows,fields);
	if(!rows)
	{
		mysql_format(dbhandle,bigquery,"INSERT INTO `players` (`name`,`slot1`,`slot2`,`slot3`,`slot4`,`slot5`,`slot6`,`slot7`,`slot8`,`slot9`,`slot10`) VALUES ('%e',0,0,0,0,0,0,0,0,0,0)",name);
	    mysql_function_query(dbhandle,bigquery,false,"","");
	    printf("MySQL: Player %s added to furniture database!",name);
	}
	else if(rows)
	{
		new temp[24],countused;
		cache_get_row(0,0,temp); FurnitureInfo[playerid][id] = strval(temp);
		cache_get_row(0,1,temp); format(FurnitureInfo[playerid][Name],MAX_PLAYER_NAME,"%s",name);
		cache_get_row(0,2,temp); FurnitureInfo[playerid][Slot][0] = strval(temp);
		cache_get_row(0,3,temp); FurnitureInfo[playerid][Slot][1] = strval(temp);
		cache_get_row(0,4,temp); FurnitureInfo[playerid][Slot][2] = strval(temp);
		cache_get_row(0,5,temp); FurnitureInfo[playerid][Slot][3] = strval(temp);
		cache_get_row(0,6,temp); FurnitureInfo[playerid][Slot][4] = strval(temp);
		cache_get_row(0,7,temp); FurnitureInfo[playerid][Slot][5] = strval(temp);
		cache_get_row(0,8,temp); FurnitureInfo[playerid][Slot][6] = strval(temp);
		cache_get_row(0,9,temp); FurnitureInfo[playerid][Slot][7] = strval(temp);
		cache_get_row(0,10,temp); FurnitureInfo[playerid][Slot][8] = strval(temp);
		cache_get_row(0,11,temp); FurnitureInfo[playerid][Slot][9] = strval(temp);
		cache_get_row(0,12,temp); FurnitureInfo[playerid][Slot][10] = strval(temp);
		cache_get_row(0,13,temp); FurnitureInfo[playerid][Slot][11] = strval(temp);
		cache_get_row(0,14,temp); FurnitureInfo[playerid][Slot][12] = strval(temp);
		cache_get_row(0,15,temp); FurnitureInfo[playerid][Slot][13] = strval(temp);
		cache_get_row(0,16,temp); FurnitureInfo[playerid][Slot][14] = strval(temp);
		cache_get_row(0,17,temp); FurnitureInfo[playerid][Slot][15] = strval(temp);
		cache_get_row(0,18,temp); FurnitureInfo[playerid][Slot][16] = strval(temp);
		cache_get_row(0,19,temp); FurnitureInfo[playerid][Slot][17] = strval(temp);
		cache_get_row(0,20,temp); FurnitureInfo[playerid][Slot][18] = strval(temp);
		cache_get_row(0,21,temp); FurnitureInfo[playerid][Slot][19] = strval(temp);
		cache_get_row(0,22,temp); FurnitureInfo[playerid][Slot][20] = strval(temp);
		cache_get_row(0,23,temp); FurnitureInfo[playerid][Slot][21] = strval(temp);
		cache_get_row(0,24,temp); FurnitureInfo[playerid][Slot][22] = strval(temp);
		cache_get_row(0,25,temp); FurnitureInfo[playerid][Slot][23] = strval(temp);
		cache_get_row(0,26,temp); FurnitureInfo[playerid][Slot][24] = strval(temp);
		cache_get_row(0,27,temp); FurnitureInfo[playerid][Slot][25] = strval(temp);
		cache_get_row(0,28,temp); FurnitureInfo[playerid][Slot][26] = strval(temp);
		cache_get_row(0,29,temp); FurnitureInfo[playerid][Slot][27] = strval(temp);
		cache_get_row(0,30,temp); FurnitureInfo[playerid][Slot][28] = strval(temp);
		cache_get_row(0,31,temp); FurnitureInfo[playerid][Slot][29] = strval(temp);
		for(new i = 0; i < 10; i++)
		{
			if(FurnitureInfo[playerid][Slot][i] != 0) countused++;
		}
		printf("MySQL: Player %s loaded from furniture database. Objects used: %d!",name,countused);
	}
	return 1;
}
stock f_SavePlayer(playerid)
{
	mysql_format(dbhandle,bigquery,"UPDATE `players` SET `name` = '%e',`slot1` = '%d',`slot2` = '%d',`slot3` = '%d',`slot4` = '%d',`slot5` = '%d',`slot6` = '%d',`slot7` = '%d',`slot8` = '%d',`slot9` = '%d',`slot10` = '%d' WHERE `id` = '%d' LIMIT 1",
		FurnitureInfo[playerid][Name],
	    FurnitureInfo[playerid][Slot][0],
	    FurnitureInfo[playerid][Slot][1],
	    FurnitureInfo[playerid][Slot][2],
	    FurnitureInfo[playerid][Slot][3],
	    FurnitureInfo[playerid][Slot][4],
	    FurnitureInfo[playerid][Slot][5],
	    FurnitureInfo[playerid][Slot][6],
	    FurnitureInfo[playerid][Slot][7],
	    FurnitureInfo[playerid][Slot][8],
	    FurnitureInfo[playerid][Slot][9],
	    FurnitureInfo[playerid][id]);
	mysql_function_query(dbhandle,bigquery,false,"","");

    mysql_format(dbhandle,bigquery,"UPDATE `players` SET `slot11` = '%d',`slot12` = '%d',`slot13` = '%d',`slot14` = '%d',`slot15` = '%d',`slot16` = '%d',`slot17` = '%d',`slot18` = '%d',`slot19` = '%d',`slot20` = '%d' WHERE `id` = '%d' LIMIT 1",
	    FurnitureInfo[playerid][Slot][10],
	    FurnitureInfo[playerid][Slot][11],
	    FurnitureInfo[playerid][Slot][12],
	    FurnitureInfo[playerid][Slot][13],
	    FurnitureInfo[playerid][Slot][14],
	    FurnitureInfo[playerid][Slot][15],
	    FurnitureInfo[playerid][Slot][16],
	    FurnitureInfo[playerid][Slot][17],
	    FurnitureInfo[playerid][Slot][18],
	    FurnitureInfo[playerid][Slot][19],
	    FurnitureInfo[playerid][id]);
    mysql_format(dbhandle,bigquery,"UPDATE `players` SET `slot21` = '%d',`slot22` = '%d',`slot23` = '%d',`slot24` = '%d',`slot25` = '%d',`slot26` = '%d',`slot27` = '%d',`slot28` = '%d',`slot29` = '%d',`slot30` = '%d' WHERE `id` = '%d' LIMIT 1",
	    FurnitureInfo[playerid][Slot][20],
	    FurnitureInfo[playerid][Slot][21],
	    FurnitureInfo[playerid][Slot][22],
	    FurnitureInfo[playerid][Slot][23],
	    FurnitureInfo[playerid][Slot][24],
	    FurnitureInfo[playerid][Slot][25],
	    FurnitureInfo[playerid][Slot][26],
	    FurnitureInfo[playerid][Slot][27],
	    FurnitureInfo[playerid][Slot][28],
	    FurnitureInfo[playerid][Slot][29],
	    FurnitureInfo[playerid][id]);
	mysql_function_query(dbhandle,bigquery,false,"","");
	printf("MySQL: Player %s has been saved!",FurnitureInfo[playerid][Name]);
	return 1;
}
public f_ObjectsLoad()
{
	new rows,fields;
	cache_get_data(rows,fields);
	if(!rows) return print("Loading Objects: There are no objects in data base to load!");
	else if(rows)
	{
		new temp[24];
		for(new i = 0; i <= rows; i++)
		{
			cache_get_row(i,0,temp); ObjectInfo[i][id] = strval(temp);
			cache_get_row(i,1,temp); ObjectInfo[i][modelid] = strval(temp);
			cache_get_row(i,2,temp); ObjectInfo[i][x] = floatstr(temp);
			cache_get_row(i,3,temp); ObjectInfo[i][y] = floatstr(temp);
			cache_get_row(i,4,temp); ObjectInfo[i][z] = floatstr(temp);
			cache_get_row(i,5,temp); ObjectInfo[i][rx] = floatstr(temp);
			cache_get_row(i,6,temp); ObjectInfo[i][ry] = floatstr(temp);
			cache_get_row(i,7,temp); ObjectInfo[i][rz] = floatstr(temp);
			cache_get_row(i,8,temp); ObjectInfo[i][worldid] = strval(temp);
			cache_get_row(i,9,temp); ObjectInfo[i][interiorid] = strval(temp);
			object[i] = CreateDynamicObject(ObjectInfo[i][modelid],ObjectInfo[i][x],ObjectInfo[i][y],ObjectInfo[i][z],ObjectInfo[i][rx],ObjectInfo[i][ry],ObjectInfo[i][rz],ObjectInfo[i][worldid],ObjectInfo[i][interiorid],-1,50);
		}
		printf("Loading Objects: Loaded %d objects!",rows);
	}
	return 1;
}
stock f_ObjectSave(aid)
{
	mysql_format(dbhandle,bigquery,"UPDATE `objects` SET `x` = '%f',`y` = '%f',`z` = '%f',`rx` = '%f',`ry` = '%f',`rz` = '%f' WHERE `id` = '%d' LIMIT 1",
		ObjectInfo[aid][x],
		ObjectInfo[aid][y],
		ObjectInfo[aid][z],
		ObjectInfo[aid][rx],
		ObjectInfo[aid][ry],
		ObjectInfo[aid][rz],
		aid);
	mysql_function_query(dbhandle,bigquery,false,"","");
	return 1;
}
// End of script
Find
Reply
AndySedeyn
High-roller
*****
Posts: 1,206
Threads: 39
Joined: Feb 2014
Reputation: 0
#2

14.02.2015, 18:23
Quote:
Originally Posted by Vince
Hey, I can't figure out any way to convert a car to a bicycle since I don't know anything about cars. And yet it seems like a ludicrous idea. You need to know one thing: dini is slow and outdated. Do not use it in new projects.
Quote:
Originally Posted by ******
Also, not knowing about MySQL is entirely inexcusable - it is VERY well documented on the official site:

http://www.mysql.com/
There's absolutely no reason to convert MySQL to an outdated Dini other than you not willing to expand your knowledge and improve.
Find
Reply
RedFusion
Gangsta
*****
Posts: 920
Threads: 113
Joined: Nov 2009
Reputation: 0
#3

14.02.2015, 18:24
Now why would anyone want to do that? That's like the biggest downgrade you can make...
Find
Reply
CalvinC
High-roller
*****
Posts: 1,830
Threads: 49
Joined: Nov 2014
Reputation: 0
#4

14.02.2015, 18:54
https://sampwiki.blast.hk/wiki/Useful_Fu....28Dini.inc.29
Quote:
This section is outdated. It may use methods or functions which no longer exist or which are deemed
obsolete by the community. Caution is advised.
As even the wiki clearly states, do not use dini.
There's better saving methods, y_ini saves to .ini files aswell, but is way more efficient and faster.

MySQL is also very good, i don't see any reason to convert it, other than you not knowing how to use it.
But i would recommend you to learn how to use it, instead of using worse saving systems.
Find
Reply
Kaperstone
Banned
Posts: 3,004
Threads: 12
Joined: May 2011
#5

14.02.2015, 20:15
Maybe to y_ini ?

There is no automative software for this as far as I know, so you will need to learn y_ini and/or rewrite.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 3 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help