Finalizat

Cron jobs - sortare mysql

Am o baza de date cu un numar infinit de tabele.

coloane :

- id : varchar(256)

- message : text

- l_name : text

- l_type : text

- link1 : text

- link2 : text

- date_published: datetime

- nr_hit1 :text

- nr_hit2 :text

- nr_hit3 :text

- nr_hit4 :text

- nr_hit5 :text

- nr_hit6 :text

- nr_hit7 :text

- nr_hit8 :text

- nr_hit9 :text

Am nevoie de un script pentru a sorta constant (deci probabil

cron job) toate tabele in functie de anumite configurari per

tabela. Pentru config se poate face ori front-end ori back-end,

nu ma intereseaza asta momentan.

Ce vreau sa faca mai exact :

- la fiecare rulare vreau sa stearga toate intrarile mai vechi de

X zile

- daca intrarea din orice tablea are valoarea [AAAA] (se ia din

config) in coloana l_type: OK, daca nu, ignore

- daca intrarea din orice tablea este mai veche de X timp

(valoarea va fi luata din config): ignore

- daca intrarea din tablea se afla in intervalu de timp stablit,

si nr_hit1 sau nr_hit2 sau nr_hit3 se afla intr-un interval

stabilit in config atunci vreau sa o trimit intr-un rss-feed +

intr-un rss separat cu numele tabelei

Exemplu config :

Tabela 1 :

- Daca l_type = AAAA: OK

- daca a trecut mai mult de [60 min] de la publicare : ignore

- daca are min nr_hit1 [606] : OK

- Daca are min nr_hit2 [807] : OK

- Daca are min nr_hit3 [444] : OK

Tabela 2 :

- Daca l_type = AQXC: OK

- Daca a trecut mai mult de [33 min] de la publicare : ignore

- daca are min nr_hit1 [107] : OK

- Daca are min nr_hit2 [420] : OK

- Daca are min nr_hit3 [512] : OK

Rss feed :

<a href="$link1">$l_name</a>

Aptitudini: MySQL, PHP

Vezi mai multe: work from home php mysql developer jobs, mysql freelance jobs, web developer cms system wordpress php mysql gauteng jobs, mysql reminder script cron job, mysql synchronize database cron, php mysql sample jobs site, php mysql online jobs, php mysql intern jobs, mysql data import cron, mysql cluster jobs, mysql sql script cron, mysql import csv cron job, mysql csv cron jobs, mysql cron jobs, shirt designing software, network analyzer software, seller pro software vista compatible, flight reservation software project, sample good software instructions, customer software needed

Despre angajator:
( 0 recenzii ) Oradea, Romania

ID Proiect: #13311762

Acordat lui:

racasanucrinel

Salut. Te pot ajuta cu acest proiect. Trebuie facut un modul ceva pentru un script deja existent, sau se face totul de la 0? Astept mai multe detalii pe privat.

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% EUR în 2 zile
(1 părere)
1.6

3 freelanceri licitează în medie 177€ pentru acest proiect

bestit4u

Hi,I'm very very interested in your job. I have enough experience for this job. I wanna work for u. If u award me, i can finish this job without fail. Please send me message. Thanks...

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(9 recenzii)
4.6
graphichaks24

A proposal has not yet been provided

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(16 recenzii)
1.8
JustinLee890410

It’s my specialty. Hi, my friend. You selected the right man! I’ve been developing programs more than 10 years. Don’t lose your time anymore Call me asap Best regards Thx

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(3 recenzii)
1.5
bsoni3891

We make sure we understand exactly what it is you need and then provide you with the dedicated IT offshore development center or a IT team of just a few developers best suited to meet your [login to view URL] have specialists of Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(2 recenzii)
0.0