Gridirontables AFVD fetches league standings and game schedules from a publicly available XML API, stores them locally, and displays them via shortcodes.<\/p>\n\n
This plugin is an independent project and is not affiliated with, endorsed by, or in any way officially connected to the AFVD (American Football Verband Deutschland) or any of its member associations.<\/p>\n\n
[gridirontables_afvd_standings league=\"slug\"]<\/code> \u2014 League standings table<\/li>\n[gridirontables_afvd_schedule league=\"slug\"]<\/code> \u2014 Game schedule table<\/li>\n<\/ul>\n\nSchedule Attributes<\/h4>\n\n\nhome_only=\"1\"<\/code> \u2014 Show only home games of the configured team<\/li>\nshow=\"upcoming\"<\/code> \u2014 Show only upcoming games<\/li>\nshow=\"past\"<\/code> \u2014 Show only past games<\/li>\nlimit=\"5\"<\/code> \u2014 Limit number of games shown<\/li>\n<\/ul>\n\nShared Attributes<\/h4>\n\n\ngroup=\"A\"<\/code> \u2014 Show only a specific group<\/li>\nhighlight=\"Team Name\"<\/code> \u2014 Override team name for highlighting<\/li>\nclass=\"my-class\"<\/code> \u2014 Add custom CSS class<\/li>\nsaison=\"2026\"<\/code> \u2014 Override the season label shown in the heading<\/li>\n<\/ul>\n\nStandings Attributes<\/h4>\n\n\nformat=\"wins\"<\/code> (default) \u2014 BSO record layout: W-L (Quotient) \/ TD \/ Home-Away<\/li>\nformat=\"points\"<\/code> \u2014 Legacy points layout: P+ \/ P- \/ TD+ \/ TD- (for archive data)<\/li>\n<\/ul>\n\n\n\n- Upload the plugin folder to
\/wp-content\/plugins\/<\/code><\/li>\n- Activate the plugin through the Plugins menu<\/li>\n
- Go to Gridirontables AFVD<\/strong> in the admin menu to configure leagues<\/li>\n
- Import data and use shortcodes on your pages<\/li>\n<\/ol>\n\n\n
3.1.3<\/h4>\n\n\n- Fix: post-import row counts in the Import tab reported the wrong saison's count.
import_league()<\/code> called get_counts($liga_code)<\/code> without passing the saison, so importing an archive entry would store the right rows in the DB but display the count from the current saison \u2014 making two leagues with the same liga_code look identical even though the underlying data was different. Now the count is scoped to the saison that was just imported.<\/li>\n- Migration robustness: replaced
SHOW INDEX \u2026 WHERE<\/code> with a fetch-all-then-filter-in-PHP approach so the saison-in-unique-key migration runs reliably on all MySQL\/MariaDB versions; table and key names are now backtick-quoted.<\/li>\n<\/ul>\n\n3.1.2<\/h4>\n\n\n- Leagues form: when duplicate slugs or duplicate (liga_code, saison) pairs are submitted, nothing is saved<\/strong> and the form re-renders with the user's unsaved input intact plus a red error notice listing the row numbers and what to fix. Previously the duplicate row was silently skipped, which lost the user's typing.<\/li>\n<\/ul>\n\n
3.1.1<\/h4>\n\n\n- Two league entries can now coexist with the same Liga Code but different Saison values \u2014 useful for displaying current + archive data side by side. The
saison<\/code> column is part of the unique key on both DB tables; DB schema bumped to 1.5 (the key is migrated automatically on upgrade)<\/li>\n- Validation on the Leagues form: duplicate slugs or duplicate (liga_code, saison) pairs are now skipped on save and surfaced in an admin notice \u2014 previously the second entry silently overwrote the first<\/li>\n
- Import buttons, count cells, and raw-data viewer in the admin Import tab key off the league slug instead of the liga_code so multi-saison setups address the right league entry<\/li>\n
- Import tab now shows the per-league Saison column and counts are scoped to that saison<\/li>\n<\/ul>\n\n
3.1.0<\/h4>\n\n\n- New BSO-style standings layout (default):
Rank | Team | Record (W-L (Quotient)) | TD (TD+:TD-) | Home\/Away<\/code>, matching the official footballverband.de output<\/li>\n- Legacy
P+ \/ P- \/ TD+ \/ TD-<\/code> layout remains available via format=\"points\"<\/code> on the shortcode or per league config (for archive seasons that still use the old points system)<\/li>\n- New per-league Saison<\/strong> field \u2014 when set, gets appended to the table heading and passed to the XML API as the
Saison<\/code> parameter so archive seasons can be imported<\/li>\n- Shortcode attributes
format<\/code> and saison<\/code> for ad-hoc overrides<\/li>\n- Importer now captures
Gameswin<\/code>, Gamesloose<\/code>, Gamestied<\/code>, Quotient<\/code>, Home\/Away splits and overtime scores (OTHeim<\/code> \/ OTGast<\/code>) \u2014 DB schema bumped to 1.4<\/li>\n- Important after upgrade:<\/strong> run a fresh import (Gridirontables AFVD \u2192 Import) to populate the new columns; until you do, standings fall back to the legacy
points<\/code> layout<\/li>\n<\/ul>\n\n3.0.2<\/h4>\n\n\n- Corrected the
Contributors<\/code> field in readme.txt<\/code> to the WordPress.org account that owns the plugin (dsfooboo<\/code>)<\/li>\n- Removed the deprecated
[dsfooboo_football_data_*]<\/code>, [footballdata_*]<\/code> and [afvdata_*]<\/code> shortcode aliases to satisfy the WordPress.org Plugin Check prefix requirement \u2014 only [gridirontables_afvd_*]<\/code> is registered now (existing pages using the old tags must be updated)<\/li>\n<\/ul>\n\n3.0.1<\/h4>\n\n\n- Trim short description to fit the 150-character readme limit<\/li>\n
- Suppress remaining
WordPress.DB.PreparedSQL.InterpolatedNotPrepared<\/code> warnings on the legacy-table RENAME \/ DROP queries (table names cannot be passed as prepared placeholders)<\/li>\n- Scope
uninstall.php<\/code> cleanup loop in a closure so its variables are no longer flagged as unprefixed globals<\/li>\n<\/ul>\n\n3.0.0<\/h4>\n\n\n- Renamed plugin to \"Gridirontables AFVD\" (third rename) to match the WordPress.org plugin slug
gridirontables-afvd<\/code><\/li>\n- Text domain changed to
gridirontables-afvd<\/code> (hyphenated, as required by WordPress.org)<\/li>\n- New shortcodes
[gridirontables_afvd_standings]<\/code> and [gridirontables_afvd_schedule]<\/code>; previous [dsfooboo_football_data_*]<\/code>, [footballdata_*]<\/code> and [afvdata_*]<\/code> shortcodes still work as aliases<\/li>\n- All internal prefixes (classes, options, CSS, AJAX hooks, cron hook) renamed to
gridirontables_afvd_*<\/code><\/li>\n- Migration on activation\/load handles tables and options from all three prior prefixes (
dsfooboo_football_data_*<\/code>, footballdata_*<\/code>, afvdata_*<\/code>)<\/li>\n- DB schema bumped to 1.3<\/li>\n<\/ul>\n\n
2.5.2<\/h4>\n\n\n- Updated tagline to \"League tables & schedules - data provided by AFVD\"<\/li>\n<\/ul>\n\n
2.5.1<\/h4>\n\n\n- GitHub repository renamed from
footballdata<\/code> to dsfooboo-football-data<\/code>; Plugin URI and documentation links updated accordingly<\/li>\n<\/ul>\n\n2.5.0<\/h4>\n\n\n- Renamed plugin to \"DSFOOBOO Football Data\"<\/li>\n
- New shortcodes
[dsfooboo_football_data_standings]<\/code> and [dsfooboo_football_data_schedule]<\/code>; previous [footballdata_*]<\/code> and [afvdata_*]<\/code> shortcodes still work as aliases<\/li>\n- All internal prefixes (classes, options, CSS, AJAX hooks, text domain, cron hook) renamed to
dsfooboo_football_data_*<\/code><\/li>\n- Migration on activation\/load handles tables and options from both prior prefixes (
footballdata_*<\/code> and afvdata_*<\/code>)<\/li>\n- DB schema bumped to 1.2<\/li>\n<\/ul>\n\n
2.4.1<\/h4>\n\n\n- GitHub repository renamed from
afvdata<\/code> to footballdata<\/code>; Plugin URI and documentation links updated accordingly<\/li>\n<\/ul>\n\n2.4.0<\/h4>\n\n\n- Renamed plugin from \"AFVData\" to \"FootballData\"<\/li>\n
- New shortcodes
[footballdata_standings]<\/code> and [footballdata_schedule]<\/code>; old [afvdata_*]<\/code> shortcodes still work as aliases<\/li>\n- All internal prefixes renamed from
afvdata<\/code> to footballdata<\/code><\/li>\n- Automatic one-time migration on activation: renames database tables and copies options from the old prefix<\/li>\n
- DB schema bumped to 1.1<\/li>\n<\/ul>\n\n
2.3.0<\/h4>\n\n\n- Complete rename of all internal prefixes to afvdata<\/li>\n
- Shortcodes are now
[afvdata_standings]<\/code> and [afvdata_schedule]<\/code><\/li>\n- Text domain changed to
afvdata<\/code><\/li>\n- Updated all CSS classes, option names, and hook names<\/li>\n
- Added Info tab with disclaimer and contact information<\/li>\n
- Added plugin logo<\/li>\n<\/ul>\n\n
2.1.0<\/h4>\n\n\n- Fixed schedule showing only own team's games<\/li>\n
- Per-league team name configuration<\/li>\n
- Configurable table colors with theme palette<\/li>\n
- Top-level admin menu<\/li>\n
- Raw data viewer on import tab<\/li>\n
- Auto-detect groups from imported data<\/li>\n
- German date format for schedule<\/li>\n<\/ul>\n\n
2.0.0<\/h4>\n\n\n- Initial release<\/li>\n<\/ul>","raw_excerpt":"Display American football league standings and schedules from publicly available XML data on your WordPress site.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/305260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=305260"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/dsfooboo"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=305260"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=305260"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=305260"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=305260"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=305260"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=305260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}