Recent Posts

21

World of Warcraft / Ink Merchants in World of Warcraft

« Last post by Remix on January 06, 2022, 04:12:29 PM »

Ink Merchants in World of Warcraft

Jessica Sellers > Dalaran
Illianna Moonscribe > Darnassus
Thargen Heavyquill > Ironforge
Morak > Orgimmar
Sinzi Sparkscribe > Orgimmar
Xantili > Orgimmar
Lelorian > Silvermoon City
Sarana Damir > Stormwind
Stanly McCormick > Stormwind
Sessoh > The Exodar
Mertle Murkpen > Thunder Bluff
Ickabod Pimlen > Under City

22

World of Warcraft / World of Warcraft Cataclysm Theme

« Last post by Remix on January 06, 2022, 01:01:19 PM »

Install World of Warcraft Cataclysm Theme link:

23

World of Warcraft / WoW Class Colors

« Last post by Remix on January 06, 2022, 11:30:18 AM »

WoW Class Colors

Death Knight

Code: [Select]

[RGB (0-255)] 196 / 30 / 58
[RGB (0.0-1.0)]: 0.77 / 0.12 / 0.23
[RGB Hex (00-FF)]: #C41E3A
Description: Red


Demon Hunter

Code: [Select]

[RGB (0-255)] 163 / 48 / 201
[RGB (0.0-1.0)]: 0.64 / 0.19 / 0.79
[RGB Hex (00-FF)]: #A330C9
Description: Dark Magenta


Druid

Code: [Select]

[RGB (0-255)] 255 / 124 / 10
[RGB (0.0-1.0)]: 1.00 / 0.49 / 0.04
[RGB Hex (00-FF)]: #FF7C0A
Description: Dark Orange


Hunter

Code: [Select]

[RGB (0-255)] 170 / 211 / 114
[RGB (0.0-1.0)]: 0.67 / 0.83 / 0.45
[RGB Hex (00-FF)]: #AAD372
Description: Green


Mage

Code: [Select]

[RGB (0-255)] 63 / 199 / 235
[RGB (0.0-1.0)]: 0.25 / 0.78 / 0.92
[RGB Hex (00-FF)]: #3FC7EB
Description: Light Blue


Monk

Code: [Select]

[RGB (0-255)] 0 / 255 / 152
[RGB (0.0-1.0)]: 0.00 / 1.00 / 0.60
[RGB Hex (00-FF)]: #00FF98
Description: Spring Green


Paladin

Code: [Select]

[RGB (0-255)] 244 / 140 / 186
[RGB (0.0-1.0)]: 0.96 / 0.55 / 0.73
[RGB Hex (00-FF)]: #F48CBA
Description: Pink


Priest

Code: [Select]

[RGB (0-255)] 255 / 255 / 255
[RGB (0.0-1.0)]: 1.00 / 1.00 / 1.00
[RGB Hex (00-FF)]: #FFFFFF
Description: White


Rogue

Code: [Select]

[RGB (0-255)] 255 / 244 / 104
[RGB (0.0-1.0)]: 1.00 / 0.96 / 0.41
[RGB Hex (00-FF)]: #FFF468
Description: Yellow


Shaman

Code: [Select]

[RGB (0-255)] 0 / 112 / 221
[RGB (0.0-1.0)]: 0.00 / 0.44 / 0.87
[RGB Hex (00-FF)]: #0070DD
Description: Blue


Warlock

Code: [Select]

[RGB (0-255)] 135 / 136 / 238
[RGB (0.0-1.0)]: 0.53 / 0.53 / 0.93
[RGB Hex (00-FF)]: #8788EE
Description: Purple


Warrior

Code: [Select]

[RGB (0-255)] 198 / 155 / 109
[RGB (0.0-1.0)]: 0.78 / 0.61 / 0.43
[RGB Hex (00-FF)]: #C69B6D
Description: Tan




--

24

MySQL / MySQL select all rows with a NULL in column

« Last post by Remix on January 04, 2022, 05:10:32 PM »

Syntax: WHERE field IS NULL

Code: [Select]

SELECT * FROM `YourTable` WHERE YourColumn IS NULL;

25

PHP / Add csv delimiters at the beginning and the end of each line using regexp

« Last post by Remix on January 04, 2022, 01:50:51 PM »

Add " at the beginning and the end of each line (using regular expressions in any text editor):

Add " as CSV delimiters:
1. Check "Use Regular Expressions"
2. Search for: (.+)
3. Replace with: "\1"




--

26

Servers and Networking [IT & Datacenter] / Specify @font-display when defining custom fonts in your theme

« Last post by hubsinfo on December 23, 2021, 06:10:53 PM »

Specify @font-display when defining custom fonts in your theme

Leverage the font-display CSS feature to ensure text is user-visible while webfonts are loading.

Code: [Select]

@font-face {
  font-family: 'Roboto Mono', monospace;
  src: url(fonts/roboto-mono-v12-latin-regular.woff2) format('woff2'),
       url(fonts/roboto-mono-v12-latin-regular.woff) format('woff'),
       url(fonts/roboto-mono-v12-latin-regular.ttf) format('truetype');
  font-display: optional;
}

@font-face {
  font-family: 'Roboto Mono', monospace;
  src: url(fonts/roboto-mono-v12-latin-700italic.woff2) format('woff2'),
       url(fonts/roboto-mono-v12-latin-700italic.woff) format('woff'),
       url(fonts/roboto-mono-v12-latin-700italic.ttf) format('truetype');
  font-weight: 700;
  font-style: italic;
  font-display: optional;
}




--

27

PHP / Adding csv delimiter for phpmyadmin imports

« Last post by Slowloris on December 12, 2021, 11:34:08 AM »

Adding csv delimiter for phpmyadmin imports ","
(in any text editor)


Add " at the beginning of each line:
--
Press CTRL+H
Replace ^ with " (sign you want append at the start)
Select search mode as Regular Expression
Click Replace All.

28

PHP / Import csv files in phpmyadmin

« Last post by Slowloris on December 12, 2021, 11:22:38 AM »

Import csv files in phpmyadmin

1. When you click "Import", make sure a table in the database is NOT selected. The database name SHOULD be selected instead.
2. Before importing... Rename your .txt file to .csv
3. Make sure that your data has delimiter like this ","

29

PHP / Diacritice si accente in PHP si MySQL

« Last post by Remix on September 20, 2021, 04:12:11 PM »

Diacritice si accente in PHP si MySQL

1. For HTML

Code: [Select]

<meta http-equiv="Content-type" content="text/html;charset=utf-8" />

2.
For MySQLi

Code: [Select]

mysqli_set_charset($conn, "utf8");

For MySQLi (OOP)

Code: [Select]

$conn->set_charset("utf8");





--

30

SimCity BuildIt / Upgrading Roads in SimCity BuildIt

« Last post by Remix on August 31, 2021, 01:27:08 PM »

Tap the hard hat/traffic light Upgrade icon. You’ll see a view of your city with your road network highlighted. Green/black roads = good. Red roads = bad!

A yellow glow in the upgrading view indicates Moderate traffic. A sudden population increase in that area and residents will start to complain!
A red glow is bad news, and means traffic is already too heavy. Citizens are unhappy at this point, and will start to abandon their homes.

Tap the yellow and red sections to see how many Simoleons are needed to upgrade to the next road level, then tap the green checkmark to confirm your decision. Each upgrade is unlocked as you progress in the game.

SUBSCRIBE!