Joining Tables

Mon, 03 Dec 2012 15:03:55 -0800

Hello...

Need some help.

I have 2 tables - User_Profiles & User_Submissions. The common denominator is user_id, which can be used to link both tables.

The way the sections function:

I have an iphone app that uses fb authentication to register users if they want to submit content. On initial sign on, a web service checks to see if the user has an account. If there is not account, it creates on and pulls all user data from fb and writes to the use_profiles table.

The user can then post content, and it writes that data to the user_submissions table. In both tables, the unique identifier & link is the user_id.

What I need to do is link both tables with the user_id, and then pull the user thumbnail image from the user_profiles section and display is when the content from the user_submissions is pulled.

I hope that makes sense. Thanks

Re: [Damon] 2.17 Bug

Tue, 09 Oct 2012 12:59:37 -0700

Hi Damon,

I gave it another shot. It works on chrome, but not on safari. I am on a mac.

2.17 Bug

Tue, 09 Oct 2012 00:06:02 -0700

hi, i just upgraded to 2.17 and have some issues. how can i get this resolved, at the earliest?

lightbox editors do not show up in browsers. view html source, paste as text or word doc, etc.

see attached screenshot.

Year + Month in url?

Wed, 18 Jul 2012 16:07:34 -0700

is there a way to dynamically create or add the year + month in the url?

alot of the news/magazine sites, as well as blogs, file their content by year and month. ie: http://www.domain.com/2012/07/conent.php

Thanks

Re: [gkornbluth] Changing Field Type

Fri, 13 Jul 2012 04:22:24 -0700

Hi gkornbluth,

Thanks for the pointers. This really helped! I had enough time to tackle the field type.

Files to edit: uploads.ini.php, uploadModify.php, editField.php & style.css

Uploads.ini.php (changed type from varchar to medium text)
[info5]
order = 32
customColumnType = "mediumtext NOT NULL"

Although I can't edit just 1 info field. This would require a lot of code mod. So I just kept it simple and edited the code that will modify all the info fields.

uploadModify.php (from textfield to text area)

$fieldHTML = "";

I also removed the character limit of 255.

Next I will be working on the gallery over the weekend.

Many thanks for your help!

Changing Field Type

Wed, 11 Jul 2012 12:57:05 -0700

Hi,

Backend questions:

Is it possible to change the field from textfield to wysiwyg box for the captions (info1, info2, etc) in the image upload area?

The current character count is limited, I need to expand that, plus have the ability to add html attributes.

Also, is there a way to dynamically add text boxes, much like the way the image upload functions? This pertains to galleries. I want to be able to insert video code in between images, or have a gallery entirely of videos.

I want to be able to add or delete text boxes at will, and use a foreach statement in the frontend to pull the # of boxes.

Does that make sense?

Thanks

Category List plus # of items

Wed, 13 Jun 2012 03:32:13 -0700

Hi,

I wanted to see if you have any sample code that shows the total categories, include the number of items in each category.

See example here:

http://clients.xhtmlchop.com/31912/3wldy2ut7x31912/inner4.php

many Thanks!

Re: [Jason] Next Article Code

Wed, 13 Jun 2012 03:09:02 -0700

So the same function will work if I want just the next record to show (an not previous, etc)?

