prontera,96,182,4	script	Aura Changer	485,{

mes "Hello "+strcharinfo(0)+"!";
mes "Do you want to change your bought aura?";
mes "View a list of available?";
query_sql "SELECT `partid`,`auraid` FROM `auratable` WHERE `charid`='"+getcharid(0)+"'",.@partid,.@auraid;
next;
mes "You have part:^0055FF"+.@partid+"^000000 and aura ^0055FF"+.@auraid+"^000000";
    close;	
}