Get a Freelance Job

I have an email scrapper that I need someone to null. I have not purchased/obtained a copy of the software but I’ll be glad to do so if it is required.

I will send you a link to the file upon reply.

My intention is to have the program nulled so that I can run it on all of my computers without issue.

All callbacks must be removed. If the .hosts file needs to be altered, that is OK.

Hi I need this ASAP…

I have a video script (PHP) for a video sharing site.

Similar to : http://bit.ly/sQB2XO

I would like my script to be nulled so i can use it on many domain.

I will include the script in attachment.

Please let me know if you can do it.

Hi,

This project will go quick. I’ll pick winner in next 30-60 minutes.

Bassicly I have an mysql table –

CREATE TABLE IF NOT EXISTS `infraud` (
`username` varchar(500) CHARACTER SET utf8 NOT NULL,
`EmailAddress` varchar(500) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`acccount` varchar(500) CHARACTER SET utf8 NOT NULL,
`type_of` varchar(500) CHARACTER SET utf8 NOT NULL,
`new_type` varchar(500) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`EmailAddress`)
) …

I need the the following form http://sturtcommunity.com/form.php search the code using Ajax auto complete fill all fields from database, exact from search.

conditions:
Get record from database without reloading the page, use only ajax auto fill option.

database driver mysql_connect only

