Hi Joomlapolis citizens!

first of all, I have never worked with PHP, and never with CBplugins.

I want to create a 'highscore tab' for displaying the user highscores from this component:
mamboflashgames

i have study a lot of hours on other plugins, websites etc. But i don't get it ! i'm a bit ashame for the code that i have created. Because i know the code is not right at all. But I hope, someone with a better vision of programming can help me a bit.

This is the code... (don't laugh, because i can hear you )
[code:1]<?php

defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );


/**
* Lists mamboflashgames highscores
* @author lennox
*/
class getgameTab extends cbTabHandler {
/**
* Constructor
*/
function getgameTab() {
$this->cbTabHandler();
}
/**
* Generates the HTML to display the user profile tab
* @param object tab reflecting the tab database entry
* @param object mosUser reflecting the user being displayed
* @param int 1 for front-end, 2 for back-end
* @returns mixed : either string HTML for tab content, or false if ErrorMSG generated
*/
function getDisplayTab($tab,$user,$ui) {
global $mosConfig_absolute_path, $database, $mosConfig_lang;

$gp_path = $mosConfig_absolute_path.'/components/com_comprofiler/plugin/user/plug_gameplugin';

if (file_exists($gp_path.'/language/'.$mosConfig_lang.'.php')) {
include_once($gp_path.'/language/'.$mosConfig_lang.'.php');
} else {
include_once($gp_path.'/language/english.php');
}

$return="";

$return .= _UE_GAMETAB_TITLE.'<br /><br />'

// sql try
$sSQL = 'SELECT a.gid, a.uname FROM #__mamboflashgames_savedgames a '.
'INNER JOIN #__mamboflashgames_scores b ON a.uname = b.score '.

'WHERE uname= '.$user->id.

$database->setQuery($sSQL);
$score=$database->loadObjectList();

$return .= '<table>';

foreach($scores as $score) {
$return .= '<tr><td>';
$return .= $score->uname.'</td><td>-></td>';
}

// create content
$return .= '</table>';

return $return;
}
} // end class getgameTab.
?>
[/code:1]

mamboflash games uses 3 tables:

mamboflashgames_categories
- id
title
name
published
description
image
image_position
ordering
count
parent
access
checked_out
checked_out_time

mamboflashgames_savedgames
-gid
uname
gameData
date

mamboflashgames_scores
-gid
uname
score
date
playTime


i hope someone can help me a little, what i am doing wrong (a think i'm doing 99% wrong )
Thank you so much!

Post edited by: lennox, at: 2006/02/14 12:41

o yeah, the idea is to show the : game name - highscore.

In the future: the gamethumbail and the game name: highscore.

I hope someone can help me a little