Quote:
Originally Posted by PsyGaming
Someone can fix the problem with sourcebans when you ban someone and he appears with "Name not available"?[in sourcebans]
|
A page or two back, someone posted a link that leads to this post here.
Quote:
Originally Posted by Groger
Open /pages/page.banlist.php
Find (line 385):
PHP Code:
$data['ban_date'] = SBDate($dateformat,$res->fields['ban_created']);
Before add
PHP Code:
if('' == stripslashes($res->fields['player_name']) && $nameschecked < 3) {
$new_name = GetCommunityName($res->fields['authid']);
if('' == $new_name) {
$new_name = 'Name not available';
} else {
$new_name = addslashes($new_name);
}
$GLOBALS['db']->Execute("UPDATE ".DB_PREFIX."_bans SET
name='" . $new_name . "'
WHERE bid='" . $res->fields['ban_id'] . "'
LIMIT 1");
if(!$nameschecked) {
$nameschecked = 0;
} else {
$nameschecked++;
}
$data['player'] =stripslashes($new_name);
} else {
$data['player'] = stripslashes($res->fields['player_name']);
}
Find (line 386) and remove it:
PHP Code:
$data['player'] = stripslashes($res->fields['player_name']);
Credits go to Peacemaker
http://forums.interwavestudios.com/t...h__1#entry2510 |
Now I wasn't sure what this meant at first but my admin friend Neptune used that code and it worked for us. I didnt find the above explanation all that great, not to mention the part at the end where it says to remove the line, that line was slightly different in my current copy of SB.
Bottom line is this. If you use SourceBans, you can fix the "Name not available" problem by editing one of your SourceBan pages; specifically ...<your sourcebans folder>/pages/page.banlist.php as mentioned in the post above.
Find the line
PHP Code:
$data['player'] = stripslashes($res->fields['player_name']);
which for me in my version of SB was actually
PHP Code:
$data['player'] = addslashes($res->fields['player_name']);
also, this was line 800 something. no where near 380.
Anyways, delete that line and replace it with the code i quoted above. ie, This code.
Code:
if('' == stripslashes($res->fields['player_name']) && $nameschecked < 3) {
$new_name = GetCommunityName($res->fields['authid']);
if('' == $new_name) {
$new_name = 'Name not available';
} else {
$new_name = addslashes($new_name);
}
$GLOBALS['db']->Execute("UPDATE ".DB_PREFIX."_bans SET
name='" . $new_name . "'
WHERE bid='" . $res->fields['ban_id'] . "'
LIMIT 1");
if(!$nameschecked) {
$nameschecked = 0;
} else {
$nameschecked++;
}
$data['player'] =stripslashes($new_name);
} else {
$data['player'] = addslashes($res->fields['player_name']);
}
Note:
on my version here i changed the last line to addslashes rather then stripslashes to match SB tho it prolly works the other way as well..
Also, that first line $data['ban_date'] = SBDate($dateformat,$res->fields['ban_created']); might have to go after that code block, not sure. If it doesnt work one way, swap it and it'll work the other way. Thats it, voila!
What the code does is it uses the steamID from the ban, to get the persons name from steam using the GetCommunityName function. Basically. Like I said I don't understand this stuff the best. Anyways, it doesnt just fix future bans, it actually attempts to fix all your existing bans where the name is "Name not available" or whatever.
Anyways, Hats off to the coder, & thanx to the original guy who pointed out the link in the first place. I'm just trying to explain it in a simpler manner for people like me who need a bit more of an explanation
Linear Mode
