Thursday 28 November 2013

Joomla Ticketmaster - Sell promo tickets first

I've made a couple of changes to Joomla Ticketmaster . They're hacks so will need uploading on any future developments of the component.


Firstly the client was after selling tickets at Promotional Price and then once they've run out the full price tickets will sell.

To do this ADD your promo tickets FIRST  .  And the tickets MUST HAVE THE SAME NAME


Here's the hack

OPEN com_ticketmaster/models/eventlist.php  

find



   function getList() {
   
  if (empty($this->_data)) {

    $db = JFactory::getDBO();
   
   $where  = $this->_buildContentWhere();
   $order  = $this->_buildContentOrderBy();
  
   ## Making the query for showing all the clients in list function
   $sql = 'SELECT a.*, b.eventname, b.groupname, v.venue AS venuename, v.id AS venueid
     FROM #__ticketmaster_tickets AS a, #__ticketmaster_events AS b, #__ticketmaster_venues AS v'
     .$where
 .$order;     
   
    $db->setQuery($sql, $this->getState('limitstart'), $this->getState('limit' ));
    $this->data = $db->loadObjectList();
  }
  return $this->data;
 }

AND REPLACE WITH
     function getList() {
   
  if (empty($this->_data)) {

    $db = JFactory::getDBO();
   
   $where  = $this->_buildContentWhere();
   $order  = $this->_buildContentOrderBy();
  
   ## Making the query for showing all the clients in list function
   $sql = 'SELECT a.*, b.eventname, b.groupname, v.venue AS venuename, v.id AS venueid
     FROM #__ticketmaster_tickets AS a, #__ticketmaster_events AS b, #__ticketmaster_venues AS v'
     .$where
 .' AND a.totaltickets > 0 GROUP   BY a.ticketname'   
     .$order;  // changed by littleripples.com      
   
    $db->setQuery($sql, $this->getState('limitstart'), $this->getState('limit' ));
    $this->data = $db->loadObjectList();
  }
  return $this->data;
 }
 
 
 
 
SAVE AND UPLOAD


Wednesday 27 November 2013

Images not showing on Front Page of Wordpress Fashionista Theme

The issue here is that after blogging some images aren't displaying. As pictured here.




These display boxes are set in the Post; of which you can choose which format you wish.  I'm going to make this change in 'standard' but you'll need to spread over to the other formats too.

Take a look at the page wp-content/themes/wpex-fashionista/formats/entry-standard.php

Look for the code

aq_resize( wp_get_attachment_url(get_post_thumbnail_id(),'full'), x, x, false ); 


if you change the False here to True then this will allow cropping :)

Saturday 23 November 2013

Issues purchasing after Upgrade to Joomla 3.2

The first part of this blog acts as a lesson learnt and a big slap on the wrist for myself. When doing any upgrade on Joomla you should always make a full backup; I also always do this in a testing area. The slap on the wrist comes now with the level of testing given at this point - Do not trust the label of 'STABLE upgrade'; it still needs thorough testing through all processes and not just checking all Pages, which is what I done. Ok so let's have a look at the actual issues that occured. user name and password do not match or you do not have an account yet The mail function has been temporarily disabled on this site COM_TICKETMASTER_AUTOLOGIN_LOGIN_FAILURE 1. The Mail Function has been temporarily disabled on this site. this is an easy - switch on switch off solution in admin -> http://forum.joomla.org/viewtopic.php?f=706&t=825521 2. COM_TICKETMASTER_AUTOLOGIN_LOGIN_FAILURE & user name and password do not match or you do not have an account yet Take a look at https://github.com/Skullbock/joomla-cms/commit/dac70c8c023a2cf1079fa8c31fa2ed3dc393f966 you need to make a change to the Joomla core at lugins/user/joomla/joomla.php Also I had noticed I was getting this message in admin Error "Password too long. Please select a password with 55 or fewer characters." to fix this i went to Plugin Manager: System - Remember Me and reduced the value of Key Length to 6. and my issue seems to be fixed.