Requesting Auction!

Erba · February 2, 2013

Can someone make a script that when a player wants to vend something.. he will post it in an NPC then the item that the player wishes to be in auction will be deleted and be shown in the NPC.. then if someone wants to bid they will also post their bid item in that item and the bid item will be deleted to the player but will only get back the item if they cancel their bids or their trades..

then the seller will have to choose what offer to accept.. after the seller had chosen the player will get the item that the bidder had posted then the bidder will only get the item he bids for after he checked the npc

thanks!!

AnnieRuru · February 2, 2013

this is support section

you need 2 sql table for this

1 table is for auctioning

another table is the ID of the auction for the bidder's item

when player auction something, the auction table automatically generated, which is easy to do

the when players wants to buy a bid item, create another row for the 2nd table according to the ID of the auction

you need my getitemname2 function, how to write dynamic menu with getinventorylist, dynamic menu with sql table,

and more importantly, sendmail script command ... lol

nanakiwurtz · February 2, 2013

trunk\npc\other\auction.txt

Erba · February 2, 2013

nope.. it is only for zeny mam

nanakiwurtz · February 3, 2013

Oh so you want to trade an item for another item?

Erba · February 4, 2013

this is support section

you need 2 sql table for this

1 table is for auctioning

another table is the ID of the auction for the bidder's item

when player auction something, the auction table automatically generated, which is easy to do

the when players wants to buy a bid item, create another row for the 2nd table according to the ID of the auction

you need my getitemname2 function, how to write dynamic menu with getinventorylist, dynamic menu with sql table,

and more importantly, sendmail script command ... lol

Honestly i dont know how to do this XD

Can i request for this script mam AnnieRuru?XD

bump

AnnieRuru · February 6, 2013

/*
create table auction_item (
auction_id int(11) primary key auto_increment,
seller_id int(11),
seller_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify enum('0','1'),
refine tinyint(3),
attribute enum('0','1'),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_item;

create table auction_bidder (
id int(11) primary key auto_increment,
auction_id int(11),
buyer_id int(11),
buyer_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify enum('0','1'),
refine tinyint(3),
attribute enum('0','1'),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_bidder;
*/

prontera,155,186,5	script	kjsdhfksh	100,{
mes "aaa";
next;
if ( select( "list", "sell" ) == 1 ) {
	.@nb = query_sql( "select * from auction_item limit 128", .@id, .@cid, .@name$, .@time$, .@itemid, .@amount, .@identify, .@refine, .@attribute, .@card1, .@card2, .@card3, .@card4 );
	for ( .@i = 0; .@i < .@nb; .@i++ )
		mes .@time$[.@i] +" -> "+ .@amount[.@i] +"x "+ callfunc( "getitemname2", .@itemid[.@i], .@identify[.@i], .@refine[.@i], .@attribute[.@i], .@card1[.@i], .@card2[.@i], .@card3[.@i], .@card4[.@i] );
	close;
}
close2;
callshop "auction_item", 2;
end;
OnSellItem:
query_sql "insert into auction_item values ( null, "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', now(), "+ @sold_nameid +", "+ @sold_quantity +", "+ @sold_identify +", "+ @sold_refine +", "+ @sold_attribute +", "+ @sold_card1 +", "+ @sold_card2 +", "+ @sold_card3 +", "+ @sold_card4 +" )";
delitem2 @sold_nameid, @sold_quantity, @sold_identify, @sold_refine, @sold_attribute, @sold_card1, @sold_card2, @sold_card3, @sold_card4;
end;
OnInit:
npcshopattach "auction_item";
end;
}
-	shop	auction_item	-1,501:-1

I'm writing this script 1/2 way and suddenly realize I've made a half-ass work before already

http://www.eathena.ws/board/index.php?s=&showtopic=273365&view=findpost&p=1498394

@emistry, 2 years ago you not able to write, how about today ?

if you not able to write that ctf script, I can take over

Erba · February 6, 2013

/*
create table auction_item (
auction_id int(11) primary key auto_increment,
seller_id int(11),
seller_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify enum('0','1'),
refine tinyint(3),
attribute enum('0','1'),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_item;

create table auction_bidder (
id int(11) primary key auto_increment,
auction_id int(11),
buyer_id int(11),
buyer_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify enum('0','1'),
refine tinyint(3),
attribute enum('0','1'),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_bidder;
*/

