Skip to content

Instantly share code, notes, and snippets.

View adopilot's full-sized avatar
🎯
Focusing

Admir adopilot

🎯
Focusing
  • Robot General Trading Co doo
  • Sarajevo Bosnia and Hercegovina
  • X @pilotado
View GitHub Profile
@adopilot
adopilot / gist:6378aa46c4cc458aaa51
Created December 5, 2015 19:39
discouse pg_dump for version 1.5.0.beta6
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.3.10
-- Dumped by pg_dump version 9.3.1
-- Started on 2015-12-05 20:38:18
SET statement_timeout = 0;
SET lock_timeout = 0;
#!/usr/bin/python
# -*- coding: utf-8 -*-
"""
Zabbix SMTP Alert script for gmail.
"""
import sys
import smtplib
from email.MIMEText import MIMEText
from email.Header import Header
public ActionResult DiscourseLogin()
{
if (string.IsNullOrEmpty(Request.QueryString["sso"]) || string.IsNullOrEmpty(Request.QueryString["sig"]))
return Content("Invalid");
string ssoSecret = "YOUR SSO SECRET"; //must match sso_secret in discourse settings
string sso = Request.QueryString["sso"];
string sig = Request.QueryString["sig"];
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MoveIndexToFileGroup]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[MoveIndexToFileGroup]
GO
CREATE PROC [dbo].[MoveIndexToFileGroup] (
@DBName sysname,
@SchemaName sysname = 'dbo',
@ObjectNameList Varchar(Max),
@IndexName sysname = null,
@FileGroupName varchar(100)