Back
Similar todos
Tweak the algo so job board with Highlight or Brand Color upgrades that are not sticky get auto shuffled #jobboardsearch
Make a bot that shuffles non paid job boards every 30 mins #jobboardsearch
remove sticky job cache because DB is now fast enough to do it on load (thanks @daniellockyer) #remoteok
manage to figure out how to add sticky jobs into SQL query by doing ORDER BY max(coalesce(epoch,0),coalesce(epoch_bumped,0),(coalesce(is_sticky_day,0)+86400),(coalesce(is_sticky_week,0)+604800),(coalesce(is_sticky_month,0)+2592000))) so that we don’t need to “manually” add the sticky jobs on top with code but it just sorts it straight into db (86400 is 24h, 604800 is 7 days, 2592000 is 30 days etc.) #remoteok
find solution for if company adds sticky (24h/7d/30d) during editing job it won’t sticky cuz sticky based on posting date not when sticky was added; solution = sticky boolean value can be a timestamp instead (0 = false, 1 = true, 1601993989 is timestamp of sticky time) and it checks that when showing stickies and resets timestamp of job to edit #remoteok (complex af)
Get Skillset job board upgrade to Sticky after two weeks of Custom Color #jobboardsearch
cache sticky jobs to drop WAIT time by 25% #remoteok
fix when companies who post a job that’s sticky for a day/week/month edit their job post, the sticky gets disabled, this is because I hid the checkboxes for the already purchased sticky (because I wanted to avoid it getting charged extra for them again), then the AJAX would send the edits but it’d not include the sticky, so it’d disable them. Now instead code in backend to check for the diffs in features selected and charge $ based on that. Difficult. #remoteok
Get a job board listing upgrade Sticky + Custom Color #jobboardsearch