vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   Reset Style for all users? (https://vborg.vbsupport.ru/showthread.php?t=44074)

Smoothie 03-22-2003 06:35 PM
Quote:
Yesterday at 03:22 PM yzztik said this in Post #5
What if I deleted some styles but the database still says they are using that styleid even though it does not exist. It shows up in the what styles they are using as blank even though I think it automatically selects the next one for them.

What if I want to run a query to change every user in the db who has styleid x to styleid y?
I have the same problem, but how would you know what styles they were using if they were deleted?

yzztik 03-22-2003 06:53 PM
what I did was looked up the styleid for each of the remaining styles and note those down.

Then I used this hack [Who's Using Wich Style On One Page] to see which styles were being used and put the styleid number next to each of the ones that I knew. Since they are listed in numerical order, I then search the user table in phpmyadmin for the missing styles until I matched up each of the missing ones with a styleid. Then I ran the query to change those to the default.

Smoothie 03-22-2003 07:00 PM
Hell, too much work for me. I just updated all members to use styleid=1.

yzztik 03-22-2003 07:07 PM
I'd probably have a riot on my hands if I did that, so I took a bit of time to do this. It really didnt take that long. It was easier than it sounds.

Smoothie 03-22-2003 07:12 PM
Quote:
I'd probably have a riot on my hands if I did that
members on my board will get over it.


All times are GMT. The time now is 03:51 AM.
Page 2 of 2 1 2
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.01011 seconds
  • Memory Usage 1,722KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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