• 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: Just show completed subscribers

Just show completed subscribers 9 years 4 months ago #33592

I want to make RSEvents Pro! to just show subscribers with completed status.
Is there a way to do it?
The administrator has disabled public write access.

Just show completed subscribers 9 years 3 months ago #33902

  • massageindy
  • massageindy's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 18
  • Thank you received: 2
BELOW is the code i added to dafault.php file to display COMPLETED Ticket Count per event along with added info such as a different color if more than a certain number and we use different prices for an event for all attendees depending on how many tickets sold so that also is included below. Feel free to remove whatever you dont need to use.

<?php
$db = &JFactory::getDBO();
// Amount of Subscriptions
$db->setQuery("SELECT SUM(ut.quantity) FROM #__rseventspro_user_tickets ut LEFT JOIN #__rseventspro_users u ON ut.ids = u.id WHERE u.ide = '".$event->id."'");
$subs = $db->loadResult();?>
<p 
<?php if ($subs == 0) echo 'style="color:red"'; ?>
<?php if ($subs > 0) echo 'style="color:green"'; ?>
<?php
echo '<b>';?>
<?php if ($subs == 0) echo '0'; ?>
<?php
echo ''.($subs);
echo ' Deposits Paid</b></br>';?>
<?php if ($featured) echo 'This is a featured event!</p>'; ?>
<?php if ($subs == 1) echo '$70 per person. 2 more deposits needed for $60 rate. 5 more deposits needed for the $50 rate.</p>'; ?>
<?php if ($subs == 2) echo '$70 per person. 1 more deposit needed for $60 rate. 4 more deposits needed for the $50 rate.</p>'; ?>
<?php if ($subs == 3) echo '$60 per person. 3 more deposits needed for $50 rate.</p>'; ?>
<?php if ($subs == 4) echo '$60 per person. 2 more deposits needed for $50 rate.</p>'; ?>
<?php if ($subs == 5) echo '$60 per person. 1 more deposit needed for $50 rate.</p>'; ?>
<?php if ($subs > 5) echo '$50 per person because 6 or more deposits have been paid! </p>'; ?>
			</div>
			<?php } ?>
Last Edit: 9 years 3 months ago by alexp. Reason: Added coded tags
The administrator has disabled public write access.
The following user(s) said Thank You: zeinabvesal
  • 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!