prontera,155,186,5	script	kjsdhfksh	100,{
mes "aaa";
next;
if ( select( "list", "sell" ) == 1 ) {
	.@nb = query_sql( "select * from auction_item limit 128", .@id, .@cid, .@name$, .@time$, .@itemid, .@amount, .@identify, .@refine, .@attribute, .@card1, .@card2, .@card3, .@card4 );
	for ( .@i = 0; .@i < .@nb; .@i++ )
		mes .@time$[.@i] +" -> "+ .@amount[.@i] +"x "+ callfunc( "getitemname2", .@itemid[.@i], .@identify[.@i], .@refine[.@i], .@attribute[.@i], .@card1[.@i], .@card2[.@i], .@card3[.@i], .@card4[.@i] );
	close;
}
close2;
callshop "auction_item", 2;
end;
OnSellItem:
query_sql "insert into auction_item values ( null, "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', now(), "+ @sold_nameid +", "+ @sold_quantity +", "+ @sold_identify +", "+ @sold_refine +", "+ @sold_attribute +", "+ @sold_card1 +", "+ @sold_card2 +", "+ @sold_card3 +", "+ @sold_card4 +" )";
delitem2 @sold_nameid, @sold_quantity, @sold_identify, @sold_refine, @sold_attribute, @sold_card1, @sold_card2, @sold_card3, @sold_card4;
end;
OnInit:
npcshopattach "auction_item";
end;
}
-	shop	auction_item	-1,501:-1

I'm writing this script 1/2 way and suddenly realize I've made a half-ass work before already

http://www.eathena.w...dpost&p=1498394

@emistry, 2 years ago you not able to write, how about today ?

if you not able to write that ctf script, I can take over

thanks mam!!!!

/kis

ill gonna test it later.. and ill post for the update!! XD

: DB error - Data truncated for column 'identify' at row 1

[Debug]: at ..\src\map\script.c:14407 - insert into auction_item values ( null,150025, 'Perfection', now(), 25149, 1, 0, 0, 0, 0, 0, 0, 0 )

[Debug]: Source (NPC): kjsdhfksh at prontera (155,186)

[Error]: script:delitem2: failed to delete 1 items (AID=2000000 item_id=25149).

[Debug]: Source (NPC): kjsdhfksh at prontera (155,186)

[color=#880000]create table auction_item (

auction_id int(11) primary key auto_increment,

seller_id int(11),

seller_name varchar(23),

time datetime,

nameid smallint(6),

amount smallint(6),

identify enum('0','1'),

refine tinyint(3),

attribute enum('0','1'),

card0 smallint(6),

card1 smallint(6),

card2 smallint(6),

card3 smallint(6)

) engine = innodb;

drop table auction_item;

create table auction_bidder (

id int(11) primary key auto_increment,

auction_id int(11),

buyer_id int(11),

buyer_name varchar(23),

time datetime,

nameid smallint(6),

amount smallint(6),

identify enum('0','1'),

refine tinyint(3),

attribute enum('0','1'),

card0 smallint(6),

card1 smallint(6),

card2 smallint(6),

card3 smallint(6)

) engine = innodb;

drop table auction_bidder;[/color]

i remove the drop table in the end

caspa · February 6, 2013

error.......

/*
create table auction_item (
auction_id int(11) primary key auto_increment,
seller_id int(11),
seller_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify enum('0','1'),
refine tinyint(3),
attribute enum('0','1'),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_item;

create table auction_bidder (
id int(11) primary key auto_increment,
auction_id int(11),
buyer_id int(11),
buyer_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify enum('0','1'),
refine tinyint(3),
attribute enum('0','1'),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_bidder;
*/

