TraceRT

C:\Documents and Settings\Administrator>tracert rochess.net

Tracing route to rochess.net [66.206.9.16]
over a maximum of 30 hops:

1 <1 ms <1 ms <1 ms firewall [192.168.0.1]
2 36 ms 29 ms 13 ms 10.85.128.1
3 13 ms 13 ms 11 ms gsr01-cr.blueyonder.co.uk [62.30.112.33]
4 14 ms 28 ms 10 ms tele1-cro-pos.telewest.net [194.117.136.34]
5 10 ms 12 ms 9 ms 194.117.136.174
6 99 ms 93 ms 84 ms eqix.asbn.twtelecom.net [206.223.115.36]
7 84 ms 95 ms 82 ms core-02-so-0-1-0-0.asbn.twtelecom.net [66.192.255.230]
8 148 ms 165 ms 152 ms core-02-so-0-0-0-0.bois.twtelecom.net [66.192.248.2]
9 149 ms 151 ms 150 ms core-02-so-0-0-0-0.bois.twtelecom.net [66.192.248.2]
10 169 ms 169 ms 183 ms dist-02-so-2-0-3-0.spkn.twtelecom.net [66.192.248.27]
11 176 ms 189 ms 168 ms hagg-01-ge-1-3-0-508.spkn.twtelecom.net [66.192.248.169]
12 173 ms 167 ms 167 ms 66.193.134.54
13 171 ms 166 ms 218 ms c1-gige-b1.llix.net [65.61.96.2]
14 171 ms 208 ms 199 ms rochess.net [66.206.9.16]

For Dobby

