Re: [Jason] Tag Cloud

Fri, 28 Oct 2011 10:15:53 -0700

Hi Jason,

Thats exactly what i need, but instead of counting duplicates could the function remove duplicate values?

Also i am struggling with extracting the tags from the array, no matter what i do i seem to always just get the numerical values out of the array, needless to say php coding is not my strongest area.

Also when returning the results it would be really good to have the functionality to limit the number of results and display them in a random order.

Again your help would be greatly appreciated.

Many thanks

Ryan

Re: [Jason] Website Search - with images

Thu, 20 Oct 2011 03:59:55 -0700

Hi Jason,

excellent, thats certainly a step in the right direction.

However i am getting some very strange results.

The image that is being returned is the same image for all the records, and the image that is being displayed isn't in the searchable tables.

not too sure whats happening to be honest.

I have attached my viewing code, to see if it is something in there.

    
  
  
          $images = array(); 
        
       if (array_key_exists($record['tablename'], $tableNameToUploadField)) { 
	 $query = "SELECT * FROM `{$TABLE_PREFIX}uploads` WHERE tableName = '".mysql_escape($record['tablename'])."' 
	         AND fieldName = '".mysql_escape($tableNameToUploadField[$record['tablename']])."' 
		     AND recordNum = '".intval($record['num'])."'"; 
		      
	 $images = mysql_query_fetch_all_assoc($query); 

       } 
     ?>

Again your help is greatly appreciated.

Many thanks

Website Search - with images

Wed, 19 Oct 2011 07:33:30 -0700

Hi all,

I have been searching the forums, and cant find a solution for the problem that i am having.

I have created a search page for the website that will return results from three tables. but i was wondering how i go about getting the images from the uploads table to the relative article.

i have created a working page search, but just need to tie in the uploads table. i have the following as a starting block:

 $searchOptions = array();
      $searchOptions['keywords'] = @$_REQUEST['s'];
      $searchOptions['perPage']  = "14";
	  $searchOptions['debugSql'] = "1"; 

      $searchTables = array();
      $searchTables['features'] = array(
        'viewerUrl'       => '/features/article.php',
        'titleField'      => 'title',
        'summaryField'    => 'content', 
        'searchFields'    =>  array('title','content'),
		'field1' => 'updatedDate'
      );
	   $searchTables['reviews'] = array(
        'viewerUrl'       => '/reviews/article.php',
        'titleField'      => 'title',
        'summaryField'    => 'content', 
        'searchFields'    =>  array('title','content'),
		'field1' => 'updatedDate'
      );
	   $searchTables['news'] = array(
        'viewerUrl'       => '/news/event.php',
        'titleField'      => 'title',
        'summaryField'    => 'content', 
        'searchFields'    =>  array('title','content'),
		'field1' => 'updatedDate'
      );
      list($searchRows, $searchDetails) = searchMultipleTables($searchTables, $searchOptions);
      ?>

Any help would be greatly appreciated.

Many thanks

Ryan

Re: [Jason] Join Tables over a hierarchy

Tue, 02 Aug 2011 15:52:20 -0700

Hi Jason,

Yeah that sounds like it might do it.

Could you give me an example of how i would extract the title information from tableB (assuming the field name would be title)?

If you can tell me that i should be able to figure the rest out

Cheers - Ryan

Join Tables over a hierarchy

Tue, 02 Aug 2011 08:53:27 -0700

Hi all,

I was just wondering if it possible to join tables in a hierarchy situation.

I have 3 tables linked to each other through 2 different fields.

tableA (level 1)
   )      
   -  relatedField1 (dropdown Menu)
   )
tableB (level 2)
   )
   -  relatedField2 (dropdown Menu)
   )
tableC (level 3)

I need all the results to be returned in one array, so that i can display all the relating data to tableA

Any help would be greatly appreciated.

Many thanks - Ryan

Article Listing - Advanced sorting

Wed, 27 Jul 2011 09:27:51 -0700

Hi all,

i just wondered if the following was possible in the admin article listing sort options?

