Archive

Posts Tagged ‘status’

Magento Add Shipment-status Column To Shipment Grid

January 19th, 2012 Comments off

Add the “shipment_status” column from sales_flat_shipment to the shipment grid (Sales->Shipments)

1. The DB will have a numeric value in “shipment_status” that shows the status – i.e. 1=delivered Null=un-delivered, 2=returned etc.
2. This status number has to be enumerated to show the actual status – ie. 1=delivered Null=un-delivered, 2=returned

Don’t need any admin interface – just the php and xml override file.

Thanks

PS: Magento 1.4.2

Whmcs – Modifications For Network Status Page

January 16th, 2012 Comments off

Hello,

I am in need of modifications for our Network Status page in our WHMCS Install. We need to customize the script to only display network issues to customers who are affected by the downtime. For all other customers a friendly “No Network Problems Occur” message would display.

I have a few other projects related to WHMCS and hooks/customizations that will be required should this project go well.

Making An Admin Panel And Adding A Group Level Image

December 30th, 2011 Comments off

Hi there I want a admin panel to edit users profiles , groups and what level they have
user status normal user
admin status full access edit and remove add and remove group level
guide status limted access only edit profiles and group

For the group level image I want to add to my group list where if the group on level 1 a image will show if group on level 2 a diffent image show

Fb + Twitter Status Update Script + Scheduling

November 2nd, 2011 Comments off

Http://postcron.com/ and tuitting similar type of project

I need to integrate something very similar to my CMS. I’ve purchased tuitting (jquery/ajax heavy) so we can use that or if you have stand alone I’m open. We’ve been working on this already so you can continue or start fresh if you’ve already got something prepared.

Mainly interested in the scheduling and ease of multiplying or automating the status posts. Need auto recurring if not against fb tos.

This must all be laid out very easy for user.

Features I need:
- facebook login/account creation
- multi user ( I have this on cms, just need to hook it up)
- schedule unlimited duplicate posts (repeat every _ days – or by calendar) to fb or twitter or both
- pull random quote from db or use scheduled status
- save posts for future use
- choose to post status to fb,twitter, and any others
- php/mysql
- you need to set up all necessary api’s with facebook for testing, then let me know how to hook it up ourselves when complete

PMB any questions.

Oscommerce Paypal Not Updating Order Status

October 18th, 2011 Comments off

I have a heavily modified oscommerce website and when someone pays by Paypal the order status is not updated…on the order page it always says No PayPal Transaction Information Available. No order confirmation email is being sent either.

I have checked at Paypal and it appears that the notification from them is being sent back to the website.

I have 2 similar websites that were a copy of this site but they have had a couple of other small modifications done to them, nothing to do with Paypal, and these work fine.

I need the Paypal module fixed so it will update the order status and put the payment info on the order and send the confirmation email.

This website had auctionblox installed and I think something was changed about the Paypal module but I don’t know what was changed. Even though I stopped using auctionblox a long time ago, the Paypal module still worked fine for several years but all the sudden stopped working correctly for some reason?

Desktop Widget That Shows Internet Status

October 15th, 2011 Comments off

I have a bunch of sales reps who use laptops in the field with Cellular Air Cards. Frequently, they report problems with connectivity, when I troubleshoot I find they are not actually connected to the internet. I am looking for a small application that can run in Windows sidebar, or on the desktop that basically shows a red/yello/green light method of determining internet connection. I can put a couple sites in a field, or in a text file, the program can measure ping times and light up the appropriate light, so if the sales rep sees red, he is not connected, if he sees yellow, he might have a very slow or unstable connection, and if he sees green he has a ‘good to work’ connection.

Magento Cron Script – Update Order Status

September 23rd, 2011 Comments off

I need someone to create a php cron script for magento which will update order status’s for me, following a set of rules which I will specify, for example:

Check all new orders in the system.
If the delivery address post code = x, y or z then update the orders status to “status2″
If the amount paid for shipping < x then update status to “status3″
If the amount paid for shipping > x then update status to “status4″

