[PHP] Error

I need help fixing this:

Code:

---

Warning:  mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Array' to data type int. (severity 16) in C:\AppServ\www\test\rebirth\index.php on line 101

Warning:  mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\test\rebirth\index.php on line 101

---

This is the PHP code:

PHP Code:

---

                                        $q = mssql_query("SELECT * FROM Character WHERE AID = '".$_SESSION['AID']."'");

                                        echo "<form method='post' action='index.php?action=rebirth'>";
                                        echo  "<select name='re' class='login'>";

                                        while($fetch = mssql_fetch_array($q))
                                        {
                                            echo "<option class='login' value=".$fetch['Name'].">".$fetch['Name']." - Lv.".$fetch['[Level]']."</option>";
                                        }

                                        echo "</select>";
                                        echo "<br><br><input type='submit' name='rebirth' class='login' value='Rebirth' />";
                                        echo "</form>";
                                    ?> 


---

What is going on? The only one of those options that is int is Level, and its a smallint datatype

Im guessing Line, 101
is

PHP Code:

---

$q = mssql_query("SELECT * FROM Character WHERE AID = '".$_SESSION['AID']."'"); 


---

try this,

PHP Code:

---

$int = (int)$_SESSION['aid'];
$q = mssql_query("SELECT * FROM Character WHERE AID = '".$int."'"); 


---

PHP: Type Juggling - Manual

xd 500th post is helping you<3 Enjoy xd

lol congratulations.
Unfortunately, that did fix the error, but nothing shows up on the list even though there are characters connected to that account.

EDIT: I found out what the issue is. The problem is, I'm using this with another website. The script works perfectly on its own, but when I access it with the website I'm using it with, I'm already logged in like the script is using the session from the previous website (which it shouldn't, there should be an external log-in form for the rebirth script, using its own sessions.)

Mind helping me out on fixing that?

I don't really understand your issue, sense php sessions aren't cant go from server to server, I'd suggest clearing cache, cookies, ect.

Not from server to server. It's hosted on the same place, locally
BlueGunZWeb > Rebirth PHP Script in BlueGunZWeb folders.
I linked to the Rebirth Script on the BlueGunZWeb.

When I click on the link from the BlueGunZWeb, I'm already logged in on the Rebirth Script, and it shows that error.
When I use The Rebirth Script's logout function to where it shows it's login screen, I log in using that and it works fine.

I'm thinking the session is being brought into the Rebirth Script from the BlueGunZWeb, as most webs only destroy their sessions when the user logs out.

Quote:

---

Originally Posted by wesman2232

Not from server to server. It's hosted on the same place, locally
BlueGunZWeb > Rebirth PHP Script in BlueGunZWeb folders.
I linked to the Rebirth Script on the BlueGunZWeb.

When I click on the link from the BlueGunZWeb, I'm already logged in on the Rebirth Script, and it shows that error.
When I use The Rebirth Script's logout function to where it shows it's login screen, I log in using that and it works fine.

I'm thinking the session is being brought into the Rebirth Script from the BlueGunZWeb, as most webs only destroy their sessions when the user logs out.

---

Are both scripts hosted on the same web server? If so then yes the session would be passed, because the session names are all the same, that's a good thing, if your planning on intergrating it directly into BlueGunzWeb. So what error are you getting because it should still work fine.

Yes, both scripts are hosted on the same server.
I'm not getting any error after I used your little fix, which is the problem.
The Option to choose your character is there, but no names show up in it when the sessions are passed.
It works perfect however, when I log in with the rebirth script itself.
Maybe some of the headers/sessions are a bit different? Cause the original error was "Conversion failed when converting the varchar value 'Array' to data type int."

Put print_r($_SESSION); on top of the rebirth script (after session_start();) and check if the variables are set/correct.

Quote:

---

Originally Posted by SuperWaffle

Put print_r($_SESSION); on top of the rebirth script (after session_start();) and check if the variables are set/correct.

---

When accessing the script by itself:

Code:

---

Array ( )
Warning:  Cannot modify header information - headers already sent  by (output started at  C:\AppServ\www\BlueGunzWeb\rebirth\secure\config.php:4) in C:\AppServ\www\BlueGunzWeb\rebirth\secure\functions.php on line 123


---

The warning only shows up when trying to login using the rebirth script.

When accessing using logged-in BlueGunZWeb:

Code:

---

