Files for extended Server + Random-Scripts like sliding mapvote on Deathrun

[Mitch]

MySQL does that for you

		SELECT md5('test') 
	

Thanks. I have been looking into mysql's security functions. It is safer to use SHA2.

		DELIMITER $$

DROP FUNCTION IF EXISTS generateSalt$$

CREATE FUNCTION generateSalt()
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
    DECLARE x INT;
    DECLARE s VARCHAR(255);
    SET s = '';
    SET x = 0;

    WHILE x  < 10 DO
        SET s = CONCAT(s,CHAR(FLOOR(34+(RAND()*93))));
        SET x = x + 1; 
    END WHILE;

    RETURN s;
END$$

DELIMITER ; 
	

		SET s = generateSalt();
SET pass = SHA2(CONCAT(s, pass), 256); 
	

[Mitch]

If you have got an account system and you often search your user on their username. Then it would be better to make this an index. This will increase performance 10 times.

		    CREATE INDEX players_user ON players(user); 
	

If you want to see or drop your one of your indexes

		    SHOW INDEX FROM players;
    DROP INDEX players_user ON players; 
	

[ARTOTTO]

Decent, need to accomplish something like this with mine.