Differences

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

--- 4x4_evolution_tracks [2023/01/06 16:41] – created fuzzy
+++ 4x4_evolution_tracks [2023/01/13 19:47] (current) – fuzzyfish
@@ Line 3: / Line 3: @@
 <datatables>
-<sql>select
+<sql>
-concat('<a href=https://4x4evolution.net/doku.php?id=Evo1_', trackName, '>', trackName, '</a>')
+SELECT 'Track Name' , 'Author', 'Created', "File Name (Download)"
+UNION ALL
+SELECT
+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,
-from Evo1_Tracks
+concat('<a href=https://www.4x4evolution.net/Downloads/Tracks_Evo1/', trackFile, '>', trackFile, '</a>')
+FROM Evo1_Tracks
+WHERE trackType3='1' or trackType3='2';
 </sql>
 </datatables>
 =====NOTE DOWNLOADS ARE DOWN=====