[waiflih]

Originally Posted by martin.developer Hello, this plugin is good, but on my server ranks write in DB only if client disconnect. Anybody help me, what can I do to write ranks on round end ? Many thanks

Originally Posted by graczu On Evry player disconnect statistics are saving in Database. (for me it's good, becouse players dont saying /rank, /rank on evry round they play )

read first!!

and, graczu, if you're still active, can you add the option to save the rank by name and not by steamid?

[graczu]

Offf, i will try on some free time update this plugin. Im now sick so i dont need go to job, so i have some free time, and my server players will be happy if they will have stats on the server.

I will try to add some options like time after that stat of nonactive player is deleting, etc..

[graczu]

Updated

Edit: ops sorry for post spam , dont see that my post was last

[foohey]

hi, I have just modified for display rank at all player

it displays like: <nick> stats: 0 kills | 3 death | ...

public SQLGetMyRank(Handle:owner, Handle:hndl, const String:error[], any:client){
    if(hndl == INVALID_HANDLE)
    {
        LogError(error);
        PrintToServer("Last Connect SQL Error: %s", error);
        return;
    }
    
    decl String:name[64];
    decl RAkills;
    decl RAdeaths;
    decl RAheadshots;
    decl RAsucsides;
    decl RAnkNum;
    
    if(SQL_FetchRow(hndl)) 
    {
        SQL_FetchString(hndl, 0, name, sizeof(name));
        RAkills=SQL_FetchInt(hndl,1);
        RAdeaths=SQL_FetchInt(hndl,2);
        RAheadshots=SQL_FetchInt(hndl,3);
        RAsucsides=SQL_FetchInt(hndl,4);
        RAnkNum=RAkills/RAdeaths;
        decl String:buffer[512];
        Format(buffer, sizeof(buffer), "SELECT rank_id FROM css_rank WHERE (kills/deaths) >= '%i'", RAnkNum);
        if(DEBUG == 1){
            PrintToServer("DEBUG: SQLGetMyRank (%s)", buffer);
        }
        SQL_TQuery(db, SQLShowRank, buffer, client);
        PrintToChatAll("%c%s's stats: Tués: %i | Morts: %i | Headshots: %i | Suicides: %i", GREEN, name, RAkills, RAdeaths, RAheadshots, RAsucsides);
    } else {
        PrintToChat(client, "%cYour rank is not avlilable!", GREEN);
    }
}

but in SQLShowRank, I can not change for display like:
<nick> is ranked 20/160

Im french, sorry for my bad english
Thanks in advance.

[Faks]

work like charm i think we must make it better and i next versions add more functions to be more advanced but author

[graczu]

Originally Posted by foohey hi, I have just modified for display rank at all player it displays like: <nick> stats: 0 kills | 3 death | ... public SQLGetMyRank(Handle:owner, Handle:hndl, const String:error[], any:client){ if(hndl == INVALID_HANDLE) { LogError(error); PrintToServer("Last Connect SQL Error: %s", error); return; } decl String:name[64]; decl RAkills; decl RAdeaths; decl RAheadshots; decl RAsucsides; decl RAnkNum; if(SQL_FetchRow(hndl)) { SQL_FetchString(hndl, 0, name, sizeof(name)); RAkills=SQL_FetchInt(hndl,1); RAdeaths=SQL_FetchInt(hndl,2); RAheadshots=SQL_FetchInt(hndl,3); RAsucsides=SQL_FetchInt(hndl,4); RAnkNum=RAkills/RAdeaths; decl String:buffer[512]; Format(buffer, sizeof(buffer), "SELECT rank_id FROM css_rank WHERE (kills/deaths) >= '%i'", RAnkNum); if(DEBUG == 1){ PrintToServer("DEBUG: SQLGetMyRank (%s)", buffer); } SQL_TQuery(db, SQLShowRank, buffer, client); PrintToChatAll("%c%s's stats: Tués: %i | Morts: %i | Headshots: %i | Suicides: %i", GREEN, name, RAkills, RAdeaths, RAheadshots, RAsucsides); } else { PrintToChat(client, "%cYour rank is not avlilable!", GREEN); } } but in SQLShowRank, I can not change for display like: <nick> is ranked 20/160 Im french, sorry for my bad english Thanks in advance.

If somone have long nick it's display bad.

Update, Some litle Fixes in SQL and SQL Queries, Litle Change in Display TOP 10.

[k2k1n9]

Hi,

I have some problems because i don't know how the databases.cfg have to look like.

I tried something lik that:

"Databases"
{
 "driver_default"  "mysql"
 
 "default"
 {
  "driver"   "default"
  "host"    "localhost"
  "database"   "sourcemod"
  "user"    "root"
  "pass"    ""
  //"timeout"   "0"
  //"port"   "0"
 }
 
 "storage-local"
 {
  "driver"   "sqlite"
  "database"   "sourcemod-local"
 }
 "cssrank"
 {
  "driver"   "default"
  "host"    "127.0.0.1"
  "database"   "axerank"
  "user"    "root"
  "pass"    "hallo"
  //"timeout"   "0"
  "port"    "3306"
 }
}
CREATE TABLE `css_rank`(
`rank_id` int(64) NOT NULL auto_increment,
`steamId` varchar(32) NOT NULL default '',
`nick` varchar(128) NOT NULL default '',
`kills` int(12) NOT NULL default '0',
`deaths` int(12) NOT NULL default '0',
`headshots` int(12) NOT NULL default '0',
`sucsides` int(12) NOT NULL default '0',
`last_active` int(12) NOT NULL default '0',
`played_time` int(12) NOT NULL default '0',
PRIMARY KEY  (`rank_id`)) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

Is this the way it works or is something wrong with it.

Other Questions:
*Must the port be forwarded in my firewall?
*When is the information I typed in for the "user" and "password" line needed and how?
*What's the difference between a selfmade username and "root" as username?

Please help me..

k2k1n9

[Zuben]

Hello , I have problem when I write /rank I see this :

Rank System is now not avilable

Help please , Thank you

[MrCapion]

Originally Posted by Zuben Hello , I have problem when I write /rank I see this : Rank System is now not avilable Help please , Thank you

yir.. thats all I get too ???

[genzo]

Good job!

How trample kills bots in statistic? What need doing?

Sorry my English.