sql:
CREATE TABLE IF NOT EXISTS `executive_master` (
`Code` varchar(250) NOT NULL,
`Name` varchar(250) NOT NULL,
`address` text NOT NULL,
`place` varchar(250) NOT NULL,
`zip` varchar(250) NOT NULL,
`phone` varchar(250) NOT NULL,
`mobile` varchar(250) NOT NULL,
`target` varchar(250) NOT NULL,
`sub_rep` varchar(250) NOT NULL,
`type` varchar(250) NOT NULL,
`designation` varchar(250) NOT NULL,
`report` varchar(250) NOT NULL,
`allow_billing` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I need add,edit, delete using php,mysql,ajax autocomplete

table sql:
CREATE TABLE IF NOT EXISTS `cus_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(250) NOT NULL,
`Custname` varchar(250) NOT NULL,
`address` text NOT NULL,
`place` varchar(250) NOT NULL,
`location` varchar(250) NOT NULL,
`phone` varchar(250) NOT NULL,
`mobile` varchar(250) NOT NULL,
`DLno1` varchar(250) NOT NULL,
`DLno2` varchar(250) NOT NULL,
`zipcode` varchar(250) NOT NULL,
`STno` varchar(250) NOT NULL,
`CST` varchar(250) NOT NULL,
`email` varchar(250) NOT NULL,
`DL.Exp` varchar(250) NOT NULL,
`CSTper` varchar(250) NOT NULL,
`State` varchar(250) NOT NULL,
`Tin` varchar(250) NOT NULL,
`Crlimit` varchar(250) NOT NULL,
`Cr.days` varchar(250) NOT NULL,
`Duebills` varchar(250) NOT NULL,
`Duedays` varchar(250) NOT NULL,
`int` varchar(250) NOT NULL,
`Area` varchar(250) NOT NULL,
`Rep` varchar(250) NOT NULL,
`Cust_cat` varchar(250) NOT NULL,
`bank` varchar(250) NOT NULL,
`Shipping` varchar(250) NOT NULL,
`rep_commision` varchar(250) NOT NULL,
`Rate_increase` varchar(250) NOT NULL,
`Currency` varchar(250) NOT NULL,
`CrDisc` varchar(250) NOT NULL,
`CashDisc` varchar(250) NOT NULL,
`Grade` varchar(250) NOT NULL,
`Allow_billing` varchar(250) NOT NULL,
`Allow_product_disc` varchar(250) NOT NULL,
`Type` varchar(250) NOT NULL,
`Active` varchar(250) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

We will write the plain PHP version of one of our executable PC software. The database is MSSQL. This is a big software, so we will go step by step. In this very first step we need only 3 pages;

1. The login page.
2. The CHECKS control page.

The database structure is below. We need a detailed search/list option (we need to add criteria for at least 14-15 fields)

User will be able to add and edit data.

3. The CASH_PAYMENTS control page

Completely same designed as CHECKS control page, and the db structure is below.

Both tables are linked to another tables but you dont need to edit any other table for this moment.

All the database and hosting information will be delivered to you. The database is ready, you dont need to create or add data to start. The graphical design will be also delivered as JPG files. (graphical design is very very simple, while to functionnality is more important)

While this will be a modular software (some part will be written by ourselves), some more details needed;

1. There will be a “user_info” table and all the table fields order and column widths will be read from there. It means that you will read the columns orders and widths from the database.

2. You need to use some already defined functions for
OpenConn() : Open Connection
CloseConn() : Close Connection
ms_exec(): mssql_query for executing SQL statements.

3. The most important thing is that, in the list panel, you need to read data with ajax.load, so we can cancel the search criteria and update/change it. It means that we will always have 2 divs; one to search, second to list. The edit/update/addnew windows would be popup windows, as usual.

4. The page should run correctly on different PC browsers as IE, Firefox and Chrome.

5. This is the start of the project, so the code need to be clean, and “readable”, because we will add more modules using the same CSS and functions.

CREATE TABLE [dbo].[CHECKS](
[CHECK_ID] [int] NOT NULL,
[BOOK_NO_YEAR] [int] NULL,
[BOOK_NO_MONTH] [int] NULL,
[BOOK_NO_ID] [int] NULL,
[CHECK_TYPE_NO] [int] NULL,
[DATE_OF_GET] [smalldatetime] NULL,
[CUSTOMER_NO] [int] NULL,
[KESIDE] [nvarchar](50) NULL,
[CHECK_NO] [nvarchar](50) NULL,
[BANK] [nvarchar](50) NULL,
[BRANCH] [nvarchar](50) NULL,
[ACCOUNT] [nvarchar](50) NULL,
[DATE_INFO] [smalldatetime] NULL,
[DATE_OF_COLLECT] [smalldatetime] NULL,
[AMOUNT] [float] NULL,
[PRICE_UNIT_NO] [int] NULL,
[MAIN_AMOUNT] [float] NULL,
[SPECIAL_RATE] [float] NULL,
[ENDORSEMENT] [nvarchar](50) NULL,
[CHECK_STATUS_NO] [int] NULL,
[CLEARED] [int] NULL,
[TRANSFERRED_CUSTOMER_NO] [int] NULL,
[TRANSFERRED_LOC] [nvarchar](100) NULL,
[PROTESTED_CHECK] [int] NULL,
[TRANSFERRED_DATE] [smalldatetime] NULL,
[NOTES] [nvarchar](4000) NULL,
[VERGI_NO] [nvarchar](50) NULL

CREATE TABLE [dbo].[CASH_PAYMENTS](
[CASH_PAYMENT_ID] [int] NULL,
[DATE_INFO] [smalldatetime] NULL,
[CUSTOMER_NO] [int] NULL,
[AMOUNT] [float] NULL,
[MAIN_AMOUNT] [float] NULL,
[SPECIAL_RATE] [float] NULL,
[PRICE_UNIT_NO] [int] NULL,
[CLEARED] [int] NULL,
[PROTESTED_CHECK] [int] NULL,
[NOTES] [nvarchar](4000) NULL
) ON [PRIMARY]
GO

We will write the plain PHP version of one of our executable PC software. The database is MSSQL. This is a big software, so we will go step by step. In this very first step we need only 3 pages;

1. The login page.
2. The CHECKS control page.

The database structure is below. We need a detailed search/list option (we need to add criteria for at least 14-15 fields)

User will be able to add and edit data.

3. The CASH_PAYMENTS control page

Completely same designed as CHECKS control page, and the db structure is below.

Both tables are linked to another tables but you dont need to edit any other table for this moment.

All the database and hosting information will be delivered to you. The database is ready, you dont need to create or add data to start. The graphical design will be also delivered as JPG files. (graphical design is very very simple, while to functionnality is more important)

While this will be a modular software (some part will be written by ourselves), some more details needed;

1. There will be a “user_info” table and all the table fields order and column widths will be read from there. It means that you will read the columns orders and widths from the database.

2. You need to use some already defined functions for
OpenConn() : Open Connection
CloseConn() : Close Connection
ms_exec(): mssql_query for executing SQL statements.

3. The most important thing is that, in the list panel, you need to read data with ajax.load, so we can cancel the search criteria and update/change it. It means that we will always have 2 divs; one to search, second to list. The edit/update/addnew windows would be popup windows, as usual.

4. The page should run correctly on different PC browsers as IE, Firefox and Chrome.

5. This is the start of the project, so the code need to be clean, and “readable”, because we will add more modules using the same CSS and functions.

CREATE TABLE [dbo].[CHECKS](
[CHECK_ID] [int] NOT NULL,
[BOOK_NO_YEAR] [int] NULL,
[BOOK_NO_MONTH] [int] NULL,
[BOOK_NO_ID] [int] NULL,
[CHECK_TYPE_NO] [int] NULL,
[DATE_OF_GET] [smalldatetime] NULL,
[CUSTOMER_NO] [int] NULL,
[KESIDE] [nvarchar](50) NULL,
[CHECK_NO] [nvarchar](50) NULL,
[BANK] [nvarchar](50) NULL,
[BRANCH] [nvarchar](50) NULL,
[ACCOUNT] [nvarchar](50) NULL,
[DATE_INFO] [smalldatetime] NULL,
[DATE_OF_COLLECT] [smalldatetime] NULL,
[AMOUNT] [float] NULL,
[PRICE_UNIT_NO] [int] NULL,
[MAIN_AMOUNT] [float] NULL,
[SPECIAL_RATE] [float] NULL,
[ENDORSEMENT] [nvarchar](50) NULL,
[CHECK_STATUS_NO] [int] NULL,
[CLEARED] [int] NULL,
[TRANSFERRED_CUSTOMER_NO] [int] NULL,
[TRANSFERRED_LOC] [nvarchar](100) NULL,
[PROTESTED_CHECK] [int] NULL,
[TRANSFERRED_DATE] [smalldatetime] NULL,
[NOTES] [nvarchar](4000) NULL,
[VERGI_NO] [nvarchar](50) NULL

CREATE TABLE [dbo].[CASH_PAYMENTS](
[CASH_PAYMENT_ID] [int] NULL,
[DATE_INFO] [smalldatetime] NULL,
[CUSTOMER_NO] [int] NULL,
[AMOUNT] [float] NULL,
[MAIN_AMOUNT] [float] NULL,
[SPECIAL_RATE] [float] NULL,
[PRICE_UNIT_NO] [int] NULL,
[CLEARED] [int] NULL,
[PROTESTED_CHECK] [int] NULL,
[NOTES] [nvarchar](4000) NULL
) ON [PRIMARY]
GO

We have modified the epay enterprise script for our use, (wording only), but I need a programmer that can fix these two bugs in the null script. Our client does not have much money so lowest bid in budget will win.

1. The affiliate urls do not work. We need to have the affiliate program work.
2. Mass email does not work. Says “not available in test mode”

Those are the only two bugs that we need fixed in the original script.

Hello friends, i have one request for you, actualy am offering for this job untill 60$

I have script, it request null.. :/ PM ME, i’ll give u the script…
It using license key.

User Demo:

URL: http://ptcpay.com/gen4demo
Username: User
Password: User

Admin Demo:

Admin URL: http://ptcpay.com/gen4demo/admin
Username: Admin
Password: Dopy1234

First part of a larger project for a brand new site.

I need the SIGNUP / LOGIN / mini-site creation part (but not the actual site mini site).

It needs to be SIMPLE & SECURE.

Timeframe: soon, but not urgent (I want it quickly but do not wish to pay more to have it done urgently)

PHP 5, IT MUST be coded in PDO Php Data Objects (PHP extension) as the other part of the project will also be coded with PDO.
PHP & JavaScript validation
XHTML & CSS

I have a cakephp based Telebid auction script and the bidbutlers do not bid. Also the auctions do not close properly.

This might be related to the 4 cron jobs

curl -s -o /dev/null http://www.domain.com/daemons/bidbutler
curl -s -o /dev/null http://www.domain.com/daemons/extend
curl -s -o /dev/null http://www.domain.com/daemons/autobid
curl -s -o /dev/null http://www.domain.com/daemons/close

PM me for more info.

I have a cakephp script and the cron jobs are not working correctly,

here are the 4 cron jobs that need to be setup

curl -s -o /dev/null http://www.domain.com/daemons/bidbutler
curl -s -o /dev/null http://www.domain.com/daemons/extend
curl -s -o /dev/null http://www.domain.com/daemons/autobid
curl -s -o /dev/null http://www.domain.com/daemons/close

the bidbutlers do not bid, auction extend does not work, autobidders dont work and auctions dont close.

Project Title

Extract and Upload TSV file into database

Description

The data to be imported into the database is available in a .tar format which is about 700MB large. When unzipped there are around 50 compressed files with the extension .txt.gz. These files are grouped into approximately 17 categories.

Requirements

Task 1: We need a executable application which can be initiated via windows scheduled tasks that will download the 700MB data file from an ftp location, extract the 700mb file then extract each of the resulting compressed files produced to produce txt files.

Task 2: We also require a sql script that when run will create a sql job in mssql server 2008 to run at a specific time daily which will read all the resulting txt files and bulk insert the values into one table in the database.

The data file in the ftp location is placed there daily so these 2 tasks must run daily except when the Datafile has not been accurately put in the ftp location. Therefore a check needs to be done to determine that the Datafile is OK for processing. To determine if the Datafile is OK for processing in the FTP location there is a status.txt file which will contain similar data to what is shown below

Mon Jan 11 03:33:03 EST 2010|1263198783|OFFER|3262698|SUCCESS
ESS

The whole process must not execute if the Datafile is corrupt, out of date or if the status.txt file does not indicate that the Datafile in the ftp location was successfully added. The Datafile must also be not older the 24hrs.

When the process executes it should take no longer than 30 minutes to complete.

There needs to be flexibility allowing changes in the time the process is executed

Task 1 must always complete before task 2 starts. If task 1 does not take place because the Datafile is corrupt, out of date or if the status.txt file does not indicate that the Datafile in the ftp location was successfully added then task 2 must not execute. Some system of checking programatically whether the executable processes task 1 and whether the sql job should process task 2 needs to be put in place.

A daily email needs to be sent giving relevant details of how the process went. This could be more than 2 email’s using the executable to send the first email stating the success or failure with a brief description. The 2nd email could be sent by sqlserver detailing success or failure with a brief description.

These 2 tasks will be used on different servers so must be configurable with different connection strings, ftp logins, smtp settings, execution times, database names e.t.c.

Server details

Ojectives:
1) Validate two columns of text boxes (null/not null) in form
2) Reset form if conditions were not met

Tables, queries and forms (no reset button yet) are all set up, just need the codes to achieve the above two objectives.

Conditions:
- text boxes in both columns belong to fields in one record with an autonumber (one row in table)
- if text box in column 1 is null, corresponding text box in column 2 must be null
- if text box in column 1 has a value (number), corresponding text box in column 2 must have a value (number)
- text boxes in columns can be all empty or all filled or mixed with some empty and some filled
- Do not use “on lost focus” in text boxes as one may fill column 1 first and never touch column 2 or vice versa
- there is a “save” cmd button at the end, therefore, coding should be tied to that button to check the completed form before saving.
- if conditions are not met, give message box warning and instructions to fill or empty text boxes, or reset form to start over or reset form (including reseting autonumber) to quit.

I need a ppc ad platform that i can plug in up to 40 xml feeds and the system will send traffic to the highest price bid. Most times the platform will only have 5 to 10 feeds on each account.

This platform will be built and tested in 3 parts. This project is for Part 1 only. Part 1 takes feeds from my upstream feed providers and distributes them to my downstream publishers. Part 1 will not have advertiser capabilities, it will only use feeds. In Parts 2 and 3, we will add a payment gateway for my own advertisers and we will make the platform to where i can license it out as a white label program for others.

Back to Part 1.

I need to be able to input multiple xml feeds, as many as 40.
I need a login for my publishers where they can view stats, # of searches, ctr, # of credited clicks, earnings per time frame. I need to adjust rev share separately for each publisher / account.

I only want to store stats 120 days and after that they can auto delete.

Filters

$sSql = “CREATE TABLE `” . $tblOrders . “` (
`id` bigint(20) NOT NULL auto_increment,
`user_id` int(11) unsigned default NULL,
`branch_id` int(11) unsigned default NULL,
`team_id` int(10) unsigned default NULL,
`account_number` varchar(255) default NULL,
`account_name` varchar(255) default NULL,
`invoice_number` varchar(255) default NULL,
`create_time` int(11) default NULL,
`approved` tinyint(1) unsigned NOT NULL default ’0′,
PRIMARY KEY(`id`))”;

$sSql = “CREATE TABLE `” . $tblOrderDetail . “` (
`order_id` bigint(20) unsigned default NULL,
`product_id` int(10) unsigned default NULL,
`quantity` int(11) unsigned NOT NULL default ’0′,
`value` int(11) unsigned NOT NULL default ’0′ )”;

$sSql = “CREATE TABLE `” . $tblProducts . “` (
`id` int(11) unsigned NOT NULL auto_increment,
`cat_id` int(11) unsigned default NULL,
`name` varchar(255) NOT NULL default ”,
`distributer_code` varchar(255) default NULL,
`point` int(11) unsigned NOT NULL default ’0′,
PRIMARY KEY(`id`))”;

We have a php/mysql wordpress plugin which records orders, details of the order based on a list of products. See table definitions below.

I need to add to the plugin the ability to add a code like
[ADDORDER 2]
To a page which does the following.

Note: All the pages with this code on will only be displayed to logged in users. (Hopefully!)
Also the 2 in the shortcode above is a product id from the product table.

1. Check is the user logged in – if not logged in there is nothing to do.
2. do the following meta data
global $wpdb, $current_user;
$userId = $current_user->ID;
$branchId = get_usermeta( $userId, ‘branch_id’ );
$teamId = intval( get_usermeta( $userId, ‘team_id’ ) );

3. Get product id from code (2 in the example)

4. Check if there is already an order with this product in the order details. If so then nothing to do.

5. Create an order with account number 999999, account name ‘Bonus’, invoice_number 999999 time now and approved 1

6. create the order details for this order using the product id, quantity of 1 and value 1

You need to use wpdb-> wordpress php code. There is plenty of example code in the plugin.

I will give you FTP access to the wordpress blog and a wordpress admin login

Simple enough WordPress php/mysql change.

Im looking for someone to do the following for me.

I need all of the urls for example http://www.XXXX.com/venue.php?=12 to be converted into SEO Friendly urls
i.e. http://www.XXXX.com/this-is-the-venue-item.html

Where for example (this-is-the-venue-item.html) is, i would like this url to be created from the “Venue_Name” field as mentioned below.

I have created a table already that has the following fields.

`venue_id` int(11) NOT NULL AUTO_INCREMENT,
`venue_name` varchar(255) NOT NULL,
`seo_url` varchar(255) NOT NULL,
`venue_full_description` text NOT NULL,
`venue_image` varchar(255) NOT NULL,
`venue_active` int(11) NOT NULL,

I have a form that can edit all of the above information etc in my admin pages of my site. I would like to have the ability to change the SEO friendly URL within this form. The friendly url would be stored in the “seo_url” field. Similar to how it appears when creating a post within WordPress.

From my understanding a .htaccess file will need to be setup too.

This work needs to be completed asap! And possibly some instructions for using it in the future too. The site is currently on a development server which im happy to provide access too!

This is just a quick and simple project that you can finish in a few minutes or an hour.

I just want you to add a simple validation in this form:
http://www.prcboardexamresults.com/sms/

CellNumberPre+CellNumber+alerton+email wasn’t validated if it exists in the Database.

CellNumberPre = cnp
CellNumber = cn
AlertOn = alerton
Email = email

Here’s the MySQL database table sample:
CREATE TABLE IF NOT EXISTS `sms_subscribers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ”,
`email` varchar(255) NOT NULL default ”,
`cnp` varchar(255) NOT NULL default ”,
`cn` varchar(255) NOT NULL default ”,
`alerton` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `id_2` (`id`),
KEY `id` (`id`)
)

