Just wondering how to show the set of player on players search at @Znote AAC with the latest version like this pic.
thanks in advance! .
thanks in advance! .
Attachments
-
screenshot.png13.8 KB · Views: 2 · VirusTotal
thanks bro, much appreciated!This is an old one:
[Znote AAC] Characterprofile EQ shower
This is a new one, still WIP (todo list: Support more than 24 outfits)
Characterprofile equipped items + skills + aquired outfits showcase
Characterprofile equipped items + skills + aquired outfits showcase - characterprofile.phpgist.github.com
It will be officially implemented into Znote AAC in about a month I guess. But until then you can add it yourself by modifying characterprofile.php
i have chosen the next new one but this error appear on the sitethanks bro, much appreciated!
string(302) " SELECT `health`, `healthmax`, `mana`, `manamax`, `cap`, `experience`, `level`, `soul`, `stamina`, `maglevel`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing` FROM `players` WHERE `id`=99 LIMIT 1; "
(query - SQL error)
Type: [B]select_single[/B] (select single row from database)
Unknown column 'skill_fist' in 'field list'
thanks bro, much appreciated!
i have chosen the next new one but this error appear on the site
string(302) " SELECT `health`, `healthmax`, `mana`, `manamax`, `cap`, `experience`, `level`, `soul`, `stamina`, `maglevel`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing` FROM `players` WHERE `id`=99 LIMIT 1; " (query - SQL error) Type: [B]select_single[/B] (select single row from database) Unknown column 'skill_fist' in 'field list'
$playerstats = mysql_select_single("
SELECT
`health`, `healthmax`,
`mana`, `manamax`,
`cap`,
`experience`, `level`, `soul`, `stamina`,
`maglevel`,
`skill_fist`,
`skill_club`,
`skill_sword`,
`skill_axe`,
`skill_dist`,
`skill_shielding`,
`skill_fishing`
FROM `players`
WHERE `id`={$user_id}
LIMIT 1;
");
$playerstats = mysql_select_single("
SELECT
`p`.`health`, `p`.`healthmax`,
`p`.`mana`, `p`.`manamax`,
`p`.`cap`,
`p`.`experience`, `p`.`level`,
`p`.`soul`,
`p`.`stamina`,
`p`.`maglevel`,
`fist`.`value` AS `skill_fist`,
`club`.`value` AS `skill_club`,
`sword`.`value` AS `skill_sword`,
`axe`.`value` AS `skill_axe`,
`dist`.`value` AS `skill_dist`,
`shield`.`value` AS `skill_shielding`,
`fish`.`value` AS `skill_fishing`
FROM `players` AS `p`
LEFT JOIN `player_skills` AS `fist` ON `p`.`id` = `fist`.`player_id` AND `fist`.`skillid` = 0
LEFT JOIN `player_skills` AS `club` ON `p`.`id` = `club`.`player_id` AND `club`.`skillid` = 1
LEFT JOIN `player_skills` AS `sword` ON `p`.`id` = `sword`.`player_id` AND `sword`.`skillid` = 2
LEFT JOIN `player_skills` AS `axe` ON `p`.`id` = `axe`.`player_id` AND `axe`.`skillid` = 3
LEFT JOIN `player_skills` AS `dist` ON `p`.`id` = `dist`.`player_id` AND `dist`.`skillid` = 4
LEFT JOIN `player_skills` AS `shield` ON `p`.`id` = `shield`.`player_id` AND `shield`.`skillid` = 5
LEFT JOIN `player_skills` AS `fish` ON `p`.`id` = `fish`.`player_id` AND `fish`.`skillid` = 6
WHERE `p`.`id`= {$user_id}
LIMIT 1;
");
thanks that worked, but it looks broken image how to fix it?Ahh yeah, my prototype is currently only tested using TFS 1.3.
Replace:
PHP:$playerstats = mysql_select_single(" SELECT `health`, `healthmax`, `mana`, `manamax`, `cap`, `experience`, `level`, `soul`, `stamina`, `maglevel`, `skill_fist`, `skill_club`, `skill_sword`, `skill_axe`, `skill_dist`, `skill_shielding`, `skill_fishing` FROM `players` WHERE `id`={$user_id} LIMIT 1; ");
With this:
PHP:$playerstats = mysql_select_single(" SELECT `p`.`health`, `p`.`healthmax`, `p`.`mana`, `p`.`manamax`, `p`.`cap`, `p`.`experience`, `p`.`level`, `p`.`soul`, `p`.`stamina`, `p`.`maglevel`, `fist`.`value` AS `skill_fist`, `club`.`value` AS `skill_club`, `sword`.`value` AS `skill_sword`, `axe`.`value` AS `skill_axe`, `dist`.`value` AS `skill_dist`, `shield`.`value` AS `skill_shielding`, `fish`.`value` AS `skill_fishing` FROM `players` AS `p` LEFT JOIN `player_skills` AS `fist` ON `p`.`id` = `fist`.`player_id` AND `fist`.`skillid` = 0 LEFT JOIN `player_skills` AS `club` ON `p`.`id` = `club`.`player_id` AND `club`.`skillid` = 1 LEFT JOIN `player_skills` AS `sword` ON `p`.`id` = `sword`.`player_id` AND `sword`.`skillid` = 2 LEFT JOIN `player_skills` AS `axe` ON `p`.`id` = `axe`.`player_id` AND `axe`.`skillid` = 3 LEFT JOIN `player_skills` AS `dist` ON `p`.`id` = `dist`.`player_id` AND `dist`.`skillid` = 4 LEFT JOIN `player_skills` AS `shield` ON `p`.`id` = `shield`.`player_id` AND `shield`.`skillid` = 5 LEFT JOIN `player_skills` AS `fish` ON `p`.`id` = `fish`.`player_id` AND `fish`.`skillid` = 6 WHERE `p`.`id`= {$user_id} LIMIT 1; ");
Here are the outfit ids:
ZnoteAAC/characterprofile.php at 0eb2972e303ce705a1e773d843087036c765f511 · Znote/ZnoteAAC
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAACgithub.com
When you configure these, take notice of the rows and columns. They should match as good as possible.
And follow these instructions:
Znote/ZnoteAAC
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAACgithub.com
To install this Lua script:
Znote/ZnoteAAC
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAACgithub.com
Note that I check if addon = 3 (that you have both addons to an outfit) before they get highlighted and visible on the characterprofile.