Category: MYSQL Projects

My Sql App Password Change
I would like a MySQL coder to assist me ‘step by step’ true my code to make sure that my old coder doesn’t have access to my SOL application true a master passord. If so change it.
Right now i can change my password any time, but i suspect he has a Master code.
You will not have any access to my SQL database, but we can chat, and i can copy paste any text. So the coder should know what i’m talking about.

Programming Project 1270693248
Hello,

I’m looking for a programmer to spider an online store. The spider would need to gather and store all of the products and product attributes into a MySQL Database. The product images would also need to be gathered and saved to disk and a way to link a product with its corresponding image(s). There are roughly 500,000 products in the online store. All images would need to be saved in their highest resolution with no manipulation done to the images.

The MySQL database should have at least two tables, one storing the product and its core details, and another table to store attributes in key/value pairs.

Once you spider the data you would compress a MySQL database dump file of the product data along with all of the images and send it over. We would need to see a sample of the database before payment is sent over along some statistics of the data, including database rows, size, and image size.

Please add something in your bid description that proves you read the full description of this job listing.

Thanks

PS We can provide a server if needed.

Tecdoc To Mysql Convert
Need to acces information from tecdoc for an webshop.

C# – Design/print Plastic Card
Development of a WYSIWYG software that allow user to design and print both sides of a pvc

(plastic) card, using card printer Fargo Persona c30e and the printer’s SDK.

Software must allow to place shapes, pictures, barcode, labels, background color or image,

read/record magnet stripe (using printer’s sdk).

Main purpose of software is to print a sequence of cards from a database (Access, Mysql, Oracle,

Sqlserver, Postgresql), or from csv file.
So the software must allow dynamic fields:
– dynamic Label, dynamic barcode and dynamic magnet stripe can be loaded from both CSV or

Database
– dynamic picture can be loaded from both a database or a directory of numbered image files.

Requirements:

– Development in C# using Windows Forms
– Provide source-code
– Ribbon UI, using DevXpress Xtrabars component
– Use Bytescout Barcode component
– Use Printer SDK (which I’ll provide)
– Provide a easy way for translating all the software messages, options and controls (the

software will be used in my own language so I’ll have to translate everything).

Detailed tasks that the software must accomplish or allow:

– have a control where the user designs the card, which means the user can add elements to this

control (pictures, labels, shapes, background color, magnet stripe, barcode…)
– The “Card control” mentioned above must look like a card: a white rectangle with black borders

and rounded corners
– design and print only front side, or only back side or both sides of the card
– change card orientation: Portrait or Landscape
– select card size/model: CR-79, CR-80, Custom size (in milimeters)
– Card control must allow user to add following elements:
-> pictures
-> dynamic pictures: which will be loaded from a database and/or a directory with numbered image

file names
-> labels
-> dynamic labels: which will be loaded from a database and/or csv file
-> barcodes
-> dynamic barcodes
-> magnet stripe (only in card back)
-> dynamic magnet stripe (only in card back)
-> rectangle shapes
-> circle shapes
-> ellipse shapes
-> square shapes
-> line shapes
-> card background (which may be a color or an image)
– dynamic fields must be able to be loaded from different columns of different tables. Must support: Access, Mysql, Oracle, SQLServer, PostgreSQL.
– database settings can be saved for each database so the user doesn’t have to type it everytime.
– change shape’s border color
– change shape’s fill color
– change transparency level for shape elements
– fill color can be set to transparent so you see what’s bellow the shape in the card
– easily resize elements (except the magnet stripe)
– easily move elements (except for magnet stripe)
– easily rotate elements (except for the magnet stripe)
– Horizontal and Vertical Rulers with mouse tracking, divided in centimeters (showing milimeters

small marks).
– copy & paste elements from/to both sides of card
– Undo/Redo (50 times) separatelly for both sides of the card
– send an element to back or bring it to front of other elements
– send an element from back side of card to it’s front and vice-versa.
– keep a beautiful visible list of every element placed in the card, where itens can be managed

as well (example: Barcode1: “918209”, Dynamic Barcode1, Text1: “hello”, Text2: “test string”,

Dynamic Picture1…)
– zoom card (in and out)
– show grid for helping user to design the card
– option for snap elements to grid
– show mouse position in statusbar (in centimeters)
– Menu options: new, open, save, configure printer, Print preview, Print, Print All (print all

cards of a dynamic sequence).
– “Configure printer” option must show a printer selection dialog which has the printer names

list, a configure button (which opens the windows default properties dialog for the selected

printer) and the number of copies.
– “Print” option can use the exact same window of “Configure Printer”, but it may have a “Print”

