Skip to content

Instantly share code, notes, and snippets.

View Mrbytes's full-sized avatar

Eduardo Guervós Mrbytes

View GitHub Profile
@Mrbytes
Mrbytes / internationalization-of-language-on-install.diff
Created April 26, 2013 23:32
internationalization of language on install & new table structure
From dc7363d00d08ad69baa31c1d9d2f1505b67f2b63 Mon Sep 17 00:00:00 2001
From: mrbytes <eguervos@msn.com>
Date: Sat, 27 Apr 2013 01:22:30 +0200
Subject: [PATCH] internationalization of language on install
---
install/extra/basicdata.sql | 876 +++++++++++++++++++
install/extra/script_text_locales.sql | 717 ++++++++++++++++
install/extra/structure.sql | 1496 +++++++++++++++++++++++++++++++++
install/functions/database.php | 141 +++-
From 61b9fe7d6eb8a8e422b050168bd31c7b8aaf684f Mon Sep 17 00:00:00 2001
From: mrbytes <eguervos@msn.com>
Date: Sat, 9 Mar 2013 14:47:14 +0100
Subject: [PATCH] Implementation of slide roll over and over in Last-5-Block
Index page
---
blocks/index/latest_torrents.php | 71 +++---
lang/1/lang_index.php | 199 +++++++--------
scripts/jquery.gallery.js | 522 +++++++++++++++++++++++++++++++++++++++
@Mrbytes
Mrbytes / gist:3059638
Created July 6, 2012 11:24
Fixed-all-quotes-and-apostrophes-without-slash.patch
From 8a91782af83345816a78a8d42a7a26cf7b7e7a1b Mon Sep 17 00:00:00 2001
From: mrbytes <eguervos@msn.com>
Date: Fri, 6 Jul 2012 13:19:34 +0200
Subject: [PATCH] Fixed all quotes ["] and apostrophes ['] (without slash)
improperly implemented By Mrbytes
---
sql_mr/mr00249_scriptdev2_ulduar.sql | 428 +++++++++++++++++-----------------
1 file changed, 214 insertions(+), 214 deletions(-)
@Mrbytes
Mrbytes / gist:3046915
Created July 4, 2012 11:38
SD2 DB cleanup.sql
-------------------------------------------
-- Corrections to the table script_texts --
-------------------------------------------
-- This query has done the extraction --
-- SELECT a1.entry ,a1.sound FROM script_texts a1 INNER JOIN script_texts a2 ON a1.sound <> 0 AND a1.sound = a2.sound AND a1.entry <> a2.entry ORDER BY a1.entry ASC