The script also needs to look at the attributes for the product they have ordered and update an order attribute depending on what they have ordered. ie there’s a product attribute called “number of labels”, so look at that attribute and multiply the “number of labels” by the quantity purchased of that item and then save the result back to the database as an order attribute.

The script should output its results as it goes so when it’s run in a browser you can see what’s happening to each order, ie:

Order ID 123 weight = 2kg therefore status updated to x etc etc

This script is to replace one that I’ve been using for years that was coded for oscommerce, but now we’re upgrading to magento it needs rewriting.

I have uploaded two text files explaining the requirements in more detail. One of which is effectively some rough pseudo code for what needs to be created.

The code should be fully commented so that I can edit it later on if changes need making.

This can be a totally stand alone system that just updates the database , and is run by cron every 10 mins or so.

thanks

Simple Fast Php/mysql Command-line Query Script

September 20th, 2011 Comments off

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.

Amazon/ebay Api

September 6th, 2011 Comments off

I need 1 c# page that lists (order date, customer name/ebayid, order total and order status) the Amazon/eBay orders from 4 Amazon acocunts and 1 eBay (but will need the ability to add more).

On clicking the order, you can see the products ordered and customer information as well as the order status.

Ability to update order status & send to Amazon/eBay (bulk update too).

Central MSSQL stock database is reduced when products are purchased on Amazon/eBay.

Adding a product to the MSSQL database also sends/lists the added product(s) to the Amazon/eBay accounts.

User Status Streams With Status History

August 23rd, 2011 Comments off

I need previous history of status posts of a user to show on a separate page like a status stream, this being viable to other members. This page needs to show a limit of 30 results, each status update needs to show date in the format of seconds, to minutes, to hours then showing the date in which the update was posted like how the homepage statuses are.

Anything a user posts right now shows only once until the user updates their current status again.

Mysql Problem Subqueries

August 20th, 2011 Comments off

Can someone pls tell me how do i select multiple values for “artist_names” column, when i run following query it says “#1242 – Subquery returns more than 1 row” but i want to select all artist names for that event, (since one event can have multiple artists)

++++++++++++++++++++++++++++++++++++++++++++++++++++++

SELECT e.event_id,

(SELECT a.artist_name FROM event_artist ea, artist a WHERE ea.artist_id=a.artist_id) AS artist_names,

e.event_name, e.event_intro, e.event_des,e.event_contact_name, e.event_contact, e.event_email, e.event_tags,
e.event_rating, e.event_rating_count, e.event_type, s.show_date_from, s.show_date_to , s.show_repeat,v.venue_id, v.venue_name, m.media_name, c.category_name,
IFNULL(img.image_thumb,’default.jpg’) AS image_thumb
FROM event e
LEFT JOIN `show` AS s ON ( e.event_id = s.event_id )
LEFT JOIN `venue` AS v ON ( s.venue_id = v.venue_id )
LEFT JOIN `category` AS c ON ( e.category_id = c.category_id )
LEFT JOIN `media` AS m ON ( c.media_id = m.media_id )
LEFT JOIN `link_image` AS img ON ( e.event_id = img.event_id )
WHERE img.image_main=’Y’
AND e.status=’Y’
AND s.status=’Y’
AND e.status=’Y’
AND v.status=’Y’
AND e.status=’Y’
AND m.status=’Y’
AND c.status=’Y’
AND img.status=’Y’
GROUP BY e.event_id

Categories: MySQL Tags: , , , , , ,

Facebook Like Status With Form And Comments

August 15th, 2011 Comments off

This is what I need done for this project:

Statuses: (Needs to be css/jquery based.):
See Picture: http://screencast.com/t/Wy1ZP110O
-Display status comment box.
-Display status comments.
-Status & comments limited to 140 characters.
-Removable status.
-Removable status comments.
-Status and status comments showing timestamp in the format of seconds to minutes to hours then just showing the date.
-Website address in a status or status comment parsed as a clickable link instead of just plain text.

This is what my current status looks like:
http://screencast.com/t/grrzoem8

The user that gets a status or journal comment needs to be sent an alert/notification like this:
http://screencast.com/t/Y1lngoa7hxV

I need the alert/notification to take the user to a page that shows the status or journal that had a new comment, on this page i need status comment form, and comments to show.

