Premium Gl0bal 0 Posted August 27, 2014 Premium Share Posted August 27, 2014 (edited) Hey today I noticed, that some log tables has no real colum names. For example the fish_log table looks like that: Does anybody here has a better fish_log than I? It's is nearly imposible to work with this. Sorry for my bad english Regards Edited August 18, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium Zonni 230 Posted August 28, 2014 Premium Share Posted August 28, 2014 Query("INSERT INTO fish_log%s VALUES(NOW(), %u, %d, %u, %d, %u, %u, %u)", get_table_postfix(), dwPID, prob_idx, fish_id, fish_level, dwMiliseconds, dwVnum, dwValue); Set your column name to the right. 1 -> datatime 2 -> player_id 3 -> prob_idx 4 -> fish_id 5 -> fish_level 6 -> miliseconds (unix timestamp) 7 -> vnum 8 -> value 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now