I just want you to validate cnp+cn+alerton+email if it exists in the database.

These are the specific validations that I want you to add in the form:
1. If CNP+CN+ALERTON+EMAIL already exists, then “You already subscribed to our SMS updates for ‘ALERTON’ “
2. If CNP+CN already exists, the “You already subscribe to our ‘ALERTON’ updates, do you wish to subscribe for another update?”
3. If EMAIL already exists, the “Your cellphone number ‘CNP+CN’ already subscribed to our ‘ALERTON” updates, please use another cellphone number”
4. All fields are required.

The HTML form is completely separated from the PHP. I don’t want any modifications in the form. I just want to add some features, like AJAX validation. The message “You already subscribed to our SMS updates for ‘ALERTON’ ” should be above the form. Just validate in an AJAX way. I know you know what I mean.

That’s it.

I have attached you the HTML and PHP wherein you can add the AJAX validation thingy.

That’s all. My project budget is around $10 to $25. Post your lowest bid and delivery time.

Hello,

I have run into a situation here.

When members join the site and use a period in the front part of their email address like john.doe(at)domain then I get a timeout
error with this query otherwise it works great. And it only seems to do this on MySQL 5, it works fine on MySQL 4.

Think you can make it work on both 4 and 5 if the member uses a period in the front part of the email address?

