[Freeciv] Re: civserver.freeciv.org stats (was: civserver)

[Paul Zastoupil <paulz@xxxxxxxxxxxx>]

On Mon, Jul 30, 2001 at 01:41:11PM +0200, Reinier Post wrote:
> On Mon, Jul 30, 2001 at 12:03:33PM +0200, Christian Knoke wrote:
> 
> > > > where are the gamelogs stored, for the civserver games?
> > > > The Latest games at http://civserver.freeciv.org/ seem
> > > > not to be up to date. How can I identify a gamelog for
> > > > a game, even if I don't know the number?
> > >
> > > You can't.  What you can do is query the database by player name
> > > or other criteria.  Dates are not included.
> > 
> > Great. When I do a query, the date and time of the game is displayed.
> > But I can't query for dates? Pity.
> > 
> > I wasn't able to find any syntax or web form to do a query, so I am
> > blind or it is not there ;)
> 
> As I meant to say, the dates are not included into the database.
>  
> > Also, the games of the last two weeks aren't included. Is there
> > a reason for it? Or is there another place where I can retrieve them?
> 
> I have no idea.  I'll check the reporting system when I have time.

I found the problem.

And guess what.... It was my fault!
I upgraded mysql and didn't notice it moved it socket for local
connections.  > /dev/null 2>&1 can do that do you...

Anyway its fixed now.  If I have time I will go through and make sure
old games get entered.


-- 
Paul Zastoupil