Newest downloads op portal

Luuk · Bericht door **Luuk** » 16 dec 2003, 15:20

Ik heb naar deze mod gezocht, maar niet gevonden en dacht, dan maak ik hem maar zelf. Als basis gebruik ik de Newest links on portal mod van OXPUS.

Ik krijg deze error:

Code: Selecteer alles

Could not query links information

DEBUG MODE

SQL Error : 1146 Table 'esaclan_esa.PA_CAT_TABLE' doesn't exist

SELECT l.link_url, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, u.username, u.user_id FROM phpbb_pa_files l, PA_CAT_TABLE lc, phpbb_users u WHERE l.file_active = 1 AND l.file_catid = lc.cat_id AND l.user_id = u.user_id ORDER BY l.file_id DESC LIMIT 0,10

Line : 508
File : /home/www/esaclan.50free.net/forum/portal.php

Dit is de code die ik erop zet:

Code: Selecteer alles

//
// Recent Downloads
//
$sql = "SELECT l.link_url, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, u.username, u.user_id
		FROM " . PA_FILES_TABLE . " l, " . PA_CAT_TABLE . " lc, " . USERS_TABLE . " u
		WHERE l.file_active = 1
		AND l.file_catid = lc.cat_id
		AND l.user_id = u.user_id
		ORDER BY l.file_id DESC
		LIMIT 0,".$board_config['recent_downloads'];
if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query links information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
	$template->assign_block_vars('recent_downloads', array(
	      'DL_URL' => '<a href="'.append_sid("dload.$phpEx?action=go&file_id=" . $row['file_id']).'" target="_blank" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()"><b>'.$row['file_name'].'</b></a>',
	      'DL_CAT' => '<a href="'.append_sid("dload.$phpEx?t=sub_pages&cat=" . $row['cat_id']).'" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()"><i>'.$row['cat_title'].'</i></a>',
	      'DL_DESC' => $row['file_desc'],
	      'DL_AUTHOR' => '<a href="'.append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']).'" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()">'.$row['username'].'</a>')
	);
}
$template->assign_vars(array(
	'L_RECENT_DOWNLOADS' => $lang['Recent_downloads'])
);

Wat is er verkeerd?

Dit is de pa_files en pa_cat tabel:

Code: Selecteer alles

#
# Table structure for table `phpbb_pa_cat`
#

