Please fix this db.query edit !!! Easy + reppp

[Blood BlvD Ot]

db.executeQuery("UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = [email protected], `rlname` = noName, `location` = BloodBlvdOt WHERE `id` ='"..id.."';")

 

[Summ]

UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt';

 

[cbrm]

db.executeQuery("UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt' WHERE = '"..id)

 

[Blood BlvD Ot]

[28/12/2010 20:59:48] mysql_real_query(): UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt' WHERE = '0 - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '0' at line 1 (1064)


what local would i put for "..id ?


local id = getAccountIdByName(playerName) ????

 

[cbrm]

lulz pwna

db.executeQuery("UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt' WHERE id = '" .. id)

[28/12/2010 20:59:48]
what local would i put for "..id ?


local id = getAccountIdByName(playerName) ????

local id = getPlayerAccountId(cid)

 

[Blood BlvD Ot]

NEVER MIND I FIGURED IT OUT

function onUse(cid, item, frompos, item2, topos)
----Config----
local playerName = getPlayerName(cid)
local id = getAccountIdByName(playerName)
local storage = getPlayerStorageValue(cid,15424)
---/Config----
	if isPlayer(cid) and storage == -1 and id <= 2497 then
		db.executeQuery("UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt' WHERE `id` ='"..id.."';") 
		setPlayerStorageValue(cid,15424,1)
	else
		doPlayerSendCancel(cid,"You have already fixed your account to be able to access the site propperly")
	end 
return true 
end

TANX FOR HELPS

 

[cbrm]

why old params :s

function onUse(cid, item, fromPosition, itemEx, toPosition)
	----Config----
	local id = getPlayerAccountId(cid)
	local storage = getCreatureStorage(cid, 15423)
	---/Config----
	if storage == EMPTY_STORAGE and id <= 2497 then
		db.executeQuery("UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt' WHERE `id` = " .. id)
		doCreatureSetStorage(cid,15423,1)
	else
		return doPlayerSendCancel(cid, 'You have already fixed your account to be able to access the site properly.')
	end 
	return true 
end

 

[Summ]

Why don't you just execute this in your DB?

UPDATE `accounts` SET `page_access` = 0, `page_lastday` = 1293581300, `email_new` = '[email protected]', `rlname` = 'noName', `location` = 'BloodBlvdOt';

 

[cbrm]

@up bcuz he wants it to execute at a lua script

 

[Summ]

That fucking lua whore executes all my queries ingame -.- xd urs should work then cyber