Thread: Add-On Releases - European Cup 2008 Bet Game
View Single Post
  #99  
Old 06-17-2008, 03:43 PM
Fraxter Fraxter is offline
 
Join Date: Jul 2007
Posts: 158
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No sql table, the group table calculation (A-D) was wrong. Take a look into your tables and you will see that for example switzerland before czech is display (thats wrong).

If you have translated your em2008.php file, you can change it manuell with this:

Find:

PHP Code:
$sql "SELECT t.name, t.shortname, t.groupname, gs.match_played, gs.won, 
                    gs.drawn, gs.lost, gs.goal_plus, gs.goal_minus, gs.goal_diff, gs.points 
                    FROM " 
TABLE_PREFIX "rth_em08_teams AS t 
                    LEFT JOIN " 
TABLE_PREFIX "rth_em08_group_scores AS gs ON ( t.team_id = gs.team_id ) 
                    ORDER BY t.groupname, gs.points DESC, gs.goal_diff DESC, gs.goal_plus DESC"

Replace with:

PHP Code:
$sql "SELECT t.name, t.shortname, t.groupname, gs.match_played, gs.won, 
                    gs.drawn, gs.lost, gs.goal_plus, gs.goal_minus, gs.goal_diff, gs.points 
                    FROM " 
TABLE_PREFIX "rth_em08_teams AS t 
                    LEFT JOIN " 
TABLE_PREFIX "rth_em08_group_scores AS gs ON ( t.team_id = gs.team_id ) 
                    ORDER BY t.groupname, gs.points DESC, gs.goal_plus DESC, gs.goal_minus ASC"

That?s all. Only a little sql query bug.

best regards

Pander23
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01305 seconds
  • Memory Usage 1,776KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete