The XenForo codebase uses PHP for the backend processing, as well as HTML, CSS, JavaScript (with jQuery) and a custom XenForo template syntax (based on custom HTML-style tags) for the front end templates.
SQL (MySQL flavour) is used for database queries.