anpera.net

da skommt auf der village, wollt nur die gilden wegmachen und hab alles rückgängig gemacht, dann kommt das ; (((


SELECT commentary.*,
accounts.name,
accounts.login,
accounts.loggedin,
accounts.location,
accounts.laston,
accounts.guildid,
accounts.clanid,
accounts.acctid,

guilds.guildtag,
guilds.guildid,
guilds.guildowner,
clans.clantag,
clans.clanid,
clans.clanowner


FROM commentary
INNER JOIN accounts
ON accounts.acctid = commentary.author
LEFT JOIN guilds
ON guilds.guildowner = accounts.acctid OR guilds.guildid = accounts.guildid
LEFT JOIN clans
ON clans.clanowner = accounts.acctid OR clans.clanid = accounts.clanid
WHERE section = 'village'
AND accounts.locked=0
ORDER BY commentid DESC
LIMIT 0,25
Table 'usr_web236_1.guilds' doesn't exist

$this->bbcode_second_pass_code('', ' FROM commentary
INNER JOIN accounts
ON accounts.acctid = commentary.author
LEFT JOIN guilds
ON guilds.guildowner = accounts.acctid OR guilds.guildid = accounts.guildid
LEFT JOIN clans
ON clans.clanowner = accounts.acctid OR clans.clanid = accounts.clanid
WHERE section = 'village'
AND accounts.locked=0
ORDER BY commentid DESC
LIMIT 0,25
Table 'usr_web236_1.guilds' doesn't exist')

Lesen und verstehgen

Table 'usr_web236_1.guilds' doesn't exist guilds existiert net, hast vergessen, viewcommentary zu ändern

öffne common.php, suche
[php]SELECT commentary.*,
accounts.name,
accounts.login,
accounts.loggedin,
accounts.location,
accounts.laston,
accounts.guildid,
accounts.clanid,
accounts.acctid,

guilds.guildtag,
guilds.guildid,
guilds.guildowner,
clans.clantag,
clans.clanid,
clans.clanowner


FROM commentary
INNER JOIN accounts
ON accounts.acctid = commentary.author
LEFT JOIN guilds
ON guilds.guildowner = accounts.acctid OR guilds.guildid = accounts.guildid
LEFT JOIN clans
ON clans.clanowner = accounts.acctid OR clans.clanid = accounts.clanid
WHERE section = 'village'
AND accounts.locked=0
ORDER BY commentid DESC
LIMIT 0,25[/php]

ersetze mit
[php]SELECT commentary.*,
accounts.name,
accounts.login,
accounts.loggedin,
accounts.location,
accounts.laston,
accounts.acctid,
FROM commentary
INNER JOIN accounts
ON accounts.acctid = commentary.author
WHERE section = 'village'
AND accounts.locked=0
ORDER BY commentid DESC
LIMIT 0,25[/php]

limit 0,25 und so steht in der common datei nich^^ is die fehlermeldung

so stehts das

[php]
$com=(int)$_GET[comscroll];
$sql = "SELECT commentary.*,
accounts.name,
accounts.login,
accounts.loggedin,
accounts.location,
accounts.laston,
accounts.guildid,
accounts.clanid,
accounts.acctid,

guilds.guildtag,
guilds.guildid,
guilds.guildowner,
clans.clantag,
clans.clanid,
clans.clanowner


FROM commentary
INNER JOIN accounts
ON accounts.acctid = commentary.author
LEFT JOIN guilds
ON guilds.guildowner = accounts.acctid OR guilds.guildid = accounts.guildid
LEFT JOIN clans
ON clans.clanowner = accounts.acctid OR clans.clanid = accounts.clanid
WHERE section = '$section'
AND accounts.locked=0
ORDER BY commentid DESC
LIMIT ".($com*$limit).",$limit";
$result = db_query($sql) or die(db_error(LINK));
$counttoday=0;
[/php]

Dooooch, das steht das
Funktion viewcommentary, etwa 9 Zeile der Funktion, $sql = "SELECT blablabla

EDIT: Na gut, das Limit steht nicht so da....

schau nomma über deiner antwort^^