Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- source requests : torrents {
- #By inheriting from torrents, we keep all the connection info
- #By overwriting sql_query_pre (etc.) once, we overwrite all of them
- sql_query_pre = TRUNCATE TABLE sphinx_requests
- sql_query_pre = SET group_concat_max_len=10140
- sql_query_pre = SET @StartTime=NOW()
- sql_query_pre = INSERT INTO sphinx_requests ( \
- ID, UserID, TimeAdded, LastVote, CategoryID, Title, \
- Year, ReleaseType, CatalogueNumber, BitrateList, \
- FormatList, MediaList, LogCue, FillerID, TorrentID, \
- TimeFilled, Visible, Votes, Bounty ) \
- SELECT \
- r.ID, r.UserID, UNIX_TIMESTAMP(TimeAdded), \
- UNIX_TIMESTAMP(LastVote), CategoryID, Title, Year, \
- ReleaseType, CatalogueNumber, BitrateList, FormatList, \
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement