Add few minor functions to existing site -- 4

Ακυρώθηκε

Περιγραφή

Hello,

Site: [url removed, login to view]

Queries are like:

$games = ORM::for_table('games')

->table_alias('g')

->select('g.*')

->select('[url removed, login to view]', 'league_name')

->select('[url removed, login to view]', 'home_team_name')

->select('[url removed, login to view]', 'away_team_name')

->left_outer_join('leagues', 'g.league_id = [url removed, login to view]', 'l')

->left_outer_join('teams', 'g.home_team_id = [url removed, login to view]', 'ht')

->left_outer_join('teams', 'g.away_team_id = [url removed, login to view]', 'at')

->where('id', $id)

->find_array();

What need to be done,

1. Index to: Featured games mixed from both DBs - tennis and soccer and ordered by GMT.

Now is: Query Soccer -> Display, Query Tennis -> Display

To be: Query Tennis + Query Soccer -> Merge results and Sort by start_time -> Display sorted

2. Index to: Have a simple .php which is checking: Is there X games/per sport featured games on Index? If not auto-change Featured from 0 to 1 to fill up to X games, on games where Best Odds are from diff bookies /there is written function for this/. E.g. check if there are enough games marked as Featured, if not - mark some

So by this always to have featured games on Index

Include word "spesse" into bidding, otherwise your bid will be ignored.

3. Compare and match names: In DB players are with their full names:

Like: Aleksandra Wozniak

But same bookie could write it, Aleksandra Wozniak, A Wozniak, Al Wozniak, Wozniak, A. Wozniak or Al. Wozniak

E.g. Just code for matching names. Code for create/update game is existing.

4. Adding a timestamp to Odds table - on time of creation or updating and then on Showing games on Index or other places - if timestamp if <X minutes - add text "Outdated Odd" and then Odd

e.g. Add additional field in DB and implement it in 3 code files for inserting and showing.

Δεξιότητες: PHP

Δείτε περισσότερα: site built wordpress need add blog, creating wap site existing, cms flash site existing, clone site existing database, add live sport scores website, joomla migrate existing site existing website, create wap site existing website, merge joomla site existing html site, edit existing swf file add link, modx site existing, attaching joomla site existing site, replace existing functions javascript, site existing site, dunamic web site existing project vbnet, wordpress copy site existing

ID Εργασίας: #11800641

5 freelancers κάνουν προσφορές με μέσο όρο $61 γι' αυτή τη δουλειά

krishan725

Acceleregenius have unique processes that allow us to offer superior value in terms of creativity, quality, speed, and price. We are a Team with 15+ highly skilled Designer and Developer with over 4+ years of experie Περισσότερα

$166 USD σε 5 μέρες
(11 Αξιολογήσεις)
4.3
huangxiaoxuan23

Dear Thank you for your posting. I've just check this link : http://spotodds.com I'm a PHP developer and I'm very interested in your job post. I've more than 7 years Website development Experience. And I am av Περισσότερα

$50 USD σε 1 μέρα
(10 Αξιολογήσεις)
3.6
fhwszsqnlv

Hope you are doing great! I am approaching you in an attempt to initiate a discussion between you and Gropse IT Solutions . I would be interested in discussing the projects with you . Please let me know a conven Περισσότερα

$35 USD σε 1 μέρα
(5 Αξιολογήσεις)
2.4
hyadesfreelancer

PHP,PDO, Core-php, CakePHP, CodeIgniter, Laravel, Yii, Mysql, HTML, HTML5, CSS, JavaScript, Angular js, jquery, AJax, Joomla, E-Commerce Wordpress, Woo-commerce, Open-cart And BUG FIXING etc. When we work for clie Περισσότερα

$30 USD σε 0 μέρες
(4 Αξιολογήσεις)
2.2
Amitjn55

Hi there, An experienced team of Designers & CorePHP, Magento, Wordpress (Woocommerce) Developers here to assist you. Please feel free to contact us anytime to discuss your project. We look forward to working w Περισσότερα

$25 USD σε 2 μέρες
(1 Αξιολόγηση)
0.4