elnelson
Lunaria World Dev
Hello, im trying to enable this system for znote but im getting some syntax errores. i havent changed anything in code.
this is the code im using: Znote/ZnoteAAC (https://github.com/Znote/ZnoteAAC/blob/master/auctionChar.php)
SQL:
string(1375) " SELECT `za`.`id` AS `zaid`, `za`.`player_id`, `za`.`original_account_id`, `za`.`bidder_account_id`, `za`.`time_begin`, `za`.`time_end`, CASE WHEN `za`.`price` > `za`.`bid` THEN `za`.`price` ELSE `za`.`bid`+5 END AS `price`, CASE WHEN `za`.`original_account_id` = 11 THEN 1 ELSE 0 END AS `own`, CASE WHEN `za`.`original_account_id` = 11 THEN `p`.`name` ELSE '' END AS `name`, CASE WHEN `za`.`original_account_id` = 11 THEN `za`.`bid` ELSE 0 END AS `bid`, CASE WHEN `za`.`original_account_id` = 11 THEN `za`.`deposit` ELSE 0 END AS `deposit`, `p`.`vocation`, `p`.`level`, `p`.`balance`, `p`.`lookbody` AS `body`, `p`.`lookfeet` AS `feet`, `p`.`lookhead` AS `head`, `p`.`looklegs` AS `legs`, `p`.`looktype` AS `type`, `p`.`lookaddons` AS `addons`, `p`.`maglevel` AS `magic`, `p`.`skill_fist` AS `fist`, `p`.`skill_club` AS `club`, `p`.`skill_sword` AS `sword`, `p`.`skill_axe` AS `axe`, `p`.`skill_dist` AS `dist`, `p`.`skill_shielding` AS `shielding`, `p`.`skill_fishing` AS `fishing` FROM `znote_auction_player` za INNER JOIN `players` p ON `za`.`player_id` = `p`.`id` WHERE `za`.`id` = 1 AND `za`.`sold` = 0 LIMIT 1; "
(query - SQL error)
Type: [B]select_single[/B] (select single row from database)
Unknown column 'p.skill_fist' in 'field list'
this is the code im using: Znote/ZnoteAAC (https://github.com/Znote/ZnoteAAC/blob/master/auctionChar.php)