User Status streams (Basically where all statuses posted by a specific user show. Needs to be css/jquery based. This page needs to show 30 status results, and be viewable by other members.):
-Display status stream comment box.
-Display status stream comments.
-Stream status & comments limited to 140 characters.
-Removable stream status.
-Removable stream status comments.
-Status and status comments showing timestamp in the format of seconds to minutes to hours then just showing the date.
-Website address in a status or status comment parsed as a clickable link instead of just plain text.

Journals(Bulletins) Needs to be css/jquery based.):
-Display journal comment box.
-Display journal comments.
-Removable journal comments.
-Journal comments limited to 140 characters.
-Comments showing timestamp in the format of seconds to minutes to hours then just showing the date.
-Website address in a journal or journal comment parsed as a clickable link instead of just plain text.

Things that need fixing:
-top_8.php (make selected friends show on every page.)
-edit_pics.php (add pagination showing 12 results per page.)

The script that needs this modification is located at http://friendalicious.com

Facebook Like Status Comments

August 15th, 2011 Comments off

I need a Facebook like status form with comments, This is what my current status form looks like:
http://screencast.com/t/grrzoem8

Here is a print screen of what needs to be added:
http://screencast.com/t/ub4jeCp2yQ
(Also the statuses you post as a user need to be removable.)

The status comment needs to be limited to 140 characters.

If you were to add a link to a website in your status or a status comment i need that link to be parsed as a clickable link instead of just plain text.

All previously posted statuses of a user need to show as a stream that is viewable to their friends, this page also needs to include status, and status form with comments.

Time stamps for status comments need to show in the format of seconds to minutes to hours then just showing the date in which it was posted.

If you were to comment someones status, i would like the user YOU or whoever you comment will receive a status comment notification, that notification needs to show like these notifications. http://screencast.com/t/Y1lngoa7hxV

Once you view the status mentioned from the notification with the new comment, this will need to be what shows. (basically taking you to the one status that received a new comment.)
http://screencast.com/t/Wy1ZP110O

I would like journals/bulletins to allow users to add comments
http://screencast.com/t/JWYKwXCOR2l
possible unused existing code add_comment.php and add_comment1.php

Time stamps for journals/bulletins comments need to show in the format of seconds to minutes to hours then just showing the date in which it was posted.

EASY FIXES
The manage pictures page needs pagination showing 12 pictures per page in edit_pics.php

When visiting a new page in top friends, selected top friends do not show/follow to next page in top_8.php

The script that needs this modification is located at http://friendalicious.com

Apple Warranty Status Checker

August 2nd, 2011 Comments off

I’d like to build a front end script that uses Apple’s GSX API and allows a user to enter their computer serial number and returns some specific information. We already have the basic functions of the API integrated to other parts of our site, so you don’t have to start from scratch.

The functions are basically a duplicate of Apple’s warranty checker at https://selfsolve.apple.com/agreementWarrantyDynamic.do. You can use serial number W89391JR64C in the query field to see the results.

The API documentation can be found here – http://gsxwsut.apple.com/apidocs/html/WSHome.html. See the API section for Apple Authorized Service Providers -> Repair Creation -> Warranty Status.

Once the serial number is entered the following parameters need to be returned-

serialNumber
warrantyStatus
coverageEndDate
imageURL
productDescription
configDescription

Facebook Status Update On Pages With Over 300k Likes

July 20th, 2011 Comments off

I am looking to buy Facebook status updates AND wall posts.

Requirements:

Fanpage of 300k + members/likes
Must be real fans and accounts
Fans must have over 50+ friends each

Message me with the details of the page, including the link and the price per blast.

Thank you very much for your time .

Need An Experienced Iphone Developer

July 16th, 2011 Comments off

Hello,

I need you to develop an iphone application, that has twitter and facebook login integrated.
The app will fetch friends status from facebook and twitter and display it in front of the user. The users can express their reactions on this status which will go to our database. (we will provide api).
Users can see all their friends reactions in our app. There are few more things that I will discuss to selected providers only. But there are about 5-10 other request other than mentioned here.
Remember we need paging for everything, there may be 100 people expressing their moods on a status. (Our api will have paging which you will need to implement, in the app).
This is a very high quality design app, for which we will provide you screenshots of the design. NDA will be required. Please provide an approx budget. Please drop some links to the apps you have developed.

