• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Character Market for Gesior

Stellow

C++/C#/PHP/LUA
Joined
Oct 23, 2008
Messages
1,106
Reaction score
214
Location
Germany
GitHub
eubrunomiguel
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

characterauction.png


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
 
small error after put the price of the player

Fatal error: Class 'Player' not found in C:\xampp\htdocs\characterauction.php on line 25
 
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 ?
 
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!
 
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

characterauction.png


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.
 
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.
 
On the php file, /3-
what happened here? xD

screenshot_53.png




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.
 
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.
 
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

characterauction.png


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"?
 
Back
Top