[sanada] Gesior Acc Maker (ajudem Plz)

Olá!

Bem, eu inicialmente postei isso no Otland.net mas só um cara respondeu e eu não intendi muito bem o que ele disse...

~O problema~

O Gesior Account Maker para TFS 0.2 Mystic Spirit (pelo menos o meu) procura os personagens com a primeira letra maiúscula e as outras minúsculas (e o website diferencia maiúsculas e minúsculas), sendo assim se o nome de um jogador começar com 2 letras maiúsculas (GMs, CMs, GODs, etc) o website não irá encontrar o personagem e uma mensagem de erro aparecerá!

~A solução~

Ainda não descobri, vim aqui para isso! mas o Macroman (do Otland.net) tentou me dizer o que é para fazer, segue abaixo o post que ele deixou no meu tópico:

As I am not a fan of how gesior decided to build his AAC, I will not try to modify it, sorry mate. Although you could contact either him or someone else to do it for you. Just tell them to make both the post string and the db string into lowercase where it checks if it exists.

Obs: não consegui traduzir totalmente, mas acho que é mais ou menos isso:

Não sou fan de como o gesior decidiu construir o seu website, Eu não vou tentar modificar it, desculpe. Embora você possa entrar em contato com o gesior ou alguém que faça isso para você. Apenas diga para eles....<Não consegui mais traduzir>

Agradeço qualquer ajuda desde já e espero que todos que usem este website também ajudem a procurar soluções para este... (acho que posso chamar de bug).

Abraços,

Drax Skylon//

PS: MODERADORES! ME DISCULPEM SE VIOLEI ALGUMA REGRA DO FORUM QUANDO MENSIONEI O OTLAND.NET, CASO ISSO SEJA UMA VIOLAÇÃO POR FAVOR ME AVISE E EU IREI ALTERAR O TÓPICO O MAIS RÁPIDO POSSÍVEL.

Você pode postar o script de search character para mim tentar editar?

O cara da OTLand disse para transformar tudo em letras minúsculas antes de fazer a query.

E é isso mesmo...

Ta aqui cara!

<?PHP

$name = stripslashes(ucwords(strtolower(trim($_REQUEST['name']))));

if(empty($name)) {

$main_content .= 'Here you can get detailed information about a certain player on '.$config['server']['serverName'].'.<BR> <FORM ACTION="index.php?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';

}

else

