new bool: TransferObjects;
new tr_own, tr_group, tr_groupEX, last_object_guid;

stock CreateDynamicObjectEx2(modelid, Float:x, Float:y, Float:z, Float:rx, Float:ry, Float:rz, worldid = -1, interiorid = -1, playerid = -1, Float:streamdistance = 200.0, Float:drawdistance = 0.0)
{
    /*if(SERVER_ID == 20)
        return CreateDynamicObject(modelid, x, y, z, rx, ry, rz, worldid, interiorid, playerid, streamdistance);
    else
        return CreateDynamicObject(modelid, x, y, z, rx, ry, rz, worldid, interiorid, playerid, streamdistance, drawdistance);*/
    if(TransferObjects == true) {
        mysql_format(connectionid, sqlstr, sizeof(sqlstr), "INSERT INTO `objects` VALUES (0, %d, %d, %d, 1, %d, %f, %f, %f, %f, %f, %f, %d, %d, %f)", tr_own, tr_group, tr_groupEX, modelid, x, y, z, rx, ry, rz, worldid, interiorid, streamdistance);
        new Cache:result = mysql_query(connectionid, sqlstr, true);
        last_object_guid = cache_insert_id(connectionid);
        cache_delete(result);
        printf(sqlstr);
    }
    return CreateDynamicObject(modelid, x, y, z, rx, ry, rz, worldid, interiorid, playerid, streamdistance, drawdistance);
}
#define CreateDynamicObject CreateDynamicObjectEx2

stock SetDynamicObjectMaterialEx(objectid, materialindex, modelid, const txdname[], const texturename[], materialcolor = 0)
{
    if(TransferObjects == true) {
        mysql_format(connectionid, sqlstr, sizeof(sqlstr), "INSERT INTO `objects_mat` VALUES (0, %d, %d, %d, '%s', '%s', %d)", last_object_guid, materialindex, modelid, txdname, texturename, materialcolor);
        mysql_query(connectionid, sqlstr);
        printf(sqlstr);
    }
    return SetDynamicObjectMaterial(objectid, materialindex, modelid, txdname, texturename, materialcolor);
}
#define SetDynamicObjectMaterial SetDynamicObjectMaterialEx

stock SetDynamicObjectMaterialTextEx(objectid, materialindex, const text[], materialsize = OBJECT_MATERIAL_SIZE_256x128, const fontface[] = "Arial", fontsize = 24, bold = 1, fontcolor = 0xFFFFFFFF, backcolor = 0, textalignment = 0)
{
    if(TransferObjects == true) {
        mysql_format(connectionid, sqlstr, sizeof(sqlstr), "INSERT INTO `objects_mat_text` VALUES (0, %d, '%s', %d, %d, '%s', %d, %d, %d, %d, %d)", last_object_guid, text, materialindex, materialsize, fontface, fontsize, bold, fontcolor, backcolor, textalignment);
        mysql_query(connectionid, sqlstr);
        printf(sqlstr);
    }
    return SetDynamicObjectMaterialText(objectid, materialindex, text, materialsize, fontface, fontsize, bold, fontcolor, backcolor, textalignment);
}
#define SetDynamicObjectMaterialText SetDynamicObjectMaterialTextEx

stock CreatePlayerObjectEx2(playerid, modelid, Float:X, Float:Y, Float:Z, Float:rX, Float:rY, Float:rZ, Float:DrawDistance = 0.0)
{
    if(TransferObjects == true) {
        mysql_format(connectionid, sqlstr, sizeof(sqlstr), "INSERT INTO `objects` VALUES (0, %d, %d, %d, 2, %d, %f, %f, %f, %f, %f, %f, %d, %d, %f)", tr_own, tr_group, tr_groupEX, modelid, X, Y, Z, rX, rY, rZ, -1, -1, DrawDistance);
        new Cache:result = mysql_query(connectionid, sqlstr);
        last_object_guid = cache_insert_id(connectionid);
        cache_delete(result);
        printf(sqlstr);
    }
    return CreatePlayerObject(playerid, modelid, X, Y, Z, rX, rY, rZ, DrawDistance);
}
#define CreatePlayerObject CreatePlayerObjectEx2

stock SetPlayerObjectMaterialEx(playerid, objectid, materialindex, modelid, txdname[], texturename[], materialcolor)
{
    if(TransferObjects == true) {
        mysql_format(connectionid, sqlstr, sizeof(sqlstr), "INSERT INTO `objects_mat` VALUES (0, %d, %d, %d, '%s', '%s', %d)", last_object_guid, materialindex, modelid, txdname, texturename, materialcolor);
        mysql_query(connectionid, sqlstr);
        printf(sqlstr);
    }
    return SetPlayerObjectMaterial(playerid, objectid, materialindex, modelid, txdname, texturename, materialcolor);
}
#define SetPlayerObjectMaterial SetPlayerObjectMaterialEx

stock SetPlayerObjectMaterialTextEx(playerid, objectid, text[], materialindex = 0, materialsize = OBJECT_MATERIAL_SIZE_256x128, fontface[] = "Arial", fontsize = 24, bold = 1, fontcolor = 0xFFFFFFFF, backcolor = 0, textalignment = 0)
{
    if(TransferObjects == true) {
        mysql_format(connectionid, sqlstr, sizeof(sqlstr), "INSERT INTO `objects_mat_text` VALUES (0, %d, '%s', %d, %d, '%s', %d, %d, %d, %d, %d)", last_object_guid, text, materialindex, materialsize, fontface, fontsize, bold, fontcolor, backcolor, textalignment);
        mysql_query(connectionid, sqlstr);
        printf(sqlstr);
    }
    return SetPlayerObjectMaterialText(playerid, objectid, text, materialindex, materialsize, fontface, fontsize, bold, fontcolor, backcolor, textalignment);
}
#define SetPlayerObjectMaterialText SetPlayerObjectMaterialTextEx