Updated the import script a bit so that only new items are inserted into the database and immediately dumped the script in a crontab. It will now update the database every day, just after midnight. This will stay in place until the gamemode supports the database as well.
The recommended query to insert a new log item to the database is as follows:
Please do not hesitate to ask me anything. It's important this gets implemented correctly, so we all need to understand what's going on.
The recommended query to insert a new log item to the database is as follows:
Code:
INSERT INTO samp_logs (log_date, log_type, log_address, log_user_name, log_user_id, log_subject_name, log_subject_id, log_reason) VALUES (NOW(), "kick", 703236693, "MrBondt", 11464, "Matthias", 42659, "Have nice day");Please do not hesitate to ask me anything. It's important this gets implemented correctly, so we all need to understand what's going on.