button instead of the “OK” button.
– Both “Configure printer” and “Print” options must allow to show only printers with specific

name (I’ll give you the list of names).
– check if printer has magnetic encoder installed before print a card that has magnetic stripe

element placed in it.
– Simple access control system with 2 levels: administrator and operator. Administrator can do everything. Operator can ONLY print a previous saved design.
– log every action (with datetime). Only administrator can see/clean logs.

Problems you may face and things you should avoid:

– avoid aliasing
– avoid flickering while moving elements
– if you place your elements in a rectangle make sure the rectangle is totally transparent.
– ruler’s mouse tracking may intercept windows mouse moving messages and take a lot of processing which will generate flickering (even if you use double buffering) or screw up ribbon interface
– using windows default printer properties dialog isn’t trivial for c#, so you may use win32 api for that, but it may cause problems for you to open the dialog (memory protection fault) or for you to save it’s settings

If you need any further detail or help let me know.

Convert Mysql Data To To Flash
Hi,

I have the following:
– mysql db
– fields to be used are ID, up to 13 text fields and up to 13 photos per record

I need to have data from fields generated into a flash file (FLV) that i can use to upload to youtube.

The automated FLV file should include transitions of the photos and text so it looks like an online family photo album. There will be six songs supplied, the script should select one of the songs at random when generating the flash file.

The video should always start with the same intro slide, then content from db, then a final slide that users can click on to direct them to our website.

If you have worked on a similar project please provide me with the url so i can view your portfolio.

txs.

Perl Fuzzy Addrss Matching-gis
Perl
MySQL
GIS

—-

we have geographical data (streets, addresses, etc in a geo database)

we want to employ similar fuzzy address matching rules as typical geolocators – like yahoo/google

-address ranging
-corners
-city or zip code search
-free form entry

12372 topsfield ct 63141
mason and ladue, creve coeur, mo
Bellington Lane, st louis, mo

etc…

Returns latitude and longitude from my geodatabase and multiple match selection if relevant

PHASE I: Initial testing
(pay 33%)
PHASE II: Feedback from client on fixes and test search results
PHASE III: project completion – Final Payment.

Must have Skype for chat only (no voice)
Must speak ONE E. European language (Russian preferable)
payment by SL
Escrow 33% as usual

PMB your skype address

Openfire (java) Plug-in Mod
My company is using Openfire 3.6.4 as an internal server to manage our XMPP/Jabber communications. We have it set so
that all messages are archived in a database presently, but need to adjust the archiving so that all conversations
are exported to an email address vs. just being stored in the database.

Openfire is open sourced and there is an existing plug-in published that does a majority of the work that is needed.

What we are looking for is someone who is comfortable with the level of java used to build this project that can take a little time to develop the plug-in we need. Delivery of the finished product will be as a plug-in that can be installed to our build.

Please read the description below. If you are interested in taking on this project, please respond with a proposal for how long it will take and compensation desired.

—————————————–

Purpose:

Provide the ability to export archived conversations from an Openfire XMPP Server (www.igniterealtime.com) as
individual SMTP email messages.

Environment:

1 – OpenFire Server 3.6.4
2 – Monitoring Service Plug-in 1.1
3 – Java
4 – MySql

Proposed Method :

OpenFire is a fully functional Jabber/XMPP server and it keeps records of all conversations in a MySql database.

The Monitoring Service plug-in provides a framework for the majority of the work that needs to be done.

Under the Archiving tab that allows you to search the database for conversations, there is a facility that assembles
the individual chats from the MySql database and formats them in a structured way. Upon checking on an individual
conversation, there is a function that will allow you to view the content of a chat as a pdf.

Taking advantage of this existing plug-in we want to modify it so that in place of exporting individual messages to a
pdf, we instead email them to a pre-defined email address, as well as being to trigger this action in bulk for a range
of messages.

We will also need to add a new table that will keep track of whether a message has been exported to email or not. This
table will employ the PK of conversationID as a reference and track date of last export and email address exported to.

The plug-in will need to have two operational modes:

1 – manual

Employ the search feature of the Monitoring Service plug-in and allow for the results to either be emailed one by one
upon clicking them (export to mail will replace ‘view as pdf’), or the entire found set can be emailed.

Upon a batch email out, each unique conversationID will be matched to an individual email.

2 – scheduled

The plug-in needs to have the ability to be triggered daily at a specified time to export all un-flagged conversations
that have been generated.

Finally the plug-in needs to be written as a self contained module and in to the framework of an openfire plug-in. Any
database adjustments need to be kept separate from the overall schema (i.e. …. adding tables preferred over adding
fields to existing tables)

