Hello,
Site: [login to view URL]
Queries are like:
$games = ORM::for_table('games')
->table_alias('g')
->select('g.*')
->select('[login to view URL]', 'league_name')
->select('[login to view URL]', 'home_team_name')
->select('[login to view URL]', 'away_team_name')
->left_outer_join('leagues', 'g.league_id = [login to view URL]', 'l')
->left_outer_join('teams', 'g.home_team_id = [login to view URL]', 'ht')
->left_outer_join('teams', 'g.away_team_id = [login to view URL]', '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.