only Sikka GAS code
// ==========================================
// 🏏 SIKKA GAME - BACKEND ENGINE (1000+ Users)
// ==========================================
const ROUND_DURATION = 30000; // 30 Seconds Total
const BETTING_WINDOW = 23000; // 23 Seconds Open
function doPost(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var req = JSON.parse(e.postData.contents);
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);
}
// 🔐 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][8] === token) {
sheet.getRange(i + 1, 6).setValue(new Date()); // Update Last Active
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();
// Anti-Spam: Block repeated digits (e.g., 1111111111, 0000000000)
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, new Date(), "Active", data.pass, ""]);
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][7].toString() === data.pass) {
if (users[i][6] !== "Active") return { success: false, message: "Account is Inactive/Archived." };
var newToken = Utilities.getUuid();
sheet.getRange(i + 1, 9).setValue(newToken);
sheet.getRange(i + 1, 6).setValue(new Date());
return { success: true, token: newToken, balance: parseFloat(users[i][4]).toFixed(2) };
}
}
return { success: false, message: "Invalid Mobile or Password!" };
}
// 👤 GET USER DATA & SMART HISTORY LOADER (Last 10 Txns)
function getUserData(ss, phone) {
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
var bal = 0;
for (var i = 1; i < uData.length; i++) {
if (uData[i][2].toString() === phone.toString()) { bal = parseFloat(uData[i][4]); 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; // Limit to 10
}
}
return { success: true, balance: bal.toFixed(2), history: history };
}
// 💰 DEPOSIT FUNDS (₹50 - ₹1000 Limit) + AUTO DROPDOWN
function depositFunds(ss, req) {
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);
// Naya row add karna
tSheet.appendRow([txnId, new Date(), req.phone, "Deposit", amount.toFixed(2), "Pending", req.utr]);
// 🔥 THE ULTIMATE FIX: Pura cell copy karke wapas "Pending" set karna
var lastRow = tSheet.getLastRow();
if (lastRow > 2) {
var sourceCell = tSheet.getRange(lastRow - 1, 6);
var targetCell = tSheet.getRange(lastRow, 6);
// Isse rule, colors, chip design sab kuch copy ho jayega
sourceCell.copyTo(targetCell);
// Pura copy hone se upar wala text bhi aa jayega, isliye usko "Pending" kar denge
targetCell.setValue("Pending");
}
return { success: true };
}
// 🏦 WITHDRAW FUNDS & UPI AUTO-SAVE (1 Per Day) + AUTO DROPDOWN
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 bal = parseFloat(uData[i][4]);
if (bal < amount) return { success: false, message: "Insufficient Balance!" };
// Deduct instant balance & Auto-save UPI ID
uSheet.getRange(i + 1, 4).setValue(req.upiId);
uSheet.getRange(i + 1, 5).setValue((bal - amount).toFixed(2));
var txnId = "TXN" + Math.floor(Math.random() * 900000 + 100000);
// Naya row add karna
tSheet.appendRow([txnId, new Date(), req.phone, "Withdrawal", "-" + amount.toFixed(2), "Pending", req.upiId]);
// 🔥 THE ULTIMATE FIX
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");
}
return { success: true };
}
}
} finally {
lock.releaseLock();
}
}
// 🪙 GET ROUND DATA (Pre-fetch & Smart Loader 30 Rounds)
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 (Strict Limits & Single Player Logic)
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." };
// Strict 23-Second Betting Window Lock
if (new Date().getTime() - roundTimestamp > BETTING_WINDOW) {
return { success: false, message: "Betting is closed for this round!" };
}
// Single Player Limits (Max ₹20, Max 5 rounds/day) check
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." };
}
// Deduct Balance
var uSheet = ss.getSheetByName("Users");
var uData = uSheet.getDataRange().getValues();
var uIndex = -1;
for (var j = 1; j < uData.length; j++) {
if (uData[j][2].toString() === req.phone.toString()) {
uIndex = j + 1;
var bal = parseFloat(uData[j][4]);
if (bal < amount) return { success: false, message: "Insufficient Wallet Balance!" };
uSheet.getRange(uIndex, 5).setValue((bal - amount).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]);
return { success: true };
} finally {
lock.releaseLock();
}
}
// 🏆 RESOLVE ROUND (Least Pool Wins / Auto-Refund / Single Player Randomizer)
function tossResolve(ss, req) {
var lock = LockService.getScriptLock();
if (!lock.tryLock(5000)) return { success: true, result: window.tossResultCache }; // Fallback for heavy load
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; var tailSum = 0;
var roundBets = [];
var uniquePlayers = [];
for (var j = 1; j < bData.length; j++) {
if (bData[j][1] === req.roundId) {
roundBets.push({ row: j + 1, phone: bData[j][2], side: bData[j][3], amount: parseFloat(bData[j][4]) });
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;
// SCENARIO 1: No bets
if (totalPool === 0) {
finalResult = Math.random() < 0.5 ? "HEAD" : "TAIL";
rSheet.getRange(rIndex, 3).setValue("Completed");
rSheet.getRange(rIndex, 4).setValue(finalResult);
return { success: true, result: finalResult };
}
// SCENARIO 2: Single Player (50-50 Randomizer)
if (uniquePlayers.length === 1) {
finalResult = Math.random() < 0.5 ? "HEAD" : "TAIL";
}
// SCENARIO 3: Equal Pool (Auto Refund)
else if (headSum === tailSum) {
finalResult = "SERVER_ISSUE";
}
// SCENARIO 4: Admin Profit (Least Pool Wins)
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;
// Distribute Winnings or Refunds
for (var k = 0; k < roundBets.length; k++) {
var bet = roundBets[k];
var wonAmt = 0;
var newStatus = "Lost";
if (finalResult === "SERVER_ISSUE") {
wonAmt = bet.amount; // 100% Refund
newStatus = "Refunded";
} else if (bet.side === finalResult) {
wonAmt = bet.amount * 1.9; // 1.9x Winning
newStatus = "Won";
distributed += wonAmt;
}
if (wonAmt > 0) {
bSheet.getRange(bet.row, 6).setValue(newStatus);
bSheet.getRange(bet.row, 7).setValue(wonAmt.toFixed(2));
for (var m = 1; m < uData.length; m++) {
if (uData[m][2].toString() === bet.phone.toString()) {
var currentBal = parseFloat(uSheet.getRange(m + 1, 5).getValue());
uSheet.getRange(m + 1, 5).setValue((currentBal + wonAmt).toFixed(2));
break;
}
}
} else {
bSheet.getRange(bet.row, 6).setValue("Lost");
}
}
// Log Admin Profit
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 (100% FIXED)
// ==========================================
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) { // Column F (Status)
// e.value ki jagah cell se direct display value read karna zyada safe hai
var status = sheet.getRange(row, 6).getDisplayValue().trim();
var oldStatus = e.oldValue ? e.oldValue.toString().trim() : "";
if (status === "Approved" && oldStatus !== "Approved") {
var type = sheet.getRange(row, 4).getDisplayValue().trim();
// 🔥 FIX: getDisplayValue() ensures 10-digit numbers don't break
var phone = sheet.getRange(row, 3).getDisplayValue().trim();
var amount = parseFloat(sheet.getRange(row, 5).getValue());
if (type === "Deposit" && !isNaN(amount) && amount > 0) {
var usersSheet = e.source.getSheetByName("Users");
// 🔥 FIX: Getting display values so number matching never fails
var usersData = usersSheet.getDataRange().getDisplayValues();
for (var i = 1; i < usersData.length; i++) {
var userPhone = usersData[i][2].toString().trim(); // Column C (Phone)
if (userPhone === phone) {
// Get original exact balance value, add amount, and save
var currentBal = parseFloat(usersSheet.getRange(i + 1, 5).getValue()) || 0;
var newBal = currentBal + amount;
usersSheet.getRange(i + 1, 5).setValue(newBal.toFixed(2));
break; // Stop loop once user is found and updated
}
}
}
}
}
}
// ==========================================
// 🕒 CRON JOBS (Auto Database Cleanup & Lifecycle
// ==========================================
function cleanupTossHistory() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
// Clean Toss_Rounds (Keep last 100)
var rSheet = ss.getSheetByName("Toss_Rounds");
var rLast = rSheet.getLastRow();
if (rLast > 100) rSheet.deleteRows(2, rLast - 100);
// Clean Toss_Bets (Keep last 300)
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][5]).getTime();
var daysInactive = (now - lastActive) / (1000 * 3600 * 24);
if (daysInactive >= 50) {
sheet.deleteRow(i + 1); // Delete completely
} else if (daysInactive >= 30) {
arSheet.appendRow(data[i]);
sheet.deleteRow(i + 1);
} else if (daysInactive >= 15) {
inSheet.appendRow(data[i]);
sheet.deleteRow(i + 1);
}
}
}
