Differences

This shows you the differences between two versions of the page.

--- 4x4_evolution_tracks [2023/01/06 17:08] – fuzzy
+++ 4x4_evolution_tracks [2023/01/13 19:47] – fuzzyfish
@@ Line 4: / Line 4: @@
 <datatables>
 <sql>
-SELECT 'Track Name (Info)' , 'Author', "File Name (Download)"
+SELECT 'Track Name' , 'Author', 'Created', "File Name (Download)"
 UNION ALL
 SELECT
-concat('<a href=\"https://4x4evolution.net/doku.php?id=Evo_1_Track_', trackFile, '\">', trackName, '</a>'),
+concat('<a href=https://www.4x4evolution.net/Evo1_Tracks.php?id=', ID, '>', trackName, '</a>'),
 trackAuthor,
-concat('<a href=https://www.4x4evolution.net/Evo1_Tracks/', trackFile, '>', trackFile, '</a>')
+trackDate,
+concat('<a href=https://www.4x4evolution.net/Downloads/Evo1_Tracks/', trackFile, '>', trackFile, '</a>')
 FROM Evo1_Tracks
+WHERE trackType3='1' or trackType3='2';
 </sql>
 </datatables>
 =====NOTE DOWNLOADS ARE DOWN=====