/** * Updates a QQueryBuilder with the SELECT fields for this WpPvcTotal * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_pvc_total'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'postnum', $strAliasPrefix . 'postnum'); $objBuilder->AddSelectItem($strTableName, 'postcount', $strAliasPrefix . 'postcount'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroSuggestionVote * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_suggestion_vote'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'suggestion_id', $strAliasPrefix . 'suggestion_id'); $objBuilder->AddSelectItem($strTableName, 'context_id', $strAliasPrefix . 'context_id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'suggestion_id', $strAliasPrefix . 'suggestion_id'); $objBuilder->AddSelectItem($strTableName, 'context_id', $strAliasPrefix . 'context_id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'vote_value', $strAliasPrefix . 'vote_value'); $objBuilder->AddSelectItem($strTableName, 'created', $strAliasPrefix . 'created'); $objBuilder->AddSelectItem($strTableName, 'modified', $strAliasPrefix . 'modified'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleFlood * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_flood'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'f_id', $strAliasPrefix . 'f_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'f_id', $strAliasPrefix . 'f_id'); $objBuilder->AddSelectItem($strTableName, 'ip', $strAliasPrefix . 'ip'); $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'flag', $strAliasPrefix . 'flag'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroContext * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_context'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'context_id', $strAliasPrefix . 'context_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'context_id', $strAliasPrefix . 'context_id'); $objBuilder->AddSelectItem($strTableName, 'text_id', $strAliasPrefix . 'text_id'); $objBuilder->AddSelectItem($strTableName, 'text_access_key', $strAliasPrefix . 'text_access_key'); $objBuilder->AddSelectItem($strTableName, 'text_command_key', $strAliasPrefix . 'text_command_key'); $objBuilder->AddSelectItem($strTableName, 'project_id', $strAliasPrefix . 'project_id'); $objBuilder->AddSelectItem($strTableName, 'context', $strAliasPrefix . 'context'); $objBuilder->AddSelectItem($strTableName, 'context_md5', $strAliasPrefix . 'context_md5'); $objBuilder->AddSelectItem($strTableName, 'comment', $strAliasPrefix . 'comment'); $objBuilder->AddSelectItem($strTableName, 'comment_md5', $strAliasPrefix . 'comment_md5'); $objBuilder->AddSelectItem($strTableName, 'file_id', $strAliasPrefix . 'file_id'); $objBuilder->AddSelectItem($strTableName, 'created', $strAliasPrefix . 'created'); $objBuilder->AddSelectItem($strTableName, 'modified', $strAliasPrefix . 'modified'); $objBuilder->AddSelectItem($strTableName, 'active', $strAliasPrefix . 'active'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroPermission * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_permission'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'permission_id', $strAliasPrefix . 'permission_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'permission_id', $strAliasPrefix . 'permission_id'); $objBuilder->AddSelectItem($strTableName, 'permission_name', $strAliasPrefix . 'permission_name'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleBanned * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_banned'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'users_id', $strAliasPrefix . 'users_id'); $objBuilder->AddSelectItem($strTableName, 'descr', $strAliasPrefix . 'descr'); $objBuilder->AddSelectItem($strTableName, 'date', $strAliasPrefix . 'date'); $objBuilder->AddSelectItem($strTableName, 'days', $strAliasPrefix . 'days'); $objBuilder->AddSelectItem($strTableName, 'ip', $strAliasPrefix . 'ip'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroLog * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_log'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'log_id', $strAliasPrefix . 'log_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'log_id', $strAliasPrefix . 'log_id'); $objBuilder->AddSelectItem($strTableName, 'language_id', $strAliasPrefix . 'language_id'); $objBuilder->AddSelectItem($strTableName, 'project_id', $strAliasPrefix . 'project_id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'message', $strAliasPrefix . 'message'); $objBuilder->AddSelectItem($strTableName, 'priority', $strAliasPrefix . 'priority'); $objBuilder->AddSelectItem($strTableName, 'date', $strAliasPrefix . 'date'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpWsluserscontacts * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_wsluserscontacts'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'provider', $strAliasPrefix . 'provider'); $objBuilder->AddSelectItem($strTableName, 'identifier', $strAliasPrefix . 'identifier'); $objBuilder->AddSelectItem($strTableName, 'full_name', $strAliasPrefix . 'full_name'); $objBuilder->AddSelectItem($strTableName, 'email', $strAliasPrefix . 'email'); $objBuilder->AddSelectItem($strTableName, 'profile_url', $strAliasPrefix . 'profile_url'); $objBuilder->AddSelectItem($strTableName, 'photo_url', $strAliasPrefix . 'photo_url'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleAdminSections * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_admin_sections'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name'); $objBuilder->AddSelectItem($strTableName, 'title', $strAliasPrefix . 'title'); $objBuilder->AddSelectItem($strTableName, 'descr', $strAliasPrefix . 'descr'); $objBuilder->AddSelectItem($strTableName, 'icon', $strAliasPrefix . 'icon'); $objBuilder->AddSelectItem($strTableName, 'allow_groups', $strAliasPrefix . 'allow_groups'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpPollsq * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_pollsq'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'pollq_id', $strAliasPrefix . 'pollq_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'pollq_id', $strAliasPrefix . 'pollq_id'); $objBuilder->AddSelectItem($strTableName, 'pollq_question', $strAliasPrefix . 'pollq_question'); $objBuilder->AddSelectItem($strTableName, 'pollq_timestamp', $strAliasPrefix . 'pollq_timestamp'); $objBuilder->AddSelectItem($strTableName, 'pollq_totalvotes', $strAliasPrefix . 'pollq_totalvotes'); $objBuilder->AddSelectItem($strTableName, 'pollq_active', $strAliasPrefix . 'pollq_active'); $objBuilder->AddSelectItem($strTableName, 'pollq_expiry', $strAliasPrefix . 'pollq_expiry'); $objBuilder->AddSelectItem($strTableName, 'pollq_multiple', $strAliasPrefix . 'pollq_multiple'); $objBuilder->AddSelectItem($strTableName, 'pollq_totalvoters', $strAliasPrefix . 'pollq_totalvoters'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpTermTaxonomy * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_term_taxonomy'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'term_taxonomy_id', $strAliasPrefix . 'term_taxonomy_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'term_taxonomy_id', $strAliasPrefix . 'term_taxonomy_id'); $objBuilder->AddSelectItem($strTableName, 'term_id', $strAliasPrefix . 'term_id'); $objBuilder->AddSelectItem($strTableName, 'taxonomy', $strAliasPrefix . 'taxonomy'); $objBuilder->AddSelectItem($strTableName, 'description', $strAliasPrefix . 'description'); $objBuilder->AddSelectItem($strTableName, 'parent', $strAliasPrefix . 'parent'); $objBuilder->AddSelectItem($strTableName, 'count', $strAliasPrefix . 'count'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DlePost * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_post'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'autor', $strAliasPrefix . 'autor'); $objBuilder->AddSelectItem($strTableName, 'date', $strAliasPrefix . 'date'); $objBuilder->AddSelectItem($strTableName, 'short_story', $strAliasPrefix . 'short_story'); $objBuilder->AddSelectItem($strTableName, 'full_story', $strAliasPrefix . 'full_story'); $objBuilder->AddSelectItem($strTableName, 'xfields', $strAliasPrefix . 'xfields'); $objBuilder->AddSelectItem($strTableName, 'title', $strAliasPrefix . 'title'); $objBuilder->AddSelectItem($strTableName, 'descr', $strAliasPrefix . 'descr'); $objBuilder->AddSelectItem($strTableName, 'keywords', $strAliasPrefix . 'keywords'); $objBuilder->AddSelectItem($strTableName, 'category', $strAliasPrefix . 'category'); $objBuilder->AddSelectItem($strTableName, 'alt_name', $strAliasPrefix . 'alt_name'); $objBuilder->AddSelectItem($strTableName, 'comm_num', $strAliasPrefix . 'comm_num'); $objBuilder->AddSelectItem($strTableName, 'allow_comm', $strAliasPrefix . 'allow_comm'); $objBuilder->AddSelectItem($strTableName, 'allow_main', $strAliasPrefix . 'allow_main'); $objBuilder->AddSelectItem($strTableName, 'allow_rate', $strAliasPrefix . 'allow_rate'); $objBuilder->AddSelectItem($strTableName, 'approve', $strAliasPrefix . 'approve'); $objBuilder->AddSelectItem($strTableName, 'fixed', $strAliasPrefix . 'fixed'); $objBuilder->AddSelectItem($strTableName, 'rating', $strAliasPrefix . 'rating'); $objBuilder->AddSelectItem($strTableName, 'allow_br', $strAliasPrefix . 'allow_br'); $objBuilder->AddSelectItem($strTableName, 'vote_num', $strAliasPrefix . 'vote_num'); $objBuilder->AddSelectItem($strTableName, 'news_read', $strAliasPrefix . 'news_read'); $objBuilder->AddSelectItem($strTableName, 'votes', $strAliasPrefix . 'votes'); $objBuilder->AddSelectItem($strTableName, 'access', $strAliasPrefix . 'access'); $objBuilder->AddSelectItem($strTableName, 'symbol', $strAliasPrefix . 'symbol'); $objBuilder->AddSelectItem($strTableName, 'flag', $strAliasPrefix . 'flag'); $objBuilder->AddSelectItem($strTableName, 'editdate', $strAliasPrefix . 'editdate'); $objBuilder->AddSelectItem($strTableName, 'editor', $strAliasPrefix . 'editor'); $objBuilder->AddSelectItem($strTableName, 'reason', $strAliasPrefix . 'reason'); $objBuilder->AddSelectItem($strTableName, 'view_edit', $strAliasPrefix . 'view_edit'); $objBuilder->AddSelectItem($strTableName, 'tags', $strAliasPrefix . 'tags'); $objBuilder->AddSelectItem($strTableName, 'metatitle', $strAliasPrefix . 'metatitle'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleIgnoreList * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_ignore_list'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'user', $strAliasPrefix . 'user'); $objBuilder->AddSelectItem($strTableName, 'user_from', $strAliasPrefix . 'user_from'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpFormmaker * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_formmaker'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'title', $strAliasPrefix . 'title'); $objBuilder->AddSelectItem($strTableName, 'mail', $strAliasPrefix . 'mail'); $objBuilder->AddSelectItem($strTableName, 'form', $strAliasPrefix . 'form'); $objBuilder->AddSelectItem($strTableName, 'form_front', $strAliasPrefix . 'form_front'); $objBuilder->AddSelectItem($strTableName, 'theme', $strAliasPrefix . 'theme'); $objBuilder->AddSelectItem($strTableName, 'javascript', $strAliasPrefix . 'javascript'); $objBuilder->AddSelectItem($strTableName, 'submit_text', $strAliasPrefix . 'submit_text'); $objBuilder->AddSelectItem($strTableName, 'url', $strAliasPrefix . 'url'); $objBuilder->AddSelectItem($strTableName, 'submit_text_type', $strAliasPrefix . 'submit_text_type'); $objBuilder->AddSelectItem($strTableName, 'script1', $strAliasPrefix . 'script1'); $objBuilder->AddSelectItem($strTableName, 'script2', $strAliasPrefix . 'script2'); $objBuilder->AddSelectItem($strTableName, 'script_user1', $strAliasPrefix . 'script_user1'); $objBuilder->AddSelectItem($strTableName, 'script_user2', $strAliasPrefix . 'script_user2'); $objBuilder->AddSelectItem($strTableName, 'counter', $strAliasPrefix . 'counter'); $objBuilder->AddSelectItem($strTableName, 'label_order', $strAliasPrefix . 'label_order'); $objBuilder->AddSelectItem($strTableName, 'article_id', $strAliasPrefix . 'article_id'); $objBuilder->AddSelectItem($strTableName, 'pagination', $strAliasPrefix . 'pagination'); $objBuilder->AddSelectItem($strTableName, 'show_title', $strAliasPrefix . 'show_title'); $objBuilder->AddSelectItem($strTableName, 'show_numbers', $strAliasPrefix . 'show_numbers'); $objBuilder->AddSelectItem($strTableName, 'public_key', $strAliasPrefix . 'public_key'); $objBuilder->AddSelectItem($strTableName, 'private_key', $strAliasPrefix . 'private_key'); $objBuilder->AddSelectItem($strTableName, 'recaptcha_theme', $strAliasPrefix . 'recaptcha_theme'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroText * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_text'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'text_id', $strAliasPrefix . 'text_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'text_id', $strAliasPrefix . 'text_id'); $objBuilder->AddSelectItem($strTableName, 'text_value', $strAliasPrefix . 'text_value'); $objBuilder->AddSelectItem($strTableName, 'text_value_md5', $strAliasPrefix . 'text_value_md5'); $objBuilder->AddSelectItem($strTableName, 'text_char_count', $strAliasPrefix . 'text_char_count'); $objBuilder->AddSelectItem($strTableName, 'text_word_count', $strAliasPrefix . 'text_word_count'); $objBuilder->AddSelectItem($strTableName, 'has_comments', $strAliasPrefix . 'has_comments'); $objBuilder->AddSelectItem($strTableName, 'created', $strAliasPrefix . 'created'); $objBuilder->AddSelectItem($strTableName, 'modified', $strAliasPrefix . 'modified'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpPollsa * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_pollsa'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'polla_aid', $strAliasPrefix . 'polla_aid'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'polla_aid', $strAliasPrefix . 'polla_aid'); $objBuilder->AddSelectItem($strTableName, 'polla_qid', $strAliasPrefix . 'polla_qid'); $objBuilder->AddSelectItem($strTableName, 'polla_answers', $strAliasPrefix . 'polla_answers'); $objBuilder->AddSelectItem($strTableName, 'polla_votes', $strAliasPrefix . 'polla_votes'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroTextComment * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_text_comment'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'text_comment_id', $strAliasPrefix . 'text_comment_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'text_comment_id', $strAliasPrefix . 'text_comment_id'); $objBuilder->AddSelectItem($strTableName, 'text_id', $strAliasPrefix . 'text_id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'language_id', $strAliasPrefix . 'language_id'); $objBuilder->AddSelectItem($strTableName, 'created', $strAliasPrefix . 'created'); $objBuilder->AddSelectItem($strTableName, 'modified', $strAliasPrefix . 'modified'); $objBuilder->AddSelectItem($strTableName, 'comment_text', $strAliasPrefix . 'comment_text'); $objBuilder->AddSelectItem($strTableName, 'comment_text_md5', $strAliasPrefix . 'comment_text_md5'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DlePm * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_pm'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'subj', $strAliasPrefix . 'subj'); $objBuilder->AddSelectItem($strTableName, 'text', $strAliasPrefix . 'text'); $objBuilder->AddSelectItem($strTableName, 'user', $strAliasPrefix . 'user'); $objBuilder->AddSelectItem($strTableName, 'user_from', $strAliasPrefix . 'user_from'); $objBuilder->AddSelectItem($strTableName, 'date', $strAliasPrefix . 'date'); $objBuilder->AddSelectItem($strTableName, 'pm_read', $strAliasPrefix . 'pm_read'); $objBuilder->AddSelectItem($strTableName, 'folder', $strAliasPrefix . 'folder'); $objBuilder->AddSelectItem($strTableName, 'reply', $strAliasPrefix . 'reply'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleImages * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_images'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'images', $strAliasPrefix . 'images'); $objBuilder->AddSelectItem($strTableName, 'news_id', $strAliasPrefix . 'news_id'); $objBuilder->AddSelectItem($strTableName, 'author', $strAliasPrefix . 'author'); $objBuilder->AddSelectItem($strTableName, 'date', $strAliasPrefix . 'date'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroProjectProgress * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_project_progress'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'project_progress_id', $strAliasPrefix . 'project_progress_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'project_progress_id', $strAliasPrefix . 'project_progress_id'); $objBuilder->AddSelectItem($strTableName, 'project_id', $strAliasPrefix . 'project_id'); $objBuilder->AddSelectItem($strTableName, 'language_id', $strAliasPrefix . 'language_id'); $objBuilder->AddSelectItem($strTableName, 'active', $strAliasPrefix . 'active'); $objBuilder->AddSelectItem($strTableName, 'last_modified', $strAliasPrefix . 'last_modified'); $objBuilder->AddSelectItem($strTableName, 'total_text_count', $strAliasPrefix . 'total_text_count'); $objBuilder->AddSelectItem($strTableName, 'fuzzy_text_count', $strAliasPrefix . 'fuzzy_text_count'); $objBuilder->AddSelectItem($strTableName, 'approved_text_count', $strAliasPrefix . 'approved_text_count'); $objBuilder->AddSelectItem($strTableName, 'progress_percent', $strAliasPrefix . 'progress_percent'); $objBuilder->AddSelectItem($strTableName, 'data', $strAliasPrefix . 'data'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleRssinform * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_rssinform'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'tag', $strAliasPrefix . 'tag'); $objBuilder->AddSelectItem($strTableName, 'descr', $strAliasPrefix . 'descr'); $objBuilder->AddSelectItem($strTableName, 'category', $strAliasPrefix . 'category'); $objBuilder->AddSelectItem($strTableName, 'url', $strAliasPrefix . 'url'); $objBuilder->AddSelectItem($strTableName, 'template', $strAliasPrefix . 'template'); $objBuilder->AddSelectItem($strTableName, 'news_max', $strAliasPrefix . 'news_max'); $objBuilder->AddSelectItem($strTableName, 'tmax', $strAliasPrefix . 'tmax'); $objBuilder->AddSelectItem($strTableName, 'dmax', $strAliasPrefix . 'dmax'); $objBuilder->AddSelectItem($strTableName, 'approve', $strAliasPrefix . 'approve'); $objBuilder->AddSelectItem($strTableName, 'rss_date_format', $strAliasPrefix . 'rss_date_format'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this NarroUser * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'narro_user'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'username', $strAliasPrefix . 'username'); $objBuilder->AddSelectItem($strTableName, 'password', $strAliasPrefix . 'password'); $objBuilder->AddSelectItem($strTableName, 'email', $strAliasPrefix . 'email'); $objBuilder->AddSelectItem($strTableName, 'real_name', $strAliasPrefix . 'real_name'); $objBuilder->AddSelectItem($strTableName, 'data', $strAliasPrefix . 'data'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleCategory * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_category'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'parentid', $strAliasPrefix . 'parentid'); $objBuilder->AddSelectItem($strTableName, 'posi', $strAliasPrefix . 'posi'); $objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name'); $objBuilder->AddSelectItem($strTableName, 'alt_name', $strAliasPrefix . 'alt_name'); $objBuilder->AddSelectItem($strTableName, 'icon', $strAliasPrefix . 'icon'); $objBuilder->AddSelectItem($strTableName, 'skin', $strAliasPrefix . 'skin'); $objBuilder->AddSelectItem($strTableName, 'descr', $strAliasPrefix . 'descr'); $objBuilder->AddSelectItem($strTableName, 'keywords', $strAliasPrefix . 'keywords'); $objBuilder->AddSelectItem($strTableName, 'news_sort', $strAliasPrefix . 'news_sort'); $objBuilder->AddSelectItem($strTableName, 'news_msort', $strAliasPrefix . 'news_msort'); $objBuilder->AddSelectItem($strTableName, 'news_number', $strAliasPrefix . 'news_number'); $objBuilder->AddSelectItem($strTableName, 'short_tpl', $strAliasPrefix . 'short_tpl'); $objBuilder->AddSelectItem($strTableName, 'full_tpl', $strAliasPrefix . 'full_tpl'); $objBuilder->AddSelectItem($strTableName, 'metatitle', $strAliasPrefix . 'metatitle'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpPostmeta * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_postmeta'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'meta_id', $strAliasPrefix . 'meta_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'meta_id', $strAliasPrefix . 'meta_id'); $objBuilder->AddSelectItem($strTableName, 'post_id', $strAliasPrefix . 'post_id'); $objBuilder->AddSelectItem($strTableName, 'meta_key', $strAliasPrefix . 'meta_key'); $objBuilder->AddSelectItem($strTableName, 'meta_value', $strAliasPrefix . 'meta_value'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DlePoll * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_poll'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'news_id', $strAliasPrefix . 'news_id'); $objBuilder->AddSelectItem($strTableName, 'title', $strAliasPrefix . 'title'); $objBuilder->AddSelectItem($strTableName, 'frage', $strAliasPrefix . 'frage'); $objBuilder->AddSelectItem($strTableName, 'body', $strAliasPrefix . 'body'); $objBuilder->AddSelectItem($strTableName, 'votes', $strAliasPrefix . 'votes'); $objBuilder->AddSelectItem($strTableName, 'multiple', $strAliasPrefix . 'multiple'); $objBuilder->AddSelectItem($strTableName, 'answer', $strAliasPrefix . 'answer'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleStatic * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_static'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'name', $strAliasPrefix . 'name'); $objBuilder->AddSelectItem($strTableName, 'descr', $strAliasPrefix . 'descr'); $objBuilder->AddSelectItem($strTableName, 'template', $strAliasPrefix . 'template'); $objBuilder->AddSelectItem($strTableName, 'allow_br', $strAliasPrefix . 'allow_br'); $objBuilder->AddSelectItem($strTableName, 'allow_template', $strAliasPrefix . 'allow_template'); $objBuilder->AddSelectItem($strTableName, 'grouplevel', $strAliasPrefix . 'grouplevel'); $objBuilder->AddSelectItem($strTableName, 'tpl', $strAliasPrefix . 'tpl'); $objBuilder->AddSelectItem($strTableName, 'metadescr', $strAliasPrefix . 'metadescr'); $objBuilder->AddSelectItem($strTableName, 'metakeys', $strAliasPrefix . 'metakeys'); $objBuilder->AddSelectItem($strTableName, 'views', $strAliasPrefix . 'views'); $objBuilder->AddSelectItem($strTableName, 'template_folder', $strAliasPrefix . 'template_folder'); $objBuilder->AddSelectItem($strTableName, 'date', $strAliasPrefix . 'date'); $objBuilder->AddSelectItem($strTableName, 'metatitle', $strAliasPrefix . 'metatitle'); $objBuilder->AddSelectItem($strTableName, 'allow_count', $strAliasPrefix . 'allow_count'); $objBuilder->AddSelectItem($strTableName, 'sitemap', $strAliasPrefix . 'sitemap'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpOptions * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_options'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'option_id', $strAliasPrefix . 'option_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'option_id', $strAliasPrefix . 'option_id'); $objBuilder->AddSelectItem($strTableName, 'option_name', $strAliasPrefix . 'option_name'); $objBuilder->AddSelectItem($strTableName, 'option_value', $strAliasPrefix . 'option_value'); $objBuilder->AddSelectItem($strTableName, 'autoload', $strAliasPrefix . 'autoload'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpLinks * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_links'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'link_id', $strAliasPrefix . 'link_id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'link_id', $strAliasPrefix . 'link_id'); $objBuilder->AddSelectItem($strTableName, 'link_url', $strAliasPrefix . 'link_url'); $objBuilder->AddSelectItem($strTableName, 'link_name', $strAliasPrefix . 'link_name'); $objBuilder->AddSelectItem($strTableName, 'link_image', $strAliasPrefix . 'link_image'); $objBuilder->AddSelectItem($strTableName, 'link_target', $strAliasPrefix . 'link_target'); $objBuilder->AddSelectItem($strTableName, 'link_description', $strAliasPrefix . 'link_description'); $objBuilder->AddSelectItem($strTableName, 'link_visible', $strAliasPrefix . 'link_visible'); $objBuilder->AddSelectItem($strTableName, 'link_owner', $strAliasPrefix . 'link_owner'); $objBuilder->AddSelectItem($strTableName, 'link_rating', $strAliasPrefix . 'link_rating'); $objBuilder->AddSelectItem($strTableName, 'link_updated', $strAliasPrefix . 'link_updated'); $objBuilder->AddSelectItem($strTableName, 'link_rel', $strAliasPrefix . 'link_rel'); $objBuilder->AddSelectItem($strTableName, 'link_notes', $strAliasPrefix . 'link_notes'); $objBuilder->AddSelectItem($strTableName, 'link_rss', $strAliasPrefix . 'link_rss'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this DleMailLog * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'dle_mail_log'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'id', $strAliasPrefix . 'id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'mail', $strAliasPrefix . 'mail'); $objBuilder->AddSelectItem($strTableName, 'hash', $strAliasPrefix . 'hash'); } }
/** * Updates a QQueryBuilder with the SELECT fields for this WpWpscstReplies * @param QQueryBuilder $objBuilder the Query Builder object to update * @param string $strPrefix optional prefix to add to the SELECT fields */ public static function GetSelectFields(QQueryBuilder $objBuilder, $strPrefix = null, QQSelect $objSelect = null) { if ($strPrefix) { $strTableName = $strPrefix; $strAliasPrefix = $strPrefix . '__'; } else { $strTableName = 'wp_wpscst_replies'; $strAliasPrefix = ''; } if ($objSelect) { $objBuilder->AddSelectItem($strTableName, 'primkey', $strAliasPrefix . 'primkey'); $objSelect->AddSelectItems($objBuilder, $strTableName, $strAliasPrefix); } else { $objBuilder->AddSelectItem($strTableName, 'primkey', $strAliasPrefix . 'primkey'); $objBuilder->AddSelectItem($strTableName, 'ticket_id', $strAliasPrefix . 'ticket_id'); $objBuilder->AddSelectItem($strTableName, 'user_id', $strAliasPrefix . 'user_id'); $objBuilder->AddSelectItem($strTableName, 'timestamp', $strAliasPrefix . 'timestamp'); $objBuilder->AddSelectItem($strTableName, 'message', $strAliasPrefix . 'message'); } }