void Init()
{
_Authorized = false;
_UnityLogo = (Texture2D)Resources.Load("Pwrd_By_Unity_Pri_In_sm", typeof(Texture2D));
_LitteratusLogo = (Texture2D)Resources.Load("Litteratus_Logo_sm", typeof(Texture2D));
_Separator = (Texture2D)Resources.Load("separator", typeof(Texture2D));
_HelpButton = (Texture2D)Resources.Load("help", typeof(Texture2D));
_BrowseButton = (Texture2D)Resources.Load("folder", typeof(Texture2D));
_Username = GetString("username", _Username);
_Password = GetString("password", _Password);
_ActiveWorkbookname = GetString("activeworkbookname", _ActiveWorkbookname);
_ObjDbResourcesDirectory = GetString("objDBResourcesDirectory", _ObjDbResourcesDirectory);
_ObjDbEditorDirectory = GetString("objDBEditorDirectory", _ObjDbEditorDirectory);
_StaticDbResourcesDirectory = GetString("staticDBResourcesDirectory", _StaticDbResourcesDirectory);
_NguiDirectory = GetString("nguiDirectory", _NguiDirectory);
_XmlDirectory = GetString("xmlDirectory", _XmlDirectory);
_JsonDirectory = GetString("jsonDirectory", _JsonDirectory);
_CsvDirectory = GetString("csvDirectory", _CsvDirectory);
_PlaymakerDirectory = GetString("playmakerDirectory", _PlaymakerDirectory);
_DaikonforgeDirectory = GetString("daikonforgeDirectory", _DaikonforgeDirectory);
_EditorLanguage = GetString("editorLanguage", _EditorLanguage);
if (Language.GetLanguageCode(_EditorLanguage) == Language.Code.INVALID)
{
_EditorLanguage = "en";
SetString("editorLanguage", _EditorLanguage);
}
_SaveCredentials = GetBool("saveCredientials", _SaveCredentials);
_AutoLogin = GetBool("autoLogin", _AutoLogin);
_TemporaryAutoLogin = GetBool("temporaryAutoLogin", _TemporaryAutoLogin);
_UseObjDb = GetBool("useObjDB", _UseObjDb);
_UseStaticDb = GetBool("useStaticDB", _UseStaticDb);
_UseNgui = GetBool("useNGUI", _UseNgui);
_UseNguiLegacy = GetBool("useNGUILegacy", _UseNguiLegacy);
_UseXml = GetBool("useXML", _UseXml);
_UseJson = GetBool("useJSON", _UseJson);
_UseCsv = GetBool("useCSV", _UseCsv);
_UseDaikonForge = GetBool("useDaikonForge", _UseDaikonForge);
_UsePlaymaker = GetBool("usePlaymaker", _UsePlaymaker);
_LanguagesIndex = GetInt("languagesIndex", _LanguagesIndex);
_ProjectPath = Application.dataPath;
_CurrentHelpDoc = string.Empty;
_ArrayDelimiters = GetString("arrayDelimiters", _ArrayDelimiters);
_StringArrayDelimiters = GetString("stringArrayDelimiters", _StringArrayDelimiters);
_ComplexTypeDelimiters = GetString("complexTypeDelimiters", _ComplexTypeDelimiters);
_ComplexTypeArrayDelimiters = GetString("complexTypeArrayDelimiters", _ComplexTypeArrayDelimiters);
_TrimStrings = GetBool("trimStrings", _TrimStrings);
_TrimStringArrays = GetBool("trimStringArrays", _TrimStringArrays);
System.Net.ServicePointManager.ServerCertificateValidationCallback = Validator;
_Service = new Google.GData.Spreadsheets.SpreadsheetsService("UnityGoogleFu");
_AuthenticateTick = -1;
if (System.IO.Directory.GetFiles(Application.dataPath, "NGUITools.cs", System.IO.SearchOption.AllDirectories).Length > 0)
{
_FoundNgui = true;
}
if (System.IO.Directory.GetFiles(Application.dataPath, "PlayMaker.dll", System.IO.SearchOption.AllDirectories).Length > 0)
{
_FoundPlaymaker = true;
}
if (System.IO.Directory.GetFiles(Application.dataPath, "dfScriptLite.dll", System.IO.SearchOption.AllDirectories).Length > 0)
{
_FoundDaikonForge = true;
}
if (_AutoLogin || _TemporaryAutoLogin)
{
SetBool("temporaryAutoLogin", false);
DoRefreshWorkbooks = true;
}
else
{
_Workbooks.Clear();
var tmpManualWorkbooks = GetString("manualworkbookurls", System.String.Empty);
var splitManualWorkbooks = tmpManualWorkbooks.Split(new[] { '|' }, System.StringSplitOptions.RemoveEmptyEntries);
foreach (var info in splitManualWorkbooks.Select(in_s => AddManualWorkbookByUrl(in_s)).Where(in_info => in_info != null && GfuStrCmp(in_info.Title, _ActiveWorkbookname)))
{
SetActiveWorkbook(info);
}
}
}
void Init()
{
_authorized = false;
_unityLogo = (Texture2D)Resources.Load("Pwrd_By_Unity_Pri_In_sm", typeof(Texture2D));
_litteratusLogo = (Texture2D)Resources.Load("Litteratus_Logo_sm", typeof(Texture2D));
_separator = (Texture2D)Resources.Load("separator", typeof(Texture2D));
_helpButton = (Texture2D)Resources.Load("help", typeof(Texture2D));
_browseButton = (Texture2D)Resources.Load("folder", typeof(Texture2D));
_username = GetString("username", _username);
_password = GetString("password", _password);
_activeWorkbookname = GetString("activeworkbookname", _activeWorkbookname);
_objDBResourcesDirectory = GetString("objDBResourcesDirectory", _objDBResourcesDirectory);
_objDBEditorDirectory = GetString("objDBEditorDirectory", _objDBEditorDirectory);
_staticDBResourcesDirectory = GetString("staticDBResourcesDirectory", _staticDBResourcesDirectory);
_nguiDirectory = GetString("nguiDirectory", _nguiDirectory);
_xmlDirectory = GetString("xmlDirectory", _xmlDirectory);
_jsonDirectory = GetString("jsonDirectory", _jsonDirectory);
_csvDirectory = GetString("csvDirectory", _csvDirectory);
_playmakerDirectory = GetString("playmakerDirectory", _playmakerDirectory);
_daikonforgeDirectory = GetString("daikonforgeDirectory", _daikonforgeDirectory);
_editorLanguage = GetString("editorLanguage", _editorLanguage);
_saveCredentials = GetBool("saveCredientials", _saveCredentials);
_autoLogin = GetBool("autoLogin", _autoLogin);
_useObjDB = GetBool("useObjDB", _useObjDB);
_useStaticDB = GetBool("useStaticDB", _useStaticDB);
_useNGUI = GetBool("useNGUI", _useNGUI);
_useNGUILegacy = GetBool("useNGUILegacy", _useNGUILegacy);
_useXML = GetBool("useXML", _useXML);
_useJSON = GetBool("useJSON", _useJSON);
_useCSV = GetBool("useCSV", _useCSV);
_useDaikonForge = GetBool("useDaikonForge", _useDaikonForge);
_usePlaymaker = GetBool("usePlaymaker", _usePlaymaker);
_languagesIndex = GetInt("languagesIndex", _languagesIndex);
_projectPath = Application.dataPath;
_currentHelpDoc = string.Empty;
_ArrayDelimiters = GetString("arrayDelimiters", _ArrayDelimiters);
_StringArrayDelimiters = GetString("stringArrayDelimiters", _StringArrayDelimiters);
_ComplexTypeDelimiters = GetString("complexTypeDelimiters", _ComplexTypeDelimiters);
_ComplexTypeArrayDelimiters = GetString("complexTypeArrayDelimiters", _ComplexTypeArrayDelimiters);
_TrimStrings = GetBool("trimStrings", _TrimStrings);
_TrimStringArrays = GetBool("trimStringArrays", _TrimStringArrays);
System.Net.ServicePointManager.ServerCertificateValidationCallback = Validator;
_service = new Google.GData.Spreadsheets.SpreadsheetsService("UnityGoogleFu");
_authenticateTick = -1;
if (System.IO.Directory.GetFiles(Application.dataPath, "NGUITools.cs", System.IO.SearchOption.AllDirectories).Length > 0)
{
_foundNGUI = true;
}
if (System.IO.Directory.GetFiles(Application.dataPath, "PlayMaker.dll", System.IO.SearchOption.AllDirectories).Length > 0)
{
_foundPlaymaker = true;
}
if (System.IO.Directory.GetFiles(Application.dataPath, "dfScriptLite.dll", System.IO.SearchOption.AllDirectories).Length > 0)
{
_foundDaikonForge = true;
}
if (_autoLogin == true)
{
DoRefreshWorkbooks = true;
}
else
{
string tmpManualWorkbooks = GetString("manualworkbookurls", System.String.Empty);
string [] split_ManualWorkbooks = tmpManualWorkbooks.Split(new char[] { '|' }, System.StringSplitOptions.RemoveEmptyEntries);
foreach (string s in split_ManualWorkbooks)
{
WorkBookInfo info = AddManualWorkbookByURL(s);
if (info != null && info.Title == _activeWorkbookname)
{
_activeWorkbook = info;
}
}
}
}
public SpreadsheetsService()
{
authorization = AuthorizationManager.Instance;
service = new GoogleSpreadsheetsService(authorization.ProgramName);
authorization.UpdateService(service);
}
public AdvancedDatabaseInfo(string in_componentName, Google.GData.Spreadsheets.WorksheetEntry in_entry, Google.GData.Spreadsheets.SpreadsheetsService in_service, GameObject in_databaseAttachObject, bool in_bGeneratePlaymaker, bool in_bFirstRowValueTypes)
{
ParseWorksheetEntry(in_entry, in_service, in_bFirstRowValueTypes);
ComponentName = in_componentName;
if (in_databaseAttachObject != null)
{
DatabaseAttachObject = in_databaseAttachObject;
}
else
{
DatabaseAttachObject = GameObject.Find("databaseObj") ?? new GameObject("databaseObj");
}
GeneratePlaymaker = in_bGeneratePlaymaker;
}
private void ParseWorksheetEntry(Google.GData.Spreadsheets.WorksheetEntry in_entry, Google.GData.Spreadsheets.SpreadsheetsService in_service, bool in_bFirstRowValueTypes)
{
if (in_entry == null)
{
Debug.LogError("Could not read WorksheetEntry - retry count: ");
return;
}
// Define the URL to request the list feed of the worksheet.
Google.GData.Client.AtomLink listFeedLink = in_entry.Links.FindService(Google.GData.Spreadsheets.GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
var listQuery = new Google.GData.Spreadsheets.ListQuery(listFeedLink.HRef.ToString());
Google.GData.Spreadsheets.ListFeed listFeed = in_service.Query(listQuery);
//int rowCt = listFeed.Entries.Count;
//int colCt = ((ListEntry)listFeed.Entries[0]).Elements.Count;
if (listFeed.Entries.Count > 0)
{
int curRow = 0;
// Iterate through each row, printing its cell values.
foreach (var atomEntry in listFeed.Entries)
{
var row = (Google.GData.Spreadsheets.ListEntry)atomEntry;
// skip the first row if this is a value type row
if (curRow == 0 && in_bFirstRowValueTypes)
{
curRow++;
continue;
}
if (row.Title.Text.Equals("VOID", StringComparison.OrdinalIgnoreCase))
{
curRow++;
continue;
}
int curCol = 0;
// Iterate over the remaining columns, and print each cell value
foreach (Google.GData.Spreadsheets.ListEntry.Custom element in row.Elements)
{
// this will be the list of all the values in the row excluding the first 'name' column
if (curCol > 0)
{
EntryStrings.Add(element.Value);
}
curCol++;
}
EntryStride = curCol - 1;
curRow++;
}
}
}
public AdvancedDatabaseInfo(string ComponentName, Google.GData.Spreadsheets.WorksheetEntry _entry, Google.GData.Spreadsheets.SpreadsheetsService _service, GameObject _DatabaseAttachObject, bool bGeneratePlaymaker, bool bFirstRowValueTypes)
{
ParseWorksheetEntry(_entry, _service, bFirstRowValueTypes);
this.ComponentName = ComponentName;
if (_DatabaseAttachObject != null)
{
DatabaseAttachObject = _DatabaseAttachObject;
}
else
{
DatabaseAttachObject = GameObject.Find("databaseObj");
if (DatabaseAttachObject == null)
{
DatabaseAttachObject = new GameObject("databaseObj");
}
}
GeneratePlaymaker = bGeneratePlaymaker;
}
void Init()
{
_Authorized = false;
_UnityLogo = (Texture2D)Resources.Load("Pwrd_By_Unity_Pri_In_sm", typeof(Texture2D));
_LitteratusLogo = (Texture2D)Resources.Load("Litteratus_Logo_sm", typeof(Texture2D));
_Separator = (Texture2D)Resources.Load("separator", typeof(Texture2D));
_HelpButton = (Texture2D)Resources.Load("help", typeof(Texture2D));
_BrowseButton = (Texture2D)Resources.Load("folder", typeof(Texture2D));
_Username = GetString("username", _Username);
_Password = GetString("password", _Password);
_ActiveWorkbookname = GetString("activeworkbookname", _ActiveWorkbookname);
_ObjDbResourcesDirectory = GetString("objDBResourcesDirectory", _ObjDbResourcesDirectory);
_ObjDbEditorDirectory = GetString("objDBEditorDirectory", _ObjDbEditorDirectory);
_StaticDbResourcesDirectory = GetString("staticDBResourcesDirectory", _StaticDbResourcesDirectory);
_NguiDirectory = GetString("nguiDirectory", _NguiDirectory);
_XmlDirectory = GetString("xmlDirectory", _XmlDirectory);
_JsonDirectory = GetString("jsonDirectory", _JsonDirectory);
_CsvDirectory = GetString("csvDirectory", _CsvDirectory);
_PlaymakerDirectory = GetString("playmakerDirectory", _PlaymakerDirectory);
_DaikonforgeDirectory = GetString("daikonforgeDirectory", _DaikonforgeDirectory);
_EditorLanguage = GetString("editorLanguage", _EditorLanguage);
if (Language.GetLanguageCode(_EditorLanguage) == Language.Code.INVALID)
{
_EditorLanguage = "en";
SetString("editorLanguage", _EditorLanguage);
}
_SaveCredentials = GetBool("saveCredientials", _SaveCredentials);
_AutoLogin = GetBool("autoLogin", _AutoLogin);
_TemporaryAutoLogin = GetBool("temporaryAutoLogin", _TemporaryAutoLogin);
_UseObjDb = GetBool("useObjDB", _UseObjDb);
_UseStaticDb = GetBool("useStaticDB", _UseStaticDb);
_UseNgui = GetBool("useNGUI", _UseNgui);
_UseNguiLegacy = GetBool("useNGUILegacy", _UseNguiLegacy);
_UseXml = GetBool("useXML", _UseXml);
_UseJson = GetBool("useJSON", _UseJson);
_UseCsv = GetBool("useCSV", _UseCsv);
_UseDaikonForge = GetBool("useDaikonForge", _UseDaikonForge);
_UsePlaymaker = GetBool("usePlaymaker", _UsePlaymaker);
_LanguagesIndex = GetInt("languagesIndex", _LanguagesIndex);
_ProjectPath = Application.dataPath;
_CurrentHelpDoc = string.Empty;
_ArrayDelimiters = GetString("arrayDelimiters", _ArrayDelimiters);
_StringArrayDelimiters = GetString("stringArrayDelimiters", _StringArrayDelimiters);
_ComplexTypeDelimiters = GetString("complexTypeDelimiters", _ComplexTypeDelimiters);
_ComplexTypeArrayDelimiters = GetString("complexTypeArrayDelimiters", _ComplexTypeArrayDelimiters);
_TrimStrings = GetBool("trimStrings", _TrimStrings);
_TrimStringArrays = GetBool("trimStringArrays", _TrimStringArrays);
System.Net.ServicePointManager.ServerCertificateValidationCallback = Validator;
_Service = new Google.GData.Spreadsheets.SpreadsheetsService("UnityGoogleFu");
_AuthenticateTick = -1;
if (System.IO.Directory.GetFiles(Application.dataPath, "NGUITools.cs", System.IO.SearchOption.AllDirectories).Length > 0)
_FoundNgui = true;
if (System.IO.Directory.GetFiles(Application.dataPath, "PlayMaker.dll", System.IO.SearchOption.AllDirectories).Length > 0)
_FoundPlaymaker = true;
if (System.IO.Directory.GetFiles(Application.dataPath, "dfScriptLite.dll", System.IO.SearchOption.AllDirectories).Length > 0)
_FoundDaikonForge = true;
if (_AutoLogin || _TemporaryAutoLogin)
{
SetBool("temporaryAutoLogin", false);
DoRefreshWorkbooks = true;
}
else
{
_Workbooks.Clear();
var tmpManualWorkbooks = GetString("manualworkbookurls", System.String.Empty);
var splitManualWorkbooks = tmpManualWorkbooks.Split(new[] { '|' }, System.StringSplitOptions.RemoveEmptyEntries);
foreach (var info in splitManualWorkbooks.Select(in_s => AddManualWorkbookByUrl(in_s)).Where(in_info => in_info != null && GfuStrCmp(in_info.Title, _ActiveWorkbookname)))
{
SetActiveWorkbook(info);
}
}
}
