VB World Weather

This is VB World Weather...

It allow your users to look up and display local weather for 39,722 locations around the world! It is template based with multi language support built in!


The zip file contains...

1. Step by step install files
2. All images, language files, templates, weather database file and scripts

Demo

http://forum.ya-right.com/

user: test
pass: test

when you login go to the usercp to try the demo, also look at the bottom of the forum home for the other display...

The one on the forum home can be placed where ever you want to place it!

If you have any questions or need install help post your questions here...

UPDATES (7/15/2004 9:47 PM EDT)

Go here for the FORUMHOME template update install info

https://vborg.vbsupport.ru/showthrea...d=1#post533325

UPDATES (7/18/2004 9:04 AM EDT)

Add a database install table script, for people who can not run
the single sql file (FOUND IN STEP 7). It is very easy to use!


Have a great day....

Sonia


_______________________________
Next mod -> translate this topic or post!

[MooMan65]

Hmm. After waiting for about half an hour on my 56k modem to apply the Database changes I get an error with the first damn query when it tried to create the forecast table:

CREATE TABLE forecast(

id int( 4 ) NOT NULL AUTO_INCREMENT ,
rid char( 2 ) default NULL ,
region varchar( 15 ) default NULL ,
cid char( 2 ) default NULL ,
country varchar( 33 ) default NULL ,
sid char( 2 ) NOT NULL default '',
state varchar( 20 ) default NULL ,
pid varchar( 5 ) NOT NULL default '',
place varchar( 120 ) default NULL ,
code varchar( 8 ) default NULL ,
PRIMARY KEY ( id ) ,
KEY forecast_rid_cid_sid_pid( rid, cid, sid, pid ) 
)ENGINE = MYISAM DEFAULT CHARSET = latin1

#1064 - 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 'DEFAULT CHARSET = latin1' at line 12

I'm pretty sure it's because my PHP version is too old, which is a shame as this isn't my server so I don't have a choice as to upgrading the version. But this is a great hack though! Thanks!

[romanticyao]

can someone please tell me how do i install the weather table using command line? :nervous:

[why-not]

Originally Posted by MooMan65

Hmm. After waiting for about half an hour on my 56k modem to apply the Database changes I get an error with the first damn query when it tried to create the forecast table:

CREATE TABLE forecast(

id int( 4 ) NOT NULL AUTO_INCREMENT ,
rid char( 2 ) default NULL ,
region varchar( 15 ) default NULL ,
cid char( 2 ) default NULL ,
country varchar( 33 ) default NULL ,
sid char( 2 ) NOT NULL default '',
state varchar( 20 ) default NULL ,
pid varchar( 5 ) NOT NULL default '',
place varchar( 120 ) default NULL ,
code varchar( 8 ) default NULL ,
PRIMARY KEY ( id ) ,
KEY forecast_rid_cid_sid_pid( rid, cid, sid, pid ) 
)ENGINE = MYISAM DEFAULT CHARSET = latin1

#1064 - 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 'DEFAULT CHARSET = latin1' at line 12

I'm pretty sure it's because my PHP version is too old, which is a shame as this isn't my server so I don't have a choice as to upgrading the version. But this is a great hack though! Thanks!

Hi MooMan 65

Just remove that line.....

As it is the default chr/set anyways! It will cause problems with some mysql managers! Like in MyPHPAdmin, if you use browse and upload having the charset is ok, but if you try to run the create in the query text box you will get the same error you got!

change to.....

DROP TABLE IF EXISTS forecast;
CREATE TABLE forecast (
  id int(4) NOT NULL auto_increment,
  rid char(2) default NULL,
  region varchar(15) default NULL,
  cid char(2) default NULL,
  country varchar(33) default NULL,
  sid char(2) NOT NULL default '',
  state varchar(20) default NULL,
  pid varchar(5) NOT NULL default '',
  place varchar(120) default NULL,
  code varchar(8) default NULL,
  PRIMARY KEY  (id),
  KEY forecast_rid_cid_sid_pid (rid,cid,sid,pid)
);

Sonia

[ambrosious]

Question, what will happen if I install this and have already messed with the profile.php and functions_user.php while installing another hack. I'm pretty sure I've messed these around some.

Can I not add this?

[why-not]

Originally Posted by Zombie

Yeah, me to

I'm using vBadvanced's weather module right now and this will be a much better replacement

Hi

This was done, because I want everyone to first install the core system. Adding it to any page after the core system is installed is easy! I don't know why you said the example on my demo site was not working, because it is!


Maybe someone switched it off when you were trying it!


HINT!!!!!

Look under the "WHOS ON LINE"


This will be released tomorrow, along with transparent images using (2) sizes, (1) for the CP, the other for the FORUMHOME and Members Profile page. The templates are easy to make, so you can design any type of display you want, using 60 different forecast array values! I will include 2 templates based on the USERCP template, which is CSS controled, so making it look the way you want is as easy as creating (2) images (gradients) and changing the colors you want to use!


Sonia

[why-not]

Originally Posted by ambrosious

Question, what will happen if I install this and have already messed with the profile.php and functions_user.php while installing another hack. I'm pretty sure I've messed these around some.

Can I not add this?

Hi


If you tell what you installed, better yet give your 'profile.php, functions_user.php', and I can write a work around for whatever you have installed that might get in the way of this system!


Sonia

[MooMan65]

Thanks Sonia I got it working now, well, I think so. I already had existing custom profile fields like a number of people here so it's not working correctly at the moment. Where abouts would I need to edit in the files so I can change the profile field ids manually?

[romanticyao]

hi can you please show me how to install the .sql file? i tried with phpmyadmin but the filesize was too big. so if you could show me how to do it with command line would be great, thank you in advance

[why-not]

Originally Posted by kall

*nods*

The concept is excellent, but the install is a bit of a killer, mainly for those people who already have custom fields installed.



I have installed it, but the Location Field is a single-line text box...with no hints as to what the code to put in it is.

Hi

If you already have custom fields installed, this is not a problem! You just have to update the array that validates the custom fields for the weather system. I am writing a very simple 'HOW TO' with images that show you how to do this! Once the system is installed this takes less than 30 seconds to fix or change if you add more fields later!


Sonia

[ambrosious]

Originally Posted by why-not

Hi


If you tell what you installed, better yet give your 'profile.php, functions_user.php', and I can write a work around for whatever you have installed that might get in the way of this system!


Sonia

Will do shortly! Thanks!