Thanks for bidding.

Rich Media Ad Builder.

June 13th, 2011 Comments off

Windows compatible program to export PNG images. Content of the image consist of 5-6 things. 4 texts and/or couple of pictures.
These images are to be used as banner ads for online advertisement.
Similiar to “google display ad builder” just that I need PNGs and gifs.
Or you can go to 4delite.com
I want a program that would automate the ad builder. Example, the following combinations of the input text and/or image.
Here, we input 3 headlines and some expansion of the

headlines(sh_)(can be text/image or both), image and some text(cta_) and we get these combinations as the ouptut.
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status
headline,description 1, description 2,display url,destination url,ad status

1. User inputs the text and sets the various text settings (like font, font size and all). It should be able to install some text fonts also.
2. User inputs the content_images (1 small and one for background) from the local disk.
3. Background may be chosen as of some particular colour.
4. Once these details are entered, 5 types of size(180X150, 300X250, 160X600, 120X600, 728×90, 315×300) are displayed and user can do minor adjustment (like placement and highlighting of text/content_images) in individual images and then export PNG and GIF with one click.

P.S. A sample image is attached.

WordPress Widget Needed

June 8th, 2011 Comments off

**PLEASE** Read all BEFORE placing bid

I am looking to have a custom (meaning original coding…no copies) widget/plug-in to be created for my wordpress sites.

The widget should feed from my facebook account OR the facebook account of my choice.

THe widget display a profile pic, and my 3 most recent status updates or wall post (post put on my wall by me).

The widget will also display my name as seen on the Facebook account along with my friend count (friend count display should be optional)

People should be able to like my status…meaning the like button should display near my status so others can press the like button, sign into their Facebook account, and official like and share my status.

This widget should be compatible with Facebook Fan pages as well as personal profiles…at the very least Facebook Fan pages.

Attached is a pic of how the final widget may look.

Again this coding needs to be original, no copy. This plug-in should be able to be used on serval sites of my choosing and I should be able to determin which fan page or personal page I wish to associate the widget with.

Please address all questions via PM. If you are new and currently do not have feedback, please do not apply at this time.

Samples of past works dealing with plugins and widgets are appreciated!

Install Status.net Open Source (twitter Clone)

June 2nd, 2011 Comments off

Install latest stable release of status.net open source (twitter clone) found at http://status.net/statusnet-0.9.7fix1.tar.gz

- tweak website parameters for performance and security
- exclude unrelated postings from other status.net installations
- would like to increase the size of postings from 140 to 250 characters. Need to know the ramifications.
- brand the site with a provided logo
- verify status.net open source desktop and mobile apps work with the installation

An intro landing page is ready to be linked in.

Before bidding, please review the installation notes, installation forum and desktop/mobile apps at status.net

Preference given to responses citing social media experience.

Cs Cart 2.14 Modification & Add On

May 17th, 2011 Comments off

Modify CS CART Professional and create add ons for clickatell SMS notification, Escrow Service & Delivery service.

I will need to transform CS CART into an Escrow & Courier Service website.

I will be creating a few products and services in the website ex:
1. Escrow Payment Service
2. COD within Metro Manila
3. Manila to provincial
4. Provincial to Manila COD

When people click any of the following services there will be a an option during the checkout process to ask if that option they choose is for escrow payment services or delivery

[For the Escrow Service]
If it is Escrow service they will need to input the following info for the receiver:
1. Email address
2. Mobile number (sms will be sent by clickatell)
3. Bank account info or money transfer:

Job Status Form 2

May 4th, 2011 Comments off

Need to make a form that when fields are filled out they can submit changes and the form update the mySql DB. (I have all the form fields it is a total of 12 fields)

For Example if field one and two are field out they can hit update and update the DB, the info they filled out in the fields one and two stay grayed out until they fill out the last field and once submitted the fields clear and the DB gets fully updated.

