Re: [Jason] Membership plugin - photo upload page

Sat, 28 Apr 2012 03:11:18 -0700

That worked perfectly! Thank you :)

Membership plugin - photo upload page

Fri, 06 Apr 2012 08:33:47 -0700

Hi,
I'm just playing around with the membership plugin to see what I can do with it. I made a quick 'Photos' page to see if I could allow users to upload photos.

I used this and it worked fantastic -
http://www.interactivetools.com/iforum/Products_C2/CMS_Builder%3A_Plugins_%26_Add-ons_F40/Allow_Logged_in_Users_to_Access_Upload_Form_P85546/gforum.cgi?post=81668

I'm wondering though, is there anyway to list on my photos page which user uploaded the photos? I noticed a system field called updatedByUserNum so I added the line

Uploaded by:

But it just brings up the number of that user. I can't seem to get it to bring up the "username" field and can't figure out how to make that part of the photos section without making a field someone has to fill out manually (don't want this).

Any help appreciated :)

Membership Plugin - could I make a music/band community site with it?

Thu, 05 Apr 2012 04:14:43 -0700

Before I purchased this just wanted to check it will do what I need.

I want to start a band community site where users would sign up, then be able to comment and like various things on the site using their user account. They would have a profile page with all their information on it along with being able to do a lot of other things around the site.

A higher level of membership would allow users to make band pages on the site for their band.

Is this something I could accomplish with this add on?

Licensing Issues - stolen license

Tue, 28 Sep 2010 05:49:41 -0700

Hi,
I offer your CMS product to my web design clients. I don't purchase a license for them, but rather I purchase licenses I can use myself then I charge them a fee for the customisation work, then they pay a small monthly fee to use the license.

Recently I had another website company transfer our clients site to another host without our knowledge. They are now using the system with our license but refusing to pay the monthly fee!

I figured I would deal with this by going to the CMS, logging in and updating the license key to an old one which had already been cancelled by Interactive Tools. This has been a fine solution in the past, HOWEVER this time it didn't work as I guess that license number is not blocked anymore?

I need someone to either reblock that license, or cancel the license in question and provide a new one to me that I can use for another client.

Thanks :)

Re: [ross] Basic Search

Fri, 03 Jul 2009 10:35:38 -0700

Haha sorry probably should have included that!!

The site has products on it - I just want it to search the product name field. Don't know if it will be a problem that the products are all in different sections?

Anyway when you hit search with nothing typed in, it merely shows all the products from the first section listed (jewellery). If you type any word in at all it will say no products to display, even if you use a word that is in the title of an item

Basic Search

Tue, 30 Jun 2009 12:42:03 -0700

Hi,
Trying to create a standard search box for a site using the help guide yet having no luck. Here's what I have so far....

SEARCH FORM

RESULTS PAGE

  require_once "/mysiteaddy/viewer_functions.php";

  list($jewelleryRecords, $jewelleryMetaData) = getRecords(array(
    'tableName'   => "jewellery",
  ));
    
  list($products_lea_steinRecords, $products_lea_steinMetaData) = getRecords(array(
    'tableName'   => "products_lea_stein",
  ));  
  
  list($products_vintage_jewelleryRecords, $products_vintage_jewelleryMetaData) = getRecords(array(
    'tableName'   => "products_vintage_jewellery",
  )); 
   
  list($products_gentlemensRecords, $products_gentlemensMetaData) = getRecords(array(
    'tableName'   => "products_gentlemens",
  ));  
  
  list($products_decorativeRecords, $products_decorativeMetaData) = getRecords(array(
    'tableName'   => "products_decorative",
  ));  
  
  list($products_collectiblesRecords, $products_collectiblesMetaData) = getRecords(array(
    'tableName'   => "products_collectibles",
  )); 
   
  list($products_sewingRecords, $products_sewingMetaData) = getRecords(array(
    'tableName'   => "products_sewing",
  ));  

?>

Re: [ross] Move CMS and all data from webhost to another

Fri, 22 May 2009 06:13:13 -0700

Hi Ross. Yes I did as you described as above but was stuck at uploading the data.

WOW. Can't believe how many different things I had to try to figure out what it wasn't working!! Have finally managed to copy my first site over. For anyone else reading experiencing problems I kept getting an error in phpadmin saying table already exists for each section.

