Sikka game backend.
// ==========================================
// 🏏 SIKKA GAME - BACKEND ENGINE (1000+ Users)
// ==========================================
const ROUND_DURATION = 30000; // 30 Seconds Total
const BETTING_WINDOW = 23000; // 23 Seconds Open
// 📢 TELEGRAM CONFIGURATION
const TELEGRAM_TOKEN = "8837257790:AAEeCd7is1MLCa1UQyUrJjQ7hjNcL9HRY48";
const ADMIN_CHAT_ID = "966116673";
function doPost(e) {
try {
if (!e || !e.postData || !e.postData.contents) {
return ContentService.createTextOutput(JSON.stringify({success: false, message: "Invalid API Request"})).setMimeType(ContentService.MimeType.JSON);
}
var ss = SpreadsheetApp.getActiveSpreadsheet();
var req = JSON.parse(e.postData.contents);
// 🔥 TELEGRAM BUTTON CLICK INTERCEPTOR
if (req.callback_query) {
return handleTelegramAction(req.callback_query);
}
var action = req.action;
if (action === "register") return ContentService.createTextOutput(JSON.stringify(registerUser(ss, req))).setMimeType(ContentService.MimeType.JSON);
if (action === "login") return ContentService.createTextOutput(JSON.stringify(loginUser(ss, req))).setMimeType(ContentService.MimeType.JSON);
// SESSION AUTHENTICATION
var auth = verifySession(ss, req.phone, req.token);
if (!auth.success) return ContentService.createTextOutput(JSON.stringify(auth)).setMimeType(ContentService.MimeType.JSON);
var res;
if (action === "getUserData") res = getUserData(ss, req.phone);
else if (action === "deposit") res = depositFunds(ss, req);
else if (action === "withdraw") res = withdrawFunds(ss, req);
else if (action === "tossGetRound") res = tossGetRound(ss);
else if (action === "tossPlaceBet") res = tossPlaceBet(ss, req);
else if (action === "tossResolve") res = tossResolve(ss, req);
else res = { success: false, message: "Invalid API Action" };
return ContentService.createTextOutput(JSON.stringify(res)).setMimeType(ContentService.MimeType.JSON);
} catch (error) {
// 🛡️ Master Shield: Prevents "Connection Error" on frontend
return ContentService.createTextOutput(JSON.stringify({success: false, message: "Server Error: " + error.message})).setMimeType(ContentService.MimeType.JSON);
}
}
// 🔐 SESSION TOKEN AUTHENTICATION
function verifySession(ss, phone, token) {
var sheet = ss.getSheetByName("Users");
var data = sheet.getDataRange().getValues();
for (var i = 1; i < data.length; i++) {
if (data[i][2].toString() === phone.toString()) {
if (data[i][9] === token) { // Col J
sheet.getRange(i + 1, 7).setValue(new Date()); // Col G
return { success: true };
}
return { success: false, message: "Session Expired! Logged in from another device." };
}
}
return { success: false, message: "User not found." };
}
// 🚫 REGISTRATION & ANTI-SPAM BLOCKER
function registerUser(ss, data) {
var otpSheet = ss.getSheetByName("Common OTP");
var validOtp = otpSheet.getRange("A2").getValue().toString().trim();
if (data.otp.toString().trim() !== validOtp) return { success: false, message: "Invalid Admin OTP!" };
var phoneStr = data.phone.toString();
if (/^(\d)\1{9}$/.test(phoneStr)) return { success: false, message: "Spam/Fake numbers are not allowed!" };
if (phoneStr.length !== 10) return { success: false, message: "Invalid 10-digit number." };
var sheet = ss.getSheetByName("Users");
var users = sheet.getDataRange().getValues();
for (var i = 1; i < users.length; i++) {
if (users[i][2].toString() === phoneStr) return { success: false, message: "Mobile number already registered!" };
}
var newId = "U" + Math.floor(Math.random() * 90000 + 10000);
sheet.appendRow([newId, data.name, phoneStr, "", 0.00, 0.00, new Date(), "Active", data.pass, "", data.refCode || ""]);
return { success: true, message: "Account Created!" };
}
// 🔑 LOGIN SYSTEM
function loginUser(ss, data) {
var sheet = ss.getSheetByName("Users");
var users = sheet.getDataRange().getValues();
for (var i = 1; i < users.length; i++) {
if (users[i][2].toString() === data.phone.toString() && users[i][8].toString() === data.pass) {
if (users[i][7] !== "Active") return { success: false, message: "Account is Inactive/Archived." };
var newToken = Utilities.getUuid();
sheet.getRange(i + 1, 10).setValue(newToken);
sheet.getRange(i + 1, 7).setValue(new Date());
var playBal = parseFloat(users[i][4]) || 0;
var winBal = parseFloat(users[i][5]) || 0;
var totalBal = playBal + winBal;
return { success: true, token: newToken, balance: totalBal.toFixed(2), playBal: playBal.toFixed(2), winBal: winBal.toFixed(2) };
}
}
return { success: false, message: "Invalid Mobile or Password!" };
}
// 👤 GET USER DATA & SMART HISTORY LOADER
function getUserData(ss, phone) {
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
var totalBal = 0, playBal = 0, winBal = 0;
for (var i = 1; i < uData.length; i++) {
if (uData[i][2].toString() === phone.toString()) {
playBal = parseFloat(uData[i][4]) || 0;
winBal = parseFloat(uData[i][5]) || 0;
totalBal = playBal + winBal;
break;
}
}
var tSheet = ss.getSheetByName("Transactions");
var tData = tSheet.getDataRange().getValues();
var history = [];
for (var j = tData.length - 1; j >= 1; j--) {
if (tData[j][2].toString() === phone.toString()) {
var amt = parseFloat(tData[j][4]);
history.push({ date: tData[j][1], type: tData[j][3], amount: amt, status: tData[j][5] });
if (history.length >= 10) break;
}
}
return { success: true, balance: totalBal.toFixed(2), playBal: playBal.toFixed(2), winBal: winBal.toFixed(2), history: history };
}
// 💰 DEPOSIT FUNDS (₹50 - ₹1000 Limit) + Telegram Alert
function depositFunds(ss, req) {
var lock = LockService.getScriptLock();
if (!lock.tryLock(5000)) return { success: false, message: "System busy, please try again in 5 seconds." };
try {
var amount = parseFloat(req.amount);
if (amount < 50 || amount > 1000) return { success: false, message: "Deposit limit is ₹50 to ₹1000." };
var tSheet = ss.getSheetByName("Transactions");
var txnId = "TXN" + Math.floor(Math.random() * 900000 + 100000);
tSheet.appendRow([txnId, new Date(), req.phone, "Deposit", amount.toFixed(2), "Pending", req.utr]);
var lastRow = tSheet.getLastRow();
if (lastRow > 2) {
var sourceCell = tSheet.getRange(lastRow - 1, 6);
var targetCell = tSheet.getRange(lastRow, 6);
sourceCell.copyTo(targetCell);
targetCell.setValue("Pending");
}
sendTelegramAlert(txnId, "Deposit", amount.toFixed(2), req.phone, req.utr);
return { success: true };
} finally {
lock.releaseLock();
}
}
// 🏦 WITHDRAW FUNDS + Telegram Alert
function withdrawFunds(ss, req) {
var lock = LockService.getScriptLock();
if (!lock.tryLock(5000)) return { success: false, message: "Server busy, try again in 5 seconds." };
try {
var amount = parseFloat(req.amount);
if (amount < 100 || amount > 2000) return { success: false, message: "Withdrawal limit is ₹100 to ₹2000." };
var tSheet = ss.getSheetByName("Transactions");
var tData = tSheet.getDataRange().getValues();
var todayStr = new Date().toDateString();
var dailyCount = 0;
for (var j = tData.length - 1; j >= 1; j--) {
if (tData[j][2].toString() === req.phone.toString() && tData[j][3] === "Withdrawal") {
var txnDateStr = new Date(tData[j][1]).toDateString();
if (txnDateStr === todayStr) dailyCount++;
}
}
if (dailyCount >= 1) return { success: false, message: "Only 1 withdrawal allowed per day." };
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
for (var i = 1; i < uData.length; i++) {
if (uData[i][2].toString() === req.phone.toString()) {
var playBal = parseFloat(uData[i][4]) || 0;
var winBal = parseFloat(uData[i][5]) || 0;
if (playBal > 0) return { success: false, message: "⚠️ Please play your remaining Play Balance (₹" + playBal.toFixed(2) + ") before withdrawing!" };
if (winBal < amount) return { success: false, message: "Insufficient Winning Balance!" };
uSheet.getRange(i + 1, 4).setValue(req.upiId);
uSheet.getRange(i + 1, 6).setValue((winBal - amount).toFixed(2));
var txnId = "TXN" + Math.floor(Math.random() * 900000 + 100000);
tSheet.appendRow([txnId, new Date(), req.phone, "Withdrawal", "-" + amount.toFixed(2), "Pending", req.upiId]);
var lastRow = tSheet.getLastRow();
if (lastRow > 2) {
var sourceCell = tSheet.getRange(lastRow - 1, 6);
var targetCell = tSheet.getRange(lastRow, 6);
sourceCell.copyTo(targetCell);
targetCell.setValue("Pending");
}
sendTelegramAlert(txnId, "Withdrawal", "-" + amount.toFixed(2), req.phone, req.upiId);
return { success: true };
}
}
} finally {
lock.releaseLock();
}
}
// 🪙 GET ROUND DATA
function tossGetRound(ss) {
var sheet = ss.getSheetByName("Toss_Rounds");
var data = sheet.getDataRange().getValues();
var now = new Date().getTime();
var activeRound = null;
var history = [];
for (var i = data.length - 1; i >= 1; i--) {
var status = data[i][2];
if ((status === "Completed" || status === "Server Issue") && history.length < 30) {
history.push({ roundId: data[i][0], result: data[i][3] });
}
if (status === "Active" || status === "Processing" || status === "Server Issue") {
var roundTimestamp = new Date(data[i][1]).getTime();
if (now - roundTimestamp < ROUND_DURATION) {
if(!activeRound) activeRound = { roundId: data[i][0], timestamp: roundTimestamp };
} else {
if (status === "Active") sheet.getRange(i + 1, 3).setValue("Processing");
}
}
}
if (!activeRound) {
var newRoundId = "RND-" + Math.floor(Math.random() * 1000000);
var createTime = new Date();
sheet.appendRow([newRoundId, createTime, "Active", "Pending"]);
activeRound = { roundId: newRoundId, timestamp: createTime.getTime() };
}
return { success: true, round: activeRound, history: history, serverTime: new Date().getTime() };
}
// 💰 PLACE BET
function tossPlaceBet(ss, req) {
var lock = LockService.getScriptLock();
if (!lock.tryLock(5000)) return { success: false, message: "System is processing, please wait." };
try {
var amount = parseFloat(req.amount);
if (amount < 5 || amount > 100) return { success: false, message: "Bet limit is ₹5 to ₹100." };
if (req.side !== "HEAD" && req.side !== "TAIL") return { success: false, message: "Invalid bet side." };
var rSheet = ss.getSheetByName("Toss_Rounds");
var rData = rSheet.getDataRange().getValues();
var rIndex = -1;
var roundTimestamp = 0;
for (var i = rData.length - 1; i >= 1; i--) {
if (rData[i][0] === req.roundId) {
rIndex = i + 1;
roundTimestamp = new Date(rData[i][1]).getTime();
break;
}
}
if (rIndex === -1) return { success: false, message: "Round not found." };
if (new Date().getTime() - roundTimestamp > BETTING_WINDOW) return { success: false, message: "Betting is closed for this round!" };
var bSheet = ss.getSheetByName("Toss_Bets");
var bData = bSheet.getDataRange().getValues();
var todayStr = new Date().toDateString();
var userBetToday = 0;
var currentRoundBettors = [];
for (var k = bData.length - 1; k >= 1; k--) {
var bDate = new Date(bData[k][1]);
if (bData[k][2].toString() === req.phone.toString() && bDate.toDateString() === todayStr) userBetToday++;
if (bData[k][1] === req.roundId) {
if (currentRoundBettors.indexOf(bData[k][2].toString()) === -1) currentRoundBettors.push(bData[k][2].toString());
}
}
if (currentRoundBettors.length === 0 || (currentRoundBettors.length === 1 && currentRoundBettors[0] === req.phone.toString())) {
if (amount > 20) return { success: false, message: "Single player bet limit is ₹20." };
if (userBetToday >= 5) return { success: false, message: "Single player limit of 5 bets/day reached." };
}
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
var uIndex = -1;
var playDeducted = 0, winDeducted = 0;
for (var j = 1; j < uData.length; j++) {
if (uData[j][2].toString() === req.phone.toString()) {
uIndex = j + 1;
var playBal = parseFloat(uData[j][4]) || 0;
var winBal = parseFloat(uData[j][5]) || 0;
if ((playBal + winBal) < amount) return { success: false, message: "Insufficient Wallet Balance!" };
if (playBal >= amount) {
playDeducted = amount; winDeducted = 0;
uSheet.getRange(uIndex, 5).setValue((playBal - amount).toFixed(2));
} else {
playDeducted = playBal; winDeducted = amount - playBal;
uSheet.getRange(uIndex, 5).setValue(0.00);
uSheet.getRange(uIndex, 6).setValue((winBal - winDeducted).toFixed(2));
}
break;
}
}
var betId = "TB-" + Math.floor(Math.random() * 1000000);
bSheet.appendRow([betId, req.roundId, req.phone, req.side, amount.toFixed(2), "Locked", 0, playDeducted.toFixed(2), winDeducted.toFixed(2)]);
return { success: true };
} finally {
lock.releaseLock();
}
}
// 🏆 RESOLVE ROUND
function tossResolve(ss, req) {
var lock = LockService.getScriptLock();
// BUG FIX: Removed 'window.tossResultCache' to prevent backend crash
if (!lock.tryLock(5000)) return { success: false, message: "System is busy resolving round." };
try {
var rSheet = ss.getSheetByName("Toss_Rounds");
var rData = rSheet.getDataRange().getValues();
var rIndex = -1;
for (var i = rData.length - 1; i >= 1; i--) {
if (rData[i][0] === req.roundId) {
if (rData[i][2] === "Completed" || rData[i][2] === "Server Issue") return { success: true, result: rData[i][3] };
rIndex = i + 1;
break;
}
}
if (rIndex === -1) return { success: false };
var bSheet = ss.getSheetByName("Toss_Bets");
var bData = bSheet.getDataRange().getValues();
var headSum = 0, tailSum = 0;
var roundBets = [], uniquePlayers = [];
for (var j = 1; j < bData.length; j++) {
if (bData[j][1] === req.roundId) {
var pDed = parseFloat(bData[j][7]);
var wDed = parseFloat(bData[j][8]);
if (isNaN(pDed) && isNaN(wDed)) { pDed = parseFloat(bData[j][4]); wDed = 0; }
else { pDed = pDed || 0; wDed = wDed || 0; }
roundBets.push({ row: j + 1, phone: bData[j][2], side: bData[j][3], amount: parseFloat(bData[j][4]), playDeducted: pDed, winDeducted: wDed });
if (bData[j][3] === "HEAD") headSum += parseFloat(bData[j][4]);
else if (bData[j][3] === "TAIL") tailSum += parseFloat(bData[j][4]);
if (uniquePlayers.indexOf(bData[j][2].toString()) === -1) uniquePlayers.push(bData[j][2].toString());
}
}
var finalResult = "HEAD";
var totalPool = headSum + tailSum;
if (totalPool === 0) finalResult = Math.random() < 0.5 ? "HEAD" : "TAIL";
else if (uniquePlayers.length === 1) finalResult = Math.random() < 0.5 ? "HEAD" : "TAIL";
else if (headSum === tailSum) finalResult = "SERVER_ISSUE";
else finalResult = (headSum < tailSum) ? "HEAD" : "TAIL";
rSheet.getRange(rIndex, 3).setValue(finalResult === "SERVER_ISSUE" ? "Server Issue" : "Completed");
rSheet.getRange(rIndex, 4).setValue(finalResult);
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
var distributed = 0;
for (var k = 0; k < roundBets.length; k++) {
var bet = roundBets[k];
var totalPayout = 0, profit = 0;
var newStatus = "Lost";
if (finalResult === "SERVER_ISSUE") {
totalPayout = bet.amount; profit = 0; newStatus = "Refunded";
} else if (bet.side === finalResult) {
totalPayout = bet.amount * 1.9; profit = totalPayout - bet.amount;
newStatus = "Won"; distributed += totalPayout;
}
if (totalPayout > 0) {
bSheet.getRange(bet.row, 6).setValue(newStatus);
bSheet.getRange(bet.row, 7).setValue(totalPayout.toFixed(2));
for (var m = 1; m < uData.length; m++) {
if (uData[m][2].toString() === bet.phone.toString()) {
var playBal = parseFloat(uSheet.getRange(m + 1, 5).getValue()) || 0;
var winBal = parseFloat(uSheet.getRange(m + 1, 6).getValue()) || 0;
uSheet.getRange(m + 1, 5).setValue((playBal + bet.playDeducted).toFixed(2));
uSheet.getRange(m + 1, 6).setValue((winBal + bet.winDeducted + profit).toFixed(2));
break;
}
}
} else {
bSheet.getRange(bet.row, 6).setValue("Lost");
}
}
if (finalResult !== "SERVER_ISSUE") {
var adminProfit = totalPool - distributed;
ss.getSheetByName("Admin_Profit").appendRow([req.roundId, totalPool.toFixed(2), adminProfit.toFixed(2), distributed.toFixed(2), new Date()]);
}
return { success: true, result: finalResult };
} finally {
lock.releaseLock();
}
}
// ==========================================
// 🔄 AUTO WALLET UPDATE ON MANUAL APPROVAL (WITH LOCKSERVICE)
// ==========================================
function onEdit(e) {
if (!e || !e.range) return;
var sheet = e.range.getSheet();
if (sheet.getName() !== "Transactions") return;
var col = e.range.getColumn();
var row = e.range.getRow();
if (col === 6 && row > 1) {
var status = sheet.getRange(row, 6).getDisplayValue().trim();
var oldStatus = e.oldValue ? e.oldValue.toString().trim() : "";
var type = sheet.getRange(row, 4).getDisplayValue().trim();
var phone = sheet.getRange(row, 3).getDisplayValue().trim();
var amount = parseFloat(sheet.getRange(row, 5).getValue());
var lock = LockService.getScriptLock();
if (!lock.tryLock(10000)) return;
try {
if (status === "Approved" && oldStatus !== "Approved") {
if (type === "Deposit" && !isNaN(amount) && amount > 0) {
var usersSheet = e.source.getSheetByName("Users");
var usersData = usersSheet.getDataRange().getDisplayValues();
for (var i = 1; i < usersData.length; i++) {
if (usersData[i][2].toString().trim() === phone) {
var currentBal = parseFloat(usersSheet.getRange(i + 1, 5).getValue()) || 0;
usersSheet.getRange(i + 1, 5).setValue((currentBal + amount).toFixed(2));
if (amount >= 100) {
var referredByPhone = usersData[i][10] ? usersData[i][10].toString().trim() : "";
if (referredByPhone !== "" && referredByPhone !== "BONUS_PAID") {
for (var r = 1; r < usersData.length; r++) {
if (usersData[r][2].toString().trim() === referredByPhone) {
var refBal = parseFloat(usersSheet.getRange(r + 1, 5).getValue()) || 0;
usersSheet.getRange(r + 1, 5).setValue((refBal + 50).toFixed(2));
var bonusTxnId = "TXN" + Math.floor(Math.random() * 900000 + 100000);
e.source.getSheetByName("Transactions").appendRow([
bonusTxnId, new Date(), referredByPhone, "Referral Bonus", "50.00", "Approved", "From: " + phone
]);
usersSheet.getRange(i + 1, 11).setValue("BONUS_PAID");
break;
}
}
}
}
break;
}
}
}
}
else if (status === "Rejected" && oldStatus !== "Rejected") {
if (type === "Withdrawal" && !isNaN(amount) && amount < 0) {
var usersSheet = e.source.getSheetByName("Users");
var usersData = usersSheet.getDataRange().getDisplayValues();
for (var i = 1; i < usersData.length; i++) {
if (usersData[i][2].toString().trim() === phone) {
var currentWin = parseFloat(usersSheet.getRange(i + 1, 6).getValue()) || 0;
usersSheet.getRange(i + 1, 6).setValue((currentWin + Math.abs(amount)).toFixed(2));
break;
}
}
}
}
} finally {
lock.releaseLock();
}
}
}
// ==========================================
// 🚀 TELEGRAM NOTIFICATION & ACTION HANDLER
// ==========================================
function sendTelegramAlert(txnId, type, amount, phone, ref) {
var emoji = (type === "Deposit") ? "📥" : "📤";
// BUG FIX: Removed formatting characters like '*' to prevent Markdown errors
var text = "🚨 New " + type + " Request!\n\n" +
emoji + " Amount: ₹" + amount + "\n" +
"📱 Phone: " + phone + "\n" +
"🔖 Details/UTR: " + ref + "\n" +
"🆔 Txn ID: " + txnId;
var keyboard = {
"inline_keyboard": [
[
{ "text": "✅ Approve", "callback_data": "APPROVE_" + txnId },
{ "text": "❌ Reject", "callback_data": "REJECT_" + txnId }
]
]
};
try {
UrlFetchApp.fetch("https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/sendMessage", {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify({
"chat_id": ADMIN_CHAT_ID,
"text": text,
"reply_markup": keyboard
})
});
} catch(e) { }
}
function handleTelegramAction(callback_query) {
var data = callback_query.data;
var messageId = callback_query.message.message_id;
var action = data.split("_")[0];
var txnId = data.split("_")[1];
var lock = LockService.getScriptLock();
if (!lock.tryLock(10000)) return ContentService.createTextOutput("System Busy");
try {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var tSheet = ss.getSheetByName("Transactions");
var tData = tSheet.getDataRange().getValues();
var rowIndex = -1;
var phone = "", amount = 0, type = "";
// Safety Update: added .toString().trim()
for (var i = 1; i < tData.length; i++) {
if (tData[i][0].toString().trim() === txnId.toString().trim()) {
rowIndex = i + 1;
phone = tData[i][2].toString().trim();
type = tData[i][3].toString().trim();
amount = parseFloat(tData[i][4]);
break;
}
}
if (rowIndex !== -1) {
var currentStatus = tSheet.getRange(rowIndex, 6).getValue().toString().trim();
if (currentStatus === "Pending") {
var newStatus = (action === "APPROVE") ? "Approved" : "Rejected";
tSheet.getRange(rowIndex, 6).setValue(newStatus);
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
if (newStatus === "Approved") {
for (var j = 1; j < uData.length; j++) {
if (uData[j][2].toString().trim() === phone) {
if (type === "Deposit") {
var currentPlay = parseFloat(uSheet.getRange(j + 1, 5).getValue()) || 0;
uSheet.getRange(j + 1, 5).setValue((currentPlay + amount).toFixed(2));
if (amount >= 100) {
var usersDataDisplay = uSheet.getDataRange().getDisplayValues();
var referredByPhone = usersDataDisplay[j][10] ? usersDataDisplay[j][10].toString().trim() : "";
if (referredByPhone !== "" && referredByPhone !== "BONUS_PAID") {
for (var r = 1; r < usersDataDisplay.length; r++) {
if (usersDataDisplay[r][2].toString().trim() === referredByPhone) {
var refBal = parseFloat(uSheet.getRange(r + 1, 5).getValue()) || 0;
uSheet.getRange(r + 1, 5).setValue((refBal + 50).toFixed(2));
var bonusTxnId = "TXN" + Math.floor(Math.random() * 900000 + 100000);
tSheet.appendRow([bonusTxnId, new Date(), referredByPhone, "Referral Bonus", "50.00", "Approved", "From: " + phone]);
uSheet.getRange(j + 1, 11).setValue("BONUS_PAID");
break;
}
}
}
}
}
break;
}
}
} else if (newStatus === "Rejected" && type === "Withdrawal") {
for (var j = 1; j < uData.length; j++) {
if (uData[j][2].toString().trim() === phone) {
var currentWin = parseFloat(uSheet.getRange(j + 1, 6).getValue()) || 0;
uSheet.getRange(j + 1, 6).setValue((currentWin + Math.abs(amount)).toFixed(2));
break;
}
}
}
var statusEmoji = (newStatus === "Approved") ? "🟢" : "🔴";
var updatedText = callback_query.message.text + "\n\n" + statusEmoji + " Status: " + newStatus;
UrlFetchApp.fetch("https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/editMessageText", {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify({ chat_id: ADMIN_CHAT_ID, message_id: messageId, text: updatedText })
});
} else {
// Error Detector 1
UrlFetchApp.fetch("https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/sendMessage", {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify({ chat_id: ADMIN_CHAT_ID, text: "⚠️ Update Failed: Yeh Txn (" + txnId + ") sheet me pehle se hi " + currentStatus + " hai." })
});
}
} else {
// Error Detector 2
UrlFetchApp.fetch("https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/sendMessage", {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify({ chat_id: ADMIN_CHAT_ID, text: "⚠️ Error: Sheet mein Txn ID " + txnId + " nahi mili!" })
});
}
UrlFetchApp.fetch("https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/answerCallbackQuery", {
"method": "post",
"payload": { "callback_query_id": callback_query.id }
});
} catch(err) {
// Error Detector 3
UrlFetchApp.fetch("https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/sendMessage", {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify({ chat_id: ADMIN_CHAT_ID, text: "🛑 Code Crash Error:\n" + err.message })
});
} finally {
lock.releaseLock();
}
return ContentService.createTextOutput("OK");
}
// ========================================
// 🕒 CRON JOBS
// ==========================================
function cleanupTossHistory() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var rSheet = ss.getSheetByName("Toss_Rounds");
var rLast = rSheet.getLastRow();
if (rLast > 100) rSheet.deleteRows(2, rLast - 100);
var bSheet = ss.getSheetByName("Toss_Bets");
var bLast = bSheet.getLastRow();
if (bLast > 300) bSheet.deleteRows(2, bLast - 300);
}
function userLifecycleManager() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Users");
var inSheet = ss.getSheetByName("Inactive_Users");
var arSheet = ss.getSheetByName("Archive_Users");
var data = sheet.getDataRange().getValues();
var now = new Date().getTime();
for (var i = data.length - 1; i >= 1; i--) {
var lastActive = new Date(data[i][6]).getTime();
var daysInactive = (now - lastActive) / (1000 * 3600 * 24);
if (daysInactive >= 50) sheet.deleteRow(i + 1);
else if (daysInactive >= 30) { arSheet.appendRow(data[i]); sheet.deleteRow(i + 1); }
else if (daysInactive >= 15) { inSheet.appendRow(data[i]); sheet.deleteRow(i + 1); }
}
}
function testBot() {
var url = "https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/sendMessage";
var options = {
"method": "post",
"contentType": "application/json",
"payload": JSON.stringify({
"chat_id": ADMIN_CHAT_ID,
"text": "Hello Sikka Admin! Bot is working."
}),
"muteHttpExceptions": true
};
var response = UrlFetchApp.fetch(url, options);
console.log(response.getContentText());
}
function setupWebhook() {
// Niche double quotes ke andar apna copy kiya hua Web App URL paste karein
var webAppUrl = "https://script.google.com/macros/s/AKfycbzNGnfXhz16M_zdJfWmdtZmMI8M5xbcEFLoSfFZ65FD1Y1GXXQVCDRLqjthUEDg6OEc/exec";
var url = "https://api.telegram.org/bot" + TELEGRAM_TOKEN + "/setWebhook?url=" + webAppUrl;
var response = UrlFetchApp.fetch(url);
console.log(response.getContentText());
}