Mysql Expert Needed Database
I have a database that gathers checked out orders from a website that needs to be completed it is 90% done , it does recognize checked out order compared to previewed orders , it has multi admin levels , its for a essay writing company, basically how it works it the writers log in and get their own log in and password , then they simply grab the checked out orders that come in once done writing the essays then they simply pload it to the database where the proofers can come in and proof the essays out. Also there is a writing manager admin and a regional manager , and just Admin , and a proofing manager admin , all have dif access , all this is all ready done in the database . Right now i have a guy working on it but he needs little more help. All this is all ready done in the database but we are just basically making the database more user friendly. I paid a guy asll ready to get it to this point but now i need another to wrap it up and help this guy whos working on finish it up. Ill pay you min 200.00 to wrap up the database . Larry the guy who is working on it now is basically cleaning up the code to make it easier for the next person to do the database and try to get my user frinedly fixes done to it but is taking to long. I have 4 sites that need to be connected to the database. The database need to be in each site so the sites dont link out to another site for SEO purposes i dont want any of my 4 sites linking out to any sites.

Pligg Mysql And Errors
Hi, my site was working perfectly when i decided to buy a new pligg template with new modules, then my hosting sent me an email saying:

“The script you ran to clear a cache table in your database has caused a massive overload on the server initiating huge number of MySQL queries:

| 7545598 | choowawa_new | localhost | choowawa_new | 600 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545660 | choowawa_new | localhost | choowawa_new | 596 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545681 | choowawa_new | localhost | choowawa_new | 594 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545730 | choowawa_new | localhost | choowawa_new | 591 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545739 | choowawa_new | localhost | choowawa_new | 590 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545774 | choowawa_new | localhost | choowawa_new | 587 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545777 | choowawa_new | localhost | choowawa_new 587 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |
| 7545784 | choowawa_new | localhost | choowawa_new | 585 | removing tmp table | INSERT INTO pligg_tag_cache select tag_words, count(*) as count FROM pligg_tags, pligg_links WHERE t |

These are part of the queries.

You should contact an expert local web developer before you execute the same action. The load caused from your account was over 120 and on 4 QUAD core CPUs and 12GB or ram machine this means that there should be a malfunctioned script on your website. Please request from your developer to download your website scripts and create dump of your database and to optimize it.”

Now with this, I decided to just ask my hosting to reupload my old files, which meant losing some (not all) of the current database, members etc…

What I want the programmer/developer to accomplish is to bring back the lost member registrations and news using the most current backup file that i have. Is this possible?

Product Design Customization
Allow an end user to select Product ID (13 products), select defined color ID number or select custom color from default window color chart, select special service, select amount of screen/color, select sizes (if applicable), select artwork from album gallery or upload multiple artworks, a special instruction text field, quantity, calculate estimated total cost, special service charge, enter in coupon code, and waive certain fee.

The user must register for an account with email as the username and a defined password (where they enter contact name, company name, phone, email, billing name, and shipping name) and label their design with a name (A-Z or 0-9 only). The user has the ability to retrieve lost password using their email address.

There will be a special text field for customers with existing account in another system. Text field will be labeled as “Customer ID:” and another text field label “Representative in charge:” The Representative in charge field is a small database to be retrieved from MySQL or MSSQL

After creation of account, the user may submit the design and other information to the administrator for confirmation.

The design information is saved in the database and a copy is emailed to the administrator. The user will receive an e-mail with the assigned “Order confirmation number”, Reference_* file (output of customer database info), link to access the customer portal account, and will be redirected to a completion page.

The system will link to a UPS rate tool to determine the actual shipping cost with the determined total product weight.

The administrator has a backend system (MySQL or MSSQL) that receives the order (complete customer inputted information) and generate a confirmation number for the saved design. The saved design will be saved to the root path / folder of the hosting computer sorted by the generated order confirmation number in the format (<Confirmation Number>_<Product ID>_<Design Name>) Example: folder: E12032_Product1_GatorNumberOne)

Two files will be generated called Reference_<Confirm Num>_<Design Name>.html and Order_<Confirm Numb>_<Design Name> with up specific text output from the customer order information.

The submit design will send an email to the administrator notifying the order complete detail (attach Reference_ * and Order_* File with the generated order confirmation number and the attachment of the specific uploaded, artwork and/or doodle design).

The administrator has the ability to login the web interface to change saved design quantity, update pricing, or change feature, and change or update user account settings,

Upon completion of order review and final design mockup, the administrator will go to the web interface (make necessary changes to the order, pricing, quantity, or feature, or waiver), upload the new proof design artwork (up to 2 files or .zip file) and click “Submit”.

Upon Submit, the system will create a new Reference_* file and Order_* file (if any new changes were made) then send an e-mail to the User relating to the order a confirmation e-mail.

