Active
Project:
XML sitemap
Version:
7.x-2.x-dev
Component:
xmlsitemap_node.module
Priority:
Normal
Category:
Feature request
Assigned:
Unassigned
Reporter:
Created:
28 Oct 2019 at 21:26 UTC
Updated:
6 May 2021 at 12:25 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #2
darkodev commentedComment #3
jasonmce commentedIt is a good start, but it appears that an update to node 1 would match queued rows for any nid with a 1 in it (ex: 1234) and be excluded?
You probably want your condition to be the full
data = 's:DIGITS_IN_NID:"NID";', but quote wrapping ":data" in your like condition should be just as safe.Comment #4
darkodev commentedGood point, thanks.
Will refactor, test and upload a new patch.I checked and the value for the like condition in my patch already contains the quotes.
The resultant query doesn't select anything except the nid in question.
eg.
select item_id from `queue` where name = 'xmlsitemap_node' and data like '%"1"%'
only selects nid 1
select item_id from `queue` where name = 'xmlsitemap_node' and data like '%"1234"%'
only selects nid 1234
Unless I'm missing something . . .
Comment #5
jasonmce commentedThere it is! Apologies for the noise.
Comment #6
darkodev commented@jasonmce thanks for second set of eyes
Comment #7
bricel commentedAdding support for the advanced queue module.
Comment #8
bricel commentedMaking query condition more efficient. The nid is save as is, so need for %like%
Comment #9
bricel commentedComment #10
bricel commentedCleanup and fixes for patch #2 and #3
Comment #11
bricel commentedFix patch.
Comment #12
bricel commentedFix query from #5
Comment #13
bricel commented