am i wrong or is there unfinished code in admin_lexicon_cat.php?
When i go to lexicon_cat.php i get a list with catagories, but it always says there is nothing in either one of those catagories?
- Code: Alles auswählen
// define categorie names
while($row = $db->sql_fetchrow($result))
{
$cat_id = $row['cat_id'];
$lexicon_categories[$row['cat_id']] = $row['cat_titel'];
if ($row['cat_titel'] == 'default')
{
$categorie = '<i>'.$row['cat_titel'].'</i>';
}
else
{
$categorie = $row['cat_titel'];
}
$categorie_lang = @$lang[$row['cat_titel']];
if ($categorie_lang == ' ')
{
$categorie_lang = '<font color="red">*</font> '.$lang['generally'];
}
if ($categorie_lang == '')
{
$categorie_lang = '<i>'.$lang['no_entry'].'</i>';
}
Zugefügt nach 1 Stunde(n) 8 Minute(n):
I solved it in my own way:
I took the above code and replaced it with the below code.
- Code: Alles auswählen
// define categorie names
while($row = $db->sql_fetchrow($result))
{
$cat_id = $row['cat_id'];
$lexicon_categories[$row['cat_id']] = $row['cat_titel'];
if ($row['cat_titel'] == 'Algemeen')
{
$categorie = $row['cat_titel'];
$query = "SELECT * FROM phpbb_lexicon WHERE cat = ".$cat_id;
$abc = mysql_query($query);
if(!$itemresult = $db->sql_query($query))
{
message_die(GENERAL_ERROR, 'Could not get catagorie content', '', __LINE__, __FILE__, $sql);
}
$numberitems = mysql_num_rows($abc);
if($numberitems == "0")
{
$categorie_lang = '0 items';
}
else
{
$categorie_lang = $numberitems.' items';
}
}
else
{
$categorie = $row['cat_titel'];
$query = "SELECT * FROM phpbb_lexicon WHERE cat = ".$cat_id;
$abc = mysql_query($query);
if(!$itemresult = $db->sql_query($query))
{
message_die(GENERAL_ERROR, 'Could not get catagorie content', '', __LINE__, __FILE__, $sql);
}
$numberitems = mysql_num_rows($abc);
if($numberitems == "0")
{
$categorie_lang = '0 items';
}
else
{
$categorie_lang = $numberitems.' items';
}
}