/*
 
 
CREATE TABLE IF NOT EXISTS `wishing_well` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `time` datetime NOT NULL default '0000-00-00 00:00:00',
    `char_id` int(11) NOT NULL default '0',
    `zeny` int(11) NOT NULL default '0',
    `nameid` int(11) unsigned NOT NULL default '0',
    `amount` int(11) unsigned NOT NULL default '0',
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM; 
 
 
*/
 
prontera,155,171,5  script  Wishing Well    757,{
mes "Throw zeny.";
input .@zeny,0,Zeny;
if( .@zeny ){
    mes "What item you wish ?";
    do{
        input .@itemid,0,32767;
        if( !.@itemid ) close;
    }while( getitemname( .@itemid ) == "null" );
    mes "Amount ?";
    input .@amount,0,30000;
    if( .@amount ){
        set Zeny,Zeny - .@zeny;
        mes "Zeny : "+.@zeny;
        mes "Wished "+.@amount+" x "+getitemname( .@itemid );
        if( select( "Confirm","Cancel" ) == 1 ){
            mes "You've wish to get "+getitemname( .@itemid );
            query_sql( "INSERT INTO `wishing_well` ( `time`,`char_id`,`zeny`,`nameid`,`amount` ) VALUES ( NOW(),"+getcharid(0)+","+.@zeny+","+.@itemid+","+.@amount+" )" );
        }
    }
}
close;
}