// Loading the data

CharacterInfo[i][extraid][CharacterID] = cache_get_field_int(0, "CharacterID");
CharacterInfo[i][extraid][CharacterOwner] = cache_get_field_int(0, "CharacterOwner");
cache_fetch_string(0, "CharacterName", CharacterInfo[i][extraid][CharacterName]);
CharacterInfo[i][extraid][CharacterSlotUsed] = cache_get_field_int(0, "CharacterSlotUsed");
CharacterInfo[i][extraid][CharacterSkin] = cache_get_field_int(0, "CharacterSkin");
CharacterInfo[i][extraid][CharacterAge] = cache_get_field_int(0, "CharacterAge");
cache_fetch_string(0, "CharacterAccent", CharacterInfo[i][extraid][CharacterAccent]);
cache_fetch_string(0, "CharacterOrigin", CharacterInfo[i][extraid][CharacterOrigin]);
cache_fetch_string(0, "CharacterBirthday", CharacterInfo[i][extraid][CharacterBirthday]);
CharacterInfo[i][extraid][CharacterGender] = cache_get_field_int(0, "CharacterGender");
CharacterInfo[i][extraid][CharacterInHouse] = cache_get_field_int(0, "CharacterInHouse");
CharacterInfo[i][extraid][CharacterInBusiness] = cache_get_field_int(0, "CharacterInBusiness");
CharacterInfo[i][extraid][CharacterInterior] = cache_get_field_int(0, "CharacterInterior");
CharacterInfo[i][extraid][CharacterVirtualWorld] = cache_get_field_int(0, "CharacterVirtualWorld");
cache_fetch_float(0, "CharacterHealth", CharacterInfo[i][extraid][CharacterHealth]);
cache_fetch_float(0, "CharacterArmour", CharacterInfo[i][extraid][CharacterArmour]);
cache_fetch_float(0, "CharacterHunger", CharacterInfo[i][extraid][CharacterHunger]);
cache_fetch_float(0, "CharacterThirst", CharacterInfo[i][extraid][CharacterThirst]);
cache_fetch_float(0, "CharacterPOS_X", CharacterInfo[i][extraid][CharacterPOS][0]);
cache_fetch_float(0, "CharacterPOS_Y", CharacterInfo[i][extraid][CharacterPOS][1]);
cache_fetch_float(0, "CharacterPOS_Z", CharacterInfo[i][extraid][CharacterPOS][2]);
cache_fetch_float(0, "CharacterPOS_R", CharacterInfo[i][extraid][CharacterPOS][3]);
CharacterInfo[i][extraid][CharacterHasRadio] = cache_get_field_int(0, "CharacterHasRadio");
CharacterInfo[i][extraid][CharacterRadioPower] = cache_get_field_int(0, "CharacterRadioPower");
CharacterInfo[i][extraid][CharacterRadioFrequency] = cache_get_field_int(0, "CharacterRadioFrequency");
CharacterInfo[i][extraid][MarijuanaSeeds] = cache_get_field_int(0, "CharacterMarijuanaSeeds");
CharacterInfo[i][extraid][HeroinSeeds] = cache_get_field_int(0, "CharacterHeroinSeeds");
CharacterInfo[i][extraid][CocaineSeeds] = cache_get_field_int(0, "CharacterCocaineSeeds");
CharacterInfo[i][extraid][MarijuanaDrugMatter] = cache_get_field_int(0, "CharacterMarijuanaDrugMatter");
CharacterInfo[i][extraid][HeroinDrugMatter] = cache_get_field_int(0, "CharacterHeroinDrugMatter");
CharacterInfo[i][extraid][CocaineDrugMatter] = cache_get_field_int(0, "CharacterCocaineDrugMatter");
CharacterInfo[i][extraid][PureMarijuana] = cache_get_field_int(0, "CharacterPureMarijuana");
CharacterInfo[i][extraid][PureHeroin] = cache_get_field_int(0, "CharacterPureHeroin");
CharacterInfo[i][extraid][PureCocaine] = cache_get_field_int(0, "CharacterPureCocaine");


// The functions that are used

stock cache_fetch_string(const row, const field[], result[])
{
    cache_get_field_content(row, field, result, MySQL_Connection);
}

stock cache_get_field_int(row, const field_name[])
{
    static
        str[12];

    cache_get_field_content(row, field_name, str, MySQL_Connection);
    return strval(str);
}

stock Float:cache_fetch_float(const row, const field[], &Float:result = 0.0)
{
    static
        string[24];

    cache_get_field_content(row, field, string, MySQL_Connection);
    result = floatstr(string);
    
    return result;
}


stock cache_return_data(const row, const field[])
{
    static
        result[255];
        
    cache_get_field_content(row, field, result, MySQL_Connection);
    return result;
}