Rewrite TV-Guide script

[Afkamm]

OOPs, my bad. Missed something

Code: Select all

#
#-----[ OPEN ]-------------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]-------------------------------------------------
#
define('PAGE_GROUPCP', -11);

#
#-----[ AFTER, ADD ]-------------------------------------------
#
// Start - TVGuide MOD
define('PAGE_TVGUIDE', -50);
// End - TVGuide MOD

#
#-----[ FIND ]-------------------------------------------------
#
define('TOPICS_WATCH_TABLE', $table_prefix.'topics_watch');

#
#-----[ AFTER, ADD ]-------------------------------------------
#
// Start - TVGuide MOD
define('TVGUIDE_CHANNELS_TABLE', $table_prefix.'tvguide_channels');
define('TVGUIDE_SHOWS_TABLE', $table_prefix.'tvguide_shows');
// End - TVGuide MOD

What does this part do? I don't understand why there are titles from series there.

You put your shows in here and when they're found the background has a different colour when the channels are displayed.

Shouldn't be hard to do if you wish for only these shows to appear and not display any others by adding an option to do so.

[Maxx]

OOPs, my bad. Missed something

Ah yes, now it displays. See the page on my forum here.

What does this part do? I don't understand why there are titles from series there.

You put your shows in here and when they're found the background has a different colour when the channels are displayed.

Shouldn't be hard to do if you wish for only these shows to appear and not display any others by adding an option to do so.

Ah, I understand the linking-method. Is there however a possibility to use the showtitles as the searchwords without having to define them in the database first? As you can see in our showlist we have over 250 shows in our database and we're still growing each day.

Then for a little feedback. I'll do it per page to keep it readable, but overall I have to thank you for the wonderful job you did!

Adminpage - Channels
Very nicely done, it's very readable and easy to adjust. I did get an error when I tried to switch some of the channels off. The same error appeared when I tried to change the Group of a channel and when trying to delete a channel. The following error occoured after clicking the 'Submit changes' button:

Code: Select all

Fatal error: Call to undefined function: add_slashes() in c:\domains\seriejunkies.nl\wwwroot\admin\admin_tvguide.php on line 238

Adding a channel works perfectly.
Enabling and disabling whole groups also works perfectly.

Adminpage - Configuration
Easy to edit, works perfectly.

Adminpage - Shows
Easy to edit, works perfectly. But see my earlier remark about not having to define the shows.

TVGuide.php
When displayed in a list, the links on the defined shows do not show. For example, when displayed in a grid, the show NOS Journaal (I added this 'show' to test) has a link to a search on the words in the title of the show, but when it's displayed in the grid, there's no link.

More about the linkfunction
Is it possible to define the search as follows?

• Predefining the shows should not be necessary, when a show is not found people will see that on the resultpage;
• Search for any of the words in the shows title, but NOT words like 'the', 'a', 'an', 'and' and the Dutch equivalents 'de', 'het', 'een' and 'en';
• Search only in topictitles;
• Display results as topics, not as posts.

Thank you very much for making all of this already. I hope you'll have time to look into my comments.

[Afkamm]

Fatal error: Call to undefined function: add_slashes() in

Code: Select all

#
#-----[ OPEN ]-------------------------------------------------
#
admin/admin_tvguide.php

#
#-----[ FIND ]-------------------------------------------------
#
				$display_name = add_slashes($display_name);
				$web_name = add_slashes($web_name);
#
#-----[ REPLACE WITH ]-----------------------------------------
#
				$display_name = addslashes($display_name);
				$web_name = addslashes($web_name);

Is there however a possibility to use the showtitles as the searchwords without having to define them in the database first? As you can see in our showlist we have over 250 shows in our database and we're still growing each day.

Are the names of those shows hard coded to the page, or do they come from a database table? If they come from a table then I'll need a copy to play with.

When displayed in a list, the links on the defined shows do not show. For example, when displayed in a grid, the show NOS Journaal (I added this 'show' to test) has a link to a search on the words in the title of the show, but when it's displayed in the grid, there's no link.

That's right, I thought I'd just do one and let you see if first before doing the other.

[Maxx]

Fatal error: Call to undefined function: add_slashes() in

Tnx. I'll change that tomorrow or the day after that (weekend and vacation are over again) and get back to you on that.
Edit 23/7: Works perfectly now!

Are the names of those shows hard coded to the page, or do they come from a database table? If they come from a table then I'll need a copy to play with.

The shownames are not hard coded. They are just the topic-titles. For example, this topic is about the show Traveler. The topictitle equals the showname.

That's right, I thought I'd just do one and let you see if first before doing the other.

Ah okay. I prefer the list-option myself, but it would be nice to let the users choose their preference like you showed in an earlier example. About the list-version though: is it possible to make the indiviual channellist as long as the longest channellist in a row? So, when a there are 4 channels listed in a row and 3 have like 5 shows and 1 channel has 10 shows until the end of the day, is it possible to fill the other 3 channellists out with 5 blank lines so the bottoms of the tables are aligned?

Btw. I already put this version live. I told my users about it and acknowledged your programming in the announcement. Thanks again!

[Afkamm]

The shownames are not hard coded. They are just the topic-titles. For example, this topic is about the show Traveler. The topictitle equals the showname.

Does the forum category only contains forums that have topics for shows in them, or can anyone create a topic in these forums? I might be able to use topic title data that's in the database already.

is it possible to make the indiviual channellist as long as the longest channellist in a row? So, when a there are 4 channels listed in a row and 3 have like 5 shows and 1 channel has 10 shows until the end of the day, is it possible to fill the other 3 channellists out with 5 blank lines so the bottoms of the tables are aligned?

I'll see what I can do.

[Maxx]

Does the forum category only contains forums that have topics for shows in them, or can anyone create a topic in these forums? I might be able to use topic title data that's in the database already.

The category "Serie Database" has 8 subfora where only the crew can add topics. So the topics in these subfora are always named after the series that they are about. The subfora in this category are 4, 5, 6, 7, 8, 11, 16 and 17.

You can see it here: http://www.seriejunkies.nl/portal.php.

[Afkamm]

If the topics are exactly the way that tvgids.nl has the shows named then I'll be able to use the topics from that forum table and use them for searching with.

[Maxx]

Not always exactly. For example The 4400 is called "The 4400" at TVgids.nl, but in our database it's called "4400, The". But mostly they are the same.

I think if the words in the title are searched for (no matter what order) the specific topic will be included in the searchresults.

[Maxx]

Hey Afkamm, it's been a while. Have you make any progress with the script?

[Afkamm]

Sorry, no I haven't. Been slow on the php programming side due to work commitments.