vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Miscellaneous Hacks - [DBTech] Username Change v1 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=236980)

Amaury 11-17-2012 04:42 PM

An admin just checked. They're showing up there.

EDIT: Here's a screenshot he provided.

http://i101.photobucket.com/albums/m...a/Changes2.png

DragonByte Tech 11-17-2012 05:39 PM

Hmm... Can you check the userchangelog database table and see if the fieldname column is anything other than "username" (all lowercase) for the entries that are missing?

Fillip

Amaury 11-17-2012 05:42 PM

Quote:

Originally Posted by DragonByte Tech (Post 2381970)
Hmm... Can you check the userchangelog database table and see if the fieldname column is anything other than "username" (all lowercase) for the entries that are missing?


Fillip

Is that also done via the Admin CP?

DragonByte Tech 11-17-2012 05:52 PM

Via phpMyAdmin is the best bet, though it can be done via the AdminCP if the user has Execute SQL permissions from config.php :)


Fillip

Amaury 11-17-2012 05:56 PM

Quote:

Originally Posted by DragonByte Tech (Post 2381979)
Via phpMyAdmin is the best bet, though it can be done via the AdminCP if the user has Execute SQL permissions from config.php :)


Fillip

SQL executions are possible.

What would the execution be?

DragonByte Tech 11-17-2012 06:01 PM

If you're using a table prefix, you need to add it in front of the table name:

Code:

select fieldname from userchangelog where userid = x
Replacing X with the userid of a user that's got missing entries.


Fillip

Amaury 11-17-2012 06:08 PM

Quote:

Originally Posted by DragonByte Tech (Post 2381983)
If you're using a table prefix, you need to add it in front of the table name:

Code:

select fieldname from userchangelog where userid = x
Replacing X with the userid of a user that's got missing entries.


Fillip

Just so I pass along the correct information, am I understanding this right?

Admin CP -> Maintenance -> Execute SQL Query

In the Manual Query box, enter that code and replace the X with the user's ID -- for example, mine is 18.

DragonByte Tech 11-17-2012 06:18 PM

That's correct :)

Ideally it should return "username" in all lowercase over and over again for all the entries.


Fillip

Amaury 11-17-2012 06:23 PM

Quote:

Originally Posted by DragonByte Tech (Post 2381993)
That's correct :)

Ideally it should return "username" in all lowercase over and over again for all the entries.


Fillip

In that case, just exit the Admin CP, go back to the forum index, and carry on with your day, right? =P

If not, though, what should be done?

DragonByte Tech 11-17-2012 06:33 PM

If not then
Code:

update userchangelog set fieldname = 'username' where fieldname = 'x'
replacing X with whatever the result of the previous query was that is not "username" in all lowercase :)


Fillip


All times are GMT. The time now is 08:10 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.01364 seconds
  • Memory Usage 1,739KB
  • 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
  • (4)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