Also Need for the form to be able to send out an email to 2 different emails every time the form is updated.

Need an admin section where it will list the fields as they are updated and also be able to delete any section if need to.
Each time the form is completed the db starts a new table.

If any questions I will be available for them.

Thank You

Job Status Form

May 3rd, 2011 Comments off

Need to make a form that when fields are filled out they can submit changes and the form update the mySql DB. (I have all the form fields it is a total of 12 fields)

For Example if field one and two are field out they can hit update and update the DB, the info they filled out in the fields one and two stay grayed out until they fill out the last field and once submitted the fields clear and the DB gets fully updated.

Also Need for the form to be able to send out an email to 2 different emails every time the form is updated.

Need an admin section where it will list the fields as they are updated and also be able to delete any section if need to.
Each time the form is completed the db starts a new table.

If any questions I will be available for them.

Thank You

Install Status.net Open Source Micro-blog

April 20th, 2011 Comments off

Install latest stable release of status.net found at http://status.net/statusnet-0.9.7fix1.tar.gz

Database is private to the extent that unrelated postings from other status.net installations do not appear at this site.

Would like to increase the size of postings from 140 characters. Need to know the ramifications.

Brand the site with a provided logo.

Present users with an intro page on which I will populate with a welcome message and directions. Pressing ‘proceed’ at any time will execute the status.net application.

Verify status.net desktop and mobile work with the installation.

Customize And Install Server Status Script

April 18th, 2011 Comments off

Want to show server dedicated status:
HTML
SSL
SSH
FTP
POP
IMAP
Load
a few other things I’m forgetting right now.

Load indicator must be graphical and move real time.

Website Generates Too Many Slow Mysql Queries

April 15th, 2011 Comments off

Website generates too many slow MySQL queries. Here are some of them:

Executed 2 min ago for 15 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1034′ order by pd.products_name limit 0, 15
Executed 2 min ago for 13 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’119′ order by pd.products_name limit 0, 15
Executed 2 min ago for 14 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1222′ order by pd.products_name limit 0, 15
Executed 2 min ago for 11 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1236′ order by pd.products_name limit 0, 15
Executed 1 min ago for 12 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1116′ order by pd.products_name limit 0, 15
Executed 1 min ago for 12 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1236′ order by pd.products_name limit 0, 15
Executed 1 min ago for 11 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’1940′ order by pd.products_name limit 0, 15
Executed 0 min ago for 11 sec on Database –> cardboar_db1.
select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = ’1′ and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = ’1′ and p2c.categories_id = ’132′ order by pd.products_name limit 0, 15

You need to optimize the MySQL database. You can check this tutorial for more details how to do this:

http://www.developer.com/db/article.php/3667831/Four-Ways-to-Optimize-Your-MySQL-Database.htm

Realtime Status

April 7th, 2011 Comments off

Please see pmb for details about project….

Myspace Status Bot++

March 8th, 2010 Comments off

I need somebody that can make a myspace bot script
that will be able to send out bulletins & post status ect
i want it to run though my site, if you think your up for it bid :)

Chatroom

February 26th, 2010 Comments off

I need a code to write me a chatroom, so please read completly before bidding.
I will not put an escrow down or anything. I will only pay when project
is completed. If you’re not ok with that, proceed to the project description.

I’m looking for a php coder to write me a script that can do the following:

A chatroom where Female Members can join for FREE and Males gets a 24 hour
free trial.

Once signed in, male and female member will be prompted to write a “Status Update”
statement indicating what he or she is looking for.

MALE MEMBERS
————
Males user gets taken to the Female Chatroom to chat where he can browse female
members and read their status updates in the room. Should he find someone he likes
he can do either of the following:

1) Send her a short message (The inbox options should be: Read, Delete, Save, Report)

2) Request a live chat (Options: Accept, Decline, or Decline w/a message)
*If so he will be chatting privately, one on one with her via an IM like interface.

3) Move on to the next user, by pressing “Next” (Options: Next, Block, Flag, Report)

5) Update own status update

FEMALE MEMBERS
————–
Females user gets taken to the Male Chatroom to chat where she can browse male
members and read their status updates in the room. Should she find someone she likes
she can do either of the following:

