Help - Printable Version

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: Help (/showthread.php?tid=569860)

Help - Edw - 03.04.2015

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;

}

Re: Help - dominik523 - 03.04.2015

I'm sure you need a parameter to your function which will be job's ID.

pawn Код:

forward LoadJobs(id);
public LoadJobs(id)
{
    new Cache: database; szQuery[ 0 ] = EOS;
    mysql_format( mysql, szQuery, 128, "SELECT * FROM `jobs` WHERE `jobID` = %d", id); 
...

Re: Help - Nicker - 03.04.2015

mysql_format( mysql, szQuery, 128, "SELECT * FROM `jobs` WHERE `jobID`" );

You don't need the WHERE. Just:

mysql_format( mysql, szQuery, 128, "SELECT * FROM `jobs`" );

Re: Help - Sawalha - 03.04.2015

as the guy above me said, you just need "SELECT * FROM `jobs`" to select all jobs inserted in the table "jobs"

Re: Help - Edw - 05.04.2015

I put two jobs but only 1 load ..

PHP код:



forward LoadJobs( );
public LoadJobs( )
{
    new Cache: database;
    mysql_format( mysql, szQuery, 128, "SELECT * FROM `jobs`" );
    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("Load jobs: %d", jobID);
    }
    printf("Load jobs: %d", jobID);
    cache_delete(database);
    return 1;
}