Read-only archive of the All About Symbian forum (2001–2013) · About this archive

New Review Admin

9 replies · 63 views · Started 18 January 2003

http://robin.genx.be/review/

Do you like this?

And Rafe if you like it, tell me what functions you need for the site.
I've got full_review_list(); and get_review($id); so far

EDIT: Dazler - I think I misunderstood what you meant. The editing / adding system looks brilliant. The only thing left is the user side which I'm happy to do if you want?

Dazler - that looks superb!

In terms of the site it needs a way of listing reviews by device in their categories (i.e. the list for the 7650 Reviews page, P800 Reviews page etc). These I would guess can be combined to get a list of all for the main reviews page. It would also be good to have a list for top scoring review (one over 90%, one over 80%). I guess also one for list showing all reviews by gievn author. Also most recent 5 reviews by device.

I can produce these if necessary (just a question of using the right SQL command) - this is what I'll do for WAO.

Looks brilliant though 😊

Yes, but I was thinking to get the category and devices from a table or like I use it now, from a file that is ...

We should make sure that we don't hardcode anything .... I'm sure you know what I mean ...

And I wouldn't connect to sql from anything else then 1 general review include file (if we need to change again) ... I'll try some stuff and send it over.

Dazler:
http://www.allaboutsymbian.com/phpBB2/viewtopic.php?t=6164

This link contains what I did for the user end of the new reviews system and a brief overview of the fields required for entry in the database. If that gives you any inspiration with the PHPing, my skillz aren't up to scratch in that department.

Yes I saw, added your 'date' field, and implementing all the functions needed to generate those list 😊

I think these functions can generate most things required by Rafe and Switchblade ...
http://robin.genx.be/review/test.php

you'll need to get the last reviews from the full list function and the reviews per user 2, Is that OK Rafe? Or maybe better to get a seperate function call for them?