[el_psycho]

Originally Posted by Mr. Man I was confused because the old link contained a depreciated API method.

This is true. I also got confused when researching this problem becuase as it is right now, the maps image will not work without changing the PHP code.

[matrixmark]

Originally Posted by muukis Some time ago, I made an app for creating your own population.csv files: https://forums.alliedmods.net/showth...123#post816123

Meh I couldnt get any of that to work... I pasted stuff into the proggy but it didnt do jack and when i just copied it back out and into a file i saved as a .csv it just broke the stats.

Think I'm gonna need some detailed instructions for a dumass (me) dude. If you would be so kind?

[muukis]

Originally Posted by matrixmark Meh I couldnt get any of that to work... I pasted stuff into the proggy but it didnt do jack and when i just copied it back out and into a file i saved as a .csv it just broke the stats. Think I'm gonna need some detailed instructions for a dumass (me) dude. If you would be so kind?

At least in Firefox, when you paint the table and copy the text (the i -image is also copied!) to clipboard and paste it to for instance notepad, the text should look something like this (tabulator separated values):

<    Åland     ÅAL    AReg    Mariehamn    1,555    24,604    25,776    26,766
<    Etelä-Karjala [South Karelia]     EKA    Reg    Lappeenranta    5,613    141,240    137,149    135,604
<    Etelä-Pohjanmaa [South Ostrobothnia]     EPO    Reg    Seinäjoki    13,445    201,670    195,615    193,812
<    Etelä-Savo     ESA    Reg    Mikkeli    14,000    176,089    167,369    160,507
<    Itä-Uusimaa (Östra Nyland)     IUU    Reg    Porvoo    2,761    85,063    89,604    92,933
<    Kainuu    KAI    Reg    Kajaani    21,506    96,957    89,777    85,303
<    Kanta-Häme     KHÄ    Reg    Hämeenlinna    5,199    162,248    165,307    168,381
<    Keski-Pohjanmaa [Central Ostrobothnia]    KPO    Reg    Kokkola    5,273    71,567    71,292    70,696
<    Keski-Suomi [Central Finland]    KSO    Reg    Jyväskylä    16,542    255,948    263,886    269,575
<    Kymenlaakso (Kymmenedalen)    KYM    Reg    Kotka    5,112    193,919    187,474    185,196

Paste this text (not the text above because the format has changed at the allied modders forum) to the populous app and it will convert the text to proper CSV format:

"County or equivalent","Åland ",26766
"County or equivalent","Etelä-Karjala [South Karelia] ",135604
"County or equivalent","Etelä-Pohjanmaa [South Ostrobothnia] ",193812
"County or equivalent","Etelä-Savo ",160507
"County or equivalent","Itä-Uusimaa (Östra Nyland) ",92933
"County or equivalent","Kainuu",85303
"County or equivalent","Kanta-Häme ",168381
"County or equivalent","Keski-Pohjanmaa [Central Ostrobothnia]",70696
"County or equivalent","Keski-Suomi [Central Finland]",269575
"County or equivalent","Kymenlaakso (Kymmenedalen)",185196

[matrixmark]

Nah didnt work Muukis, I dont know what the heck is going on with it but it just ends up garbling the stats at the bottom up.

Really cba to keep messing with it so thanks anyways.

[Mr. Man]

Hello Mukkis,

I had a question with regards to "big" data such as my statistic DB here: http://176.31.208.74/l4d2stats/

Will there be a point in which the points in the high-score and other leaderboards be so big that they won't display properly? I am just curious.

[muukis]

Originally Posted by Mr. Man Hello Mukkis, I had a question with regards to "big" data such as my statistic DB here: http://176.31.208.74/l4d2stats/ Will there be a point in which the points in the high-score and other leaderboards be so big that they won't display properly? I am just curious.

I'm sure that there is a possibility that the DB can get too heavy, for multiple reasons: DB server cannot handle the data, HD space, 32bit signed values overflow, etc., but I don't think the system is otherwise fragile for a large catalog of player stats. I think Harm, a dude that helped me with the plugin at one point, had a lot bigger row count in comparison to yours. The only problem that he had and I know of was the Google maps, which practically put the DB server on halt for ~10 sec per page load. He was having 50-100 players writing stats at peek times on the server cluster he was then having.

[Evkval]

Good day!
Please tell me how to display the ip address of the player on the page? Thank you! http://kalibr.myarena.ru/

[muukis]

Originally Posted by Evkval Good day! Please tell me how to display the ip address of the player on the page? Thank you! http://kalibr.myarena.ru/

In player.php file (line 235 where it sets the steam_id)...
- Add new line:

PHP Code:

$stats->set("player_ip", $row['ip']); 


Then in player.tpl file (line 56 where it sets the steam id)...
- Add new line:

PHP Code:

<tr><td>IP:</td><td><?php echo $player_ip;?></td></tr>

[Evkval]

muukis
thank you!!!

[Chronic1]

Can someone help me set this up without a web site? I'm really confused on what to fill out in the database.cfg and where to put the l4d2stats.sql