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.

[Zia]

hi Lebabnon,

any idea abt the ETA of the final relase ?

[lebanon]

zia, i suppose it will take few days, the new hack is much different than beta and it run totally from your server with only one cron job to download the feeds from mine. And i do have a job in the day so i only have an hour or two in the afternoon , but surely before this week ends. regards

[Zia]

Hi Lebanon,
Nice to know abt that.

umm would u mind to say..why ur not releasing those hacks vbHoroscope,vbimdb etc here?
Plz give a serious thought on it..releasing them in vb.org?

[lebanon]

zia, simply those hacks do not comply with vborg policy, and even on my website you have to agree on the terms, as they provide you the function list to re-post the information but you need your own authorization to do so

[Zia]

ahem ahem ahem Lebanon,
sorry to say that im totally in dark abt the policy...
what ever it is the policy..

shall we get support about those mentioned hack (vbimdb,horoscope) ?
thats my point man.gez u reliaze it.



end of the week is knocking at the doorrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrr

Knock Kncok,hello.. Mr.vbsoccer & Mr.Vbcricker is home now or comming to home?

[lebanon]

Zia , i have uploaded the rest of the files.
But still am not satisfied with the design, I hope some designer would volunteer to submit a better templates design or so !
Anyway , i will review the files later to see what would be needed to be modified after your reviews guys. thx

[soulface]

lebanon, in one word 'Simply gr8'

ops! two word i mean

[bashy]

Just installed the sportstemplate 1 and got this db error

Also Forumla 1 does not appear to be working?

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
        ('001','FRIENDLY GAMES','FRI','21:00','SWEDEN','1-1','CHILE','Second Half','90'','1-0','-','-','-','-','-','-','SUAZO(51)
');

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1-0','-','-','-','-','-','-','SUAZO(51)
')' at line 4
Error Number : 1064
Date         : Friday, June 2nd 2006 @ 02:08:21 PM
Script       : http://www.bashys-place.com/forums/admincp/cronadmin.php?do=runcron&cronid=47
Referrer     : http://www.bashys-place.com/forums/admincp/cronadmin.php?do=modify

[lebanon]

bashy, yes obviously we all face this error , because when i was testing the hack there was no games and the feeds contain ' character for the minutes value, i am fixing this asap and in the next games today feeds will not contain any more 's

[bashy]

ah...that explains that then
In the sports.php will you be adding Forumla 1 as a main link?