I am seeing syntax problems in your Trigger. The correct way should be like
DROP TRIGGER IF EXISTS insert_points;
CREATE TRIGGER insert_points
BEFORE INSERT
ON p_players
FOR EACH ROW
BEGIN
SET NEW.total_points = NEW.gold_num + NEW.total_people_count + NEW.week_thief_points +NEW.week_dev_points+NEW.week_defense_points+NEW.week_attack_points+NEW.defense_points+NEW.attack_points+NEW.hero_points+NEW.villages_count;
END;