Facebook

81     void OnGUI()
82     {
83         if (PhotonNetwork.connected)
84         {
85             GUILayout.Label(PhotonNetwork.connectionStateDetailed.ToString());
86             return;
87         }
88
89
90         GUILayout.BeginArea(GuiRect);
91         switch (guiState)
92         {
93             case GuiState.AuthFailed:
94                 GUILayout.Label("Authentication Failed");
95
96                 GUILayout.Space(10);
97
98                 GUILayout.Label("Error message:\n'" + this.authDebugMessage + "'");
99
100                 GUILayout.Space(10);
101
102                 GUILayout.Label("For this demo set the Authentication URL in the Dashboard to:\nhttp://photon.webscript.io/auth-demo-equals");
103                 GUILayout.Label("That authentication-service has no user-database. It confirms any user if 'name equals password'.");
104                 GUILayout.Label("The error message comes from that service and can be customized.");
105
106                 GUILayout.Space(10);
107
108                 GUILayout.BeginHorizontal();
109                 if (GUILayout.Button("Back"))
110                 {
111                     SetStateAuthInput();
112                 }
113                 if (GUILayout.Button("Help"))
114                 {
115                     SetStateAuthHelp();
116                 }
117                 GUILayout.EndHorizontal();
118                 break;
119
120             case GuiState.AuthHelp:
121
122                 GUILayout.Label("By default, any player can connect to Photon.\n'Custom Authentication' can be enabled to reject players without valid user-account.");
123
124                 GUILayout.Label("The actual authentication must be done by a web-service which you host and customize. Example sourcecode for these services is available on the docs page.");
125
126                 GUILayout.Label("For this demo set the Authentication URL in the Dashboard to:\nhttp://photon.webscript.io/auth-demo-equals");
127                 GUILayout.Label("That authentication-service has no user-database. It confirms any user if 'name equals password'.");
128
129                 GUILayout.Space(10);
130                 if (GUILayout.Button("Configure Authentication (Dashboard)"))
131                 {
132                     Application.OpenURL("https://cloud.exitgames.com/dashboard");
133                 }
134                 if (GUILayout.Button("Authentication Docs"))
135                 {
136                     Application.OpenURL("https://doc.exitgames.com/en/pun/current/tutorials/pun-and-facebook-custom-authentication");
137                 }
138
139
140                 GUILayout.Space(10);
141                 if (GUILayout.Button("Back to input"))
142                 {
143                     SetStateAuthInput();
144                 }
145                 break;
146
147             case GuiState.AuthInput:
148
149                 GUILayout.Label("Authenticate yourself");
150
151                 GUILayout.BeginHorizontal();
152                 this.authName = GUILayout.TextField(this.authName, GUILayout.Width(Screen.width/4 - 5));
153                 GUILayout.FlexibleSpace();
154                 this.authToken = GUILayout.TextField(this.authToken, GUILayout.Width(Screen.width/4 - 5));
155                 GUILayout.EndHorizontal();
156
157
158                 if (GUILayout.Button("Authenticate"))
159                 {
160                     PhotonNetwork.AuthValues = new AuthenticationValues();
161                     PhotonNetwork.AuthValues.SetAuthParameters(this.authName, this.authToken);
162                     PhotonNetwork.ConnectUsingSettings("1.0");
163                 }
164
165                 GUILayout.Space(10);
166
167                 if (GUILayout.Button("Help", GUILayout.Width(100)))
168                 {
169                     SetStateAuthHelp();
170                 }
171
172                 break;
173         }
174
175         GUILayout.EndArea();
176     }