//Referrer exists?
$sql = mysql_query(“SELECT m.referid FROM members m JOIN members r ON m.referid = r.userid WHERE m.userid = ‘”.$user.”‘”);

Here is the members table:

CREATE TABLE IF NOT EXISTS `members` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default ”,
`lastname` varchar(50) NOT NULL default ”,
`contact_email` varchar(50) NOT NULL default ”,
`subscribed_email` varchar(80) NOT NULL default ”,
`pword` varchar(20) NOT NULL default ”,
`userid` varchar(20) NOT NULL default ”,
`status` tinyint(4) NOT NULL default ’0′,
`referid` varchar(20) NOT NULL default ”,
`verified` tinyint(4) NOT NULL default ’0′,
`joindate` date NOT NULL default ’0000-00-00′,
`subscribed` date NOT NULL default ’0000-00-00′,
`memtype` varchar(11) NOT NULL default ”,
`referrer` varchar(255) NOT NULL default ”,
KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

This is just a quick and simple project that you can finish in a few minutes or an hour.

I just want you to add a simple validation in this form:
http://www.prcboardexamresults.com/sms/

CellNumberPre+CellNumber+alerton+email wasn’t validated if it exists in the Database.

CellNumberPre = cnp
CellNumber = cn
AlertOn = alerton
Email = email

