vb.org Archive - vB Weather Mk. 2

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - vB Weather Mk. 2 (https://vborg.vbsupport.ru/showthread.php?t=41842)

Quote:

Originally posted by Minifreunde
@ JJR!
Thanks, i did it so.
But i don?t get the weatherinfo.
I put youre hole code in the home.php directly for that line you say. I edit that line to fit my new template with the weather-Info for Home.php. The template called home_left_weather.
But the weather didn?t appear.... I placed the $currentweather in the home_left template.
Is there anything that must be done?
* Minifreunde get nervous if something like that happend... ;)

I run a (very) hacked up version of home.php and use a left/right in my index.php and forumdisplay.php... I had to add the weather code BEFORE I called the left and right templates.... and now it's showing up on the left side properly...

On a side note... this is agreat hack but I found a coding error in the weather_main template... the link to force an update seemed to be missing "&action=getdata" before "&forceupdate=yes"

*clicks Install Button* Thumbs up!!!!!

He's right! If I add that, then it doesn't give me a blank page anymore. I don't get the confirmation message either, but at least I don't get a blank page now on force update. JJR512, what do I need to change to get the confirmation message now? :)

Quote:

Originally posted by mbaskett
On a side note... this is a great hack but I found a coding error in the weather_main template... the link to force an update seemed to be missing "&action=getdata" before "&forceupdate=yes"

Hi

Using VB 2.6 and having a small problem, I just installed the hack and it works great, nice one. I changed the Country to Spain and it doesnt list any Cities so I saved it and whenever I now try and edit the settings for the time change I get a SQL Database error:

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT accid,city_title FROM weather_city WHERE subdivid= ORDER BY city_title
mysql error: You have an error in your SQL syntax near 'ORDER BY city_title' at line 1

mysql error number: 1064

Date: Thursday 22nd of August 2002 12:23:08 AM
Script: http://www.villas4spain.com/forums/f...modifysettings
Referer:

I am pretty sure this is because Spain didnt have a ny cities listed, I tested it before and changed the settings on US Cities.

Anyone know how I can solve this please? Other members don't have this problem so its just because mine saved on Spain, its sort of blocked it.

Any info would be cool

Thank you

Stu

Fatal error: Call to undefined function: convert_temp() in /home/virtual/site13/fst/var/www/html/forum/index.php on line 424

i followed the instructions step by step.. and reinstalled, following each step very very carefully. Can someone assist.

Reach me on aol IM mysweetfocus
or yahoo zarkarin
or reply to this thread!

re installed.. and it worked this time... ODDDD awesome hack!

What do I enter for the following, under "Create new table on database vbulletin"

Name : ????
Fields: ????

Installed, and it works great! I haven't tried setting it to Spain, though...

The time is screwed up it seems, I've tried a few things to get it to consistently give users something a little more accurate in reference to their local time, but no joy yet.

Thanks for a great hack!

Installed. Awesome. Easy to modify the design to cutomize to my board.
Thanks
TCS

JJR512, the guy who tried to set Spain as his default is right, there are no cities for Spain in there. Can we get some or at least take Spain out if there is none so we don't have users getting stuck like that? :)

Anyones weather working today?

Mine went down about an hour ago. They must be temporarily down.

mines went down too. i thought i was the only 1.

Mines went down too.... hope it will work again soon!! ;)

well it back up agian

It's working for me at the moment.

Just looking through the Weather_City data and I'm wondering whether I REALLY need to load all of this ?

I am based in the UK, and no-one is going to need any of the data for the rest of the world?

Would it help to keep things smaller and neater if I ONLY loaded the UK specific data?

Would it still work?

You don't get any users from anywhere else in the world? :)

Quote:

Originally posted by BrAinZ
Just looking through the Weather_City data and I'm wondering whether I REALLY need to load all of this ?

I am based in the UK, and no-one is going to need any of the data for the rest of the world?

Would it help to keep things smaller and neater if I ONLY loaded the UK specific data?

Would it still work?

Quote:

Originally posted by Boofo
You don't get any users from anywhere else in the world? :)

Nope.. Our board is only for staff of our Company, which is based in the UK. Well actually I might need to need Hong Kong in there, as we have a few staff there.

Hi,

Most of the time under the Temperature box there is no temperature, showing. (as you can see in the pic)

but under Detailed Forecast all comes up !
is it possible to fix that ?

LeMarsu

Database error in vBulletin 2.2.7:

Invalid SQL: SELECT accid,city_title FROM weather_city WHERE subdivid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

$cities = $DB_site->query("SELECT accid,city_title FROM weather_city WHERE subdivid=$current_subdiv[subdivid] ORDER BY city_title");

i think this query seems to complicate it..

