- Joined
- Aug 7, 2019
- Messages
- 647
- Reaction score
- 239
- Points
- 49
This is a closed thread containing updates made to the forum.
Title | Points |
New Member | 0 |
Member | 5 |
Active member | 25 |
Well-known member | 45 |
SELECT concat('https://www.mgevs.com/maps/13/hotspots/',lower(regexp_replace(REGEXP_REPLACE(title,'[^a-z\d\s ]',''),'[ ]+','-')),'.',hotspot_id),
LEFT(substring_index(thread_url,'.',-1),length(substring_index(thread_url,'.',-1)-1))
from xf_hotspot
UPDATE `xf_post` set message = concat(message,'\n\n[URL=\'https://www.mgevs.com/maps/13/hotspots/glyn-hopkin-east-london.8\']View on the dealer map[/URL]') where position = 0 and thread_id = 826;