Skip to content

Instantly share code, notes, and snippets.

View itsbalamurali's full-sized avatar
🎯
Focusing

Balamurali Pandranki itsbalamurali

🎯
Focusing
91 followers · 67 following
View GitHub Profile
@itsbalamurali
itsbalamurali / dataimport.php
Created April 14, 2014 14:30
Game Metadata Import Script
<?php
$con=mysqli_connect("localhost","root","yourass1994","games");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// Change character set to utf8
@itsbalamurali
itsbalamurali / game data.sql
Last active August 29, 2015 13:59
Mochi game data
This file has been truncated, but you can view the full file.
--
-- MySQL 5.5.35
-- Mon, 14 Apr 2014 14:42:45 +0000
--
CREATE TABLE `games` (
`id` int(11) not null auto_increment,
`uuid` varchar(200) not null,
`created` datetime not null,
`name` varchar(300) not null,
@itsbalamurali
itsbalamurali / 0_reuse_code.js
Created April 22, 2014 19:48
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@itsbalamurali
itsbalamurali / api.md
Created June 7, 2014 11:21 — forked from tmcw/api.md

Root

api.tiles.mapbox.com/v1/

Albums

api.tiles.mapbox.com/v1/albums.json
api.tiles.mapbox.com/v1/albums.jsonp
@itsbalamurali
itsbalamurali / 4sqr-cat.json
Created June 25, 2014 04:01
foursquare categories
{
"meta": {
"code": 200
},
"notifications": [
{
"type": "notificationTray",
"item": {
"unreadCount": 0
}
@itsbalamurali
itsbalamurali / ravi.php
Created June 25, 2014 14:31
rv backup
<?php /* Template Name: Homepage */ ?>
<?php get_header(); ?>
<?php $canon_options_slider = get_option('canon_options_slider'); ?>
<?php $canon_options_hp = get_option('canon_options_hp'); ?>
<!-- SLIDER MASTHEAD -->
@itsbalamurali
itsbalamurali / func.php
Created June 26, 2014 16:52
usercake funcs
<?php
//Functions that do not interact with DB
//------------------------------------------------------------------------------
//Retrieve a list of all .php files in models/languages
function getLanguageFiles()
{
$directory = "config/languages/";
$languages = glob($directory . "*.php");
//print each file name
@itsbalamurali
itsbalamurali / ip-check.py
Created July 8, 2014 01:17
Python script for detecting IP change and send email to admin.
import os.path
import time
import urllib
import re
from email.MIMEMultipart import MIMEMultipart
from email.MIMEText import MIMEText
import smtplib
fileName = "mylastip.txt"
@itsbalamurali
itsbalamurali / Json response foursquare.json
Created July 8, 2014 18:59
Json response foursquare.json
{"meta":{"code":200},"notifications":[{"type":"notificationTray","item":{"unreadCount":0}}],"response":{"venue":{"id":"40a55d80f964a52020f31ee3","name":"Clinton St. Baking Co. & Restaurant","contact":{"phone":"+16466026263","formattedPhone":"+1 646-602-6263"},"location":{"address":"4 Clinton St","crossStreet":"at E Houston St","lat":40.721294,"lng":-73.983994,"postalCode":"10002","cc":"US","city":"New York","state":"NY","country":"United States","formattedAddress":["4 Clinton St (at E Houston St)","New York, NY 10002","United States"]},"canonicalUrl":"https:\/\/foursquare.com\/v\/clinton-st-baking-co--restaurant\/40a55d80f964a52020f31ee3","categories":[{"id":"4bf58dd8d48988d143941735","name":"Breakfast Spot","pluralName":"Breakfast Spots","shortName":"Breakfast","icon":{"prefix":"https:\/\/ss1.4sqi.net\/img\/categories_v2\/food\/breakfast_","suffix":".png"},"primary":true},{"id":"4bf58dd8d48988d16a941735","name":"Bakery","pluralName":"Bakeries","shortName":"Bakery","icon":{"prefix":"https:\/\/ss1.4sqi.net\/i
@itsbalamurali
itsbalamurali / trending venues.json
Created July 8, 2014 19:07
trending venues json