query to obtain information of particular client services

[Sylvert]

Hello, I have a question on how to obtain information from the servers of a particular customer. How could adapt the following query to only show me of a particular customer?

 

SELECT a.ip_address, a.game_port, b.* FROM tc_game_services a, tc_game_service_live_stats b WHERE online = 1 AND a.service_id = b.service_id;

[ECF]

You should be able to remove this:

AND a.service_id = b.service_id;

 

And add something like this:

AND a.client_id = b.client_id;

 

I would have to take a look at the DB for the proper client variable but I think that is correct.

[LFA]

Like this. Replace c.user_id=1 with the id of the user you want.

 

SELECT a.ip_address, a.game_port, b.* FROM tc_game_services a, tc_game_service_live_stats b, tc_services c WHERE online = 1 AND a.service_id = b.service_id AND c.service_id = a.service_id AND c.user_id=1;

[Sylvert]

Like this. Replace c.user_id=1 with the id of the user you want.

 

SELECT a.ip_address, a.game_port, b.* FROM tc_game_services a, tc_game_service_live_stats b, tc_services c WHERE online = 1 AND a.service_id = b.service_id AND c.service_id = a.service_id AND c.user_id=1;

 

thank you very much, I worked very well the query