[+ARUKARI-]

Originally Posted by dekken PHP Code: Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dekken/public_html/ranking_sample.php on line 39  Player Ranking TOP15    rank  name kills deaths score hits shots hs eff. acc. acc. hs  also: PHP Code: [PSD] Error No.2003: Can't connect: Can't connect to MySQL server on '127.0.0.1' (111)  even tho i changed the HOST.

plz try input command "reload"

[dekken]

ok it fixed it and i fixed the PHP Problem
but now on mapchange my server just Freezes...
and also your Php page is Dark
mine is just white and not in shape
http://dekken.info/ranking_sample.php

The Debug Mode:

PHP Code:

[PSD] Error: Duplicate entry 'STEAM_0:1:17865366' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:5760880' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:972174' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:10158665' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:16052173' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:14140320' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:2826306' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:14392047' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:12807403' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:9846756' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:15494821' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:4266526' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:15848832' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:8335916' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:14927823' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:15804847' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:18626560' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:18554891' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:6696050' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:15602797' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:18167809' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:4238843' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:10454125' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:17577176' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:10637531' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:10268473' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:17963583' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:14901481' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:15234271' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:3406736' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:3421465' for key 1
[12345@localhost hlds]$ [PSD] Error: Duplicate entry 'STEAM_0:1:15345193' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:16161315' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:14943835' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:12866801' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:1:3726201' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:12067542' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:10493160' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:15650136' for key 1
[PSD] Error: Duplicate entry 'STEAM_0:0:18471812' for key 1 


LOTS OF THOSE

[+ARUKARI-]

dekken:
Is it that considerable load depends on your server at the time of a mapchange?

and also your Php page is Dark mine is just white and not in shape

It is the thing which yourself design.
I showed a sample.

[dekken]

Originally Posted by +ARUKARI- dakken: Is it that considerable load depends on your server at the time of a mapchange?

what?
the server Freezes and Shows lots of this in SSH client..
i cant do anything except to crashing the server and restarting him
it happens on map change/Rcon restart/Reload, anything..

and could you give me the design you used please? :>

[+ARUKARI-]

Originally Posted by dekken what? the server Freezes and Shows lots of this in SSH client.. i cant do anything except to crashing the server and restarting him it happens on map change/Rcon restart/Reload, anything..

hmm..
Plz try nondebug version.
It doesn't give such an error.

and could you give me the design you used please? :>

I use CSS in PHPBB2(Counter-Strike template).
Look this Mypage(in Japan)

upload this php file.
but no upload css..ok?

[dekken]

well one more thing
lets say i get 100New Players today. so 100Players getting inside the Database taking ages!
it took me about 20-30Seconds until it got 100Players to the database
which means the Server was Frozen and many players timed out
is there any way to make the Process of setting peoples into the DB Faster?

[+ARUKARI-]

Originally Posted by dekken well one more thing lets say i get 100New Players today. so 100Players getting inside the Database taking ages! it took me about 20-30Seconds until it got 100Players to the database which means the Server was Frozen and many players timed out is there any way to make the Process of setting peoples into the DB Faster?

I am not good at SQL very much.

However, it is thought that there is the method to arrange in DB faster.
It is to make it sequential processing not batch processing.

I may show a new version soon.
Thank you for a precious opinion.

[dekken]

well i hope you will make it faster!
this is very good plugin! thanks love it
also i would recomend adding stuff like Kill/Death..
Like you die 4Times and Kill 1
Your K/D will be 0.25%
Or you kill 4 and Die once
your K/D will be 4%
it would be nice and easy to do it

Thank You! +Karmaaaaaaaa

[+ARUKARI-]

update:
0.6 - RC linux version.
I trying DB faster.
and add k/d rate field.

[dekken]

nice!
ill test the new update soon