• 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

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:
Dropbox (https://www.dropbox.com/s/unan0x215vp4bu3/characterauction.php?dl=0)
LINK OFF
 
I guess this is not being re-uploaded, did anyone manage to download it before the link died?
 
Back
Top