• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: show only submissions that get paid in directory

show only submissions that get paid in directory 10 years 3 weeks ago #30948

  • youngboy
  • youngboy's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
Hi
I want to show only submissions that has been paid by user in directory layout instead of show only confirmed.

I edited line 96 of the \models\directory.php file to this :
if ($this->params->get('show_confirmed', 0)) {
			$query->where($db->qn('s._STATUS').'='.$db->q(1));
		}
but now on the directory page , it shows this error and any submission:
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /public_html/libraries/joomla/database/database/mysql.php on line 293

what is the solution?

thanks
Last Edit: 10 years 3 weeks ago by youngboy.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!