io.on('connection', async function (socket) {
let params = socket.handshake.query.params
let vars = socket.handshake.query
let prov = validateAppUrl(params, "6Uc75GjlyLtxZzDgXHc8");
if (!prov.status) return console.log(`err1`) && socket.disconnect()
params = getUrlVars(params)
if (Number(params.vk_user_id) != Number(socket.handshake.query.uid)) {
console.log(`err`)
return socket.disconnect()
}
console.log(`ok`)
con.query(`SELECT * FROM users WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
if (result.length == 0) {
let name = socket.handshake.query.nick
let new_name = name.replace(/[^a-zа-яё0-9\s]/gi," ")
con.query(`INSERT INTO users (uid,photo,nick, ip) VALUES ('${socket.handshake.query.uid}','${socket.handshake.query.photo}','${new_name}', '${socket.handshake.address}')`, function(err,result){
if (err) {
return console.log(err)
}
con.query(`SELECT * FROM users WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
if (result.length > 0) {
con.query(`UPDATE users SET online = '1' WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
con.query(`SELECT * FROM users WHERE online='1'`, function(err,result){
if (err) {
return console.log(err)
}
socket.emit(`response`,{
'type':'online',
'count':result.length
})
})
})
con.query(`SELECT * FROM users WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
if (result[0].rules == 0) {
socket.emit(`response`,{
'type':'noaccess_rules'
})
}
})
socket.emit(`response`, {
'type':'userdata',
'bonus':result[0].bonus,
'balance':result[0].balance,
'ban':result[0].ban
})
}
})
})
}
if (result.length > 0) {
con.query(`UPDATE users SET ip='${socket.handshake.address}' WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
})
let info = result[0]
let bonus = 0
const now = new Date()
let year = now.getFullYear()
let month = Number(now.getMonth() + 1)
let day = now.getDate()
if(month < 10) {
month = `0${month}`
}
if(day < 10) {
day = `0${day}`
}
let time = day + "." + month + "." + year
// сутки = 86400
let usertime = info.lastbonus
if(usertime != time) {
bonus = 1
con.query(`UPDATE users SET bonus = '1' WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
})
}
if(usertime == time) {
bonus = 0
con.query(`UPDATE users SET bonus = '0' WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
})
}
con.query(`UPDATE users SET online = '1' WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
con.query(`SELECT * FROM users WHERE online='1'`, function(err,result){
if (err) {
return console.log(err)
}
socket.emit(`response`,{
'type':'online',
'count':result.length
})
})
})
con.query(`SELECT * FROM users WHERE uid = '${socket.handshake.query.uid}'`, function(err,result){
if (err) {
return console.log(err)
}
if (result[0].rules == 0) {
socket.emit(`response`,{
'type':'noaccess_rules'
})
}
socket.emit(`response`, {
'type':'userdata',
'balance':result[0].balance,
'ban':result[0].ban,
'bonus': bonus
})
})
}
})
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Danger Studio - разработка чат-ботов VK</title>
<link rel="stylesheet" href="../css/style.css">
</head>
<body>
<div id="siteIntro">
<h1 align="center" class="siteName">Dander Studio</h1>
<p align="center" class="siteDescription">Студия разработки чат-ботов Вконтакте</p>
<a href="https://vk.com/ymenaidtopa" class="buyButton">Заказать</a>
</div>
<div id="siteContent">
<p class="contentDescription"></p>
</div>
</body>
</html>
const videobonus = async() => {
if (!isMobile) {
setmodal('errads')
}
else {console.log(isMobile)
setscreen('home')
setisads(1)
setpopout(<ScreenSpinner size='large' />)
await bridge.send("VKWebAppShowNativeAds", {ad_format:"reward"})
.then(data => window.socket.emit(`request`,{
'type':'watchads',
'data':data,
'prov':uniquecode
}) & setpopout(null))
.catch(error => window.socket.emit(`request`,{
'type':'watchads',
'data':{result:false},
'prov':uniquecode
}) & setpopout(null))}
}