Viewing 3 replies - 16 through 18 (of 18 total)
  • Thread Starter drsack

    (@drsack)

    I apologize. Under league manager I see folders labeled; “admin, css, images, languages, lib, sports, templates.” Can you tell me where to look for the column names of the tables.

    Plugin Author K

    (@koelle)

    Maybe it’s easier this way. Copy the following code to your functions.php

    function showDatabaseColumnsLeaguemanager()
    	{
    		global  $wpdb;
    
    		$tables = array($wpdb->leaguemanager, $wpdb->leaguemanager_teams, $wpdb->leaguemanager_matches, $wpdb->leaguemanager_stats);
    
    		foreach( $tables AS $table ) {
    			$results = $wpdb->get_results("SHOW COLUMNS FROM {$table}");
    			$columns = array();
    			foreach ( $results AS $result ) {
    				$columns[] = "<li>".$result->Field." ".$result->Type.", NULL: ".$result->Null.", Default: ".$result->Default.", Extra: ".$result->Extra."</li>";
    			}
    			echo "<p>Table ".$table."<ul>";
    			echo implode("", $columns);
    			echo "</ul></p>";
    		}
    	}
    showDatabaseColumnsLeaguemanager();
    Plugin Author K

    (@koelle)

    then go to any page in the frontend and post the output

Viewing 3 replies - 16 through 18 (of 18 total)
  • The topic ‘No standings display and cannot add new teams’ is closed to new replies.