Last Active Listing to show on User Profile

We need following changes/enhancements on our View User Profile page. Tables to be used are as follows. • users • listings (user_sid – foreign key from users table) Files to be changed: - \apps\frontEnd\templates\zaahib_base\users\[login to view URL] - \apps\frontEnd\templates\base\users\[login to view URL] - \apps\frontEnd\scripts\users\[login to view URL] - \system\lib\classifieds\Listing\[login to view URL] (Add function getLastActiveListingByUserSID, for reference see getActiveListingsByUserSID) - \system\lib\classifieds\Listing\[login to view URL] (Add function getLastActiveListingSIDByUserSID, for reference see getActiveListingsSIDByUserSID)