The user will receive an email with the link back to the design site; enter in the confirmation number to complete the order with the following payment option:
1) API Credit Gateway (Paypal)
2) Paypal
3) Check or Other option.

And after payment the order will be marked as Paid in the database system. If payment is Check or other, mark in system as “Pending”, else mark all order as “None”

The administrator will receive a confirmation email with Notice of Payment marked as either PayPal, API – Payment as an Alternative Method, Check, or other.

Specific Details
1) Administrator Web Interface to add/update/remove product, colors, special feature, and unit cost calculations, update order status such as tracking number, and change payment status.
2) A customer portal to allow customer to register, enter contact, billing and shipping information, save their order, view status of the order, and perform reorder of past orders.
2.1) Option for Re-ordering the same design with ability to modify quantity, or re-loading design and modifying previously placed order using previous Order Confirmation number.
3) Clipart color can be changed using a predetermined PMS color chart. (I provide)
4) Clipart is to be categorized (based on file directory)
5) Uploaded artwork by the end user forces the user to enter the color description or color ID from color chart into the Special instruction text field.
6) All artwork must be cropped at the edge of the product.
7) A text editor to add custom text.
8) All items in the design interface can be resized, rotated, and layered.
9) All artwork including uploaded artwork can become transparent (remove white).
10) When a customer chooses a personalization option, an additional upload field will appear to allow the customer to upload additional document like Excel spreadsheet, word. These files will also be sent to the Administrator and saved in the root directory.

Recruitment Website Clone 2
PRIOR EXPERIENCE WITH THIS CONTENT PROJECT IS PREFERRED. NEED “CLONE” (OPERTAIONAL AND AESTHETIC COMPONENTS) OF THE MANAGEMENT CONSULTING WEBSITE (WWW.ACCENTURE.COM),WE WILL SUPPLY OUR OWN ORIGINAL TEXT, AS NEEDED.
OTHER WEBSITE COMPONENTS:

(i) E-commerce:
Secure, on-line global payment system;

(ii) Secure Log-in:
Candidate Log-in
Client Log-in

(iii) Back end Administration:
Log-in database for Job Search Listings, Jobs, Candidates, Clients and for website traffic information and details;

(iv) Website Marketing-Website Search Engine marketing optimization:

Submit the completed website to over 100 search engines, directories and links pages and over 100 keyword searches. Improve site for better search engine rankings. Including following features:

-Statistics to analyze the efficiency of site traffic
-Full disclosure (first page uniques, join page submits, $/click) allows for comparison of different marketing campaigns
-Display the graphical charts of your first or second page clicks, sales by payment type etc.
-Exported stats via standardized CSV/Excel file for further analysis & record keeping
-All settings in the statistical reports can be saved. Come back next time and run the same analysis with just one click
-Display referring URL’s for all your sales
-Flexible and powerful campaign system to differentiate between different marketing campaigns or traffic sources
-Improved, in-depth payout history to track receipt of your payouts.

Database Relational Schemas
Effort is in two parts. (see attach problem 1)

For part 1 (see attach problem 1): for each figure listed (Fig 3-8, 3-9b, and 3-16b) complete the following below by 8:00 P.M. EST, Sunday, 4 April.

a.-Transform the diagram to a relational schema that shows referential integrity constraings.

b.-For each relation created in step 1 (above), diagram the functional dependencies

c.-If any of the relations are not in the 3rd normative form (3NF), transform those relations to the 3NF.

——————————————————————–
For part 2 (see attach problem 7): For Fig 5-5 (see attach Fig 5_5):

a.- Draw a relational schema and diagram the functional dependencies in the relation.

b.- Answer: In what normal form is this relation?

c. Decompose MANIFEST (Fig 5-5) into a set of 3 Normal Form (3NF) relations and show referential integrity constraints.

All documents must be submitted in MS Word format following standard entity-relationship naming conventions (example: Flight_Identity)and numbered/lettered as above.
See attached documents for reference diagrams.

Coldfusion Website Fixes
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.

Install Fatfree Crm On Server
Hello,

We are looking for someone to install FatFree CRM on our web server. FatFree is open-source CRM developed using Ruby On Rails.

More information on FatFree CRM can be found here:

http://fatfreecrm.com/
http://github.com/michaeldv/fat_free_crm

We are looking for a company to simply install this web application on our server as we are not familiar with Rails. We would also like you to import our current CRM database (will be supplied as CSV) into FatFree.

No customization to FatFree will be necessary at this stage. We are simply looking for you to get us up and running.

Thanks!

Forum Email Extraction Program
I need a program that will extract ALL member and guest email addresses in forums. Please see video that is attached.