Skip to content

Instantly share code, notes, and snippets.

ALTER TABLE `arena_team` ADD INDEX ( `captainguid` );
ALTER TABLE `arena_team` ADD FOREIGN KEY ( `captainguid` ) REFERENCES `characters` (`guid`) ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE `arena_team_member` ADD FOREIGN KEY ( `arenateamid` ) REFERENCES `arena_team` (`arenateamid`) ON DELETE NO ACTION ON UPDATE NO ACTION ;
ALTER TABLE `arena_team_member` ADD FOREIGN KEY ( `guid` ) REFERENCES `characters` (`guid`) ON DELETE NO ACTION ON UPDATE NO ACTION ;
ALTER TABLE `arena_team_stats` ADD FOREIGN KEY ( `arenateamid` ) REFERENCES `arena_team` (`arenateamid`) ON DELETE NO ACTION ON UPDATE NO ACTION ;
ALTER TABLE `auction` ADD FOREIGN KEY ( `itemguid` ) REFERENCES item_instance` (`guid`) ON DELETE NO ACTION ON UPDATE NO ACTION ;
ALTER TABLE `auction` ADD INDEX ( `itemowner` );
ALTER TABLE `auction` ADD FOREIGN KEY ( `itemowner` ) REFERENCES `characters` (`guid`) ON DELETE NO ACTION ON UPDATE NO ACTION ;
ALTER TABLE `character_action` ADD FOREIGN KEY ( `guid` ) REFERENCES `characte
DELETE FROM `spell_bonus_data` WHERE `entry` IN ( 596, 2060, 2061, 13908, 32546, 10461, 10460, 6372, 6371, 5672);
INSERT INTO `spell_bonus_data`(`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`comments`) VALUES
( 596, 0.4285, 0, 0, 'Priest - Prayer of Healing'),
( 2060, 1.2353, 0, 0, 'Priest - Greater Heal'),
( 2061, 0.6177, 0, 0, 'Priest - Flash Heal'),
(13908, 0.4286, 0, 0, 'Priest - Desperate Prayer'),
(32546, 0.4286, 0, 0, 'Priest - Binding Heal'),
( 5672, 0.0450, 0, 0, 'Shaman - Healing Stream Totem Rank 1'),
( 6371, 0.0450, 0, 0, 'Shaman - Healing Stream Totem Rank 2'),
( 6372, 0.0450, 0, 0, 'Shaman - Healing Stream Totem Rank 3'),
page:
url: /:titre
class: sfDoctrineRoute
options: { model: Page, type: object }
param: { module: page, action: index }
homepage:
url: /
class: sfDoctrineRoute
options: { model: Page, type: object }
# mvn install
[INFO] Scanning for projects...
[INFO] ------------------------------------------------------------------------
[INFO] Building dynmap
[INFO] task-segment: [install]
[INFO] ------------------------------------------------------------------------
[INFO] [resources:resources {execution: default-resources}]
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 1 resource
[INFO] [compiler:compile {execution: default-compile}]
@MiLk
MiLk / ScriptDev2_2224_to_MaNGOS_one.patch
Created June 21, 2011 19:35
Update ScriptDev2_2224_to_MaNGOS_one.patch
From 119469b62d86cf121adbe835d8ff33ba4f0f8b4b Mon Sep 17 00:00:00 2001
From: MiLk <hello@emilienkenler.com>
Date: Tue, 21 Jun 2011 21:33:12 +0200
Subject: [PATCH] Update TBC-patch
---
include/precompiled.h | 5 +
include/sc_instance.cpp | 22 --
include/sc_instance.h | 3 -
.../shadowfang_keep/shadowfang_keep.cpp | 8 +-
@MiLk
MiLk / gist:1161937
Created August 22, 2011 08:34
Mass mailer
<?php
/*
* Mass mailer with PHPMailer
* http://sourceforge.net/projects/phpmailer/files/phpmailer%20for%20php5_6/PHPMailer%20v5.1/PHPMailer_v5.1.zip/download
*/
require_once('./class.phpmailer.php');
$mail = new PHPMailer();
@MiLk
MiLk / gist:1162375
Created August 22, 2011 13:28
Slideshow
$("#slideshow .slide_control").click(function () {
slideshowSwitch();
});
setInterval('slideshowSwitch();',5000);
function slideshowSwitch() {
var next = $("#slideshow .active").next(".slide");
if($("#slideshow .active").hasClass("last"))
next = $("#slideshow .first");
@MiLk
MiLk / gist:1189959
Created September 2, 2011 21:22
Comparaison Varnish / Nginx / Apache2
-- Varnish + Nginx
httperf --client=0/1 --server=www.hostyourcreeper.com --port=6081 --uri=/ --send-buffer=4096 --recv-buffer=16384 --num-conns=500 --num-calls=10
Maximum connect burst length: 1
Total: connections 500 requests 5000 replies 5000 test-duration 166.988 s
Connection rate: 3.0 conn/s (334.0 ms/conn, <=1 concurrent connections)
Connection time [ms]: min 293.1 avg 334.0 max 5315.1 median 309.5 stddev 316.5
Connection time [ms]: connect 0.1
<script type="text/javascript">
//<![CDATA[
function createCookie(name,value,days) {
if (days) {
var date = new Date();
date.setTime(date.getTime()+(days*24*60*60*1000));
var expires = "; expires="+date.toGMTString();
}
else var expires = "";
document.cookie = name+"="+value+expires+"; path=/";
<a href="javascript:;" rel="1" class="ajax_link">Text</a>