July 27th, 2002

  • evan

status report

Tonight I modified NSIS to:
  • Use the Win2k+ font, if available, in its dialogs (the same way FotoBilder does). [trivial]
  • Add a $SENDTO variable to the installation language so I can add FotoBilder to the user's SendTo menu. [near-trivial]
God, I love open source. I would've been screwed if it hadn't come with source.

FotoBilder changes since last release:
  • minor
    • Show "initializing" when starting up transfer. [link]
    • Obey the "Remember Password" checkbox.
    • Pop up the Login box if the user hasn't entered a username and refuse to run without one.
  • Major
    • Enqueue new files into running FotoBilder process instead of starting a new one. [link]
    • Gallery support. Need server-side support if I'm gonna retrieve a gallery list.
      Bug: FotoBilder lets me create galleries with no name ("X-FB-Gallery: name=").
      Bug(?): FotoBilder galleries of the same name but in different cases should probably be the same(?). Observe my galleries: "Best Pictures Ever" and "best pictures ever".
    • Installer support. Use the above-modified NSIS to install (including into SendTo menu) and uninstall properly. When you install multiple times, it overwrites the old install, so don't worry about uninstalling between releases.


[FotoBilderInstall.exe]
computer crap

Late night question...

I'm here hackin' on fotobilder and I have a little hangup.

the 'user' table only exists on a dbs or a dbh handle, right? Obviously right now it exsits on any db handle because we only have one database, but i can't do something like:

SELECT * FROM secmembers m, user u WHERE m.secid='$secid' AND m.userid='$u' AND m.userid=u.userid

... because the user table and the secmembers table would probably/possibly be on different servers, right?

Also, just a quick run-down. I asked brad about this the other day, but I'd like to verify:

dbh = master writer
dbs = master reader
udbh = user writer
udbs = user reader

Is this correct? Any quick responses appreciated, I'm running out of coffee.
computer crap

Security Group Editor

The security group editor is complete. I haven't sent it to brad yet because I need to know if it is okay to select from 'user' and 'secmembers' in a single query. If not, I need to rework something real quick. See this post.

Also, I added a few new API functions and I need to WCMFUNC those... So it'll be fully complete tomorrow. Also of note is that FB::delete_secgroup() doesn't exist yet, we'll have to wait on brad to write that one since he knows the schema better than anyone else.
amused, happy
  • mart

Weird Thumbnail Behavior

The 320x240 images on the "Edit Picture" page on PicPix seem to be retrieving the full-size image rather than the resized version, which is making the small image take a stupidly long time to download on my 56k modem. Of course, the HTML is scaling it down to 320x240 anyway, so it's just a small image that takes a long time to download and looks like shit because my browser is scaling it rather than ImageMagick.

Patch submittal

Ok, I've implemented the palette-on-the-fly stuff for PNGs. Would someone be willing to walk me through the process of creating a patch from my changed file? (the only file I changed is Pic.pm)

If you'd like to see it in action:

Original image:
http://fb.mutualslump.net/jeremy/pic/00002abe


Change palette entry 0 to black
http://fb.mutualslump.net/jeremy/pic/00002abe/p0000000


Change palette entry 0 to black and 1 to white
http://fb.mutualslump.net/jeremy/pic/00002abe/p00000001ffffff


A couple of questions for Brad regarding his implementation:
- Is it possible to change the palette entry for palette entries > 15 (F)? It seems not since we're looking for multiples of 7 for each change
- I do some error checking of the PNG (ie. check for valid signature, make sure png type is indexed palette). Is the "right" way to react to errors to return 404?

A few final notes:
- Right now it breaks if you try and change a nonexisting palette entry (PNGs don't have fixed size palettes). The test image only has entries 0 and 1. I'll fix this before I submit the patch.

thanks,
jeremy

Updated: The patch is now available here.
belize
  • brad

Update

New stuff:

-- jredburn's PNG modifying code in. (good work... nice & clean!) moved GIF & PNG palette modifying code to its own file. (Note: this requires a new library... String::CRC32)


-- added doc/CONTRIBUTORS.txt file ... for now it's sorted by amount of work done, approximately, but if this gets to be a controversial thing, I'll change it to alphabetical. in the future, update the contributors file in any patches you send in. (whether to add yourself or to add a new feature line under your name)

-- fix from whitaker (pointed out by mart) where full image was loading on /manage/pic page... (had two $url vars... overlapping in scope)

-- new tool bin/fotodb which just execs the command-line mysql client with all the arguments you need, based on %FB::DBINFO ... when I was debugging patrick's installation problems, I wrote this when I realized it's hard to instruct somebody to get into their mysql shell perhaps, or it's inconsisent if I have to maintain different fotobilder installations in the future.

Much remaining to do ... seems everybody decided to mail me with FotoBilder work the day I went away. (oh, that weekend thing.)
belize
  • brad

Group editor

whitaker's friend/security group editor is in CVS, and picpix.com is updated. Give it a whirl. It's not entirely done. Remaining:

-- deleting groups (which requires some db stuff I need to do)
-- editing by user, instead of just by group. (given a user, add/remove groups they belong to) whitaker's working on this next, after he makes a BML template from niko's site design.

Also, new snapshot at:
http://www.picpix.com/download/code/