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

Quote:

---

Originally Posted by kung foo man

MySQL does that for you :)

PHP Code:

---

SELECT md5('test') 


---

---

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

PHP Code:

---

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 ; 


---

PHP Code:

---

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


---

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.

PHP Code:

---

    CREATE INDEX players_user ON players(user); 


---

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

PHP Code:

---

    SHOW INDEX FROM players;
    DROP INDEX players_user ON players; 


---

Decent, need to accomplish something like this with mine.