Advertisement
Guest User

Untitled

a guest
Aug 13th, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  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, \
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement