[Shockey HD]

Gangzones aren't showing when they load.

I've checked if they're loading correctly from floats:

pawn Код:

stock Turf_Load(i)
{
    new query[420], savingstring[20];
    format(query, sizeof(query), "SELECT * FROM GangZone WHERE TurfID=%d",i);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "North"); TurfData[i][North] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "South"); TurfData[i][South] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "East"); TurfData[i][East] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "West"); TurfData[i][West] = floatstr(savingstring);
        mysql_fetch_field_row(savingstring, "Color"); TurfData[i][TurfColor] = strval(savingstring);
        mysql_fetch_field_row(TurfData[i][TurfName],"TurfName");
        TurfData[i][tTurfID] = GangZoneCreate(TurfData[i][West], TurfData[i][South], TurfData[i][East], TurfData[i][North]);

        switch(TurfData[i][TurfColor])
        {
            case 0: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_WHITE);
            case 1: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_BLUE);
            case 2: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_GREEN);
            case 3: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_YELLOW);
            case 4: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_ORANGE);
            case 5: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_PURPLE);
            case 6: GangZoneShowForAll(TurfData[i][tTurfID], COLOR_RED);
        }

    }
    return 1;
}

Код:

[00:52:09] CMySQLHandler::Query(SELECT * FROM GangZone WHERE TurfID=1) - Successfully executed.

[00:52:09] >> mysql_store_result( Connection handle: 1 )

[00:52:09] CMySQLHandler::StoreResult() - Result was stored.

[00:52:09] >> mysql_fetch_row_format( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchRow() - Return: |1|0|-1737.82|-1747.71|-1737.58|-1738.29

[00:52:09] >> mysql_fetch_field_row( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchField("North") - -1737.82

[00:52:09] >> mysql_fetch_field_row( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchField("South") - -1747.71

[00:52:09] >> mysql_fetch_field_row( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchField("East") - -1737.58

[00:52:09] >> mysql_fetch_field_row( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchField("West") - -1738.29

[00:52:09] >> mysql_fetch_field_row( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchField("Color") - 0

[00:52:09] >> mysql_fetch_field_row( Connection handle: 1 )

[00:52:09] CMySQLHandler::FetchField("TurfName") - 

[00:52:09] >> mysql_fetch_row_format( Connection handle: 1 )

[00:52:09] >> mysql_query( Connection handle: 1 )

Any idea why this isn't working?

I'm not too familiar with Gangzones so maybe I'm just using the functions incorrectly?