[SMALL PROJECT] - Looking for a skilled php /MySql program.
Posted: Mon Sep 11, 2006 2:38 pm
Dear,
So I am looking for somebody or a group of people that are interested in doing this small project, I can pay with paypal ...
I would like to set-up a large user/registration database (php5 / MySql / Apache / godaddy hosting) with some additional features for a new site with an emphasis on: performance, security, database capacity, login process.
We are talking about:
Multi-Language
Normal registration process (challenge/response ... or other ...) (username, password, first-last name, some other fields)
If needed I can use SSL with my hosting account.
Password should be sha hashed
Email address should be encrypted and stored in database!
I lost my password etc... function should be available.
3 levels of validation before you get registered as a user (1: just fill out the registration form, 2:click on link in email 3: confirmation by 2 friends that also register in the database)
Google Maps linked to each user profile (a world map with all registered users on it ....)
Poll module should be developed as well (you can also use advancedpoll ... )
Module where people can send a message to each other.
User profile can be made public, field by field but not the email address. Search on some fields on the website should be possible.
TAG cloud page should be available, tag's on country, some profile words, poll's ... (maybe FreeTag is an option here)
Chat & forum should be added, any opensource would be fine like (smf ...)
Some considerations I have ...
Should the 3 stages (of users) be handled in 3 separate databases, or tables ... after each stage move them to other database or table in same database?
How do you prevent being hacked so they can read the database?
How do you securely store an email address in a database, what if the database get compromised ... can we for example use every day a new encryption key etc ... so that only few users are encrypted with same key (store key's per day off site ... ?)
Should sessions be stored in multiple databases - will this decrease the performance ?
Is it wise to use remember me cookie?
Concerning performance/capacity
Let say you have about 1 user registering every second, do you use multiple databases or multiple tables?
Admin
Small admin section would be nice, like add/delete/approve/inactive/registrations/new poll etc ...
Please do not comment me on the 1 user a second, it's just that I want to present you with a target, if this target will be reached is not the issue right know.
A lot of login/registration scripts are just around for grabs but few/none have what I am looking for...
Thanks for any feedback on this!
I you are interested I can mail/pm you already my database design I have.
(Table: access, Table: users, Table: user validation, Table: user stats, Table: user2friends, Table: user geo, Table: user account, Table: Campain header, Table: Campain detail, Table Country, Table: Postal Code, Table: State)
[ADDED on 16/09/2006]
The budget is 1.500 Euro - Please let me know what part you can do for this amount! (for example: Login/Registration - User profile - Google Maps - but not multi language ... no chat/send message)
The timeframe is 30 to 40 day's - project should be finished by the end of October 2006.
The layout is not a job of a programmer php/mysql - and so will be done by a webdesigner.
So I am looking for somebody or a group of people that are interested in doing this small project, I can pay with paypal ...
I would like to set-up a large user/registration database (php5 / MySql / Apache / godaddy hosting) with some additional features for a new site with an emphasis on: performance, security, database capacity, login process.
We are talking about:
Multi-Language
Normal registration process (challenge/response ... or other ...) (username, password, first-last name, some other fields)
If needed I can use SSL with my hosting account.
Password should be sha hashed
Email address should be encrypted and stored in database!
I lost my password etc... function should be available.
3 levels of validation before you get registered as a user (1: just fill out the registration form, 2:click on link in email 3: confirmation by 2 friends that also register in the database)
Google Maps linked to each user profile (a world map with all registered users on it ....)
Poll module should be developed as well (you can also use advancedpoll ... )
Module where people can send a message to each other.
User profile can be made public, field by field but not the email address. Search on some fields on the website should be possible.
TAG cloud page should be available, tag's on country, some profile words, poll's ... (maybe FreeTag is an option here)
Chat & forum should be added, any opensource would be fine like (smf ...)
Some considerations I have ...
Should the 3 stages (of users) be handled in 3 separate databases, or tables ... after each stage move them to other database or table in same database?
How do you prevent being hacked so they can read the database?
How do you securely store an email address in a database, what if the database get compromised ... can we for example use every day a new encryption key etc ... so that only few users are encrypted with same key (store key's per day off site ... ?)
Should sessions be stored in multiple databases - will this decrease the performance ?
Is it wise to use remember me cookie?
Concerning performance/capacity
Let say you have about 1 user registering every second, do you use multiple databases or multiple tables?
Admin
Small admin section would be nice, like add/delete/approve/inactive/registrations/new poll etc ...
Please do not comment me on the 1 user a second, it's just that I want to present you with a target, if this target will be reached is not the issue right know.
A lot of login/registration scripts are just around for grabs but few/none have what I am looking for...
Thanks for any feedback on this!
I you are interested I can mail/pm you already my database design I have.
(Table: access, Table: users, Table: user validation, Table: user stats, Table: user2friends, Table: user geo, Table: user account, Table: Campain header, Table: Campain detail, Table Country, Table: Postal Code, Table: State)
[ADDED on 16/09/2006]
The budget is 1.500 Euro - Please let me know what part you can do for this amount! (for example: Login/Registration - User profile - Google Maps - but not multi language ... no chat/send message)
The timeframe is 30 to 40 day's - project should be finished by the end of October 2006.
The layout is not a job of a programmer php/mysql - and so will be done by a webdesigner.