Windows Erro SQLite Console/GUI no recognizing player with name Mario'Luigi

[samuel157]

[26/01/2020 20:54:06] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "pala": syntax error (INSERT INTO "death_list" ("player_id", "date", "level", "killer_name") VALUES ('4491', '1580079246', '24931', 'Lord'pala. ') ; )

Erro with player name Lord'Pala Help

 

[Evil Puncker]

you need to use escape string

escapeString(killer_name)

but i can't help any further since you provided no info: Rules for the Support board (https://otland.net/threads/rules-for-the-support-board.217087/)

 

[samuel157]

how do i do it?

Post automatically merged: Jan 27, 2020

you need to use escape string

escapeString(killer_name)

but i can't help any further since you provided no info: Rules for the Support board (https://otland.net/threads/rules-for-the-support-board.217087/)

how do i do it?

 

[Evil Puncker]

post on pastebin.com the script that is executing that query

 

[samuel157]

the erro is at the Sqlite

ta giving problem in the quotes when the player enters the name Dear'Sign of the error because of the quotes

 

[Evil Puncker]

the escape string is exactly to prevent this error, you need to search for the script that is executing it and change this (example):

db.query("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `is_player`, `mostdamage_by`, `mostdamage_is_player`, `unjustified`, `mostdamage_unjustified`) VALUES (" .. playerGuid .. ", " .. os.time() .. ", " .. player:getLevel() .. ", " .. killerName .. ", " .. byPlayer .. ", " .. mostDamageName .. ", " .. byPlayerMostDamage .. ", " .. (unjustified and 1 or 0) .. ", " .. (mostDamageUnjustified and 1 or 0) .. ")")

into this:

db.query("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `is_player`, `mostdamage_by`, `mostdamage_is_player`, `unjustified`, `mostdamage_unjustified`) VALUES (" .. playerGuid .. ", " .. os.time() .. ", " .. player:getLevel() .. ", " .. db.escapeString(killerName) .. ", " .. byPlayer .. ", " .. db.escapeString(mostDamageName) .. ", " .. byPlayerMostDamage .. ", " .. (unjustified and 1 or 0) .. ", " .. (mostDamageUnjustified and 1 or 0) .. ")")

in your playerdeath.lua