--- trunk/FlisServer/FlisServerDlg.cpp	2007/12/02 12:03:03	121
+++ trunk/FlisServer/FlisServerDlg.cpp	2007/12/03 09:22:26	130
@@ -252,7 +252,7 @@
 		CString tekst;
 		std::vector<unsigned char> answer = readFrame();
 		Sleep(50);
-			char array1[25];
+			char array1[150];
 			int i;
 			for (int i=0; i<answer.size(); i++)
 			{
@@ -302,8 +302,8 @@
 void CFlisServerDlg::DBConnect()
 {
 	CString dsn;
-	dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=t-hoerup.dk; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");
-	//dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");   //skole server
+	//dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=t-hoerup.dk; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");	//Torben
+	dsn.Format("ODBC;Description=asd;DRIVER=PostgreSQL ANSI;SERVER=192.168.134.132; uid=serrenab;password=furnacemonitor;database=flisfyr;sslmode=prefer");   //skole server
 	db.OpenEx(dsn, CDatabase::noOdbcDialog);
 }
 vector<Commands> CFlisServerDlg::DBRead(void)
@@ -319,17 +319,17 @@
 		rs.MoveFirst();
 		while(!rs.IsEOF())
 		{
-		Commands Mycom;
-		rs.GetFieldValue((short)0, IDnr);
-		rs.GetFieldValue(3, CommandID);
-		rs.GetFieldValue(4, InstallationsID);
-		
-		Mycom.IDnr = IDnr;
-		Mycom.CommandID = CommandID;
-		Mycom.InstallationsID = InstallationsID;
+			Commands Mycom;
+			rs.GetFieldValue((short)0, IDnr);
+			rs.GetFieldValue(3, CommandID);
+			rs.GetFieldValue(4, InstallationsID);
+			
+			Mycom.IDnr = IDnr;
+			Mycom.CommandID = CommandID;
+			Mycom.InstallationsID = InstallationsID;
 
-		buffer.push_back(Mycom);
-		rs.MoveNext();
+			buffer.push_back(Mycom);
+			rs.MoveNext();
 		}
 	}
 	rs.Close();
@@ -612,8 +612,9 @@
 		if (continueThread = 1)
 		{
 			
-			////////////////DBRead stuff//////////////////
 			CString testdata, dataframe,testprint, sIDnr, sCommandID, sInstallationsID, sImei;
+			int commandtest = 0;
+			int iAll = 1;
 			std::vector<Commands> data;
 			data = DBRead();
 			for (int i=0; i<data.size(); i++)
@@ -622,39 +623,54 @@
 				testdata.Append(":");
 				testdata.Append(data[i].CommandID);
 				testdata.Append(":");
+				commandtest = atoi(data[i].CommandID);
+
+				if(commandtest > 1)
+				{
 				testdata.Append(data[i].InstallationsID);
 				testdata.Append(":");
+				}
 			}
 			sIDnr = Splitter(testdata);
 			sCommandID = Splitter(testdata);
+			sInstallationsID = "0";
+			if (commandtest > 1)
+			{
 			sInstallationsID = Splitter(testdata);
+			iAll = 0;
+			}
 
 			if (sIDnr.GetLength() > 0)
 			{
 				DBReadData(sIDnr,sCommandID,sInstallationsID);
 			}
 			Sleep(500);
