Get a Freelance Job

I’m the member of a site that offers an API to generate articles! I know my way around html and css but php is way over my head. In comes you!

The documentation is really clear but I have no way to script/turn it into something useful. He lists all the variables and even a sample script on his site so I’m sure you can make this work. What I’d like in functionality from the script are the following things:

- Every variable has it’s own input field based on the type of input required (on a w…

Hi
MySQL query problem.
Please contact about details.
Budget = 10, I will compensate in the next project

Hi
MySQL query problem.
Please contact about details.
Please note my budget is set to 10 sadly, thanks.

Need a programmer to create a website that does the following:

If you go to:
http://www.modelzone.nl/search/
And choose profiletype (profiieltype) : Model
Then click zoeken (Search)
THE first page Will list models (results: 36)
If you go to page 2 it Will list on page 2 all profile types (results: 76) instead of only models.
I need someone to correct this.

Requirements:
- very good php knowledge
- comment in file what you did
- payment after work done

Hello Programmers

I need to setup a php script that run every so many minutes and will do the following

1. connect to a game server via tcp/ip and login via rcon system
2. the script will need to issue the command bf2cc pl
3. the script will then parse each line as a player and store his status in a database (kills, deaths, score, team, etc..)
4. will then use a serverstatus.php to read the server status databause and show

Please view the attached files for more information and wha…

Hello Programmers

I have currently have a sqlite database that contains player information (gamers) I also have a simple php page that will displays the database contents in a nice graphical form. Look here to view it http://www.dylanknisley.com/stats

As you can see from the link we have 3 servers thus 3 databases. They includes the following information : playername, level, class, score, kills, deaths, class, time played. times connected. Now please keep in mind each server contains its o…

Need some work done to troubleshoot a report/query written with Access and using Access DB. Created using 2003 and needs to stay 2003.

This is an existing report generator using drop down and radio button selection along with a date range. It seems the query may not be accurate. I need someone to review the query against what it should do and determine if there is any issue and then edit if necessary.

Thanks

I have a fairly complex mysql query which needs to be optimized.
Please bid on this project if you are a mysql optimization expert.

I’ll need you to advise on which indexes should be created for this specific query.
Also I’ll need advise if and how we need to rewrite the query.

I can send you the query over private message before you bid.

Only mysql optimization experts please.

I have a fairly complex mysql query which needs to be optimized.
Please bid on this project if you are a mysql optimization expert.

I’ll need you to advise on which indexes should be created for this specific query.
Also I’ll need advise if and how we need to rewrite the query.

I can send you the query over private message before you bid.

Only mysql optimization experts please.

Hello, I need some help with a SQL Server Query in Microsoft SQL Server 2008.

I have two tables, one with device information, and the other with device history. The device history is keyed to the device information id column.

In the devicehistory table I have 4 columns: id, compid, startalarmdate, endalarmdate. I have a script in my application that adds an entry when one of my devices goes into alarm, it puts in the id of the device into the compid column. It also writes the current date…

This is a very small Javascript project but is needed urgently.

I need a simple program which will be used to store information about tracks played by a radio station. Every track will be assigned an index, this can be based on the existing Javascript array indexes. Each track will need the following data:

Track name
Track artist
URL

I need for it to be stored in an array of some sort and the program must be able to perform the following operations:

Insertion: of new tracks to the …

Need some work done to troubleshoot a report/query written with Access and using Access DB. Created using 2003 and needs to stay 2003.

This is an existing report generator using drop down and radio button selection along with a date range. It seems the query may not be accurate. I need someone to review the query against what it should do and determine if there is any issue and then edit if necessary.

Thanks

PLEASE, Only serious people respond. I will pay you through the scriptlance account ONLY. If that is not good for you, please do not bid on this project!!! Also, I will pay you your BID price. Do not bid a price, do the work, and then haggle or hassle me for a larger fee. The project is listed IN FULL, so please bid for an acceptable amout for you. This project needs to be done in 20 hours.

Below is the project. Please use the attached database as your data. The deliverable is an Acce…

Develop two tools that will allow for the user to input a keyword. Based on the keyword, the two tools will do the following:

1. Competitive tool – Do a google search for the keyword and scrape the top X number results(URL, Title, description, and rank). This data will be available via export at the end. Once the scrape is complete, it will take the URLs that it found and get link data from the Majestic SEO API. For each URL, it will query Majestic seo and pull that URL’s backlink data and ad…

Hello Programmers

I have currently have a sqlite database that contains player information (gamers) I would like someone to make the following html / php stats page by using the included database.

Look at this example, I would like it to show the following stats http://hlstats.bob.fi/index.php?mode=players& game=cstrike

My database includes the following information, playername, level, class, score, kills, deaths . I would like for the query / stats page to also include a rank based on …

Looking to match a catalog/database against a XML database. The database is from Discogs.com.

Data:
http://www.discogs.com/data/

API
http://www.discogs.com/help/api

I’m listing my entire catalog in their marketplace. I have several thousand releases from my own website database in xls/csv. They have a bulk upload which requires their unique release ID. Would like to setup a solution so I could do regular queries and create my own upload database to correspond with Discogs.

DO NOT BID UNLESS YOU CAN DO THIS TODAY, RIGHT NOW.

I need to rewrite a group of strings
Here is what it is

http://www.domain.com/something1& Category_Code=something2.html

to go to (redirect 301)

http://www.domain.com/something1.html

it needs to drop anything after the & ampersand, up to the .html
But this file has many many other things going on in it so you need to really know your stuff.

Hi All,

I hoping one of you will be able to help me, I’m a bit out of my depth when it comes to javascript and API’s so I need some assistance.
I would like to query google shopping API, producing a webpage containing the result in a table format (say the first 1000 on screen). This webpage needs to offer both:-
1) an option to download ALL results into csv file.
2) sort the results via any of the attributes.
3) search with in the results
I’ll also need any javascript files etc. that are required for it to all work.

