Custom variables

S kolegou se mi podařilo dostat k SQL kódu pro select, který mi k vybranému číslu objednávky dotáhne veškeré informace, nicméně ani tak mi to nefunguje, je možné revidovat kód?

use BulkGate\Extensions;

!defined(‘ABSPATH’) && exit;

require_once(ABSPATH . ‘wp-admin/includes/plugin.php’);

/**
* Check if WooSMS is installed
*/
if (is_plugin_active(‘woosms-sms-module-for-woocommerce/woosms-sms-module-for-woocommerce.php’))
{
/**
* Extend WooSMS
*/
add_action(“woosms_extends_variables”, function(Extensions\Hook\Variables $variables, Extensions\Database\IDatabase $database)
{
$result = $database->execute(‘SELECT main.post_id as cislo_ktere_mam, omg.post_id as cislo_ketere_nemam, omg.meta_id, omg.meta_key, omg.meta_value as vou_code, wtf.meta_value as vou_exp FROM wp_postmeta as main left join wp_postmeta as omg on omg.meta_value = main.post_id and omg.meta_key = “_woo_vou_purchased_codes”*/ left join wp_postmeta as wtf on wtf.meta_key = “_woo_vou_exp_date” WHERE main.post_id = “‘.( $database->escape($variables->get(‘order_id’))).'” and main.meta_key = “_order_key” and wtf.post_id = omg.post_id’);

if($result->getNumRows())
{
$row = $result->getRow();
$variables->set(‘vou_code’, $row->voucher_code);
$variables->set(‘vou_exp’, $row->voucher_exp);
}

/** Now you can use in Customer or Admin SMS variable <test_variable> */

}, 20, 2);
}
else
{
deactivate_plugins(plugin_basename(__FILE__));
}