Help mysql - database - unity | Official Unity Discord | Page 1

ashen kestrel Aug 17, 2022, 5:51 AM

#

Hel

#

https://drive.google.com/drive/folders/1yamfRL8wicoBBssDFW6eoM_QFmHoPiJV

#

example there

#

and modify WWW old , new UnityWebRequest

vocal tendon Aug 17, 2022, 5:52 AM

#

Your request reaches the server. Server has the error information

ashen kestrel Aug 17, 2022, 5:54 AM

#

vocal tendon Your request reaches the server. Server has the error information

think is error 500?

#

hmm i see.

vocal tendon Aug 17, 2022, 5:55 AM

#

Error 500 just mean unknown error happened from your server

#

You need to test your server

ashen kestrel Aug 17, 2022, 5:56 AM

#

Hmm other is "dbconnection" is working?

ashen kestrel Aug 17, 2022, 5:57 AM

#

ashen kestrel https://drive.google.com/drive/folders/1yamfRL8wicoBBssDFW6eoM_QFmHoPiJV

check look

#

and there "createuser.php"

#

Okay i see but check investigate maybe hard.

vocal tendon Aug 17, 2022, 6:00 AM

#

Do you have server log?

#

Like what exception happened from server

ashen kestrel Aug 17, 2022, 6:05 AM

#

no have logs but idk okay well...

#

moment ok use postman

#

Look

#

CM_Hmm

#

empty lol

#

@vocal tendon is server cloudflare

vocal tendon Aug 17, 2022, 6:10 AM

#

What is empty? Postman is client

ashen kestrel Aug 17, 2022, 6:11 AM

#

vocal tendon What is empty? Postman is client

yeah

vocal tendon Aug 17, 2022, 6:11 AM

#

You send request to server with it

#

With your url

ashen kestrel Aug 17, 2022, 6:11 AM

#

okay

#

@vocal tendon look there link

#

and already have empty.

vocal tendon Aug 17, 2022, 6:15 AM

#

Well did you put your post fields?

#

Username Email etc

ashen kestrel Aug 17, 2022, 6:17 AM

#

yes already all @vocal tendon

#

vocal tendon Aug 17, 2022, 6:17 AM

#

From the POSTman….

ashen kestrel Aug 17, 2022, 6:18 AM

#

vocal tendon From the POSTman….

yeah but is empty.

vocal tendon Aug 17, 2022, 6:20 AM

#

You can set the body values from POSTman

ashen kestrel Aug 17, 2022, 6:21 AM

#

there is?

#

vocal tendon Aug 17, 2022, 6:22 AM

#

Yes

#

Fill your Key and Value

ashen kestrel Aug 17, 2022, 6:23 AM

#

Hmm how is key and value CM_Hmm

#

example same User - Benzitczo

#

?

vocal tendon Aug 17, 2022, 6:23 AM

#

Yes your parameters

#

Username
Email
Password

ashen kestrel Aug 17, 2022, 6:24 AM

#

ok

#

Done

#

try sent click?

vocal tendon Aug 17, 2022, 6:25 AM

#

Yeah let’s try

ashen kestrel Aug 17, 2022, 6:25 AM

#

#

exactly? Okay done sent

#

hmm nothing.

#

#

CM_Hmm

vocal tendon Aug 17, 2022, 6:27 AM

#

Yes it says 500

ashen kestrel Aug 17, 2022, 6:27 AM

#

vocal tendon Yes it says 500

hmm i see

#

exactly same unity

#

how solution ?

vocal tendon Aug 17, 2022, 6:27 AM

#

So it is not Unity problem

ashen kestrel Aug 17, 2022, 6:27 AM

#

vocal tendon So it is not Unity problem

yeah i know.

vocal tendon Aug 17, 2022, 6:27 AM

#

Your server has the error detail

ashen kestrel Aug 17, 2022, 6:28 AM

#

vocal tendon Your server has the error detail

yes, how solution?

vocal tendon Aug 17, 2022, 6:28 AM

#

You have access to your server?

ashen kestrel Aug 17, 2022, 6:28 AM

#

yes have.

#

wait you experience php?

vocal tendon Aug 17, 2022, 6:30 AM

#

Not much but I know server stuffs

ashen kestrel Aug 17, 2022, 6:30 AM

#

i see but need help.

vocal tendon Aug 17, 2022, 6:30 AM

#

You can get error logs right?

ashen kestrel Aug 17, 2022, 6:30 AM

#

no have logs error where.

#

and yes error have 500

#

how solution no idea

#

but there is:

vocal tendon Aug 17, 2022, 6:30 AM

#

https://docs.moodle.org/dev/PHP_error_logs

PHP error logs

ashen kestrel Aug 17, 2022, 6:31 AM

#

ok i see

#

there ccreate php.ini

#

#

Correct?

#

But idk

vocal tendon Aug 17, 2022, 6:33 AM

#

I don’t think so how are you running your php

#

What web server

ashen kestrel Aug 17, 2022, 6:33 AM