CREATE TABLE phpbb_pa_cat (
  cat_id int(10) NOT NULL auto_increment,
  cat_name text,
  cat_desc text,
  cat_files int(10) default NULL,
  cat_1xid int(10) default NULL,
  cat_parent int(50) default NULL,
  cat_order int(50) default NULL,
  PRIMARY KEY  (cat_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `phpbb_pa_files`
#

CREATE TABLE phpbb_pa_files (
  file_id int(10) NOT NULL auto_increment,
  file_name text,
  file_desc text,
  file_creator text,
  file_version text,
  file_longdesc text,
  file_ssurl text,
  file_dlurl text,
  file_time int(50) default NULL,
  file_catid int(10) default NULL,
  file_posticon text,
  file_license int(10) default NULL,
  file_dls int(10) default NULL,
  file_last int(50) default NULL,
  file_pin int(2) default NULL,
  file_docsurl text,
  file_rating double(6,4) NOT NULL default '0.0000',
  file_totalvotes int(255) NOT NULL default '0',
  PRIMARY KEY  (file_id)
) TYPE=MyISAM;
# --------------------------------------------------------

Wie mij kan helpen, hartelijk dank.

Podium4 · Bericht door **Podium4** » 16 dec 2003, 15:23

er moet ergens een bestand zijn die verteld dat PA_CAT_TABLE eigenlijk phpbb_pa_cat is... dat bestand moet je dus opzoeken en corrigeren... je kunt natuurlijk ook gewoon de goede tabelnaam in het script opnemen...

Luuk · Bericht door **Luuk** » 16 dec 2003, 15:35

OK, ik heb dat veranderd, en nog een hoop, maar nu krijg ik deze error:

Code: Selecteer alles

Could not query downloads information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM phpbb_pa_files l, phpbb_pa_cat lc WHERE l.file_time = 1

SELECT l.file_dlurl, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, FROM phpbb_pa_files l, phpbb_pa_cat lc WHERE l.file_time = 1 AND l.file_catid = lc.cat_id ORDER BY l.file_id DESC LIMIT 0,10

Line : 505
File : /home/www/esaclan.50free.net/forum/portal.php

Wat nu?

Podium4 · Bericht door **Podium4** » 16 dec 2003, 15:43

probeer dit 'ns ipv dat stukje waar het fout gaat:

Code: Selecteer alles

SELECT l.file_dlurl, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, FROM 'phpbb_pa_files' l, phpbb_pa_cat lc WHERE l.file_time = 1 AND l.file_catid = lc.cat_id ORDER BY l.file_id DESC LIMIT 0,10

Luuk · Bericht door **Luuk** » 16 dec 2003, 16:32

Waarvoor moet ik het in de plaats doen? hiervoor?

Code: Selecteer alles

$sql = "SELECT l.file_dlurl, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, FROM 'phpbb_pa_cat' l, " . phpbb_pa_cat . " lc
		WHERE l.file_time = 1
		AND l.file_catid = lc.cat_id
		ORDER BY l.file_id DESC
		LIMIT 0,".$board_config['recent_downloads'];

//Aangepast door podium4: nu is het d8 ik wel goed...

Luuk · Bericht door **Luuk** » 16 dec 2003, 22:09

Ik heb het nu zo ver gekregen dat ie geen error's meer geeft. Nu alleen nog dat ie het ook vergeeft.
Bestand in portal.php

Code: Selecteer alles

//
// Recent Downloads
//
$sql = "SELECT l.file_dlurl, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, u.username, u.user_id
		FROM " . phpbb_pa_files . " l, " . phpbb_pa_cat . " lc, " . USERS_TABLE . " u
		WHERE l.file_time = 1
		AND l.file_catid = lc.cat_id
		AND l.user_id = u.user_id
		ORDER BY l.file_id DESC
		LIMIT 0,".$board_config['recent_downloads'];
if (!$result = $db->sql_query($sql))
{
	message_die(GENERAL_ERROR, 'Could not query links information', '', __LINE__, __FILE__, $sql);
}
while( $row = $db->sql_fetchrow($result) )
{
	$template->assign_block_vars('recent_downloads', array(
	      'DL_URL' => '<a href="'.append_sid("dload.$phpEx?action=go&file_id=" . $row['file_id']).'" target="_blank" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()"><b>'.$row['file_name'].'</b></a>',
	      'DL_CAT' => '<a href="'.append_sid("dload.$phpEx?t=sub_pages&cat=" . $row['cat_id']).'" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()"><i>'.$row['cat_name'].'</i></a>',
	      'DL_DESC' => $row['file_desc'],
              'DL_AUTHOR' => '<a href="'.append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']).'" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()">'.$row['username'].'</a>')
	);
}
$template->assign_vars(array(
	'L_RECENT_DOWNLOADS' => $lang['Recent_downloads'])
);

Bestand in portal_body.tpl:

Code: Selecteer alles

		  <br />

		  <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
		   <tr>
			<td class="catHead" height="25"><span class="genmed"><b>{L_RECENT_DOWNLOADS}</b></span></td>
		   </tr>
		   <tr>
			<td class="row1" align="left"><span class="gensmall">
			<marquee id="recent_downloads" behavior="scroll" direction="up" height="200" scrolldelay="100" scrollamount="2">
			<!-- BEGIN recent_topic_row -->
			&raquo; <a href="{recent_downloads_row.DL_URL}" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()">{recent_downloads_row.DL_AUTHOR}</a><br />
			by <a href="{recent_downloads_row.U_CAT}" onMouseOver="document.all.recent_downloads.stop()" onMouseOut="document.all.recent_downloads.start()">{recent_downloads_row.DL_DESC}<br /><br />
			<!-- END recent_downloadstopic_row -->
			</marquee>
			</span></td>
		   </tr>
		  </table>

Zie het 'werkende' hier

WebSiteNet · Bericht door **WebSiteNet** » 17 dec 2003, 08:39

$sql = "SELECT l.file_dlurl, l.file_name, l.file_desc, l.file_id, lc.cat_name, lc.cat_id, FROM 'phpbb_pa_cat' l, " . phpbb_pa_cat . " lc
WHERE l.file_time = 1
AND l.file_catid = lc.cat_id
ORDER BY l.file_id DESC
LIMIT 0,".$board_config['recent_downloads'];

lc.cat_id, FROM

komma te veel. daardoor kwam die error.