Re: [Maurice] Disappointed

Wed, 14 Sep 2011 17:54:22 -0700

me 2 agree with benidict

we are making the leap to WP 3.0

tip!! small fast sites use cmsb Reale the best.
making demo sites CMSB is also the best
mid range sites use WP 3.0
Larger complex sites any of the big names in CMS world.

this prevents many frustrations
use the right tool for the right project we learned.

Greetz M

I don't agree with this at all, CMSB is definitely usable for complex sites.

Re: [Jason] Display one's search query

Thu, 18 Aug 2011 20:29:47 -0700

Worked perfect, thanks!

Re: [Hansaardappel] Display one's search query

Wed, 17 Aug 2011 20:39:31 -0700

Ran into a new problem and I found out it has to do with my solution to the previous problem I had. To display the search query I did the following:

form code:

And in my search.php page I added the following line:
$searchquery = $_POST["tags,content,title_keyword"];

To display the results on search.php I use this code:

 Search Results for ""
 
     
      Title: 
 
      Category: 
 
      Tags: 
 
      _link : 
 
      
 
      
 
     
      No records were found!

The result is good, except for the category. The notice I get:

Notice: Undefined index: 2 in C:\xampp\htdocs\xampp\cmsbuilder\search.php on line 173

I found out that this has to do with the fact that I use $numToName, because I do get the result 2 (category 2) when I remove the $numToName part. Normally the $numToName function works fine though and it ALSO does in search.php if I delete $searchquery = $_POST["tags,content,title_keyword"];

Could anyone explain to me why the $numToName function doesn't work when I add the $searchquery = $_POST["tags,content,title_keyword"];
part? And even more important, does anyone have any suggestions on how to fix it?

Thanks again for your help :)

EDIT:
This is the code I use for $numToName at the top of my page:

  $numToName=array(); 
 
  foreach($categoryRecords as $record){ 
     $numToName[$record['num']]=$record['name']; 
  }

Re: [Hansaardappel] Display one's search query

Wed, 17 Aug 2011 19:34:31 -0700

Figured it out already :)

Re: [Jason] Two problems when setting up a photo gallery

Wed, 17 Aug 2011 12:52:12 -0700

That does get rid of the notice, now I get this notice though (and no images showing at all):

Notice: Undefined index: images in C:\xampp\htdocs\xampp\cmsbuilder\articles4.php on line 150

Re: [Jason] Display one's search query

Wed, 17 Aug 2011 12:42:37 -0700

They can enter whatever they want :) Here's the code I use:

Display one's search query

Wed, 17 Aug 2011 11:27:08 -0700

This may be very easy, but I have no idea how to accomplish it.

I want my search page to look like this:

Search Results for "The search query they entered":

result1
result2 etc...

I got it working as I want, but how do I display the search query?

Thanks!

Re: [Jason] Two problems when setting up a photo gallery

Tue, 16 Aug 2011 15:37:11 -0700

Hi Jason,

I just tried your suggestion, but unfortunately without succes. I get exactly the same notice and not the desired effect. Here's my current "body code"... is anything wrong with it?

      




Photo Gallery













" />

Any other suggestions? I've searched around the forums quite a bit, but that didn't help me any further either.

Thanks again :)

Re: [Jason] Two problems when setting up a photo gallery

Mon, 15 Aug 2011 18:49:53 -0700

Hi Jason,

Thanks for your reply. Unfortunately it gives me the following notice (and it messes up my design):

Notice: Undefined index: listPageOrder in C:\xampp\htdocs\xampp\cmsAdmin\lib\viewer_functions.php on line 54

Any suggestions?

Thanks!

Two problems when setting up a photo gallery

Fri, 12 Aug 2011 14:35:49 -0700

Hi,

It often happens that when I write an article, I end up uploading 10+ pictures. One of those pictures ends up in the body of my article and the rest as thumbnails in a menu on the side. The problems I have are with the thumbnail images. The first thing is that the picture I use in the article body also ends up in the gallery, although I don't want it to. The second is that when I upload 6+ images, the menu becomes too crowded. I'd rather show 6 and add a "next page link" to show the rest.

To start off, here's my code at the top:

list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $articlesRecord = @$articlesRecords[0]; // get first record 

list($categoryRecords,$categoryMetaData) = getRecords(array( 
       'tableName' => 'categories', 
       )); 
 
  $numToName=array(); 
 
  foreach($categoryRecords as $record){ 
     $numToName[$record['num']]=$record['name']; 
  }  

  foreach($articlesRecords as $thumbnails){
  };
  
    list($thumbnailsRecords,$thumbnailsMetaData) = getRecords(array( 
       'tableName' => 'articles',
     'offset' => 1
       ));

The gallery code:













" />

Thanks in advance for any help offered!

Re: [Hansaardappel] Hide last record in the "Other News" section

Thu, 11 Aug 2011 21:23:25 -0700

Nevermind, just did a search and found an old thread that showed me that something as simple as offset would do the trick :)

Hide last record in the "Other News" section

Thu, 11 Aug 2011 21:01:32 -0700

Hi Guys,

I have a small problem with my index page. Today I changed the setup of my index page, making a small preview + image (kinda like a headline) for my last record and then showing the list of other news. Despite my lack of PHP knowledge, I managed to create a summary, but the one problem I have now is the fact that the last record also appears in the other news section.

So let's say my last 3 articles are called
1. Netherlands (last article and therefore the headline)
2. Belgium
3. Australia

My question now is, how do I remove Netherlands from the other news section?