Some of the querys I wish to run produce 150,000+ results, hence the need to be able to download all the results to a single csv file.

I already know that if i query google shopping API it limits my results to 1000, so you’ll need to possibly run the query x number of times until you have all the info required. I am aware this may take a while to download, thats OK.

PS I have omitted my specific key to the sample query in the text field

I have included the files I can think that you might need
Example of webpage I want and an simple example of the csv file it will need to produce. I am unable to upload the json result from google shopping API this form will not allow it.

I hope they help any questions please contact me.
Thanks Paul

I am using the open source script Phplist. I need a small query script (called qscript from now on) to identify email addresses that meet my criteria, within a database used by my installation of phpscript.

The qscript must be written in php and will be hosted on the same server where my PHPLIST is installed. When launched, qscript will

1) ask for my db details (user, password and database name)
2) ask for a starting and ending date
3) ask for a maximum number of mailing lists

The script will then go through the database and extract all the email addresses that were entered between the starting and ending date and that are subscribed to more than the maximum number of mailing lists.

The resulting email addresses will be presented in a download link to a csv file containing all the email addresses that were extracted.

If you are familiar with PHPscript, this should be very easy.

We need to make a website that does the following:

1. On the home page, you make a query, it searches a database
2. Finds all the results matching that ID/query
3. Then on the results page provides a graph of quantity over time for that ID, a text field that states the date of the first entry, along with some of the information from the most recent/newest entry in the database of that item.

No styling required, just functionality. Must use a mySQL database.

I use Excel for mac 2011.

I currently download share price data/information into my spreadsheet via the standard query “MSN Moneycentral stock quotes”.

However there have been problems with the quality of the data recently.

I would like a query that pulls stock data off Yahoo Finance (my preference) or Google Finance. I need data only for the US & Canada.

The query must download the data into a workbook where I have already entered the stock codes. The stock prices do not need to be real-time. The standard 15 min delay data that is freely provided is sufficient.

See attachment for sample spreadsheet.

I just need a query in SQL for the following: Create a heading of REPORTING STATEMENTS as a comment at the bottom of your script file

Hello all,

What I need is relatively simple. I need someone very very skilled in PHP to add a form to my Yahoo Boss API code. A simple code is already written, but I have no idea how to add a form to actually capture the input. I need someone who can tweak this sample code and add the php elements needed for the search to be functional.

