public static ArrayList GetWebBookMarks(string serverPath,string clientID, MySqlWrapper dbConn)
{
ArrayList webBookmarks = new ArrayList();
try
{
string sql = "select bookmark_title,bookmark_url from ctool_bookmark where bookmark_ownerid = " + clientID;
ArrayList recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebBookMark entry = new WebBookMark((string)record[0],(string)record[1]);
webBookmarks.Add(entry);
}
sql = "select bookmark_title,bookmark_url from ctool_bookmark,ctool_bmtouser where bookmark_id = bmtouser_bookmark_id AND bmtouser_mid = " + clientID;
recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebBookMark entry = new WebBookMark((string)record[0],(string)record[1]);
webBookmarks.Add(entry);
}
}
catch(Exception ee)
{
// MessageBox.Show(ee.Message);
}
return webBookmarks;
}
public WebEvaluations(MySqlWrapper dbConn)
{
dbCon = dbConn;
}
public static ArrayList GetWebPresentations(string serverPath,string clientID, MySqlWrapper dbConn)
{
ArrayList WebPresentations = new ArrayList();
try
{
string sql = "select presentation_title,Concat(presentation_id,presentation_url) from ctool_presentation where presentation_ownerid = " + clientID;
ArrayList recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebPresentationEntry entry = new WebPresentationEntry((string)record[0],serverPath + record[1]);
WebPresentations.Add(entry);
}
sql = "select presentation_title,Concat(presentation_id,presentation_url),pretouser_presentation_id from ctool_presentation,ctool_pretouser WHERE presentation_id = pretouser_presentation_id AND pretouser_mid = " + clientID;
recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebPresentationEntry entry = new WebPresentationEntry((string)record[0],serverPath + record[1]);
WebPresentations.Add(entry);
}
}
catch(Exception ee)
{
// MessageBox.Show(ee.Message);
}
return WebPresentations;
}
public WebPolls(MySqlWrapper dbConn)
{
dbCon = dbConn;
}
public static ArrayList GetWebFiles(string serverPath,string clientId,MySqlWrapper dbConn)
{
ArrayList WebFiles = new ArrayList();
try
{
string sql = "select Concat(uploads_id,uploads_url) as FilePath,uploads_title from ctool_uploads where uploads_ownerid= " + clientId;
ArrayList recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebUploadedFiles file = new WebUploadedFiles((string)record[1],serverPath + record[0]);
WebFiles.Add(file);
}
sql = "select Concat(uploads_id,uploads_url) as FilePath,uploads_title from ctool_uploads,ctool_uploadstouser where uploads_id = uploadstouser_uploads_id AND uploadstouser_mid = " + clientId;
recordset = dbConn.Execute(sql);
foreach(ArrayList record in recordset)
{
WebUploadedFiles file = new WebUploadedFiles((string)record[1],serverPath + record[0]);
WebFiles.Add(file);
}
}
catch(Exception ee)
{
// MessageBox.Show("We Integration " + ee.Message);
}
return WebFiles;
}
/// <summary>
/// this Constructor do the following things
/// 1-Set Configurations
/// 2-Connect to db
/// 3-Start Logging Thread
/// 4-Start thFlushMemory Thread
/// </summary>
public ConferenceServer()
{
/*
* loading configuration files
* */
getConfig();
dbCon=new MySqlWrapper();
dbCon.Connect(databaseServer,databaseUsername,databasePassword);
dbCon.SelectDB("ctool");
staticServerInstance = this;
#if TESTING
Console.Write(databaseServer + " " + databaseUsername + " "+ databasePassword);
#endif
// insertFlowThread = new Thread(new ThreadStart(insertFlowMessages));
// insertFlowThread.Name = "insertFlowThread Thread : ConferenceServer()";
// insertFlowThread.Start();
//
// thread free all extra resorces after specific time Kamran
Thread thFlushMemory = new Thread(new ThreadStart(overallFlushMemory)); //per2
thFlushMemory.Name = "overallFlushMemory Thread : ConferenceServer";//per2
thFlushMemory.Start();//per2
}