Module random player

pelloq1

Module random player

Postby pelloq1 » Sun Mar 18, 2007 2:08 pm

Hallo, der module random player angezeit mich keine player.

Ich habe der team ID mit mein team eingefult, aber das functioniert nich.

???

pelloq1

Re: Module random player

Postby pelloq1 » Sun Mar 18, 2007 2:13 pm

#list players of a team
$query = sprintf("SELECT player_id , picture
                    FROM #__joomleague_playertool
                   WHERE project_id = %s AND
                         team_id = %s
                ORDER BY rand() LIMIT 1", $project_id, $teamtoolid);

$database->setQuery($query);
//print $database->getQuery();
$rows = $database->loadObjectList();

echo count($rows);

 
SELECT player_id , picture
                    FROM jos_joomleague_playertool
                  WHERE project_id = 1 AND
                        team_id = 7
                ORDER BY rand() LIMIT 1

 --->> return 0


Daten :
  ID Equipe Points au démarrage Raison Administrateur Vérification
  1 Athléticum BBC Troistorrents  0     
  2 Brunnen Basket  0     
  3 Canti Riva Basket Ceresio  0     
  4 Elfic Fribourg Basket  0     
  5 Espérance Sportive Pully  0     
  6 Martigny Basket  0     
  7 SDent Sierre-Anniviers 

pelloq1

Re: Module random player

Postby pelloq1 » Tue Mar 20, 2007 10:05 am

keine anung ???


Return to “mod_joomleague_random_player”

Who is online

Users browsing this forum: No registered users and 1 guest

cron