1) Send him a short message (The inbox options should be: Read, Delete, Save, Report)

2) Request a live chat (Options: Accept, Decline, or Decline w/a message)
*If so he will be chatting privately, one on one with her via an IM like interface.

3) Move on to the next user, by pressing “Next” (Options: Next, Block, Flag, Report)

5) Update own status update

Each Members should be required to upload a Picture to their profile and their
profile will comprise of the following:

1) Status Update (Short Bio)
2) Up to 3 Pictures
3) City, State and Zip Code
4) Area code
5) Gender (M, F, TS)
6) Sexual Orientation (Straight, Bi, Gay, Lesbian)
7) Marital Status (Married, Single, Divorced, Separated)

**Males Members will be restricted by IP address for their 24 hour trial period.
Beyond the 24 hour trial. Male members will be required to signup using 2Checkout and Paypal.

**Status update: A short message describing what that particular member
is looking for.

ADMIN AREA
—————–
1) Admin will have to approve memberships, photos and profiles. (W/Options to set on automatic approval)

2) Admin can set duration of FREE trial and also reset IP Log to allow Previous Free Trial Users another shot
at a FREE trial in the future.

3) Admin can view and or log in as members

4) Admin can add single user and or bulk via a csv/text/spreadsheet file.

5) Admin can set membership price for the guys/girls and decide whether girls join for FREE or for a FEE.

6) Admin can block, deny, accept, upgrade, edit and delete membership.

7) Admin can email members, send newsletter and setup automatic emails to inactive members.

8) Admin can turn off site for maintenance

9) Admin can filter bad words.

10) Admin can block by IP address, Email and or Username.

The chatroom should be very simple and easy to use. No bloated graphic, just plain with a generic logo on top.
I need someone to do this fairly quick in php and mysql. Please read my project again carefully and make sure you
can do this before bidding.

Good luck!!

Status Updates Status

February 22nd, 2010 Comments off

Status updates as agreed earlier…

Twitter Status Update Bot

February 19th, 2010 Comments off

We need a script hosted on our webserver (php5/mysql)

Drupal Form-product Fixes

February 18th, 2010 Comments off

Overview
We require a Drupal programmer to fix the following for our classifieds listing site.

* We have an existing listing forms, Ubercart checkout payment process and processing workflow for the forms.
* Our objective for this project is to have a price for listing per country.
* Ensure user login/join and redirect back to form is enabled
* Ensure that current module for form status works as previously coded
* Do some small fixes to the forms (see screenshots) and remove the basic/premium taxononomy.
* Create system generated emails for user/admin for payment and status of listing
* Create admin page/view to show listings, status and edit link

See attached for more information. No escrow is preferred (see our excellent scriptlance rating)

When you bid PMB me only 1 previous project. Please ask questions any questions via PMB.

Thanks in advance and best wishes bidding.
svconcepts

Appointment Request System

February 3rd, 2010 Comments off

Hello,
we have to set up an appointment system for a nonprofit organization where users should ask for a medical appointment. Is not like an hotel booking system, this not require an availibilty or a calendar. How should works:

Public section:
1) user see a list of services, like dentists, blood donations, ecc.
2) user click on one of the service and see a list of city where this service is available
3) user click on a city and should fill the form
4) the form must have fields like: name, surname, address, phone, email, privacy acceptance (required fields) and other optional fields (health id card, a text note field), and a simple captcha. And with error messages system while compiling the form.
5) when the form is filled and sent, an email should be sent both to user and to admin

Admin section:
1) all appointments requested should be stored into a table that could be printed (or exported). The requests should be ordered by name, or by date or by city.
2) more operators should login to the admin area
3) in this table, admins/operators should have a field where they should update the status of the request: the operator should select from 2 status ( “to do” -default- or “done”) and put a text note. If the operator “john” change the status, a column will show “status changed by john on date..)

Some notes:
This administration will be used by volunteers that do not have an high pc skill, so easy use is required
Hosting: linux, with mysql
After some test, maybe the volunteers should ask for some little improvements at the script. I remember you: is a non profit organization and this system should help the volunteers, so an easy administration is required and.. please do not ask high prices :-)

