GHengeveld

Za, 31 Okt 2009 01:26:32 -0000

Why use url.php?f=1|2|3 if you can just use url.php?f=1&f=2&f=3 ? This will make $f an array automatically so you don't need to explode it. This is de default way in which checkboxes and multiple selects get sent with the GET method.

Sean

Vr, 30 Okt 2009 03:17:45 -0000

ha ha yes it looks like i made a typo. I don't think this is the problem though... ive had serialize working properly when i was messing around with it before but it still wasn't working for me. How would I serialize $collections[$count]? When I tried it before, $collections['1'] out puts as s:1:"1"; which of course just gives me an SQL error. I guess i dont quite understand how serialize works.

EDIT:
I think ive found out what is causing the 905 error. After the second SQL query theres a line

sed_die(mysql_num_rows($sql_pff)==0);

which is causing it to die. should have seen this earlier. So this means that the SQL queries are failing and not finding anything....

Added 16 minutes later:

Ahh stupid me. I figured it out. The sed_import for $f was wrong, 2|3|5 is not a int. I set it to txt and now it works

Kilandor

Vr, 30 Okt 2009 02:47:56 -0000

The function is serialize not serialise

http://us.php.net/manual/en/function.serialize.php

Sean

Vr, 30 Okt 2009 01:28:36 -0000

It could be that im not using serialize properly. Ive never used it before, and all i know about it is what ive read on the internet

I should probably explain what im trying to do first. Im trying to modify the Seditio gallery plugin to display multiple galleries on the same page. So for example, /plug.php?e=gallery&f=2|4|1 will display pictures from gallery 2, 4 and 1. So what ive done is imported $f, exploded it, then looped through each gallery.

Heres the code:

