Also-Known-As [MySQL]
#2

Comparing the IPs does not make sense as it fetches only records that match the IP to begin with. What you need is COUNT aggregate function which returns 1 row with the counter.

The data are not accessed too frequently so I would get rid of the array and execute the query each time. But you need to select only the name from the database and not everything.

The way it is done, it can only store 1 IP. Create a table to track the activity of the players.
Reply


Messages In This Thread
Also-Known-As [MySQL] - by JaKe Elite - 23.01.2019, 14:22
Re: Also-Known-As [MySQL] - by Calisthenics - 23.01.2019, 15:39
Re: Also-Known-As [MySQL] - by Logic_ - 23.01.2019, 17:54

Forum Jump:


Users browsing this thread: 1 Guest(s)