vJk7aJsT

1CREATE TABLE IF NOT EXISTS `ranksystem` (\
2											`id` INT(20) NOT NULL AUTO_INCREMENT,\
3											`steamid` VARCHAR(150) NOT NULL DEFAULT 'error',\
4											`name` VARCHAR(150) NOT NULL DEFAULT 'error',\
5											`exp` INT(20) NOT NULL DEFAULT 0,\
6											`tokens` INT(20) NOT NULL DEFAULT 0,\
7											`damage` INT(20) NOT NULL DEFAULT 0,\
8											`gravity` INT(20) NOT NULL DEFAULT 0,\
9											`speed` INT(20) NOT NULL DEFAULT 0,\
10											PRIMARY KEY (`id`)) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
11
12SELECT * FROM ranksystem WHERE steamid='%s'
13UPDATE `ranksystem` SET damage = damage+1, tokens = tokens-1 WHERE steamid='%s'
14UPDATE `ranksystem` SET exp = exp+%i, tokens = %i WHERE steamid='%s'
15select name, exp from ranksystem order by exp desc limit 10