Coding a small CMS

[Aaron]

Then they should make a review for each platform =P

I can't really code a rating system (I'm pretty sure ..), but I think I might be able to code a counter for each review.

Things I want to (be able to) do soon:
- Counter showing total views (like PHP Scripts page)
- Display "New" next to the 5 newest reviews.

[ShadowyOne]

admin said:

Then they should make a review for each platform =P

I can't really code a rating system (I'm pretty sure ..), but I think I might be able to code a counter for each review.

Things I want to (be able to) do soon:
- Counter showing total views (like PHP Scripts page)
- Display "New" next to the 5 newest reviews.

Maybe there should be another column for other systems. Like, you use the drop-down box for the system you played the game on, but then there's an optional text box for other consoles/handhelds/systems that the game's on. Maybe you shouldn't do it now, but when people can submit real reviews during this, there should be some method of saying the game's multiplatform.

And the counter and display new review thing sounds good.

Last Edit: Jun 20, 2005 11:24:14 GMT -8 by ShadowyOne

[Aaron]

There wouldn't be enough room to display the other consoles the game is on, on the reviews index page. The only place it would be decent to be displayed at is the actual review page with the review.

Any other ideas?

I finished the views feature. It's also modify-able in the modify review area.

[Aaron]

I'm taking a break from DarkGamer version 3 to work on this.

I got a little bit farther.

Now you can see who the top reviewers are and how many reviews they have created.

Current Bugs:
Deleting a review individually doesn't subtract the amount of reviews written by a reviewer.
-- Ex. Deleting 1 review from Naruto won't change 20 reviews to 19.

---

I had to delete all the reviews after I made this feature.

[ShadowyOne]

admin said:

I'm taking a break from DarkGamer version 3 to work on this.

I got a little bit farther.

Now you can see who the top reviewers are and how many reviews they have created.

Current Bugs:
Deleting a review individually doesn't subtract the amount of reviews written by a reviewer.
-- Ex. Deleting 1 review from Naruto won't change 20 reviews to 19.

---

I had to delete all the reviews after I made this feature.

Great, now I have to add 20+ reviews again. That's okay, they were short anyway.

[CD]

XD I'll add my amazing Guild Wars again. Anyway, Naruto, I learne dMySQL yesterday (or at least the basics, and in the process, gave Crazy my password XD )

Anyway, I'm not sure how you coded it in a table, but try going through each individual review, and then have it add "1" to a variable for each instance of the author's name.

[Aaron]

No, it adds properly, just doesn't subtract. I'll figure it out eventually.

Good luck with MySQL if you pursue it. I'm still learning the basics.

@ ShadowyOne - ............ that's a lot of reviews.

[CD]

But why would it still add it if it was deleted form the table?

Edit: I deleted one of SO's reviews, and it worked fine. Went from 32 to 31. Now to run from the KEA admin.

Edit2: But in top 5 it doesn't update. x.x

Last Edit: Jul 5, 2005 22:38:40 GMT -8 by CD

[ShadowyOne]

You're damn right that's a lot of reviews. Now I have to kill CD.

And I think someone's putting up er...bad reviews on there. I deleted it, but the submitted name is still there under people who reviewed.

[CD]

Attack me SO, and I shall use the cherry flavored starburst cannon on you. XD

Anyway, yeah, keep up the great work Naruto.