/* ==================================== */
	case 'gallery':
	/* ==================================== */
	
	
	//TESTING
	$f = sed_import('f','G','TXT');
	$collections = explode("|", $f);
	$numcol = count($collections);
	
	$count = '0';
	$num = '0';
	
	//$serialized = serialise($collections);
	
	while ($numcol != $count){
		$jj=0;
		$sql_pff = mysql_query("SELECT f.*, u.user_name FROM $db_pfs_folders f, $db_users u WHERE pff_id=$collections[$count] AND pff_ispublic=1 AND pff_isgallery=1 AND f.pff_userid=u.user_id") or die(mysql_error());
	
		sed_die(mysql_num_rows($sql_pff)==0);
		$pff = sed_sql_fetcharray($sql_pff);
	
		$sql = mysql_query("SELECT * FROM $db_pfs WHERE pfs_folderid=$collections[$count] ORDER BY pfs_$cfg_sortby $cfg_sortway") or die(mysql_error());
		$nbitems = sed_sql_numrows($sql_pff);
		$pff['pff_title'] = sed_cc($pff['pff_title']);
		$userid = $pff['pff_userid'];
	
		$t->assign(array(
			"GALLERY_ID" => $pff['pff_id'],
			"GALLERY_TITLE" => " ".$pff['pff_title']."",
			"GALLERY_SHORTTITLE" => $pff['pff_title'],
			"GALLERY_DESC" => sed_cc($pff['pff_desc']),
			"GALLERY_COUNT" => $pff['pff_count'],
	//		"GALLERY_COMMENTS" => $pff['comments'],
	//		"GALLERY_RATING" => $pff['ratings'],
			"GALLERY_AUTHOR" => $pff['author']
				));
	
	//	$pff['comments'] = sed_comments('g'.$pff['pff_id']);
	//	$pff['ratings'] = sed_ratings('g'.$pff['pff_id']);
	
		while ($pfs = sed_sql_fetcharray($sql))
			{
			$jj++;
			$pfs['pfs_fullfile'] = $cfg['pfs_dir'].$pfs['pfs_file'];
			$pfs['pfs_filesize'] = floor($pfs['pfs_size']/1024);
	
			if (($pfs['extension']=='jpg' || $pfs['extension']=='jpeg' || $pfs['extension']=='png') && $cfg['th_amode']!='Disabled')
				{
				if (!file_exists($cfg['th_dir'].$pfs['pfs_file']) && file_exists($cfg['pfs_dir'].$pfs['pfs_file']))
				{
					$pfs['th_colortext'] = array(
						hexdec(substr($cfg['th_colortext'], 0, 2)),
						hexdec(substr($cfg['th_colortext'], 2 ,2)),
						hexdec(substr($cfg['th_colortext'], 4 ,2))
							);
	
					$pfs['th_colorbg'] = array(
						hexdec(substr($cfg['th_colorbg'], 0, 2)),
						hexdec(substr($cfg['th_colorbg'], 2, 2)),
						hexdec(substr($cfg['th_colorbg'], 4, 2))
							);
	
					sed_createthumb(
						$cfg['pfs_dir'].$pfs['pfs_file'],
						$cfg['th_dir'].$pfs['pfs_file'],
						$cfg['th_x'],
						$cfg['th_y'],
						$cfg['th_keepratio'],
						$pfs['pfs_extension'],
						$pfs['pfs_file'],
						$pfs['pfs_filesize'],
						$pfs['th_colortext'],
						$cfg['th_textsize'],
						$pfs['th_colorbg'],
						$cfg['th_border'],
						$cfg['th_jpeg_quality']
							);
					}
		 		}
	
			if ($cfg['plugin']['gallery']['columns']==1)
				{
				$pfs['cond1'] = '';
				$pfs['cond2'] = '';
				}
			elseif ($jj==1)
				{
				$pfs['cond1'] = '';
				$pfs['cond2'] = '';
				}
			elseif ($jj==$cfg['plugin']['gallery']['columns'])
				{
				$jj=0;
				$pfs['cond1'] = '';
				$pfs['cond2'] = '';
				}
			else
				{
				$pfs['cond1'] = '';
				$pfs['cond2'] = '';
				}
	
	
			$pfs['picturecode'] = 'g'.$pff['pff_id'].'-'.$pfs['pfs_id'];
	//		$pfs['comments'] = sed_comments($pfs['picturecode']);
	//		$pfs['ratings'] = sed_ratings($pfs['picturecode']);
			$pfs['new'] = ($pfs['pfs_date']+$cfg['plugin']['gallery']['newdelay']*86400>$sys['now']) ? $cfg['plugin']['gallery']['newtext'] : '';
	
			if (sed_gallery_ismovie($pfs['pfs_extension']))
				{
				$pfs['pfs_imgsize'] = array ('?','?');
				$pfs['pfs_imgsize_xy'] = '';
				$pfs['popup'] = "plug.php?e=gallery&v=".$pfs['pfs_id'];
				}
			else
				{
				$pfs['pfs_imgsize'] = @getimagesize($pfs['pfs_fullfile']);
				$pfs['pfs_imgsize_xy'] = $pfs['pfs_imgsize'][0].'x'.$pfs['pfs_imgsize'][1];
				$pfs['popup'] = "javascript:popup('gallery&v=".$pfs['pfs_id']."',".($pfs['pfs_imgsize'][0]+$cfg['plugin']['gallery']['popupmargin']).",".($pfs['pfs_imgsize'][1]+$cfg['plugin']['gallery']['popupmargin']).")";
				}
	
			if ($usr['isadmin'])
				{
				$pfs['admin'] = "".$L['Edit']."";
				$pfs['admin'] .= "   ".$L['gal_setaspotw']."";
				}
			
			$t-> assign(array(
				"GALLERY_ROW_ID" => $pfs['pfs_id'],
				"GALLERY_ROW_VIEWURL" => "plug.php?e=galleria&f=".$pfs['pfs_folderid']."#datas/users/".$pfs['pfs_file'],
				"GALLERY_ROW_VIEWURL_POPUP" => $pfs['popup'],
				"GALLERY_ROW_FILE" => $pfs['pfs_file'],
				"GALLERY_ROW_FULLFILE" => $pfs['pfs_fullfile'],
				"GALLERY_ROW_THUMB" => sed_gallery_thumb($pfs['pfs_extension'], $pfs['pfs_file']),
				"GALLERY_ROW_ICON" => $icon[$pfs['pfs_extension']],
				"GALLERY_ROW_DESC" => $pfs['pfs_desc'],
				"GALLERY_ROW_SHORTDESC" => sed_cc($pfs['pfs_desc'], 64),
				"GALLERY_ROW_DATE" => date($cfg['dateformat'], $pfs['pfs_date'] + $usr['timezone'] * 3600),
				"GALLERY_ROW_NEW" => $pfs['new'],
				"GALLERY_ROW_SIZE" => $pfs['pfs_filesize'].$L['kb'],
				"GALLERY_ROW_DIMX" => $pfs['pfs_imgsize'][0],
				"GALLERY_ROW_DIMY" => $pfs['pfs_imgsize'][1],
				"GALLERY_ROW_DIMXY" => $pfs['pfs_imgsize_xy'],
				"GALLERY_ROW_COUNT" => $pfs['pfs_count'],
	//			"GALLERY_ROW_COMMENTS" => $pfs['comments'],
	//			"GALLERY_ROW_RATING" => $pfs['ratings'],
				"GALLERY_ROW_ADMIN" => $pfs['admin'],
				"GALLERY_ROW_COND1" => $pfs['cond1'],
				"GALLERY_ROW_COND2" => $pfs['cond2'],
				"GALLERY_ROW_TEST" => $num
					));
			$t->parse("MAIN.GALLERY.ROW");
			}
		$t->parse("MAIN.GALLERY");
		$count++;
	}

	$t->parse("MAIN.MENU");

	break;

Does it have something to do with sed_import do you think?
Thanks a lot for your help!

GHengeveld

Thu, 29 Okt 2009 15:18:52 -0000

Serialize should do it. Please provide some of your code. Error 950 could be because you're importing a variable which doesnt hold the right datatype. As far as i know this only happens if the last parameter of sed_import is set to true.

Sean

Thu, 29 Okt 2009 03:41:40 -0000

Ive got a problem with an SQL query in a plugin im writing. Im trying to pass an array into a MySQL Query, but im having some problems. Every time i try the plugin in my browser, I get redirected to the Error #905 (Wrong URL) error page. No mysql error, nothing. Whats going on? Ive tried passing the array into a variable, then serializing it, ive tried converting the variable but nothing seems to work. Any ideas? Thanks.

cotonti.com : PHP array in MySQL query??

GHengeveld

Sean

Kilandor

Sean

GHengeveld

Sean