[yamin]

this code doesn't works

PHP Code:

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


[hornet]

I'm at no advanced level of PHP, but I believe an entry must already exist in order to use UPDATE. Are you getting an error?

Show your full code.

[yamin]

i am not getting errors just some warnings

PHP Code:

public client_death(killer,victim){
    if(victim!=isolo)
        return
    
    new name[32]
    get_user_name(victim,name,31)
    
    formatex(g_query,511,"UPDATE played_time SET playedtime=playedtime-350 WHERE name='%s'",name)
    SQL_ThreadQuery(sql,"query",g_query)
    
    get_user_name(killer,name,31)
    
    formatex(g_query,511,"UPDATE played_time SET playedtime=playedtime+100 WHERE name='%s'",name)
    SQL_ThreadQuery(sql,"query",g_query)
} 


[YamiKaitou]

What are the warnings you are getting?

[yamin]

/tmp/textseJfqW.sma(39) : warning 201: redefinition of constant/macro (symbol "SILVER")
/tmp/textseJfqW.sma(41) : warning 201: redefinition of constant/macro (symbol "ADMIN")
/tmp/textseJfqW.sma(59) : warning 217: loose indentation
/tmp/textseJfqW.sma(105) : warning 217: loose indentation
/tmp/textseJfqW.sma(10 : warning 217: loose indentation
/tmp/textseJfqW.sma(113) : warning 217: loose indentation
/tmp/textseJfqW.sma(12 : warning 209: function "eCurWeapon" should return a value
/tmp/textseJfqW.sma(134) : warning 217: loose indentation
/tmp/textseJfqW.sma(135) : warning 217: loose indentation
/tmp/textseJfqW.sma(137) : warning 217: loose indentation
/tmp/textseJfqW.sma(163) : warning 217: loose indentation
/tmp/textseJfqW.sma(173) : warning 217: loose indentation
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "colorChat"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "findAnyPlayer"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "g_addCvar"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "messageSayText"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "messageTeamInfo"

[yamin]

there is no warning in this code

[YamiKaitou]

Those warnings do not apply to the code snippet you supplied


Now, back to your original question. Define "doesn't work". How do you know it is not working? What kind of debugging have you done? Are you sure it is even executing? Is the SQL server accepting your query and executing it without any errors?

[Waleed]

For loose indentation you can use Indenter,Click on Tools->Indenter
This should solve your 99% indentation warning.
You have put these variables,But you are not using them,Put "//" before them to disable,If no warnings are given,Then you can delete those variables as you are not using them.


/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "colorChat"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "findAnyPlayer"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "g_addCvar"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "messageSayText"
/tmp/textseJfqW.sma(373) : warning 203: symbol is never used: "messageTeamInfo"

[yamin]

how will i know if the plugin works or not?

[fysiks]

Originally Posted by yamin how will i know if the plugin works or not?

lol, I think you are in trouble if you have to ask that. The plugin works if it does what it is supposed to do. Therefore, if it does not do what it is supposed to do then it doesn't work . . .