101: SELECT id, pid, bbcode,html,smiley,url,typ,ifbreite,ifhoehe,tanzeig,rblock FROM exv2_content where id=31
102: SELECT languages_id FROM exv2_languages where directory='deutsch'
103: SELECT title, description FROM exv2_content_desc WHERE pid=31 AND lang_id='1'
Fehlernummer: 2 [Warnung]
Fehlermitteilung: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
in Datei: /srv/www/vhosts/xxx.de/httpdocs/class/database/mysql.php
in Zeile: 155

Mitglieder (das ist die Überschrift)

119: SELECT COUNT(*) FROM exv2_groups_modules_link WHERE type='A' AND mid=23 AND (groupid=1)
Bearbeiten
104: SELECT l.uid, u.uname FROM exv2_groups_users_link l, exv2_users u WHERE l.groupid = 4 AND l.uid=u.uid ORDER BY u.uname

105: SELECT * FROM exv2_users WHERE uid=3
106: SELECT country_name FROM exv2_country_land where country_id=81
107: SELECT title FROM exv2_astro WHERE (date1 <= "02-23" and date2 >= "02-23")
109: SELECT country_name FROM exv2_country_land where country_id=81
110: SELECT title FROM exv2_astro WHERE (date1 <= "02-23" and date2 >= "02-23")
108: SELECT rank_title AS title, rank_image AS image FROM exv2_ranks WHERE rank_min <= 0 AND rank_max >= 0 AND rank_special = 0

Und dann werden ganz normal die User hier drunter angezeigt, ohne Fehler.

Fehlernummer: 2 [Warnung]
Fehlermitteilung: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
in Datei: /srv/www/vhosts/xxx.de/httpdocs/class/database/mysql.php
in Zeile: 155

global $xoopsUser, $db, $myts, $xoopsConfig, $xoopsModule;
//Angabe welche Usergruppe
$g_id = "4";

$sql = "SELECT l.uid, u.uname FROM ".$db->prefix("groups_users_link")." l, ".$db->prefix("users")." u WHERE l.groupid = ".$g_id." AND l.uid=u.uid ORDER BY u.uname";
$result = $db->query($sql);

$admins = array();
while ( $myrow = $db->fetch_array($result) ) {
$admins[$myrow['uid']] = $myts->makeTboxData4Show($myrow['uname']);
}


foreach ( $admins as $a_id => $a_name ) {
echo "<br>";
//}

$uid = $a_id;
$thisUser = new XoopsUser($uid);
define("_US_REALVNAME","Vorname");
define("_US_USERSTR","Strasse");
define("_US_USERHNR","Hausnummer");
define("_US_USERPLZ","Postleitzahl");
define("_US_USERTEL","Telefon");
define("_US_USERFAX","Handy");
define("_US_USERGEB","Geburtsdatum");
define("_US_USERGESCHL","Geschlecht");
define("_US_USERGESCHL1","männlich");
define("_US_USERGESCHL2","weiblich");
define("_US_REGION","Bundesland/Region");
define("_US_REALNAME","Nachname");
define("_US_COUNTRY","Land");
define("_US_LOCATION","Wohnort");
define("_US_SIGNATURE","Signatur");
define("_IMG_PFEIL","&amp;nbsp;");
echo "<table border='0' cellpadding='0' cellspacing='0' align='center' valign='top' width='100%'><tr><td>";
inc_class_form("class", "COUNTRY_STATE_INCLUDED", "country_state.php");
inc_class_form("class", "COUNTRY_LAND_INCLUDED", "country_land.php");
include_once(XOOPS_ROOT_PATH."/modules/system/cache/adr_conf.php");
if ( $thisUser->isActive() ) {
OpenTable();
echo "<table border='0' cellpadding='0' cellspacing='0' align='center' valign='top' width='100%'><tr><td class='bg2'>
<table border='0' cellpadding='4' cellspacing='1' width='100%'><tr valign='top' class='bg1'><td colspan='2' align='center'>";
$xoopsOption['page_menue'] = "user_info_uebersicht";
$gal_user = $thisUser->pr_gal();
$user_avatar = $thisUser->getVar("user_avatar");
$u_uname = $thisUser->getVar("uname");
$userrank = $thisUser->rank();

echo "<table border='0' cellpadding='0' cellspacing='0' align='center' valign='top' width='100%'><tr class='bg1'><td align='left' width='60'>";
if ($user_avatar) {
echo "<img src='".XOOPS_URL."/images/avatar/".$user_avatar."' alt='' width='50' />";
}
echo "</td><td align='left'><b>".$u_uname."</b><br>";

if ( $userrank['image'] ) {
echo "<img src='".XOOPS_URL."/images/ranks/".$userrank['image']."' alt='' /><br />";
}
echo $userrank['title'];

echo "</td><td align='left'>";
echo "<table cellpadding='1' cellspacing='0' border='0'><tr>";
echo "<td>";
echo "</td>";
echo "</tr></table>";
echo "</td></tr></table>";
echo "</td></tr>";
$bgC = "bg1";
if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
if ($thisUser->user_geschl() == 1){$anred = _US_USERGESCHL1;}else{$anred = _US_USERGESCHL2;}
echo "<tr valign='top' class='".$bgC."'><td width='250px'><b>"._US_USERGESCHL.":</b></td><td>"._IMG_PFEIL.$anred."</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_REALVNAME.":</b></td><td>"._IMG_PFEIL.$thisUser->vname()."</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_REALNAME.":</b></td><td>"._IMG_PFEIL.$thisUser->name()."</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_USERSTR."/"._US_USERHNR.":</b></td><td>"._IMG_PFEIL.$thisUser->user_str()." ".$thisUser->user_hnr()."</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_USERPLZ." "._US_LOCATION.":</b></td><td>"._IMG_PFEIL.$thisUser->user_plz()." ".$thisUser->user_from()."</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_COUNTRY.":</b></td><td>"._IMG_PFEIL.CountryLand::getCountryLandTitle($thisUser->user_country());
echo "</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_REGION.":</b></td><td>"._IMG_PFEIL.CountryState::getStateTitle($thisUser->user_region());
echo "</td></tr>";

if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._US_USERGEB.":</b></td><td>"._IMG_PFEIL.anzGebTag($thisUser->user_geb())."</td></tr>";
if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._USOLD.":</b></td>";
echo "<td>"._IMG_PFEIL.anzAlter(anzGebTag($thisUser->user_geb()))."</td></tr>";
if (!defined("XOOPS_ASTRO_INCLUDED")) {include(XOOPS_ROOT_PATH."/class/xoops_astro.php");}
if ($bgC == "bg1"){$bgC = "bg3";}else{$bgC = "bg1";}
echo "<tr valign='top' class='".$bgC."'><td><b>"._ASTRO.":</b></td>";
echo "<td>"._IMG_PFEIL.XoopsAstro::getTitelAstro($thisUser->user_geb())."</td></tr>";

echo "</table></td></tr></table>";
CloseTable();

echo "</td></tr></table>";
}
}