anpera.net
https://anpera.dyndns.org/phpbb3/

GANZ DRINGEND HILFE brauch ich
https://anpera.dyndns.org/phpbb3/viewtopic.php?f=34&t=1578		 Seite 1 von 1
Autor:  Taikun14 [ Di 19 Jul, 2005 19:26 ]
Betreff des Beitrags:  GANZ DRINGEND HILFE brauch ich
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
Autor:  Eliwood [ Di 19 Jul, 2005 19:32 ]
Betreff des Beitrags:  Re: GANZ DRINGEND HILFE brauch ich
Taikun14 hat geschrieben:
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 :nene:

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]
Autor:  Taikun14 [ Di 19 Jul, 2005 19:36 ]
Betreff des Beitrags: 
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]
Autor:  Eliwood [ Di 19 Jul, 2005 19:38 ]
Betreff des Beitrags: 
Taikun14 hat geschrieben:
limit 0,25 und so steht in der common datei nich^^ is die fehlermeldung


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

EDIT: Na gut, das Limit steht nicht so da.... :pein:
Autor:  Taikun14 [ Di 19 Jul, 2005 19:41 ]
Betreff des Beitrags: 
schau nomma über deiner antwort^^
Seite 1 von 1 Alle Zeiten sind UTC + 1 Stunde
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/