Inactive [WEB/ECON] WebAuction - Website based item market [1597]

Discussion in 'Inactive/Unsupported Plugins' started by Exote, Aug 24, 2011.

  1. Offline

    Exote

    WebAuction - Website based item market [1597]

    Moving over to bukkitdev - New Project Page
     
    nicom1997, tom, andrewkm and 2 others like this.
  2. Offline

    andrewkm

    Awesome I will give this a full spin later tonight throughout the night and get it set up :) - Very excited for it :D
    By the way just something I remembered, if users dont have:
    • wa.use.withdraw.items (use mail box) - default: True
    • wa.use.withdraw.money (use withdraw sign) - default: True
    • wa.use.deposit.items (use deposit chest) - default: True
    • wa.use.deposit.money (use deposit sign) - default: True
    -They still do work for those users...
    Usually when a permissions plugin is detected the defaults get overrided and all equal false untill the perm is given... right (I think thats how it works)? The only way I could get users to not have those permissions at the moment is to negate them. Just wondering if this is how you meant to have things and mentioning it incase you dont know :p
     
  3. Offline

    Exote

    Yeah with superperms you can set a default value for all the permissions in the plugin.yml, so if nothing is said about that permission it just takes the default.

    Thanks why I wrote the default value next to each one :p
     
  4. Offline

    NotYetRated

    Any idea where to find these? Using tiny core linux, Lighttpd..
     
  5. Offline

    Diaz9943

    Bit of a bug..

    Whenever I try to sell 1 of something, I get the following error:
    "Quantity was not an integer."
     
  6. Offline

    Exote

    get a more recent zip :p
     
  7. Offline

    Diaz9943

    any changes that will breake mah stuff in it? xD

    Sure the "iConomy table name" is set to the exact table name? its case sensitive :)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 19, 2016
  8. Offline

    NotYetRated

    No errors in PHP error log..... Any other ideas?
     
  9. Offline

    Diaz9943

    is it saying "0$" or just "0"
     
  10. Offline

    andrewkm

    @Exote
    Before i try out the canbuy and cansell options tonight, just wondering how exactly it works if the server is offline yet the website market is accessible? - Wouldnt all users be able to normally buy/sell on it?
     
  11. Offline

    Exote

    When a player logs in (to the game) it checks their in game permissions and updates the database. So the website will use the player data taken from their last login.
     
  12. Offline

    andrewkm

    Ah thank you :) Was just curious :p
     
  13. Offline

    Exote

    And im curious if it even works how I am expecting it to :p Permissions always work very mysteriously in my experience :p Seems to be pure luck if i manage to set up my server perms properly :D
     
  14. Offline

    andrewkm

    I will definately be testing sometime in the middle of the night once i get a chance to mess with it during less traffic :D
     
  15. Offline

    NotYetRated

    ? Im sorry I do not follow....
     
  16. Offline

    Diaz9943

    You said it didnt display your users money... Where its supposed to say how much money they have, does it say "$0" or just "0"?
     
  17. Offline

    Exote

    Just uploaded a new jar. Was my guess at what was causing the problem, but would need to test more to be sure.
     
  18. Offline

    andrewkm

    @Exote
    -Updated webauction.jar
    Tried again, same issue, builders can indeed sell items, as well they are seen as admins in the webinterface.
     
  19. Offline

    Exote

    Could you check the database to see if their player values show that they should be allowed to build. Trying to work out if it is the plugin or the website.
     
  20. Offline

    NotYetRated

    Ahh haha I apologize. The error was fixed, the default name o f the iconomy table was set as "iConomy", whereas the default table created by iconomy is "iconomy" I had forgotten to change it.

    Ahh weird, I am admin on my web interface but do not have the cancel auction option available either. Also, still working on enabling PHP error logging. Once I get around to it I will let you know if anything comes up. For now, using 0.3.1.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 19, 2016
  21. Offline

    Exote

    If you want me to check it out, send me a URL and a login etc :)

    Cancel option got removed for a bit while testing other things. Is back now though. Download a new zip :)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 19, 2016
  22. Offline

    NotYetRated

    DOH disregard my previous PM then. Apologies, I hate to waste your time.
     
  23. Offline

    Exote

    Don't worry, Should have announced that I took that out. Let me know if you get it working again with the new update (0.3.3)
     
  24. Offline

    andrewkm

    Alright im back, sorry, needed sleep -_- wish we didnt need that lol.
    Okay lets see just doing some testing.
    My user has the permission wa.cenSell negated, yet in console i still see:
    canbuy: 1 cansell: 1 isadmin: 0
    -
    (Edit)
    -
    Okay through testing im noticing a few funny issues.
    First one is i set wa.* to everyone, and they all become admin (Of course since now they have webadmin permission) However removing the permissions from PEX and having them relog does NOT remove the admin=1 value from mysql. You must now negate wa.webadmin in the permission file and have them relog to have the value removed. - Nothing major just thought you should know.
    -
    Back to the issue at hand. Something is quite weird. See if I negate wa.canSell permission the cansell value in mysql doesnt turn to 0, HOWEVER if I negate wa.* (everything) it does turn to 0, so my conclusion is, is the permission really wa.canSell ? lol im confused.
    -
    Anotheredit:
    Okay now it seems to be working hmm... Darn permissions, I swear i capitalized the s in sell but it shouldnt need to be.... lets see how this handles multigroups though.

    @Exote
    Alright the permission handling is working perfect now. (No idea what was going on before - stupid issue when sometimes adding to the bottom of the old perm files it doesnt catch the perm on reload... no idea why. - has happened tons before with other plugins.) Alright anyways.
    Builders have:
    wa.canBuy
    -wa.canSell
    and Residents have:
    wa.canSell
    ---------
    Mysql is responding correctly on relogs as well on multigroups, inheritance etc, with PEX. So thats a +1 :D
    Now time to see if the website is correct, although im sure it will be :D

    @Exote
    Well website working exactly as it should, with relogs, permissions changes, group changes, and cansell/canbuy options. :)
    Using 0.3.3 by the way - very nice work on the buy input field now, speeds up the index alot :D

    @Exote
    During the usage delay (1000 miliseconds) a user with no permission to use a deposit chest can indeed use it as a normal chest if he right clicks it quickly within that delay (may cause confusion) <- just something i noticed. They may put items inside, and leave thinking they went to webauction when indeed they did not. Maybe users without perms to use deposit chests shouldnt be able to click them even if delay is on. (This isnt too important though)

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 19, 2016
  25. Offline

    NotYetRated

    Updated to 3.3. Webpage works. BUT, on server boot...

    Code:
    2011-10-14 00:26:14 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canBuy' in 'field list'
    2011-10-14 00:26:14 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canSell' in 'field list'
    2011-10-14 00:26:14 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isAdmin' in 'field list'
    2011-10-14 00:26:14 [INFO] [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 0
    2011-10-14 00:26:14 [INFO] New max size: 484
    2011-10-14 00:26:14 [INFO] New max size: 784
    2011-10-14 00:26:27 [INFO] _RGC_Pablo [/88.25.100.184:13688] logged in with entity id 2738 at ([world] -296.28125, 69.0, 613.75)
    2011-10-14 00:26:27 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canBuy' in 'field list'
    2011-10-14 00:26:27 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canSell' in 'field list'
    2011-10-14 00:26:27 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isAdmin' in 'field list'
    2011-10-14 00:26:27 [INFO] [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 0
    2011-10-14 00:26:27 [INFO] [xAuth] Villanover has logged in
    2011-10-14 00:26:48 [INFO] NotYetRated [/192.168.0.190:62699] logged in with entity id 5974 at ([world] 374.5, 50.0, -957.5)
    2011-10-14 00:26:49 [INFO] [staff] NotYetRated has joined the channel
    2011-10-14 00:26:49 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canBuy' in 'field list'
    2011-10-14 00:26:49 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canSell' in 'field list'
    2011-10-14 00:26:49 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isAdmin' in 'field list'
    2011-10-14 00:26:49 [INFO] [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 1
    2011-10-14 00:26:49 [SEVERE] while parsing a block mapping 
    Seriously, you will laugh your ass off at this. I get a member telling me the auction doesnt work blablabla. Finally get him to send me a screenshot of the error message.

    http://imageshack.us/photo/my-images/685/cantresolve.png/

    Tried to buy an item on webauction and taken to this page

    Code:
    id = $iConRow->id; $this->name = $iConRow->username; $this->money = $iConRow->balance; }else{ $query = mysql_query("SELECT * FROM WA_Players WHERE name='$user'"); $row = mysql_fetch_object($query); $this->id = $row->id; $this->name = $row->name; $this->money = $row->money; } } public function saveMoney($useMySQLiConomy, $iConTableName) { if ($useMySQLiConomy){ $query = mysql_query("UPDATE $iConTableName SET balance='$this->money' WHERE username='$this->name'"); }else{ $query = mysql_query("UPDATE WA_Players SET money='$this->money' WHERE name='$this->name'"); } } } ?>
    Fixed with a server reboot? odd... Still cant buy items though...

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 19, 2016
  26. Offline

    andrewkm

    @Exote
    Just realized I am not able to purchase items on webauction
    Code:
    id = $iConRow->id;             $this->name = $iConRow->username;             $this->money = $iConRow->balance; 	   }else{             $query = mysql_query("SELECT * FROM WA_Players WHERE name='$user'");             $row = mysql_fetch_object($query);             $this->id = $row->id;             $this->name = $row->name;             $this->money = $row->money;         }     } 	public function saveMoney($useMySQLiConomy, $iConTableName)     {         if ($useMySQLiConomy){             $query = mysql_query("UPDATE $iConTableName SET balance='$this->money' WHERE username='$this->name'"); 	    }else{             $query = mysql_query("UPDATE WA_Players SET money='$this->money' WHERE name='$this->name'");         }     } } ?> 
    I am running 0.3.3 updated .jar and webfiles.
    Edit:
    Tested with both normal users and webadmin accounts. Mysql is correct and users do have value on under canBuy. Not exactly sure what is going on here. (Seems above others are having the same issue)
     
  27. Offline

    silverwolf897

    @andrewkm

    Looks like when he integrated my new purchase code he changed to a php short tag.

    Goto the /classes/EconAccount.php that is in your webauciton folder & change the first line from "<?" to "<?php"

    See if that helps
     
    andrewkm likes this.
  28. Offline

    NotYetRated

    Worked like a charm! Thank you so much!!
     
  29. Offline

    Diaz9943

  30. Offline

    andrewkm

    Oh yeah I forgot about that problem with the tags. :p Fixing now.
    edit: Yup fixed
    By the way the press buy with empty field returns please enter quantity greater then zero, yet table title specifies click buy to purchase all. However I prefer it this way, so users dont press buy thinking they are buying just one and accidently buy all :p
     
  31. Offline

    Agil

    Now that I've upgraded to 0.3.4 which is absolutely working like a charm, I noticed that new players couldnt register and I do get alot of errors related to SQL query's upon joining and using any command.

    Error for new player upon joining:
    Code:
    2011-10-17 18:27:47 [INFO] [WebAuction] Player not found, creating account
    2011-10-17 18:27:47 [WARNING] [WebAuction] Error at SQL INSERT Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canBuy' in 'field list'
    Error for existing player upon joining:
    Code:
    2011-10-17 18:27:22 [INFO] NAME_PLAYER [/IPADDRESS:POORT] logged in with entity id 4352 at ([world] 142.5169937200374, 54.0, 713.1398581564587)
    2011-10-17 18:27:22 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canBuy' in 'field list'
    2011-10-17 18:27:22 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'canSell' in 'field list'
    2011-10-17 18:27:22 [WARNING] [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'isAdmin' in 'field list'
    2011-10-17 18:27:22 [INFO] [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 1
    Putting php after <? in EconAccount.php does not seem to work for me..
     

Share This Page