[DOWNLOAD] [CoD2] Basetdm-Mod

[kung foo man]

MySQL needs this in a datebase:

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user` varchar(32) DEFAULT NULL,
  `pass` varchar(32) DEFAULT NULL,
  `money` int(10) DEFAULT NULL,
  `xp` int(10) DEFAULT NULL,
  `kills` int(10) DEFAULT NULL,
  `headshots` int(10) DEFAULT NULL,
  `melee_kills` int(10) DEFAULT NULL,
  `longest_killstreak` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DELIMITER $$


DROP FUNCTION IF EXISTS statsDeltaMoney$$


CREATE FUNCTION statsDeltaMoney (id_ INT, money_ INT)
RETURNS INT
DETERMINISTIC
BEGIN
    DECLARE ret INT;
    SET ret = NULL;
    UPDATE players SET money=IFNULL(money,0)+money_ WHERE id = id_;
    SELECT money FROM players WHERE id = id_ INTO ret;
    RETURN ret;
END$$

DELIMITER ;

SELECT statsDeltaMoney(5, 10) AS newMoney;







DELIMITER $$


DROP FUNCTION IF EXISTS statsDeltaXP$$


CREATE FUNCTION statsDeltaXP (id_ INT, xp_ INT)
RETURNS INT
DETERMINISTIC
BEGIN
    DECLARE ret INT;
    SET ret = NULL;
    UPDATE players SET xp=IFNULL(xp,0)+xp_ WHERE id = id_;
    SELECT xp FROM players WHERE id = id_ INTO ret;
    RETURN ret;
END$$

DELIMITER ;

SELECT statsDeltaXP(5, 10) AS newXP;