here you can find some useful and time saving scripts and pieces of code.


add images to joomla3 newsflash mod :

just after the foreach loop, paste this line:
<?php $images = json_decode($item->images); ?>


<img src="/<?php echo json_decode($item->images)->image_intro; ?>"/>


add this to h or v override

 

PHP - URL based content

 

{codecitation} something //this part takes fourth value from array and displays corresponding content defined here below something else {/codecitation}

 

http://www.tizag.com/sqlTutorial/sqlupdate.php

http://www.w3schools.com/sql/sql_update.asp

http://rizwanshah.blogspot.com/2007/10/return-duplicate-column-values-in-table.html

http://www.gsdesign.ro/blog/sql-query-copy-one-column-to-another-column-in-mysql/

 

How to reorder MySQL table columns in MySQL databases

http://trebleclick.blogspot.com/2009/02/reorder-mysql-table-columns.html

{codecitation}

ALTER table `table_name`
MODIFY COLUMN `column_name` your_data_type
AFTER `other_column_name`

 

{/codecitation}

 

 

 

 

 

 

Show / Hide based on selected option

{codecitation}

<script>
$(window).load(function(){

    $('#Netkodrugi_field, .Netkodrugi').hide();
    $('#upline').change(function(){
        if($(this).val() == 'netkodrugi'){
  
        $('#Netkodrugi_field, .Netkodrugi').show();
       }
        else {  $('#Netkodrugi_field, .Netkodrugi').hide();}
 
});
  });

</script>

{/codecitation}