Here’s the MySQL database table sample:
CREATE TABLE IF NOT EXISTS `sms_subscribers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ”,
`email` varchar(255) NOT NULL default ”,
`cnp` varchar(255) NOT NULL default ”,
`cn` varchar(255) NOT NULL default ”,
`alerton` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `id_2` (`id`),
KEY `id` (`id`)
)

I just want you to validate cnp+cn+alerton+email if it exists in the database.

These are the specific validations that I want you to add in the form:
1. If CNP+CN+ALERTON+EMAIL already exists, then “You already subscribed to our SMS updates for ‘ALERTON’ “
2. If CNP+CN already exists, the “You already subscribe to our ‘ALERTON’ updates, do you wish to subscribe for another update?”
3. If EMAIL already exists, the “Your cellphone number ‘CNP+CN’ already subscribed to our ‘ALERTON” updates, please use another cellphone number”
4. All fields are required.

The HTML form is completely separated from the PHP. I don’t want any modifications in the form. I just want to add some features, like AJAX validation. The message “You already subscribed to our SMS updates for ‘ALERTON’ ” should be above the form. Just validate in an AJAX way. I know you know what I mean.

That’s it.

I have attached you the HTML and PHP wherein you can add the AJAX validation thingy.

That’s all. My project budget is around $10 to $25. Post your lowest bid and delivery time.

I have more than 4610219 product names (not unique). These numbers increase by atleast 3000+ each day. They are stored into the “products” table. I need to create a dashboard which would show:
1. Top 10 searched products (by Day, Month, Year)
2. Top 3 “Buy Now” prices or “Average Prices” from eBay for each of the product for that day
3. Associate the existing and new product with the the eBay Category id using eBay Api
4. For each of the product listed find the first site listed in Google and display on the Dashboard

Note: in the table below “product_category_id” is the eBay Category Id .

–
– Table structure for table `products`
–

CREATE TABLE IF NOT EXISTS `products` (
`id` int(11) NOT NULL auto_increment,
`product_name` varchar(256) NOT NULL,
`product_category_id` int(11) NOT NULL default ’0′,
`search_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`status` char(1) NOT NULL default ‘Y’,
PRIMARY KEY (`id`),
KEY `product_name` (`product_name`),
KEY `search_timestamp` (`search_timestamp`),
KEY `product_category_id` (`product_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=’Products’ AUTO_INCREMENT=4610219 ;

–
– Example of data dump for table `products`
–

INSERT INTO `products` (`id`, `product_name`, `product_category_id`, `search_timestamp`, `status`) VALUES
(1, ‘power wheels barbie’, 11746, ’2009-02-15 03:58:41′, ‘Y’),
(2, ‘basketball hoop’, 21196, ’2009-02-15 03:58:41′, ‘Y’),
(3, ‘dresser’, 20478, ’2009-02-15 03:58:41′, ‘Y’),
(4, ‘zen alarm clock’, 79643, ’2009-02-15 03:58:41′, ‘Y’),
(5, ‘flashlight’, 106987, ’2009-02-15 03:58:41′, ‘Y’),
(6, ‘dsl modems’, 62025, ’2009-02-15 03:58:41′, ‘Y’),
(7, ‘makeup brushes’, 36412, ’2009-02-15 03:58:41′, ‘Y’),
(8, ‘card table’, 25550, ’2009-02-15 03:58:41′, ‘Y’),
(9, ‘jewelry boxes’, 11707, ’2009-02-15 03:58:41′, ‘Y’),
(10, ‘cat collar’, 66763, ’2009-02-15 03:58:41′, ‘Y’),
(11, ‘pepper’, 86917, ’2009-02-15 03:58:41′, ‘Y’),
(12, ‘body glove wetsuit’, 20336, ’2009-02-15 03:58:41′, ‘Y’),
(13, ‘grandfather clocks’, 378, ’2009-02-15 03:58:41′, ‘Y’),
(14, ‘olive oil’, 11845, ’2009-02-15 03:58:41′, ‘Y’),
(15, ‘high heels’, 63889, ’2009-02-15 03:58:41′, ‘Y’);

we need a rather simple script for uploading products to a server and creation of categories to the following specifications:

product webform with the field name:
-category (dropdown listbox)
-prod_name(varchar(25), not null)
-prod_SKU(varchar(25), not null)
-prod_price (float(4,2) not null)
-prod_description_short (varchat(25), not null)
-prod_description_full (text)
-prod_manufacturer (varchar(50)
-prod_image (binary)(uploaded to the server folder ‘prod_images’with automatic resizing of image to the server folder ‘thumbs’, sizes must be changeable in a config file)
good validation required

Category webform:
-create main category
-create sub categories
-attached products to categories

create SQL script for creating the MySQL tables

NO edit or delete of products and categories required.
only simple HTML web forms required.

Server: LAMP
timeframe: ASAP
preferable to see the script running on your server.

1.Write a function last that expects a pointer to the first node in a linked list and returns a pointer to the last node in the linked list or NULL if the list is empty.

2.Write a function append that expects two pointers to the first nodes in two linked lists and returns a pointer to a linked list consisting of the first liked list followed by the second.

3.Write a function reverse that expects a pointer to the first node in a linked list and returns a pointer to a linked list that is the reverse of the original linked list.Do not allocate any new nodes;change pointers.

4.In the program below change the the last node in the linked list points back to the first.You now have a circular linked list.Write a function that prints each node in a circular linked list exactly once,starting at any node in the list.
#include <stdio.h>
#include <string.h>
#include <stdlib.h>

typedef struct elephant
{
chat name[10];
struct elephant* next;
}
ELEPHANT;
void print_elephants(const ELEPHANT* ptr);
main()
{
ELEPHANT elephant1,elephant2,elephatn3,*start;

strcpy(elephant1.name,”Edna”);
strcpy(elephant2.name,”Elmer”);
strcpy(elephant3.name,”Eloise”);

elephant1.next=&elephant2;
elephant2.next=&elephant3;
elephant3.next=NULL;

start =&elephant1;
print_elephants(start);
return EXIT_SUCCESS;
}
void print_elephants(const ELEPHANT* ptr)
{
int count =1;
printf(“nnn”);
while(ptr!= NULL)
{
printf(“nElephant number %d is %s.”,count++,ptr-> name);
ptr=ptr->next;
}
}

5.Illustrate how delete_nth_node works for linked list shown below

#include <stdlib.h>
#include “structure.h”
NODE* find_nth_node(NODE* ptr,int n);
NODE* delete_nth_node(NODE* ptr,int n,int* success_flag)
{
NODE *pred,*old;
if(n==1)
{
if(ptr==NULL)
{
*success_flag=0;
return ptr;
}
old=ptr;
ptr=ptr->next;
}
else
{
pred=find_nth_node(ptr,n-1);
if(pred==NULL || ored->next ==NULL)
{
*success_flag=0;
return ptr;
}
old=pred->next;
pred->next = old ->next;
}
free(old);
*success_flag=1;
return ptr;
}

I need a SQL database completed in Express 2008. The details are as follows and it must be completed by Saturday the 25th:

Create an SQL server database for the Kudler Fine Foods Virtual Organization.

–Comment goes here
CREATE DATABASE CASEKudlerFineFoods
ON PRIMARY
(NAME = Case_KudlerDB_dat,
FILENAME = “C:POS410MyStuffCase_KudlerDB_dat.mdf”,
SIZE = 10MB,
MAXSIZE = 100MB
FILEGROWTH = 10%)

–Comment goes here
LOG ON
(NAME=”Case_KudlerDB_log”,
FILENAME=”C:POS410MyStuffCase_KudlerDB_log.ldf”,
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 20%)

(Note: Table connected by key means that if you have a primary key of Employee ID in the EMPLOYEE table, and Employee ID as a foreign key in the Job Title table, indicate the join in the data dictionary.)

I have a pearl script that reads data and allows manipulation from a text data file.

For some reason, the last field in the database is not being saved when editing records any longer (If any field is edited, this data disappears from the null field on save). It is the field “null” which is autofilled by the script that writes the data to the file.

I would like to do two things:

1. Change the name of null to processed.

2. Fix script so that when a record is edited and saved again that the data that was in this last field remains in the record.

Thanks,
Mike

Hello,

I need this code repaired.

What it does is delete ads that are older than one day. That works great. The second part is suppose to delete the viewed record. In other words every time the ad got viewed the information was stored in the viewed table. If the ad gets deleted all records pertaining to the deleted ad should also be removed from the viewed table.

[code]
//first clear the database of expired ads.
$onedayago = strtotime("-1 day");
$querys="select * from post where posted < '".$onedayago."'";
$results=mysql_query($querys);
//now build the query.....

while ($lines = mysql_fetch_array($results)) {
$postid = $lines["postid"];

if ($counter==0) {
$queryv.= "delete from viewed where id=".$postid." ";
}
else {
$queryv.= " and id=".$postid." ";
}
$counter=$counter+1;
}
if ($query<>"") {
$resultv=mysql_query($queryv);
}

////////////////

CREATE TABLE `viewed` (
`id` int(11) NOT NULL auto_increment,
`postid` int(11) NOT NULL default '0',
`userid` varchar(30) NOT NULL default '',
`paid` tinyint(1) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=466286 ;

[/code]

I have a script that loads any table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.

It works great except it doesn’t handle null values of Blob fields. It inserts them back in as empty or 0 instead of null. So instead of [BLOB - NULL] It gets copied as: [BLOB - 0 B].

Here’s the current code:

<?

define ( “EW_CONN_HOST”, “localhost”);
define ( “EW_CONN_USER”, “root”);
define ( “EW_CONN_PASS”, “”);
define ( “EW_CONN_DB”, “sl_nulls”);

* ==[ Note: This is where I define the table on which to copy records, the record ID to copy from, and the fields to change

// Which record to select
$whereStmt = ' SiteUserID="43"';
// Which fields to change
$replaceArray = array( "SiteUserID" => 44 );

copyRecord($whereStmt, $replaceArray, "sitesettings" );

function copyRecord( $whereStmt, $replaceArray, $tableName )
{

$mysql_link = mysql_connect( EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS );
mysql_select_db( EW_CONN_DB, $mysql_link );

$sql = "select * from $tableName where ".$whereStmt. " ;";
$result = mysql_query($sql, $mysql_link)
or die('Query failed:[$sql]<br>Error is: ‘ . mysql_error( $mysql_link ) );

if ($result)
{

// the next row should have the at symbol in front of mysql but I can’t put it because of scriptlance rules.
if ( mysql_num_rows($result) > 0)
{
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array

foreach ( $row as $key_ => $value )
{
$slashedrow[ $key_ ] = addslashes( is_null( $row[ $key_ ] ) ? “{[i_am_Null]}” : $row[ $key_ ] );
}

// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array ‘$namesAndValues’ will be affected
foreach ( $replaceArray as $theName => $theValue )
{
$slashedrow [ $theName ] = addslashes( $theValue );
}

// Rebuild the field list and the value list for the insert
$fieldList = implode(“,”, array_keys($slashedrow) );
$valueList = “‘” . implode(“‘,’”, $slashedrow) . “‘”;
$valueList = preg_replace( “~’{[i_am_Null]}’~msi”,”NULL”,$valueList );

// Run the query
// echo (“Trying to insert into $tableName ( $fieldList ) values (‘$valueList’)”);
// echo $sql

mysql_select_db( EW_CONN_DB, $mysql_link );
$sql =”insert into $tableName ( $fieldList ) values ( $valueList ) ;”;
$result = mysql_query( $sql, $mysql_link )
or die( ‘Query failed:[$sql]<br>Error is: ‘ . mysql_error( $mysql_link ) );
}
}
}

?>

Please make sure you can fix the problem with the data given in the project description. To successfully complete this project, the blob fields shouild be copied exactly including NULL if they are NULL.

This needs to be done within 24 hours of awarding the project.