zvermafia

SELECT name, COUNT(name) FROM users GROUP BY name HAVING COUNT(name) > 1

zvermafia

#
# REQUIRES:
#       - server (the forge server instance)
#       - event (the forge event instance)
#       - sudo_password (random password for sudo)
#       - db_password (random password for database user)
#       - callback (the callback URL)
#

zvermafia

#################################################
# Create a database with charset utf8mb4 in MySQL
#################################################

# Syntax:
CREATE DATABASE <database_name> CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

# Example:
CREATE DATABASE mortal_kombat CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;