#

yeah but my little experience and i am no professional.

#

and there exactly web server

#

login and password mysql for unity

#

tutorial is old date.

#

problem nothing 2020

#

and no idea solution.

vocal tendon Aug 17, 2022, 6:34 AM

#

Which tutorial did you use?

ashen kestrel Aug 17, 2022, 6:34 AM

#

only spanish tutorial there and no problem here look: https://drive.google.com/drive/folders/1yamfRL8wicoBBssDFW6eoM_QFmHoPiJV

vocal tendon Aug 17, 2022, 6:35 AM

#

How did you install your php?

ashen kestrel Aug 17, 2022, 6:35 AM

#

vocal tendon How did you install your php?

ya have php version current

#

actual.

#

why use have is "hostinger"

#

think

#

there is "Options -Indexes"

#

?

#

vocal tendon Aug 17, 2022, 6:37 AM

#

ah okay you are hosting on them

ashen kestrel Aug 17, 2022, 6:37 AM

#

yeah

#

is okay all

#

maybe is problem bad code php?

vocal tendon Aug 17, 2022, 6:38 AM

#

Could be or could not be

#

https://www.hostinger.com/tutorials/website/how-to-check-your-website-error-log

Hostinger Tutorials

How to Check Your Website's PHP Error Log

Do you get unknown PHP errors on your website? Check out our step-by-step tutorial on how to locate and check your PHP error log file.

#

here is for hostinger

ashen kestrel Aug 17, 2022, 6:38 AM

#

AHH

#

there

#

moment

#

done

vocal tendon Aug 17, 2022, 6:40 AM

#

Now POST request it again

#

You should get 500 again

ashen kestrel Aug 17, 2022, 6:41 AM

#

yes work

vocal tendon Aug 17, 2022, 6:41 AM

#

Then you can check the error_log

ashen kestrel Aug 17, 2022, 6:41 AM

#

i see line 5 to 8 error

vocal tendon Aug 17, 2022, 6:41 AM

#

can you paste the error?

ashen kestrel Aug 17, 2022, 6:41 AM

#

