Skip to content

Instantly share code, notes, and snippets.

View manga.py
import ui
import appex
import requests
import json
if appex.is_running_extension():
url = appex.get_url()
else:
url = 'https://dynasty-scans.com/chapters/together_with_hecaa_chan_2'
View example_3.py
import records
import datetime
db = records.Database('mysql://root:a6478a14@172.16.144.157/bank')
print('Welcome to Softbank. Please enter your username and password...')
username = raw_input('Username: ')
password = raw_input('Password: ')
# This SQL library does not immediately run the query and store the results until we tell it to.
View example_2.py
import records
db = records.Database('mysql://root:a6478a14@172.16.144.157/bank')
print('Welcome to the Softbank registration system!')
print('Please tell us the following information...')
first_name = raw_input('First name: ')
middle_name = raw_input('Middle name: ')
last_name = raw_input('Last name: ')
username = first_name.lower()[0] + last_name.lower()
View example_1.py
import records
db = records.Database('mysql://root:a6478a14@172.16.144.157/bank')
# Create User table
db.query("""CREATE TABLE `user` (
`id` INT NOT NULL AUTO_INCREMENT,
`first_name` VARCHAR(100) NOT NULL,
`middle_name` VARCHAR(100) NOT NULL,
View remote_map_drive.vbs
'''''''''''''''''''''''''''''
' Purpose: Allows us to remotely map drives without psexec or knowing the user's password
' Requirements: Windows 7 (may support older OSes), Administrator (maybe)
' Written by: Alex Yancey
' Date: December 20, 2016
'''''''''''''''''''''''''''''
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile("remotemap.bat")
View external_computer_name.vbs
'''''''''''''''''''''''''''''
' Purpose: Allows you to enter the drive letter of an external drive with a copy of Windows on it, returns computer name
' Requirements: Windows 7 (may support older OSes), Administrator (maybe)
' Written by: Alex Yancey
' Date: December 8, 2016
'''''''''''''''''''''''''''''
const HKEY_LOCAL_MACHINE = &H80000002
set objshell = CreateObject("Wscript.shell")
computer_name = InputBox("OS drive letter: ", "HDD Computer Name")
View CoffeeMaker.ino
#include <ESP8266WiFi.h>
#include <stdlib.h>
const char* ssid = "MAAQ";
const char* password = "";
WiFiServer server(80);
void setup() {
pinMode(LED_BUILTIN, OUTPUT);
View RAM Upgrade.vbs
'''''''''''''''''''''''''''''
' Purpose: Allows you to easily get the RAM configuration of a computer. LAN Sweeper won't tell you the RAM type, but this utility will. This should be useful for RAM upgrades.
' Requirements: Probably admin in Active Directory
' Written by: Alex Yancey
' Date: September 15, 2016
'''''''''''''''''''''''''''''
' More info about SMBIOS can be found in the SMBIOS specification: https://www.dmtf.org/standards/smbios, and from this article: http://www.codeguru.com/cpp/misc/misc/system/article.php/c12347/SMBIOS-Demystified.htm
computer_name = InputBox("Computer name: ", "RAM Identifier")
View Get_Ram_Type.vbs
' More info about SMBIOS can be found in the SMBIOS specification: https://www.dmtf.org/standards/smbios, and from this article: http://www.codeguru.com/cpp/misc/misc/system/article.php/c12347/SMBIOS-Demystified.htm
' Get SMBIOS data using WMI
Set objWMIService = GetObject("winmgmts:\\.\root\WMI")
Set smbios_array = objWMIService.ExecQuery("SELECT * FROM MSSmBios_RawSMBiosTables")
For Each i in smbios_array
Set smbios = i
Exit For
Next
smbios_string = Join(smbios.SMBiosData, ",")
@ayancey
ayancey / ram_type.py
Last active Jul 15, 2016
Gets the type of RAM in Windows, with raw SMBIOS data. Works even if Win32_PhysicalMemory.MemoryType is Unknown.
View ram_type.py
import wmi
import struct
# RAM memory types described in 7.18.2 in SMBIOS Specification
MEMORY_TYPES = {1: 'Other', 2: 'Unknown', 3: 'DRAM', 4: 'EDRAM', 5: 'VRAM', 6: 'SRAM', 7: 'RAM', 8: 'ROM', 9: 'FLASH', 10: 'EEPROM', 11: 'FEPROM', 12: 'EPROM', 13: 'CDRAM', 14: '3DRAM', 15: 'SDRAM', 16: 'SGRAM', 17: 'RDRAM', 18: 'DDR', 19: 'DDR2', 20: 'DDR2 FB-DIMM', 21: 'Reserved', 22: 'Reserved', 23: 'Reserved', 24: 'DDR3', 25: 'FBD2'}
def Get_SMBIOS(w):
SMBIOSTableData = ""
for i in w.query("SELECT * FROM MSSmBios_RawSMBiosTables")[0].SMBiosData: