Category: MYSQL Projects

Message Platform
Message Collection and Distribution Platform

The application I need is simple: there are many apps that distribute messages of some kind. Think about email, Twitter, Facebook, RSS, search results, blog posts etc. – they are all different. We will call these ‘Channels’. I need a platform where messages of a wide range of apps can be collected in a MySQL database. From the database we need to provide a ‘Stream’ of messages in Real-Time that can be filtered in different ways and be seen by multiple people. Responses to the messages should be sent through the same or different channels.

I just need the core of the platform, with a well-documented API so any developer can create a plug-in to add a new channel for sending or receiving.

Some required functionalities:
• There needs to be three levels of users: Super-Admins for Admins and their Users, and Admins for their Users.
• You may use any technology, but it needs to run on Apache with MySQL as a hosted app
• Admins/Users should be able to configure channels in two ways:
o As a kind of search where only messages that contain certain (configurable) keywords are actively fetched (like ‘at’ mentions in Twitter).
o All the messages from a channel like your email or everything that is written on your Facebook wall. (passive).
• The stream should flow continuously and duplicates should be omitted.
• To deal with the stream of incoming messages the user should be able to configure a filter in the incoming channel that determines – based on a predefined condition – to what user or group of users the message should go. (Provide a UI as well as an API for this functionality)
• It should be possible to send messages from the platform to any channel.
• When there are non-text elements in the message, they should be stored on the server and referenced with a URL in the message.
• We need a central password/userid management tool, where a (Super) Admin can maintain all userid’s and passwords. We also need individual Users to be able to create/maintain their own userid/password list. (a UI should be part of the platform, but it should also be possible to do this through an API)
• Provide a dashboard, where you can access the different configuration UI’s, the API documentation and some gauges for the number of messages in and out, as well as a view on the stream of messages at a user-definable speed. Users should only see their own stream, a (Super) admin should be able to see all or just one User/Admin.

Please provide me with a detailed quote as well as a timeline for the app. We are under a tight planning schedule, so deadlines need to be kept strictly.

Note: I may well be possible that a platform like this already exists. I will pay $50 to the first person to point me to a platform like this, provided it is Open Source or Free.

Coldfusion Website Fixes 3
I need a coldfusion developer to do work on an existing mysql database website programmed with fusebox 5 technology. I need several enhancements to the site and several fixes made to existing code, I need the accepted developer to thoroughly test each fix and enhancement prior to code updating. The approved developer will receive ftp and login credentials. All code on developers server and or desktop must be destroyed upon final acceptance of the deliveries. Please see the word document for specific instructions. All code must be commented and organized in an efficient manner.

Extract Database From Website3
I need the database extracted from a website and put into an excel spreadsheet. I will attach a text file with the name of the website.

When you click on “Public Information” you will find a way to find a doctor. I need that database extracted. Only United States entries are necessary.

I need First Name, Last Name, City, State, ZIP/Postal Code, Business Phone, Credentials, Specialties, Website.

If specialties are too difficult because of the length of entries, then that could be skipped.

Quick Asp Debug
http://tommcgphotohosting.com/ariz/featured_new.asp

Attempting to write to the mysql column “linkid”, front end shows no errors when adding new items, but “linkid” column never fills into database.

Changing Database Origination
Hello programmers,

We are looking for very dependable, professional and able programmers to make a change for our database.

Our website is wwwlivrotekcom and it is a copy of wwwcheggcom

We’d hired a programmer to build the website and the website was completed with all functionalities. Right now, our books search database is coming from wwwamazon.ca

We do not want that anymore. We want to create our own database where we can add our own books and books descrition and books pictures, etc…

If you think that you are up to the task without damaging the current codes wich are already working fine, then bid on this project.

The whole website is currently hosted by hostgator, not godaddy. You must have experience building such a website before considering bidding on the project.

Good luck to everyone
Philipp

Cre Loaded Module Install
Looking for a programmer who ius familiar with CRE Loaded (this is different than OSC)

I would like this module installed http://addons.oscommerce.com/info/7237

If you do not have experience with CRE Loaded, Please do not bid.

Automatic bids and messages will be ignored

Layout And Copy Data Schema
I have a dedicated server with multiple MySQL and PostreSQL databases. Four of these databases are large and these are the three this project is for. Over the last couple of years I have had numerious database administrators and programmers optimizing the structure of these databases. As a result I have no documentation showing the table layout structure or anything related to the data schema. You may be able to pull this from phpmyadmin and do the backups from WHM – cPanel. I have no idea but if you reading this I assume you would know.

