0
I need to create a list of online users at the moment, or even 20 minutes ago. Being that the table with the data of the users is called 'User', and the table that has the accesses of these users is called 'Core.logs'.
I have no idea how to do this! Can someone at least give me a hint?
What are these tables? Database tables? If so, which database? What is the structure of the tables? If not, are they text files? How they are organized?
– bfavaretto
Yes, from a database, Mysql. Table structure: user Columns: user_id int(11) AI PK user_type int(11) name varchar(255) nickname varchar(255) email varchar(255) password varchar(255) image varchar(255) sessao varchar(255) telephone varchar(45) cargo varchar(255) sector varchar(255) status int(1) api_key varchar(255) Table: core_logs Columns: core_logs_id int(11) AI PK usuario_id int(11) cliente_id int(11) references varchar(45) acao Enum('C','R','U',’D') sessao_alias varchar(255) Metadata longtext data timestamp
– GWER