[akib]

Quote:

Originally Posted by SyS what's mysql_function_query ? Also show OnDoorsLoad

mysql_function_query is now mysql_tquery

Code OnDoorsLoad

PHP Code:

public OnDoorsLoad()
{
    new num_fields,num_rows,str[512];
    cache_get_data(num_rows,num_fields,dbhandle);
    if(!num_rows)return 1;
    print("========================| Loading Doors |=========================");
    for(new i=1;i<sizeof(DynamicDoor);i++){
        DestroyPickup(DynamicDoor[i][dPickup]);
        DestroyPickup(DynamicDoor[i][dOPickup]);
        Delete3DTextLabel(DynamicDoor[i][dLabel]);
    }
    for(new i=0; i<num_rows; i++)
    {
        new id=GetFreeDoorID();
        DynamicDoor[id][doorID]=id;
        DynamicDoor[id][dUsed]=1;
        DynamicDoor[id][doorSQLID]=cache_get_field_content_int(i, "id", dbhandle);
        DynamicDoor[id][posX]=cache_get_field_content_float(i, "posX", dbhandle);
        DynamicDoor[id][posX]=cache_get_field_content_float(i, "posX", dbhandle);
        DynamicDoor[id][posY]=cache_get_field_content_float(i, "posY", dbhandle);
        DynamicDoor[id][posZ]=cache_get_field_content_float(i, "posZ", dbhandle);
        DynamicDoor[id][posi][0]=cache_get_field_content_float(i, "posiX", dbhandle);
        DynamicDoor[id][posi][1]=cache_get_field_content_float(i, "posiY", dbhandle);
        DynamicDoor[id][posi][2]=cache_get_field_content_float(i, "posiZ", dbhandle);
        DynamicDoor[id][dBarOne]=cache_get_field_content_int(i, "bar", dbhandle);
        DynamicDoor[id][dTreasury]=cache_get_field_content_int(i, "dTreasury", dbhandle);
        DynamicDoor[id][dFee]=cache_get_field_content_int(i, "dFee", dbhandle);
        DynamicDoor[id][dOutWorld]=cache_get_field_content_int(i, "dOutWorld", dbhandle);
        DynamicDoor[id][dOutInt]=cache_get_field_content_int(i, "dOutInt", dbhandle);
        DynamicDoor[id][dOwner]=cache_get_field_content_int(i, "dOwner", dbhandle);
        DynamicDoor[id][dWorld]=cache_get_field_content_int(i, "dWorld", dbhandle);
        DynamicDoor[id][dInterior]=cache_get_field_content_int(i, "dInterior", dbhandle);
        DynamicDoor[id][dLock]=cache_get_field_content_int(i, "dLock", dbhandle);
        cache_get_field_content(i, "dName", DynamicDoor[i][dName], dbhandle);
        DynamicDoor[id][dPickup] = CreatePickup(1239, 1, DynamicDoor[id][posX], DynamicDoor[id][posY], DynamicDoor[id][posZ], -1);
        DynamicDoor[id][dOPickup] = CreatePickup(1239, 1, DynamicDoor[id][posi][0], DynamicDoor[id][posi][1], DynamicDoor[id][posi][2], -1);
        format(str, sizeof(str), "%s\n{ffffff}Type /enter to enter.", DynamicDoor[i][dName]);
        DynamicDoor[id][dLabel] = CreateDynamic3DTextLabel(str ,COLOR_ORANGE, DynamicDoor[id][posX], DynamicDoor[id][posY], DynamicDoor[id][posZ],30.0, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 7.0);
        printf("Door %i[%i]: %f,%f,%f", DynamicDoor[id][doorSQLID],id,DynamicDoor[id][posX], DynamicDoor[id][posY], DynamicDoor[id][posZ]);
    }
    printf("========================| Total Biz: %i |============================",num_rows);
    return 1;
}