Alpha: VBSoccer Tennis Cricket Formula1 - (others sports are being modified)

Hi,
These r some additions i am adding to my own forums containing livescores pages, and other pages for tables of major leagues, fixtures, standings and fixtures.
Some of the content is routed through my site including the first 4 attachments, while sports.zip which enables
Soccer, tennis, hockey, baseball, basketball, and american football
Will act as follows : Cron job to download the feeds from my website, parse into database, and the sports.php will accordinaly show which tables selected to users.

Demos are on :
http://www.tchatting.com/forum/livescores.php
http://www.tchatting.com/forum/latest.php
http://www.tchatting.com/forum/cricket.php
http://www.tchatting.com/forum/formula1.php
http://www.tchatting.com/forum/tennis.php


Attention: None of these files will work if you do not have allowurl_fopen_on




All you need to do is upload two files, few images and create two templates using the xml product file included.
Your server must allow you to include remote files ( allow_url_fopen = on )
There is no installer as they are only two templates to add manually.

I am still developing this for further additions so it might follow some updates especially if i was given more ideas.

The livescores page contains a Link to a freebet.php file that i did not include but rather is up to you to create and add your own content page since you cannot modify the body.
Though you cannot modify the table itself but its percentage table thus you can edit the template as you may and just make sure to keep the variable.
The goals.php and standings.php are non vb pages but rather popups, their style is included within the en.css style sheet thus you can edit to match your forum look and feel.

To install just upload the files, add the two templates, and dont forget to link to it from your navbar or header.

May 22nd , added Tennis under further development too.
demo at
http://www.tchatting.com/forum/tennis.php
zip attached
May 25th, added cricket parsed rss feeds as requested by Zia, he also suggested the free feeds to be displayed.
nb: crickinfo.com provides the feeds for free as long as you keep their copyright, parsing technique Copyright 2005 Drew Phillips
cricket.zip attached
demo at
http://www.tchatting.com/forum/cricket.php
nb: in cricket.php FIND
/home/username/public_html/forum
and replace with your actual forum path this setting will actually put a cached copy of the rss feed on your desired directory so you dont overload your server connections

June 02 2006
Uploaded formula1.zip ,
One file to upload and one xml to export 1 template.
Includes, Formula 1 results, Drivers Standings and Constructors Standings

June 02 2006
Added Sports.zip
To Install :
1:Export scorestables.xml
This will create your required database tables.
2: Export ONE of the templates xml files the first one sportstemplates.xml has also links to the previous attached files if installed, the second does not if you are using sports.php alone.
3: upload sports.php to forum root, and owsoccer.php to includes/cron/
4: Add the cron job as described in the note ( See the picture included in the zip file ) and DO NOT change the minute value, it is set to update once per hour, keep it so , as the feeds are updated once per hour too and it will not be any more usefull if you hammer my server with requests !
Finally,
For using any of those add your own navbar or header links wherever you find suitable on your forum.

Attention : I removed sports.php , untill i resolve some communication setting and few other issues, the rest are working fine.

Suggestions and feedback for further improvements are appreciated.
If you use the feeds please click install !

Sports.php is no longer served.

20 Jan 2007 : Updated soccer.zip
changed files :
livescores.php
goal.php ( you can safely delete old goals.php )
standing.php ( you can safely delete standings.php)
en.css ( because of changed goal and standing class names)
images to be uploaded to your forum images directory.
If you are updating, its enough to replace those files with no further editing or installing.

[lebanon]

Am hoping to continue development of this hack very soon, but i got stuck with loads of work (my actual daily job) and thus am unable to fix few glitches, although the attached 4 files are working just fine !
The problems am having are in the sports.php ( which is not listed right now in the zip attachments)
Also as when am done, i would be probably obtaining more leagues and feeds but till then, as i first mentioned i did this because am a worldcup fan and thats what mostly interests me now, and i started adding more sports as per your requests
Hope to be able to set language translations and others soon.

[ithf]

ok...i downloaded the soccer zip file...it came with 3 folders...templates, forum folder and images.

I uploaded the content forum folder into my main folder.....via ftp
the template folder...vbsoccertemplate..i uploaded into includes/xml/vbsoccertemplate via ftp

and the mages...

when I go to forum.domain.com/livescores.php...just white page..nothing happens

[firstrebel]

uploaded into includes/xml/vbsoccertemplate

No. Import it as a product.

Bob

[ithf]

I got it...thanks

[firstrebel]

My server error log shows that mydomain/forum/livescores.php looks for /images/im.gif but does not find it. Where is it?

Bob

[firstrebel]

My server error log shows mydomain/forum/latest.php looks for left_top.gif, left_bottom.gif, right_top.gif, right_bottom.gif. Where are they?

Bob

[sudn3sc3d]

just awsome thats all i got say just awsome.

[bashy]

Hi

Been getting this error for a little while now

Database error in vBulletin 3.5.4:

Invalid SQL:

	INSERT INTO tctsoccer	
       (entry1, entry2, entry3, entry4, entry5, entry6, entry7, entry8, entry9, entry10, entry11, entry12, entry13, entry14, entry15, entry16, entry17)
    VALUES
        ('');

MySQL Error  : Column count doesn't match value count at row 1 Error Number : 1136
Date         : Monday, June 19th 2006 @ 01:29:15 PM
Script       : http://www.bashys-place.com/forums/cron.php?&rand=518979
Referrer     : http://www.bashys-place.com/forums/forumdisplay.php?f=7&tboffset=1

Any ideas please?

[lebanon]

bashy, i did disconnect sport.zip and added a notice about this, there will be a release for more sports but right now am really too busy with work and worldcup When this is over i will have free time again and will re-release a sports version, and probably vb 3.6 will be stable by then and i can make sure it works on both.
As for now am sorry not to be able to support this hack or release updates before the end of worldcup

[GafferSports]

This no longer works. The sites are down