Business MYSQL help! - Printable Version

Business MYSQL help! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Business MYSQL help! (/showthread.php?tid=525651)

Business MYSQL help! - dieuhanhphuc - 13.07.2014

Код:

stock LoadBiz()
{
	new query[300];
	for(new i=0;i<MAXBIZ; i++)
	{
		format(query, sizeof(query), "SELECT * FROM business WHERE IDBiz = %d LIMIT 1", i);
		mysql_query(OCP, query);
		BInfo[i][ID] = cache_get_field_content_int(0, "IDBiz");
		cache_get_field_content(0, "TenBiz", BInfo[i][Ten],OCP,128);
		BInfo[i][Gia] = cache_get_field_content_int(0, "Gia");
		BInfo[i][Loai] = cache_get_field_content_int(0, "Loai");
		BInfo[i][X] = cache_get_field_content_float(0, "X");
		BInfo[i][Y] = cache_get_field_content_float(0, "Y");
		BInfo[i][Z] = cache_get_field_content_float(0, "Z");
	}
	return 0;
}

I got this error! Pls help me. , i use the new MYSQL R33.

Quote:

[14:49:44] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[14:49:44] [ERROR] cache_get_field_content_float - invalid datatype

Re: Business MYSQL help! - Jack_Leslie - 13.07.2014

I think there's something wrong with your actual mysql database and the table. You'd need to access phpmyadmin and fix it through that.

Re: Business MYSQL help! - dieuhanhphuc - 13.07.2014

Код:

format(query,sizeof(query),"CREATE TABLE IF NOT EXISTS business (\
	IDBiz int(11) NOT NULL,\
	TenBiz varchar(40) NOT NULL,\
	Gia int(11) NOT NULL,\
	Loai int(11) NOT NULL,\
	X float(11) NOT NULL,\
	Y float(11) NOT NULL,\
	Z float(11) NOT NULL)");
mysql_query(OCP, query);

Here.

Re: Business MYSQL help! - dieuhanhphuc - 13.07.2014

Close! I fixed it