-			////////////////DBRead stuff//////////////////	
 		}
 }
 void CFlisServerDlg::DBReadData(CString IDnr,CString CommandID,CString InstallationsID)
 {
-	CString TlfNr, Imei, ServerTlfNr, updaterate;
-
+	CString ServerTlfNr;
+	int i = 0;
 	ServerTlfNr = "29860132";
 		
-	//kald dbreadphone som du kalder dbread
+	
 	std::vector<Installation> inst;
 	inst = DBReadPhone(InstallationsID);
-	for (int i=0; i<inst.size(); i++)
+	while (i < inst.size())
 	{
+		CString TlfNr, Imei, updaterate;
+		TlfNr.Empty();
+		Imei.Empty();
+		updaterate.Empty();
+
 		CString dataen = inst[i].InstPhoneNr;
 		TlfNr.Append(dataen);
 		CString Imeidata = inst[i].Imei;
 		Imei.Append(Imeidata);
 		CString updaterat = inst[i].Updaterate;
 		updaterate.Append(updaterat);
-	}
+		i++;
+	
 	vector<unsigned char> tlfnr;
 	for (int i=0; i<TlfNr.GetLength(); i++)
 	{
@@ -662,8 +678,7 @@
 	}
 	
 	int calcimei; 
-	double buf;
-	Imei.Remove('0');
+	__int64 buf;
 
 	buf = atof(Imei);
 	
@@ -672,8 +687,8 @@
 	Imei.Format("%d",calcimei);
 	
 	SendSmsHead(tlfnr);
-	Sleep(500);
-	//35:29860132:75 <--- demo pakke;
+	Sleep(250);
+	
 	vector<unsigned char> smsdata;
 	
 	for (int i=0; i<Imei.GetLength(); i++)
@@ -692,13 +707,17 @@
 	}
 
 	SendSmsData(smsdata);
-	Sleep(250);
-
-	CString SQL;
-
-	SQL.Format("update command set executed=now() where id=%s",IDnr);
-	db.ExecuteSQL(SQL);
-	Sleep(150);
+	Sleep(500);
+	
+	}
+		CString SQL, Textwindow;
+		SQL.Format("update command set executed=now() where id=%s",IDnr);
+		db.ExecuteSQL(SQL);
+		m_Textwindow.GetWindowText(Textwindow);
+		Textwindow.Append("\r\n");
+		Textwindow.Append("Command executed");
+		m_Textwindow.SetWindowText(Textwindow);
+		Sleep(150);
 
 }
 vector<Installation> CFlisServerDlg::DBReadPhone(CString sInstallationsID)
@@ -706,7 +725,17 @@
 	vector<Installation> buffer;
 
 	CString SQL, phonenr, imei, updaterate;
-	SQL.Format("select installationphonenr, imei, updaterate from installation WHERE id = %s",sInstallationsID);
+	int installernull;
+	Installation Myinst;
+	installernull = atoi(sInstallationsID);
+	if (installernull > 1)
+	{
+		SQL.Format("select installationphonenr, imei, updaterate from installation WHERE id = %s", sInstallationsID);
+	}
+	else if(installernull < 2)
+	{
+		SQL.Format("select installationphonenr, imei, updaterate from installation");
+	}
 	CRecordset rs(&db);
 	rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
 	if (rs.GetRecordCount()>0) 
@@ -714,23 +743,23 @@
 		rs.MoveFirst();
 		while(!rs.IsEOF())
 		{
-		Installation Myinst;
-		rs.GetFieldValue((short)0,phonenr);
-		rs.GetFieldValue(1,imei);
-		rs.GetFieldValue(2,updaterate);
-
-		Myinst.InstPhoneNr.Append(phonenr);
-		Myinst.Imei.Append(imei);
-		Myinst.Updaterate.Append(updaterate);
+		
+			rs.GetFieldValue((short)0,phonenr);
+			rs.GetFieldValue(1,imei);
+			rs.GetFieldValue(2,updaterate);
+
+			Myinst.InstPhoneNr = phonenr;
+			Myinst.Imei = imei;
+			Myinst.Updaterate = updaterate;
 
-		buffer.push_back(Myinst);
-		rs.MoveNext();
+			buffer.push_back(Myinst);
+			rs.MoveNext();
 		}
 	}
 	rs.Close();
 	return buffer;
 }
-int CFlisServerDlg::tversum(unsigned input)
+int CFlisServerDlg::tversum(__int64 input)
 {
 	int sum = 0;
 	while (input > 0)