ok, so whenever i apply a texture to a mesh it looks terrible in view-port mode but whenever i start playing the game it looks completely fine. for eg:
if you're wondering i have already used the UV scale.
HERE IS THE TEXTURE:
HERE IS THE TEXTURE WHEN APPLIED: