Hello. I am creating an MDT for a roleplay server and have connected it to the SQL Database. I am attempting to pull the characters names but they are stored with other details of the character so when I am attempting to show the data it shows the whole thing instead of just the name.
e.g. {“cid”:“2”,“birthdate”:“2000-05-31”,“nationality”:“English”,“gender”:0,“backstory”:“placeholder backstory”,“phone”:“3398184962”,“firstname”:“Sammy”,“account”:“US05QBCore8395948277”,“lastname”:“Sanders”}
{“firstname”:“Luke”,“birthdate”:“1992-11-05”,“nationality”:“British”,“backstory”:“placeholder backstory”,“cid”:“1”,“lastname”:“Vader”,“phone”:“3422043605”,“gender”:0,“account”:“US00QBCore0000000000”}