vb.org Archive

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)

Gohan 09-10-2002 12:03 AM

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!

Gohan 09-10-2002 11:59 AM

Hello, someone can helped?

Gohan 09-11-2002 12:09 AM

*BUMP* :(

PHiXTiT 09-11-2002 03:35 PM

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

PsYc 09-11-2002 03:45 PM

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..

Gohan 09-11-2002 04:38 PM

Quote:

Originally posted by PsYc
cities1-5.sql
Hmm.. i havent it but well weather_city5.sql


EDIT: Doesnt working!!! :tired:

lemarsu 09-13-2002 07:25 AM

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

Gohan 09-13-2002 08:25 AM

Open vbindex.php and find:

PHP Code:

// left & right templates 

add ABOVE:
PHP Code:

if ($weatherpage!=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)

TECK 09-13-2002 08:48 AM

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...

Gohan 09-13-2002 08:53 AM

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.


All times are GMT. The time now is 01:20 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01457 seconds
  • Memory Usage 1,854KB
  • 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
  • (3)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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