[17-Aug-2022 06:41:03 UTC] PHP Notice:  Undefined index: Nickname in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 6
[17-Aug-2022 06:41:03 UTC] PHP Notice:  Undefined index: Password in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 7
[17-Aug-2022 06:41:03 UTC] PHP Notice:  Undefined index: Email in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 8
[17-Aug-2022 06:41:03 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Username' in 'where clause' in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php:12
Stack trace:
#0 /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php(12): PDO->query('SELECT User Fro...')
#1 {main}
  thrown in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 12```

vocal tendon Aug 17, 2022, 6:44 AM

#

Is it same code as google drive? looks different

#

the createUser

ashen kestrel Aug 17, 2022, 6:44 AM

#

vocal tendon Is it same code as google drive? looks different

yes

#

and modify differents

vocal tendon Aug 17, 2022, 6:44 AM

#

The log says CreatedUser

#

and parameters are different

#

Oh so the code is different okay

ashen kestrel Aug 17, 2022, 6:45 AM

#

yeah

#


include "DBConnection.php";

$User = $_POST['User'];
$Nickname = $_POST['Nickname'];
$Password = hash("sha256", $_POST['Password']); //metodo hash el sha256 hash para encriptacion
$Email = $_POST['Email'];

//n la query cuando llame la tabla poner tambien la base de datos osea select userName from (game)doctores.usuarios ...
$sql = "SELECT User From Usuarios WHERE Username = '$User'";//leer de nuestra tabla usuarios donde Username(en formulario) se aigual a userName en bd
$result = $pdo->query($sql);

if($result->rowCount()>0)//comprobamos que si ya hay mas de 1 osea >0 entonces seria falso
{
  $data = array('done' => false, 'message' => "Error, nombre de usuario ya existe");
  Header('Content-Type: application/json');
  echo json_encode($data);//utilizamos echo de json para enviar los datos
  exit();//romper la ejecusion si es correcto
}

else{
    //comprobamos que el email no exista
  $sql = "SELECT Email From Usuarios WHERE Email = '$Email'";
  $result = $pdo->query($sql);

  if($result->rowCount()>0)//comprobamos que si ya hay mas de 1 osea >0 entonces falso.
  {
    $data = array('done' => false, 'message' => "Error, Email ya existe");
    Header('Content-Type: application/json');
    echo json_encode($data);
    exit();
  }

  else{
      //leemos  que lo insertado esta aprobado true osea no repetido en la tabla usuarios de bd
    $sql = "INSERT INTO Usuarios SET User = '$User, Nickname = '$Nickname, Password = '$Password, Email = '$Email'";
    $pdo->query($sql);
//en caso que sea true  enviaremos el mensaje
    $data = array('done' => true, 'message' => "Usuario nuevo creado");
    Header('Content-Type: application/json');
    echo json_encode($data);
    exit();
  }
}

?>

#

there

#

or no idea you? okay no problem other server help discord.

vocal tendon Aug 17, 2022, 6:47 AM

#

So the error says there is no "User" "Nickname" "Password" "Email" in your POST body

ashen kestrel Aug 17, 2022, 6:47 AM

#

yeah but wait think complicated.

vocal tendon Aug 17, 2022, 6:49 AM

#

What is your URL? I can try post from my side..

ashen kestrel Aug 17, 2022, 6:50 AM

#

ok

vocal tendon Aug 17, 2022, 6:50 AM

#

Oh.. also your DB setup needs to be fixed

ashen kestrel Aug 17, 2022, 6:50 AM

#

vocal tendon Oh.. also your DB setup needs to be fixed

ya have is okay DB

vocal tendon Aug 17, 2022, 6:50 AM

#

Column not found: 1054 Unknown column 'Username' in 'where clause' in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php:12

ashen kestrel Aug 17, 2022, 6:50 AM

#

vocal tendon ``` Column not found: 1054 Unknown column 'Username' in 'where clause' in /home/...

Hmm werid.

#

Ah

#

I see

#

wait fixed.

#

think is user

#

not username

#

solution fix 12 line

#

again error 5 to 8 same

vocal tendon Aug 17, 2022, 6:52 AM

#

I can post if you send me url

ashen kestrel Aug 17, 2022, 6:52 AM

#

and 38 error lol

vocal tendon Aug 17, 2022, 6:53 AM

#

Okay how is the error?

#

I just posted

ashen kestrel Aug 17, 2022, 6:53 AM

#

@vocal tendon yes

vocal tendon Aug 17, 2022, 6:54 AM

#

okay still undefined index

ashen kestrel Aug 17, 2022, 6:54 AM

#

yeah :/

#

problem ?

vocal tendon Aug 17, 2022, 6:59 AM

#

Yeah.. I think I'm sending correctly but still gets undefined index

ashen kestrel Aug 17, 2022, 7:00 AM

#

vocal tendon Yeah.. I think I'm sending correctly but still gets undefined index

i see but how solution?

vocal tendon Aug 17, 2022, 7:04 AM

#

Still same error? I posted just now

ashen kestrel Aug 17, 2022, 7:05 AM

#

@vocal tendon

#

vocal tendon Aug 17, 2022, 7:05 AM

#

ashen kestrel Aug 17, 2022, 7:05 AM

#

i see

#

maybe error last 38

vocal tendon Aug 17, 2022, 7:06 AM

#

I think Error line 38 is just happening because everything is empty

ashen kestrel Aug 17, 2022, 7:06 AM

#

  thrown in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 38
[17-Aug-2022 06:53:15 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'hello, Password = '2597a7caf656e89e9ab35e12326d557ebfe9b7b5dcbe4c564e74070fa5...' at line 1 in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php:38
Stack trace:
#0 /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php(38): PDO->query('INSERT INTO Usu...')
#1 {main}
  thrown in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 38
[17-Aug-2022 07:03:22 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' Nickname, Password, Email = 'myusername, Nickname = 'hello, Password = '2597...' at line 1 in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php:38
Stack trace:
#0 /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php(38): PDO->query('INSERT INTO Usu...')
#1 {main}
  thrown in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/CreatedUser.php on line 38```

vocal tendon Aug 17, 2022, 7:06 AM

#

Oh other errors are gone?

ashen kestrel Aug 17, 2022, 7:06 AM

#

yeah

#

there last error 38

vocal tendon Aug 17, 2022, 7:07 AM

#

Alright then almost there

#

and your SQL needs to get fixed

#

$sql = "INSERT INTO Usuarios SET User = '$User, Nickname = '$Nickname, Password = '$Password, Email = '$Email'";

ashen kestrel Aug 17, 2022, 7:07 AM

#

@vocal tendon

vocal tendon Aug 17, 2022, 7:07 AM

#

Do you see ' is missing after $User $Nickname $Password ?

ashen kestrel Aug 17, 2022, 7:08 AM

#

vocal tendon Do you see ' is missing after $User $Nickname $Password ?

Yes

#

Okay wait second

vocal tendon Aug 17, 2022, 7:08 AM

#

$sql = "INSERT INTO Usuarios SET User = '$User', Nickname = '$Nickname', Password = '$Password', Email = '$Email'";

#

Should be fixed like this

ashen kestrel Aug 17, 2022, 7:09 AM

#

OK wait

vocal tendon Aug 17, 2022, 7:09 AM

#

Let me know when you're done so I'll POST again

ashen kestrel Aug 17, 2022, 7:11 AM

#

#

there is maybe?

#

Ok done

vocal tendon Aug 17, 2022, 7:11 AM

#

200!

ashen kestrel Aug 17, 2022, 7:11 AM

#

what lol

#

ah is work

#

vocal tendon Aug 17, 2022, 7:12 AM

#

{
"done": true,
"message": "Usuario nuevo creado"
}

ashen kestrel Aug 17, 2022, 7:12 AM

#

Yes

#

finally

vocal tendon Aug 17, 2022, 7:12 AM

#

It worked 🙂

#

200 means OK/Success in HTTP code

ashen kestrel Aug 17, 2022, 7:12 AM

#

i see

vocal tendon Aug 17, 2022, 7:12 AM

#

So your Unity should work now.

ashen kestrel Aug 17, 2022, 7:12 AM

#

there is okay and maybe is last 38 error

ashen kestrel Aug 17, 2022, 7:13 AM

#

vocal tendon So your Unity should work now.

Yes moment

vocal tendon Aug 17, 2022, 7:13 AM

#

line 38 error is fixed with your code

ashen kestrel Aug 17, 2022, 7:13 AM

#

vocal tendon line 38 error is fixed with your code

yeah

#

Done unity

#

and waiting "loading"

#

no working maybe problem code webunityXD

#

#

And empty console 👀

vocal tendon Aug 17, 2022, 7:14 AM

#

Now you can check error message

ashen kestrel Aug 17, 2022, 7:15 AM

#

vocal tendon Now you can check error message

empty console

#

xd

vocal tendon Aug 17, 2022, 7:15 AM

#

Does that mean no 500?

ashen kestrel Aug 17, 2022, 7:16 AM

#

vocal tendon Does that mean no 500?

no

#

is okay work

#

and empty console

#

and loading waiting

#

maybe no working

vocal tendon Aug 17, 2022, 7:16 AM

#

So it's not the web request the issue

ashen kestrel Aug 17, 2022, 7:16 AM

#

there code: #archived-code-general message @vocal tendon

ashen kestrel Aug 17, 2022, 7:16 AM

#

vocal tendon So it's not the web request the issue

exactly

vocal tendon Aug 17, 2022, 7:17 AM

#

responseText will not start with "Success" that's the thing

#

so empty console

#

responseText is like #1009337797515169842 message

ashen kestrel Aug 17, 2022, 7:18 AM

#

hmm yeah how :/

vocal tendon Aug 17, 2022, 7:19 AM

#

So your HTTP is success

#

You need to see the code that calling Co_CreateUser now

ashen kestrel Aug 17, 2022, 7:20 AM

#

Hmm

vocal tendon Aug 17, 2022, 7:21 AM

#

There'd be reason that hangs on the loading 🙂

ashen kestrel Aug 17, 2022, 7:21 AM

#

vocal tendon There'd be reason that hangs on the loading 🙂

yeah maybe

#

@vocal tendon Okay no problem

#

thanks help and tomorrow again ok

#

my sleep rest.

vocal tendon Aug 17, 2022, 7:24 AM

#

Good night

ashen kestrel Aug 17, 2022, 7:25 AM

#

@vocal tendon ah i see

#

there ..

#

already ID and pass

#

said processing...

#

no working problem.

#

example login -> profile

#

#

Okay

#

no problem ignore and solution idea

#

thanks gn

ashen kestrel Aug 18, 2022, 2:10 AM

#

@vocal tendon back hello

#

and but ...

vocal tendon Aug 18, 2022, 2:10 AM

#

Sup

ashen kestrel Aug 18, 2022, 2:10 AM

#

problem werid enter link page and account register wtf but is problem no allow enter page register (only game not page)

#

example

#

but do not use or idk maybe problem.

#

and only is game

#

and said unity console : HTTP/1.1 404 Not Found

ashen kestrel Aug 18, 2022, 2:11 AM

#

ashen kestrel example

vocal tendon Aug 18, 2022, 2:11 AM

#

404 not found means your address is wrong

ashen kestrel Aug 18, 2022, 2:11 AM

#

vocal tendon 404 not found means your address is wrong

yeah exactly.

#

problem no working hmm

vocal tendon Aug 18, 2022, 2:12 AM

#

which of your url gives 404 not found?

ashen kestrel Aug 18, 2022, 2:12 AM

#

yes there.

ashen kestrel Aug 18, 2022, 2:12 AM

#

vocal tendon which of your url gives 404 not found?

#

#

CM_Hmm

#

Ah

#

i see hmm

#

moment fixed.

vocal tendon Aug 18, 2022, 2:15 AM

#

Fixed? nice

ashen kestrel Aug 18, 2022, 2:15 AM

#

yeah fixed

#

@vocal tendon

#

and maybe wrong text bad

vocal tendon Aug 18, 2022, 2:15 AM

#

Que bueno

ashen kestrel Aug 18, 2022, 2:15 AM

#

#

but no working where example.

#

#

when register -> login

#

exist account

vocal tendon Aug 18, 2022, 2:16 AM

#

So remove your if

ashen kestrel Aug 18, 2022, 2:16 AM

#

where is oh is if (responseText.StartsWith("Success"))

#

?

vocal tendon Aug 18, 2022, 2:16 AM

#

Yes responseText will not starts with "Success"

ashen kestrel Aug 18, 2022, 2:16 AM

#

ah

#

Correct?

#

vocal tendon Aug 18, 2022, 2:18 AM

#

Should be

ashen kestrel Aug 18, 2022, 2:20 AM

#

@vocal tendon i see but error lol

#

Okay i see my idea.

vocal tendon Aug 18, 2022, 2:22 AM

#

Now LoginUI is getting called

#

So it's problem inside of it

ashen kestrel Aug 18, 2022, 2:22 AM

#

Yess i know

#

my remember minutes.

#

but my forgetl ol

#

is hard developer hehe.

#

Done solution

vocal tendon Aug 18, 2022, 2:23 AM

#

I know it's not easy

ashen kestrel Aug 18, 2022, 2:23 AM

#

and problem error werid:

#

vocal tendon Aug 18, 2022, 2:25 AM

#

I think you need to do

using (var request = UnityWebRequest.Post(...))

#

https://docs.unity3d.com/ScriptReference/Networking.UnityWebRequest.Post.html

#

See examples

ashen kestrel Aug 18, 2022, 2:25 AM

#

Yeah look @vocal tendon

#

CM_Hmm

vocal tendon Aug 18, 2022, 2:26 AM

#

Well is the request success?

ashen kestrel Aug 18, 2022, 2:27 AM

#

vocal tendon Well is the request success?

yes sucess

#

and probably problem werid missing email

#

why said "Olivia12"

#

where is @gmail.com lol

#

No problem ask help php

#

how there think $Email = $_POST['Email'];

#

hmm

vocal tendon Aug 18, 2022, 2:28 AM

#

Ooh. that is UrlEncode problem

#

https://docs.unity3d.com/ScriptReference/Networking.UnityWebRequest.EscapeURL.html

#

@ is special character you need to escape it

ashen kestrel Aug 18, 2022, 2:29 AM

#

ah hmm how is ..

#

okay copy code

#

okay maybe test?

vocal tendon Aug 18, 2022, 2:30 AM

#

So basically UnityWebRequest.EscapeURL(email)

#

Put that into WWWForm

ashen kestrel Aug 18, 2022, 2:31 AM

#

Ahh i see

#

noted.

ashen kestrel Aug 18, 2022, 2:31 AM

#

vocal tendon So basically `UnityWebRequest.EscapeURL(email)`

Done

ashen kestrel Aug 18, 2022, 2:31 AM

#

vocal tendon Put that into `WWWForm`

how is?

#

UnityWebRequest.EscapeURL(email, wwform maybe?)

#

xd

#

sorry my bad.

vocal tendon Aug 18, 2022, 2:32 AM

#

No replace it like Form.AddField("Email", UnityWebRequest.EscapeURL(email))

ashen kestrel Aug 18, 2022, 2:32 AM

#

ahh

#

Done

vocal tendon Aug 18, 2022, 2:33 AM

#

that is gonna make "abcd@gmail.com" to "abcd%40gmail.com"

ashen kestrel Aug 18, 2022, 2:33 AM

#

i see.

#

Test play?

vocal tendon Aug 18, 2022, 2:33 AM

#

Yes

ashen kestrel Aug 18, 2022, 2:34 AM

#

#

werid.

#

no work email

#

xd

vocal tendon Aug 18, 2022, 2:34 AM

#

Did you change the register part too?

ashen kestrel Aug 18, 2022, 2:35 AM

#

vocal tendon Did you change the register part too?

maybe

#

change already all

#

and missing email problem

#

xd

vocal tendon Aug 18, 2022, 2:35 AM

#

Show me the code?

#

The Co_CreateUser

ashen kestrel Aug 18, 2022, 2:36 AM

#

#

there co_createuser

vocal tendon Aug 18, 2022, 2:37 AM

#

Hmm it should work

ashen kestrel Aug 18, 2022, 2:37 AM

#

maybe php

vocal tendon Aug 18, 2022, 2:37 AM

#

Mayybe

ashen kestrel Aug 18, 2022, 2:37 AM

#

#

hmm

#

search google. or ask php server discord lol

vocal tendon Aug 18, 2022, 2:39 AM

#

Yeah I think it should work

ashen kestrel Aug 18, 2022, 2:42 AM

#

vocal tendon Yeah I think it should work

hmm

vocal tendon Aug 18, 2022, 2:42 AM

#

Maybe your code is not saved? XD

ashen kestrel Aug 18, 2022, 2:45 AM

#

vocal tendon Maybe your code is not saved? XD

yeah maybe

#

No problem thanks help @vocal tendon

#

and waiting other help php

#

Done solution all good.

#

ok later wait

vocal tendon Aug 18, 2022, 2:46 AM

#

They fixed it?

ashen kestrel Aug 18, 2022, 2:52 AM

#

@vocal tendon Yes okay later

#

and but

#

problem why email no is password

#

confuse.

#

wait check.

#

Olivias12 why is password for email? wtf

#

confuse lol

#

@vocal tendon look

#

maybe is okay

#

probably php fix moment.

#

i see

vocal tendon Aug 18, 2022, 2:54 AM

#

Oh you put it in the wrong order?

ashen kestrel Aug 18, 2022, 2:54 AM

#

yes

vocal tendon Aug 18, 2022, 2:54 AM

#

Yeah that will fix

ashen kestrel Aug 18, 2022, 2:55 AM

#

yeah is okay all unity

#

and idk probably problem php

vocal tendon Aug 18, 2022, 2:56 AM

#

Try request it again?

#

With your Unity

ashen kestrel Aug 18, 2022, 2:58 AM

#

@vocal tendon look there have:

#

#

vocal tendon Aug 18, 2022, 2:58 AM

#

Okay, but your parameter order was wrong

ashen kestrel Aug 18, 2022, 2:58 AM

#

werid

ashen kestrel Aug 18, 2022, 2:59 AM

#

vocal tendon Okay, but your parameter order was wrong

how is?

vocal tendon Aug 18, 2022, 2:59 AM

#

ashen kestrel <@307360612403642370> look

you putting username, nickname, email, password

vocal tendon Aug 18, 2022, 2:59 AM

#

ashen kestrel

it should be username, nickname, password, email

#

Do you see it?

ashen kestrel Aug 18, 2022, 3:00 AM

#

sigh is hard see lol

vocal tendon Aug 18, 2022, 3:00 AM

#

see the parameter of CreateUser

ashen kestrel Aug 18, 2022, 3:00 AM

#

NM.CreateUser(m_userNameInput.text, m_nickname.text, m_emailInput.text, m_password.text, delegate (Response response)

#

there?

vocal tendon Aug 18, 2022, 3:00 AM

#

Yes

#

You putting email and then password

#

Order is wrong

ashen kestrel Aug 18, 2022, 3:01 AM

#

how is order wrong.

#

maybe is NM.CreateUser(m_userNameInput.text, m_nickname.text, m_password.text, m_emailInput.text, delegate (Response response)

#

to correct?

vocal tendon Aug 18, 2022, 3:01 AM

#

See Co_CreateUser parameter

#

Yes

ashen kestrel Aug 18, 2022, 3:01 AM

#

ahh

#

i see

#

ahh

#

i see

vocal tendon Aug 18, 2022, 3:02 AM

#

You were passing email as password

#

and vice versa

ashen kestrel Aug 18, 2022, 3:02 AM

#

yeah

#

public void CreateUser(string User, string Nickname, string Email, string Password, Action<Response> response)

#

is correct?

#

good?

#

hmm

vocal tendon Aug 18, 2022, 3:03 AM

#

I think order is wrong on that one too

#

Because it is different from Co_CreateUser

ashen kestrel Aug 18, 2022, 3:03 AM

#

Yeah

#

done fix

#

test play

vocal tendon Aug 18, 2022, 3:04 AM

#

Yes

ashen kestrel Aug 18, 2022, 3:05 AM

#

@vocal tendon

#

work lol.

#

i see

#

remove espaceurl

#

is work @ maybe

#

Done solution @vocal tendon

#

thanks good

#

finishh

#

learn... much little hard

vocal tendon Aug 18, 2022, 3:07 AM

#

Okay it works now

#

Good

ashen kestrel Aug 18, 2022, 3:08 AM

#

yes

ashen kestrel Aug 18, 2022, 3:40 AM

#

@vocal tendon okay good register

#

and problem login no working 500 error

#

D:

#

$result = $pdo ->query($sql);```

#

#1 {main}
  thrown in /home/u746990723/domains/benzitczostudio.com/public_html/noallowspytic/noallowspyfuck/checkUser.php on line 9

vocal tendon Aug 18, 2022, 3:53 AM

#

You should quote them

#

Like ’$User’

ashen kestrel Aug 18, 2022, 4:25 AM

#

@vocal tendon hmm

ashen kestrel Aug 18, 2022, 4:25 AM

#

vocal tendon Like `’$User’`

how is?

ashen kestrel Aug 18, 2022, 4:25 AM

#

vocal tendon Like `’$User’`

where ilol.

vocal tendon Aug 18, 2022, 4:31 AM

#

ashen kestrel where ilol.

Inside of your DB query man

ashen kestrel Aug 18, 2022, 4:31 AM

#

vocal tendon Inside of your DB query man

yeah but have is "table: users"

#

and there user

vocal tendon Aug 18, 2022, 4:31 AM

#

No your parameter needs to be quoted

ashen kestrel Aug 18, 2022, 4:31 AM

#

and there $User = $_POST['User'];

#

?

vocal tendon Aug 18, 2022, 4:31 AM

#

Because they are string

ashen kestrel Aug 18, 2022, 4:31 AM

#

yes same string "User"

vocal tendon Aug 18, 2022, 4:32 AM

#

‘$User’ not just $User

#

Other things too

#

Compare with create account php

ashen kestrel Aug 18, 2022, 4:32 AM

#

vocal tendon ‘$User’ not just $User

wwait what there is $User = $_POST['$User'];

#

?

#

sorry bad understand

#

xd

vocal tendon Aug 18, 2022, 4:33 AM

#

Inside of your SELECT query

#

It’s not PHP it is SQL

ashen kestrel Aug 18, 2022, 4:33 AM

#

there is create account

#

$sql = "SELECT User From users WHERE User = '$User'"

#

and login account

#

$sql = "SELECT User From users WHERE User =$User AND password =$Password ";

#

hmm i see

#

$sql = "SELECT User From users WHERE User = '$User AND password =$Password ' ";

#

probably?

vocal tendon Aug 18, 2022, 4:34 AM

#

You forgot closing ‘

ashen kestrel Aug 18, 2022, 4:34 AM

#

#

@vocal tendon yeah

vocal tendon Aug 18, 2022, 4:34 AM

#

And password too

ashen kestrel Aug 18, 2022, 4:34 AM

#

ashen kestrel

tf

#

work lol.

vocal tendon Aug 18, 2022, 4:35 AM

#

Quote $Password too lol

#

Yeah

ashen kestrel Aug 18, 2022, 4:35 AM

#

Ah missing

#

$sql = "SELECT User From users WHERE User = '$User AND password = '$Password ' ";

#

exactly?

#

error 500 lol

#

what hmm

vocal tendon Aug 18, 2022, 4:35 AM

#

You forgot closing ‘

#

End of ‘$User

ashen kestrel Aug 18, 2022, 4:36 AM

#

ah

#

done

#

#

Work finally @vocal tendon

#

I see

#

but my bad stupid

vocal tendon Aug 18, 2022, 4:36 AM

#

Good work

ashen kestrel Aug 18, 2022, 4:37 AM

#

finally finish

#

and okay

#

thx sorry.

#

you cool help.

vocal tendon Aug 18, 2022, 4:38 AM

#

Have fun with coding

ashen kestrel Aug 18, 2022, 4:40 AM

#

vocal tendon Have fun with coding

yeah true lol

ashen kestrel Aug 18, 2022, 6:13 AM

#

but login web no working werid and there lol

#

oh maybe missing "name="password"" // also forget "select" lol

vocal tendon Aug 18, 2022, 6:19 AM

#

Making website now?

ashen kestrel Aug 18, 2022, 6:19 AM

#

vocal tendon Making website now?

Yes here: https://benzitczostudio.com/new/login/index.php

#

wait problem no working.

#

$sql = "SELECT id, user, password FROM users WHERE user = ?,?,?";

#

there think

#

incorrect?

#

// Initialize the session
session_start();
 
// Check if the user is already logged in, if yes then redirect him to welcome page
if(isset($_SESSION["loggedin"]) && $_SESSION["loggedin"] === true){
    header("location: profile.php");
    exit;
}
 
// Include config file
require_once "config.php";
 
// Define variables and initialize with empty values
$username = $password = "";
$username_err = $password_err = $login_err = "";
 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
 
    // Check if username is empty
    if(empty(trim($_POST["user"]))){
        $username_err = "Please enter username.";
    } else{
        $username = trim($_POST["user"]);
    }
    
    // Check if password is empty
    if(empty(trim($_POST["password"]))){
        $password_err = "Please enter your password.";
    } else{
        $password = trim($_POST["password"]);
    }
    
    // Validate credentials
    if(empty($username_err) && empty($password_err)){
        // Prepare a select statement
        $sql = "SELECT id, user, password FROM users WHERE user = ?,?,?";
        
        if($stmt = mysqli_prepare($link, $sql)){
            // Bind variables to the prepared statement as parameters
            mysqli_stmt_bind_param($stmt, "s", $param_username,);
            
            // Set parameters
            $param_username = $username;
            //$param_server = $server;
            
            // Attempt to execute the prepared statement
            if(mysqli_stmt_execute($stmt)){
                // Store result
                mysqli_stmt_store_result($stmt);
                
                // Check if username exists, if yes then verify password
                if(mysqli_stmt_num_rows($stmt) == 1){                    
                    // Bind result variables
                    mysqli_stmt_bind_result($stmt, $id, $username, $hashed_password);
                    if(mysqli_stmt_fetch($stmt)){
                        if(password_verify($password, $hashed_password)){
                            // Password is correct, so start a new session
                            session_start();
                            
                            // Store data in session variables
                            $_SESSION["loggedin"] = true;
                            $_SESSION["id"] = $id;
                            $_SESSION["user"] = $username; 
                            $_SESSION["password"] = $password; 
                            
                            // Redirect user to welcome page
                            header("location: profile.php");
                        } else{
                            // Password is not valid, display a generic error message
                            $login_err = "Invalid username or password.";
                        }
                    }
                } else{
                    // Username doesn't exist, display a generic error message
                    $login_err = "Invalid username or password.";
                }
            } else{
                echo " 3 Oops! Something went wrong. Please try again later.";
            }

            // Close statement
            mysqli_stmt_close($stmt);
        }
    }
    
    // Close connection
    mysqli_close($link);
}
?>```

#

CM_Hmm

#

error logs:

#

[18-Aug-2022 06:11:38 UTC] PHP Notice: Undefined index: password in /home/u746990723/domains/benzitczostudio.com/public_html/new/login/index.php on line 29

vocal tendon Aug 18, 2022, 6:27 AM

#

no password in $_POST?

ashen kestrel Aug 18, 2022, 6:28 AM

#

vocal tendon no password in $_POST?

yes is.. password post..

#

uhmm

vocal tendon Aug 18, 2022, 6:28 AM

#

did you put name=password thing

ashen kestrel Aug 18, 2022, 6:28 AM

#

vocal tendon Aug 18, 2022, 6:29 AM

#

And you better hard reload your browser too

ashen kestrel Aug 18, 2022, 6:29 AM

#

yes there name="password"

ashen kestrel Aug 18, 2022, 6:29 AM

#

vocal tendon And you better hard reload your browser too

already

#

werid hm

vocal tendon Aug 18, 2022, 6:29 AM

#

Empty cache too?

ashen kestrel Aug 18, 2022, 6:29 AM

#

nah okay other broswer

#

moment

#

already no working lol.

#

https://gyazo.com/da7a6a6ad8da4a886884f2efb55fbb9e

Gyazo

▶ Play video

#

ah found @vocal tendon error

#

[18-Aug-2022 06:27:02 UTC] PHP Warning:  mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in /home/u746990723/domains/benzitczostudio.com/public_html/new/login/index.php on line 42
[18-Aug-2022 06:27:15 UTC] PHP Warning:  mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in /home/u746990723/domains/benzitczostudio.com/public_html/new/login/index.php on line 42```

vocal tendon Aug 18, 2022, 6:32 AM

#

well it’s different error

ashen kestrel Aug 18, 2022, 6:32 AM

#

mysqli_stmt_bind_param($stmt, "s", $param_username);

#

#

think missing password?

ashen kestrel Aug 18, 2022, 6:33 AM

#

vocal tendon well it’s different error

maybe

vocal tendon Aug 18, 2022, 6:34 AM

#

You have 3 parameters as I see

ashen kestrel Aug 18, 2022, 6:34 AM

#

vocal tendon You have 3 parameters as I see

maybe is user , pass and id?

vocal tendon Aug 18, 2022, 6:39 AM

#

I also think that SELECT sql is wrong, you can ask php people

ashen kestrel Aug 18, 2022, 6:40 AM

#

vocal tendon I also think that SELECT sql is wrong, you can ask php people

yeah help is sleep name "hunter" discord

#

xd

#

nothing help who lol

#

waiting reply mod

ashen kestrel Aug 18, 2022, 6:40 AM

#

vocal tendon I also think that SELECT sql is wrong, you can ask php people

maybe but is okay working

#

werid

#

@vocal tendon https://www.tutorialrepublic.com/php-tutorial/php-mysql-login-system.php

#

there found is same code.

#

But probably problem "hash" password

#

success work

#

if (strtoupper(hash("SHA256", $password)) == strtoupper($hashed_password)) { <- solution

ashen kestrel Aug 20, 2022, 1:16 AM

#

@vocal tendon other

#

found better auto login good done

#

and problem register no work "nickname"

#

lol.

#

there look is okay?

vocal tendon Aug 20, 2022, 1:30 AM

#

Is your table/column/parameter names all correct

ashen kestrel Aug 20, 2022, 2:19 AM

#

vocal tendon Is your table/column/parameter names all correct

Yeah okay memory

#

already.

#

and last problem register no work maybe script unity

#

#

when "nickname no coinicde" problem why already nickname button

#

no sent sumbit register.

#

#

@vocal tendon

#

maybe think problem "user" missing text?

vocal tendon Aug 20, 2022, 2:28 AM

#

Well you need username and password with that php

ashen kestrel Aug 20, 2022, 2:28 AM

#

Ah

#

but not is == ""

#

wrong maybe.

#

wait second idea

ashen kestrel Aug 20, 2022, 2:29 AM

#

vocal tendon Well you need username and password with that php

No need but

#

my idea there is Steam

#

ID steam + nickname

#

not password.

#

Or yes password (random)

#

think my idea.

ashen kestrel Aug 20, 2022, 2:29 AM

#

vocal tendon Well you need username and password with that php

i know have id and pass

#

is working success

#

and now remove pass and user + nickname test

#

@vocal tendon question how auto text TMP_InputField?

#

think same usertext.text = "nick"?

vocal tendon Aug 20, 2022, 2:35 AM

#

Yes

ashen kestrel Aug 20, 2022, 2:35 AM

#

ok

#

@vocal tendon and there is public void start correct?

#

auto text usertext.text = "nick"?

#

right?

#

ok done cool

#

@vocal tendon why problem no work nickname

#

CM_Hmm

ashen kestrel Aug 20, 2022, 2:55 AM

#

ashen kestrel <@307360612403642370>

@vocal tendon you see there SubitRegister

#

is problem solution?

#

is work or bad incorrect?

#

why do not understand problem nickname

#

#Help mysql - database - unity