As you said, "you can use field1, field2, etc. to add up to 10 additional fields"

Since 10 fields is not enough for my search page.

Is it possible to add more fields?

For example add up to 20 additional fields.

Thank You

Thank You

I've just upgrade from 3.04 (Build 2081) to 3.56 (Build 2304).

Since I have a very big database.

When I was using the old version.

I was told that there is only a 1000 field listed.

The solution was below.

If you want to change it, it's in /lib/database_functions.php in the function: getListOptionsFromSchema();
If you search for "LIMIT 0" you'll find this line:        $query        = "SELECT `$valueField`, `$labelField` FROM `$selectTable` $where $orderBy LIMIT 0, 999";

If you change it from 0, 999 to 0, 1499 then you'll get another 500 records.  

However after I upgraded to the new version of CMSB,

in /lib/database_functions.php, there is no such a code can be amended.

Please refer the the attach screen capture and advise.

Thank You

This is perfect.

Thank You

Below is my code.

<?php $movie_cat = array_combine($listing['movie_cat:values'], $listing['movie_cat:labels']); ?>
<?php foreach ($movie_cat as $movie_catNum => $movie_catName): ?>
<a href="listings.php?movie_cat=<?php echo $movie_catNum;?>"><?php echo implode( ', ', $listing['movie_cat:labels'] ); ?></a>
<?php endforeach ?>

What I intend to do is output TEST1, TEST2, TEST3 instead of Test1 Test2 Test3

However it returns

Test1,Test2,Test3 Test1,Test2,Test3 Test1,Test2,Test3

Could you please take a look on it.

Thank You

Thanks for your info and I've just use a stupid way to solve it.

Thanks again

"director": {
                "@type": "Person",
                "name": "abcdefg"
              }
            }
          }<?php if($listingDetails['totalRecords'] != $counter)
            { echo ",";} ?> 
		   <?php $counter++ ?>
               <?php endforeach ?>
      ]
    }
    </script>

I intend to remove the last comma in the last string.

I did try rtrim but no success.

<script type="application/ld+json">
{
"@context": "https://schema.org",
"@type": "ItemList",
"itemListElement": [
<?php $counter = 1; ?>
<?php foreach ($listingRecords as $listing): ?>
<?php foreach ($listing['uploads'] as $upload): ?>
{
"@type": "ListItem",
"position": "<?php echo $counter; ?>",
"item": {
"@type": "Movie",
"url": "<?php echo $listing['_link'] ?>",
"name": "<?php echo $listing['ref_no1'] ?>",
"image": "<?php echo $upload['urlPath'] ?>",
"dateCreated": "<?php echo $listing['date_added'] ?>",
"director": {
"@type": "Person",
"name": "abcdefg"
}
}
},
<?php $counter++ // increment counter ?>
<?php endforeach ?> <?php endforeach ?>
]
}
</script>

It's all about the output of the last listing.

There is a comma in the last part of listing.

"@type": "Person",
"name": "abcdefg" 
}
}
},  <-- remove this comma in the last listing-->
]
}
</script>

Is there any method to remove the comma in the last listing?

Thanks a lot and sorry for trouble.

Thanks for your reply and sorry for misunderstand.

...
  'titleField'   => 'fullname',
  'summaryField' => 'fullname',
  'searchFields' => array('fullname'),
  'field5'       => 'permalink',
);

