Character Market for Gesior

Stellow

C++/C#/PHP/LUA
Joined
Oct 23, 2008
Messages
1,008
Reaction score
121
Location
United States
I have updated and implemented new features from the original buy/sell characters by @Raggaer

New features:
-Sell/Buy at the same page
-Purchase history log
-Option to remove offer
-Magic and Skills at the description



SQL:
Code:
CREATE TABLE IF NOT EXISTS `sellchar_history` (
`id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `seller` int(11) NOT NULL,
  `buyer` int(11) NOT NULL,
  `price` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


ALTER TABLE `sellchar_history`
ADD PRIMARY KEY (`id`);


ALTER TABLE `sellchar_history`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
SQL 2:
Code:
CREATE TABLE IF NOT EXISTS `sellchar` (
`id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `vocation` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `status` varchar(40) NOT NULL,
  `oldid` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;


ALTER TABLE `sellchar`
ADD PRIMARY KEY (`id`);


ALTER TABLE `sellchar`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
PHPFILE:
https://www.dropbox.com/s/unan0x215vp4bu3/characterauction.php?dl=0
 

darcisantos

New Member
Joined
Jun 16, 2011
Messages
3
Reaction score
0
small error after put the price of the player

Fatal error: Class 'Player' not found in C:\xampp\htdocs\characterauction.php on line 25
 

darcisantos

New Member
Joined
Jun 16, 2011
Messages
3
Reaction score
0
I'm not sure I have this version a much longer believe it is 0.3.8 would have somewhere for me actually see if this version is ?
 
OP
Stellow

Stellow

C++/C#/PHP/LUA
Joined
Oct 23, 2008
Messages
1,008
Reaction score
121
Location
United States
I'm not sure I have this version a much longer believe it is 0.3.8 would have somewhere for me actually see if this version is ?
Do you have folder 'Classes' on your website? If not, let me know, and I will substitude those functions for you.
 

mameca123

www.TheHeroesOfTime.com
Joined
Nov 19, 2008
Messages
20
Reaction score
0
Hello. I also don't have the folder Classes. Could you please change the object-oriented functions for me? I still use the older Gesior :(

Thanks!
 

oualid6496

Premium User
Premium User
Joined
Aug 24, 2014
Messages
340
Reaction score
51
Location
Dordrecht, The Netherlands
I have updated and implemented new features from the original buy/sell characters by @Raggaer

New features:
-Sell/Buy at the same page
-Purchase history log
-Option to remove offer
-Magic and Skills at the description



SQL:
Code:
CREATE TABLE IF NOT EXISTS `sellchar_history` (
`id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `seller` int(11) NOT NULL,
  `buyer` int(11) NOT NULL,
  `price` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


ALTER TABLE `sellchar_history`
ADD PRIMARY KEY (`id`);


ALTER TABLE `sellchar_history`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
SQL 2:
Code:
CREATE TABLE IF NOT EXISTS `sellchar` (
`id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `vocation` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `status` varchar(40) NOT NULL,
  `oldid` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;


ALTER TABLE `sellchar`
ADD PRIMARY KEY (`id`);


ALTER TABLE `sellchar`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
PHPFILE:
https://www.dropbox.com/s/unan0x215vp4bu3/characterauction.php?dl=0
Hey I was just testing this with gesior 2012 (tfs 1.2) and everything seems to work except that it says:
"By placing your character on sale, you will lose access to it until someone buys it, or the sale is removed."
but it's still possible to login into the char when you've placed it for sale.

Also is it possible to destroy like 10% of the premium points so that people won't abuse it and transfer chars for 1 premium point between accounts? And maybe make it like minimum 10 premium points so that the 10% will have effect.

And the last thing is maybe add a minimum level to sell a character to avoid people selling alot of level 1 characters and maybe add that the offer stays for X time so that the auction won't get alot of offers after a while.
 
OP
Stellow

Stellow

C++/C#/PHP/LUA
Joined
Oct 23, 2008
Messages
1,008
Reaction score
121
Location
United States
Hey I was just testing this with gesior 2012 (tfs 1.2) and everything seems to work except that it says:
"By placing your character on sale, you will lose access to it until someone buys it, or the sale is removed."
but it's still possible to login into the char when you've placed it for sale.

Also is it possible to destroy like 10% of the premium points so that people won't abuse it and transfer chars for 1 premium point between accounts? And maybe make it like minimum 10 premium points so that the 10% will have effect.

And the last thing is maybe add a minimum level to sell a character to avoid people selling alot of level 1 characters and maybe add that the offer stays for X time so that the auction won't get alot of offers after a while.
That's why you need to put the character on a null account, 9! Which no one will have access to log in the character.
 
OP
Stellow

Stellow

C++/C#/PHP/LUA
Joined
Oct 23, 2008
Messages
1,008
Reaction score
121
Location
United States
On the php file, /3-
what happened here? xD





How do you do that? Where do I change null 9?
In the php file, search for "setaccountid", it should appear a function with a number inside.Change it over there, to an account that nobody has access to it.
 

Romenes Hasvu

Banned User
Joined
Nov 20, 2015
Messages
300
Reaction score
12
many bugs, like: If player put for sell and another buy, the player who put on sale click on "remove" the other will lose points and characters.
other bug: Player can put like "-1000" points who bought this will win 1000 points.
 

Pabox Cavieres

Dovux Online owner
Joined
May 12, 2008
Messages
572
Reaction score
9
Location
Caracas/Venezuela
I have updated and implemented new features from the original buy/sell characters by @Raggaer

New features:
-Sell/Buy at the same page
-Purchase history log
-Option to remove offer
-Magic and Skills at the description



SQL:
Code:
CREATE TABLE IF NOT EXISTS `sellchar_history` (
`id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `seller` int(11) NOT NULL,
  `buyer` int(11) NOT NULL,
  `price` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


ALTER TABLE `sellchar_history`
ADD PRIMARY KEY (`id`);


ALTER TABLE `sellchar_history`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
SQL 2:
Code:
CREATE TABLE IF NOT EXISTS `sellchar` (
`id` int(11) NOT NULL,
  `name` varchar(40) NOT NULL,
  `vocation` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `status` varchar(40) NOT NULL,
  `oldid` varchar(40) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;


ALTER TABLE `sellchar`
ADD PRIMARY KEY (`id`);


ALTER TABLE `sellchar`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
PHPFILE:
https://www.dropbox.com/s/unan0x215vp4bu3/characterauction.php?dl=0
where i can see the "history log"?
 
Top