:

We now have a cron job running that updates the user prices!

Right now, I'm having the job run slowly (one item every two minutes), so that if something goes wrong, the damage will be minimal, but so far I've watched the script go through the first four items (Orange, Red Ball, Subeta History, Book of Magic I) with no problems.

At the current speed, it will update the entire database in about six weeks (and then start all over again). If we don't see any problems over the next day or so, I'll speed it up a little -- but I don't want to speed it up to the point that we get in trouble for hammering Subeta's site.

oh wow! Making the sort by price useful again. I still use that sort, but its been way more of a guide than really helpful for a long time.

This makes me very, very happy.

Six weeks does seem a bit long though. I know at one time we had it running only during off peak hours (maybe 1 - 5 am?) and it was able to complete the entire database in, I believe, two weeks. Admittedly we have many more items now but I wonder if we could try something similar? Maybe every item monthly? Is it actually set for every item or is it not (please) doing CWs?

: Per your suggestion, I've excluded anything with a rarity 200 or above; I've also sped things up slightly. Right now, the script will go through the entire database in 26 days, so slightly faster than monthly.

I've set it up so the cron works round the clock, but at a slow enough rate that Subeta shouldn't object. It'd be a simple matter to change it to operate only during non-peak hours or something like that. If someone wants to check with Grace to see what she'd prefer, I can accommodate it.

[edit]Bonus feature:

While updating the user shop price, the script now also checks to see if the item name or description needs updating (in case we missed any of those spelling changes that occurred recently.) Already uncovered: "Bob The Fishing Ontra" is now "Bob The Fishing Ontra Trading Card". (Ironically, they changed the name of the item, but Fishing is run by an islander now. He's Bob the Ex-Fishing Ontra now! ;) )

Is it any different than a user being logged in and loading a lot of different pages 24/7? I can't check with her if needed....

Speaking of logged in, whose account is this running on?

: Nobody's logged in for the cron -- you can get user shop prices without being logged in. (The only script that runs as a logged-in user so far is the one that gets wearable and ornament overlays.)

What it looks like to Subeta is that we connected to get the pages https://subeta.net/hover_item.php?itemid=2 https://subeta.net/hover_item.php?itemid=3 https://subeta.net/hover_item.php?itemid=4 https://subeta.net/hover_item.php?itemid=5 etc., skipping over numbers that didn't have an item assigned to it or that had an item of rarity 200 or higher.

Right now, the script grabs 3 pages every 2 minutes. (The old script grabbed 100 pages every 15 minutes, so they should be okay if we ramp up the speed somewhat.)

This is the most exciting thing omg. I try to use the price sort sometimes when I'm feeding/reading, but I know it hasn't been able to be super accurate. I don't understand too much of the technical side, but it seems like you've found a good compromise where it's not putting too much strain on the site but also won't take a month and a half to update.

And the added bonus that it catches/fixes changes to item names/descriptions is beautiful.

Oh, riiight! Logged in was just for overlays.

If you can speed it up some without it causing a noticeable strain go ahead and do it. We may need to cut it back some during events though.

After it has a few days to run and update we can let people know to expect prices to be updated every X number of days. They will be happy!

Done. I've also identified SubetaLodge in the user agent in case there is a problem, they may be more inclined to let us know.

[edit] If anyone's interested, http://www.subetalodge.org/cron/update-prices-last-item shows the last item number which was updated.

They are going to update the rarities of CT items, BHH and TS items.. https://subeta.net/forums.php/gotopost/60240338

Can I just say that I love you! Or rather your work on SubetaLodge. I just entered the new serpenth lifelike dolls and between using the new form and the old item note editor, it took more time to write up the news post than to enter the 14 new items. It all went off without a hitch. Now all I need to do is work out a way to make my browser auto-enter my Subeta password rather than my subetaLodge password.

: I'm really glad it worked out for you. :) I definitely want the tedious parts of Subetalodge work to be not so tedious (that'll free our time up for new projects!)

... which brings me to the discussion of achievement tracking again.

What I'd like to suggest is something a little broader than just tracking achievements: I'd like to have a table in the items database for item lists. What I'm envisioning is a table something like this:

Name: Fighter of the Dayman Type: achievement, clothing Description: Have the following wearables in your wardrobe! Items: Dripping Liquid Shadow, Flask of Liquid Shadow, ...

Name: September 2016 Collection Type: Cash shop Description: Open option: receive your choice of one item Items: Book of Treasured Secrets, Cocodra, ...

...which we could use for achievements, but for all sorts of other things.

