[Xp3r7]

Originally Posted by Bacardi We have running this plugin OB-Css, 30player server, OS Linux... mms 1.8.3 & SM 1.3.4 No crash or slow map change

Same here but Im Windows and 32 slots.

[Pialx]

Hi,

I use this plugin on my server, i tried to modify it for include the reset rank fonction.


The changes on the file sodstats.sp:

- Add in the section: public Action:ConCmd_Say(userid, args)

 if(strcmp(text[startidx], "resetrank", false) == 0 || strcmp(text[startidx], "!resetrank", false) == 0)
 {
 Reset_Rank(userid);
 }

- Add a new section:

Reset_Rank(const userid)
{
 new String:name[255];
 GetClientName(userid, name, sizeof(name));
 
 // Make SQL-safe
 ReplaceString(name, sizeof(name), "'", "");
 
 // resetrank
 g_kills[userid]       = 0;
 g_deaths[userid]      = 0;
 g_shots[userid]       = 0;
 g_hits[userid]        = 0;
 g_score[userid]       = 0;
 g_time_played[userid] = 0;
 g_headshots[userid]   = 0;
 PrintToChat(userid, "Votre rank a été réinitialisé %s", name);
 
 SavePlayer(userid);
 return 0;
}

I'm not a programmer, i tryed to use existing code, it's certainly not optimized but it's functionnal.

The source file is attached.

(Sorry for mistakes, English is not my mother tongue.)

[zombieescape2010]

Commands

sm_stats_reset - Resets player stats.
sm_stats_purge [#days] - Removes players from database who haven't connected for [#days] days.

Please help me, This commands doesn't work by me.


Sorry for my bad english.

[Bacardi]

Admins with flag "i"(config) or "z"(root) can use those two commands.

Type command in your own console, what it say ?
sm_stats_reset
sm_stats_purge 7

Do you get work chat commands rank, statsme, session ?

[zombieescape2010]

Okay, thanks.

I have wirte this comannds as a rcon command.

[zombieescape2010]

So, I have me give admin right with Sourcemod.

The reset command works, but the "sm_stats_purge 7" dosen't work.
The player count are the same as before.

I need your help again.

[Devil Within]

Where do the ranks save, im going from a home PC to a dedi server and i need to transfer the ranks, help please

Thanks

[Bacardi]

Originally Posted by Devil Within Where do the ranks save, im going from a home PC to a dedi server and i need to transfer the ranks, help please Thanks

...addons\sourcemod\data\sqlite\sourcemod-local.sq3

Can you use *.sq3 files ?? I have no clue about sql things.

[u235]

Originally Posted by Bacardi ...addons\sourcemod\data\sqlite\sourcemod-local.sq3 Can you use *.sq3 files ?? I have no clue about sql things.

Yep. If you're into GUI's or not familiar with SQL, this firefox plugin is pretty useful http://code.google.com/p/sqlite-manager/. Of course, there's the sqlite3 tool in linux if you prefer cli tools.

[Bacardi]

Originally Posted by u235 Yep. If you're into GUI's or not familiar with SQL, this firefox plugin is pretty useful http://code.google.com/p/sqlite-manager/. Of course, there's the sqlite3 tool in linux if you prefer cli tools.

Good, and there already other post have show program #701

http://sourceforge.net/projects/sqlitebrowser/

Time to little practising ^^