I would like to know the exact database layout structure (schema) of the following:

http://www.salesdatainc.com/list.php?page=members&action=consumers

http://www.salesdatainc.com/list.php?page=members&action=buy

http://www.salesdatainc.com/list.php?page=members&action=consumers_new

http://anybirthday.info/xuid

I would like to have the database and structure saved to an external drive that is connected to the server. This is to assure I have a copy of the database and structure as I will be moving it to another server in the near future.

Drupal Services Script
We’re creating a Drupal backend to manage data for a third-party RPG game framework. We know a little PHP/MySQL, but need help implementing the Services (http://drupal.org/project/services) module for our use.

A little explanation about our setup: Our system allows people to create their own RPG games, complete with settings (like leveling speed, etc.), races, classes, etc. Data like game settings, character sheets, etc. is stored in the Drupal site, and our third-party software will fetch and update data via HTTP.

We know a bit of PHP, but we’re relatively new to Drupal. What we need is a script that can use the Services framework to accomplish the following tasks:

1. Connect to Drupal
2. Create nodes with pre-defined fields
3. Find user ids by username
4. Locate nodes based on certain search criteria
5. Fetch the values of a particular node using the node id

Please note that our content types use CCK fields.

We will then include these core functions in our own script in order to intercept HTTP calls and update/return the appropriate data for our software.

Attached is a full specification document that defines each custom function we need.

Convert Script To Run In Mysql
I have a small script running in just plain text mode and would like to have it run in MYSQL. The script is attached.

Keyword Analyzer
Requirements:

Allow the user to enter a keyword in a UI
The system search all website to find ANY information on the keyword.
Must be able to search blog, social website, forums, newswire etc.
Then return a hyberlink to any site that contains the keyword
Take a screenshot of the website
Must allow to wildcard searching

All the information must be stored into a mysql database.

Specail consideration will be given to the developer who can demostrate or provide a POC of the bot/service that I need.

The Keyword Analyzer program must be design as components that can be called as a webservice or a bot.

Clone Wp News Site / Template
1. I need an existing WP site cloned to a new domain on a new server.

2. I need a new “skin/template” like the sample I provide.

3. I need part of the existing MySQL dbase parsed for specific keywords and the rest of the dbase to be discarded.

Desktop Messenger 4 Php Site
=-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-=
Bonjour,
Feature list of Desktop Messenger for www.aconie.com done by PHP:

It will install on desktop to chat online with other member of our site only.

1) Remember me, save password, Auto Sign in -> for LOGIN.
2) Status type: Online, Busy, Away, On the phone, Out to lunch, Be right back, Invisible to all.
3) Click on settings -> Open popup window. It contain General & Individual Settings.
a) Individual -> Language option (Chinese simplified, etc)
b) General-> Updates (Automatically Updates or manually Updates, version->latest beta, latest release).
4) News TAB -> It contains latest news & when click on that then it go to community-> Industry forum.
5) Today’s news TAB„³ If u r buyer then information about latest buying leads & If u r seller then information about latest selling leads.
8) Messages TAB -> It contain inbox message of our site.
9) Menu: My details ->
I) Edit: PROFILE
II) View details (Name, Member Id, Name, Co. Name, product/service, Yr joined, telephone, add)
III) Click on image (Name, telephone, Mobile #, email (click on email outlook express is open))
IV) ShowCase -> MEANS DISPLAY PRODUCTS (which will fetch from our database from members own gallery) or someone instantly want to show one or more product online while chatting with others.
10) Change Details: about me (Name, gender, country, province, city, dist, birth, blood type, occupation, education, hobby, intere, intro) personal, work, privacy (all, cont only, hide))
11) My status (Online, Busy, Away, On the phone, Out to lunch, Be right back, Invisible to all)
12) Send message: Receiver¡¥s member ID
13) Message history (All messages, offline message and system message)
14) Display option (New today)
15) Preference ()
16) Mobile settings (send SMS, group SMS)+
17) Video
18) Audio
19) Send file.
20) Single Login.(means if anyone login in site he should logged in the massenger & vice versa)
21) Share file.
22) No guests are allowed.
23) No group chat or room chat concept.

**All are done by using our database.

www.aconie.com

My Store
i want a way to extract data from paypal ipn emails and send it to my customer database.

and then also