Array ( [UserID] => wesman2232 [AID] => Array ( [AID] => 3 ) [UGradeID] => 255 [Password] => fbee5f212ae661f387d4c249531b1880 [URL] => [PageTitle] => [user] => wesman2232 )

---

PHP Code:

---

Warning:  mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Array' to data type int. (severity 16) in C:\AppServ\www\BlueGunzWeb\rebirth\index.php on line 101

Warning:  mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\BlueGunzWeb\rebirth\index.php on line 101 


---

I'm assuming it's the AID part, but how do I fix that?
Since it works by itself, I was thinking maybe make a function that destroys the session when I use that link. Or even fixing it this way would be better since they are already logged in.

Quote:

---

Originally Posted by wesman2232

When accessing the script by itself:

Code:

---

Array ( )
Warning:  Cannot modify header information - headers already sent  by (output started at  C:\AppServ\www\BlueGunzWeb\rebirth\secure\config.php:4) in C:\AppServ\www\BlueGunzWeb\rebirth\secure\functions.php on line 123


---

The warning only shows up when trying to login using the rebirth script.

When accessing using logged-in BlueGunZWeb:

Code:

---

Array ( [UserID] => wesman2232 [AID] => Array ( [AID] => 3 ) [UGradeID] => 255 [Password] => fbee5f212ae661f387d4c249531b1880 [URL] => [PageTitle] => [user] => wesman2232 )

---

PHP Code:

---

Warning:  mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Array' to data type int. (severity 16) in C:\AppServ\www\BlueGunzWeb\rebirth\index.php on line 101

Warning:  mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\BlueGunzWeb\rebirth\index.php on line 101 


---

I'm assuming it's the AID part, but how do I fix that?
Since it works by itself, I was thinking maybe make a function that destroys the session when I use that link. Or even fixing it this way would be better since they are already logged in.

---

Seems like you have a nested array when it comes down to AID. $_SESSION['AID']['AID'] should do the trick. If your PHP version doesn't directly support access to nested arrays, this should work:

PHP Code:

---

$rgAID = $_SESSION['AID'];
// Use $rgAID['AID'] in query now 


---

Or, of course, UserID style

PHP Code:

---

mssql_query("SELECT C.* FROM Character C, Account A WHERE A.UserID = '" . $_SESSION['userid'] . "' AND A.AID = C.AID"); 


---

Quote:

---

Originally Posted by Wizkidje

Seems like you have a nested array when it comes down to AID. $_SESSION['AID']['AID'] should do the trick. If your PHP version doesn't directly support access to nested arrays, this should work:

PHP Code:

---

$rgAID = $_SESSION['AID'];
// Use $rgAID['AID'] in query now 


---

Or, of course, UserID style

PHP Code:

---

mssql_query("SELECT C.* FROM Character C, Account A WHERE A.UserID = '" . $_SESSION['userid'] . "' AND A.AID = C.AID"); 


---

---

Thank you so much. $_SESSION['AID']['AID'] worked. Had to do the same changes in my rebirth function to make it work as well.
Been awhile since I've seen you here Wizkidje. Coming back to GunZ for a bit?

Quote:

---

Originally Posted by wesman2232

Thank you so much. $_SESSION['AID']['AID'] worked. Had to do the same changes in my rebirth function to make it work as well.
Been awhile since I've seen you here Wizkidje. Coming back to GunZ for a bit?

---

Nah, never intended nor willing to come back to GunZ. I just happen to hang around these forums when I feel like it, considering there's still some people around here I consider as friends. Mostly trolling though, but considering you're a good guy, I decided to help you out.

Quote:

---

Originally Posted by Wizkidje

Nah, never intended nor willing to come back to GunZ. I just happen to hang around these forums when I feel like it, considering there's still some people around here I consider as friends. Mostly trolling though, but considering you're a good guy, I decided to help you out.

---

I see. Well, I appreciate it. Good luck with whatever your current projects are.

Quote:

---

Originally Posted by wesman2232

I see. Well, I appreciate it. Good luck with whatever your current projects are.

---

I have none, I've graduated from college, moved on to uni, rarely doing projects any-more due to huge lack of time. How come you're still here?

Quote:

---

Originally Posted by Wizkidje

I have none, I've graduated from college, moved on to uni, rarely doing projects any-more due to huge lack of time. How come you're still here?

---

I usually just lurk around on here now. Not much to do with GunZ anymore. Working with DaemonsRing Rebirth though, I still like GunZ to an extent. Out of High School, working a good job, living with my girl, just something to do on my free time.