Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1124 /*-- update_hash function ------------------------------------------------*/
- 1125 /*------------------------------------------------------------------------*/
- 1126 /* This function is to update a specific torrent group hash in the */
- 1127 /* torrent_hash table to keep the browse page a little more up to date */
- 1128 /*-- TODO ----------------------------------------------------------------*/
- 1129 /* Add in tag sorting based on positive negative votes algo */
- 1130 /**************************************************************************/
- 1131
- 1132 function update_hash($GroupID)
- 1133 {
- 1134 global $DB,$SpecialChars;
- 1135
- 1136 $DB->query("UPDATE torrents_group SET TagList=(SELECT CONCAT('|',GROUP_CONCAT(tags.Name SEPARATOR '|'),'|')
- 1137 FROM torrents_tags AS t
- 1138 INNER JOIN tags ON tags.ID=t.TagID
- 1139 WHERE t.GroupID='".db_string($GroupID)."'
- 1140 GROUP BY t.GroupID)
- 1141 WHERE ID='".db_string($GroupID)."'");
- 1142
- 1143 $DB->query( "INSERT INTO torrent_hash ( GroupID, GroupYear, GroupCategoryID, GroupTime, MaxTorrentSize, TotalSnatches, TotalSeeders, TotalLeeche rs, ArtistID, TorrentIDList, TagList, YearList, RemasterList, RemasterTitleList, FileCountList, SizeList, LeechersList, SeedersList, SnatchedList, FreeT orrentList, DirectorList, TimeList, NativeTitleList, RuntimeList, RatingList, DiskNumberList, SourceMediaList, SourceResolutionList, ScreenFormatList, L anguageList, AudioFormatList, AudioChannelList, SubtitleList )
- 1144 SELECT
- 1145 g.ID,
- 1146 g.Year,
- 1147 g.CategoryID,
- 1148 g.Time,
- 1149 MAX(t.Size),
- 1150 SUM(t.Snatched),
- 1151 SUM(t.Seeders),
- 1152 SUM(t.Leechers),
- 1153 g.ArtistID,
- 1154 GROUP_CONCAT(t.ID ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1155 g.TagList,
- 1156 GROUP_CONCAT(t.Year ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1157 GROUP_CONCAT(t.Remastered ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1158 CONCAT('|',GROUP_CONCAT(t.RemasterTitle ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),'|'),
- 1159 GROUP_CONCAT(t.FileCount ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1160 GROUP_CONCAT(t.Size ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1161 GROUP_CONCAT(t.Leechers ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1162 GROUP_CONCAT(t.Seeders ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1163 GROUP_CONCAT(t.Snatched ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),
- 1164 CONCAT('|',GROUP_CONCAT(t.FreeTorrent ORDER BY t.Format DESC, t.Encoding SEPARATOR '|'),'|'),
- 1165 g.Directors,
- 1166 GROUP_CONCAT(t.Time ORDER BY t.Format DESC, t.Encoding SEPARATOR '|')
- 1167
- 1168 FROM torrents AS t
- 1169 LEFT JOIN torrents_group AS g ON g.ID=t.GroupID
- 1170 WHERE t.GroupID='".db_string($GroupID)."'
- 1171 GROUP BY t.GroupID
- 1172 ON DUPLICATE KEY UPDATE
- 1173 GroupID=VALUES(GroupID),
- 1174 GroupYear=VALUES(GroupYear),
- 1175 GroupCategoryID=VALUES(GroupCategoryID),
- 1176 GroupTime=VALUES(GroupTime),
- 1177 MaxTorrentSize=VALUES(MaxTorrentSize),
- 1178 TotalSnatches=VALUES(TotalSnatches),
- 1179 TotalSeeders=VALUES(TotalSeeders),
- 1180 TotalLeechers=VALUES(TotalLeechers),
- 1181 ArtistID=VALUES(ArtistID),
- 1182 TorrentIDList=VALUES(TorrentIDList),
- 1183 TagList=VALUES(TagList),
- 1184 YearList=VALUES(YearList),
- 1185 RemasterList=VALUES(RemasterList),
- 1186 RemasterTitleList=VALUES(RemasterTitleList),
- 1187 FileCountList=VALUES(FileCountList),
- 1188 SizeList=VALUES(SizeList),
- 1189 LeechersList=VALUES(LeechersList),
- 1190 SeedersList=VALUES(SeedersList),
- 1191 SnatchedList=VALUES(SnatchedList),
- 1192 FreeTorrentList=VALUES(FreeTorrentList),
- 1193 DirectorList=VALUES(DirectorList),
- 1194 TimeList=VALUES(TimeList)");
- 1195
- 1196 $DB->query("
- 1197 INSERT INTO torrent_hash (GroupID, GroupName, ArtistID, ArtistName)
- 1198 SELECT g.ID, g.Name, g.ArtistID, g.Directors
- 1199 FROM torrents_group AS g
- 1200 LEFT JOIN artists AS a ON a.ID=g.ArtistID
- 1201 WHERE g.ID='".db_string($GroupID)."'
- 1202 ON DUPLICATE KEY UPDATE
- 1203 GroupName=VALUES(GroupName),
- 1204 ArtistName=VALUES(ArtistName)");
- 1205
- 1206 $DB->query("UPDATE torrent_hash SET SearchText=CONCAT_WS(' ',ArtistName, GroupName, GroupYear) WHERE GroupID='".db_string($GroupID)."'");
- 1207
- 1208 $Query = 'SearchText';
- 1209
- 1210 while (list($K, list($Search, $Replace)) = each($SpecialChars))
- 1211 {
- 1212 $Query = 'REPLACE('.$Query.", '$Search', '$Replace')";
- 1213 }
- 1214
- 1215 $Query = 'UPDATE torrent_hash SET SearchText='.$Query;
- 1216 $DB->query($Query);
- 1217
- 1218 $DB->query("UPDATE torrents_group AS g, torrent_hash AS h SET g.SearchText=h.SearchText WHERE g.ID=h.GroupID AND h.GroupID='".db_string($GroupID )."'");
- 1219 }
Add Comment
Please, Sign In to add comment