// Névváltoztató
//============================================================
 
prontera,157,182,3  script  Névváltoztató    954,{
 
 
// ============ NPC NEVE ====================
set .@npcname$,"[ ^002f77Névváltoztató^000000 ]";
 
// ============ DATA SCRIPT ===================
if(countitem (7539) >= 50) {
mes .@npcname$;
mes "Meg szeretnéd változtatni a neved? Ötven ^FF0000Poring Coin^000000 kell hozzá!";
next;
menu "Nosza!",L_Nevvalt,"Nem, köszi",L_Kilepes1;
 
L_Kilepes1:
mes .@npcname$;
mes "Akkor később!";
close;
 
L_Nevvalt:
mes .@npcname$;
mes "^FF0000Be sure to leave your guild, party, and remove any friends you may have BEFORE you change your name!^000000";
mes "Please enter the name you wish:";
input @newname$;
set @aid, @newname$;
query_sql "SELECT `account_id` FROM `char` WHERE `name` = '"+escape_sql(@newname$)+"'", @aid;
if(!@aid) goto available;
next;
mes .@npcname$;
mes "The character name ^ff0000"+@newname$+"^000000 is already used.";
close;
end;
 
available:
next;
mes .@npcname$;
mes "Character name ^0000ff"+@newname$+"^000000 is available.";
next;
mes .@npcname$;
mes "Do you still want to continue?";
mes "";
mes "^ff0000- We will kick you first and automatically log you out.^000000";
mes "^ff0000- Then just login again and your character name will be automatically changed.^000000";
menu "No",-,"Yes",okcont;
 
dontcont:
close;
end;
 
okcont:
next;
mes .@npcname$;
mes "Your name ^ff0000"+strcharinfo(0)+"^000000 has changed into ^ff0000"+@newname$+"^000000.";
delitem 7539,50;
close2;
query_sql "UPDATE `char` SET name = '"+@newname$+"' WHERE char_id = " + getcharid(0) + ";";
 
atcommand strcharinfo(0)+ "@kick "+strcharinfo(0)+"";
end;
}
else {
mes .@npcname$;
mes "Ötven coin vagy nincs névváltás.";
close;
end;
}
}
 
select charname;
from  charc;
where SET'rename'= 'rename'+ "+@x+" where char_id' = "+getcharid(0)""(Select Charname
From char 
where set 'rename'= 'rename'+ "+@x+"where guildmember_id" ='"getcharid(0)+""(select charname
from char
where SET 'rename'=rename'+ "+@x+"where firend_id"='"getcharid(0)+"";
 
//<20:54:55> "Reva": de
//<20:54:58> "Reva": a táblákat
//<20:54:59> "Reva": kéne
//<20:55:08> "Reva": elenörizni mert fejből nem vágom de a lekéredzés tuti ez