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

Threaded Mode
cache_get_field_content_int error
3MY
Little Clucker
**
Posts: 35
Threads: 10
Joined: Jun 2012
Reputation: 0
#1

11.03.2017, 12:57
Errors:

Код HTML:
[13:58:24 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:58:24 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:58:44 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:58:44 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:58:54 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:58:54 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:06 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:59:06 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:17 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:59:17 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:27 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:59:27 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:42 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:59:42 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[13:59:53 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[13:59:53 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:00:07 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:00:07 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:00:26 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:00:26 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:00:35 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:00:35 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:00:45 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:00:45 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:00:57 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:00:57 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:08 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:08 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:19 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:19 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:27 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:27 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:42 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:42 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:49 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:49 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:53 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:53 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:01:59 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:01:59 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:10 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:10 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:19 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:19 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:27 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:27 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:31 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:31 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:36 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:36 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:39 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:39 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:02:47 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 3 ")
[14:02:47 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:06:13 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 1 ")
[14:06:13 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:06:16 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 1 ")
[14:06:16 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:06:18 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 1 ")
[14:06:18 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:06:19 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 1 ")
[14:06:19 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
[14:24:34 03/11/17] [WARNING] CMySQLResult::GetRowDataByName - field not found ("CashSkill0") (Query: "SELECT * FROM `paychecks` WHERE ID = 7 ")
[14:24:34 03/11/17] [ERROR] cache_get_field_content_int - invalid datatype
Code:
Код HTML:
stock GetJobSalariu(playerid, job)
{
	new pret;
	new string[256];
	format(string, 256, "SELECT * FROM `paychecks` WHERE ID = %d ", job);
	new Cache: Result = mysql_query( mysql, string), Get[ 2 ];
	cache_get_data( Get[ 0 ], Get[ 1 ], SQL );
	new formatx[50];
	format(formatx, 50, "CashSkill%d", PlayerInfo[playerid][pJobSkillL][job]);
	pret  = cache_get_field_content_int( 0, formatx, mysql );
	cache_delete( Result );
	return pret;
}
MySQL Table:


How can i solve?
Find
Reply
iLearner
Unregistered
 
#2

11.03.2017, 13:20
Quote:

pret = cache_get_field_content_int( 0, formatx);
Try that

PS: Show us the table structure
Reply
TitanX
Banned
Posts: 83
Threads: 3
Joined: Feb 2017
#3

11.03.2017, 13:29
PHP код:
stock GetJobSalariu(playerid, job)
{
    new pret;
    new string[256];
    format(string, 256, "SELECT * FROM `paychecks` WHERE ID = %d ", job);
    new Cache: Result = mysql_query( mysql, string), Get[ 2 ];
    cache_get_data( Get[ 0 ], Get[ 1 ], SQL );
    new formatx[50];
    format(formatx, 50, "CashSkill%d", PlayerInfo[playerid][pJobSkillL][job]+1);
    pret  = cache_get_field_content_int( 0, formatx, mysql );
    cache_delete( Result );
    return pret;
} 
there no CashSkill0 in table so we need to add +1 to this
Find
Reply
3MY
Little Clucker
**
Posts: 35
Threads: 10
Joined: Jun 2012
Reputation: 0
#4

11.03.2017, 13:33
Quote:
Originally Posted by TitanX
Посмотреть сообщение
PHP код:
stock GetJobSalariu(playerid, job)
{
    new pret;
    new string[256];
    format(string, 256, "SELECT * FROM `paychecks` WHERE ID = %d ", job);
    new Cache: Result = mysql_query( mysql, string), Get[ 2 ];
    cache_get_data( Get[ 0 ], Get[ 1 ], SQL );
    new formatx[50];
    format(formatx, 50, "CashSkill%d", PlayerInfo[playerid][pJobSkillL][job]+1);
    pret  = cache_get_field_content_int( 0, formatx, mysql );
    cache_delete( Result );
    return pret;
} 
there no CashSkill0 in table so we need to add +1 to this
great, thank you!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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