//loadsystem
public LoadSystems() {
	mysql_tquery(SQL, "SELECT * FROM `factions`", "LoadDynamicFactions", "");
	mysql_tquery(SQL, "SELECT * FROM `vehicles`", "LoadVehicles", "");
	mysql_tquery(SQL, "SELECT * FROM `houses`", "LoadProperty", "");
	LoadTurfs();
	for(new i = 0; i < sizeof(TurfInfo); i++)
	{
     	Turfs[i] = GangZoneCreateEx(TurfInfo[i][zMinX],TurfInfo[i][zMinY],TurfInfo[i][zMaxX],TurfInfo[i][zMaxY],TurfInfo[i][zID],1.0);
	}

	mysql_tquery( SQL, "SELECT * FROM `clans` ORDER BY `clanID` ASC", "LoadClanVariables", "" );
	mysql_tquery( SQL, "SELECT * FROM `clanzones` ORDER BY `zoneID` ASC", "LoadClanZonesVariables", "" );
	mysql_tquery( SQL, "SELECT * FROM `clanvehicles` ORDER BY `clanVehicleID` ASC", "LoadClanVehicles", "" );
	mysql_tquery(SQL, "SELECT * FROM `bizz`", "LoadBizz", "");
	mysql_tquery(SQL, "SELECT * FROM `stock`", "LoadStock", "");
	mysql_tquery(SQL, "SELECT * FROM `stockbonus`", "LoadStockBonus", "");
	mysql_tquery( SQL, "SELECT * FROM `apartaments` ORDER BY `ID` ASC", "loadApartments", "" );
	mysql_tquery(SQL, "SELECT * FROM `cars`", "LoadCar", "");
	mysql_tquery(SQL, "SELECT * FROM `users`", "LoadUsers", "");
	mysql_tquery(SQL, "SELECT * FROM `atms`", "LoadAtms", "");
	mysql_tquery(SQL, "SELECT * FROM `treasurehunt`", "LoadTreasureHuntPOS", "");
	mysql_tquery(SQL, "UPDATE `friends` SET `Status`='0'", "", "");
	mysql_tquery(SQL, "UPDATE `users` SET `Status`='0'", "", "");
}

//functii clan
function LoadClanZonesVariables( ) {
	new string[ 50 ];
	serverClanZones = cache_num_rows( );
	for( new i = 1; i <= serverClanZones; i++ ) {
		clanZoneVariables[ i ][ clanZoneID ] = cache_get_field_content_int( i - 1, "zoneID" );
		clanZoneVariables[ i ][ clanZoneClan ] = cache_get_field_content_int( i - 1, "zoneClan" );
		clanZoneVariables[ i ][ clanZoneMinX ] = cache_get_field_content_float( i - 1, "zoneMinX" );
		clanZoneVariables[ i ][ clanZoneMinY ] = cache_get_field_content_float( i - 1, "zoneMinY" );
		clanZoneVariables[ i ][ clanZoneMaxX ] = cache_get_field_content_float( i - 1, "zoneMaxX" );
		clanZoneVariables[ i ][ clanZoneMaxY ] = cache_get_field_content_float( i - 1, "zoneMaxY" );
		clanZoneVariables[ i ][ clanZoneObjX ] = cache_get_field_content_float( i - 1, "zoneObjX" );
		clanZoneVariables[ i ][ clanZoneObjY ] = cache_get_field_content_float( i - 1, "zoneObjY" );
		clanZoneVariables[ i ][ clanZoneObjZ ] = cache_get_field_content_float( i - 1, "zoneObjZ" );
		clanZoneVariables[ i ][ clanZoneObjRotX ] = cache_get_field_content_float( i - 1, "zoneObjRotX" );
		clanZoneVariables[ i ][ clanZoneObjRotY ] = cache_get_field_content_float( i - 1, "zoneObjRotY" );
		clanZoneVariables[ i ][ clanZoneObjRotZ ] = cache_get_field_content_float( i - 1, "zoneObjRotZ" );
		clanZoneVariables[ i ][ clanZoneObject ] = CreateDynamicObject( 19353, clanZoneVariables[ i ][ clanZoneObjX ], clanZoneVariables[ i ][ clanZoneObjY ], clanZoneVariables[ i ][ clanZoneObjZ ], clanZoneVariables[ i ][ clanZoneObjRotX ], clanZoneVariables[ i ][ clanZoneObjRotY ], clanZoneVariables[ i ][ clanZoneObjRotZ ], -1, -1, -1, STREAMER_OBJECT_SD, STREAMER_OBJECT_DD );
		clanZoneVariables[ i ][ clanZoneTurf ] = GangZoneCreateEx( clanZoneVariables[ i ][ clanZoneMinX ], clanZoneVariables[ i ][ clanZoneMinY ], clanZoneVariables[ i ][ clanZoneMaxX ], clanZoneVariables[ i ][ clanZoneMaxY ], i, 1.0 );
		clanZoneVariables[ i ][ clanZoneAttacked ] = 0;
		clanZoneVariables[ i ][ clanZoneProcent ] = 0;

		if( clanZoneVariables[ i ][ clanZoneClan ] == 0 ) format( string, 50, "None" );
		else format( string, 50, "{%s}%s", clanVariables[ clanZoneVariables[ i ][ clanZoneClan ] ][ clanColor ], clanVariables[ clanZoneVariables[ i ][ clanZoneClan ] ][ clanName ] );
		SetDynamicObjectMaterialText( clanZoneVariables[ i ][ clanZoneObject ], 0, string, OBJECT_MATERIAL_SIZE_256x128, "Arial", 28, 0, 0xFFFF9200, 0, OBJECT_MATERIAL_TEXT_ALIGN_CENTER );
	} printf( "Clan Zones: %d", serverClanZones );
	return true; }
