[yamin]

there is nothing like this?

PHP Code:

public client_putinserver(id){
    PlayedTime[id] = get_playedtime(id)
    log_amx("--> Got %d",PlayedTime[id])
} 


[fysiks]

Originally Posted by yamin there is nothing like this? PHP Code: public client_putinserver(id){     PlayedTime[id] = get_playedtime(id)     log_amx("--> Got %d",PlayedTime[id]) }

What?

[yamin]

if the time subtracts then in
the hlds console
its should come like
%d minutes have been taken from %s

[Backstabnoob]

A row must exist before altering it with UPDATE command. My guess is you didn't create them first. Change the SQL query to

INSERT IGNORE INTO played_time VALUES( /* columns */ ) ON DUPLICATE KEY UPDATE playedtime=playedtime-350

Notice that UPDATE command won't throw any errors even if the row doesn't exist, it will simply do nothing.
If you want this to work, a unique key must be assigned first though.

[yamin]

this

PHP Code:

    formatex(g_query,511,"UPDATE played_time SET playedtime=playedtime-350 WHERE name='%s'",name) 
    SQL_ThreadQuery(sql,"query",g_query) 


to this?

PHP Code:

INSERT IGNORE INTO played_time VALUES( /* columns */ ) ON DUPLICATE KEY SET playedtime=playedtime-350 


[Backstabnoob]

Change "SET" to "UPDATE", I made a mistake. Also, you have to fill in the values and that's a query so it should be passed to the g_query cache.

[yamin]

i don't know much about sqlx
i didn't understand this:
you have to fill in the values and that's a query so it should be passed to the g_query cache.

[Backstabnoob]

VALUES( /* columns */ )

[yamin]

what values should i put?

[Backstabnoob]

http://dev.mysql.com/doc/refman/5.5/en/tutorial.html