ALTER PROCEDURE dbo.GetHumanByID
@ID int
AS
DECLARE @ROLES int
SELECT Humans.Email, Hgeneral.ImageGroup, Hgeneral.AddressGroup, Hgeneral.Flags, Hgeneral.FriendlyName, Hgeneral.Title, Hgeneral.FirstName, Hgeneral.SirName,
Hgeneral.Salutation, Hgeneral.Roles
FROM Humans INNER JOIN
Hgeneral ON Humans.PKId = Hgeneral.Hid
WHERE (Hgeneral.Hid = @ID)
SET @ROLES = (SELECT Hgeneral.Roles From Humans INNER JOIN HGeneral ON Humans.PKId =
HGeneral.Hid WHERE (Humans.PKID = @ID))
SELECT Htenants.PKId, Htenants.Cid, 'Tenant' AS Role, Htenants.Flags, Htenants.Created, Htenants.LastAccessed, Htenants.PassExpiresON,
Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country,
Address.Post_Zip
FROM Htenants INNER JOIN
Companys ON Htenants.Cid = Companys.PKId INNER JOIN
Buildings ON Htenants.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 1 & @ROLES) = 1) AND (Htenants.Hid = @ID)
UNION
SELECT Hagents.PKId, Hagents.Cid, 'Agent' AS Role, Hagents.Flags, Hagents.Created, Hagents.LastAccessed, Hagents.PassExpiresON,
Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.County_State, Address.Town, Address.Country,
Address.Post_Zip
FROM Hagents INNER JOIN
Companys ON Hagents.Cid = Companys.PKId INNER JOIN
Buildings ON Hagents.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 2 & @ROLES) = 2) AND (Hagents.Hid = @ID)
UNION
SELECT HLandLord.PKId, HLandLord.Cid, 'LandLord' AS Role, HLandLord.Flags, HLandLord.Created, HLandLord.LastAccessed, HLandLord.PassExpiresON,
Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country,
Address.Post_Zip
FROM HLandLord INNER JOIN
Companys ON HLandLord.Cid = Companys.PKId INNER JOIN
Buildings ON HLandLord.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 4 & @ROLES) = 4) AND (HLandLord.Hid = @ID)
UNION
SELECT Hcontractors.PKId, Hcontractors.Cid, 'Contractor' AS Role, Hcontractors.Flags, Hcontractors.Created, Hcontractors.LastAccessed,
Hcontractors.PassExpiresON, Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town,
Address.County_State, Address.Country, Address.Post_Zip
FROM Hcontractors INNER JOIN
Companys ON Hcontractors.Cid = Companys.PKId INNER JOIN
Buildings ON Hcontractors.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 8 & @ROLES) = 8) AND (Hcontractors.Hid = @ID)
UNION
SELECT HLeaseHolder.PKId, HLeaseHolder.Cid, 'LeaseHolder' AS Role, HLeaseHolder.Flags, HLeaseHolder.Created, HLeaseHolder.LastAccessed, HLeaseHolder.PassExpiresON,
Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country,
Address.Post_Zip
FROM HLeaseHolder INNER JOIN
Companys ON HLeaseHolder.Cid = Companys.PKId INNER JOIN
Buildings ON HLeaseHolder.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 16 & @ROLES) = 16) AND (HLeaseHolder.Hid = @ID)
UNION
SELECT HFreeHolder.PKId, HFreeHolder.Cid, 'FreeHolder' AS Role, HFreeHolder.Flags, HFreeHolder.Created, HFreeHolder.LastAccessed, HFreeHolder.PassExpiresON,
Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country,
Address.Post_Zip
FROM HFreeHolder INNER JOIN
Companys ON HFreeHolder.Cid = Companys.PKId INNER JOIN
Buildings ON HFreeHolder.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 32 & @ROLES) = 32) AND (HFreeHolder.Hid = @ID)
UNION
SELECT Hother.PKId, Hother.Cid, Hother.Role, Hother.Flags, Hother.Created, Hother.LastAccessed, Hother.PassExpiresON,
Companys.PKId AS CompanyID, Companys.Name AS CName, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country,
Address.Post_Zip
FROM Hother INNER JOIN
Companys ON Hother.Cid = Companys.PKId INNER JOIN
Buildings ON Hother.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE ((SELECT 32 & @ROLES) = 64) AND (Hother.Hid = @ID)
IF (EXISTS(SELECT Companys.PKId
FROM Companys INNER JOIN
CompanyEmployees ON Companys.PKId = CompanyEmployees.CId INNER JOIN
Humans ON CompanyEmployees.HId = Humans.PKId
WHERE (Humans.PKId = @ID)))
Begin
DECLARE @CID int
DECLARE @ROWNUM INT
DECLARE LIST cursor for
SELECT Companys.PKId FROM Companys INNER JOIN
CompanyEmployees ON Companys.PKId = CompanyEmployees.CId INNER JOIN
Humans ON CompanyEmployees.HId = Humans.PKId
WHERE (Humans.PKId = @ID)
OPEN LIST
FETCH NEXT FROM LIST
INTO @CID
SET @ROWNUM = 0
WHILE @@FETCH_STATUS = 0
BEGIN
set @RowNum = @RowNum + 1
SET @ROLES = (SELECT Roles FROM Companys WHERE (PKId = @CID))
SELECT Htenants.PassExpiresON, Htenants.Created, 'Tenenant' AS Role, Htenants.LastAccessed, Htenants.Flags, Htenants.Cid, Companys.Name,
Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country, Address.Post_Zip
FROM Buildings INNER JOIN
Htenants INNER JOIN
Companys ON Htenants.Cid = Companys.PKId ON Buildings.PKId = Htenants.BuildingID INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (Htenants.Cid = @CID) AND
((SELECT 1 & @ROLES) = 1)
UNION
SELECT HLandLord.PassExpiresON, HLandLord.Created, 'LandLord' AS Role, HLandLord.LastAccessed, HLandLord.Flags, HLandLord.Cid, Companys.Name,
Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country, Address.Post_Zip
FROM HLandLord INNER JOIN
Companys ON HLandLord.Cid = Companys.PKId INNER JOIN
Buildings ON HLandLord.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (HLandLord.Cid = @CID) AND
((SELECT 2 & @ROLES) = 2)
UNION
SELECT Hcontractors.PassExpiresON, Hcontractors.Created, 'Contractor' AS Role, Hcontractors.LastAccessed, Hcontractors.Flags, Hcontractors.Cid,
Companys.Name, Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country,
Address.Post_Zip
FROM Hcontractors INNER JOIN
Companys ON Hcontractors.Cid = Companys.PKId INNER JOIN
Buildings ON Hcontractors.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (Hcontractors.Cid = @CID) AND
((SELECT 4 & @ROLES) = 4)
UNION
SELECT Hagents.PassExpiresON, Hagents.Created, 'Agent' AS Role, Hagents.LastAccessed, Hagents.Flags, Hagents.Cid, Companys.Name,
Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country, Address.Post_Zip
FROM Hagents INNER JOIN
Companys ON Hagents.Cid = Companys.PKId INNER JOIN
Buildings ON Hagents.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (Hagents.Cid = @CID) AND
((SELECT 8 & @ROLES) = 8)
UNION
SELECT HLeaseHolder.PassExpiresON, HLeaseHolder.Created, 'LeaseHolder' AS Role, HLeaseHolder.LastAccessed, HLeaseHolder.Flags, HLeaseHolder.Cid, Companys.Name,
Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country, Address.Post_Zip
FROM HLeaseHolder INNER JOIN
Companys ON HLeaseHolder.Cid = Companys.PKId INNER JOIN
Buildings ON HLeaseHolder.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (HLeaseHolder.Cid = @CID) AND
((SELECT 16 & @ROLES) = 16)
UNION
SELECT HFreeHolder.PassExpiresON, HFreeHolder.Created, 'FreeHolder' AS Role, HFreeHolder.LastAccessed, HFreeHolder.Flags, HFreeHolder.Cid, Companys.Name,
Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country, Address.Post_Zip
FROM HFreeHolder INNER JOIN
Companys ON HFreeHolder.Cid = Companys.PKId INNER JOIN
Buildings ON HFreeHolder.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (HFreeHolder.Cid = @CID) AND
((SELECT 32 & @ROLES) = 32)
UNION
SELECT Hother.PassExpiresON, Hother.Created, Hother.Role, Hother.LastAccessed, Hother.Flags, Hother.Cid, Companys.Name,
Buildings.PKId AS BuildingID, Buildings.BuildingName,Address.PKId AS AddressID, Address.Line1, Address.Line2, Address.Town, Address.County_State, Address.Country, Address.Post_Zip
FROM Hother INNER JOIN
Companys ON Hother.Cid = Companys.PKId INNER JOIN
Buildings ON Hother.BuildingID = Buildings.PKId INNER JOIN
Address ON Buildings.AddressID = Address.PKId
WHERE (Hother.Cid = @CID) AND
((SELECT 64 & @ROLES) = 64)
FETCH NEXT FROM LIST
INTO @CID
END
CLOSE LIST
DEALLOCATE LIST
End
RETURN

