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 ++!

 

[Serginov]

"UPDATE `killers` SET `unjustified` = (" .. unjustified .. ")-1"

 

[dukzin]

cleans all too. ;s

How i'm testing:

login 2 characters (MC) kill other one 2 times.
use the query
and say !frags..

 

[Serginov]

"UPDATE `killers` SET `unjustified` = `unjustified`-1"

 

[Cykotitan]

"UPDATE `killers` SET `unjustified` = `unjustified`-1"

The total number of unjustified kills is not stored like that - it's stored within multiple entries (rows).
Also, no quotes around queries!

One might have to use UPDATE and store the player_id's that have been already processed. However, there isn't a player_id column in table killers which means you would have to SELECT from table player_killers, too.

 

[dukzin]

cyko, are u talking about " ?
if it's i'm deleting it...

if u know a query to delete one frag of all persons please post heree ;(

 

[dukzin]

BUUMP :s
Anybody Knows?

 

[dukzin]

B
u
m
p
!

 

[Zonet]

Try

UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers`) LIMIT 1;

 

[Cykotitan]

Try

UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers`) LIMIT 1;

It'll only update a frag of 1 player.

 

[Zonet]

It'll only update a frag of 1 player.

I guess he must use SQL FOREACH, I'm not that good in it

 

[dukzin]

#Cykoo
U dont know man? -u know everything!

#Zonet
What are u talking about?
i reealy need it ;s

 

[Diazapam]

Ehh, just remove the LIMIT 1?

 

[Cykotitan]

#Cykoo
U dont know man? -u know everything!

I don't know everything, quite the opposite.

Ehh, just remove the LIMIT 1?

Removing LIMIT would result in all unjustified frags being altered.

 

[Zonet]

Very bad way, but you could simply do
onLogin(cid) remove 1 frag from that player, set storage

function onLogin(cid)
	if getPlayerStorageValue(cid, 93368) < 1 then
		db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")
		setPlayerStorageValue(cid, 93368, 1)
	end
	return true
end

 

[dukzin]

@zonet

                db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")

it removes 1 frag?

if yes, i'm making a global event that i want :x


-----

about it.
removes 1 frag of all online or offline (if possible) players.
i've it, but it needs a query that removes 1 frag...
;s

if someone have other way to do it,
post here ;x

 

[Zonet]

@zonet

                db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `id` = "..getPlayerGUID(cid).." LIMIT 1;")

it removes 1 frag?

if yes, i'm making a global event that i want :x


-----

about it.
removes 1 frag of all online or offline (if possible) players.
i've it, but it needs a query that removes 1 frag...
;s

if someone have other way to do it,
post here ;x

Use onLogin(cid) wont hurt you, lol.
Yes, it removes all players frags that login, only 1 frag, 1 TIME.

 

[dukzin]

noo, i dont want that removes on login..
i want to remove every x time..

function onThink(interval)
db.executeQuery("QUERY THAT I WANT")
doBroadcastMessage("Everbody Lost 1 Frag. Next remotion in 1 hours.")
return true
end

 

[dukzin]

BUMP.
- take it to top.

 

[Fallen]

online maybe possible but idk how to do it for offline players also ;S
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.")
	end
	return true
end

 

[dukzin]

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