next »

[MordyT]

Hi all,
Have a client who has a weird issue. He has chatlogger installed on his bot and can view his chat in Echelon. All is fine there, you type, and it shows up on the spot. The issues is if you manually look at the database, in the chatlog table, you will not see the latest chat. You will see older chat (approx 600 or so lines), but not the latest chat.

I thought echelon pulled the chat from the database, so how is it possible the echelon shows the correct chat and if looking at the database you see only older chat?

Let me know what you need to look into this issue. Screens, URLs, MySQL details, whatever.

Thanks!

[82ndAB.Bravo17]

I think you must be looking two different places or with some strange view of the correct table, Echelon can only get its data from what is in the tables

[MordyT]

I think you must be looking two different places or with some strange view of the correct table, Echelon can only get its data from what is in the tables

I would say the same as you just did. Except I have triple checked and am in shock - because I see this too. Is it OK if I send you a message with info to log into echelon, ftp where it is stored (for the config file) and phpmyadmin?

[Courgette]

have you played with the sort feature of phpmyadmin ? you might have phpmyadmin show from the oldest to newest instead of from the newest to oldest.

[BlackMamba]

Try:
select * from chatlog order by msg_time desc limit 10;
This shows you the last 10 messages

[82ndAB.Bravo17]

I would say the same as you just did. Except I have triple checked and am in shock - because I see this too. Is it OK if I send you a message with info to log into echelon, ftp where it is stored (for the config file) and phpmyadmin?

Yes, I'll take a look

[MordyT]

have you played with the sort feature of phpmyadmin ? you might have phpmyadmin show from the oldest to newest instead of from the newest to oldest.

I have never used the sort feature.

Try:
select * from chatlog order by msg_time desc limit 10;
This shows you the last 10 messages

I will try this next - thanks

Yes, I'll take a look

You haz message. Thanks!

[82ndAB.Bravo17]

It's in some strange order, if you change sort from none to Primary(Descending) you will see it in reverse (newest first) order

[MordyT]

It's in some strange order, if you change sort from none to Primary(Descending) you will see it in reverse (newest first) order

Hmm, that is weird. Any idea why I need to do that for this database? I can give you access to another one that works fine as is.
I never set sorting either...

[82ndAB.Bravo17]

Hmm, that is weird. Any idea why I need to do that for this database? I can give you access to another one that works fine as is.
I never set sorting either...

The only thing that I can think of is that records have been deleted from the table, and then they get filled in as needed. Not sure if that is how mysql works, but that is one guess.

[MordyT]

I have passed the info onto the client and asked him if he deleted rows in the table.
Thank you for looking at this, if you want a personal donation (to you) just send me a address.

[82ndAB.Bravo17]

This ones a freebie Mordy! 

[setman]

What about if you can see all the chat, and you can type back into echelon and see it come up in echelon, but it does not come up in game?

[WickedShell]

Is the rcon address/port set up right? And last I looked not all RCON protocols were supported from echelon. What game type are you trying to talk back to?

[setman]

COD4 and MW2

The mw2's run from home, the cod4 from a gameserver company

this is what all the echelon files say for all servers  "rcon_ip" => "127.0.0.1",