Character Market for Gesior

Discussion in 'The Graveyard' started by Stellow, Jun 22, 2016.

  1. Stellow

    Stellow C++/C#/PHP/LUA

    Joined:
    Oct 23, 2008
    Messages:
    1,006
    Likes Received:
    120
    Best Answers:
    0
    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

    [​IMG]

    SQL:
    Code (Text):
    1. CREATE TABLE IF NOT EXISTS `sellchar_history` (
    2. `id` int(11) NOT NULL,
    3.   `name` varchar(50) NOT NULL,
    4.   `seller` int(11) NOT NULL,
    5.   `buyer` int(11) NOT NULL,
    6.   `price` int(11) NOT NULL
    7. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
    8.  
    9.  
    10. ALTER TABLE `sellchar_history`
    11. ADD PRIMARY KEY (`id`);
    12.  
    13.  
    14. ALTER TABLE `sellchar_history`
    15. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
    SQL 2:
    Code (Text):
    1. CREATE TABLE IF NOT EXISTS `sellchar` (
    2. `id` int(11) NOT NULL,
    3.   `name` varchar(40) NOT NULL,
    4.   `vocation` int(11) NOT NULL,
    5.   `price` int(11) NOT NULL,
    6.   `status` varchar(40) NOT NULL,
    7.   `oldid` varchar(40) NOT NULL
    8. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
    9.  
    10.  
    11. ALTER TABLE `sellchar`
    12. ADD PRIMARY KEY (`id`);
    13.  
    14.  
    15. ALTER TABLE `sellchar`
    16. MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1;
    PHPFILE:
    https://www.dropbox.com/s/unan0x215vp4bu3/characterauction.php?dl=0
     
    bok, pierroth, Oldtibia.eu and 3 others like this.
  2. darcisantos

    darcisantos New Member

    Joined:
    Jun 16, 2011
    Messages:
    3
    Likes Received:
    0
    Best Answers:
    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
     
  3. Stellow

    Stellow C++/C#/PHP/LUA

    Joined:
    Oct 23, 2008
    Messages:
    1,006
    Likes Received:
    120
    Best Answers:
    0
    What Gesior Version do you use?
     
  4. darcisantos

    darcisantos New Member

    Joined:
    Jun 16, 2011
    Messages:
    3
    Likes Received:
    0
    Best Answers:
    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 ?
     
  5. Stellow

    Stellow C++/C#/PHP/LUA

    Joined:
    Oct 23, 2008
    Messages:
    1,006
    Likes Received:
    120
    Best Answers:
    0
    Do you have folder 'Classes' on your website? If not, let me know, and I will substitude those functions for you.
     
  6. darcisantos

    darcisantos New Member

    Joined:
    Jun 16, 2011
    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    do not have this class folder on my server will wait thank you
     
  7. HeberPcL

    HeberPcL [PowerOT.com.br]

    Joined:
    Aug 21, 2007
    Messages:
    1,279
    Likes Received:
    41
    Best Answers:
    0
    Nice!
     
  8. mameca123

    mameca123 www.TheHeroesOfTime.com

    Joined:
    Nov 19, 2008
    Messages:
    20
    Likes Received:
    0
    Best Answers:
    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!
     
  9. Zak.Tibiam

    Zak.Tibiam Member

    Joined:
    Mar 25, 2012
    Messages:
    125
    Likes Received:
    2
    Best Answers:
    0
  10. Shadow Dan

    Shadow Dan Sh4dowDan

    Joined:
    Jun 5, 2010
    Messages:
    336
    Likes Received:
    76
    Best Answers:
    0
    Thank you!
     
  11. Oualid

    Oualid Active Member

    Joined:
    Aug 24, 2014
    Messages:
    318
    Likes Received:
    42
    Best Answers:
    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.
     
  12. Stellow

    Stellow C++/C#/PHP/LUA

    Joined:
    Oct 23, 2008
    Messages:
    1,006
    Likes Received:
    120
    Best Answers:
    0
    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.
     
  13. pierroth

    pierroth Mar Co.

    Joined:
    Sep 11, 2008
    Messages:
    344
    Likes Received:
    9
    Best Answers:
    0
    what happened here? xD

    [​IMG]

    How do you do that? Where do I change null 9?
     
  14. Stellow

    Stellow C++/C#/PHP/LUA

    Joined:
    Oct 23, 2008
    Messages:
    1,006
    Likes Received:
    120
    Best Answers:
    0
    On the php file, /3-
    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.
     
  15. Romenes Hasvu

    Romenes Hasvu Banned User

    Joined:
    Nov 20, 2015
    Messages:
    300
    Likes Received:
    12
    Best Answers:
    0
    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.
     
  16. Pabox Cavieres

    Pabox Cavieres Dovux Online owner

    Joined:
    May 12, 2008
    Messages:
    572
    Likes Received:
    9
    Best Answers:
    0
    looool big bug hahaha xD please fix script!
     
  17. Pabox Cavieres

    Pabox Cavieres Dovux Online owner

    Joined:
    May 12, 2008
    Messages:
    572
    Likes Received:
    9
    Best Answers:
    0
    where i can see the "history log"?
     
  18. bok

    bok Member

    Joined:
    Apr 28, 2009
    Messages:
    322
    Likes Received:
    4
    Best Answers:
    0
    Re-host please.
     
  19. Aklayos

    Aklayos Member

    Joined:
    Aug 2, 2016
    Messages:
    62
    Likes Received:
    2
    Best Answers:
    0
    Re-host please.
     
  20. igorlabanca

    igorlabanca New Member

    Joined:
    Aug 15, 2010
    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Re-host please.
     

Share This Page

Loading...