31         private void loadData()
32         {
33             using (MySqlConnection conn = new MySqlConnection("server=localhost;user=root;database=phonedirectory;port=3306;password=;"))
34             {
35                 using (MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT Name,Nickname,PhoneNumber,MobileNumber,EmailAddress,HomeAddress,Company,Position,GroupName,Website,FacebookAccount From directory Where Remarks=''", conn))
36                 {
37                     DataSet ds = new DataSet();
38                     adapter.Fill(ds);
39                     dataGridView1.DataSource = ds.Tables[0];
40                 }
41             }
42         }

44         private void loadData(string searcher, string field)
45         {
46              name = searcher;
47             if (comboBox1.Text == "")
48             {
49                 try
50                 {
51                     using (MySqlConnection conn = new MySqlConnection("server=localhost;user=root;database=phonedirectory;port=3306;password=;"))
52                     {
53                         using (MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT Name,Nickname,PhoneNumber,MobileNumber,EmailAddress,HomeAddress,Company,Position,GroupName,Website,FacebookAccount From directory WHERE Name LIKE '%" + name +
54                             "%' or Nickname LIKE '%"+name+
55                             "%' or PhoneNumber LIKE '%" + name +
56                             "%' or MobileNumber LIKE '%" + name +
57                             "%' or EmailAddress LIKE '%" + name +
58                             "%' or HomeAddress LIKE '%" + name +
59                             "%' or Company LIKE '%" + name +
60                             "%' or Position LIKE '%" + name +
61                             "%' or GroupName LIKE '%" + name +
62                             "%' or Website LIKE '%" + name +
63                             "%' or FacebookAccount LIKE '%" + name + "%'", conn))
64                         {
65                             DataSet ds = new DataSet();
66                             adapter.Fill(ds);
67                             dataGridView1.DataSource = ds.Tables[0];
68
69
70                         }
71                     }
72                 }
73                 catch (Exception er)
74                 {
75                 }
76             }
77             else
78             {
79                 try
80                 {
81                     using (MySqlConnection conn = new MySqlConnection("server=localhost;user=root;database=phonedirectory;port=3306;password=;"))
82                     {
83                         using (MySqlDataAdapter adapter = new MySqlDataAdapter("SELECT Name,Nickname,PhoneNumber,MobileNumber,EmailAddress,HomeAddress,Company,Position,GroupName,Website,FacebookAccount From directory WHERE " + field + " LIKE '%" + textBox1.Text + "%'", conn))
84                         {
85                             DataSet ds = new DataSet();
86                             adapter.Fill(ds);
87                             dataGridView1.DataSource = ds.Tables[0];
88                         }
89                     }
90                 }
91                 catch (Exception er)
92                 {
93                 }
94             }
95
96         }

133         private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
134         {
135             try
136             {
137                 int index = e.RowIndex;
138                 DataGridViewRow selectedRow = dataGridView1.Rows[index];
139                 Name1 = selectedRow.Cells[0].Value.ToString();
140                 Nickname = selectedRow.Cells[1].Value.ToString();
141                 PhoneNumber = selectedRow.Cells[2].Value.ToString();
142                 MobileNumber = selectedRow.Cells[3].Value.ToString();
143                 EmailAddress = selectedRow.Cells[4].Value.ToString();
144                 HomeAddress = selectedRow.Cells[5].Value.ToString();
145                 Company = selectedRow.Cells[6].Value.ToString();
146                 Position = selectedRow.Cells[7].Value.ToString();
147                 GroupName = selectedRow.Cells[8].Value.ToString();
148                 Website = selectedRow.Cells[9].Value.ToString();
149                 FacebookAccount = selectedRow.Cells[10].Value.ToString();
150
151                 frm_prev a = new frm_prev(Name1,Nickname,PhoneNumber,MobileNumber,EmailAddress,HomeAddress,Company,Position,GroupName,Website,FacebookAccount);
152                 a.ShowDialog();
153                 loadData();
154
155             }
156             catch (Exception er)
157             {
158             }
159         }

