• Gandii (Combat CGs)

• Colonia (Colonia Expansion CG)

• LHS 3447 (Colonia Expansion CG)

Reminder for new dispatchers: consider using a private group (PG) when rescuing a client in these systems.

Starport closure information: Starport Status

Permit locked Systems and Regions: Permit-systems

Changes are being made to SOP for the upcoming Horizons 4.0 game version.

Elite Live and Legacy mode SOP changes

See this guide that Masterloon put together on calculating SC travel times for long distances

This unofficial training Training can be especially useful for Ratlings before their drill, but in no way should make them feel pressured to complete their drill before they're ready.  As always, this  This training is 100% optional and voluntary. This training is not required in order to rat or dispatch.

We have our own Pastebin: https://paste.fuelrats.com/

Be sure to save the file and change the extension to .txt before sharing.Training Opportunities

SELECT
	sq."Total Cases (Last 7 days)",
	sq."Rescues (Last 7 days)",
	sq."Success % (Last 7 days)",
	sq."Total Cases (Last 24 hours)",
	sq."Rescues (Last 24 hours)",
	sq."Success % (Last 24 hours)"
FROM
	(
		SELECT
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total Cases (Last 7 days)",
			COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Rescues (Last 7 days)",
			ROUND(CAST(COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as decimal)/COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) *100,2) as "Success % (Last 7 days)",
COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total Cases (Last 24 hours)",
			COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Rescues (Last 24 hours)",
			ROUND(CAST(COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as decimal)/COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) *100,2) as "Success % (Last 24 hours)"
		FROM
			public."Rescues" 
		WHERE
			"deletedAt" IS NULL and "platform" != 'unknown' and position(': false' in "data"::json#>>'{markedForDeletion}')>0 
	) sq;
 
SELECT
	sq."Total CR Cases (Last 7 days)",
	sq."CR Rescues (Last 7 days)",
	sq."CR Success % (Last 7 days)",
	sq."Total CR Cases (Last 24 hours)",
	sq."CR Rescues (Last 24 hours)",
	sq."CR Success % (Last 24 hours)"
FROM
	(
		SELECT
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total CR Cases (Last 7 days)",
			COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "CR Rescues (Last 7 days)",
			ROUND(CAST(COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as decimal)/COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) *100,2) as "CR Success % (Last 7 days)",
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total CR Cases (Last 24 hours)",
			COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "CR Rescues (Last 24 hours)",
			ROUND(CAST(COALESCE(sum(CASE WHEN "successful" and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as decimal)/COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) *100,2) as "CR Success % (Last 24 hours)"
		FROM
			public."Rescues" 
		WHERE
			"codeRed" = TRUE and "deletedAt" IS NULL and "platform" != 'unknown' and position(': false' in "data"::json#>>'{markedForDeletion}')>0 
	) sq;	
 
SELECT
	sq."Total PC Cases (Last 7 days)",
	sq."Total PC Cases (Last 24 hours)"
FROM
	(
		SELECT
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total PC Cases (Last 7 days)",
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total PC Cases (Last 24 hours)"
		FROM
			public."Rescues" 
		WHERE
			"platform" = 'pc' and "deletedAt" IS NULL and "platform" != 'unknown' and position(': false' in "data"::json#>>'{markedForDeletion}')>0 
	) sq;	
 
SELECT
	sq."Total XB Cases (Last 7 days)",
	sq."Total XB Cases (Last 24 hours)"
FROM
	(
		SELECT
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total XB Cases (Last 7 days)",
			COALESCE(sum(CASE WHEN "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '24 hours' AND LOCALTIMESTAMP THEN 1 ELSE 0 END),0) as "Total XB Cases (Last 24 hours)"
		FROM
			public."Rescues" 
		WHERE
			"platform" = 'xb' and "deletedAt" IS NULL and "platform" != 'unknown' and position(': false' in "data"::json#>>'{markedForDeletion}')>0 
	) sq;	
select count(distinct("firstLimpetId")) as "Rats with a First Limpet (Last 7 Days)" from "Rescues" where "createdAt" between LOCALTIMESTAMP - INTERVAL '7 days' and LOCALTIMESTAMP;

select count(distinct("firstLimpetId")) as "Rats with a First Limpet (Last 24 hours)" from "Rescues" where "createdAt" between LOCALTIMESTAMP - INTERVAL '24 hours' and LOCALTIMESTAMP;

SELECT system as "System", COUNT(system) as "# of Rescues" FROM "Rescues" WHERE position(': false' in "data"::json#>>'{markedForDeletion}')>0 and "createdAt" BETWEEN LOCALTIMESTAMP - INTERVAL '7 days' AND LOCALTIMESTAMP GROUP BY system ORDER BY count(system) DESC LIMIT 5;