Here's my code at the top of the page:

list($categoriesRecords, $selectedCategory) = getCategories(array( 
    'tableName'   => 'categories', 
  ));

  list($articlesRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'articles',
	$exclude= 2,
  ));
  
  list($categoryRecords,$categoryMetaData) = getRecords(array( 
       'tableName' => 'categories', 
       )); 
 
  $numToName=array(); 
 
  foreach($categoryRecords as $record){ 
     $numToName[$record['num']]=$record['name']; 
  } 
  
  foreach($articlesRecords as $headlines){
  };
  
    list($headlinesRecords,$headlinesMetaData) = getRecords(array( 
       'tableName' => 'articles', 
	   	'limit'       => '1',
       ));

My code in the body of my page:

  function maxWords($textOrHtml, $maxWords) {  
  $text = strip_tags($textOrHtml);  
  $words = preg_split("/\s+/", $text, $maxWords+1);  
  if (count($words) > $maxWords) { unset($words[$maxWords]); }  
  $output = join(' ', $words);  
  
  return $output;  
  }  
?>
     
     

  
      
: 
      

      
      " />

      
      ?>
    

    
      No records were found!


    
  
  ...

  Read More »

        
Other News

Thanks!

Re: [Jason] Excluding specific record

Mon, 19 Apr 2010 13:37:12 -0700

Thanks Jason, once more exactly what I had in mind. Thanks so much!

Re: [Jason] Small where clause issue

Mon, 19 Apr 2010 12:58:13 -0700

This works perfect, thanks so much Jason. There's one last issue I'm dealing with and after that, I promise not to bug you again for at least a month [sly] I posted that problem here: http://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/Excluding_specific_record_P79496/

Thanks!

Kind Regards,
Hans

Re: [Jason] Small where clause issue

Mon, 19 Apr 2010 11:36:52 -0700

Thanks for replying Jason. I changed the code to what you said, but still no results...

Re: [sagentic] Excluding specific record

Sun, 18 Apr 2010 20:40:15 -0700

Thanks for the reaction, but that's not really want I meant. My idea is to exclude "item 2" on a certain page, and show it on another page, where I exclude another record.

Re: [Hansaardappel] Small where clause issue

Sat, 17 Apr 2010 11:10:00 -0700

*Sigh* ran into another problem...

I wanted to display the records that belonged to BOTH "ATP" and "Australian Open" category. The code I used:

'tableName'=>'categories',
'where'=>"name='ATP' AND name='Australian Open'",
));
$catlist="'";
foreach($catsRecords as $cats){
$catlist.="%\t".$cats['num']."\t%";
}
$catlist.="'";
?>

'tableName'=>'fpvideo',
'where'=>"category LIKE $catlist",
'orderBy'=>'createdDate ASC',
));
?>

This doesn't show any results though. What am I missing here?

Excluding specific record

Fri, 16 Apr 2010 17:39:32 -0700

Is it possible to exclude a specific record? Say I've got a category that contains item 1 till item 10 and I want to display every item, except for number two. What code should I use to achieve this?

Thanks!

Re: [Jason] Small where clause issue

Fri, 16 Apr 2010 16:25:49 -0700

Just what I wanted. Thanks for all the help today Jason it's really appreciated!

Greets,
Hansaardappel

Re: [Jason] Small where clause issue

Fri, 16 Apr 2010 14:43:47 -0700

Hi Jason,

It works once again, there's just one little problem. When an entry is assigned to multiple categories, I'm having a bit of trouble to get the content displayed. There's this entry that's assigned to two categories, namely "ATP" and "Australian Open". I use this code:

$query ="Select num from cms_categories where name='Australian Open'";

It doesn't show me the content and I think it's because of the fact that the entry is also assigned to ATP, because when I add the entry only to the category Australian Open, it does work.

Suggestions?

Re: [Jason] 3rd party comment script interferes with CMS Builder

Fri, 16 Apr 2010 13:43:09 -0700

Works like a charm, thanks you SO much. Lol I've been working on this for over 8 hours and a couple of minutes is enough for you... I feel like an idiot [;)]

Thanks again!

Re: [Jason] 3rd party comment script interferes with CMS Builder

Fri, 16 Apr 2010 13:09:37 -0700

Thanks... attached!

Re: [Jason] 3rd party comment script interferes with CMS Builder

Fri, 16 Apr 2010 11:47:38 -0700

Sorry, should have posted that in this thread :)

The CMS Builder content that doesn't show is the "In the spotlight" content in the upper right corner and the "related videos" on the right side of the comments. It shows at first, but as soon as a comment is posted, the content "disappears".

Re: [Jason] Small where clause issue

Fri, 16 Apr 2010 11:18:38 -0700

Hey Jason, thanks for replying.

I think you misunderstood my post, the function already works when I use the code
'where' => "category LIKE '%\t5\t%' AND MONTH(createdDate) = 3 AND YEAR(createdDate) = 2010",

Instead of using using tab 5 (t5 in code) I want to use the name of tab 5 (which is ATP). Is that possible and if so, how?

Thanks!

Re: [jonoc73] lookupReferringRecords Error

Fri, 16 Apr 2010 07:54:01 -0700

If I run this on a page without the plugin Chris made, it loads the page fine but WITHOUT any cms content. Does the viewer_functions.php file not run when programmes on the server are returning to a page? or is it something else? How would i force it to run in php?

thanks Jono

This is EXACTLY the problem I'm currently facing. Did anyone come up with a suitable answer?