[totopizza]

Try this, I have added a message of "Error #:" to find the query that generates the error easier and faster, try it and tell me the error again.

[Deszzz]

Hey Ocixcrom, I took a look at your keywords website for this plugin and I was wondering if there is a possibility to add a function where if player die he loses XP (die by another player instead of suicide).

[LithuanianJack]

Originally Posted by totopizza Try this, I have added a message of "Error #:" to find the query that generates the error easier and faster, try it and tell me the error again.

PHP Code:

[crx_ranksystem_v2d.amxx] Error 6: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 


PHP Code:

[crx_ranksystem.amxx] [SQL Error] Query failed (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''STEAM_0:1:156' at line 1 


[totopizza]

Originally Posted by LithuanianJack PHP Code: [crx_ranksystem_v2d.amxx] Error 6: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1  PHP Code: [crx_ranksystem.amxx] [SQL Error] Query failed (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''STEAM_0:1:156' at line 1

Try again:

[LithuanianJack]

Originally Posted by totopizza Try again:

Perfect! No errors now.

I have additional request for plugin's author ociX. I want to do "web stats" with this plugin, but I need more data inserting - kills, headshots, deaths. Can you add these things saving to SQL?

P.s. I agree with Deszzz's request. Possibility to add a function where if player die he loses XP would be great.

[OciXCrom]

Originally Posted by Deszzz Hey Ocixcrom, I took a look at your keywords website for this plugin and I was wondering if there is a possibility to add a function where if player die he loses XP (die by another player instead of suicide).

Good idea, I will add this in the next update. Until I do that, you can use this short sub-plugin:

PHP Code:

#include <amxmodx>
#include <crxranks>

public plugin_init()
{
    register_plugin("CRXRanks: Death Event", "1.0", "OciXCrom")
    register_event("DeathMsg", "OnPlayerKilled", "a")
}

public OnPlayerKilled()
    crxranks_give_user_xp(read_data(2), _, "death", CRXRANKS_XPS_REWARD) 


After you added it, just use the "death" keyword in the [XP Rewards] section and assign a negative value of XP that you want players to lose when they die. For example: death = -5

Originally Posted by LithuanianJack Perfect! No errors now. I have additional request for plugin's author ociX. I want to do "web stats" with this plugin, but I need more data inserting - kills, headshots, deaths. Can you add these things saving to SQL? P.s. I agree with Deszzz's request. Possibility to add a function where if player die he loses XP would be great.

Great, I'll have a look at the edited code and will update the main plugin soon.

Kills, headshots and deaths aren't really related to my plugin, I don't find it logical to add them. You can use the standard CSStats plugin to retrieve this information.

[Deszzz]

Originally Posted by OciXCrom Good idea, I will add this in the next update. Until I do that, you can use this short sub-plugin: PHP Code: #include <amxmodx> #include <crxranks> public plugin_init() {     register_plugin("CRXRanks: Death Event", "1.0", "OciXCrom")     register_event("DeathMsg", "OnPlayerKilled", "a") } public OnPlayerKilled()     crxranks_give_user_xp(read_data(2), _, "death", CRXRANKS_XPS_REWARD)  After you added it, just use the "death" keyword in the [XP Rewards] section and assign a negative value of XP that you want players to lose when they die. For example: death = -5

Hey, it works perfectly! Thanks for this, mate!
Amazing work you have done with this entire plugin.

[Supergirl]

A suggestion: after the maximum rank (take for example The Global Elite #18 1000-infinite points) why not put ranks being disputed by players whose rank is #18? I mean something like the top 2-10 players whose rank is #18 having a different rank #19 and the player with the most points having a #20 rank.

[OciXCrom]

Well, that's basically the same as adding more ranks in the .ini file.

[LithuanianJack]

There is a problem with the latest version of this plugin crx_ranksystem_v2d_2.amxx which was edited by totopizza. Plugin doesn't save information to SQL when SAVE_TYPE = 0 (saving on nick) and when I use nickname with symbol '

Used name: Lithuanian'Jack

PHP Code:

L 02/10/2019 - 11:18:13: [crx_ranksystem_v2d_2.amxx] Error 6: Duplicate entry 'Lithuanian\\\'Jack' for key 'PRIMARY'
L 02/10/2019 - 11:18:13: [crx_ranksystem_v2d_2.amxx] [SQL Error] Query failed (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Jack'' at line 1