Account, Website, Script Lisanslarını Al Sat

İkinci el lisans ve hesapların alışverişinin olduğu e-ticaret platformudur.
http://forum.lisansdevir.com/showthread.php?t=379

[vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes.
By vB.Org Poster
10 Jul 2018 15:58

You gave someone a username change. Great, but his old username is still in all places where he was quoted in the past.

Run this query in AdminCP, replacing with actual usernames
Kod Blok Kilitli:      (Kayıt veya giriş yapmalısın)  
Engellenmiş, kayıtlı olmayan veya onay bekleyen kişiler kodlara erişemezler.



BUT: if there exists a apostrophe in the old username, the DB will think that's the end of the string and will kick a syntax error. Therefore where apostrophe exists in either username, double it, as such: ''

Example:
Kod Blok Kilitli:      (Kayıt veya giriş yapmalısın)  
Engellenmiş, kayıtlı olmayan veya onay bekleyen kişiler kodlara erişemezler.

Where old name was: Sammy's and new name is: Elliot.


You're welcome.:D


All times are GMT +3. The time now is 12:00.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.