[bazhenov93]

No. There are only 1 sound when player finish the map.. If the player make a new rec(1st place) the sound is the same.. Could be better using another sound for 1st place in top,.

[NucL3ra]

Only the non-sql version has this function, indeed. The SQL version doesn't check the place, because sometimes the DB might lag or it might be very big and the return could come in seconds after the finish button is pressed.

[bazhenov93]

Damn

You have the code? because i can't do it

[NucL3ra]

PHP Code:

public GetNewRank_QueryHandler(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
    new id = cData[0]
    if( iFailState != TQUERY_SUCCESS )
    {
        return log_amx("TOP15 SQL: SQL Error #%d - %s", iErrnum, szError)
    }
    
    new steam[32], authid[32], namez[32], name[32], i = 0
    get_user_authid(id, steam, 31)
    get_user_name(id, namez, 31)
    
    while( SQL_MoreResults(hQuery) )
    {
        i++
        if(equal(steam, "VALVE_ID_LAN") || equal(steam, "STEAM_ID_LAN") || strlen(steam) > 18)
        {
            SQL_ReadResult(hQuery, 0, name, 31)
            if( equal(name, namez) )
            {
                ColorChat(0, GREEN, "[KZ]^x03 %s^x01 is now on place ^x03%d^x01 in^x03 %s^x01", namez, i, cData[1] == PRO_TOP ? "Pro 15" : "Noob 15");
                break;
            }
        }
        else
        {
            SQL_ReadResult(hQuery, 0, authid, 31)
            if( equal(authid, steam) )
            {
                ColorChat(0, GREEN, "[KZ]^x03 %s^x01 is now on place ^x03%d^x01 in^x03 %s^x01", namez, i, cData[1] == PRO_TOP ? "Pro 15" : "Noob 15");
                break;
            }
        }
        if(i)
            client_cmd(0, "spk woop")
        else
            client_cmd(0, "spk buttons/bell1")
        SQL_NextRow(hQuery)
    }
    
    return PLUGIN_CONTINUE    
} 


And delete the other one (line 2280)

[kp3t3h]

a suggestion

please add the commands with 'say' and 'say_team'


second, if i have a scout in hand, when starting the timer, start without changing the weapons


and there is a problem with the weapon column in top15 lists (pro,nub)
instead of the weapon it shows the date when the record was made,

i suggest you add a special column for the date as i think its useful so that other players would know when the record was made


also please put cvars for changing hud text colors, and colors in MOTD in top15 lists
and another change in the top15 lists,
my personal time in the list to be marked in yellow background , so its easy noticable

and finally all 15 players to be visible in the top15 lists

thats all for now

[NucL3ra]

Originally Posted by kp3t3h a suggestion please add the commands with 'say' and 'say_team'

Already planned for next version

Originally Posted by kp3t3h second, if i have a scout in hand, when starting the timer, start without changing the weapons

I thought many times of changing it. Perhaps I'll change it just for scout in next version.

Originally Posted by kp3t3h and there is a problem with the weapon column in top15 lists (pro,nub) instead of the weapon it shows the date when the record was made, i suggest you add a special column for the date as i think its useful so that other players would know when the record was made

I forgot to fix it o_o. I'll keep just date since there's not enough space for weapons in MOTD top 15

Originally Posted by kp3t3h also please put cvars for changing hud text colors, and colors in MOTD in top15 lists

kz_hud_color "r g b"

Originally Posted by kp3t3h and another change in the top15 lists, my personal time in the list to be marked in yellow background , so its easy noticable

It might be possible, but I want to edit the top15 as few as possible as it can get bugged very easy if it's too heavy (functions, colors, columns etc.)

Originally Posted by kp3t3h and finally all 15 players to be visible in the top15 lists

Same problem, it used to be 15, but it also used to bug a lot. You can edit it here if you want:
Line: 2453 and 2488

PHP Code:

for (new i = 0; i < 10; i++) 


->

PHP Code:

for (new i = 0 ; i<15; i++) 


[RuRuRu612754]

SQL will not work properly.
There is a problem with my settings?

addons/amxmodx/configs/kz/kreedz.cfg

PHP Code:

kz_sql_host "127.0.0.1"
kz_sql_files "xxx.xxx.xxx.xxx/kreedz/top15/"
kz_sql_user "prokreedz_db"
kz_sql_pass "prokreedz_db"
kz_sql_db "prokreedz_db"
kz_sql_name "Kreedz Server" 


www/kreedz/top15/include/config.php

PHP Code:

define("DB_HOST", "127.0.0.1");
define("DB_USER", "prokreedz_db");
define("DB_PASS", "prokreedz_db");
define("DB_NAME", "prokreedz_db"); 


Best Regards,

[NucL3ra]

Certainly looks not. Does it say cannot connect to SQL or is it some other kind of error?

[bazhenov93]

About the finish sounds, not working.

[kp3t3h]

Originally Posted by NucL3ra Originally Posted by kp3t3h a suggestion please add the commands with 'say' and 'say_team' Already planned for next version

Originally Posted by NucL3ra Originally Posted by kp3t3h second, if i have a scout in hand, when starting the timer, start without changing the weapons I thought many times of changing it. Perhaps I'll change it just for scout in next version.

please do, its annoying that it changes the weapon and have to write /scout to get it again

Originally Posted by NucL3ra Originally Posted by kp3t3h and there is a problem with the weapon column in top15 lists (pro,nub) instead of the weapon it shows the date when the record was made, i suggest you add a special column for the date as i think its useful so that other players would know when the record was made I forgot to fix it o_o. I'll keep just date since there's not enough space for weapons in MOTD top 15

i would like the weapon column since sometimes i feel like to know which weapon he finished with, scout or usp

Originally Posted by NucL3ra Originally Posted by kp3t3h also please put cvars for changing hud text colors, and colors in MOTD in top15 lists kz_hud_color "r g b"

its only for the hud text, not the motd background color
what about the MOTD background colors in top15? how to change them ?

Originally Posted by NucL3ra Originally Posted by kp3t3h and another change in the top15 lists, my personal time in the list to be marked in yellow background , so its easy noticable It might be possible, but I want to edit the top15 as few as possible as it can get bugged very easy if it's too heavy (functions, colors, columns etc.)

if its possible please do it,
i believe you can add cvars for all functions

Originally Posted by NucL3ra Originally Posted by kp3t3h and finally all 15 players to be visible in the top15 lists Same problem, it used to be 15, but it also used to bug a lot. You can edit it here if you want: Line: 2453 and 2488 PHP Code:                             for (new i = 0; i < 10; i++)  -> PHP Code:                             for (new i = 0 ; i<15; i++)

cvar here too please , i cant search for it on every new version

=====
-----
=====
and a question
while in spec or dead, can i see the complete chat on alive players, (say/say_team) ?????//
if not, please do it

2. is godmode always on? even if the map requires some special technique, like edgebug, or wallbug? those maps dpnt have the 10k heal box

3. can you make pause to be used while in air

4. is there autoheal? like in 'kreedz ultimat'

thats all for now


i forgot this too
in the menu, when selecting top15 (3) , than again (3) for main menu, it closes the menu, the same goes when opening the pro/nub lists
and also the invisible menu doesn't have an option to go back to main menu