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