I am adding an article slide-out on my site (example if you scroll down towards the bottom of the page: http://clients.xhtmlchop.com/31912/3wldy2ut7x31912/inner1.php)

Next Article Code

Tue, 12 Jun 2012 11:36:37 -0700

I wanted to include a next arrow on the article page so when users click on it, they will be taken to the next article that follows.

Is there sample code I can look at?

Thanks

Re: [Jason] GeoCoder URL Query

Mon, 04 Jun 2012 19:11:30 -0700

Hi Jason,

Thanks for the quick reply. What if I want to implement this code on a mobile device or website that pull user geolocation? How can I insert the user location into the code and then show a list based on a 100 mile radius?

Re: [Damon] GeoCoder URL Query

Mon, 04 Jun 2012 14:23:57 -0700

Hi Damon,

Thanks for the prompt reply. I have a sample page setup here: http://www.illumemagazine.com/indulge/xxx.php

What would I use as the url query to show a list of places nearby (no radius limit)..starting with closest to farthest?

Many thanks for your help.

GeoCoder URL Query

Tue, 29 May 2012 03:02:59 -0700

Dear Support Team,

How can I do a url/search query to show listing within specific parameters?

IE show events within 50miles... 25miles... etc

Thanks

Date Format

Tue, 29 May 2012 03:01:18 -0700

Dear Support Team,

I was wondering in what format do I need to list the date in order to show how much time has passed since posting...IE: 5m ago, 1h ago, 2w ago, etc...

Thanks

XML Webservice Help?

Mon, 23 Apr 2012 01:22:13 -0700

Hi,

I wanted to see if anyone can offer assistance. I am having mobile applications done for my website. We have a citizen media section that will allow users to post/upload photos or videos. For video service, I have the upload linked directly to my youtube account. For article/photo, my developers have asked me to give them an webservice that will take user uploads (name, emails, text, photo) and post them into CMS Builder. This part needs to be via xml.

I am not sure how to go about setting this up. Any help will be appreciated.

Regards,

Javed

Mobile Platform Development - Android, iPad, iPhone

Sun, 26 Feb 2012 03:46:15 -0800

Hey All,

I specialize in app development and can integrate apps with CMSB. I do complete design and development and provide full support. If anyone is interested, contact me at javed.ali@illumemag.com.

Thanks!

Submission form - attachment

Sun, 26 Feb 2012 02:35:19 -0800

Hi,

I have created a submission form (http://illumemagazine.com/zine/submit.php) where user can submit a general inquiry with standard text boxes (name, email, comment). I have included an upload field, but I am getting errors when users try to send an attachment through.

Error: MySQL Error Creating Record:
Unknown column 'uploaded_file' in 'field list'

I have attached the form to this thread.

On a similar note, is it possible to create a separate submission form so users can submit an article directly from the site, and when they attach an image, instead of coming through as an attachment, it shows up more like an upload (like a standard article). So all the admin has to do is to approve the content and it shows up on the homepage...

I also have apps due to release on ipad, iphone & android platforms... Part of the apps encourage user submission of photo/video...with written captions. This feature will directly tie in to the submission form. So any help with be appreciated!

Re: [Jason] Form Error - Help?

Fri, 29 Jul 2011 11:35:18 -0700

Yes. Its only on this page I see the error. I just copied a comments submission form Ross had created a while back and modified it. Took out existing code and added a file upload field.

Form Error - Help?

Thu, 28 Jul 2011 03:47:06 -0700

Hi... I created this form (below).. and this is the error I am receiving. Not sure what I'm doing wrong. Any help would be appreciated.

ERRORS:

Warning: mysql_query() [function.mysql-query]: Access denied for user 'illumema'@'localhost' (using password: NO) in /home/illumema/public_html/zine/journo.php on line 23

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/illumema/public_html/zine/journo.php on line 23
MySQL Error Creating Record:

CODE

// load viewer library
 // load viewer library
 $libraryPath = '../cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/home/illumema/public_html/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }


  
?>




Untitled Document




  //config
  $adminURL = "../cmsAdmin/admin.php";
  $moderatorEmail = "comments@illumemagazine.com";


  

  
    // add record
     if (@$_REQUEST['formSubmit'])  {
      mysql_query("INSERT INTO `{$TABLE_PREFIX}journo` SET
              
                        name          	   	= 'name',
                        email             	= 'email',
                        description           	= 'description',
						uploaded_file      	= 'uploaded_file',
  
                        createdDate       = NOW(),
                        updatedDate       = NOW(),
                        createdByUserNum  = '0',
                        updatedByUserNum  = '0'")
      or die("MySQL Error Creating Record:
\n");
		
	
		  
  }
	
   
?>



   
          
          

          
          
            
             
				Name 
          
              

              
                Email 
                 
              

              
                Description 
                  

                 Select A File To Upload:

Re: [Jason] Adding tags in the url?

Sat, 18 Jun 2011 15:02:32 -0700

Thank you Jason. actually what I mean was that if you visit any news site, the article URL usually reflects the year and month it was created. So for instance, if someone comes to my site, instead of illumemag.com/articleDetail.php?Article-Title-001, the URL would be illumemag.com/2011/06/articleDetail.php?Article-Title-001 to reflect the month and year the article was published.

Adding tags in the url?

Thu, 16 Jun 2011 18:20:48 -0700

How can we add tags.. ie: year & month in the article link and have it update automatically each month? are there special tags we can use?

domain.com/2011/06/articleDetail.php

Re: [Jason] Geolocation Coding Help

Tue, 07 Jun 2011 12:29:22 -0700

Hi Jason.

You rock! Awesome. It worked. Many thanks.

Last thing, how do I exclude the current listing from showing up.

See live example: http://indulge.illumemag.com/

Re: [Jason] Geolocation Coding Help

Tue, 07 Jun 2011 12:01:47 -0700

Thanks for the quick reply jason.

So when I add this:

$_REQUEST['fromAddress'] = ""; // The ZIP code you want to use goes here

on the front end, I get this error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/illumema/public_html/indulge/index.php on line 53

Geolocation Coding Help

Tue, 07 Jun 2011 10:58:51 -0700

Hi,

I wanted to know how to make 2 mods to the example files that come with the geocoder. The first is the for the proximity search.

Instead of manually searching a zipcode and returning results like the example code does, how can i use a placeholder for the zip and upon loading the page, it will automatically query based on the zipcode on the page and return results? I want the form to submit automatically with placeholder and then return the nearest 10 results.

Second is similar along the lines, but this is for the multiple map listings. Based on the placeholder , the map would show the 10 nearest locations.

Thanks

Code Optimization Help

Tue, 31 May 2011 12:51:27 -0700

Hello,

I wanted to reach out in the forum to see if someone can help me optimize my php script.

My website is www.illumemag.com. As you can see from the home page, there are several sections on the site, and I am using below codes.

When the site was first setup, it had a simple script, which pulled data and arranged it in 4 sections.

  // load records
  list($articleRecords, $articlesMetaData) = getRecords(array(
    'tableName'   => 'am_articles',
	'where'       => "approved = 1 AND category NOT LIKE '%357%'" . $andDontRepeatSlideshowClause,
  ));

	 $articlesInBlock1 = array_slice($articleRecords, 0, 1);   // article 1 
	 $articlesInBlock2 = array_slice($articleRecords, 1, 2);   // article 2-4   (3 articles)
	 $articlesInBlock3 = array_slice($articleRecords, 3, 8);   // article 5-10  (5 articles)
	 $articlesInBlock4 = array_slice($articleRecords, 11, 11);  // article 11-20 (10 articles)
	  $articlesInBlock5 = array_slice($articleRecords, 22, 1);  // article 11-20 (10 articles)

 // from the media
  list($linksoutRecords, $linksoutMetaData) = getRecords(array( 
'tableName'   => 'am_articles', 
'where'       => "approved = 1 AND media = 1", 
'orderBy'     => "publishDate DESC",
    'allowSearch'     => false,
'limit'       => 5, 
)); 
  
  // do not repeat
  $andDontRepeatSlideshowClause = ''; 
if ($linksoutRecords) { 
  $slideshowNumsCsv = join(',', array_pluck($linksoutRecords, 'num')); 
  $andDontRepeatSlideshowClause = ' AND num NOT IN (' . $slideshowNumsCsv . ')'; 
}

I have had to modify the code and add several sections, which I think is causing latency issues and server crashes. Is there a way to have a simpler way of listing?

// load records
  list($oneRecords, $oneMetaData) = getRecords(array(
    'tableName'   => 'am_articles',
	'where'       => "approved = 1 AND category LIKE '%176%'" . $andDontRepeatSlideshowClause1,
  ));

	 $oneInBlock1 = array_slice($oneRecords, 0, 1);   // article 1 
	 $oneInBlock2 = array_slice($oneRecords, 1, 4);   // article 2-4   (3 articles)

Since the site's launch, I have had to add several more sections as evident by the home page. Each section has a similar script like this.

// load records
  list($oneRecords, $oneMetaData) = getRecords(array(
    'tableName'   => 'am_articles',
	'where'       => "approved = 1 AND category LIKE '%176%'" . $andDontRepeatSlideshowClause1,
  ));

	 $oneInBlock1 = array_slice($oneRecords, 0, 1);   // article 1 
	 $oneInBlock2 = array_slice($oneRecords, 1, 4);   // article 2-4   (3 articles)

I also use the navbar to load articles with a script like this:

// load main article list
			list($category3Records, $category3MetaData) = getRecords(array(
				'tableName'   => 'am_articles',
				'perPage'			=> '4',
    'where'       => "category LIKE '%282%' AND approved = 1",
	    'allowSearch'     => false,
			));

So in the end, there is close to 25 or so hits to the query mysql and display results.

Is there a more efficient way of achieving this? I think this causes my server to slow down and crash.

Re: [Jason] Passing coordinates automatically to geocoder

Thu, 26 May 2011 12:11:29 -0700

Hello Jason,

Thanks for the quick reply. Do you know how i might be able to pull coordinates based on browser/ip location?

What I ideally want to do is... to guess the user's location and then suggest the nearest 10 listings showing with markers on the map...

Any ideas?