Climbers Top v2.01 for Kz Jump Plugin by teame06 - Page 2

ConnorMcLeod · 09-09-2007 , 17:24 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

Oh please... make one without mySQL, in a motd window.

Nofius · 09-10-2007 , 10:08 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

Can somone fix the sql issue or get this plugin off from Approved plugins.
It itsnt Complete with sql settings.

vittu · *Last edited by vittu; 09-10-2007 at 17:09.*

Works fine for me, though I do not recall if i edited anything. However, there is an exploit in this that I have not bothered to look into. Just wish teame stopped working with sm and got back to finishing his kz plugin since it's the best one there is.

Nofius · 09-11-2007 , 06:49 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

How did you import the sql data thats were in the file vittu ?
Seems somethings is missing in the data or you cant just import it into phpmyadmin, read something at the homepage but cant Leathian som didnt understand alot what they meent. Or do someone know about any other climbing Stats that works ?

Or vittu can you export your sql data (For this climbing plugin)to an file and mail me that. ?

Nofius · 09-19-2007 , 06:44 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

When will this Plugin be fixed about the database Issue ?

**Hawk552** · 09-19-2007 , 06:54 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

This relies on a plugin that's currently unapproved, so I have no choice but to unapprove this too.

vittu · 09-20-2007 , 00:04 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

Quote:

Originally Posted by Hawk552

This relies on a plugin that's currently unapproved, so I have no choice but to unapprove this too.

agreed, but this plugin does work...

Nofius, i'll check a dump for you later and edit it into here...

lexikon · *Last edited by lexikon; 03-17-2009 at 07:17.*

Help plz! Nik have ` - example `[noob]`NeWbie
This nik not write in Top15
How fix .sma?

Quote:

name='^".mysql_real_escape_string (%s).^"'

don't work

lexikon · 03-17-2009 , 07:20 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

yup)

Quote:

result = dbi_query(sql, "SELECT time FROM kz_top WHERE name='^".mysql_real_escape_string(%s).^"' AND map='%s'", name, mapname);
if(result == RESULT_NONE) {
dbi_query(sql, "INSERT INTO kz_top VALUES ('%s', '%d', '%d', '%d', '%s')", name, time, cp_count, gc_count, mapname);
} else if(result <= RESULT_FAILED) {
server_print("[AMXX] SQL error.");
} else {
new qtime = dbi_field(result, 1);
dbi_free_result(result);
if(time < qtime)
dbi_query(sql, "UPDATE kz_top SET time='%d', cp='%d', gc='%d' WHERE name='^".mysql_real_escape_string(%s).^"' AND map='%s'", time, cp_count, gc_count, name, mapname);
}

WORK!!! If nik use symbol ' or ` change this stroke in .sma file
Sorry bad eng

M1R0n,M' · 03-27-2009 , 11:38 Re: Climbers Top v2.01 for Kz Jump Plugin by teame06

Good Plugin