For any question do not hesitate to ask
Thanks

Travian Online Status Script

February 2nd, 2010 Comments off

I am interested in a script simillar or identical to these two:
http://www.scriptlance.com/projects/1189027104.shtml
http://www.scriptlance.com/projects/1191339052.shtml

I repost their description.

Me and my “clan” plays a free online game, travian.com (Travian).

I want a script that will view the “activity” status (which is given by the game/Travian) of those within my “clan”/”alliance” and create reports based on their status, which I wish the script to check every 10 minutes. However, to “see” or access this status listing (which is a constant URL by the way) I need to be logged in. So, naturally, I assume this script would have to “log in” to the website/game using my login information. This scares me a little, as I believe then this login information would have to be stored on my webspace, so I would appreciate if this could be made secure so that not anyone can “phish” this information from my webspace.

The file I have attached is a print screen of the online status I can see in the clan. Take note of the dot images beside everyones name.
blue = online
green = was online in the past 24h
yellow = was online in the past 3 days
red = was online in the past 7 days
grey = wasn’t online in the past 7 days

My main concern is only whether it’s a blue or green dot anyway, so I suppose any other image file name is irrelevent.

What I want your script to do is login under my username and password every 10 minutes and “record” in a small MySQL database what their percentage activity is in a 24 hour period. Since the script should be checking every 10 minutes, it will check the players status 144 times in a 24 hour period (there are 1440 minutes in 24 hours, but it is checking only every 10 minutes, so 1440 / 10 is 144).

Lets assume the player is active (ie. b1.gif) 30 times out of the 144 times your script checks the online status of the players. The HTML output of your script would display that player as having an activity of 20%, because that player was active 30 times out of the 144 times their status was “checked”, which would be they were “active” 20% of the times. So your script should record in the MySQL database how many TOTAL times the player was checked to get an OVERALL activity percentage -and- should record how many times they have been checked for the “new day”. User my webservers clock to determine when a “24 hour period” is done/over with.

Things I want to see in the statistics:
% online time every day, player/s and total clan
amount of players online at a time and list on who it was

The output of your script does not have to the pretty, however, it should be formatted so that it is readable/ledgible with ease (ie. it doesnt need fancy pictures or colors, just make it ledgible). The output should be alphabetized by the players name since the members in the clan can change, then it would be great if the script can read there names and record online stats to it.

Windows Media Services Plugin

January 21st, 2010 Comments off

Hello,
I am in need of someone that is extremely competent with Windows Media Services, and C#, C++, php, mysqul, or the VB.net framework.
I’ll let competent developers give me quotes. I will choose the one that looks the best.

