vb.org Archive
Page 35 of 41 « First 253334 35 3637 Last »
Show 40 post(s) from this thread on one page

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)

Etcher 04-06-2003 03:05 AM
Awsome, thank you...
That is a HUGE DB, that must have taken weeks to make, and less than 2 seconds to delete.... and that worked, and took 900,000+ out of the DB

Fantastic job though, great hack...




Quote:
Yesterday at 08:55 PM lemarsu said this in Post #339
[B]Etcher,

To delete everything that is not Canada I suggest you do the following:
As the biggest table is weather_city, just concentrate on that one. You will need to run the delete statement bellow that will get rid of 36721 rows, NOTE THIS WILL GET RID OF EVERY CITY IN THE WORLD APPART FROM CANADA the countries will still be there if you need them in the future.

[b]ps I have not tested the SQL
Code:
DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'CAXX%'

PennylessZ28 04-07-2003 02:58 PM
Quote:
04-04-03 at 09:55 PM lemarsu said this in Post #339
[B]Etcher,

To delete everything that is not Canada I suggest you do the following:
As the biggest table is weather_city, just concentrate on that one. You will need to run the delete statement bellow that will get rid of 36721 rows, NOTE THIS WILL GET RID OF EVERY CITY IN THE WORLD APPART FROM CANADA the countries will still be there if you need them in the future.

[b]ps I have not tested the SQL
Code:
DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'CAXX%'

What about everything but America, who cares about Canada! :)

drumsy 04-07-2003 04:20 PM
How would I add the type "Heavy Rain" to the board? It's coming up as Unknown Type on the board but I see it as Heavy Rain on MSNBC.

BTW, Installed, love it! :) Great fix by the other gentleman! :)

lemarsu 04-07-2003 05:09 PM
Quote:
Today at 04:58 PM HR3rdGen said this in Post #342
What about everything but America, who cares about Canada! :)
like So :
Code:
DELETE FROM `weather_city` WHERE `accid` NOT LIKE 'US%'

drumsy 04-07-2003 06:28 PM
Ok, now all of a sudden the "H O N D A - A C U R A . N E T Weather is provided by The Weather Channel and MSNBC " table is blacked out. It was fine before. I've changed nothing! What could have done this?

auz1111 04-08-2003 05:25 PM
lemarsu! lemarsu! you helped a lot. thanks!

drumsy 04-14-2003 02:41 PM
Quote:
04-07-03 at 03:22 PM drumsy said this in Post #345
Ok, now all of a sudden the "H O N D A - A C U R A . N E T Weather is provided by The Weather Channel and MSNBC " table is blacked out. It was fine before. I've changed nothing! What could have done this?

Anyone?

drumsy 04-16-2003 10:27 PM
Quote:
04-14-03 at 10:41 AM drumsy said this in Post #347
Anyone?

Help, and also it seems the weather data just took a vacation! :(

o0stephane0o 04-17-2003 12:37 AM
i´ve checked several sites and all of them are working, must be your server. That hack is very fussy and needs a server with a specific config, lok for another one or use your pc as a server. I use easyphp and it works perfect...

lemarsu 04-17-2003 06:58 AM
Quote:
04-07-03 at 07:28 PM drumsy said this in Post #345
Ok, now all of a sudden the "H O N D A - A C U R A . N E T Weather is provided by The Weather Channel and MSNBC " table is blacked out. It was fine before. I've changed nothing! What could have done this?

just had a look at : http://www.honda-acura.net/forums

Look like all is well can you give us more info ?
Like the country/town it is not working for ?

LeMarsu


All times are GMT. The time now is 12:47 PM.
Page 35 of 41 « First 253334 35 3637 Last »
Show 40 post(s) from this thread on one page

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.02411 seconds
  • Memory Usage 1,745KB
  • 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_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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