Ewige Rangliste geht nicht

Instanz · 5. September 2016

Hallo,

wir haben unsere Liga (eigene Liga) nun abgeschlossen und die nächste steht vor der Tür, jetzt wollten wir die Ewige Rangliste verwenden doch die funktioniert nicht es wird nichts angezeigt.

Gleiche Datenbank wird benutzt, User sind alle vorhanden

Datenbank Check sagt: OK
Preclac: OK

wenn ich aber jetzt die create_ranking.php ausführen will kommt folgende Meldung: Parameter sind fehlerhaft oder unvollständig oder die Abfrage ist fehlgeschlagen!

Hoffe Ihr könnt helfen

oldie · 5. September 2016

was steht in diesen Tabellen bulitipp_precalc , bulitipp_saison_ranking

Instanz · 5. September 2016

saison_ranking:

SQL

('1.3', 1, 3, 'Instanz', 0, 0, 1, 1, 3, 1, 0, 2, 10, 0, 50, 1, 1, 34, 3, 0, 23, 30, 10, 339, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.12', 1, 12, 'Singarix', 4, 0, 3, 3, 3, 0, 0, 3, 0, 0, 35, 2, 2, 31, 3, 0, 22, 20, 0, 324, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.10', 1, 10, 'Thyrann', 7, 0, 5, 5, 2, 0, 0, 2, 0, 0, 26, 3, 3, 24, 5, 0, 16, 40, 0, 301, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.2', 1, 2, 'kLeiNEr_ToD', 2, 0, 2, 2, 3, 0, 0, 3, 0, 0, 36, 4, 4, 31, 1, 0, 22, 10, 10, 270, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.8', 1, 8, 'Tankbuster1075', 0, 0, 4, 4, 3, 0, 0, 3, 0, 0, 31, 5, 5, 34, 2, 0, 22, 20, 0, 270, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.7', 1, 7, 'THOR_s_HAMMER', 4, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 6, 6, 19, 1, 0, 15, 10, 0, 159, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.11', 1, 11, 'GravityBase', 7, 0, 6, 6, 1, 0, 0, 1, 0, 0, 2, 7, 7, 22, 0, 0, 14, 0, 0, 84, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('1.13', 1, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('2.7', 2, 7, 'THOR_s_HAMMER', 4, 0, 1, 1, 3, 1, 0, 1, 10, 0, 38, 1, 1, 3, 1, 0, 1, 10, 0, 38, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('2.2', 2, 2, 'kLeiNEr_ToD', 2, 0, 2, 2, 3, 0, 0, 2, 0, 0, 25, 2, 2, 3, 0, 0, 2, 0, 0, 25, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('2.3', 2, 3, 'Instanz', 0, 0, 3, 3, 3, 0, 0, 2, 0, 0, 23, 3, 3, 3, 0, 0, 2, 0, 0, 23, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('2.8', 2, 8, 'Tankbuster1075', 0, 0, 4, 4, 3, 0, 0, 2, 0, 0, 14, 4, 4, 3, 0, 0, 2, 0, 0, 14, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.7', 3, 7, 'THOR_s_HAMMER', 4, 0, 6, 6, 3, 0, 0, 3, 0, 0, 26, 1, 1, 6, 1, 0, 4, 10, 0, 64, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.2', 3, 2, 'kLeiNEr_ToD', 2, 0, 5, 5, 3, 0, 0, 3, 0, 0, 33, 2, 2, 6, 0, 0, 5, 0, 0, 58, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.3', 3, 3, 'Instanz', 0, 0, 3, 4, 3, 0, 0, 3, 0, 0, 34, 3, 3, 6, 0, 0, 5, 0, 0, 57, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.10', 3, 10, 'Thyrann', 7, 0, 1, 1, 3, 2, 0, 1, 10, 0, 55, 4, 4, 3, 2, 0, 1, 10, 0, 55, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.12', 3, 12, 'Singarix', 4, 0, 2, 2, 3, 1, 0, 2, 10, 0, 51, 5, 5, 3, 1, 0, 2, 10, 0, 51, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.8', 3, 8, 'Tankbuster1075', 0, 0, 3, 3, 3, 0, 0, 3, 0, 0, 34, 6, 6, 6, 0, 0, 5, 0, 0, 48, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('3.11', 3, 11, 'GravityBase', 7, 0, 7, 7, 3, 0, 0, 2, 0, 0, 17, 7, 7, 3, 0, 0, 2, 0, 0, 17, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.10', 4, 10, 'Thyrann', 7, 0, 1, 2, 3, 1, 0, 2, 10, 0, 41, 1, 1, 6, 3, 0, 3, 20, 0, 96, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.8', 4, 8, 'Tankbuster1075', 0, 0, 1, 1, 3, 1, 0, 2, 10, 0, 41, 2, 2, 9, 1, 0, 7, 10, 0, 89, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.2', 4, 2, 'kLeiNEr_ToD', 2, 0, 3, 3, 3, 0, 0, 3, 0, 0, 23, 3, 3, 9, 0, 0, 8, 0, 0, 81, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.3', 4, 3, 'Instanz', 0, 0, 4, 4, 3, 0, 0, 2, 0, 0, 22, 4, 4, 9, 0, 0, 7, 0, 0, 79, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.7', 4, 7, 'THOR_s_HAMMER', 4, 0, 7, 7, 3, 0, 0, 2, 0, 0, 12, 5, 5, 9, 1, 0, 6, 10, 0, 76, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.12', 4, 12, 'Singarix', 4, 0, 5, 5, 3, 0, 0, 2, 0, 0, 15, 6, 6, 6, 1, 0, 4, 10, 0, 66, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.11', 4, 11, 'GravityBase', 7, 0, 8, 8, 3, 0, 0, 2, 0, 0, 6, 7, 7, 6, 0, 0, 4, 0, 0, 23, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('4.13', 4, 13, 'Andre193', 3, 0, 6, 6, 3, 0, 0, 1, 0, 0, 13, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.8', 5, 8, 'Tankbuster1075', 0, 0, 3, 4, 3, 1, 0, 1, 10, 0, 36, 1, 1, 12, 2, 0, 8, 20, 0, 125, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.2', 5, 2, 'kLeiNEr_ToD', 2, 0, 2, 2, 3, 1, 0, 1, 10, 0, 40, 2, 2, 12, 1, 0, 9, 10, 0, 121, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.12', 5, 12, 'Singarix', 4, 0, 1, 1, 3, 2, 0, 1, 10, 0, 54, 3, 3, 9, 3, 0, 5, 20, 0, 120, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.3', 5, 3, 'Instanz', 0, 0, 3, 3, 3, 1, 0, 1, 10, 0, 36, 4, 4, 12, 1, 0, 8, 10, 0, 115, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.10', 5, 10, 'Thyrann', 7, 0, 7, 7, 1, 0, 0, 1, 0, 0, 10, 5, 5, 7, 3, 0, 4, 20, 0, 106, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.7', 5, 7, 'THOR_s_HAMMER', 4, 0, 5, 5, 3, 0, 0, 3, 0, 0, 28, 6, 6, 12, 1, 0, 9, 10, 0, 104, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.11', 5, 11, 'GravityBase', 7, 0, 6, 6, 3, 0, 0, 1, 0, 0, 13, 7, 7, 9, 0, 0, 5, 0, 0, 36, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('5.13', 5, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.12', 6, 12, 'Singarix', 4, 0, 2, 3, 2, 0, 0, 2, 0, 0, 26, 1, 1, 11, 3, 0, 7, 20, 0, 146, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.8', 6, 8, 'Tankbuster1075', 0, 0, 5, 5, 2, 0, 0, 2, 0, 0, 21, 2, 2, 14, 2, 0, 10, 20, 0, 146, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.3', 6, 3, 'Instanz', 0, 0, 2, 2, 2, 0, 0, 2, 0, 0, 26, 3, 3, 14, 1, 0, 10, 10, 0, 141, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.10', 6, 10, 'Thyrann', 7, 0, 1, 1, 2, 1, 0, 1, 10, 0, 34, 4, 4, 9, 4, 0, 5, 30, 0, 140, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.2', 6, 2, 'kLeiNEr_ToD', 2, 0, 6, 6, 2, 0, 0, 1, 0, 0, 12, 5, 5, 14, 1, 0, 10, 10, 0, 133, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.7', 6, 7, 'THOR_s_HAMMER', 4, 0, 4, 4, 2, 0, 0, 2, 0, 0, 22, 6, 6, 14, 1, 0, 11, 10, 0, 126, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.11', 6, 11, 'GravityBase', 7, 0, 7, 7, 2, 0, 0, 2, 0, 0, 11, 7, 7, 11, 0, 0, 7, 0, 0, 47, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('6.13', 6, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.12', 7, 12, 'Singarix', 4, 0, 1, 1, 3, 0, 0, 3, 0, 0, 36, 1, 1, 14, 3, 0, 10, 20, 0, 182, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.8', 7, 8, 'Tankbuster1075', 0, 0, 2, 2, 3, 0, 0, 3, 0, 0, 33, 2, 2, 17, 2, 0, 13, 20, 0, 179, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.3', 7, 3, 'Instanz', 0, 0, 3, 5, 3, 0, 0, 3, 0, 0, 32, 3, 3, 17, 1, 0, 13, 10, 0, 173, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.10', 7, 10, 'Thyrann', 7, 0, 3, 4, 3, 0, 0, 3, 0, 0, 32, 4, 4, 12, 4, 0, 8, 30, 0, 172, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.2', 7, 2, 'kLeiNEr_ToD', 2, 0, 3, 3, 3, 0, 0, 3, 0, 0, 32, 5, 5, 17, 1, 0, 13, 10, 0, 165, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.7', 7, 7, 'THOR_s_HAMMER', 4, 0, 6, 6, 3, 0, 0, 3, 0, 0, 31, 6, 6, 17, 1, 0, 14, 10, 0, 157, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.11', 7, 11, 'GravityBase', 7, 0, 7, 7, 3, 0, 0, 2, 0, 0, 15, 7, 7, 14, 0, 0, 9, 0, 0, 62, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('7.13', 7, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.12', 8, 12, 'Singarix', 4, 0, 2, 2, 3, 0, 0, 2, 0, 0, 23, 1, 1, 28, 3, 0, 19, 20, 0, 289, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.3', 8, 3, 'Instanz', 0, 0, 1, 1, 3, 0, 0, 3, 0, 0, 28, 2, 2, 31, 2, 0, 21, 20, 10, 289, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.10', 8, 10, 'Thyrann', 7, 0, 3, 3, 2, 0, 0, 1, 0, 0, 14, 3, 3, 22, 5, 0, 14, 40, 0, 275, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.8', 8, 8, 'Tankbuster1075', 0, 0, 5, 5, 3, 0, 0, 1, 0, 0, 10, 4, 4, 31, 2, 0, 19, 20, 0, 239, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.2', 8, 2, 'kLeiNEr_ToD', 2, 0, 4, 4, 3, 0, 0, 1, 0, 0, 14, 5, 5, 28, 1, 0, 19, 10, 10, 234, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.7', 8, 7, 'THOR_s_HAMMER', 4, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 6, 6, 19, 1, 0, 15, 10, 0, 159, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.11', 8, 11, 'GravityBase', 7, 0, 6, 6, 1, 0, 0, 1, 0, 0, 5, 7, 7, 21, 0, 0, 13, 0, 0, 82, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('8.13', 8, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.10', 9, 10, 'Thyrann', 7, 0, 3, 3, 2, 0, 0, 1, 0, 0, 14, 1, 1, 16, 5, 0, 9, 40, 0, 212, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.3', 9, 3, 'Instanz', 0, 0, 1, 1, 3, 1, 0, 0, 10, 0, 26, 2, 2, 22, 2, 0, 14, 20, 0, 207, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.8', 9, 8, 'Tankbuster1075', 0, 0, 4, 5, 3, 0, 0, 1, 0, 0, 13, 3, 3, 22, 2, 0, 15, 20, 0, 201, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.12', 9, 12, 'Singarix', 4, 0, 4, 4, 3, 0, 0, 1, 0, 0, 13, 4, 4, 19, 3, 0, 12, 20, 0, 200, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.2', 9, 2, 'kLeiNEr_ToD', 2, 0, 2, 2, 2, 0, 0, 2, 0, 0, 18, 5, 5, 21, 1, 0, 16, 10, 0, 188, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.7', 9, 7, 'THOR_s_HAMMER', 4, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 6, 6, 19, 1, 0, 15, 10, 0, 159, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.11', 9, 11, 'GravityBase', 7, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 7, 7, 18, 0, 0, 10, 0, 0, 66, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('9.13', 9, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.3', 10, 3, 'Instanz', 0, 0, 2, 2, 3, 0, 0, 3, 0, 0, 34, 1, 1, 25, 2, 0, 17, 20, 0, 241, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.12', 10, 12, 'Singarix', 4, 0, 1, 1, 3, 0, 0, 3, 0, 0, 40, 2, 2, 22, 3, 0, 15, 20, 0, 240, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.10', 10, 10, 'Thyrann', 7, 0, 3, 3, 2, 0, 0, 2, 0, 0, 25, 3, 3, 18, 5, 0, 11, 40, 0, 237, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.8', 10, 8, 'Tankbuster1075', 0, 0, 4, 4, 3, 0, 0, 2, 0, 0, 18, 4, 4, 25, 2, 0, 17, 20, 0, 219, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.2', 10, 2, 'kLeiNEr_ToD', 2, 0, 5, 5, 1, 0, 0, 1, 0, 0, 14, 5, 5, 22, 1, 0, 17, 10, 0, 202, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.7', 10, 7, 'THOR_s_HAMMER', 4, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 6, 6, 19, 1, 0, 15, 10, 0, 159, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.11', 10, 11, 'GravityBase', 7, 0, 6, 6, 1, 0, 0, 1, 0, 0, 7, 7, 7, 19, 0, 0, 11, 0, 0, 73, NULL, NULL, 0, 0, 0, 0, 0, 0, 0),
('10.13', 10, 13, 'Andre193', 3, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 8, 8, 3, 0, 0, 1, 0, 0, 13, NULL, NULL, 0, 0, 0, 0, 0, 0, 0);

Alles anzeigen

Instanz · 5. September 2016

_precalc

SQL

(1, 'user_ranking', '0001-00-00 00:00:00', 2016, 1, 12, 7, 12, NULL),
(2, 'user_ranking', '2016-09-04 23:29:24', 2016, 1, 1, 7, 12, NULL),
(3, 'user_ranking', '2016-09-04 23:29:24', 2016, 1, 2, 7, 12, NULL),
(4, 'user_ranking', '2016-09-04 23:29:24', 2016, 1, 3, 7, 12, NULL),
(5, 'user_ranking', '2016-09-04 23:29:24', 2016, 1, 4, 7, 12, NULL),
(6, 'user_ranking', '2016-09-04 23:29:24', 2016, 1, 5, 7, 12, NULL),
(7, 'user_ranking', '2016-09-04 23:29:24', 2016, 1, 6, 7, 12, NULL),
(8, 'user_ranking', '2016-09-04 23:33:23', 2016, 1, 11, 7, 12, NULL),
(9, 'user_ranking', '2016-09-04 23:34:26', 2016, 1, 8, 7, 12, NULL),
(10, 'user_ranking', '2016-09-04 23:34:26', 2016, 1, 9, 7, 12, NULL),
(11, 'league_table', '2016-09-04 23:35:30', 2016, 1, 12, 7, 12, NULL),
(12, 'league_table', '2016-09-04 23:35:30', 2016, 1, 8, 7, 12, NULL),
(13, 'league_table', '2016-09-05 07:56:00', 2016, 1, 11, 7, 12, NULL),
(14, 'league_table', '2016-09-05 07:56:05', 2016, 1, 2, 7, 12, NULL),
(15, 'league_table', '2016-09-05 07:56:07', 2016, 1, 1, 7, 12, NULL),
(16, 'league_table', '2016-09-05 07:56:09', 2016, 1, 3, 7, 12, NULL),
(17, 'league_table', '2016-09-05 07:56:10', 2016, 1, 4, 7, 12, NULL),
(18, 'league_table', '2016-09-05 07:56:11', 2016, 1, 5, 7, 12, NULL),
(19, 'league_table', '2016-09-05 07:56:12', 2016, 1, 6, 7, 12, NULL),
(20, 'league_table', '2016-09-05 07:56:13', 2016, 1, 7, 7, 12, NULL),
(21, 'league_table', '2016-09-05 07:56:15', 2016, 1, 9, 7, 12, NULL),
(22, 'league_table', '2016-09-05 07:56:16', 2016, 1, 10, 7, 12, NULL);

Alles anzeigen

Das is das was in beiden drin steht.

oldie · 6. September 2016

wie hast du denn die datei aufgerufen etwa so deine url/create_ranking.php
so geht es nicht
du musst es so aufrufen
Deine url/create_ranking.php?saison=2016&liga=Nummer deiner liga&sptg=letzter Spieltag deiner liga &pw=dein cronjob passwort
etwa so sollte es aussehen
http:// deinewebadresse. de/reate_ranking.php?saison=2015&liga=1&sptg=34&pw=dein cronjobpasswort

was aber auch erst im 2. Jahr geht also muss schon eine Saison durch gespielt worden sein

Instanz · 9. September 2016

Hallo,

ok danke, nur zeigt er mir an das es keinen 12 Spieltag gibt obwohl 12 Spieltage Absolviert wurden.