26         private void saveData()
27         {
28             MySqlConnection connection = new MySqlConnection("server=localhost;user=root;database=phonedirectory;port=3306;password=;");
29             connection.Open();
30             MySqlCommand cmd = new MySqlCommand();
31             cmd.Connection = connection;
32             cmd.CommandText = "INSERT INTO directory(ID ,Name,Nickname, PhoneNumber,MobileNumber, EmailAddress,HomeAddress,Company,Position,GroupName,Website,FacebookAccount,Remarks) VALUES(@ID ,@Name,@Nickname, @PhoneNumber,@MobileNumber, @EmailAddress,@HomeAddress,@Company,@Position,@GroupName,@Website,@FacebookAccount,@Remarks)";
33             cmd.Parameters.AddWithValue("@ID", null);
34             cmd.Parameters.AddWithValue("@Name", textBox1.Text);
35             cmd.Parameters.AddWithValue("@Nickname", textBox2.Text);
36             cmd.Parameters.AddWithValue("@PhoneNumber", textBox3.Text);
37             cmd.Parameters.AddWithValue("@MobileNumber", textBox4.Text);
38             cmd.Parameters.AddWithValue("@EmailAddress", textBox5.Text);
39             cmd.Parameters.AddWithValue("@HomeAddress", textBox6.Text);
40             cmd.Parameters.AddWithValue("@Company", textBox7.Text);
41             cmd.Parameters.AddWithValue("@Position", textBox8.Text);
42             cmd.Parameters.AddWithValue("@GroupName", textBox9.Text);
43             cmd.Parameters.AddWithValue("@Website", textBox10.Text);
44             cmd.Parameters.AddWithValue("@FacebookAccount", textBox11.Text);
45             cmd.Parameters.AddWithValue("@Remarks", "");
46             cmd.ExecuteNonQuery();
47             if (connection != null)
48                 connection.Close();
49             MessageBox.Show("Successfully saved to directory", " System Notification");
50         }

27         public frm_prev(string name, string nickname, string phonenumber,string mobilenumber,string emailadd,string homeadd,string comp,string post,string group,string web,string fb)
28         {
29             Name1 =name;
30             Nickname = nickname;
31             PhoneNumber= phonenumber;
32             MobileNumber=mobilenumber;
33             EmailAddress=emailadd;
34             HomeAddress = homeadd ;
35             Company = comp;
36             Position= post;
37             GroupName=group;
38             Website= web;
39             FacebookAccount=fb;
40
41             InitializeComponent();
42         }

44         private void frm_prev_Load(object sender, EventArgs e)
45         {
46             label1.Text = "Name : " + Name1;
47             label2.Text = "Nickname : " + Nickname;
48             label3.Text = "Phone Number : " + PhoneNumber;
49             label4.Text = "Mobile Number : " + MobileNumber;
50             label5.Text = "Email Address : " + EmailAddress;
51             label6.Text = "Home Address : " + HomeAddress;
52             label7.Text = "Company : " + Company;
53             label8.Text = "Position : " + Position;
54             label9.Text = "Group : " + GroupName;
55             label10.Text = "Website : " + Website;
56             label11.Text = "Facebook Account : " + FacebookAccount;
57         }

59         private void button1_Click(object sender, EventArgs e)
60         {
61             frm_update a = new frm_update(Name1, Nickname, PhoneNumber, MobileNumber, EmailAddress, HomeAddress, Company, Position, GroupName, Website, FacebookAccount);
62             a.ShowDialog();
63             this.Close();
64         }

34         public frm_update(string name, string nickname, string phonenumber, string mobilenumber, string emailadd, string homeadd, string comp, string post, string group, string web, string fb)
35         {
36             Name1 = name;
37             Nickname = nickname;
38             PhoneNumber = phonenumber;
39             MobileNumber = mobilenumber;
40             EmailAddress = emailadd;
41             HomeAddress = homeadd;
42             Company = comp;
43             Position = post;
44             GroupName = group;
45             Website = web;
46             FacebookAccount = fb;
47
48             InitializeComponent();
49         }

51         private void frm_update_Load(object sender, EventArgs e)
52         {
53             textBox1.Text = Name1;
54             textBox2.Text = Nickname;
55             textBox3.Text = PhoneNumber;
56             textBox4.Text = MobileNumber;
57             textBox5.Text = EmailAddress;
58             textBox6.Text = HomeAddress;
59             textBox7.Text = Company;
60             textBox8.Text = Position;
61             textBox9.Text = GroupName;
62             textBox10.Text = Website;
63             textBox11.Text = FacebookAccount;
64         }