public static function deleteObjectInfoFromDB($db_table_name, $object_sid)
{
if (SJB_DB::table_exists($db_table_name . '_properties')) {
if (SJB_DB::query('DELETE FROM ?w WHERE object_sid = ?n', $db_table_name . '_properties', $object_sid)) {
return SJB_DB::query('DELETE FROM ?w WHERE sid = ?n', $db_table_name, $object_sid);
}
return false;
}
return SJB_DB::query('DELETE FROM ?w WHERE sid = ?n', $db_table_name, $object_sid);
}
function _getFromStatement($inner_join = false)
{
$sql = '';
$inner = '';
if (!empty($inner_join)) {
foreach ($inner_join as $key => $val) {
if (str_replace('_2second', '', $key)) {
$as = $key;
$table = str_replace('_2second', '', $key);
}
if (isset($val['sort_field']) && !isset($val['noPresix'])) {
$sql .= ", `{$key}`.{$val['sort_field']} ";
} elseif (isset($val['select_field'])) {
$sql .= ", `{$key}`.{$val['select_field']} ";
}
if (isset($val['count'])) {
$sql .= ", {$val['count']} ";
}
if (isset($val['main_table'])) {
if (isset($as)) {
$inner .= $val['join'] . " `{$table}` as {$as} ON `{$as}`.{$val['join_field']} = `{$this->object_table_prefix}`.{$val['join_field2']} ";
} else {
$inner .= $val['join'] . " `{$key}` ON `{$key}`.{$val['join_field']} = `{$this->object_table_prefix}`.{$val['join_field2']} ";
}
}
}
}
if (SJB_DB::table_exists($this->object_table_prefix . '_properties') && ($this->isComplex || $this->isMonetary)) {
$from_block = "FROM `{$this->object_table_prefix}` INNER JOIN `{$this->object_table_prefix}_properties` ON `{$this->object_table_prefix}`.`sid` = `{$this->object_table_prefix}_properties`.`object_sid` ";
} else {
$from_block = "FROM `{$this->object_table_prefix}` ";
}
return $sql . $from_block . ' ' . $inner;
}
public static function deleteProfileSocialInfoByReference($reference)
{
$some = explode('_', $reference);
$network = SJB_Array::get($some, 0);
if ($network) {
$fieldID = $network . '_id';
$id = explode($network . '_', $reference);
$id = SJB_Array::get($id, 1);
if (SJB_DB::table_exists($network)) {
SJB_DB::query('DELETE FROM `?w` WHERE `?w` = ?s', $network, $fieldID, $id);
}
}
}
