I'm having trouble putting weather_city.sql in the database... Looks like it's timeing out, how do I split the file?

Thanks in advanced! :banana:

Ian, open the file up...you can use Notepad (or any plain-text editor)...Just copy a bunch of lines, paste into a new file, name it 1.sql (or whatever). I'd try splitting it into thirds at first. Each line starts with INSERT INTO and ends in );

For the record, anyone installing it now and not getting current weather info...this is a problem from the source, not the hack (just saw my own city was like this, checked a few random other US cities and saw the same thing).

Is there a quicker way? It takes forever to highlight all those lines(there must be a shortcut)

Put the cursor at the beginning of the file. Scroll down (with the scroll bar) about a third of the way down. Hold down the Shift key, then click at the beginning of a line there. That will highlight everything between where the cursor was and where you put it.

Hi all,

I hope JJR512 doesn't mine. I added this to his hack. This will tell you what city,state, and country right after Your Current Weather. This will show on your forum home page. Your Current Weather For (City),(state),(country).

Find in forumhome_weather template
Then Add this right after Weather

Thanks for a wonderful hack JJR512

Ok, I got everything installed and it works good except that I only have the 5-day forecast now and no current weather. There is no icon and all there are zeros for the current weather but the 5-day forecast works great! :) Also, the force update still doesn't work for me. Could it be that my ISP is using PHP version 4.2.2 on the server, as to why the force update doesn't work? (JJR512, I notice your server uses version 4.1.2.)

Works great, JJ. The only problem is that the default NY, USA weather for guests doesn't work - there is the "Offline" icon, and no numbers. Any ideas?

I see... the NY, NY, USA weather results are not showing for CURRENT weather, but the 5-day forecast is showing... weird.

Other cities seem okay.

Erwin,

Can you check Des Moines, Iowa, USA and see if it shows the current weather for you, please? :)

Other cities are working, though. For example, Melbourne Australia works great... it's unfortunate that the default city is not working... Any ideas?