I'd like to add a collection filter -- along with "limit items by restock location", users could "limit items by item list" (this wouldn't be hard to add). And then, I'd like to set up an interface for user-submitted lists which one of the IAs could approve/disapprove. Let them do some of the tedious work for us.

We could get the ball rolling with, say, achievement lists so that people would see how these work -- then open the list-creation process to other Subeta members.

Definitely liking that table. But I'm uncertain exactly how information will be pulled out of it.

Example: I have an item in my inventory, its wishlisted, but I'm not sure why I wishlisted it. So I look it up in SubetaLodge trying to narrow down why I might have wanted it. Will I be able to see that this item is used in a genetech combo, or its needed for an achievement?

Example: 6 new achievements have just been added and while I have some of the items, I'm missing others. I want some way to track these achievement needs without making 6 custom checklists. Or will I be able to have a checklist, like the wardrobe list, that contains all items needed for various achievements?

Example: I'm baking at Fantine's some items require specific ingredients, others require one of a list. I'm not too concerned with the butter, milk and sugar that are list items, but I would like some way to track the specifically needed ingredients like Cocoa powder, baking powder, certain chocolate chips, etc.

This is fascinating to read, even if I'm a little confused. Just sayin' ^^

We could display that information on an item's page below the item notes. (In fact, it might be that the lists will duplicate some information found in the item notes -- we can decide later how we want to handle that. Item lists would take up less server space than notes -- you're entering the relevant text once and storing a dozen item numbers along with it instead of storing the text in a dozen different records.)

I don't envision this happening at first -- a few other things would need to be in place first, but what I envision is this: many (not all) of the item-related achievements would be available filters on larger checklists. For example, you'd have a Wardrobe checklist, but in addition to the items you have/items you don't have filters, there'd be a filter for those achievements items that involve the wardrobe. Similarly, your Book, Food, Plushie, etc. collections would have filters for those achievements.

There are a few "weird" achievements that don't quite fit these categories (carve 500 pumpkins, for example, involves pumpkins but they don't have to be in any particular collection) -- I'm not sure how people would use a checklist to track something like that, but people do have the opportunity to create custom checklists for those special cases.

I've thought about this -- Fantine's is tricky, because it involves a combination of mandatory items and substitutable items. It'd be easy to track just the mandatory items for a given recipe, and it'd be easy to track the list of any potential item for a given recipe. Coming up with a way to track all the different possible combinations in a single list would require implementing some boolean constructs on the list like "Baking Powder AND Eggs AND (Self-Rising Flour OR Whole Wheat Flour) AND (Chocolate Chips OR Semi-Sweet Chocolate Chips) AND (Salt OR Kosher Salt OR Sea Salt)" .

I'd like to make that a low priority unless some other application comes around which gives us additional reason to justify adding that level of complexity to the lists.

Okay, definitely picturing it better now.

I'm thinking this will eventually replace item notes completely.

I'm liking the filtering idea.

For Fantine's, how I would use it personally, would be to have a list of all mandatory items and not concern myself with the substitutable items. The only problem with this is when a mandatory item is needed in multiple recipes. Baking powder for sure is needed in several. Hum...I wondering if the same thing could be achieved through a page similar to the genetech list. Currently, what drives me nuts is having to opening each recipe separately, I'd like a way to see them all together, or by level.

Hi there! Welcome back :D. Saw your post about being back, but didn't want to add to your ton of pings by saying hello.

: Your inbox is full.

Reading drive checklists are gone. I have a saved backup just in case we need them back for some reason. I recommend making an announcement asking anyone using Reading Drive brag banners in their Subeta profiles to take them down. I haven't deleted the brag banners yet, but they don't work anymore.

On a minor note, the new admin mass-add page is now the default, but the old one is still there, and the user price cron is into the 145000's.

So I just found out (day late, dollar short here)the costume trunks/items all need updated. Lypsyl has started but there are at least a hundred items needing fixing.

Re: Georgie's post

Go the cash shop costume trunk page. I'll start working from the top (Table For Two).

We need to change the items in the costume trunk. The rarity needs to be changed to 125 (some are already 125, others 150) (check the costume trunk too, I thought they were 125 already, but some are not). Change the location to Cash Shop. Add the price, I haven't checked them all, but individual items seem to be 65 CSC each. Finally change the note: It currently reads: Name of Costume Trunk, (Fe)Male: obtained from opening a Name of Costume Trunk and choosing (Fe)Male Add:
Item can also be purchased individually at Cash Shop, Name of costume trunk

Address should be something like this: https://subeta.net/cashshop.php?act=preview&trunk=170708

I can help with this . Let me know how you want me to go through them (certain letters, etc?)