I exported the data again but made sure "IF NOT EXISTS" was NOT checked, and as soon as I did that the data uploaded and is now working fine!

Re: [_kate_] Best way to use link field option

Thu, 07 May 2009 06:41:00 -0700

The support rep wasn't able to help and instead referred me to the consulting dept.

Is there anyone here who has done something similar that may be able to help out and offer some possible solutions? Any help appreciated :)

Re: [ross] Move CMS and all data from webhost to another

Thu, 30 Apr 2009 04:43:44 -0700

Hi,
My new webhost has been trying to sort this out for me. Here's what they said >

I have tested the database that was has uploaded and even tried to import the sql dump on a separate test database and use this test
database instead (this test database has now been deleted). Unfortunately it looks like further application settings (apart from updating the database details) might need to be changed in order to have the database data displayed in the application. In most cases, importing the database tables into a database hosted with us and simply updating the database details is sufficient to have the website working as expected.

We have imported the database and updated the database settings accordingly onto the application, however the data still does not load as expected. I have tried to look on the application help webpage and I believe I found your thread there (this one).

If so, are you able to ask Ross, if there is anything else that needs to be
done apart from importing the database dump into the existing database and updating the database details?

Re: [ross] Featured rental listings

Sun, 26 Apr 2009 10:14:42 -0700

Woohoo! When I got rid of the where, and used 'orderBy' => 'updatedDate DESC' it worked like a charm.

Thanks Ross!

Re: [ross] Move CMS and all data from webhost to another

Sun, 12 Apr 2009 12:08:54 -0700

Hi Ross,
The current webhost told me how to create a SQL dump and then he offered to do it for me.

I got that file and tried to upload it to the new webhost using the instructions they gave me below and it didn't work. Showed an error message. It appeared to create one of the sections (about) which I could now see in Phpmyadmin but still nothing displays when you login to the CMS.

"To restore a SQL database dump you will need to login to your domain
name and select database, once in your database administration page you need to create a new database.

Once this new database has been created click on its name and it should start up PHPmyadmin, once it has loaded up in the top right hand side of the page you should see a little box that says SQL, if you click on that a new page will open and you should see a option called Import files, now just browse for you SQL dump and import it."

Re: [Damon] Best way to use link field option

Fri, 10 Apr 2009 12:03:07 -0700

Hi Damon,
Thanks for the quick response! I have sent my details using that form now.

Re: [ross] Best way to use link field option

Fri, 10 Apr 2009 09:43:42 -0700

Hi Ross,
I *think* we are getting there :P

Ok so after the client edited a couple of the agent records, data is now showing on the site as it should - only problem is for some reason it doesn't show the agent you selected, it is instead just showing ONE of the records for every single listing.

I thought maybe it was showing the first agent listed in the CMS and experimented moving them around with the drag/drop, but it still shows the same agent regardless. Strangely the same thing happens in the rentals section, instead it is displaying a different agent and doing it for every single one as well regardless of whats selected.

Any ideas what is going on here? When linking the sections, in the Field Options I chose
Section Tablename - agents
Use this field for option values - title
Use this field for option labels - title

The agents section has 2 fields - title and content.

Re: [ross] Move CMS and all data from webhost to another

Mon, 06 Apr 2009 05:01:48 -0700

I've contacted both hosts about that - here's what they said >

Current webhost:
We do allow external connections to MSSQL databases but not MySQL.

New webhost:
Depends on the database type, generally for the connection based db's
like MySQL yes, you can connect to them externally.

If you provide a little more information I can give a more rigorous answer. It also depends on the connection type. Perhaps you could describe exactly what you are trying or planning to do.

Re: [ross] Featured rental listings

Sun, 05 Apr 2009 10:42:42 -0700

Almost there :)

Got it working and displaying the featured listing, but it doesn't change if I specify another listing as the featured after any others I have selected. I assume the problem is the header as I wasn't sure what to put there to get only featured ones to display >>

  require_once "/mysite/viewer_functions.php";

  list($salesRecords, $salesMetaData) = getRecords(array(
    'tableName'   => 'sales',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
    'where' => ' featured = "1" ', 
    'orderBy' => 'updatedDate', 

  ));
  $salesRecord = @$salesRecords[0]; // get first record

