Add this code to your database to save players who disconnect from your server :
CREATE TABLE IF NOT EXISTS ds_pedoffline (
identifier VARCHAR(255) NOT NULL,
coords TEXT NOT NULL,
heading FLOAT NOT NULL,
appearance TEXT NOT NULL,
name VARCHAR(255) NOT NULL,
timestamp INT NOT NULL,
PRIMARY KEY (identifier)
);