API tools faq
paste
Advertisement
ercimen

server

ercimen
May 3rd, 2016
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.46 KB | None | 0 0
raw download clone embed print report
  1. var mysql = require('mysql');
  2. var log4js = require('log4js');
  3. var io = require('socket.io')(8000);
  4. var request = require('request');
  5. var fs = require('fs');
  6. var md5 = require('md5');
  7. var sha256 = require('sha256');
  8. var math = require('mathjs');
  9.  
  10. log4js.configure({
  11. appenders: [
  12. { type: 'console' },
  13. { type: 'file', filename: 'logs/site.log' }
  14. ]
  15. });
  16. var logger = log4js.getLogger();
  17.  
  18. var pool = mysql.createPool({
  19. connectionLimit : 10,
  20. database: 'roulette',
  21. host: 'localhost',
  22. user: 'root',
  23. password: 'admin'
  24. });
  25.  
  26. process.on('uncaughtException', function (err) {
  27. logger.trace('Strange error');
  28. logger.debug(err);
  29. });
  30.  
  31. /* */
  32. var accept = 30;
  33. var wait = 10;
  34. var br = 3;
  35. var chat = 2;
  36. var chatb = 2000000;
  37. var maxbet = 5000000;
  38. var minbet = 1;
  39. var q1 = 2;
  40. var q2 = 14;
  41. var timer = -1;
  42. var users = {};
  43. var roll = 0;
  44. var currentBets = [];
  45. var historyRolls = [];
  46. var usersBr = {};
  47. var usersAmount = {};
  48. var currentSums = {
  49. '0-0': 0,
  50. '1-7': 0,
  51. '8-14': 0
  52. };
  53. var currentRollid = 0;
  54. var pause = false;
  55. var hash = '';
  56. var last_message = {};
  57. /* */
  58.  
  59. load();
  60.  
  61. var prices;
  62. request('http://backpack.tf/api/IGetMarketPrices/v1/?key=56fce4a5c4404545131c8fcf&compress=1&appid=730', function(error, response, body) {
  63. prices = JSON.parse(body);
  64. if(prices.response.success == 0) {
  65. logger.warn('Loaded fresh prices');
  66. if(fs.existsSync(__dirname + '/prices.txt')){
  67. prices = JSON.parse(fs.readFileSync(__dirname + '/prices.txt'));
  68. logger.warn('Prices loaded from cache');
  69. } else {
  70. logger.error('No prices in cache');
  71. process.exit(0);
  72. }
  73. } else {
  74. fs.writeFileSync('prices.txt', body);
  75. logger.trace('New prices loaded');
  76. }
  77. });
  78.  
  79. updateHash();
  80. function updateHash() {
  81. query('SELECT * FROM `hash` ORDER BY `id` DESC LIMIT 1', function(err, row) {
  82. if(err) {
  83. logger.error('Cant get the hash, stopping');
  84. logger.debug(err);
  85. process.exit(0);
  86. return;
  87. }
  88. if(row.length == 0) {
  89. logger.error('Wrong hash found, stopping');
  90. process.exit(0);
  91. } else {
  92. if(hash != row[0].hash) logger.warn('Loaded hash'+row[0].hash);
  93. hash = row[0].hash;
  94. }
  95. });
  96. }
  97.  
  98. io.on('connection', function(socket) {
  99. var user = false;
  100. socket.on('hash', function(hash) {
  101. query('SELECT * FROM `users` WHERE `hash` = '+pool.escape(hash), function(err, row) {
  102. if((err) || (!row.length)) return socket.disconnect();
  103. user = row[0];
  104. users[user.steamid] = {
  105. socket: socket.id,
  106. balance: parseInt(row[0].balance)
  107. }
  108. socket.emit('message', {
  109. accept: accept,
  110. balance: row[0].balance,
  111. br: br,
  112. chat: chat,
  113. chatb: chatb,
  114. count: timer-wait,
  115. icon: row[0].avatar,
  116. maxbet: maxbet,
  117. minbet: minbet,
  118. name: row[0].name,
  119. rank: row[0].rank,
  120. rolls: historyRolls,
  121. type: 'hello',
  122. user: row[0].steamid
  123. });
  124. socket.emit('message', {
  125. type: 'logins',
  126. count: Object.size(io.sockets.connected)
  127. });
  128. currentBets.forEach(function(itm) {
  129. socket.emit('message', {
  130. type: 'bet',
  131. bet: {
  132. amount: itm.amount,
  133. betid: itm.betid,
  134. icon: itm.icon,
  135. lower: itm.lower,
  136. name: itm.name,
  137. rollid: itm.rollid,
  138. upper: itm.upper,
  139. user: itm.user,
  140. won: null
  141. },
  142. sums: {
  143. 0: currentSums['0-1'],
  144. 1: currentSums['1-8'],
  145. 2: currentSums['8-15'],
  146. }
  147. });
  148. });
  149. });
  150. });
  151. socket.on('mes', function(m) {
  152. if(!user) return;
  153. logger.debug(m);
  154. if(m.type == "bet") return setBet(m, user, socket);
  155. if(m.type == "balance") return getBalance(user, socket);
  156. if(m.type == "chat") return ch(m, user, socket);
  157. if(m.type == "plus") return plus(user, socket);
  158. });
  159. socket.on('disconnect', function() {
  160. io.sockets.emit('message', {
  161. type: 'logins',
  162. count: Object.size(io.sockets.connected)
  163. });
  164. delete users[user.steamid];
  165. })
  166. });
  167.  
  168. function plus(user, socket) {
  169. query('SELECT * FROM `users` WHERE `steamid` = '+pool.escape(user.steamid), function(err, row) {
  170. if(err) return;
  171. if(time() > row[0].plus) {
  172. query('UPDATE `users` SET `plus` = '+pool.escape(time()+10*60)+', `balance` = `balance` + 1 WHERE `steamid` = '+user.steamid);
  173. socket.emit('message', {
  174. type: 'alert',
  175. alert: 'Confirmed'
  176. });
  177. getBalance(user, socket);
  178. } else {
  179. socket.emit('message', {
  180. type: 'alert',
  181. alert: 'You have '+(row[0].plus-time())+' to accept'
  182. });
  183. }
  184. });
  185. }
  186.  
  187. function ch(m, user, socket) {
  188. if(m.msg) {
  189. if(last_message[user.steamid]+1 >= time()) {
  190. console.log('Too fast');
  191. return;
  192. } else {
  193. last_message[user.steamid] = time();
  194. }
  195. var res = null;
  196. if (res = /^\/send ([0-9]*) ([0-9]*)/.exec(m.msg)) {
  197. logger.trace('We need to send coins from '+res[2]+' to '+res[1]);
  198. query('SELECT `balance` FROM `users` WHERE `steamid` = '+pool.escape(user.steamid), function(err, row) {
  199. if((err) || (!row.length)) {
  200. logger.error('Failed to get the person in the database');
  201. logger.debug(err);
  202. socket.emit('message', {
  203. type: 'error',
  204. enable: false,
  205. error: 'Error: User not in DB.'
  206. });
  207. return;
  208. }
  209. if(row[0].balance < res[2]) {
  210. socket.emit('message', {
  211. type: 'error',
  212. enable: false,
  213. error: 'Error: Insufficient funds.'
  214. });
  215. } else if(res[2] <= 0) {
  216. socket.emit('message', {
  217. type: 'error',
  218. enable: false,
  219. error: 'Error: Amount must be greater than 0.'
  220. });
  221. } else {
  222. query('SELECT `name` FROM `users` WHERE `steamid` = '+pool.escape(res[1]), function(err2, row2) {
  223. if((err) || (!row.length)) {
  224. logger.error('Failed to get the STEAMID');
  225. logger.debug(err);
  226. socket.emit('message', {
  227. type: 'error',
  228. enable: false,
  229. error: 'Error: Unknown receiver.'
  230. });
  231. return;
  232. }
  233. query('UPDATE `users` SET `balance` = `balance` - '+res[2]+' WHERE `steamid` = '+pool.escape(user.steamid));
  234. query('UPDATE `users` SET `balance` = `balance` + '+res[2]+' WHERE `steamid` = '+pool.escape(res[1]));
  235. query('INSERT INTO `transfers` SET `from1` = '+pool.escape(user.steamid)+', `to1` = '+pool.escape(res[1])+', `amount` = '+pool.escape(res[2])+', `time` = '+pool.escape(time()));
  236. socket.emit('message', {
  237. type: 'alert',
  238. alert: 'You sent '+res[2]+' coins to '+row2[0].name+'.'
  239. });
  240. getBalance(user, socket);
  241. });
  242. }
  243. });
  244. } else if (res = /^\/mute ([0-9]*) ([0-9]*)/.exec(m.msg)) {
  245. if(user.rank > 0) {
  246. var t = time();
  247. query('UPDATE `users` SET `mute` = '+pool.escape(parseInt(t)+parseInt(res[2]))+' WHERE `steamid` = '+pool.escape(res[1]));
  248. socket.emit('message', {
  249. type: 'alert',
  250. alert: 'You mute '+res[1]+' to '+res[2]
  251. });
  252. }
  253. } else {
  254.  
  255. query('SELECT `mute` FROM `users` WHERE `steamid` = '+pool.escape(user.steamid), function(err, row) {
  256. if(err) return;
  257. if(row[0].mute > time()) {
  258. socket.emit('message', {
  259. type: 'alert',
  260. alert: 'You are muted '+(row[0].mute-time())
  261. });
  262. return;
  263. }
  264. io.sockets.emit('message', {
  265. type: 'chat',
  266. msg: safe_tags_replace(m.msg),
  267. name: user.name,
  268. icon: user.avatar,
  269. user: user.steamid,
  270. rank: user.rank,
  271. lang: m.lang,
  272. hide: m.hide
  273. });
  274. });
  275. }
  276. }
  277. }
  278.  
  279. function getBalance(user, socket) {
  280. query('SELECT `balance` FROM `users` WHERE `steamid` = '+pool.escape(user.steamid), function(err, row) {
  281. if((err) || (!row.length)) {
  282. logger.error('Failed to load your balance');
  283. logger.debug(err);
  284. socket.emit('message', {
  285. type: 'error',
  286. enable: true,
  287. error: 'Error: You are not DB.'
  288. });
  289. return;
  290. }
  291. socket.emit('message', {
  292. type: 'balance',
  293. balance: row[0].balance
  294. });
  295. if(user.steamid) users[user.steamid].balance = parseInt(row[0].balance);
  296. })
  297. }
  298.  
  299. function setBet(m, user, socket) {
  300. if((usersBr[user.steamid] !== undefined) && (usersBr[user.steamid] == br)) {
  301. socket.emit('message', {
  302. type: 'error',
  303. enable: true,
  304. error: 'You\'ve already placed '+usersBr[user.steamid]+'/'+br+' bets this roll.'
  305. });
  306. return;
  307. }
  308. if((m.amount < minbet) || (m.amount > maxbet)) {
  309. socket.emit('message', {
  310. type: 'error',
  311. enable: true,
  312. error: 'Invalid bet amount.'
  313.  
  314. });
  315. return;
  316. }
  317. if(pause) {
  318. socket.emit('message', {
  319. type: 'error',
  320. enable: false,
  321. error: 'Betting for this round is closed.'
  322. });
  323. return;
  324. }
  325. var start_time = new Date();
  326. query('SELECT `balance` FROM `users` WHERE `steamid` = '+pool.escape(user.steamid), function(err, row) {
  327. if((err) || (!row.length)) {
  328. logger.error('Failed to find DB');
  329. logger.debug(err);
  330. socket.emit('message', {
  331. type: 'error',
  332. enable: true,
  333. error: 'You are not DB'
  334. });
  335. return;
  336. }
  337. if(row[0].balance >= m.amount) {
  338. query('UPDATE `users` SET `balance` = `balance` - '+parseInt(m.amount)+' WHERE `steamid` = '+pool.escape(user.steamid), function(err2, row2) {
  339. if(err2) {
  340. logger.error('Error in withdraw');
  341. logger.debug(err);
  342. socket.emit('message', {
  343. type: 'error',
  344. enable: true,
  345. error: 'You dont have enough points'
  346. });
  347. return;
  348. }
  349. query('INSERT INTO `bets` SET `user` = '+pool.escape(user.steamid)+', `amount` = '+pool.escape(m.amount)+', `lower` = '+pool.escape(m.lower)+', `upper` = '+pool.escape(m.upper), function(err3, row3) {
  350. if(err3) {
  351. logger.error('Error in DB');
  352. logger.debug(err);
  353. return;
  354. }
  355. var end = new Date();
  356. if(usersBr[user.steamid] === undefined) {
  357. usersBr[user.steamid] = 1;
  358. } else {
  359. usersBr[user.steamid]++;
  360. }
  361. if(usersAmount[user.steamid] === undefined) {
  362. usersAmount[user.steamid] = {
  363. '0-0': 0,
  364. '1-7': 0,
  365. '8-14': 0
  366. };
  367. }
  368. usersAmount[user.steamid][m.lower+'-'+m.upper] += parseInt(m.amount);
  369. currentSums[m.lower+'-'+m.upper] += m.amount;
  370. socket.emit('message', {
  371. type: 'betconfirm',
  372. bet: {
  373. betid: row3.insertId,
  374. lower: m.lower,
  375. upper: m.upper,
  376. amount: usersAmount[user.steamid][m.lower+'-'+m.upper]
  377. },
  378. balance: row[0].balance-m.amount,
  379. mybr: usersBr[user.steamid],
  380. br: br,
  381. exec: (end.getTime()-start_time.getTime()).toFixed(3)
  382. });
  383. users[user.steamid].balance = row[0].balance-m.amount;
  384. io.sockets.emit('message', {
  385. type: 'bet',
  386. bet: {
  387. amount: usersAmount[user.steamid][m.lower+'-'+m.upper],
  388. betid: row3.insertId,
  389. icon: user.avatar,
  390. lower: m.lower,
  391. name: user.name,
  392. rollid: currentRollid,
  393. upper: m.upper,
  394. user: user.steamid,
  395. won: null
  396. },
  397. sums: {
  398. 0: currentSums['0-0'],
  399. 1: currentSums['1-7'],
  400. 2: currentSums['8-14'],
  401. }
  402. });
  403. currentBets.push({
  404. amount: m.amount,
  405. betid: row3.insertId,
  406. icon: user.avatar,
  407. lower: m.lower,
  408. name: user.name,
  409. rollid: currentRollid,
  410. upper: m.upper,
  411. user: user.steamid,
  412. });
  413. logger.debug('Bet #'+row3.insertId+' Ammount: '+m.amount);
  414. checkTimer();
  415. })
  416. });
  417. } else {
  418. socket.emit('message', {
  419. type: 'error',
  420. enable: true,
  421. error: 'You dont have any money'
  422. });
  423. }
  424. });
  425. }
  426.  
  427. function checkTimer() {
  428. if((currentBets.length > 0) && (timer == -1) && (!pause)) {
  429. logger.trace('Timer starting');
  430. timer = accept+wait;
  431. timerID = setInterval(function() {
  432. logger.trace('Timer: '+timer+' Site timer: '+(timer-wait));
  433. if (timer == wait) {
  434. pause = true;
  435. logger.trace('Pause included');
  436. var inprog = getRandomInt(0, (currentBets.length/4).toFixed(0));
  437. io.sockets.emit('message', {
  438. type: 'preroll',
  439. totalbets: currentBets.length-inprog,
  440. inprog: inprog,
  441. sums: {
  442. 0: currentSums['0-0'],
  443. 1: currentSums['1-7'],
  444. 2: currentSums['8-14'],
  445. }
  446. });
  447. }
  448. if (timer == wait-2) {
  449. logger.trace('Timer: ');
  450. toWin(); // Выбираем победителя
  451. }
  452. if(timer == 0) {
  453. logger.trace('Reset');
  454. timer = accept+wait;
  455. currentBets = [];
  456. historyRolls.push({id: currentRollid, roll: roll});
  457. if(historyRolls.length > 10) historyRolls.slice(1);
  458. usersBr = {}; // сколько пользователи внесли
  459. usersAmount = {}; // сколько пользователи внесли монеток
  460. currentSums = {
  461. '0-0': 0,
  462. '1-7': 0,
  463. '8-14': 0
  464. };
  465. currentRollid = currentRollid+1;
  466. pause = false;
  467. }
  468. timer--;
  469. }, 1000);
  470. }
  471. }
  472.  
  473. function toWin() {
  474. var sh = sha256(hash+'-'+currentRollid);
  475. roll = sh.substr(0, 8);
  476. roll = parseInt(roll, 16);
  477. roll = math.abs(roll) % 15;
  478. logger.trace('Rolled '+roll);
  479. var r = '';
  480. var s = q1;
  481. var wins = {
  482. '0-0': 0,
  483. '1-7': 0,
  484. '8-14': 0
  485. }
  486. if(roll == 0) { r = '0-0'; s = q2; wins['0-0'] = currentSums['0-0']*s; }
  487. if((roll > 0) && (roll < 8)) { r = '1-7'; wins['1-7'] = currentSums['1-7']*s; }
  488. if((roll > 7) && (roll < 15)) { r = '8-14'; wins['8-14'] = currentSums['8-14']*s; }
  489. logger.debug(currentBets);
  490. logger.debug(usersBr);
  491. logger.debug(usersAmount);
  492. logger.debug(currentSums);
  493. for(key in users) {
  494. if(usersAmount[key] === undefined) {
  495. var balance = null;
  496. var won = 0;
  497. } else {
  498. var balance = parseInt(users[key].balance)+usersAmount[key][r]*s;
  499. var won = usersAmount[key][r]*s;
  500. }
  501. if (io.sockets.connected[users[key].socket]) io.sockets.connected[users[key].socket].emit('message', {
  502. balance: balance,
  503. count: accept,
  504. nets: [{
  505. lower: 0,
  506. samount: currentSums['0-0'],
  507. swon: wins['0-0'],
  508. upper: 0
  509. }, {
  510. lower: 1,
  511. samount: currentSums['1-7'],
  512. swon: wins['1-7'],
  513. upper: 7
  514. }, {
  515. lower: 8,
  516. samount: currentSums['8-14'],
  517. swon: wins['8-14'],
  518. upper: 14
  519. }
  520. ],
  521. roll: roll,
  522. rollid: currentRollid+1,
  523. type: "roll",
  524. wait: wait-2,
  525. wobble: getRandomArbitary(0, 1),
  526. won: won
  527. });
  528. }
  529. currentBets.forEach(function(itm) {
  530. if((roll >= itm.lower) && (roll <= itm.upper)) {
  531. logger.debug('Rate #'+itm.betid+' sum '+itm.amount+' win '+(itm.amount*s));
  532. query('UPDATE `users` SET `balance` = `balance` + '+itm.amount*s+' WHERE `steamid` = '+pool.escape(itm.user));
  533. }
  534. });
  535. query('UPDATE `rolls` SET `roll` = '+pool.escape(roll)+', `hash` = '+pool.escape(hash)+', `time` = '+pool.escape(time())+' WHERE `id` = '+pool.escape(currentRollid));
  536. query('INSERT INTO `rolls` SET `roll` = -1');
  537. updateHash();
  538. }
  539.  
  540.  
  541.  
  542.  
  543.  
  544.  
  545.  
  546.  
  547.  
  548. /* */
  549. var tagsToReplace = {
  550. '&': '&amp;',
  551. '<': '&lt;',
  552. '>': '&gt;'
  553. };
  554.  
  555. function replaceTag(tag) {
  556. return tagsToReplace[tag] || tag;
  557. }
  558.  
  559. function safe_tags_replace(str) {
  560. return str.replace(/[&<>]/g, replaceTag);
  561. }
  562. Object.size = function(obj) {
  563. var size = 0,
  564. key;
  565. for (key in obj) {
  566. if (obj.hasOwnProperty(key)) size++;
  567. }
  568. return size;
  569. };
  570. function getRandomInt(min, max) {
  571. return Math.floor(Math.random() * (max - min + 1)) + min;
  572. }
  573. function getRandomArbitary(min, max) {
  574. return Math.random() * (max - min) + min;
  575. }
  576.  
  577. function query(sql, callback) {
  578. if (typeof callback === 'undefined') {
  579. callback = function() {};
  580. }
  581. pool.getConnection(function(err, connection) {
  582. if(err) return callback(err);
  583. logger.info('DB Connection ID: '+connection.threadId);
  584. connection.query(sql, function(err, rows) {
  585. if(err) return callback(err);
  586. connection.release();
  587. return callback(null, rows);
  588. });
  589. });
  590. }
  591. function load() {
  592. query('SET NAMES utf8');
  593. query('SELECT `id` FROM `rolls` ORDER BY `id` DESC LIMIT 1', function(err, row) {
  594. if((err) || (!row.length)) {
  595. logger.error('Cant get number from the last game');
  596. logger.debug(err);
  597. process.exit(0);
  598. return;
  599. }
  600. currentRollid = row[0].id;
  601. logger.trace('Roll '+currentRollid);
  602. });
  603. loadHistory();
  604. setTimeout(function() { io.listen(8080); }, 3000);
  605. }
  606. function loadHistory() {
  607. query('SELECT * FROM `rolls` ORDER BY `id` LIMIT 10', function(err, row) {
  608. if(err) {
  609. logger.error('Cant load betting history');
  610. logger.debug(err);
  611. process.exit(0);
  612. }
  613. logger.trace('Sucesfully updated history');
  614. row.forEach(function(itm) {
  615. if(itm.roll != -1) historyRolls.push(itm);
  616. });
  617. });
  618. }
  619.  
  620. function time() {
  621. return parseInt(new Date().getTime()/1000)
  622. }
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!