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 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);
}