Skip to content

Instantly share code, notes, and snippets.

@joomdonation
Created July 15, 2015 07:28
Show Gist options
  • Select an option

  • Save joomdonation/a2d8bde56c6e71117944 to your computer and use it in GitHub Desktop.

Select an option

Save joomdonation/a2d8bde56c6e71117944 to your computer and use it in GitHub Desktop.
<?php
function change_default_language()
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('*')
->from('#__osmembership_plans');
$db->setQuery($query);
$rowFields = $db->loadObjectList();
$newDefaultLanguagePrefix = 'zh';
$oldDefaultLanguage = 'en';
$fields = array('title', 'description', 'values', 'default_values', 'fee_values', 'depend_on_options');
foreach ($rowFields as $rowField)
{
$query->clear();
$query->update('#__osmembership_fields');
foreach ($fields as $field)
{
$query->set($db->quoteName($field) . '=' . $db->quote($rowField->{$field . '_' . $newDefaultLanguagePrefix}))
->set($db->quoteName($field . '_' . $oldDefaultLanguage) . '=' . $db->quote($rowField->{$field}));
}
$query->where('id = ' . $rowField->id);
$db->setQuery($query);
$db->execute();
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment