Change serial status to used in php?

I want to change the status of a serial to used in my software registration form.

What the best way to do this in php?

Conrad

Hi Jerome,

This does not work

$serialClass = hikaseriall:get('class.serial');
$serial = new stdClass();
$serial->serial_id = $serial_id;
$serial->serial_status = 'used';
$serialClass->save($serial);

is something mis-spelled?

This does not work

$query = "UPDATE #__hikaserial_serial
SET serial_status = 'used'
WHERE serial_data = '{$serial}'"; //$serial is an input from my form
$database->setQuery( $query );
$s_result = $database->loadResult();


But I can change the extra_data with this

$hika_extra = 'a:1:{s:7:"xxxxxxx";s:6:"'.$a_code.'";}';
$query = "UPDATE #__hikaserial_serial
SET serial_extradata = '{$hika_extra}'
WHERE serial_data = '{$serial}'";
$database->setQuery( $query );
$s_result = $database->loadResult();

Any ideas why?

Conrad

Jerome,

the corrected version does not work. I'm using this in Chronoforms v3 On Submit code. This time around I get a blank page. Feel like I'm moving backwards not forwards.

Generally where can I find documentation on how to use HikaSerial in my registration code. What I'm trying to do is set up a registration form that checks the serial is 'assigned', if it's ok then insert some data of my own into the extra data, and set the serial status to 'used'. It would also be handy to get the date of issue of the serial as well.

Any assistance you can offer to make this work appreciated particularly since I have paid 40 eu for a licence.

Conrad

This works

$query = "UPDATE #__hikaserial_serial
SET serial_extradata = '{$hika_extra}', serial_status = 'used'
WHERE serial_data = '{$serial}'";
$database->setQuery( $query );
$s_result = $database->loadResult();

for some reason when I combine the updates it works even though they don't work as separate updates.

So moving forwards again. Any chance of getting the serial issue date?

Conrad