SHARE
TWEET

Untitled

a guest Aug 13th, 2017 38 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. source requests : torrents {
  2.         #By inheriting from torrents, we keep all the connection info
  3.         #By overwriting sql_query_pre (etc.) once, we overwrite all of them
  4.  
  5.         sql_query_pre = TRUNCATE TABLE sphinx_requests
  6.         sql_query_pre = SET group_concat_max_len=10140
  7.         sql_query_pre = SET @StartTime=NOW()
  8.  
  9.         sql_query_pre = INSERT INTO sphinx_requests (                                   \
  10.                                 ID, UserID, TimeAdded, LastVote, CategoryID, Title,     \
  11.                                 Year, ReleaseType, CatalogueNumber, BitrateList,        \
  12.                                 FormatList, MediaList, LogCue, FillerID, TorrentID,     \
  13.                                 TimeFilled, Visible, Votes, Bounty )                    \
  14.                         SELECT                                                          \
  15.                                 r.ID, r.UserID, UNIX_TIMESTAMP(TimeAdded),              \
  16.                                 UNIX_TIMESTAMP(LastVote), CategoryID, Title, Year,      \
  17.                                 ReleaseType, CatalogueNumber, BitrateList, FormatList,  \
RAW Paste Data
Top