FrinBin, of my PlanetSide Outfit, is a dirty cheat...

Proof you want? :)






117,500 extra to start off with, is alot in the start of the game.

PZY

Hand me a Crook Of Llama herding +9!


#asp

[15:30:40] * Joins: adamJONES (WWE@host81-154-87-212.range81-154.btcentralplus.com)
[15:30:42] <adamJONES> HELLO?
[15:30:44] <adamJONES> is any1 here
[15:30:55] <Crusher_> YES
[15:30:56] <@PZYCOMAN> HALLO!
[15:30:58] <adamJONES> hey
[15:31:01] <adamJONES> plz write me a script
[15:31:04] <adamJONES> that is a dice
[15:31:04] * Mr_Jobe is now known as int32
[15:31:13] <Crusher_> do you spit?
[15:31:16] <adamJONES> me?
[15:31:17] <adamJONES> ????????
[15:31:23] <@PZYCOMAN> Spit or swallow?
[15:31:28] <adamJONES> shut up
[15:31:34] <adamJONES> please can u write me a dice
[15:31:46] <@PZYCOMAN> plz j3j3j3 m8 spit or swallow?
[15:31:57] <adamJONES> i dont do either
[15:32:15] <adamJONES> HELLO????????????????????????????????????????????????
[15:32:17] <@PZYCOMAN> Crusher_ i pay for a 1mbit line :) but during the day i get insane speeds :) (and late nights)
[15:32:24] <@PZYCOMAN> HAALO adamJONES M8!!111111111111
[15:32:29] <adamJONES> hi
[15:32:33] <adamJONES> please write it
[15:32:35] <adamJONES> it wont take long
[15:32:36] <@PZYCOMAN> pay me
[15:32:48] <adamJONES> no I cant
[15:32:49] <adamJONES> please
[15:32:51] <adamJONES> it wont take ong
[15:32:52] <adamJONES> long
[15:32:55] <@PZYCOMAN> Then i cant write it :)
[15:33:42] <adamJONES> bye
[15:33:43] * Parts: adamJONES (WWE@host81-154-87-212.range81-154.btcentralplus.com)