i have created all tables and made the changes, i run it 4 times deleted it and made a fresh install... everytime i got this error, can anyone help?

--------------------------------------------------------
edit: ok fixed my errors, works great

/me clicks install

Quote:

Originally posted by PsYc
Database error in vBulletin 2.2.7:

Invalid SQL: SELECT accid,city_title FROM weather_city WHERE subdivid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

$cities = $DB_site->query("SELECT accid,city_title FROM weather_city WHERE subdivid=$current_subdiv[subdivid] ORDER BY city_title");

i think this query seems to complicate it..

i have created all tables and made the changes, i run it 4 times deleted it and made a fresh install... everytime i got this error, can anyone help?

--------------------------------------------------------
edit: ok fixed my errors, works great

* PsYc clicks install

same as my problem.. what did you fix?

==========================================

JJ.. Great hack!

Hello, someone can helped?

Great hack! (5)

Only 2 problems.

1) The time is 40 minutes in the future.

2) There are no subdivisions in Canada such as Alberta, Ontario, etc, but all the cities are listed. All others are working for me.

BTW: Just wondering if you are planning on adding the option for users to select different .gif files when modifying settings?

Running on 2.2.7

Quote:

Originally posted by Gohan

same as my problem.. what did you fix?

you have to put all .sql files via myphpadmin in the tables you created, only if you have transfered all content in these tables it will work

cities1-5.sql

region.sql

subdiv.sql

etc..

Quote:

Originally posted by PsYc
cities1-5.sql

Hmm.. i havent it but well weather_city5.sql

EDIT: Doesnt working!!! :tired:

Hi,

I am looking in placing the weather in my vbindex, as described in post #107.

can anyone point me towards the template ? and all the other info you think I might need.

Thanks

LeMarsu

Open vbindex.php and find:

PHP Code:


		
			
// left & right templates

add ABOVE:

PHP Code:


		
			
if ($weatherpage!=1 or !isset($weatherpage)) {



  $usersettings = $DB_site->query_first("SELECT * FROM weather_usersettings WHERE userid=$bbuserinfo[userid]");

  if (!isset($usersettings[userid])) {

    $usersettings[accid] = "USNY0996";

    $usersettings[tpc] = "1";

    $usersettings[tps] = "1";

    $DB_site->query("INSERT INTO weather_usersettings (userid,accid,tpc,tps) VALUES ('$bbuserinfo[userid]','$usersettings[accid]','$usersettings[tpc]','$usersettings[tps]')");

  }



  $userdata = $DB_site->query_first("SELECT * FROM weather_userdata WHERE userid=$bbuserinfo[userid]");

  $datecut = $userdata[time];

  if ((time()-7200)>$datecut or $forceupdate=="yes") {

    $rawdata = fsockopen("www.msnbc.com",80,$num_error,$str_error,30);

    if(!$rawdata) {

      $weather[error_num] = $num_error;

      $weather[error_str] = $str_error;

    } else {

      fputs($rawdata,"GET /m/chnk/d/weather_d_src.asp?acid=$usersettings[accid] HTTP/1.0\n\n");



      while (!feof($rawdata)) {

        $getbit = fgets($rawdata,4096);

        $getbit = trim($getbit)."\n";

        if (substr($getbit,7,4) == "City") {

          $weather[city] = substr($getbit,15,40);

          $weather[city] = substr($weather[city],0,strlen($weather[city])-3);

        }

        if (substr($getbit,7,6) == "SubDiv") {

          $weather[subdiv] = substr($getbit,17,20);

          $weather[subdiv] = substr($weather[subdiv],0,strlen($weather[subdiv])-3);

        }

        if (substr($getbit,7,7) == "Country") {

          $weather[country] = substr($getbit,18,20);

          $weather[country] = substr($weather[country],0,strlen($weather[country])-3);

        }

        if (substr($getbit,7,5) == "Temp ") {

          $weather[temp] = substr($getbit,15,20);

          $weather[temp] = substr($weather[temp],0,strlen($weather[temp])-3);

        }

        if (substr($getbit,7,5) == "CIcon") {

          $weather[cicon] = substr($getbit,16,20);

          $weather[cicon] = substr($weather[cicon],0,strlen($weather[cicon])-3);

        }

        if (substr($getbit,7,5) == "WindS") {

          $weather[wind_spd] = substr($getbit,16,20);

          $weather[wind_spd] = substr($weather[wind_spd],0,strlen($weather[wind_spd])-3);

        }

        if (substr($getbit,7,5) == "WindD") {

          $weather[wind_dir] = substr($getbit,16,20);

          $weather[wind_dir] = substr($weather[wind_dir],0,strlen($weather[wind_dir])-3);

        }

        if (substr($getbit,7,4) == "Baro") {

          $weather[barometer] = substr($getbit,15,20);

          $weather[barometer] = substr($weather[barometer],0,strlen($weather[barometer])-3);

        }

        if (substr($getbit,7,5) == "Humid") {

          $weather[humidity] = substr($getbit,16,20);

          $weather[humidity] = substr($weather[humidity],0,strlen($weather[humidity])-3);

        }

        if (substr($getbit,7,4) == "Real") {

          $weather[realfeel] = substr($getbit,15,20);

          $weather[realfeel] = substr($weather[realfeel],0,strlen($weather[realfeel])-3);

        }

        if (substr($getbit,7,6) == "LastUp") {

          $weather[lastup] = substr($getbit,17,25);

          $weather[lastup] = substr($weather[lastup],0,strlen($weather[lastup])-3);

        }

        if (substr($getbit,7,7) == "ConText") {

          $weather[context] = substr($getbit,18,25);

          $weather[context] = substr($weather[context],0,strlen($weather[context])-3);

        }

      }



      // Location Info

      $weatherdata[city] = $weather[city];

      $weatherdata[subdiv] = $weather[subdiv];

      $weatherdata[country] = $weather[country];



      // Current Conditions

      $weatherdata[temp] = convert_temp($weather[temp],$usersettings[tpc]);

      $weatherdata[cicon] = $weather[cicon];

      $weatherdata[wind_dir] = $weather[wind_dir];

      $weatherdata[wind_spd] = convert_speed($weather[wind_spd],$usersettings[tps]);

      $weatherdata[barometer] = convert_press($weather[barometer],$usersettings[tps]);

      $weatherdata[humidity] = $weather[humidity];

      $weatherdata[realfeel] = convert_temp($weather[realfeel],$usersettings[tpc]);

      $weatherdata[lastup] = $weather[lastup];

      $weatherdata[context] = $weather[context];



      fclose($rawdata);

    }

  } else {

    $weatherdata = $DB_site->query_first("SELECT city,subdiv,country,temp,cicon,wind_dir,wind_spd,barometer,humidity,realfeel,lastup,context FROM weather_userdata WHERE userid=$bbuserinfo[userid]");

  }



  if ($weatherdata[subdiv]) {

    $weatherdata[showsubdiv] = "$weatherdata[subdiv], ";

  } else {

    $weatherdata[showsubdiv] = "";

  }



  $time_lastup = strtotime($weatherdata[lastup]);

  $weather[updatedate] = vbdate($dateformat,$time_lastup);

  $weather[updatetime] = vbdate($timeformat,$time_lastup);



  eval("\$currentweather = \"".gettemplate("home_weather")."\";");

}

