executeQuery($vend_query, $data_Params); if ($vend_result === false) { show_pdo_error($vend_query, $wrapperObj->getLastStatement()); } if (count($vend_result) > 0) { $vend_row = $vend_result[0]; $alert_for = "vendor"; $alert_for_id = $vendor_id; } } // If artist id is passed than user type is artist and get contact name, email, and phone.. elseif(!empty($artist_id) && is_numeric($artist_id)) { $vend_query = 'SELECT v.name, c.contact_email, c.contact_phone FROM vendor v, vend_contact vc, contact c, artist_info a WHERE a.artist_id = ? AND v.vendor_id = vc.vendor_id AND vc.contact_id = c.contact_id AND vc.master = "Y" AND a.vendor_id = v.vendor_id'; if($aggregator_view) $vend_query .= ' AND v.owner = ?'; $data_Params = []; $data_Params[] = $artist_id; if ($aggregator_view) { $data_Params[] = $_SESSION['S_OA_OWNER']; } $vend_result = $wrapperObj->executeQuery($vend_query, $data_Params); if ($vend_result === false) { show_pdo_error($vend_query, $wrapperObj->getLastStatement()); } if (count($vend_result) > 0) { $vend_row = $vend_result[0]; $alert_for = "artist"; $alert_for_id = $artist_id; } } // If UPC is passed than user type is release and get contact name, email, and phone.. elseif(!empty($upc) && is_numeric($upc)) { $vend_query = 'SELECT v.name, c.contact_email, c.contact_phone FROM vendor v, vend_contact vc, contact c, artist_info a, releases r WHERE r.upc = ? AND v.vendor_id = vc.vendor_id AND vc.contact_id = c.contact_id AND vc.master = "Y" AND a.vendor_id = v.vendor_id AND r.artist_id = a.artist_id'; if($aggregator_view) $vend_query .= ' AND v.owner = ?'; $data_Params = []; $data_Params[] = $upc; if ($aggregator_view) { $data_Params[] = $_SESSION['S_OA_OWNER']; } $vend_result = $wrapperObj->executeQuery($vend_query, $data_Params); if ($vend_result === false) { show_pdo_error($vend_query, $wrapperObj->getLastStatement()); } if (count($vend_result) > 0) { $vend_row = $vend_result[0]; $alert_for = "release"; $alert_for_id = $upc; } } ?>

Ticket Info

Description:
Alert:
Alert is Regarding:
ID: (Leave empty for General Alert)
Link alert to this page