FEN-10507

var currentUserId = 61;
var date = new Date();
var timestamp = date.getTime() / 1000;
var createdAt = new Date().toISOString().slice(0, 19).replace('T', ' ');
var sql = "DELETE FROM `user_friend_greetings` WHERE `game_user_id`=" + currentUserId + " OR `target_user_id`=" + currentUserId + ";\n";
sql += "DELETE FROM `user_friends` WHERE `game_user_id`=" + currentUserId + " OR `friend_user_id`=" + currentUserId + ";\n";
sql += "UPDATE `user_aps` SET `ap` = 186 WHERE `game_user_id` = " + currentUserId + ";\n";
for (i = 1; i <= 50; i++) {
  sql += "INSERT INTO `user_friends` (`game_user_id`, `friend_user_id`, `created_at`, `updated_at`) VALUES(" + currentUserId + ", " + i + ", '" + createdAt + "', '" + createdAt + "');\n";
  sql += "INSERT INTO `user_friends` (`game_user_id`, `friend_user_id`, `created_at`, `updated_at`) VALUES(" + i + ", " + currentUserId + ", '" + createdAt + "', '" + createdAt + "');\n";
  sql += "INSERT INTO `user_friend_greetings` (`game_user_id`, `target_user_id`, `send_at`, `accepted_at`, `created_at`, `updated_at`) VALUES(" + i + ", " + currentUserId + ", " + timestamp + ", NULL, '" + createdAt + "', '" + createdAt + "');\n";
  if (i <= 47) {
    sql += "INSERT INTO `user_friend_greetings` (`game_user_id`, `target_user_id`, `send_at`, `accepted_at`, `created_at`, `updated_at`) VALUES(" + currentUserId + ", " + i + ", " + timestamp + ", NULL, '" + createdAt + "', '" + createdAt + "');\n";
  }
}
console.log(sql);