?>

Re: [ross] Best way to use link field option

Sun, 05 Apr 2009 05:44:52 -0700

Hi Ross,
Did as instructed, yet not quite working yet. This is going on the detail page so maybe I need to adjust some code for that? Here's what I've got so far >

  require_once "/mysite/viewer_functions.php";

  list($salesRecords, $salesMetaData) = getRecords(array(
    'tableName'   => 'sales',
    'joinTable'   => 'agents', 
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $salesRecord = @$salesRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$salesRecord) {
    print "Record not found!";
    exit;
  }

?>

And to display the agent details >

There is no error message showing where the agents detail should appear - instead it just remains blank...

Re: [ross] Best way to use link field option

Thu, 02 Apr 2009 23:11:55 -0700

Hi Ross,
I had already set up the agents section with the required fields. The problem came when I tried to connect it to the listings section. Not sure I did it right as the data wouldn't all display. Added a list field and told it to pull data from agents field so you could pick the agent from a drop down - seemed I could only pick one data field to display on setup instead of showing them all. So is that the correct way to do it and then use a code that lets u display all the data? Or do I need to do something else?

Thanks!

Re: [ross] Move CMS and all data from webhost to another

Thu, 02 Apr 2009 03:30:34 -0700

Kenny are you or anyone else able to offer advice on this problem? :/

Re: [ross] Featured rental listings

Thu, 02 Apr 2009 03:15:06 -0700

Thanks Ross. I'll be able to do it, just need to know what to write to get it to sort by last updated time.

Thanks!

Re: [ross] Best way to use link field option

Thu, 02 Apr 2009 03:09:13 -0700

Does anyone have an answer to this problem?

As expected the client has seen the site and requested that she can pick the agents from a list instead of having to type it in for every listing.

Does anyone know how I could get this working?

Thanks!

Featured rental listings

Sat, 28 Mar 2009 05:47:15 -0700

On a real estate website with a field for rentals and sales, what would be the smartest way to feature one from each section on the front page of the website?

Would like the client to be able to choose which should show on the front page.

Thanks!

Re: [ross] Move CMS and all data from webhost to another

Sat, 28 Mar 2009 05:26:27 -0700

Hi,
I've been having some problems with this. I upgraded the old site to the new version, then exported the data as detailed below.

Created database and installed CMSB on the new site. When to the SQL tab to upload the .sql file in phymyadmin and I kept getting an error saying I didn't have user permissions to do that.

My web host said the problem was I was trying to create a database in another database which isn't allowed, and he removed the create database from my file and uploaded it - I figured it would now work but I logged into CMSB and it looks exactly as it does on install and none of my data is there.

Any help is appreciated :/

Re: [Dave] Displaying only one image

Tue, 24 Mar 2009 21:53:43 -0700

Ahhhhhhhhh I see :)

Cool thanks! Working perfectly now :)

Re: [ross] Displaying only one image

Tue, 24 Mar 2009 10:51:19 -0700

Hi Ross,
No it definetely says 10.

The code appears to work fine - I created the rentals list page which displays all the rentals and it works fine (keeps 10 to a page).

Then I simply added this -

So I could have a separate page for Residential and Commercial and thats where the problem started. The Res page displays 4 on the first page, and the Comm page displays 6??? It's very odd.

I will PM you a link to the live pages so you can see what I mean...

Re: [ross] Best way to use link field option

Tue, 24 Mar 2009 10:44:45 -0700

Hi Ross,
Thanks for your reply.

It doesn't have to be the person that created the listing - the secretary will probably do all of these. I just thought it could save some if they didn't have to enter the agents details for every listing.

I am making a real estate page with a listing layout like the page below >
http://www.colliersresidential.com/listings.cgi?listing=4893&perpage=20&rm=viewListing&s=r

See the bit down the side with the agent details? I made an agent field for these details with a WYSIWYG field. Then it occured to me with hundreds of listings, they would have to keep typing the same info so I tried to make a list field which they could choose the agent name from and linked it to a new section called "Agents". It works fine in the CMS, but on the site it only displays the one field - agent name as in the CMS it will only let me select one field for the content...

Sorry I am trying to explain it as clearly as possible... it doesn't have to work exactly how I mentioned, jhust need the best solution for the above problem :)