Topic: PunBB Messes With My Queries
I am implimenting the login system into my php script and PunBB seems to have broken it.
It looks as if it's adding "punbb." in front the table names in my MySQL queries. Why? 
- quaker
- Senior Member
- Offline
Re: PunBB Messes With My Queries
link?
q
My stuff or my style might sux, but atleast I'm willing to help when I can.
Don't be stupid and help ! We are the stupid one's !!!
Don't be stupid and help ! We are the stupid one's !!!
Re: PunBB Messes With My Queries
http://flaminghead.servegame.com:12345/ … category=2
This is the line with the query:
$tut_query = mysql_query("SELECT * FROM ortz_tuts WHERE id='".$row['id']."'") or die(mysql_error());- quaker
- Senior Member
- Offline
Re: PunBB Messes With My Queries
you need the cookies and seesion at the top of the index page..
http://bunpai.com ---. forum website integration..
that is the index.php file that i used..
My stuff or my style might sux, but atleast I'm willing to help when I can.
Don't be stupid and help ! We are the stupid one's !!!
Don't be stupid and help ! We are the stupid one's !!!
- quaker
- Senior Member
- Offline
Re: PunBB Messes With My Queries
<?php
define('PUN_ROOT', './');
define('PUN_QUIET_VISIT', 1);
require PUN_ROOT.'include/common.php';
define('PUN_ALLOW_INDEX', 1);
require PUN_ROOT.'lang/'.$pun_user['language'].'/index.php';
require PUN_ROOT.'lang/'.$pun_user['language'].'/common.php';
require PUN_ROOT.'lang/'.$pun_user['language'].'/topic.php';
require PUN_ROOT.'lang/'.$pun_user['language'].'/login.php';
require PUN_ROOT.'include/parser.php';
?>
My stuff or my style might sux, but atleast I'm willing to help when I can.
Don't be stupid and help ! We are the stupid one's !!!
Don't be stupid and help ! We are the stupid one's !!!
Re: PunBB Messes With My Queries
Err, that's a database called PunBB (I assume where you have your forum).
It's not PunBB doing anything, actually
mysql_query defaults to using the last opened database connection if no connection is specified
So, if you connect to your database and then connect to PunBB's, all your queries will be directed at PunBB's connection
7 2006-06-05 22:19 (edited by ortzinator 2006-06-05 22:24)
Re: PunBB Messes With My Queries
I have that already. It's already intigrated, it's just messing up my queries somehow.
Edit: Ok, I think I know how to fix it now, thanks.
Edit2: Yep, it's fixed, thanks! 