[krispx]

Hi loki,

when i typ: sm_rankme_remove_duplicate

L 02/01/2012 - 10:07:24: [rankme.smx] [RankMe] Query Fail: You can't specify target table 'rankme' for update in FROM clause

How fix this please?

[lokizito]

Are you running in MySQL or SQLite?

[lokizito]

@krispx
No need to answer, already got the problem.

@All
New version posted.
Changelog:

= V.2.7.6 (02/02/12):
     => Fix:
          = Fixed remove duplicate queries not working on MySQL. (thanks krispx)

[lokizito]

New version posted.
Changelog:

= V.2.7.7 (02/03/12):
     => Fix:
          = Fixed misformatted queries in MySQL. (thanks krispx)

[sajmon83]

Polish Translation Update
- Polish letters have been added in the missing part of the translation
- Added missing translation MVP

[NUdH3]

I have seen that players only rank by KD or points. Proposal: Rank my Kills?

[lokizito]

Originally Posted by sajmon83 Polish Translation Update - Polish letters have been added in the missing part of the translation - Added missing translation MVP

Thank you, gonna updated it when i release a new version.

Originally Posted by NUdH3 I have seen that players only rank by KD or points. Proposal: Rank my Kills?

For ranking by kills minus deaths, just set points given by kills to 1, no bonus points by difference of points or objectives or headshot. For ranking by kills only, set also, to no points lose mode.

[GunSpeed]

HI,

Thanks for the support!

My server has sourcebans and running perfectly, just without any need for ftp! So I was thinking if there is any chance or away to bypass the ftp requirement for the web part?

Both my gaming server and the web are one (local).


And regarding the mysql tables, are they generated automatically via ftp? (using phpmyadmin).

Again, thank you!!

[lokizito]

Originally Posted by GunSpeed HI, Thanks for the support! My server has sourcebans and running perfectly, just without any need for ftp! So I was thinking if there is any chance or away to bypass the ftp requirement for the web part? Both my gaming server and the web are one (local). And regarding the mysql tables, are they generated automatically via ftp? (using phpmyadmin). Again, thank you!!

If you dont have a ftp account to use, then you need to run the plugin in MySQL. For that, look at the first post, there is explained how to do that.

[lokizito]

Originally Posted by GunSpeed Thank you! Don't know how have I miss it! Checking again with 2nd eye opened. rankme_dump_db -> Dump the Database to SQL file? (required to be 1 if using the web interface and SQLite, case MySQL, it won't be dumped) 1 = true 0 = false. Default 0. So, what if I am using web interface and Mysql ? [Tue Feb 14 097:20 2012] [error] [client xx.xx.xx.xx] PHP Parse error: syntax error, unexpected T_VARIABLE in /var/www/rankme/config.php on line 24 line 24 : is the ftp info...

Set rankme_mysql to 1 like said in the main post. When running in MySQL, the dump file is ignored as it isn't needed.

About the error, this line is missing a semicolon in the config.php file:

$bd_table = "rankme" // DATABASE TABLE BEING USED AT THE PLUGIN. (rankme_sql_table cvar). Default: rankme.

Should be:

$bd_table = "rankme"; // DATABASE TABLE BEING USED AT THE PLUGIN. (rankme_sql_table cvar). Default: rankme.