I.E

- Read the query parameter from the form in your HTML

- Take the output and write it out in a HTML page.

Once the person has the complete code for me, I will request the code for me to test with my secret keys. (We can do escrow for safety)

Once the testing is complete and I see the code is fully functional we can agree to release the funds.

If you are unsure about this project, here is the documentation.
http://developer.yahoo.com/search/boss/boss_api_guide/

There are two sample codes you can use, one that is in the guide
1. http://developer.yahoo.com/search/boss/boss_api_guide/codeexamples.html#oauth_php

2. The other I will give to the winning bidder.

PROGRAMMER REQUIREMENTS:
1. Must be fast!
2. Speak clear english
3. Must have sample work with PHP or related projects

Please big accordingly, I stress that I’m just looking to attach the form with elements to make the sample codes work. Thanks

I have a Volusion webstore with about 500 products (women’s clothing, jewelry and accessories). Due to Google’s recent changes in their Products Feed Specifications, I need to have the QB Query code language I currently use in Volusion’s Import/Export section revised so that it will generate and export a datafeed that meets Google Products new specifications.

Google Products now requires additional categories: size and color variants, gender, age group, availability

My current export is currently NOT generating any of these categories.

Assume I have the following Tables

————-
user
————-
userid
name
picture
etc.

————-
group
————-
groupid
etc.

————-
group_has_user
————-
groupid
userid

Let’s say I would like to Get array with userid, user.name, and user.picture for all users who are member of groupid 5

How would I write such a query?

You need to be available to do this right now please.

I have a membership (mysql) db on a Linux server with cpanel and whm access. It is a dedicated server that I lease. I need 2 separate things done.
1.)I need someone to query the db and find all “active” members who “confirmed” emails since January of 2010, and also any and all active members who joined since Jan 2011. Then I want my db modified to where it is ONLY “sending” emails to ONLY those members in the above 2 queries. All of the other members will be deactivated and will not receive emails. They will not be deleted. They will only be set to inactive.
2.) There is a “sendall” email function in that db. It is an admin function where I send emails to all active members. It is not functioning properly. It is sending emails to ALL members – including inactive members. I need that modified to ONLY send “sendall” emails to ACTIVE members.
Please be experienced as you will be working with a mysql database in a Linux and WHM setting. I have everything including root/ssh access.
You must show experience or please do not bid. I would like this done asap.

In need of powershell script to do the following:

Trying to assign this computer belongs to strings in active directory descriptions from sccm 2007 data.

1. Query all Client Systems from sccm 2007, find the last logged on username.
2. Append active directory computer description with “SCCM SAYS>>username” not deleting the existing descriptions.
3. If script is reran – if string “SCCM SAYS>>username” already exists in the AD computer description then just overwrite that string with new data. Leaving existing descriptions intact.

4. If possible add lines to run on just one defined computer for testing or all computers.

This script can use the quest powershell for AD to add to descriptions
etc.

Script Will need to connect to sccm server to get the data then use quest powershell ad script to add to AD computer descriptions.

Should be pretty simple.

Thx

I am looking for someone who can provide me with a mysql query in PHP (on command line) for the following scenario:

I have a MySQL table with the follwing 30 items:
ID, DATETIME, ITEM, STATUS (true|false)

A PHP Script should endless loop this MySQL table and check the STATUS row for each item. When an item got STATUS=FALSE, the PHP endless loop is querieng from this point (ordered by datetime) and ignoring the rest which is older (datetime). EXAMPLE:

1 14-09-2011 APPLE true
2 15-09-2011 FISH true <—
3 16-09-2011 CAR true
4 18-09-2011 ANIMAL true

i.e. at the beginning every item will be looped, and checked for the STATUS. If i.e. the item 2 “FISH” gets STATUS FALSE, only the rest of the items will be looped (from 3-4), and item 1 (Apple) not.

We want an application for lottery entry analysis, i.e tickets with wining combination, unchosen numbers, etc. we allow 79 numbers and wining combination below.