$searchTables = array(); //REMOVE THIS LINE!
$searchTables['listings'] = array(
  'viewerUrl' => 'movie.html',
  'titleField' => 'user_movie',

What I intend to be shown in the viewer is

<div>

<a href="<?php echo $record['field5'] ?>"><?php echo $record['_title'] ?></a>  <!--This result was gained from the homepages table-->

<a href="<?php echo $record['field3'] ?>"><?php echo $record['_summary'] ?></a>  <!--This result was gained from the listings table-->

</div>

The output expected below

Interactivetools  <------ Result gained from the homepages table

Forum <--------------------Result gained from the listings table

Whatever the user either search 'Forum' or 'interactivetools'

The same result will be appeared.

Thank You

Sorry for trouble and here is another problem about the multisearch.php

<?php
require_once "../javdata/lib/viewer_functions.php";
$options['tableName'] = 'listings';
$searchOptions = array();
$searchOptions['keywords'] = @$FORM['q'];
$searchOptions['perPage'] = "16";
$searchOptions['debugSql'] = "0";
$searchOptions['orderBy'] = "field1 DESC";

$searchTables = array();
$searchTables['homepages'] = array(
'viewerUrl' => 'model.html',
'titleField' => 'fullname',
'summaryField' => 'fullname',
'searchFields' => array('fullname'),
'field5' => 'permalink',
);

$searchTables = array();
$searchTables['listings'] = array(
'viewerUrl' => 'movie.html',
'titleField' => 'user_movie',
'summaryField' => 'title_text',
'searchFields' =>
array('user_movie','jap_user_movie','ref_no','ref_no1'),
'field1' => 'date_added',
'field2' => 'ref_no1',
'field3' => 'permalink',
);

Is it possible to display both the homepages table result and the listings table result in the same div?

I success about the second row but failed in the first row,

First row 

<!--Get the result from the homepages table-->

<?php echo $record['field5'] ?>"><?php echo  $record['_title'] ?>   

Second row

<!--Get the result from the listings table-->

<?php foreach ($searchRows as $record): ?>
<?php foreach (getUploads($options['tableName'], 'uploads', $record['num']) as $upload): ?>

<a href="/<?php echo $record['field3'] ?>"><img src="https://abcdefg.com<?php echo $upload['urlPath'] ?>"></a><?php endforeach ?><?php endforeach ?>

Thank You

Thanks for your quick response.

Here is the code.

<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block to the TOP of your page BEFORE anything else. */
require_once "init.php";

list($listingRecords, $listingDetails) = getRecords(array(
'tableName' => 'listings',
'joinTable' => 'homepages',
'perPage' => '16',
));
?>

<!-- listing-item-container -->
<div class="listing-item-container init-grid-items fl-wrap nocolumn-lic">
<?php foreach ($listingRecords as $listing): ?>
<?php foreach ($listing['uploads3'] as $upload): ?>
<!-- listing-item -->
<div class="listing-item">
<article class="geodir-category-listing fl-wrap">
<div class="geodir-category-img">
<a href="<?php echo $listing['_link'] ?>" class="geodir-category-img-wrap fl-wrap">
<img src="https://abcdefg.com<?php echo $upload['urlPath'] ?>" alt="<?php echo $listing['ref_no'] ?>"></a>
<div class="geodir_status_date gsd_close"><i class="fal fa-desktop"></i><?php if ($listing['hd'])
{
echo "FHD";
} elseif ($listing['hd720p']) {
echo "HD";
} elseif ($listing['vr']) {
echo "VR";
} else {
echo "SD";
}
?></div>
</div>
<?php endforeach ?>
<div class="geodir-category-content fl-wrap title-sin_item">
<div class="geodir-category-content-title fl-wrap">
<div class="geodir-category-content-title-item">
<h3 class="title-sin_map"><?php
list($homepageRecords, $homepageDetails) = getRecords(array(
'tableName' => 'homepages',
'where' => '`num` IN('.mysql_escapeCSV($listing['model:values']).')',
'allowSearch' => false,
));
?>
<?php foreach ($homepageRecords as $homepage): ?>
<a href="<?php echo $homepage['_link']; ?>"><?php echo $homepage['fullname']; ?></a>
<?php endforeach ?>
</h3>
<div class="geodir-category-location fl-wrap"><a href="<?php echo $listing['_link'] ?>" ><?php echo $listing['title_text'] ?></a></div>
</div>
</div>
<div class="geodir-category-text fl-wrap">
<div class="facilities-list fl-wrap">
<div class="facilities-list-title">Genre : </div>
<ul class="no-list-style">
<li><?php $movie_cat = array_combine($listing['movie_cat:values'], $listing['movie_cat:labels']); ?>
<?php foreach ($movie_cat as $movie_catNum => $movie_catName): ?>
<a href="listings.php?movie_cat=<?php echo $movie_catNum;?>"><?php echo $movie_catName;?>, </a>
<?php endforeach ?>
</li>
</ul>
</div>
</div>
<div class="geodir-category-text fl-wrap">
<div class="facilities-list fl-wrap">
<div class="facilities-list-title">Type : </div>
<ul class="no-list-style">
<li><?php $movie_type = array_combine($listing['movie_type:values'], $listing['movie_type:labels']); ?>
<?php foreach ($movie_type as $movie_typeNum => $movie_typeName): ?>
<a href="listings.php?movie_type=<?php echo $movie_typeNum;?>"><?php echo $movie_typeName;?>, </a>
<?php endforeach ?>
</li>
</ul>
</div>
</div>
<div class="geodir-category-text fl-wrap">
<div class="facilities-list fl-wrap">
<div class="facilities-list-title">Duration : </div>
<ul class="no-list-style">
<li><?php echo $listing['play_time'] ?></li>
</ul>
</div>
</div>
<div class="geodir-category-footer fl-wrap">
<div class="facilities-list fl-wrap">
<div class="facilities-list-title">Date Added : </div>
<ul class="no-list-style">
<li><?php echo $listing['date_added'] ?></li>
</ul>
</div>
</div>
</div>
</article>
</div>

<?php endforeach ?>
<!-- listing-item end -->

Thank you

Hello Chris,

Finally I found the solution to show all the permalink in the same page with different table according to the post above.

However, it takes a long time to load the page.

As you said, you can show you how to load all the child records all at once (caching them at the top of your page).

Please advice how to do so.

Thank You

Currently I am using the membership plugin.

In the user accounts table,

there is a field named expiresDate.

Is there a way to erase the user's data automatically when the user reach the expire date?

For example,

The user num 12345 expire date 12-30-2018,

on 12-30-2018,

the whole row of num 12345 will be automatically deleted in the user account table.

Thank You

Sorry for trouble again.

I have created a field named ref_no1

And I intend to update the ref_no1 from ref_no

For example

In ref_no

ABC123

Then in ref_no1

ABC-123

I know how to do it in php

<?php
echo preg_replace('/^([A-Za-z]+)([0-9]+)$/i', '$1-$2', $listingsRecord['ref_no']);
?>

However I really don't know how to do it in mysql console to update the ref_no1 column.

Please advice.

Thanks a lot

A question about the multisearch.php

Currently the search field is something like this

'searchFields'    =>  array('ref_no','title_text','studio'),

The question is about the ref_no.

The reference number we stored in the db is something like this

abc123, sss345

The multisearch runs perfect if the user search abc123, abc, abc1

however, if the user search abc-123,

there is no result found.

Please advice is it possible if the user search abc-123,

then the result of abc123 will be shown.

Thanks a lot.

Is there a way to delete the user's favorites in the website_favorites db?

For example, a user have 50 favorites stored in the website_favorites table.

For some reason, the user cancel his account and I erase him in the user_account.

Is it possible that once I erase him in the user_account, all his favorites stored in the website_favorites table automatically being erased too?

Or I have to manually delete it?

Thanks a lot

Solved

'where'    => "date_added>'2012'",

I have a field named date_added

In the listing viewer,

I intend to display all the product after 2012 only.

This is my code 

<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block to the TOP of your page BEFORE anything else. */
require_once "init.php";
list($listingRecords, $listingDetails) = getRecords(array(
'tableName' => 'listings',
'joinTable' => 'homepages',
'perPage' => '10',
'where' => "date_added_min='2012'",
));

?>

However, it said

MySQL Error: Unknown column 'date_added_min' in 'where clause'

Please advice.

Thanks a lot

After rename the admin.php file.

The mysql console plugin not work anymore.

Please advice.

Thanks

Surely the abc.html is exist.

The problem is before I add the Error Document 404 xyz.html in htaccess

everything is normal.

Once the user login, he will be redirected to abc.html

After I add the ErrorDocument 404 xyz.html in htaccess

When the user login, he will be redirected to xyz.html not abc.html

Thanks

Thanks

I think it's almost done.

I can see there is a new column in the table cms_website_favorites named 'createdDate'

And if I click the Add Favorite link,

the date and time of the click would be logged.

However, it seems still not work in the my_favorites.php

// load matching records
list($favoriteRecords, $favoriteMetaData) = getRecords(array(
'tableName' => 'listings', // update this with your table or tag name
'perPage' => '10',
'where' => " num IN ($favoriteNumsQuery) ",
'loadCreatedBy' => false,
'allowSearch' => false,
'orderBy' => "`createdDate` DESC",
));

The sort order sort the createdDate column in the listing table, not the website_favorites table

The listing order in the my_favorites.php now becomes the sort order of createdDate in the cms_listings table

I did try to change this line

'tableName' => 'website_favorites', // update this with your table or tag name

but got error.

Please advice how to amend the code to sort order in cms_website_favorites table, not the cms_listings table.

Actually I know it is simple but I am a php idolt and sorry for trouble again.

Thanks a lot

Everything works fine in the Website Membership Plugin.

However, I found that it may be some conflict with htaccess.

After the user login,

The user will be  redirected to this page $GLOBALS['WEBSITE_LOGIN_POST_LOGIN_URL']  = 'abc.html';

HOWEVER, when I add the error document in htaccess

ErrorDocument 404 xyz.html

All the user after logined will be redirected to xyz.html not abc.html

Please advice,

Thanks