Freelance Project

Hi everyone, I have integrated my SocialEngine network with my existing Invision Power Board forum software, so all users share a single signon/user account. I have several basic php mod requests that I need fulfilled. There are 3 below, however there may be more in the future. Each shouldn’t take much time at all, I wouldn’t mind doing it myself but I’m a bit rusty. Please note that I will not be able to provide Admin access, so I can provide you with the necessary data needed to create the sql queries, then I will follow the instructions provided. Please feel free to bid on all as 1 project, or particular requests. Also, please provide reasonable bids.

———————————————————————

#1 – JOIN DATE

I need to run a database query to copy an existing database value into a different database/table…

I have integrated my InvisionPowerBoard and SocialEngine installation (both are in same database). Currently, all of my InvisionPowerBoard users already have the Join Date within their IPB profiles…I need to copy those dates to the Signup Date field within SocialEngine, so their new socialengine profiles have their true signup dates reflected. Here are the known database tables/rows that I believe are needed for this mod:

Forum:
table name: ftmembers
row name: joined

SocialEngine:
table name: se_users
row name: user_signupdate

———————————————————————

#2 – Post Count

In the Invision forums, each user has a Post Count, the total number of posts they have contributed to the forums. Within each member’s socialengine profile, I need to pull the post count from the Invision data, so it shows below their socialengine profile within the “Stats” box. This should be a simply copy function to copy the values of 1 table into the other, and then a way to call this data from within each member’s profile.

———————————————————————

# 3 – Forum Posts

I have an integration of SocialEngine and Invision Power Board. I would like activities from the Invision forums to be added to the “Whats New” feed in socialengine. This shouldn’t be a major mod request. Please provide a quote. Thanks.