Print Page - tempban tostring problem

Title: tempban tostring problem
Post by: Nihongo^ on Aug 12, 2023, 08:06 AM

My temp ban is working perfectly but whenver this guy name "[THC]^CUTE^295" joins the server it gives an error here
(https://i.postimg.cc/KYGRTmcr/Untitled.png)
local banType = GetSQLColumnData(q, 9).tostring();

Here's my full checktempban function

Code Select

function CheckTempBan(player) {
    local q = QuerySQL(db, "SELECT * FROM TempBans WHERE Name='" + escapeSQLString(player.Name) + "' OR IP='" + escapeSQLString(player.IP) + "' OR UID='" + escapeSQLString(player.UniqueID) + "' OR UID2='" + escapeSQLString(player.UniqueID2) + "'");
    if (q) {
        local banType = GetSQLColumnData(q, 9).tostring(); <--- Line 518
                local currentTime = time();
            local banStartTime = GetSQLColumnData(q, 4).tointeger();
            local banDuration = GetSQLColumnData(q, 5).tointeger();
            if (currentTime - banStartTime >= banDuration) {
                QuerySQL(db, "DELETE FROM TempBans WHERE LOWER(Name)='" + player.Name.tolower() + "'");
            } else {
                local timeLeft = banDuration - (currentTime - banStartTime);
                ServerMessage("[#FF0000][PRIOR BAN]: [#FFFFFF] [ " + player.Name + " ] is banned for Reason: [ " + GetSQLColumnData(q, 8) + " ]");
                ServerMessage("[#FF0000][PRIOR BAN]: [#FFFFFF] TimeLeft: [ " + GetBanRemainingTime(GetSQLColumnData(q, 4).tointeger(), GetSQLColumnData(q, 6).tostring()) + " ], Admin: [ " + GetSQLColumnData(q, 7) + " ]");
                EchoMessage("[PRIOR BAN]: [ " + player.Name + " ] is banned for Reason: [ " + GetSQLColumnData(q, 8) + " ] TimeLeft: [ " + GetBanRemainingTime(GetSQLColumnData(q, 4).tointeger(), GetSQLColumnData(q, 6).tostring()) + " ], Admin: [ " + GetSQLColumnData(q, 7) + " ]");
        player.Kick();          
        }
        }
        }
        }

Kindly explain me about "tostring();" is it really necessary ? and what is it ?
Thank you in advance

Title: Re: tempban tostring problem
Post by: habi on Aug 12, 2023, 10:33 AM

Show the result of print statement:

Code Select

print(GetSQLColumnData(q, 9));
local banType = GetSQLColumnData(q, 9).tostring()

tostring converts number, boolean, etc into string

Code Select

local a=2; 
local b= a.tostring()
//a=2 and b="2"

Title: Re: tempban tostring problem
Post by: Nihongo^ on Aug 12, 2023, 11:40 AM

Ah damn, i just figure out the data inside the table in "NULL" didn't check
Problem sovled

Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Nihongo^ on Aug 12, 2023, 08:06 AM