G_Markin theGuildtable is binary: turn it into text withbin2hex(). You get 64 hex digits, one per cell of an 8x8 grid.- Map each digit to a color: 0 transparent, 1 #000000, 2 #8c8a8d, 3 #ffffff, 4 #fe0000, 5 #ff8a00, 6 #ffff00, 7 #8cff01, 8 #00ff00, 9 #01ff8d, a #00ffff, b #008aff, c #0000fe, d #8c00ff, e #ff00fe, f #ff008c.
- Draw the 64 cells as colored
<div>or table cells (not<img>tags), inside a function such asguildlogo($guildmark, $size)where the second value is the cell size, so you can change the logo size. - Declare that function only once per page; if another block (for example a TOP 5 guild box) already defines one, reuse it or rename one of them.
- On current PHP use the SQL Server PDO driver and
<?phptags instead of the oldmssql_queryand<?.
How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?
“wow! ... it works”
The topic starter, 2020-07-01 (original words)