Concluído

Write 2 shell script to be called by cron

Script 1

select goipid,time,msg from receive where msg like string found in auto_ussd.z_bal_string and time > than the last time the script was ran

mysql> select goipid,time,msg from receive where time >'2016-05-07 10:15:00' limit 5;

+--------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------+

| goipid | time | msg |

+--------+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------+

| 121 | 2016-05-07 10:15:49 | Vous avez 100 MB d'internet, valide jusqu'au 05/06/2016 00:00:00. 0 Fcfa valable tous reseaux et valide jusqu'au 11/05/2016 20:13:17. |

| 73 | 2016-05-07 10:15:51 | Vous avez 100 MB d'internet, valide jusqu'au 05/06/2016 00:00:00. 496 Fcfa valable vers expresso et valide jusqu'au 05/06/2016 00:00:00.

1.

currently

mysql> select z_bal_string from auto_ussd limit 1;

+---------------------------------------+

| z_bal_string |

+---------------------------------------+

| 00:00:00. ? Fcfa valable tous reseaux |

this means that extract from the msg par the number to fill the ? mark (it has a space before and a space after)

update auto_ussd set

z_time, = now()

z_bal= the amount found for ?

z_date= value found for time

where receive.goipid=[url removed, login to view] and auto_ussd.name=[url removed, login to view]

END

Script 2

select name from auto_ussd where z_bal_date > last time script was ran AND z_bal < z_min and z_tries< z_warn and z_last_top_date is older than 15 minutes and z_enabled=’1’

CALL this SIM

select card from recharge_card where used='0' and recharge_card.prov_id=auto_ussd.prov_id limit 1

You will get a number like 12365464655

Log into with a username and password i will give you (simple login)

http://127.0.0.1/goip/en/[url removed, login to view][SIM]

insert into the textbox

auto_ussd_z_rech_code&card&#

currently z_rech_code is *222*

so you will enter

*222*12365464655#

and click send

Update [url removed, login to view] with the goipid and use_time=now()

on the next screen a message will be returned

If any part of that message contains the string found in auto_ussd.z_suc_msg

For that [url removed, login to view] set used=1 if a message is returned with some different values then set used=2

increment z_tries by 1

go back to

http://127.0.0.1/goip/en/[url removed, login to view][SIM]

delay random time between 5 and 50 seconds

input value of z_ussd_1 and send (if exist)

delay random time between 5 and 50 seconds

input value of z_ussd_2 and send

delay random time between 5 and 50 seconds

input value of z_ussd_3 and send

delay random time between 5 and 50 seconds

input value found in auto_ussd.auto_ussd and send

Do for all entries found

Update the last time the script was ran

Habilidades: Linux, Python, Shell Script

Veja mais: where do you get a python, extract number from string

Acerca do Empregador:
( 88 comentários ) dix hills, United States

ID do Projeto: #10436376

Concedido a:

markotitel

Hi, I can helpout but from job description as its output is not so clear I would like to talk to you. Kind regards

$60 USD em 3 dias
(54 Comentários)
5.3
ast3r1sk

Hello dear sir, i work with goip gateways: checks balance, update minutes limits and so on. So i can also write this scripts for you. Please contact me if you interested in .Thanks.

$133 USD em 3 dias
(8 Comentários)
3.9

12 freelancers estão ofertando em média $149 nesse trabalho

$210 USD in 3 dias
(33 Comentários)
5.3
waheni

Let s start working i am experienced with shell scripting and linux i can deploy this in your server

$55 USD em 1 dia
(9 Comentários)
4.6
rajeshpal007

Hello, I can do this. I have been programming in c, c++ and Linux for last 8+ years. I have developed many complex software's involving System Programming, Network Programming , Socket Programming,, Shared Memor Mais

$263 USD in 5 dias
(12 Comentários)
4.6
grtdeveloper

9.5 years in shell script , databases and crontab

$177 USD in 6 dias
(9 Comentários)
4.3
elbruninh

Hi, i'm interested, i can do it with php (you can to run the php script by cron) using php would be more easy login to [login to view URL][SIM] let me know if you are interested if s Mais

$150 USD em 1 dia
(2 Comentários)
3.4
djuranovski

python script would be ok ?

$100 USD in 5 dias
(9 Comentários)
3.0
yFiru

I am well experienced with python scripting + obviously running linux on my pc. What you are asking for doesn't sound too hard / time consuming, I believe I can make it done in 2 days. I still might need further clarif Mais

$60 USD in 2 dias
(0 Comentários)
0.0
$155 USD in 3 dias
(0 Comentários)
0.0
adas24

A proposal has not yet been provided

$222 USD in 2 dias
(0 Comentários)
0.0
manu50

I am a software developer with 10+ years of experience in web/mobile applications development. Based out of the Silicon Valley, I have worked for many startups. Some of them are [login to view URL] and [login to view URL] I a Mais

$200 USD in 8 dias
(0 Comentários)
0.0