03.04.2015, 12:23
I added two jobs but are 0 Jobs Loaded console and game is none .... I missed something?
PHP код:
forward LoadJobs( );
public LoadJobs( )
{
new Cache: database; szQuery[ 0 ] = EOS;
mysql_format( mysql, szQuery, 128, "SELECT * FROM `jobs` WHERE `jobID`" );
database = mysql_query(mysql, szQuery);
new jobID;
for ( new i, j = cache_get_row_count ( ); i != j; ++i ) {
jobID++;
cache_get_field_content( i, "jobName", szQuery ); format( jobVariables[ jobID ][ jobName ], 32, szQuery );
cache_get_field_content( i, "jobPositionX", szQuery ); jobVariables[ jobID ][ jobPosition ][ 0 ] = floatstr( szQuery );
cache_get_field_content( i, "jobPositionY", szQuery ); jobVariables[ jobID ][ jobPosition ][ 1 ] = floatstr( szQuery );
cache_get_field_content( i, "jobPositionZ", szQuery ); jobVariables[ jobID ][ jobPosition ][ 2 ] = floatstr( szQuery );
format( szQuery, sizeof( szQuery ), "Job ID: {C91C25}%d{FFFFFF}.\nJob Name: {C91C25}%s{FFFFFF}.", jobID, jobVariables[ jobID ][ jobName ] );
CreateDynamicPickup( 1275, 23, jobVariables[ jobID ][ jobPosition ][0], jobVariables[ jobID ][ jobPosition ][ 1 ], jobVariables[ jobID ][ jobPosition ][ 2 ], 0, -1, -1, 50);
jobVariables[ jobID ][ jobLabelID ] = CreateDynamic3DTextLabel( szQuery, COLOR_WHITE, jobVariables[ jobID ][ jobPosition ][ 0 ], jobVariables[ jobID ][ jobPosition ][ 1 ], jobVariables[ jobID ][ jobPosition ][ 2 ], 90, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 50.0);
}
printf("Jobs loaded: %d", jobID);
cache_delete(database);
return 1;
}