Register Arama Bugünkü Mesajlar Mark Forums Read

Reply
 
Thread Tools
[vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes.
vB.Org Poster
vB.Org Poster has disabled reputation
Kayıt Tarihi: Jul 2018
Mesajlar: 298

Show Printable Version Email this Page
yazar 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.
Views: 14
Reply With Quote
Reply

Thread Tools

Şunları Yapabilirsin
Yeni Konu Açmak
Konuya Cevap Yazmak
Eklenti Eklemek
Düzenleme Yapabilmek

Forum Atla


New To Site? Need Help?

All times are GMT +3. The time now is 14:36.

Tasarım Özelliği | Genişlik: Geniş Renk: [vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes. [vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes. [vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes. [vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes. [vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes.