[Slowchat #198] Waar JortK en Wyri een geheim plan hadden!

quote:

Op woensdag 28 november 2007 22:44 schreef WyriHaximus het volgende:
Die TT

quote:

Op woensdag 28 november 2007 22:44 schreef mschol het volgende:
de TT?

quote:

Op woensdag 28 november 2007 22:45 schreef WyriHaximus het volgende:

[..]

Ik zeg niks, laat ze het maar raden

quote:

Op woensdag 28 november 2007 22:50 schreef WyriHaximus het volgende:

[..]

quote:

Op woensdag 28 november 2007 22:54 schreef WyriHaximus het volgende:
Mare me pingback werkt naja half moet nog wat laten zien op de site .
Dus het is bed tijd, wel truste allemaal .

quote:

Op donderdag 29 november 2007 07:28 schreef phluphy het volgende:
En voor de mensen met een ochtendhumeur: GOEDEMORGEN!

quote:

Op donderdag 29 november 2007 09:17 schreef Godlike02 het volgende:
Slowchats

quote:

Op donderdag 29 november 2007 09:43 schreef FredvZ het volgende:

[..]



De oplossing voor mijn ochthumeur bevind zich in deze omstreken:http://maps.google.nl/maps?ie=UTF8&hl=nl&ll=51.978748,4.771843&spn=0.103409,0.2314&z=12&om=1

quote:

Op donderdag 29 november 2007 09:58 schreef FredvZ het volgende:

[..]

Oorzaak ook. Oplossing ook.

quote:

Op donderdag 29 november 2007 10:08 schreef FredvZ het volgende:
En als ik ergens mezelf gek mee kan maken dan is het wel afwachten zonder iets te kunnen doen.

Maar als ik er NU op af ga weet ik zeker dat het einde verhaal is.

quote:

Op donderdag 29 november 2007 10:35 schreef MPG het volgende:
je eigen naamtopic aanmaken

quote:

Op donderdag 29 november 2007 10:46 schreef FredvZ het volgende:

[..]


[..]

Ja&ja

Maar moeilijk.


Word er nog cryptisch van ook.

quote:

Op donderdag 29 november 2007 10:50 schreef MPG het volgende:

[..]

zit wat in...

quote:

Op donderdag 29 november 2007 10:58 schreef MPG het volgende:

[..]

ik kwam even op de koffie.
ik lees vaker mee in DIG-topics, maar post niet zo veel hier
enja, je eigen naamtopic trok wel even mijn aandacht

quote:

Op donderdag 29 november 2007 11:06 schreef BlueCurl het volgende:

[..]

Naamtopics

quote:

Op donderdag 29 november 2007 11:50 schreef FredvZ het volgende:

[..]

&nbps;

quote:

Op donderdag 29 november 2007 11:50 schreef FredvZ het volgende:
(ben er stil van)

quote:

Op donderdag 29 november 2007 11:59 schreef Geqxon het volgende:
O wacht, dat was het toch niet. Maar na het slopen van de Content-Length header werkt hij nu wel weer prima.

Heel erg eng dit

quote:

Op donderdag 29 november 2007 14:26 schreef WyriHaximus het volgende:
[ link | afbeelding ]

quote:

Op donderdag 29 november 2007 14:46 schreef WyriHaximus het volgende:

[..]

Deze dan:
[ link | afbeelding ]

quote:

Op donderdag 29 november 2007 15:51 schreef BlueCurl het volgende:

[..]

komt omdat als ze een echt ip doen iedereen dat IP gaat lastig vallen.. d'oh maar die was al heel lang bekend!

quote:

Op donderdag 29 november 2007 16:04 schreef Geqxon het volgende:
Hollywood had veel beter een klasse A range kunnen kopen.

quote:

Op donderdag 29 november 2007 16:49 schreef FredvZ het volgende:
Nu we toch in een "stem op mij"-bui zijn: [FOK!Awards 2007] Crew & FOK!

quote:

Op vrijdag 30 november 2007 08:46 schreef Sjowhan het volgende:
Mogge

quote:

Op vrijdag 30 november 2007 09:09 schreef mschol het volgende:
morghe

vandaag maar eens verder kutten met VB.net aangezien ik een aantal dingen voorelkaar heb waar ik wel blij mee ben (o.a een fatsoenlijkere manier om met mysql te communiceren)

quote:

SELECT TOP 1 kstplcode FROM kstpl ORDER BY KSTPLCODE
go
exec sp_executesql N'SELECT kstplcode FROM kstpl WHERE kstplcode=@P1', N'@P1 varchar(2)', '04'
go
exec sp_execute 17, ' 9400'
go
exec sp_executesql N'UPDATE grtbk SET std_kstpl = NULL WHERE reknr = @P1', N'@P1 varchar(9)', ' 9400'
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go
SELECT ID FROM grtbk WHERE reknr =' 9400'
go
exec sp_executesql N'SELECT 1 FROM Items WHERE ItemToBeReceivedLedger IS NOT NULL AND ItemToBeReceivedLedger = @P1 ', N'@P1 varchar(9)', ' 9400'
go
exec sp_executesql N'SELECT 1 FROM ItemAssortment WHERE ItemToBeReceivedLedger IS NOT NULL AND ItemToBeReceivedLedger = @P1 ', N'@P1 varchar(9)', ' 9400'
go
SELECT kstplcode, units FROM Ksprek WHERE reknr = ' 9400'
go
SELECT reknr, oms25_0 AS Description FROM grtbk WHERE reknr <> ' 9400' AND Class_01 = '4' AND Class_02 = '19' AND Class_03 = '39' AND Class_04 = '<none>' AND Class_05 = '<none>'
go
exec sp_executesql N'SELECT reknr FROM grtbk WHERE ID=@P1', N'@P1 int', 235
go
exec sp_executesql N'SELECT reknr FROM grtbk WHERE CompanyCode=@P1 AND reknr IS NULL AND ID<>@P2', N'@P1 varchar(3),@P2 int', '999', 235
go
UPDATE grtbk SET kstplrek = 1,sysmodified = {ts '2007-11-30 11:44:20.000'} WHERE ID = 235
go
exec ebcLogUpdate 0x8AA9F398857A7146B7FDDFD248767EAC, 0x0AE95C3EBEFD26498532CC79C76E0040, '235', 0, 1, 1
go
exec ebcLogUpdate 0x8AA9F398857A7146B7FDDFD248767EAC, 0x077FCF375BE44F4BAEA4FC4BC428D311, '235', NULL, NULL, 1
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go
exec sp_execute 2, 235
go
exec sp_execute 2, 235
go
SELECT TOP 1 ID FROM grtbk ORDER BY reknr
go
SELECT TOP 1 ID FROM grtbk ORDER BY reknr DESC
go
SELECT ID From hrcomponents WHERE ledger_account = ' 9400' AND (((blocked=0 AND comp_status<>'I') AND (startdate<=GETDATE() AND (enddate IS NULL OR enddate>=GETDATE()))) OR (comp_status='I' AND blocked=0) ) AND (comp_visible='V' OR comp_status='C') AND country= 'NL' AND comp_type NOT IN ('M','L')
go
SELECT SUM(CASE WHEN bdr_hfl > 0 THEN bdr_hfl ELSE 0 END) AS DebitAmount
,SUM(CASE WHEN bdr_hfl < 0 THEN -bdr_hfl ELSE 0 END) AS CreditAmount
, SUM(CASE WHEN verwerknrl > 0 AND bdr_hfl > 0 THEN 1 ELSE 0 END) AS ProcessedDebitCount
,SUM(CASE WHEN verwerknrl > 0 AND bdr_hfl < 0 THEN 1 ELSE 0 END) AS ProcessedCreditCount
, SUM(CASE WHEN verwerknrl = 0 AND bdr_hfl > 0 THEN 1 ELSE 0 END) AS UnprocessedDebitCount
,SUM(CASE WHEN verwerknrl = 0 AND bdr_hfl < 0 THEN 1 ELSE 0 END) AS UnprocessedCreditCount
FROM gbkmut WHERE reknr = ' 9400' AND transtype IN ('N','C','P') AND bud_vers IS NULL
go
SELECT TOP 1 gbkmut.datum FROM gbkmut WHERE reknr = ' 9400' ORDER BY gbkmut.datum DESC
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(1)', '1', '4'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 1) foo WHERE col_ID=@P1', N'@P1 int', 14
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(2)', '2', '19'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 2) foo WHERE col_ID=@P1', N'@P1 int', 82
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(2)', '3', '39'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 3) foo WHERE col_ID=@P1', N'@P1 int', 102
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(8000)', '4', '<none>'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 4) foo WHERE col_ID=@P1', N'@P1 int', 40
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(8000)', '5', '<none>'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 5) foo WHERE col_ID=@P1', N'@P1 int', 67
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(2)', '6', '20'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 6) foo WHERE col_ID=@P1', N'@P1 int', 128
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(3)', '7', '110'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 7) foo WHERE col_ID=@P1', N'@P1 int', 127
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(3)', '8', '100'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 8) foo WHERE col_ID=@P1', N'@P1 int', 129
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(1),@P2 varchar(4)', '9', '1000'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 9) foo WHERE col_ID=@P1', N'@P1 int', 131
go
exec sp_executesql N'SELECT TOP 1 IDENTITYCOL, Description_0 FROM AccountClasses WHERE ClassID=@P1 AND AccountClassCode=@P2', N'@P1 varchar(2),@P2 varchar(8000)', '10', '<none>'
go
exec sp_executesql N'SELECT 1 FROM (SELECT AccountClasses.IdentID AS col_ID FROM accountclasses WHERE classid = 10) foo WHERE col_ID=@P1', N'@P1 int', 72
go
SET FMTONLY ON SELECT StringValue FROM Settings where 1=2 SET FMTONLY OFF
go
SET FMTONLY ON select SettingGroup, SettingName from Settings where 1=2 SET FMTONLY OFF
go
declare @P1 int
set @P1=23
exec sp_prepexec @P1 output, N'@P1 char(30),@P2 char(30)', N'SELECT StringValue FROM Settings WHERE SettingGroup=@P1 AND SettingName=@P2', 'glacclinks ', 'gk_versch_account '
select @P1
go
exec sp_execute 23, 'glacclinks ', 'gk_paid_prepayments '
go
exec sp_execute 23, 'glacclinks ', 'gk_calcdif_sec_cur '
go
exec sp_execute 23, 'glacclinks ', 'gk_calcdif_sec_cur2 '
go
exec sp_execute 23, 'glacclinks ', 'gk_nto_fakturen '
go
exec sp_execute 23, 'ev_journaal ', 'intern_tegenrek '
go
exec sp_execute 23, 'bank ', 'Bank_Costs '
go
exec sp_execute 23, 'glacclinks ', 'gk_kortingen_vrk '
go
exec sp_execute 23, 'glacclinks ', 'gk_kortingen_ink '
go
exec sp_execute 23, 'glacclinks ', 'gk_betversch_vrk '
go
exec sp_execute 23, 'glacclinks ', 'gk_betversch_ink '
go
exec sp_execute 23, 'glacclinks ', 'gk_kredbeperking_vrk '
go
exec sp_execute 23, 'glacclinks ', 'gk_kredbeperking_ink '
go
exec sp_unprepare 23
go
declare @P1 int
set @P1=24
exec sp_prepexec @P1 output, NULL, N'SELECT ID, valcode, oms30_0 AS oms30 FROM valuta WHERE rekkrsvink = '' 9400'' OR rekkrswink = '' 9400'' OR rekkrsvvrk = '' 9400'' OR rekkrswvrk = '' 9400'' OR rekherw = '' 9400'' OR rekherww = '' 9400'''
select @P1
go
exec sp_unprepare 22
go
SELECT TOP 1 1 From gbkmut WHERE reknr = ' 9400' AND (debnr IS NOT NULL OR crdnr is NOT NULL) AND Transtype IN ('N','C','P')
go
exec sp_executesql N'SELECT TOP 1 1 FROM dagbk WHERE reknr = @P1', N'@P1 varchar(9)', ' 9400'
go
exec sp_executesql N'SELECT TOP 1 1 FROM btwtrs WHERE reknr = @P1 OR rek_btw_vk = @P2', N'@P1 varchar(9),@P2 varchar(9)', ' 9400', ' 9400'
go
exec sp_executesql N'SELECT 1 FROM Items WHERE ItemToBeReceivedLedger IS NOT NULL AND ItemToBeReceivedLedger = @P1 ', N'@P1 varchar(9)', ' 9400'
go
exec sp_executesql N'SELECT 1 FROM ItemAssortment WHERE ItemToBeReceivedLedger IS NOT NULL AND ItemToBeReceivedLedger = @P1 ', N'@P1 varchar(9)', ' 9400'
go
exec sp_execute 17, ' 9400'
go
exec sp_execute 18, ' 9400'
go
exec sp_executesql N'UPDATE grtbk SET kstdrrek = 0 WHERE reknr = @P1', N'@P1 varchar(9)', ' 9400'
go
IF @@TRANCOUNT > 0 COMMIT TRAN
go

quote:

Op vrijdag 30 november 2007 11:51 schreef Geqxon het volgende:

[..]

Zodat het exact goed gaat

quote:

Op vrijdag 30 november 2007 11:52 schreef Scorpie het volgende:
Damn, weer eens weinig te doen hiero