[kennyist]

Hi,

Im having problems with the site bit, I keep getting

Warning:  arsort() expects parameter 1 to be array, null given in /home/kennyi81/public_html/lostgamers/tf2stats/player.php on line 792

On players profiles. how can i fix this?

http://lostgamers.kennyiststudios.co...M_0:1:18285185 (example)

[jameless]

Looks like with all the updates that have come out, we missed the update where you created the ItemIndex column. I had to manually create it. Does the column allow NULL? What's the max size int(4)?

[kennyist]

And getting errors here:

http://lostgamers.kennyiststudios.co..._viaduct_event

On the map screens.

[jameless]

I think I found why the map page wasn't loading. You were calling a mysql function prior to connecting to the database.

When I changed:

$steamid="";
if(isset( $_GET['mapname'] ))
{
$steamid = mysql_real_escape_string($_GET["mapname"]);
}

include("inc/dbconnect.php");
include("inc/footer.inc.php");

To:

include("inc/dbconnect.php");
include("inc/footer.inc.php");

$steamid="";
if(isset( $_GET['mapname'] ))
{
$steamid = mysql_real_escape_string($_GET["mapname"]);
}

It now works.

[Sillium]

Thanks jameless

[war100ck]

Originally Posted by galadril War100ck... it's not only running the script..! You need to export the result (in your youtube movie on 1: 32). This result 'is' a sqlscript!! So you need to export the result and then run the query on your stats database. Sorry, but I don;t know how to explain this more clear..

Sorry you did of course but what format do the export? SQL does not, used to test different versions of pmyadmin, used for hosting and localhost, the results of 0, you is not hard to please do videomanual or manual in the screenshots.

[jameless]

@war: Run the query first, then at bottom is button for 'Export'. This way you are exporting the results of the query. The Export button at top, will just try to export whole table. If I were you I would pick to export as Word or as TXT so you can edit out the extra whitespace. Once the query is done you will have a bunch of sql queries. Then you want to copy those queries back into phpmyadmin and run the queries on the table. This will also take some time but should be what you're looking for.

[war100ck]

Originally Posted by jameless @war: Run the query first, then at bottom is button for 'Export'. This way you are exporting the results of the query. The Export button at top, will just try to export whole table. If I were you I would pick to export as Word or as TXT so you can edit out the extra whitespace. Once the query is done you will have a bunch of sql queries. Then you want to copy those queries back into phpmyadmin and run the queries on the table. This will also take some time but should be what you're looking for.

Thanks it worked

[m4ster]

Can you make the future versions working without geolite extension being available? Thank you.

[DarthNinja]

Originally Posted by m4ster Can you make the future versions working without geolite extension being available? Thank you.

Why?