Skip to content

Latest commit

 

History

History
183 lines (123 loc) · 6.16 KB

README.md

File metadata and controls

183 lines (123 loc) · 6.16 KB

swango

Typing SVG

marelissima marelissmia

more lisica

Prolazimo tako gradom
moj osmijeh i ja
on na licu mom
ja bez lica svog.

Jasni ljudi jasno vide,
al ne znaju da
ne postojimo
ni osmijeh ni ja.

svatko ima svoje razloge i kad razlozi ne postoje

img

marzipan

Diomedia ⚓ 🔱

«🕸🔱🕸» «·|·»
==microfiber== 🕸🔱🕸

Poljane diomedie

furtive

I once killed a man in this repository and nobody ever found him. 😈 😋

Detective :shipit: is still investigating.
.

+

~

Come Little Children - E. A . Poe

"For every problem there is one solution which is simple, neat and wrong."

Lapsed Catholic

http://en.wikipedia.org/wiki/Lapsed_Catholic

💎 what do you love?
💎 what do you hate?
💎 what makes you CraZy?
💎 what is the best thing you've done in life?
💎 what is the worst thing you have done in life?
💎 what would you do if you won the lottery?

You define yourself as...

blue sticky blood

white sticky blood

there are actually gliding roller blades over the skin

hematology

** usual ramblings of a madman **

blue skies and butterflies

maginello

once upon a time in a little treehouse around the world there lived a little timmy. he thought he knew everything. but then he met a girl. she changed his world entirely. timmy was so affraid.

there is new alcohol breed inside this shell. it comes from knowing you always michelle

⚓ 👶

Forums Design Music Lyrics Movies, Series, TV Youtube Multimedia PhotoWorld Blood

categories 'Software' 'Multimedia' 'General Category' 'World Online'

INSERT INTO `smf_smileys` (`ID_SMILEY`, `code`, `filename`, `description`, `smileyRow`, `smileyOrder`, `hidden`) VALUES
(28, ':scared:', 'Scary-Smile.png', 'Scared', 0, 10, 0),
(18, ':ninja:', 'Ninja.png', 'Ninja', 0, 25, 0),
(24, ':worry:', 'Scary.png', 'Worried', 0, 21, 0),
(23, ':tear:', 'Tear.png', 'Teary Eyes', 0, 20, 0),
(26, ':sick:', 'Sick.png', 'Sick', 0, 23, 0),
(7, ':bad:', 'Bad.png', 'Bad', 0, 6, 0),
(10, ':ahh:', 'Ahhhh.png', 'Ah NO', 0, 9, 0),
(25, ':zzz:', 'Sleep.png', 'Sleepy', 0, 22, 0),
(27, 'Alien', 'Alien.png', ':alien:', 0, 24, 0),
(5, '>:(', 'Mad.png', 'Angry', 0, 4, 0),
(9, '???', 'Huh.png', 'Huh?', 0, 8, 0),
(12, ':-[', 'Blush.png', 'Embarrassed', 0, 12, 0),
(13, 'O_o', 'Ohhhh.png', 'Ou!', 0, 13, 0),
(14, ':-\\', 'What.png', 'Undecided', 0, 14, 0),
(15, 'o_O', 'Shocking.png', 'Shocking', 0, 15, 0),
(16, ':''(', 'Crying.png', 'Cry', 0, 16, 0),
(17, '>:D', 'Devil.png', 'Evil', 0, 26, 0),
(21, '>.<', 'Doh.png', 'Doh', 0, 18, 0),
(1, ':)', 'Happy.png', 'Smiley', 0, 0, 0),
(2, ';)', 'Wink.png', 'Wink', 0, 1, 0),
(3, ':D', 'Smile.png', 'Cheesy', 0, 2, 0),
(4, ';D', 'Laugh.png', 'Grin', 0, 3, 0),
(6, ':(', 'Sad.png', 'Sad', 0, 5, 0),
(8, '8)', 'Cool.png', 'Cool', 0, 7, 0),
(11, ':P', 'Tounge.png', 'Tongue', 0, 11, 0),
(20, ':>', 'Woot.png', 'hey hey', 0, 17, 0),
(22, '<3', 'Love.png', 'In Love ', 0, 19, 0);

ameo - Carson Clay [I cry, when angels deserve to die]

💎 what is life, but a teardrop in the eye of infinity 💎

xyz

AUTHOR as MOD of TOPIC

Firstly thought as SMF mod, until someone told me that this can be done by

giving permission to  author:

[color=red]Admin CP > Permissions > (Membergroup, Regular Members if you haven't set up any others)

Then just check some of the moderation permissions for "Own Topic." [/color]

I figured out - why not in SUPPORT TOPIC to give author permission to MODERATE it.   since some questions have already been answered, and some steps explained.

if topic has more than 5/10 pages author = MOD - if support, of course.

Trivia

Did U Know: Definition of author:

[color=royalblue]Author is a person who gives existence 2 anything.[/color]


Quick reply Admin cp >>> Themes and Layout >>> Reset Options>>> (check your theme and) Reset all members' current options for this theme>> [ Change ]Use quick reply on topic display:[ show, on by default ] and save.

How to change the collation in a MySQL database for all tables and columns

There's no one-line command to do this in MySQL, but there's a command for changing a table's default character set (and/or collation) and convert all it's columns to the new character set (and/or collation). It's like this:

[code]ALTER TABLE database_name.table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci[/code]

[b]However if you've a hundred tables or so[/b], doing this one by one is a tedious task. Since MySQL 5.x you can query a list of tables (and columns, etc.) from the database named information_schema. With the following query you can create the SQL statements to convert the character set (and/or collation) for all tables easily: [code]SELECT CONCAT('ALTER TABLE ', t.TABLE_SCHEMA, '.', t.TABLE_NAME, ' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') as stmt FROM information_schema.TABLES t WHERE 1 AND t.TABLE_SCHEMA = 'database_name' ORDER BY 1 [/code] [b]Replace "database_name" with the name of your database[/b] and edit the statement template in the parameters of the CONCAT function to have the target character set (and/or collation) of your choice. After that you can just take the statements and batch execute them in the MySQL client of your choice (eg. phpmyadmin, Navicat, the official MySQL client, etc.). Of course, you're strongly advised to make a backup of your database before you start messing around with character set (and/or collation) conversions.