API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 17th, 2017
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 13.50 KB | None | 0 0
raw download clone embed print report
  1. void RS_LoadCvars( void )
  2. {
  3.     sv_port = trap_Cvar_Get( "sv_port", "44400", CVAR_ARCHIVE );
  4.     sv_hostname = trap_Cvar_Get( "sv_hostname", "racesow server", CVAR_ARCHIVE );
  5.  
  6.     rs_mysqlHost = trap_Cvar_Get( "rs_mysqlHost", "localhost", CVAR_ARCHIVE );
  7.     rs_mysqlPort = trap_Cvar_Get( "rs_mysqlPort", "0", CVAR_ARCHIVE ); // if 0 it will use the system's default port
  8.     rs_mysqlUser = trap_Cvar_Get( "rs_mysqlUser", "root", CVAR_ARCHIVE );
  9.     rs_mysqlPass = trap_Cvar_Get( "rs_mysqlPass", "", CVAR_ARCHIVE );
  10.     rs_mysqlDb = trap_Cvar_Get( "rs_mysqlDb", "racesow", CVAR_ARCHIVE );
  11.  
  12.     rs_authField_Name = trap_Cvar_Get( "rs_authField_Name", "", CVAR_ARCHIVE|CVAR_NOSET);
  13.     rs_authField_Pass = trap_Cvar_Get( "rs_authField_Pass", "", CVAR_ARCHIVE|CVAR_NOSET);
  14.     rs_authField_Token = trap_Cvar_Get( "rs_authField_Token", "", CVAR_ARCHIVE|CVAR_NOSET);
  15.     rs_tokenSalt = trap_Cvar_Get( "rs_tokenSalt", "", CVAR_ARCHIVE|CVAR_NOSET);
  16.  
  17.     rs_historyDays = trap_Cvar_Get( "rs_historyDays", "30", CVAR_ARCHIVE|CVAR_LATCH);
  18.  
  19.     if (!Q_stricmp( rs_authField_Name->string, "" ) || !Q_stricmp( rs_authField_Pass->string, "" ) ||!Q_stricmp( rs_authField_Token->string, "" ))
  20.     {
  21.         G_Error("\033[31;40m\nthe cVars rs_authField_Name, rs_authField_Pass and rs_authField_Token must be set and should be unique for your database!\n\nie. racenet uses the following settings:\n\tset rs_authField_Name \"racenet_user\"\n\tset rs_authField_Pass \"racenet_pass\"\n\tset rs_authField_Token \"racenet_token\"\n\nlike that you can store authentications for multiple servers in a single config.\n\033[0m\n");
  22.     }
  23.  
  24.     G_Printf("-------------------------------------\nClient authentication via userinfo:\nsetu %s \"username\"\nsetu %s \"password\"\nor the more secure method using an enrypted token\nsetu %s \"token\"\n-------------------------------------\n", rs_authField_Name->string, rs_authField_Pass->string, rs_authField_Token->string);
  25.  
  26.     rs_queryGetPlayerAuth           = trap_Cvar_Get( "rs_queryGetPlayerAuth",           "SELECT `id`, `auth_mask`, `auth_token` FROM `player` WHERE `auth_name` = '%s' AND `auth_pass` = MD5('%s%s') LIMIT 1;", CVAR_ARCHIVE );
  27.     rs_queryGetPlayerAuthByToken    = trap_Cvar_Get( "rs_queryGetPlayerAuthByToken",    "SELECT `id`, `auth_mask` FROM `player` WHERE `auth_token` = MD5('%s%s') LIMIT 1;", CVAR_ARCHIVE );
  28.     rs_queryGetPlayerAuthBySession  = trap_Cvar_Get( "rs_queryGetPlayerAuthBySession",  "SELECT `id`, `auth_mask` FROM `player` WHERE `session_token` = '%s' LIMIT 1;", CVAR_ARCHIVE );
  29.     rs_querySetTokenForPlayer       = trap_Cvar_Get( "rs_querySetTokenForPlayer",       "UPDATE `player` SET `auth_token` = MD5('%s%s') WHERE `id` = %d;", CVAR_ARCHIVE );
  30.     rs_querySetSessionForPlayer     = trap_Cvar_Get( "rs_querySetSessionForPlayer",     "UPDATE `player` SET `session_token` = '%s' WHERE `id` = %d;", CVAR_ARCHIVE );
  31.     rs_queryGetPlayer               = trap_Cvar_Get( "rs_queryGetPlayer",               "SELECT `id`, `auth_mask` FROM `player` WHERE `simplified` = '%s' LIMIT 1;", CVAR_ARCHIVE );
  32.     rs_queryAddPlayer               = trap_Cvar_Get( "rs_queryAddPlayer",               "INSERT INTO `player` (`name`, `simplified`, `created`) VALUES ('%s', '%s', NOW());", CVAR_ARCHIVE );
  33.     rs_queryGetPlayerStats          = trap_Cvar_Get( "rs_queryGetPlayerStats",          "SELECT `points`, `diff_points`, `races`, (SELECT SUM(`overall_tries`) FROM `player_map` WHERE `player_id` = `p`.`id` LIMIT 1) `race_tries`, `maps`, `playtime`, (SELECT SUM(`racing_time`) FROM `player_map` WHERE `player_id` = `p`.`id` LIMIT 1) `racing_time`, DATE_FORMAT(`created`, '%%Y-%%m-%%d') `first_seen`, (SELECT `date` FROM `player_history` WHERE `player_id` = `p`.`id` ORDER BY `date` DESC LIMIT 1) `last_seen` FROM `player` `p` WHERE `simplified` = '%s' LIMIT 1;", CVAR_ARCHIVE );
  34.     rs_queryGetPlayerPoints         = trap_Cvar_Get( "rs_queryGetPlayerPoints",         "SELECT `points` FROM `player` WHERE `id` = '%d' LIMIT 1;", CVAR_ARCHIVE );
  35.     rs_queryRegisterPlayer          = trap_Cvar_Get( "rs_queryRegisterPlayer",          "UPDATE `player` SET `auth_name` = '%s', `auth_email` = '%s', `auth_pass` = MD5('%s%s'), `auth_mask` = 1, `auth_token` = MD5('%s%s') WHERE `simplified` = '%s' AND (`auth_mask` = 0 OR `auth_mask` IS NULL);", CVAR_ARCHIVE );
  36.     rs_queryGetPlayerNick           = trap_Cvar_Get( "rs_queryGetPlayerNick",           "SELECT `name` FROM `player` WHERE `id` = '%d' LIMIT 1;", CVAR_ARCHIVE );
  37.     rs_queryUpdatePlayerNick        = trap_Cvar_Get( "rs_queryUpdatePlayerNick",        "UPDATE `player` SET `name` = '%s', `simplified` = '%s' WHERE `id` = %d;", CVAR_ARCHIVE );
  38.     rs_queryUpdatePlayerPlaytime    = trap_Cvar_Get( "rs_queryUpdatePlayerPlaytime",    "UPDATE `player` SET `playtime` = `playtime` + %d WHERE `id` = %d;", CVAR_ARCHIVE );
  39.     rs_queryUpdatePlayerRaces       = trap_Cvar_Get( "rs_queryUpdatePlayerRaces",       "UPDATE `player` SET `races` = races + 1 WHERE `id` = %d;", CVAR_ARCHIVE );
  40.     rs_queryUpdatePlayerMaps        = trap_Cvar_Get( "rs_queryUpdatePlayerMaps",        "UPDATE `player` SET `maps` = (SELECT COUNT(`map_id`) FROM `player_map` WHERE `player_id` = `player`.`id`) WHERE `id` = %d;", CVAR_ARCHIVE );
  41.     rs_queryUpdatePlayerPoints      = trap_Cvar_Get( "rs_queryUpdatePlayerPoints",      "UPDATE `player` SET `points` = (SELECT SUM(`points`) FROM `player_map` WHERE `player_id` = `player`.`id`), `diff_points` = (`points` - (SELECT `points` FROM `player_history` WHERE `player_id` = `player`.`id` ORDER BY `date` DESC LIMIT 1)) WHERE `id` IN(%s);", CVAR_ARCHIVE );
  42.     rs_queryUpdatePlayerHistory     = trap_Cvar_Get( "rs_queryUpdatePlayerHistory",     "INSERT INTO `player_history` (`player_id`, `date`, `races`, `maps`, `playtime`, `points`) SELECT `p`.`id`, DATE_SUB(NOW(), INTERVAL 1 DAY), `p`.`races`, `p`.`maps`, `p`.`playtime`, `p`.`points` FROM `player` `p` WHERE `p`.`playtime` IS NOT NULL AND `p`.`playtime` > 0 AND (SELECT `player_id` FROM `player_history` WHERE `player_id` = `p`.`id` AND ( `date` = DATE_SUB(NOW(), INTERVAL 1 DAY) OR ( `date` < DATE_SUB(NOW(), INTERVAL 1 DAY) AND `races` = `p`.`races` AND `points` = `p`.`points` AND `maps` = `p`.`maps` AND `playtime` = `p`.`playtime`) ) ORDER BY `date` DESC LIMIT 1) IS NULL;", CVAR_ARCHIVE );
  43.     rs_queryPurgePlayerHistory      = trap_Cvar_Get( "rs_queryPurgePlayerHistory",      "DELETE FROM `player_history` WHERE `date` < DATE_SUB(NOW(), INTERVAL %d DAY);", CVAR_ARCHIVE );
  44.     rs_queryGetServer               = trap_Cvar_Get( "rs_queryGetServer",               "SELECT `id`, `user` FROM `gameserver` WHERE `user` = CONCAT(USER(), ':', %d) LIMIT 1;", CVAR_ARCHIVE );
  45.     rs_queryGetServerById           = trap_Cvar_Get( "rs_queryGetServerById",           "SELECT `id`, `user` FROM `gameserver` WHERE `id` = %d LIMIT 1;", CVAR_ARCHIVE );
  46.     rs_queryAddServer               = trap_Cvar_Get( "rs_queryAddServer",               "INSERT INTO `gameserver` (`user`, `servername`, `created`) VALUES(CONCAT(USER(), ':', %d), '%s', NOW());", CVAR_ARCHIVE );
  47.     rs_queryIncrementServerRaces    = trap_Cvar_Get( "rs_queryIncrementServerRaces",    "UPDATE `gameserver` SET `races` = `races` + 1 WHERE `user` = CONCAT(USER(), ':', %d);", CVAR_ARCHIVE );
  48.     rs_queryUpdateServerData        = trap_Cvar_Get( "rs_queryUpdateServerData",        "UPDATE `gameserver` SET `servername` = '%s', `playtime` = `playtime` + %d, `maps` = (SELECT COUNT(DISTINCT map_id) FROM `race` WHERE `server_id` = `gameserver`.`id`) WHERE `user` = CONCAT(USER(), ':', %d);", CVAR_ARCHIVE );
  49.     rs_queryGetMap                  = trap_Cvar_Get( "rs_queryGetMapId",                "SELECT `id` FROM `map` WHERE `name` = '%s' LIMIT 1;", CVAR_ARCHIVE );
  50.     rs_queryAddMap                  = trap_Cvar_Get( "rs_queryAddMap",                  "INSERT INTO `map` (`name`, `created`) VALUES('%s', NOW());", CVAR_ARCHIVE );
  51.     rs_queryGetMapStats             = trap_Cvar_Get( "rs_queryGetMapStats",             "SELECT IF(`freestyle`, 'freestyle', 'race') `type`, `m`.`races`, SUM(`pm`.`overall_tries`) as `tries`, CAST(AVG(`pm`.`overall_tries`) AS UNSIGNED) `avg_overall_tries`, CAST(AVG(`pm`.`tries`) AS UNSIGNED) `avg_tries`, CAST(AVG(`pm`.`duration`) AS UNSIGNED) `avg_duration`, `m`.`playtime`, DATE_FORMAT(`m`.`created`, '%%Y-%%m-%%d') `created`, MIN(`pm`.`time`) `best_time`, MAX(`pm`.`time`) `worst_time`, COUNT(`pm`.`player_id`) `players` FROM map m LEFT JOIN player_map pm ON pm.map_id = m.id WHERE name = '%s' GROUP BY m.`id`;", CVAR_ARCHIVE );
  52.     rs_queryUpdateMapRating         = trap_Cvar_Get( "rs_queryUpdateMapRating",         "UPDATE `map` SET `rating` = (SELECT SUM(`value`) / COUNT(`player_id`) FROM `map_rating` WHERE `map_id` = `map`.`id`), `ratings` = (SELECT COUNT(`player_id`) FROM `map_rating` WHERE `map_id` = `map`.`id`) WHERE `id` = %d;", CVAR_ARCHIVE );
  53.     rs_queryUpdateMapPlaytime       = trap_Cvar_Get( "rs_queryUpdateMapPlaytime",       "UPDATE `map` SET `playtime` = `playtime` + %d WHERE `id` = %d;", CVAR_ARCHIVE );
  54.     rs_queryUpdateMapRaces          = trap_Cvar_Get( "rs_queryUpdateMapRaces",          "UPDATE `map` SET `races` = `races` + 1 WHERE `id` = %d;", CVAR_ARCHIVE );
  55.     rs_queryAddRace                 = trap_Cvar_Get( "rs_queryAddRace",                 "INSERT INTO `race` (`player_id`, `map_id`, `time`, `tries`, `duration`, `server_id`, `created`, `prejumped`) VALUES(%d, %d, %d, %d, %d, %d, NOW(), '%s');", CVAR_ARCHIVE );
  56.     rs_queryGetPlayerMap            = trap_Cvar_Get( "rs_queryGetPlayerMap",            "SELECT `points`, `time`, `prejumped`, `races`, `playtime`, `created` FROM `player_map` WHERE `player_id` = %d AND `map_id` = %d LIMIT 1;", CVAR_ARCHIVE );
  57.     rs_queryUpdatePlayerMap         = trap_Cvar_Get( "rs_queryUpdatePlayerMap",         "INSERT INTO `player_map` (`player_id`, `map_id`, `time`, `races`, `server_id`, `tries`, `duration`, `created`, `prejumped`) VALUES(%d, %d, %d, 1, %d, (SELECT SUM(`tries`) FROM `race` WHERE `player_id` = %d AND `map_id` = %d AND `tries` IS NOT NULL), (SELECT SUM(`duration`) FROM `race` WHERE `player_id` = %d AND `map_id` = %d AND `duration` IS NOT NULL), NOW(), '%s') ON DUPLICATE KEY UPDATE `races` = `races` + 1, `created` = IF( VALUES(`time`) < `time` OR `time` = 0 OR `time` IS NULL, NOW(), `created`), `server_id` = IF( VALUES(`time`) < `time` OR `time` = 0 OR `time` IS NULL, VALUES(`server_id`), `server_id`), `tries` = IF( VALUES(`time`) < `time` OR `time` = 0 OR `time` IS NULL, VALUES(`tries`), `tries`), `duration` = IF( VALUES(`time`) < `time` OR `time` = 0 OR `time` IS NULL, VALUES(`duration`), `duration`), `prejumped` = IF( VALUES(`time`) < `time` OR `time` = 0 OR `time` IS NULL, VALUES(`prejumped`), `prejumped`), `time` = IF( VALUES(`time`) < `time` OR `time` = 0 OR `time` IS NULL, VALUES(`time`), `time`);", CVAR_ARCHIVE );
  58.     rs_queryUpdatePlayerMapInfo     = trap_Cvar_Get( "rs_queryUpdatePlayerMapInfo",     "INSERT INTO `player_map` (`player_id`, `map_id`, `playtime`, overall_tries, racing_time) VALUES(%d, %d, %d, %d, %d) ON DUPLICATE KEY UPDATE `playtime` = `playtime` + VALUES(`playtime`), `overall_tries` = `overall_tries` + VALUES(`overall_tries`), `racing_time` = `racing_time` + VALUES(`racing_time`);", CVAR_ARCHIVE );
  59.     rs_queryGetPlayerMapHighscore   = trap_Cvar_Get( "rs_queryGetPlayerMapHighScore",   "SELECT `p`.`id`, `pm`.`time`, `pm`.`overall_tries`, `p`.`name`, `pm`.`races`, `pm`.`playtime`, `pm`.`created` FROM `player_map` `pm` INNER JOIN `player` `p` ON `p`.`id` = `pm`.`player_id` WHERE `pm`.`map_id` = %d AND `pm`.`player_id` = %d LIMIT 1;", CVAR_ARCHIVE );
  60.     rs_queryGetPlayerMapHighscores  = trap_Cvar_Get( "rs_queryGetPlayerMapHighScores",  "SELECT `p`.`id`, `pm`.`time`, `p`.`name`, `pm`.`races`, `pm`.`playtime`, `pm`.`created`, `pm`.`prejumped` FROM `player_map` `pm` INNER JOIN `player` `p` ON `p`.`id` = `pm`.`player_id` WHERE `pm`.`time` IS NOT NULL AND `pm`.`time` > 0 AND `pm`.`map_id` = %d AND `pm`.`prejumped` in (%s) ORDER BY `pm`.`time` ASC;", CVAR_ARCHIVE );
  61.     rs_queryResetPlayerMapPoints    = trap_Cvar_Get( "rs_queryResetPlayerMapPoints",    "UPDATE `player_map` SET `points` = 0 WHERE `map_id` = %d;", CVAR_ARCHIVE );
  62.     rs_queryUpdatePlayerMapPoints   = trap_Cvar_Get( "rs_queryUpdatePlayerMapPoints",   "UPDATE `player_map` SET `points` = %d WHERE `map_id` = %d AND `player_id` = %d;", CVAR_ARCHIVE );
  63.     rs_querySetMapRating            = trap_Cvar_Get( "rs_querySetMapRating",            "INSERT INTO `map_rating` (`player_id`, `map_id`, `value`, `created`) VALUES(%d, %d, %d, NOW()) ON DUPLICATE KEY UPDATE `value` = VALUE(`value`), `changed` = NOW();", CVAR_ARCHIVE );
  64.     rs_queryLoadMapList             = trap_Cvar_Get( "rs_queryLoadMapList",             "SELECT name FROM map WHERE freestyle = '%d' AND status = 'enabled' ORDER BY %s;", CVAR_ARCHIVE);
  65.     rs_queryMapFilter               = trap_Cvar_Get( "rs_queryMapFilter",               "SELECT id, name FROM map WHERE name LIKE '%%%s%%' AND freestyle = '%s' LIMIT %u, %u;", CVAR_ARCHIVE );
  66.     rs_queryMapFilterCount          = trap_Cvar_Get( "rs_queryMapFilterCount",          "SELECT COUNT(id)FROM map WHERE name LIKE '%%%s%%' AND freestyle = '%s';", CVAR_ARCHIVE );
  67.     rs_queryUpdateCheckpoint        = trap_Cvar_Get( "rs_queryUpdateCheckpoint",        "INSERT INTO `checkpoint` (`player_id`, `map_id`, `time`, `num`) VALUES(%d, %d, %d, %d) ON DUPLICATE KEY UPDATE `time` = VALUES(`time`);", CVAR_ARCHIVE );
  68.     rs_queryGetPlayerMapCheckpoints = trap_Cvar_Get( "rs_queryGetPlayerMapCheckpoints", "SELECT `time` FROM `checkpoint` WHERE `map_id` = %d AND `player_id` = %d ORDER BY `num` ASC;", CVAR_ARCHIVE );
  69.     rs_queryLoadMapHighscores       = trap_Cvar_Get( "rs_queryLoadMapHighscores",       "SELECT pm.time, p.name, pm.created, pm.prejumped FROM player_map AS pm LEFT JOIN player AS p ON p.id = pm.player_id LEFT JOIN map AS m ON m.id = pm.map_id WHERE pm.time IS NOT NULL AND pm.time > 0 AND m.id = %d AND pm.prejumped in (%s) ORDER BY time ASC LIMIT %d", CVAR_ARCHIVE );
  70.     rs_queryLoadMapOneliners        = trap_Cvar_Get( "rs_queryLoadMapOneliners",        "SELECT `oneliner`, `pj_oneliner` FROM `map` WHERE `id` = %d;", CVAR_ARCHIVE );
  71.     rs_querySetMapOneliner          = trap_Cvar_Get( "rs_querySetMapOneliner",          "UPDATE `map` SET `%s` = '%s' WHERE `id` = %d;", CVAR_ARCHIVE );
  72.  
  73. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!