i have created a section for events, with two fields (event_start & event_end) i would like the upcoming events to display first in the listing (with he start date that is closest to toady's date), then when there are no more future events, display the expired events by that ended closest to today's date.

I searched the forums as i thought that someone else may have asked the same question, but couldn't find anything.

Thanks - Ryan

Re: [kkegans] Problem with new install of 2.11 and Instant Website

Tue, 26 Jul 2011 04:08:51 -0700

Hey Kurt,

I found the solution to my problem, maybe it is the same for you.

See my last post in http://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/WYSIWYG_not_displaying_P89088/

Best of luck - Ryan

Re: [ross] WYSIWYG not displaying

Tue, 26 Jul 2011 04:05:56 -0700

Hi Ross,

I fixed it!! - Managed to find the code hidden away in the tiny_mce_gzip.php file around about on line 230.

I changed it to the following to match the file structure on the server.

// Set base URL for where tinymce is loaded from
		$buffer = "var tinyMCEPreInit = {base : '/cmsAdmin/3rdParty/tiny_mce/'};";

Hope this will help other people if they are having similar troubles.

Thanks for all your help guys & gals @ interactive tools.

Many thanks - Ryan

Re: [Jason] WYSIWYG not displaying

Mon, 25 Jul 2011 07:08:58 -0700

Hi Jason,

i have been looking on the tinyMCE support forums and have found something that could help, im just not too sure where i could integrate the change into the CMSB code.

The code that i think i need to integrate into CMSB is:

var tinyMCEPreInit = {base : 'path_to_tinymce_files'};

If you could tell me where i could include this then i can play around with the base variable until i can get it to work correctly.

Really do need to get this sorted out, as it is for a client with quite a tight deadline.

Thanks once again - Ryan

Re: [Jason] WYSIWYG not displaying

Thu, 21 Jul 2011 04:07:08 -0700

Hi Jason,

i dont think that it is a domain thing. i have pointed the full domain (gtserver.co.uk) into the development folder, but the WYSIWYG still isn't displaying.

I have submitted a support request with the hosts, to see if i can configure the BASE_URL. I will let you know what they say.

Many thanks - Ryan

Re: [Damon] WYSIWYG not displaying

Wed, 20 Jul 2011 04:45:02 -0700

Hi Damon,

Thanks for all your suggestions, but nothing has fixed the problem, i have filled in a support request.

Thanks anyway - Ryan

WYSIWYG not displaying

Tue, 19 Jul 2011 04:46:17 -0700

Hi, i have used CMSB a number of times, but this is the first time that i have had any problems with the installation.

the WYSIWYG is not showing up, all i get is two hyperlinks one for format and one for font size. (see attachment)

I have been through the FTP and tried to change all the .js files in the tinyMCE folder to 755, but no luck.

Any help would be greatly appreciated.

Many thanks - Ryan

Re: [Jason] Pull down (multi value) - Get options from database

Fri, 26 Nov 2010 06:08:44 -0800

Hi Jason,

I have attached the PHP file that I am working with.

The name of the multi-value is 'youtube_video_url'

This field then links to a table or section called 'cms_youtube_videos' and has two fields called 'title' and 'youtube_video_id'

I am not interested in displaying the title of the youtube videos, just the youtube video id. I was then going to create a for each loop and wrap the video id's into the youtube video embed code.

If there is anything else that you need, let me know

Kind regards

Ryan

Re: [Jason] Pull down (multi value) - Get options from database

Wed, 24 Nov 2010 04:37:30 -0800

Hi,

Thanks for that, but I'm still having some troubles.

Would you be able to provide me with an example page? I'm fairly new to PHP programming, I have searched through other posts to see if I can solve the issue myself, but to no avail.

Kind regards

Ryan

Pull down (multi value) - Get options from database

Mon, 22 Nov 2010 05:23:05 -0800

Hi,

Im having some troubles with extracting the multi-value results from on of my fields in the CMSB.

Basically I am trying to create a for each loop that for every value in the multi-value pull down it publishes the relevant youtube video.

I already have the embed code working for a static video, but need to make it dynamic so the user can add multiple videos to the system.

If you know a better way of doing this, or can help me out that would be grand!

thanks
Ryan