function LoadClanVariables( ) {
	serverClans = cache_num_rows( );
	for( new i = 1; i <= serverClans; i++ ) {
		clanVariables[ i ][ clanID ] = cache_get_field_content_int( i - 1, "clanID" );
		clanVariables[ i ][ clanSlots ] = cache_get_field_content_int( i - 1, "clanSlots" );
		clanVariables[ i ][ clanSafe ] = cache_get_field_content_int( i - 1, "clanSafe" );
		cache_get_field_content( i - 1, "clanName", clanVariables[ i ][ clanName ], SQL, 50 );
		cache_get_field_content( i - 1, "clanTag", clanVariables[ i ][ clanTag ], SQL, 20 );
		cache_get_field_content( i - 1, "clanColor", clanVariables[ i ][ clanColor ], SQL, 20 );
		cache_get_field_content( i - 1, "clanRankName1", clanVariables[ i ][ clanRankName1 ], SQL, 32 );
		cache_get_field_content( i - 1, "clanRankName2", clanVariables[ i ][ clanRankName2 ], SQL, 32 );
		cache_get_field_content( i - 1, "clanRankName3", clanVariables[ i ][ clanRankName3 ], SQL, 32 );
		cache_get_field_content( i - 1, "clanRankName4", clanVariables[ i ][ clanRankName4 ], SQL, 32 );
		cache_get_field_content( i - 1, "clanRankName5", clanVariables[ i ][ clanRankName5 ], SQL, 32 );
		cache_get_field_content( i - 1, "clanRankName6", clanVariables[ i ][ clanRankName6 ], SQL, 32 );
		cache_get_field_content( i - 1, "clanRankName7", clanVariables[ i ][ clanRankName7 ], SQL, 32 );
	} printf( "Clans: %d", serverClans );
	return true; }
function LoadClanVehicles( ) {
	serverClanVehicles = cache_num_rows( );
	for( new i = 1; i <= serverClanVehicles; i++ ) {
		clanVehiclesVariables[ i ][ clanVehicleID ] = cache_get_field_content_int( i - 1, "clanVehicleID" );
		clanVehiclesVariables[ i ][ clanVehicleClan ] = cache_get_field_content_int( i - 1, "clanVehicleClan" );
		clanVehiclesVariables[ i ][ clanVehicleRank ] = cache_get_field_content_int( i - 1, "clanVehicleRank" );
		clanVehiclesVariables[ i ][ clanVehicleModel ] = cache_get_field_content_int( i - 1, "clanVehicleModel" );
		clanVehiclesVariables[ i ][ clanVehicleColor1 ] = cache_get_field_content_int( i - 1, "clanVehicleColor1" );
		clanVehiclesVariables[ i ][ clanVehicleColor2 ] = cache_get_field_content_int( i - 1, "clanVehicleColor2" );
		clanVehiclesVariables[ i ][ clanVehicleX ] = cache_get_field_content_float( i - 1, "clanVehicleX" );
		clanVehiclesVariables[ i ][ clanVehicleY ] = cache_get_field_content_float( i - 1, "clanVehicleY" );
		clanVehiclesVariables[ i ][ clanVehicleZ ] = cache_get_field_content_float( i - 1, "clanVehicleZ" );
		clanVehiclesVariables[ i ][ clanVehicleA ] = cache_get_field_content_float( i - 1, "clanVehicleA" );
		createClanVehicle( i );
	} printf( "Clan Vehicles: %d", serverClanVehicles );
	return true; }

//