Description: I need a Windows media server 2003/2008 32and64bit authentication Plugin which works with php script and mysql.
I must can host that script on multiple server, so basically i need user based security on mms /rtsp and http links (sample. rtsp://server/publishingpoint?u=username&p=password)
of streaming so user cannot steam my links only registered user can watch live stream. I do need full control on script to add user (name lastname addr…, users

connection,start and expiration. The pluging-script have to protect multiple conection of the same user and automatically deactivate the user account after expiration (account

status 0/1).

I need also a http form to add, remvoe, edit and list connected users from data base with manually enable/disable button to change status in the data base for individual user

account status 1 or 0 (on/off)

How it works:

* A user requests live stream:
mms://my.server.net/PublishingPoint?u=bob&p=secret
Note that when a user requests a livestream, username and password are passed in the URL.
* Authentication plugin will check the username (sample: bob) and password (sample: secret). This happens in the background on the server side so the user does not even

notice anything.
To authenticate the user, the plugin will go to mysql data base you define in the configuration file to check the user and his account status.( the mysql and webserver

does not run on the same sever )
If in the user and password exitst, the user not connected and account satus are active then, the plugin will start the stream and set the connect status to 1

(multi connect protection of the same user)
* if the userer leaves/close the stream the plugin have to change the connect status to 0

* Otherwise, the user will not be able to play the stream.

After finish the project you have to deliver the wms plug-in with all associated scripts, detailed-comprehensible installation guide and complete sorce code.

PAYMENT: We will deposit 25% of the job in escrow using the escrow account system provided on this site. Another 10% after receiving the WMS plugin with the capability to

protect live streams. The Remaining balance will be paid after the final approved project is delivered, installed, approved and in FULL operation

Modifications reserved.

Website + Cms + Order Status

January 11th, 2010 Comments off

Website redesign (with template for main page and internal page) + cms to manage website with support for multiples language, with option to manage different types of users (administrator: total access, manager: fill contents, customers: website + check order status) + admin module to fill information about delivery status of orders + customer module to check the delivery status of their order

Programming Project 1263062318

January 9th, 2010 Comments off

I need errors fixed in my coding my host is saying. please bid if you have experience in field and can fix all errors im running into. maby a diagnostics can be ran so all errors are resolved in code….i do not want anyone that wants to get payed before errors are fixed. i had a programmer who said can do it and after he got in said everything looks fine. after errors resolved i will gladly pay… below is wut host said and under are 2 main error messages i am receiving on 2 different sites

This error is caused by the query you are running in the screenshot not completing in time when writing to the MySQL database which in turn is using too many resources which is then terminated before it continues to cause a high load on the server.

http://www.cheapjordans23.com/productsnew.php

1053 – Server shutdown in progress

select distinct p.products_id, p.products_date_available, p.products_date_added, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_status = ’1′ and p.products_id = pd.products_id and pd.language_id = ’1′ order by p.products_date_added desc limit 40

[TEP STOP]

—————

http://www.jordansnyc.com/productsnew.php

1053 – Server shutdown in progress

select distinct p.products_id, p.products_date_available, p.products_date_added, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id, products_description pd, products_to_categories p2c, categories c where p.products_status = ’1′ and p.products_id = pd.products_id and pd.language_id = ’1′ order by p.products_date_added desc limit 9

[TEP STOP]

2013 – Lost connection to MySQL server during query

select count(*) as total from sessions where sesskey = ’5ce9e931df00fd34478995d50783f3cd’

[TEP STOP]

Status – Facebook Application

January 7th, 2010 Comments off

Hi,

I need a simple fb app clone..well 3 app clone in one app:

status shuffle + status statistics + status symbols

main app over here is status shuffle, and other 2 apps are much more simple. If you check these apps you will see that it is not time consuming task for an experienced programmer. Therefore, I think 1 week is enough for full development. Details will be discussed on PMB

I need this to be implemented with .Net 3.5/4, C#, VS 2008, MS SQL, Linked to Entities as a repository layer, n-tiered architecture.

Pdshop Editing

January 2nd, 2010 Comments off

I am currently using PDShop Classic. I am thinking of buying PDShop Version 8 but would like to know if someone can do the following:
In the storefront:
– I would like to add 15 more custom fields – I think it only comes with three.
– Allow users to login and cancel their order if they would like.

In the admin:
– I would like to not allow some orders to be canceled if I choose because they may contain special order items.
– I would like to automatically send a custom email depending on what status I change the order to. In other words, when I change the status from ‘New’ to ‘Shipped’ an automatic shipping notification will be sent to the customer including order details. When I change the status from ‘New’ to ‘Canceled’ an email will be sent stating the order has been canceled. Orders would be canceled for a variety of reasons so I would need a dropdown box giving me a choice of reasons to cance and also be able to add reasons to the dropdown box. If I change the status from “‘New’ to ‘Backordered’ I would like an email sent out to the customer stating that certain items in the order are backordered. etc, etc.

Please let me know if there is any interest for someone to do this and what the cost would be. Experience in PDShop preferred.

Thank you.

Install Status.net

December 16th, 2009 Comments off

I finding someone who can install status.net script in my vps server from hostgator.com level 1 (http://www.hostgator.com/vps-hosting/). Including install any extension to linux to make the script running fine and complete every functions. I don’t know how to customize server and script working properly.So I want someone to make it perfect.

Status Button In Flash

December 16th, 2009 Comments off

I have a flash site, I need to insert an html code for a status button, similar to yahoo and msn, into the flash file. I do have the fla files just not sure how to use html in flash.

Bear