[HarryHy]

Originally Posted by muukis Make sure your database table engine is InnoDB. This could make things faster and a little lighter for you, if it's not that already.

select table_name, table_schema, engine from information_schema.tables where table_schema not in ('mysql','information_schema') and engine <> 'memory' order by table_schema, engine, table_name;
+----------------------+--------------+--------+
| table_name           | table_schema | engine |
+----------------------+--------------+--------+
| ip2country           | l4dstats     | MyISAM | 
| ip2country_blocks    | l4dstats     | MyISAM | 
| ip2country_locations | l4dstats     | MyISAM | 
| maps                 | l4dstats     | MyISAM | 
| players              | l4dstats     | MyISAM | 
| timedmaps            | l4dstats     | MyISAM | 
+----------------------+--------------+--------+
6 rows in set (0.22 sec)
>ALTER TABLE ip2country ENGINE = INNODB;ALTER TABLE ip2country_blocks ENGINE = INNODB;ALTER TABLE ip2country_locations ENGINE = INNODB;ALTER TABLE maps ENGINE = INNODB;ALTER TABLE players ENGINE = INNODB;ALTER TABLE timedmaps ENGINE = INNODB;

Now I wait for it to go to InnoDB, hopefully it makes it quicker

Edit: It is innodb now, and it actually is running worse it seems like ...... now it won't load at all, even with cities disabled.

Edit2: Dropped ip2country_blocks and ip2country_locations, and the flags work now (sadly that breaks the maps, but at least it will load now.)

[kwski43]

It looks like the servers menu doesn't work for me:
http://stats.jacklul-l4d2.tk

Edit: it works but, title can't be with " ' "! Must use " \' "

[muukis]

Originally Posted by kwski43 It looks like the servers menu doesn't work for me: http://stats.jacklul-l4d2.tk Edit: it works but, title can't be with " ' "! Must use " \' "

OK... I thought I took care of that. I'll have to look into it then, thanks

[RasterMan]

Originally Posted by muukis You can of course use: PHP Code: $game_addresses[] = array("Server 1: Kill Them Zombies", "123.0.0.234:27015"); $game_addresses[] = array("Server 2: Kill Them Zombies", "123.0.0.234:27025"); $game_addresses[] = array("Server 3: Kill Them Zombies", "123.0.0.234:27035");

Worked a treat m8 thx

[eargosedown]

Is the menu supposed to only show up with more than 1 server listed? Because that looks pretty slick but as-is I only host one play-server.

As always Muukis, continuing to love this plugin. Thanks for all your hard work!

@kwski: Would you mind if I improve upon the achievements area you started with and release an updated file for that? =)

[muukis]

Originally Posted by eargosedown Is the menu supposed to only show up with more than 1 server listed? Because that looks pretty slick but as-is I only host one play-server.

Yes. I thought it was unnecessary for the menu when only one object in the list. By doing a quick search at common.php, you can customize to always show the list with just a tiny edit.

[muukis]

Originally Posted by HarryHy select table_name, table_schema, engine from information_schema.tables where table_schema not in ('mysql','information_schema') and engine <> 'memory' order by table_schema, engine, table_name; +----------------------+--------------+--------+ | table_name | table_schema | engine | +----------------------+--------------+--------+ | ip2country | l4dstats | MyISAM | | ip2country_blocks | l4dstats | MyISAM | | ip2country_locations | l4dstats | MyISAM | | maps | l4dstats | MyISAM | | players | l4dstats | MyISAM | | timedmaps | l4dstats | MyISAM | +----------------------+--------------+--------+ 6 rows in set (0.22 sec) >ALTER TABLE ip2country ENGINE = INNODB;ALTER TABLE ip2country_blocks ENGINE = INNODB;ALTER TABLE ip2country_locations ENGINE = INNODB;ALTER TABLE maps ENGINE = INNODB;ALTER TABLE players ENGINE = INNODB;ALTER TABLE timedmaps ENGINE = INNODB; Now I wait for it to go to InnoDB, hopefully it makes it quicker Edit: It is innodb now, and it actually is running worse it seems like ...... now it won't load at all, even with cities disabled. Edit2: Dropped ip2country_blocks and ip2country_locations, and the flags work now (sadly that breaks the maps, but at least it will load now.)

That's weird. Though in your case, the Google Maps would certainly be difficult to process, because it would have taken a lot of time to search locations for ~90 players from table size of 3.7M rows. I would not recommend doing this. I can try to optimize the database still some, but don't know if it's worth it. Maybe set the player locations from in-game and store it to DB so it is unnecessary to search the locations again?

[kwski43]

Originally Posted by muukis That's weird. Though in your case, the Google Maps would certainly be difficult to process, because it would have taken a lot of time to search locations for ~90 players from table size of 3.7M rows. I would not recommend doing this. I can try to optimize the database still some, but don't know if it's worth it. Maybe set the player locations from in-game and store it to DB so it is unnecessary to search the locations again?

Some player have dynamic ip's, in my opinion its pointless.

[DmanWCG]

Alright, I cant see the plugin through HLSW and when I do the commands to see the plugin I get this "[SM] Plugin Custom.smx is not loaded."

[muukis]

Originally Posted by DmanWCG Alright, I cant see the plugin through HLSW and when I do the commands to see the plugin I get this "[SM] Plugin Custom.smx is not loaded."

Check your logs for more details.