Hello!

Could anyone tell me the ‘standalone’ SQL query for submitting new ratings?

I wish to insert new ratings from another website (on the same server) in to the DB and wanted to check what the proper SQL would be for that.

I’ve got the SQL output from debugging prefs but wondered if there was anything to bear in mind when doing it this rather odd way.

(I could get a license for MSM but I doing really want to do that if possible)

Tony,

It’s important to keep in mind the pre-processing that takes place when a rating is inserted. I do all the math for ratings on insert rather than on page load. So you’d want to invoke some of those sub-routines. We’re doing a rating module API for a private client and may need to architect some of the insert part in an abstracted way which would suit you. Can’t offer any guarantees, but it could become easier soon.

mk

Hmmm, yes.

I’ve blown that idea out of the water now.

Got myself a copy of MSM today so I’m heading back to FUN TOWN.

I take it the Ratings module plays nicely with MSM?

Tony Nibbles - 10 March 2008 06:25 AM

I take it the Ratings module plays nicely with MSM?

Actually… not quite… according to some very recent user testing.
We plan to fix this shortly though

The Rating module is not yet compatible with MSM.

mk

I spent some time working with it last night, and I have it working cross-domain between two sites in MSM.

So far so good - it’s working how I need it too

(not sure if that means it’ll break when the next Rating update comes out or not!)

Excellent. One of the reasons Rating was lower on the list for MSM conversion was that a rating is not meaningful when not tied to a specifc id in the database. All entries are unique across EE, MSM or otherwise. So for most purposes, you should be ok.