Sql Query !

[dukzin]

Hello OTland

i'm using this query to remove all frags of all persons.

"DELETE FROM `killers` WHERE `unjustified` = 1;"

can someone tell me how can i remove only 1 frag of all persons.

;s

thanks.

i'll Rep ++!

 

[Fallen]

dont remove anything and it broadcast almost 15 times
o.o
;s

LOL, why? is there 15 players online?
try this:

function onThink(inerval, lastExecution)
	for _, cid in ipairs(getPlayersOnline()) do
		db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")
		doBroadcastMessage("Everybody Lost 1 Frag. Next remotion in 1 hours.")
                break
	end
	return true
end

 

[Ancores]

function onThink(inerval, lastExecution)
	for _, cid in ipairs(getPlayersOnline()) do
		db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")
	end
	doBroadcastMessage("Everybody Lost 1 Frag. Next remotion in 1 hours.")
	return true
end

 

[Fallen]

function onThink(inerval, lastExecution)
	for _, cid in ipairs(getPlayersOnline()) do
		db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")
	end
	doBroadcastMessage("Everybody Lost 1 Frag. Next remotion in 1 hours.")
	return true
end

not nice

 

[Cykotitan]

LOL, why? is there 15 players online?
try this:

function onThink(inerval, lastExecution)
	for _, cid in ipairs(getPlayersOnline()) do
		db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")
		doBroadcastMessage("Everybody Lost 1 Frag. Next remotion in 1 hours.")
                [B][COLOR="Red"]break[/COLOR][/B]
	end
	return true
end

You're doing it wrong ^_^

 

[dukzin]

@cyko
it works?
will test!


EDIT -
don't remove.
but, broadcast 1 time.

 

[dukzin]

to the top.

 

[Cykotitan]

@cyko
it works?
will test!


EDIT -
don't remove.
but, broadcast 1 time.

What?! I never posted any script.

 

[dukzin]

sry, u only have posted OZICO's script.

sorry ;x

 

[dukzin]

bump!