to have a form which i can use to look up a order to get a customers email from that order and name and add it to mysql then send the customer a tracking number in the correct format (without having to type it)
Thank you for your order

It has now been dispatched
Track at
http://www.royalmail.com/portal/rm/track?trackNumber=EE0000000000EE

Best Regards

Sales Team

like i just want to type EE0000000000EE

B2b Site: Buy/sell/bizop Posts
PROJECT DESCRIPTION:

I need my site to have three pages — very basic, + RSS/XML feeds. No images, no graphics required.
All the functionality must be made available to my users just like the
below examples. I require a mysql database back-end.

ADMINISTRATOR AREA must include approval, deletion, and edit access to all
– buy posts
– sell posts
– opportunity posts
ADMINISTRATOR AREA must include password, as well as changeable (resetable) password for
the admin.

—————————–

PROJECT DURATION FOR PROGRAMMER:

One (1) week (7 Days.)

—————————–

MYSQL DATABASE REQUIREMENTS:

All dynamic pages ( A, B, C, D, E and F) must use the same, I repeat,
the same password to access the database. Multiple databases/tables
may be used. ONLY ONE (the same) password. Note: I only want to have
to remember ONE password.

Must be able to handle..

>500,000 Purchase posts
>500,000 Sale Offer posts
>500,000 Business posts

—————————–

FONT INFORMATION:

Background = light grey
Links = Blue
Text = Black
Offer Titles = Bold

—————————–

REQUIREMENT A) Purchase Request

http://www.europages.co.uk/buying-and-selling.html
The go to > Post a request

NOTE #1: ASSUME the visitor is *already* a member. Just program the site so the code
pushes the data stright to the mysql database.

NOTE #2: Require the users to enter a UNIQUE string to prevent spam.

I need a similar page [purchase request page] The URL must be randomized so that only myself (web admin) knows
the URL. A secure URL for the purchase request page is required because I will display
the page in a content PANE on another website. I repeat, the page must be designed
so only I know how to display it. I do not want any registration requirements. I want
a the page designed so that the page posts data, but to load the page only I know the web
address.

—————————–

REQUIREMENT B) Sell Offer

http://www.europages.co.uk/buying-and-selling.html
The go to > Post an offer

I need a similar page [sell offer page] The URL must be randomized so that only myself (web admin) knows
the URL. A secure URL for the purchase request page is required because I will display
the page in a content PANE on another website. I repeat, the page must be designed
so only I know how to display it. I do not want any registration requirements. I want
a the page designed so that the page posts data, but to load the page only I know the web
address.

NOTE #1: ASSUME the visitor is *already* a member. Just program the site so the code
pushes the data stright to the mysql database.

NOTE #2: Require the users to enter a UNIQUE string to prevent spam.

—————————–

REQUIREMENT C) Business Opportunties

http://www.europages.co.uk/buying-and-selling.html
The go to > Post a request

I need a similar page [Business Opportunities page] The URL must be randomized so that only myself (web admin) knows
the URL. A secure URL for the purchase request page is required because I will display
the page in a content PANE on another website. I repeat, the page must be designed
so only I know how to display it. I do not want any registration requirements. I want
a the page designed so that the page posts data, but to load the page only I know the web
address.

NOTE #1: ASSUME the visitor is *already* a member. Just program the site so the code
pushes the data stright to the mysql database.

NOTE #2: Require the users to enter a UNIQUE string to prevent spam.

—————————–

REQUIREMENT D) Business Opportunties Summary Purchase & Sell Offers

http://www.europages.co.uk/buying-and-selling.html

I need a similar page [ summary of buys & sells]. Next to the country named, I need
the country’s flag displayed.

—————————–

REQUIREMENT E)

Also, I need an XML RSS feed for each of the following #1, #2, #3.
Make sure the Feed can be read by all the top FEED READERS: Feedburning.com (expecially)
1) Last 20 Purchase Requests, including Title of request, and country of poster.
2) Last 20 Sell Offers, including Title, Title of offer and country of poster.
3) Last 20 Business requests, including Title of Business Opportunity, and country of poster.

—————————–
REQUIREMENT F)

I need one page very small text, to show THREE columns.

Column 1) Purchase Requests
Column 2) Sell Offers
Column 3) Business Requests

Each column must show
a) first 15 characters of Title
b) Flag of posting country
c) Country name.

Mysql Programmer
Need a script to read in a text file of fields, compare to a mySQL database and return a list of records to be deleted.