Two (2) correct prediction out of five (5)that is picked,
Three (3) correct prediction out of five(5),
Four (4) out of 5 picked and if you are that lucky
Five (5) out of five.
All our game are, predict correct five (5) out of 79. i.e 1-79

We run a Lotto Business and want a desktop application to help analysis all entry and show winning tickets and numbers without a wining combination, unchosen numbers for wining combinations. client will choose from 79 numbers and winning combination are as below.

Two (2) correct prediction out of five (5)that is picked,
Three (3) correct prediction out of five(5),
Four (4) out of 5 picked and if you are that lucky
Five (5) out of five.
All our game are, predict correct five (5) out of 79. i.e 1-79

This project consist in creating an interface (in the following simplu refered to as

PLEASE, Only serious people respond. I will pay you through the scriptlance account ONLY. If that is not good for you, please do not bid on this project!!! Also, I will pay you your BID price. Do not bid a price, do the work, and then haggle or hassle me for a larger fee. The project is listed IN FULL, so please bid for an acceptable amout for you. This project needs to be done in 20 hours.

Below is the project. Please use the attached database as your data. The deliverable is an Access database with working data entry forms and reports.

Reports should display two or more child rows for each parent row. For example, a report that shows course instructors are approved to teach would display each instructor with 2 or more courses that instructor is approved to teach. If you need to add data you may do so.

Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach.

Create a report using the wizard or based on an SQL query that shows student information and what their major is.

Create a report using the wizard or based on an SQL query that that shows student information by zip code. Zip codes shall be in increasing order.

Create a report using the wizard or based on an SQL query that that shows the Course Name and the students in each. Sort Course Number in increasing order.

Create a report using the wizard or based on an SQL query that that shows status for each student. The student should be in alphabetical order by last name, then first name.

The text and tutorials provides the knowledge needed to create a sample data entry form. Each system has its own characteristics with respect to data input. The form should be created in Access, and should be representative of one of the major entities in the database. Appropriate design elements such as the source documents, the need for forms/subforms and GUI control options should be considered.

*Create a form that is based on an SQL Query.
*Create a form using the wizard.
*Create a form of your own design using a master detail relationship.
Deliverables

********The deliverable is an ACCESS database with working data entry forms and reports.

Thank you to everyone for your consideration!

PLEASE, Only serious people respond. I will pay you through the scriptlance account ONLY. If that is not good for you, please do not bid on this project!!! Also, I will pay you your BID price. Do not bid a price, do the work, and then haggle or hassle me for a larger fee. The project is listed IN FULL, so please bid for an acceptable amout for you. This project needs to be done in 20 hours.

Below is the project. Please use the attached database as your data. The deliverable is an Access database with working data entry forms and reports.

Reports should display two or more child rows for each parent row. For example, a report that shows course instructors are approved to teach would display each instructor with 2 or more courses that instructor is approved to teach. If you need to add data you may do so.

Create a report using the wizard or based on an SQL query that that shows Courses that instructors are approved to teach.

Create a report using the wizard or based on an SQL query that shows student information and what their major is.

Create a report using the wizard or based on an SQL query that that shows student information by zip code. Zip codes shall be in increasing order.

Create a report using the wizard or based on an SQL query that that shows the Course Name and the students in each. Sort Course Number in increasing order.

Create a report using the wizard or based on an SQL query that that shows status for each student. The student should be in alphabetical order by last name, then first name.

The text and tutorials provides the knowledge needed to create a sample data entry form. Each system has its own characteristics with respect to data input. The form should be created in Access, and should be representative of one of the major entities in the database. Appropriate design elements such as the source documents, the need for forms/subforms and GUI control options should be considered.

*Create a form that is based on an SQL Query.
*Create a form using the wizard.
*Create a form of your own design using a master detail relationship.
Deliverables

********The deliverable is an ACCESS database with working data entry forms and reports.

Thank you to everyone for your consideration!

I have a MS Access database with about 150,000 names, addresses and emails. These are for Australian businesses.

I want to sort them according to State (there are 6 states in Australia) so I want to sort the database into 6 smaller databases – one for each state.

It is probably easy if you now how to use Access but I don’t have time to learn it.

Delete query is taking endless time for products in prestashop. Can any body solve it?

Below is a working query that i have constructed in my Silverlight4 Project DomainService1 class. The query below returns all customers that have the current logged on users CompanyID. “Select Number” is the users – UserID. “CompanyId” is the users CompanyID.

I need a query written for my DomainService class that returns the current logged on users’s Company_UUID to a TextBox. As you can see in the query below, “dim companyid” gets the Company_UUID but i need to return this value to a textbox. This needs to be written in VB. I need this completed today.

Public Function GetV2_Customer_Guid3(ByVal selectNumber As Guid) As IQueryable(Of v2_Customer)
Dim companyid =
(From b In Me.ObjectContext.v2_UsersCompany
Where b.User_UUID = selectNumber
Select b.Company_UUID).FirstOrDefault

Return From c In Me.ObjectContext.v2_Customer
Where (c.Company_UUID.Equals(companyid))
Select c
End Function
””’
””’
The textbox.text value will load as soon as the page loads. As you can see below, the Textbox1.text value will load as such.
””’
””’
Public Sub New()
InitializeComponent()

Me.Title = “hello”

TextBox1.Text = a.ToString ‘ “a” will be the CompanyID
Label1.Content = a
‘ Dim instance As New Guid(g)

End Sub

Hi

For some reason, mysql_query brings up a syntax error on one of my pages. Strange thing is, when I copy/paste it into a tes.php page, it works. So it only seems to fail when there are multiple mysql_query on the same page. Weird.

I’ll be available on MSN chat if that helps.

Cheers
Phil

I would like the following:

1 – An install script to create a MySQL database containing a table with the following columns:
“Product_Id”(generated by database to increment by 1 for each insert),”
“Title”(for the product name),
“Model”
“Description”(unlimited length),
“Price”,
“Image”(to store images);
“Alt Image text”,
“URL”(to store a URL to go to)

2 – An Insert screen that can be called from my websites (e.g. www.mysite.co.uk/insert) – must be password protected (I will upload the page)
– The insert screen will prompt for values to be input into the table created in step 1
– It will also have the ability to upload a single image to the table (limit the size to 500k and resize them without distorting the height/width ratio)

3 – An Edit/Delete screen that can be called from my website (e.g. www.mysite.co.uk/edit) – must be password protected (I will upload the page)
Note: – if it’s easier, please consilidate the Edit/Delete screen and Insert screen into one screen with 2 links.
– the Edit/Delete screen will list all the products in the table and give me the ability to either edit or delete the selected product.

4 – 3 easily editable php scripts to query the table that I can embed into any html page I wish (basically I want to be able to query the MySQL table above
from any html page I wish – creating a dynamic part to a static html page). However, if you think there is a better way to do this – let me know before
we finalise the work – maybe it’s better to create php pages with embedded html?
– Even though the query will be producing dynamic content – I would like it to become “static” content that the Search Engines can spider (I will be optimisitng
the product Description to target keywords, so I want the Search Engines to see the text and not just a php query – ask me if you need clarification).
– Each script will need to present the data and image in a different way:
script 1 – will be a full product listing script and will select Title, Price, Image, URL(with a “More Info” button)
– will have a layout something like http://www ghostbikes com/categorylist/On-Road-Gear-Motorcycle-Jackets/
Script 2 – will be a Model listing script and will select Title, Description (but only first 50 words), Price, Image, Alt Image Text, URL(with a “More Info” button)
– will have a layout something like http://www dogclippers org uk/andis_dog_clippers.html
Script 3 – will be a single product listing script select Title, Description (all of it), Price, Image, Alt Image Text, URL(with a “More Info” button) – where product_id=xxx

– With all 3 scripts I want to be able to edit the presentation font, header colour,colour etc, to match the website html page. (stylesheet maybe?)

Let me know if you have any questions
Regards
Warren

I have a website here : http://bit.ly/ntiSBF After I tried to an upgrade the site broke down, so I restored files and database and no it returns me this error :Bad Subdomain SQL Query

Budget is $20. No escrow payment in full once delivered. NEED IT TODAY.