Advertisement
Guest User

Untitled

a guest
Mar 22nd, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1.  
  2. var b = schedule.scheduleJob('*/15 * * * * *', function(){
  3. var sql = "SELECT * FROM counterStrikeGlobalOffensive WHERE updatePlayer='1' LIMIT 1";
  4. con.query(sql, function (err, result) {
  5. if (err) throw err;
  6. if(result.length == 0){
  7. return;
  8. }
  9. s.getPlayerSummaries({
  10. steamids: [result[0].steam64ID],
  11. callback: function(err, data) {
  12. var myData = data.response.players;
  13. var gameId = myData[0].gameid;
  14. var name = myData[0].personaname;
  15.  
  16. if(gameId && gameId == 730){
  17. CSGOCli.playerProfileRequest(CSGOCli.ToAccountID(result[0].steam64ID));
  18. CSGOCli.on("playerProfile", function(profile) {
  19.  
  20. if(profile.account_profiles[0].vac_banned == null){
  21. var vac = 0;
  22. }else{
  23. var vac = profile.account_profiles[0].vac_banned;
  24. }
  25.  
  26. var sqlss = 'UPDATE counterStrikeGlobalOffensive SET steamNick="'+ name +'",clientRank="'+ profile.account_profiles[0].ranking.rank_id +'",wins="'+ profile.account_profiles[0].ranking.wins +'", isVACBanned="'+ vac +'", updatePlayer="0" WHERE id="'+ result[0].id +'" AND updatePlayer=1';
  27. con.query(sqlss , function (err, result) {
  28. if (err) throw err;
  29. console.log("1 CSGO record updated.");
  30. });
  31. });
  32. }else{
  33. var sql = 'UPDATE counterStrikeGlobalOffensive SET updatePlayer=0 WHERE id="'+ result[0].id +'"';
  34. con.query(sql, function (err, result) {
  35. if (err) throw err;
  36. console.log("CSGO updateProfile 0.");
  37. });
  38. }
  39. }
  40. });
  41. });
  42. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement