[Der Joker aka XRAY]

For some reason when i change the items.cfg it won't have any effect on the server and the actual menu(no changes)

Is this problem common and are any fixes known?

[Lannister]

You need to restart the server!

[good_live]

Originally Posted by daleGEND Not sure if anyone has attempted this before, but is it OK to edit the credit amount outside of sourcemod via the SQL database? Any potential issues that could crop up? For instance I have a third-party application giving credits to someone who has done something on my forums. I am attempting to make a forum addon that gives those credits to them via the database itself. Any potential issue there?

Nope. I hadn't any issues so far.

[daleGEND]

Originally Posted by good_live Nope. I hadn't any issues so far.

Thanks for the reply!

[Addicted.]

Originally Posted by daleGEND Not sure if anyone has attempted this before, but is it OK to edit the credit amount outside of sourcemod via the SQL database? Any potential issues that could crop up? For instance I have a third-party application giving credits to someone who has done something on my forums. I am attempting to make a forum addon that gives those credits to them via the database itself. Any potential issue there?

If the player is connected on the server it would most likely lose the additional credits because the credits are handled locally on the server until disconnect/map end

[DarkDeviL]

Originally Posted by daleGEND Not sure if anyone has attempted this before, but is it OK to edit the credit amount outside of sourcemod via the SQL database? Any potential issues that could crop up? For instance I have a third-party application giving credits to someone who has done something on my forums. I am attempting to make a forum addon that gives those credits to them via the database itself. Any potential issue there?

There is issues:

Originally Posted by oaaron99 If the player is connected on the server it would most likely lose the additional credits because the credits are handled locally on the server until disconnect/map end

^

If you adjust John's credit while John is on the server, the Store will save his credit when he quits, and it will overwrite your modification. This basically means:

- If you raise his credits, he will lose when he is quitting.

- If you reduce his credits, he will "get them back" when he is quitting.

If John is not connected to any of your servers while the modification happens, then there will be absolutely no problem with this.

[lay295]

Originally Posted by arne1288 There is issues: If you adjust John's credit while John is on the server, the Store will save his credit when he quits, and it will overwrite your modification. This basically means: - If you raise his credits, he will lose when he is quitting. - If you reduce his credits, he will "get them back" when he is quitting. If John is not connected to any of your servers while the modification happens, then there will be absolutely no problem with this.

This is not true, I do it all the time. They will not lose additional credits either, the plugin basically just caches the credits they've earned just as most people would expect but the MySQL statement just adds those to the current value, and doesn't overwrite it with what it thinks the value should be.

Format(STRING(m_szQuery), "UPDATE store_players SET `credits`=GREATEST(`credits`+%d,0), `date_of_last_join`=%d, `name`='%s' WHERE `id`=%d", g_eClients[client][iCredits]-g_eClients[client][iOriginalCredits], g_eClients[client][iDateOfLastJoin], g_eClients[client][szNameEscaped], g_eClients[client][iId]);

If they are connected though they would have to rejoin the server to see the new credits

[DarkDeviL]

Originally Posted by lay295 This is not true, I do it all the time. They will not lose additional credits either, the plugin basically just caches the credits they've earned just as most people would expect but the MySQL statement just adds those to the current value, and doesn't overwrite it with what it thinks the value should be.

My experience was inherited through some of Zephyrus' older Stores, which were caching these values, and blindly saving (and overwriting) them according to the above explanation.

However, looking a little bit closer (@GitHub), I have to admit that it does indeed appear like this one should handle things way better.

It does however still seems like the above explanation is still true for some situations:

If someone has doing naughty things, and you plan on punishing him/her with -10000 credits (or any other negative value), it will most likely be reset to 0 next time.

The phrase most likely was added since I didn't test this, however, I haven't heard of anyone doing such punishments either.

[uurbyrkdr]

Hi.
Some players told me, they lost their items. But credits didn't change, only items lost.
Is there anyone have this problem?
And how can i fix this problem?

[Der Joker aka XRAY]

Originally Posted by Lannister You need to restart the server!

Thanks, but it didn't work in the beginning, i hat do change the database to MySQL and then it would work ^^