• 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!

AAC how to show the set of player

itachi_

itachi_

Banned User
Joined
Oct 29, 2019
Messages
44
Solutions
1
Reaction score
8
Location
Egypt
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! .
 

Attachments

Solution
Znote
This is an old one:
[Znote AAC] Characterprofile EQ shower

vEBlB8X.png


This is a new one, still WIP (todo list: Support more than 24 outfits)
gist.github.com

Characterprofile equipped items + skills + aquired outfits showcase

Characterprofile equipped items + skills + aquired outfits showcase - characterprofile.php
gist.github.com gist.github.com
7cHrLPZ.jpg


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
Sort by date Sort by votes
Last edited:
Upvote 0 Downvote
Solution
Znote said:
This is an old one:
[Znote AAC] Characterprofile EQ shower

vEBlB8X.png


This is a new one, still WIP (todo list: Support more than 24 outfits)
gist.github.com

Characterprofile equipped items + skills + aquired outfits showcase

Characterprofile equipped items + skills + aquired outfits showcase - characterprofile.php
gist.github.com gist.github.com
7cHrLPZ.jpg


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
Click to expand...
thanks bro, much appreciated!

itachi_ said:
thanks bro, much appreciated!
Click to expand...
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'
 
Upvote 0 Downvote
itachi_ said:
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'
Click to expand...

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;
");
 
Upvote 0 Downvote
Znote said:
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;
");
Click to expand...
thanks that worked, but it looks broken image how to fix it?
anotherscreen.png
 
Upvote 0 Downvote
Extract this img folder in /engine/ folder, so path to images are /engine/img/ from the Znote AAC web directory.
 

Attachments

Upvote 0 Downvote
Upvote 0 Downvote
Here are the outfit ids:
github.com

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/ZnoteAAC
github.com github.com

When you configure these, take notice of the rows and columns. They should match as good as possible.

And follow these instructions:
github.com

Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC
github.com github.com

To install this Lua script:
github.com

Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC
github.com github.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.
 
Upvote 0 Downvote
Znote said:
Here are the outfit ids:
github.com

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/ZnoteAAC
github.com github.com

When you configure these, take notice of the rows and columns. They should match as good as possible.

And follow these instructions:
github.com

Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC
github.com github.com

To install this Lua script:
github.com

Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC
github.com github.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.
Click to expand...


Znote,

How can I add the player hide option EQ SHOWER -In myaccount? Please, help.
 
Upvote 0 Downvote

Similar threads

M
  • Question
RevScripts Monster move before spell
Replies
0
Views
141
Me again
M
X
  • Solved
tfs 1.4.2 ACC installing Znote AAC
Replies
6
Views
814
XiolenceOT
X
hellboy
  • Solved
How to extract spell icons and spell groups icons from new client?
Replies
3
Views
530
Sarah Wesker
Sarah Wesker
Aquan
  • Question
TFS 0.X Changing the level display
Replies
2
Views
314
Aquan
Aquan
ralke
  • Question
TFS 1.X+ Set loot rate *1 to specific creatures
Replies
11
Views
612
Mateus Robeerto
Mateus Robeerto
Joriku
  • Question
AAC Znote, PHPMailer times website out
Replies
3
Views
442
Joriku
Joriku
160312
  • Question
How can I add new items from newest version on map editor and how to add items to market on Sabrehaven?
Replies
2
Views
460
160312
160312
Michcol94
  • Question
OTClient Big outfit problem
Replies
6
Views
567
Michcol94
Michcol94
ralke
  • Question
TFS 1.X+ Add broadcast message when player dies in infinite PVP arena
Replies
1
Views
306
Error 502
Error 502
Fabi Marzan
  • Solved
C++ Does not show the Text when the value is 0
Replies
10
Views
512
Mateus Robeerto
Mateus Robeerto
Back
Top