Topic: [Fixed] Bad auth_admin sql field on different channels
I gave aop my account kmc724 in ★ and check my DB but DB say "auth_admin__"..
My OS is ubuntu 12.04 and using apache2 ..
Why DB say "auth_admin__" ...
- HarpyWar
- Developer
- Offline
Re: [Fixed] Bad auth_admin sql field on different channels
This is wrong field, you can remove it.
See values in auth_operator and auth_admin.
Do not ask for support in PM.
+1 kmc724
Re: [Fixed] Bad auth_admin sql field on different channels
auth_admin__ Value is true.
and _ may say ★
This is true working in my server but it's not working on that field ..
- HarpyWar
- Developer
- Offline
Re: [Fixed] Bad auth_admin sql field on different channels
We do not understand what do you mean.
auth_admin__ is not properly field, I guess it may be created with /set command. Or you have modified your code to use it.
If your account is operator then auth_operator should be true. If your account has admin flag then auth_admin should be true.
Do not ask for support in PM.
5 15.01.2014 13:45 (edited by kmc724 15.01.2014 13:46)
Re: [Fixed] Bad auth_admin sql field on different channels
Sorry I was late..
That picture says that account have admin permission in ★ channel, d channel.
d is right said but ★ doesn't said on mysql server ..
Can you understand..?
- HarpyWar
- Developer
- Offline
Re: [Fixed] Bad auth_admin sql field on different channels
Ok, now I see that database fields are named by the corresponding channels. Thereby "auth_admin" field for a channel "★" should be "auth_admin_★". Isn't it?
Probably PvPGN cuts UTF symbols in field names before write to a db.
Do not ask for support in PM.
7 18.01.2014 17:45 (edited by kmc724 18.01.2014 17:47)
Re: [Fixed] Bad auth_admin sql field on different channels
Sorry to late..
Yes, you're right.
Is this problem can I solve ..?
I was trying change encoding db (latin->utf8) but it's not work..
- HarpyWar
- Developer
- Offline
Re: [Fixed] Bad auth_admin sql field on different channels
I can't create a channel with name "★" from any game client (sc, wc3). It always replaced to "?" when I do copy-paste.
How do I reproduce the bug step by step?
Do not ask for support in PM.
Re: [Fixed] Bad auth_admin sql field on different channels
You can create "★" channel using utf8towin (You write in your post.)
But I'm using Linux so I used iconv library.
I think, this problem is not encoding, because I tried PvPGN-199.r577 version (not custom) and this problem is same
("★" or "?" always say "auth_channel___")..
I'm sorry to using dirty English ..
- HarpyWar
- Developer
- Offline
Re: [Fixed] Bad auth_admin sql field on different channels
Test it with my changes in storage_sql.cpp (replace it)
Do not ask for support in PM.
Re: [Fixed] Bad auth_admin sql field on different channels
Oh... It does not work..
It same what DB say "auth_channel_____" T_T
- HarpyWar
- Developer
- Offline
Re: [Fixed] Bad auth_admin sql field on different channels
I tried with /op on a channel "?" on my account and there's a new field is created "auth_operator_?" in the database.
Can you confirm it?
Do not ask for support in PM.
Re: [Fixed] Bad auth_admin sql field on different channels
Oh.. I'm very sorry.. I was upload another storage_sql.cpp file..
That's work! You are a good skill!
Thank you, HarpyWar!