Create new template "home_weather":

PHP Code:


		
			
<tr>

    <td width="165" bgcolor="{tablebordercolor}" >

    <table width="100%" border="0" cellspacing="1" cellpadding="3">

    <tr>

        <td valign="top" bgcolor="{tableheadbgcolor}" align="center"><normalfont><font color="{categoryfontcolor}"><b>Weather</b></font></normalfont></td>

    </tr>

    <tr>

        <td bgcolor="{firstaltcolor}" align="center">

        <table bgcolor="{tablebordercolor}" border="0" cellpadding="4" cellspacing="1" width="100%" align="center">

        <tr bgcolor="{categorybackcolor}">

            <td align="center"><smallfont>$weatherdata[city]</smallfont></td>

        </tr>

        <tr bgcolor="{firstaltcolor}">

            <td align="center"><smallfont><img src="{imagesfolder}/weather/$iconset/$weatherdata[cicon].gif" border="0" alt="$weatherdata[context]"><br>$weatherdata[context]</smallfont></td>

        </tr>

        <tr bgcolor="{secondaltcolor}">

            <td align="center"><smallfont>Temperature:</smallfont><br><normalfont><b>$weatherdata[temp]</b></normalfont><br><smallfont>(Real Feel: <b>$weatherdata[realfeel]</b>)</smallfont></td>

        </tr>

        <tr bgcolor="{firstaltcolor}">

            <td align="center"><smallfont><a href="weather.php?s=$session[sessionhash]&action=getdata">Detailed Forecast</a><br><a href="weather.php?s=$session[sessionhash]&action=modifysettings">Change Settings</a></smallfont></td>

        </tr>

        </table>

        </td>

    </tr>

    </table>

    </td>

</tr>

Open template "home_left" or "home_right" and add $currentweather (whatever want you put it)

Gohan, those are your microstats:
"Page generated in 0.80156398 seconds (90.45% PHP - 9.55% MySQL) with 71 queries."
you could say goodbye to your server... the way it is now your page. over 40queries can bring easy to it's knees the server.
i hope you dont have a busy site, orelse you will have your account cancelled in no time by your host...