prontera,155,186,5	script	kjsdhfksh	100,{
mes "aaa";
next;
if ( select( "list", "sell" ) == 1 ) {
	.@nb = query_sql( "select * from auction_item limit 128", .@id, .@cid, .@name$, .@time$, .@itemid, .@amount, .@identify, .@refine, .@attribute, .@card1, .@card2, .@card3, .@card4 );
	for ( .@i = 0; .@i < .@nb; .@i++ )
		mes .@time$[.@i] +" -> "+ .@amount[.@i] +"x "+ callfunc( "getitemname2", .@itemid[.@i], .@identify[.@i], .@refine[.@i], .@attribute[.@i], .@card1[.@i], .@card2[.@i], .@card3[.@i], .@card4[.@i] );
	close;
}
close2;
callshop "auction_item", 2;
end;
OnSellItem:
query_sql "insert into auction_item values ( null, "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', now(), "+ @sold_nameid +", "+ @sold_quantity +", "+ @sold_identify +", "+ @sold_refine +", "+ @sold_attribute +", "+ @sold_card1 +", "+ @sold_card2 +", "+ @sold_card3 +", "+ @sold_card4 +" )";
delitem2 @sold_nameid, @sold_quantity, @sold_identify, @sold_refine, @sold_attribute, @sold_card1, @sold_card2, @sold_card3, @sold_card4;
end;
OnInit:
npcshopattach "auction_item";
end;
}
-	shop	auction_item	-1,501:-1

I'm writing this script 1/2 way and suddenly realize I've made a half-ass work before already

http://www.eathena.w...dpost&p=1498394

@emistry, 2 years ago you not able to write, how about today ?

if you not able to write that ctf script, I can take over

BUMP................

Edited February 8, 2013 by caspa

Erba · February 10, 2013

bump

@bump

Capuche · March 7, 2013

/*

create table auction_item (

auction_id int(11) primary key auto_increment,

seller_id int(11),

seller_name varchar(23),

time datetime,

nameid smallint(6),

amount smallint(6),

identify tinyint(1),

refine tinyint(3),

attribute tinyint(1),

card0 smallint(6),

card1 smallint(6),

card2 smallint(6),

card3 smallint(6)

) engine = innodb;

drop table auction_item;

create table auction_bidder (

id int(11) primary key auto_increment,

auction_id int(11),

buyer_id int(11),

buyer_name varchar(23),

time datetime,

nameid smallint(6),

amount smallint(6),

identify tinyint(1),

refine tinyint(3),

attribute tinyint(1),

card0 smallint(6),

card1 smallint(6),

card2 smallint(6),

card3 smallint(6)

) engine = innodb;

drop table auction_bidder;

*/

prontera,155,186,5 script kjsdhfksh 100,{

mes "aaa";

next;

if ( select( "list", "sell" ) == 1 ) {

.@nb = query_sql( "select * from auction_item limit 128", .@id, .@cid, .@name$, .@time$, .@itemid, .@amount, .@identify, .@refine, .@attribute, .@card1, .@card2, .@card3, .@card4 );

for ( .@i = 0; .@i < .@nb; .@i++ )

mes .@time$[.@i] +" -> "+ .@amount[.@i] +"x "+ callfunc( "getitemname2", .@itemid[.@i], .@identify[.@i], .@refine[.@i], .@attribute[.@i], .@card1[.@i], .@card2[.@i], .@card3[.@i], .@card4[.@i] );

close;

}

close2;

callshop "auction_item", 2;

end;

OnSellItem:

for ( .@i = 0; .@i < getarraysize( @sold_nameid ); .@i++ ) {

query_sql "insert into auction_item values ( null, "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', now(), "+ @sold_nameid[.@i] +", "+ @sold_quantity[.@i] +", "+ @sold_identify[.@i] +", "+ @sold_refine[.@i] +", "+ @sold_attribute[.@i] +", "+ @sold_card1[.@i] +", "+ @sold_card2[.@i] +", "+ @sold_card3[.@i] +", "+ @sold_card4[.@i] +" )";

if( getiteminfo( @sold_nameid[.@i],2 ) == 4 || getiteminfo( @sold_nameid[.@i],2 ) == 5 )

delitem2 @sold_nameid[.@i], @sold_quantity[.@i], @sold_identify[.@i], @sold_refine[.@i], @sold_attribute[.@i], @sold_card1[.@i], @sold_card2[.@i], @sold_card3[.@i], @sold_card4[.@i];

else

delitem @sold_nameid[.@i], @sold_quantity[.@i];

}

end;

OnInit:

npcshopattach "auction_item";

end;

}

- shop auction_item -1,501:-1

none · April 22, 2013

Hello,

Thx for this script, but look like not work:

parse_line: expect command, missing function name or calling undeclared function

    43 : 	mes "aaa";
    44 : 	next;
    45 : 	if ( select( "list", "sell" ) == 1 ) {
*   46 : 		'.'@nb = query_sql( "select * from auction_item limit 128", .@id, .@cid, .@name$, .@time$, .@itemid, .@amount, .@identify, .@refine, .@attribute, .@card1, .@card2, .@card3, .@card4 );
    47 : 		for ( .@i = 0; .@i < .@nb; .@i++ )
    48 : 			mes .@time$[.@i] +" -> "+ .@amount[.@i] +"x "+ callfunc( "getitemname2", .@itemid[.@i], .@identify[.@i], .@refine[.@i], .@attribute[.@i], .@card1[.@i], .@card2[.@i], .@card3[.@i], .@card4[.@i] );
    49 : 		close;
    50 : 	}
    51 : 	close2;

I don't know why my auction system not work, and this script not work :/

Can you help me ?

Capuche · April 22, 2013

You don't use rathena.

Try this one :


/*
create table auction_item (
auction_id int(11) primary key auto_increment,
seller_id int(11),
seller_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify tinyint(1),
refine tinyint(3),
attribute tinyint(1),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_item;

create table auction_bidder (
id int(11) primary key auto_increment,
auction_id int(11),
buyer_id int(11),
buyer_name varchar(23),
time datetime,
nameid smallint(6),
amount smallint(6),
identify tinyint(1),
refine tinyint(3),
attribute tinyint(1),
card0 smallint(6),
card1 smallint(6),
card2 smallint(6),
card3 smallint(6)
) engine = innodb;
drop table auction_bidder;
*/

prontera,155,186,5	script	kjsdhfksh	100,{
	mes "aaa";
	next;
	if ( select( "list", "sell" ) == 1 ) {
		set .@nb, query_sql( "select * from auction_item limit 128", .@id, .@cid, .@name$, .@time$, .@itemid, .@amount, .@identify, .@refine, .@attribute, .@card1, .@card2, .@card3, .@card4 );
		for ( set .@i, 0; .@i < .@nb; set .@i, .@i +1 )
			mes .@time$[.@i] +" -> "+ .@amount[.@i] +"x "+ callfunc( "getitemname2", .@itemid[.@i], .@identify[.@i], .@refine[.@i], .@attribute[.@i], .@card1[.@i], .@card2[.@i], .@card3[.@i], .@card4[.@i] );
		close;
	}
	close2;
	callshop "auction_item", 2;
	end;
OnSellItem:
	for ( set .@i, 0; .@i < getarraysize( @sold_nameid ); set .@i, .@i +1 ) {
		query_sql "insert into auction_item values ( null, "+ getcharid(0) +", '"+ escape_sql( strcharinfo(0) ) +"', now(), "+ @sold_nameid[.@i] +", "+ @sold_quantity[.@i] +", "+ @sold_identify[.@i] +", "+ @sold_refine[.@i] +", "+ @sold_attribute[.@i] +", "+ @sold_card1[.@i] +", "+ @sold_card2[.@i] +", "+ @sold_card3[.@i] +", "+ @sold_card4[.@i] +" )";
		if( getiteminfo( @sold_nameid[.@i],2 ) == 4 || getiteminfo( @sold_nameid[.@i],2 ) == 5 )
			delitem2 @sold_nameid[.@i], @sold_quantity[.@i], @sold_identify[.@i], @sold_refine[.@i], @sold_attribute[.@i], @sold_card1[.@i], @sold_card2[.@i], @sold_card3[.@i], @sold_card4[.@i];
		else
			delitem @sold_nameid[.@i], @sold_quantity[.@i];
	}
	end;
OnInit:
	npcshopattach "auction_item";
	end;
}
-	shop	auction_item	-1,501:-1

EDIT: Forgot a coma

none · April 22, 2013

Hello,

Thx for your answer, i use a old Rathena version 15869.

Some error:

(04/22/2013 16:37:17) [ Warning ] : npc_scriptcont: failed npc_checknear test.

(04/22/2013 16:41:13) [ Error ] : script:callfunc: function not found! [getitemname2]

is auction work fine now with Rathena ?

Capuche · April 22, 2013

(04/22/2013 16:41:13) [ Error ] : script:callfunc: function not found! [getitemname2]

getitemname2 function is in this topic

I don't have the warning when I use this script, maybe it's on another npc ?

Sign In

Requesting Auction!

Question

Link to comment

Share on other sites

14 answers to this question

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Recently Browsing 0 members