Find Jobs
Hire Freelancers

Query mysql, send values to a web page, write output to mysql

$30-250 USD

Completed
Posted about 10 years ago

$30-250 USD

Paid on delivery
The page you will be posting to does not have captcha but is very dependent on cookies. Please only bid if you have experience with perl, shell scripting or something similar. You will only be given ssh access, there will be no ftp access. Here is a brief on the project, expect that there will be 50% more fields involved in the final product script should add fields that do no exist yet but are needed. calll script like [login to view URL] [ip] [db] where ip and db name can be variables table2 table3 < this db is based on what called when script is called table4 select table2.gsm_number,table3.cp_topup_amount where table3.balance_date > now() - 2hours and table3.balance+0< table3.minimum+0 and table3.cp_auto_topup_amount >0 and [login to view URL]<>201 and table2.gsm_number >0 where table3.tries+0 < table3.warn+0 a few entries will come up like 8884455 1 7878542 2.30 4875454 3.21 go to url login with credential from table4 (if login is requested) click on the appropiate link fill in the number and amount retrieved from query above and login code from table4 update table4.last_script_run_datetime=now() for the value you used result can be like TopUp: $600.00 Total: $797.71 Phone: (888) 444-55 update table3 set balance=balance + TopUpAmount, set tries=tries+1 table3.last_topup_date=now() table3.last_topup_value= the amount posted table3.historic_topups=historic_topups+TopUp insert into table5 id,dateandtime,loginused,numbersent,amountsent move to next item other error can be something else, in that case, ignore, move to next entry there is an error that warns you that you do not have sufficient balance when you see that update table4 set balance=amount displayed where id=id you were trying to use timeout and move on to next item if no reply in 60s
Project ID: 5843726

About the project

15 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, this is really easy project for me: I can complete it in less than a day and I can offer you best price here. Please show me target site so I can check everything. Also to start I need 50% milestone payment and 50% after you'll check everything on your side. Thanks. Roman
$55 USD in 1 day
5.0 (474 reviews)
0.0
0.0
User Avatar
Hello. More 20 years programming experience. Have done similar many times - I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$100 USD in 5 days
4.5 (41 reviews)
0.0
0.0
15 freelancers are bidding on average $165 USD for this job
User Avatar
hey, i am pretty interested in doing this job for you, i have read the details and would like to do it
$246 USD in 3 days
5.0 (6 reviews)
0.0
0.0
User Avatar
Please Send a message to talk about details and do a best offer.... We are a group of engineers from various areas with over 15 years of experience solving critical problems in the area of database management systems, electronics and Python-C++-mt4 programming, as well as also specialists in the design and maintenance of websites, networks and all kinds of servers. We will be glad to help you with this project for a reasonable price, a good rate and a nice comment, we understand that we are at a disadvantage becouse we have not reputation on this site, this is why we give you a promotional price until climbing positions, by the way, if you send us a private message we can evaluate better your project details. We appreciate your concidere, we always looking for the solution, G.B. IT Manager ----------------------------------------------------------------
$113 USD in 1 day
3.6 (2 reviews)
0.0
0.0
User Avatar
Hi Sir, I am ready to work for you.I have 4 years of experience in C/C++/Php/C#/sql. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please visit my profile once. Thanks with regards, Arpit
$100 USD in 3 days
5.0 (31 reviews)
0.0
0.0
User Avatar
Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$309 USD in 2 days
5.0 (890 reviews)
0.0
0.0
User Avatar
Hi, I can do that using php, ssh Let us start ......................................................
$211 USD in 2 days
5.0 (190 reviews)
0.0
0.0
User Avatar
Hi vjfromgt, I'm well versed in Perl, shell scripting and MySQL. I can be reach at skyep (freelancerforhire80) for further discussion if needed
$222 USD in 5 days
5.0 (63 reviews)
0.0
0.0
User Avatar
Hello Sir, I am an expert in web scraping (ranked #1 for Web Scraping https://www.freelancer.com/freelancers/skills/Web_Scraping/). I have done many similar jobs. Please provide the details. Thanks, Alex
$177 USD in 3 days
5.0 (193 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
dix hills, United States
5.0
92
Payment method verified
Member since Aug 24, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.