Page generated in 0.80983102 seconds (90.22% PHP - 9.78% MySQL) with 72 queries.
[Debug Mode OFF] [PHP v4.2.2] [GZIP disabled] [Server Load: 0.00 » 0.01 : 0.00]

so bad for server??
just no problem cus so fast server without lag.

Gohan,

Thanks for that ! :)

I have made one or 2 changes to the template "home_weather":
making it abit more generic.

PHP Code:


		
			
<tr>

    <td width="165" bgcolor="#8080A6">

    <table bgcolor="#8080A6" width="100%" border="0" cellspacing="1" cellpadding="3">

    <tr>

        <td bgcolor="#8080A6" valign="top" align="center"><normalfont><b>Weather</b></normalfont></td>

    </tr>

    <tr>

        <td bgcolor="#8080A6" align="center">

        <table bgcolor="#8080A6" border="0" cellpadding="4" cellspacing="1" width="100%" align="center">

        <tr>

            <td bgcolor="#8080A6" align="center"><smallfont>$weatherdata[city]</smallfont></td>

        </tr>

        <tr>

            <td align="center"><smallfont><img src="https://vborg.vbsupport.ru/vbimages/weather/$iconset/$weatherdata[cicon].gif" border="0" alt="$weatherdata[context]"><br>$weatherdata[context]</smallfont></td>

        </tr>

        <tr>

            <td align="center"><smallfont>Temperature:</smallfont><br><normalfont><b>$weatherdata[temp]</b></normalfont><br><smallfont>(Real Feel: <b>$weatherdata[realfeel]</b> )</smallfont></td>

        </tr>

        <tr>

            <td align="center"><smallfont><a href="weather.php?s=$session[sessionhash]&action=getdata">Detailed Forecast</a><br><a href="weather.php?s=$session[sessionhash]&action=modifysettings">Change Settings</a></smallfont></td>

        </tr>

        </table>

        </td>

    </tr>

    </table>

    </td>

</tr>

Thanks again.

LeMarsu

how bizzar.

the code : bgcolor = "{ tableheadbgcolor } "

gets changed to bgcolor="#8080A6" even in [ code ] or [ php ]

:|

Quote:

Originally posted by Gohan
Page generated in 0.80983102 seconds (90.22% PHP - 9.78% MySQL) with 72 queries.
[Debug Mode OFF] [PHP v4.2.2] [GZIP disabled] [Server Load: 0.00 ? 0.01 : 0.00]

so bad for server??
just no problem cus so fast server without lag.

TECK is right (as usual ;) ) - it's BAD for your server. What hacks do you have installed? Take them out. Get it to below 30.

Quote:

Originally posted by Erwin
TECK is right (as usual ;) ) - it's BAD for your server. What hacks do you have installed? Take them out. Get it to below 30.

Gohan, I strongly recomend that you either reduce the number of news posts & active threads and/or remove some of the addons to that page 71 for the sites home page is very, very, very high.

Quote:

Originally posted by NTLDR

Gohan, I strongly recomend that you either reduce the number of news posts & active threads and/or remove some of the addons to that page 71 for the sites home page is very, very, very high.

Hmm.. but my server get every day around 10 users visitor.
i think better remove a weather and calendar hack from vbindex.

Quote:

quote:

Quote:

Originally posted by PsYc
Database error in vBulletin 2.2.7:

Invalid SQL: SELECT accid,city_title FROM weather_city WHERE subdivid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

$cities = $DB_site->query("SELECT accid,city_title FROM weather_city WHERE subdivid=$current_subdiv[subdivid] ORDER BY city_title");

i think this query seems to complicate it..

i have created all tables and made the changes, i run it 4 times deleted it and made a fresh install... everytime i got this error, can anyone help?

--------------------------------------------------------
edit: ok fixed my errors, works great

* PsYc clicks install

same as my problem.. what did you fix?

Hello, nobody know fixed??

Quote:

Originally posted by Gohan
Hello, nobody know fixed??

ok then.. i'll remove this hack!!! :( :tired: :dead:

Quote:

Originally posted by PHiXTiT
Great hack! (5)

Only 2 problems.

1) The time is 40 minutes in the future.

2) There are no subdivisions in Canada such as Alberta, Ontario, etc, but all the cities are listed. All others are working for me.

BTW: Just wondering if you are planning on adding the option for users to select different .gif files when modifying settings?

Running on 2.2.7

Anyone?

Have they blocked the data again?? It is not working on my site today.....

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01603 seconds Memory Usage 1,968KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (14)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: