Advertisement
Guest User

Untitled

a guest
Jan 7th, 2018
292
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. registerPlugin({
  2.  
  3.     name: 'TS3 Stats',
  4.     version: '0.0.1',
  5.     description: 'add PUBG stats to mysql',
  6.     author: 'DeniD',
  7.     engines: '>= 0.9.21',
  8.  
  9.     vars: [
  10.         {
  11.             name: 'command',
  12.             title: 'command',
  13.             placeholder: '!stats',
  14.             type: 'string'
  15.         }
  16.     ]
  17.  
  18. },    
  19. function(sinusbot, config) {
  20.         var event = require('event');
  21.         var engine = require('engine');
  22.         var backend = require('backend');
  23.  
  24.  
  25.         event.on('chat', function (msg) {
  26.  
  27.             var msgsplit = msg.text.trim().split(" ")
  28.             if (msgsplit[0] == config.command) {
  29.  
  30.  
  31.                 var clientId = msg.client.id();
  32.                 if (msgsplit.length == 1) {
  33.                     var nickname = msg.client.name()
  34.  
  35.  
  36.                 }
  37.  
  38.             }
  39.             getInfoFromNickname(nickname, clientId);
  40.  
  41.         }
  42.     });
  43.  
  44. function getInfoFromNickname(nickname, clientId, client)
  45.  
  46. var db = require('db');
  47. var engine = require('engine');
  48. var helpers = require('helpers');
  49. var dbc = db.connect({ driver: 'mysql', host: '127.0.0.1', username: 'denid213', password: '****', database: 'ts3' }, function (err) {
  50.     if (err) { engine.log(err); }
  51. });
  52. if (dbc) dbc.exec("insert into denid213.TS3 (Name,ts3,TSDB) values ('" + nickname + "','" + client.uid + "','" + client.databaseID +"')");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement