Topic: Concerning my marathon topic

[Jimmy]

I just got an empty review on the front page

Just get one tonight, but the boss his on vacation. This is the first time since you've change the script that I see one.

[Najemikon]

That's one of Eric's according to the link below the space. I thought this was only caused by naughty reviews? 

[Touti]

That's one of Eric's according to the link below the space. I thought this was only caused by naughty reviews? 

Bad ones too apparently 

[DJ Doena]

Seems to be a glitch in the review selection code, I've seen it too, but am too lazy to debug it

[DJ Doena]

DJ Doena: Splitted into seperate postings

That didn't explain why I've seen you posting in the # - section 

 

I had to correct some of your links. 

No, seriously. Yesterday I wrote an small program that parses all the links and puts them in a seperate database table (just as Eric had done it in the beginning). And my program noticed some duplicate links that were supposed to lead to different reviews.

Now that I have the program and the table I can update it whenever you update the lists. This will make the PHP script that selects a random review way more easy and less buggy.

[Najemikon]

I had to correct some of your links. 

The new manager's throwing his weight around, eh, Jimmy? 

[Jimmy]

Now that I have the program and the table I can update it whenever you update the lists. This will make the PHP script that selects a random review way more easy and less buggy.

Any chance that you can use this to make a ranking of the reviews contributor like Eric did at the beginning of the list?

[DJ Doena]

Now that I have the program and the table I can update it whenever you update the lists. This will make the PHP script that selects a random review way more easy and less buggy.

Any chance that you can use this to make a ranking of the reviews contributor like Eric did at the beginning of the list?

What do you mean by this?

Something like this?

570	addicted2dvd
224	Jimmy
208	Tom
149	Rich
95	Jon
85	DJ Doena
80	richierich
65	Dragonfire
54	RossRoy
50	Eric
17	goodguy
8	James
7	DVDsRGreat
4	Kathy
1	Achim
1	Peter von Frosta

[Jimmy]

Exactly
But with a better look

[DJ Doena]

The new randomized review generator is now online and the code is way more easy.

What I basically did was writing a .NET program that accesses the MySQL database and queries all the postings in the review forum. Then it parses all the lines in the postings for a typical review entry. Then it parses that one and writes the data into another MySQL table.

In the end it looks like this:

topicid    messageid    number    User    Title
5036    83527    0    Rich    ...and justice for all
4159    81314    1    Jon    [.REC]
5036    83526    2    Rich    *batteries not included
741    72035    3    RossRoy    The 6th Day
451    66164    4    addicted2dvd    13 Ghosts
5086    82905    5    addicted2dvd    13 Going on 30
5081    82711    6    Dragonfire    101 Dalmatians
5154    84284    7    Dragonfire    102 Dalmatians
726    70239    8    addicted2dvd    1408
5062    82645    9    Jimmy    2LDK
...
5036     83404     1575     Rich     Zulu Dawn

And from there I simply select a random post and display it.

The only real problem was Jon's [.REC] movie because it screwed up my regular expression. 

[richierich]

Now that I have the program and the table I can update it whenever you update the lists. This will make the PHP script that selects a random review way more easy and less buggy.

Any chance that you can use this to make a ranking of the reviews contributor like Eric did at the beginning of the list?

What do you mean by this?

Something like this?

570	addicted2dvd
224	Jimmy
208	Tom
149	Rich
95	Jon
85	DJ Doena
80	richierich
65	Dragonfire
54	RossRoy
50	Eric
17	goodguy
8	James
7	DVDsRGreat
4	Kathy
1	Achim
1	Peter von Frosta

I'm so good - I made the list twice   

[DJ Doena]

That's for changing your nick. 

You can ask Jimmy whether he's willing to change all the 80 entries in his lists. 

[Najemikon]

Achim? 1? Is that right?

[Jimmy]

I'm so good - I made the list twice   

Look at the number this is you Around the World marathon. I will try to remember to change the name for my next update.

Achim? 1? Is that right?

It's his review of The Girl who Leaped Through Time (or something like this ).

[Achim]

I made several review-like posts, where I comment on a film in more than one paragraph. But I actually may have done one full-blown review, with cover image and all...