{

if(check_name($name)) {

$player = $ots->createObject('Player');

$player->find($name);

if($player->isLoaded()) {

$account = $player->getAccount();

//check is premy account

if($account->getCustomField("premdays") == 0) {

$account_status = '<b><span class="red">Free Account</span></b>';

}

else

{

$account_status = '<b><span class="green">Premium Account</span></b>';

}

//set sex name

if($player->getSex() == 0)

$sex = 'female';

else

$sex = 'male';

$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Character Information</B></TD></TR>';

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=20%>Name:</TD><TD>'.$player->getName().'</TD></TR>';

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Sex:</TD><TD>'.$sex.'</TD></TR>';

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Profession:</TD><TD>'.$config_vocations[$player->getVocation()].'</TD></TR>';

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Level:</TD><TD>'.$player->getLevel().'</TD></TR>';

if($config['site']['show_mlvl'] == 1)

{

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Magic Level:</TD><TD>'.$player->getMagLevel().'</TD></TR>';

}

if(!empty($towns_list[$player->getTownId()]))

{

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Residence:</TD><TD>'.$towns_list[$player->getTownId()].'</TD></TR>';

}

$rank_of_player = $player->getRank();

if(!empty($rank_of_player))

{

$guild_name = $rank_of_player->getGuild()->getName();

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=20%>Guild membership:</TD><TD>'.$rank_of_player->getName().' of the <a href="index.php?subtopic=guilds&action=show&guild='.$guild_name.'">'.$guild_name.'</a></TD></TR>';

}

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$lastlogin = $player->getLastLogin();

if(empty($lastlogin))

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Last login:</TD><TD>Never logged in.</TD></TR>';

else

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Last login:</TD><TD>'.date("j F Y, g:i a", $lastlogin).'</TD></TR>';

if($config['site']['show_creationdate'] == 1)

{

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Created:</TD><TD>'.date("j F Y, g:i a", $player->getCustomField("created")).'</TD></TR>';

}

$comment = $player->getCustomField("comment");

$newlines = array("\r\n", "\n", "\r");

$comment_with_lines = str_replace($newlines, '<br />', $comment, $count);

if($count < 50)

$comment = $comment_with_lines;

if(!empty($comment))

{

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD VALIGN=top>Comment:</TD><TD>'.$comment.'</TD></TR>';

}

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Account Status:</TD><TD>'.$account_status.'</TD></TR></TABLE>';

//deaths list

$player_deaths = $SQL->query('SELECT * FROM player_deaths WHERE '.$player->getId().' = player_id ORDER BY time DESC');

$number_of_players_deaths = 0;

$dead_add_content .= '<br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Deaths</B></TD></TR>';

if(!empty($player_deaths)) {

$vowels = array("e", "y", "u", "i", "o", "a");

foreach($player_deaths as $dead) {

if(is_int($number_of_player_deaths / 2))

$bgcolor = $config['site']['darkborder'];

else

$bgcolor = $config['site']['lightborder'];

$number_of_player_deaths++;

$dead_add_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=30%>'.date("j M Y, H:i", $dead['time']).'</TD><TD>Killed at Level '.$dead['level'].' by ';

if($dead['is_player'] == 1)

$dead_add_content .= '<a href="index.php?subtopic=characters&name='.$dead['killed_by'].'"><b>'.$dead['killed_by'].'</b></a>';

else

{

if($dead['killed_by'] == "-1")

$dead_add_content .= "item or field";

else

{

if(in_array(substr(strtolower($dead['killed_by']), 0, 1), $vowels))

$dead_add_content .= "an ";

else

$dead_add_content .= "a ";

$dead_add_content .= $dead['killed_by'];

}

}

$dead_add_content .= '.</TD></TR>';

}

}

$dead_add_content .= '</TABLE>';

if($number_of_player_deaths > 0)

$main_content .= $dead_add_content;

if($player->getCustomField("hide_char") != 1) {

//account info

$main_content .= '<br><TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Account Information</B></TD></TR><TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Real name:</TD><TD>'.$account->getCustomField("rlname").'</TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=20%>Location:</TD><TD>'.$account->getCustomField("location").'</TD></TR><TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Created:</TD><TD>'.date("j F Y, g:i a", $account->getCustomField("created")).'</TD></TR></TABLE>';

//char list table

$main_content .= '<br><TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=4 CLASS=white><B>Characters</B></TD></TR>

<TR BGCOLOR='.$config['site']['darkborder'].'><TD><B>Name</B></TD><TD><B>Level</B></TD><TD><b>Status</b></TD><TD><B> </B></TD></TR>';

//for each player on account

$account_players = $account->getPlayersList();

$account_players->orderBy('name');

$player_number = 0;

foreach($account_players as $player_list)

{

if($player_list->getCustomField("hide_char") != 1)

{

$player_number++;

if(is_int($player_number / 2))

$bgcolor = $config['site']['darkborder'];

else

$bgcolor = $config['site']['lightborder'];

if($player_list->getCustomField("online") == 0)

$player_list_status = '<font color="red">Offline</font>';

else

$player_list_status = '<font color="green">Online</font>';

$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=72%><NOBR>'.$player_number.'. '.$player_list->getName().'</NOBR></TD><TD WIDTH=20%>'.$player_list->getLevel().' '.$config_vocations[$player_list->getVocation()].'</TD><TD WIDTH="8%"><b>'.$player_list_status.'</b></TD><TD><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><FORM ACTION="index.php?subtopic=characters" METHOD=post><TR><TD><INPUT TYPE=hidden NAME=name VALUE="'.$player_list->getName().'"><INPUT TYPE=image NAME="View '.$player_list->getName().'" ALT="View '.$player_list->getName().'" SRC="'.$layout_name.'/images/buttons/sbutton_view.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></FORM></TABLE></TD></TR>';

}

}

$main_content .= '</TABLE></TD><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD></TR></TABLE>';

//end of char list table

}

//show search form

$main_content .= '<BR><BR><FORM ACTION="index.php?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';

$main_content .= '</TABLE>';

}

else

{

$search_errors[] = 'Character <b>'.$name.'</b> does not exist.';

//gracz nie istnieje - komunikat

}

}

else

{

$search_errors[] = 'This name contains invalid letters. Please use only A-Z, a-z and space.';

//niepoprawne imie gracza

}

if(!empty($search_errors)) {

$main_content .= '<div class="SmallBox" > <div class="MessageContainer" > <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="ErrorMessage" > <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';

foreach($search_errors as $search_error)

$main_content .= '<li>'.$search_error;

$main_content .= '</div> <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> </div></div><br/>';

$main_content .= '<BR><FORM ACTION="index.php?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';

}

}

?>

Abraços,

Drax Skylon

Pelo que eu vi não tem nada de errado...

Esse site é feito com classes, e nelas podem estar o erro, só não vou editar agora, dá trabalho =/

Tenta entrar em contato com Gesior mesmo, ele já tem as manhas de editar pois ele que fez...

@Yunie

Não vou precisar!

um cara no otland mostrou onde podia estar o erro então eu editei e funcionou! veja:

na linha 2 existe isso:

$name = stripslashes(ucwords(strtolower(trim($_REQUEST['name']))));

basta substituir por isso:

$name = stripslashes(trim($_REQUEST['name']));

E o site irá procurar o nome como você digitar.

O Problema disso é que se um nome for "DrAx Skylon" e você procurar "Drax Skylon" ele não vai achar...ou seja você precisa escrever o nome como ele realmente é (com letras maiúsculas e minúsculas).

Agradeço a todos que viram o tópico e tentaram ajudar!

Dúvida Sanada,

Podem fechar!

Abraços,

Drax Skylon//

Dúvida Sanada,

Tópico Fechado!