how to change status more than one serial at once?

I have imported few dozen serials, and they all have status Free to use, but i need them all to have status Unassigned.
How do i change status of all those keys at one go?

regards
Dan

Hi Jerome,

thanks for the response.
Now when you are mentioning updates, i have few other requests.
In my case i use URLs in serials, those urls are link to pictures on dropbox. It would be great if those urls would be clickable in frontend customer view, so customer could click on it, instead of doing copy/paste to another browser window, or even better it would be best if just window popus up in a form of lightbox.

Do you have skype?

forgot to mention, i am not sure how SQL request looks like, nor how to use it in this case.
Please provide me instructions how to do that, because i have a lot of serials to import.

this is what i have in show_order_front_show :

<?php
/**
 * @package    HikaSerial for Joomla!
 * @version    1.4.0
 * @author     Obsidev S.A.R.L.
 * @copyright  (C) 2011-2012 OBSIDEV. All rights reserved.
 * @license    GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 */
defined('_JEXEC') or die('Restricted access');
?><fieldset>
  <legend><?php echo JText::_('HIKA_SERIALS')?></legend>
<?php 
if(!empty($this->data)) {
?>
  <table style="width:100%;cell-spacing:1px;">
    <thead>
      <tr>
        <th><?php echo JText::_('PACK_NAME');?></th>
        <th><?php echo JText::_('SERIAL_DATA');?></th>
        <th><?php echo JText::_('ASSIGN_DATE');?></th>
        <th><?php echo JText::_('ATTACHED_TO_PRODUCT');?></th>
      </tr>
    </thead>
    <tbody>
<?php
  foreach($this->data as $data) {
?>
    <tr>
      <td><?php echo $data->pack_name;?></td>
      <td><?php echo $data->serial_data; ?></td>
      <td><?php echo hikaserial::getDate($data->serial_assign_date);?>
      <td><?php echo $data->order_product_name; ?></td>
    </tr>
<?php
  }
?>
    </tbody>
  </table>
<?php
}
?>
</fieldset>

<a </a>

ok, i think i have figured it out:

<td><a href="<?php echo $data->serial_data; ?>/"rel="width:480,height:240" class="ANYclassTHATgivesLightBOX"><img border="0" src="<?php echo $data->serial_data; ?>" alt="<?php echo $data->serial_data; ?>" width="256" height="128" /></a></td>

now i have a problem.
When it happens that i in Serial Data use plain ordinary text like 32fkm8s7z4, then it tries to display it in the front end as a picture/image.
Is it possible to somehow overcome this?

Thank you in advance
Dan

but can it be done "universal" not just for certain pack, beacuse often in packs will be mixed serials, sometimes urls(img) and sometimes plain text/numbers ?

regards
Dan

i have no clue or knowledge what so ever about coding, but this seems to be better solution for me.
Would you be so kind and give me complete code, that checks for .bmp .png .jpg. .jpeg and .gif content of serial, so if it doesnt find any of these, it should just display it as is text/numbers.

I hope i am not troubling you to much

thank you in advance

please let me know if this is doable, since i use mixed types of serials.

Thank you in advance
Dan

i have tried that last code, but then order page doesnt display correctly......
would you be so kind and receck if you have missed somwhere with faulty code...pleaseee

tnx
Dan