And then in #html

[15:32:18] * Joins: adamJONES (WWE@host81-154-87-212.range81-154.btcentralplus.com)
[15:32:19] <adamJONES> HELLO?
[15:32:21] <adamJONES> IS ANYONE HERE
[15:32:26] <davek> plenty, lose the caps
[15:32:39] <adamJONES> hey
[15:32:42] <adamJONES> do u know PHP OR ASP
[15:32:56] <@drole> you taking a survey?
[15:32:59] <davek> #php or #asp do, people will complain about being off topic if you ask in here
[15:33:05] <adamJONES> no they dont asnwer me
[15:33:11] <adamJONES> plz can u write me a script taht is a dacie
[15:33:15] <adamJONES> sorry that is a dice
[15:33:15] <@drole> hehe
[15:33:33] <adamJONES> it wont take long plz
[15:33:43] <@drole> it won't take you long? ok, I'll wait.
[15:33:51] <adamJONES> no i cant script
[15:33:53] <adamJONES> i want to show someon
[15:33:54] <adamJONES> e
[15:33:57] <adamJONES> please do it for me
[15:34:06] <@drole> oh, ok, well, sure, let me just give you the address to send the check to.
[15:34:30] <adamJONES> no i dont have credit card
[15:34:39] <PZYCOMAN> adamJONES wants us to write him a script for free :
[15:34:44] <PZYCOMAN> and hes rude about it, lol
[15:34:48] <adamJONES> no i am not
[15:34:51] <davek> <?php echo rand( 1, 6 ); ?>
[15:34:53] <adamJONES> i asked nicely
[15:34:59] <adamJONES> yeah can u put it in a file
[15:35:02] <PZYCOMAN> [15:31:28] <adamJONES> shut up
[15:35:04] <adamJONES> cuz I cant do anything scripting
[15:35:08] <PZYCOMAN> Thats not nicely is it?
[15:35:11] <@drole> ahh, asking nicely puts the food on the table everytime.
[15:35:11] <adamJONES> cuz u asked me if i spit or slwllow
[15:35:22] <@drole> hehe
[15:35:22] <adamJONES> i did ask nicely
[15:35:24] <PZYCOMAN> And you asked me to write you a script for free
[15:35:28] <adamJONES> ya
[15:35:30] <PZYCOMAN> You dont get something for nothing
[15:35:30] <adamJONES> it wont take ling
[15:35:39] <adamJONES> u suck
[15:35:42] <davek> stop argueing and you will see your script adamJONES
[15:35:43] <adamJONES> it takes 2 mins
[15:35:44] <@drole> that is true...well, except at soup kitchens
[15:35:52] <adamJONES> ?????????????????????????????????????????????????????????????????????
[15:35:58] <PZYCOMAN> If it takes 2 mins
[15:36:00] <PZYCOMAN> why dont you do it?
[15:36:06] * X sets mode: +b *!*WWE@*.range81-154.btcentralplus.com
[15:36:06] * adamJONES was kicked by X ((daveak) scroll up, I gave it, and goodbye)

j3j3j3j3 m8z!

GenerateConnection gc = new GenerateConnection();
SqlConnection sc = gc.GetConnection();
ds_users dset = new ds_users();
SqlCommand cmd = new SqlCommand("bugtracker_getloginfromemail",sc);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Parameters.Add("@Username",SqlDbType.Text,50).Value = "root@unauthorised-access.com";//username.Trim();
cmd.Parameters.Add("@Password",SqlDbType.Text,50).Value = "Bacongo";//password.Trim();

da.Fill(dset);
return dset;

CREATE PROCEDURE bugtracker_getloginfromemail
@Username Varchar(50),
@Password Varchar(50)
As
SELECT * FROM USERS WHERE USER_EMAIL='@Username' AND User_Password='@Password'
GO

Test