START TRANSACTION;
SET CHARACTER SET cp1251;
COMMIT;

Add(MainForm,12739774,21,77)
{
 Width=811
 Height=616
}
Add(DS_MySQL,16500094,175,126)
{
 Name="baze"
 Server="heliohost.org"
 Username="kpb740_hiasm"
 Password="onlyforhiasmusers"
 DBName="kpb740_test"
 link(onOpen,14309764:doEvent,[])
}
Add(FormatStr,7850451,293,224)
{
 DataCount=1
 Mask="SELECT name, pass, email, icq, date, total FROM users WHERE name = '%1'"
 link(onFString,3736019:doQuery,[])
 link(Str1,189132:Var1,[(299,208)])
}
Add(DSC_Query,3736019,336,224)
{
 DSManager="baze"
 link(onQuery,15290198:doEvent,[])
}
Add(FormatStr,5501671,388,308)
{
 DataCount=7
 Mask="INSERT INTO `baned` (`user_id`, `name`, `pass`, `email`, `icq`, `date`, `total`, `who`, `ban_date`) VALUES (NULL, '%1', '%2', '%3', '%4', '%5', '%6', '%7', CURDATE());"
 link(onFString,5813092:doExec,[])
 link(Str1,4120447:Value1,[])
 link(Str2,4120447:Value2,[])
 link(Str3,4120447:Value3,[])
 link(Str4,4120447:Value4,[])
 link(Str5,4120447:Value5,[])
 link(Str6,4120447:Value6,[])
 link(Str7,189132:Var2,[])
}
Add(DSC_Exec,5813092,464,308)
{
 DSManager="baze"
}
Add(GlobalVarEx,14764252,430,185)
{
 Name="name"
 Data=String(Вася)
}
Add(DSC_Exec,12775326,294,168)
{
 SQL="SET CHARACTER SET cp1251;"
 DSManager="baze"
 link(onExec,2566426:doEvent,[])
}
Add(Button,277056,18,130)
{
 Left=10
 Top=20
 link(onClick,9079224:doEvent1,[])
}
Add(Hub,9079224,75,130)
{
 link(onEvent1,16500094:doOpen,[(107,136)(107,132)])
 link(onEvent2,16500094:doSelectDB,[(107,143)(107,146)])
}
Add(DSC_Exec,3142860,366,371)
{
 DSManager="baze"
 link(onExec,4518120:doEvent,[])
}
Add(FormatStr,11798996,304,371)
{
 DataCount=1
 Mask="DELETE FROM users WHERE name='%1'"
 link(onFString,3142860:doExec,[])
 link(Str1,189132:Var3,[(310,208)])
}
Add(GetDataEx,189132,430,203)
{
 link(Data,14764252:Var,[])
}
Add(DSC_Exec,5660887,303,420)
{
 SQL="COMMIT;"
 DSManager="baze"
 link(onExec,2330868:doEvent,[])
}
Add(LineBreak,16138944,119,133)
{
 Caption="off"
 Color=255
 link(Out,16500094:doClose,[])
 Primary=[12285549,262,287]
}
Add(DSC_Exec,8042473,294,126)
{
 SQL="START TRANSACTION;"
 DSManager="baze"
 link(onExec,16304908:doEvent,[])
}
Add(MT_MultiMem,4120447,388,224)
{
 Count=6
 link(onData,5501671:doString,[(445,230)(445,272)(376,272)(376,314)])
}
Add(Debug,15290198,372,224)
{
 WEName="onQuery"
 link(onEvent,4120447:doValue,[])
}
Add(Debug,16304908,357,126)
{
 WEName="START TRANSACTION"
}
Add(Debug,2566426,357,168)
{
 WEName="SET CHARACTER"
}
Add(Debug,14309764,213,126)
{
 WEName="onOpen"
 link(onEvent,14332213:doEvent1,[])
}
Add(Hub,14332213,239,126)
{
 OutCount=5
 link(onEvent1,8042473:doExec,[])
 link(onEvent2,12775326:doExec,[(288,139)(288,174)])
 link(onEvent3,7850451:doString,[(273,146)(273,230)])
 link(onEvent4,11798996:doString,[(279,153)(279,377)])
 link(onEvent5,5660887:doExec,[(278,160)(278,426)])
}
Add(Debug,4518120,406,371)
{
 WEName="onExec1"
}
Add(Debug,2330868,350,420)
{
 WEName="COMMIT"
 link(onEvent,12285549:In,[])
}