MYSQL :: MySQL Query Linking OpenCrypt & PhpBB

MySQL Query For PhpBB
i want to display 5-10 latest phpBB2 posts on my homepage, and i know there are mods for the forum's index page that do similar thing, but i want to do it in my Perl script. I know how to connect to mySQL DB, but I don't know SQL..
could someone help me with mySQL query for X latest posts, so I would get the result containing user name, post topic, post date&time and post text?

Help Rewriting A Slow Phpbb Query
I have a "glance" or "Recent Topics" list on my forums that have become fairly complex. I modified an already feature rich glance mod to allow users to select individual forums to exclude from showing topics in the list. As well when users are members of certain forum groups, they see topics from the group forum in the list, and they are highlighted a different colour.

The main SQL query to create the list often is showing up in the MySQL Slow_query log and I'm pretty sure is the main cause for the page loading slow.

I am no mysql Guru, so I thought I would seek the advice of some to improve or totaly rewrite this slow query.

PHP

$sql = "SELECT
    f.forum_id, f.forum_name, t.topic_title, t.topic_id, t.topic_last_post_id, t.topic_poster, t.topic_views, t.topic_replies, t.topic_type,
    p2.post_time, p2.poster_id,
    u.username as last_username,
    u2.username as author_username
FROM "
    . FORUMS_TABLE . " f, "
    . POSTS_TABLE . " p, "
    . TOPICS_TABLE . " t, "
    . POSTS_TABLE . " p2, "
    . USERS_TABLE . " u, "
    . USERS_TABLE . " u2
WHERE
    f.forum_id NOT IN (" . $forumsignore . $glance_recent_ignore . ")
    AND t.forum_id = f.forum_id
    AND p.post_id = t.topic_first_post_id
    AND p2.post_id = t.topic_last_post_id
    AND t.topic_moved_id = 0
    AND p2.poster_id = u.user_id
    AND t.topic_poster = u2.user_id
ORDER BY t.topic_last_post_id DESC";
$sql .= ($glance_recent_offset) ? " LIMIT " . $glance_recent_offset . ", " . $glance_num_recent : " LIMIT " . $glance_num_recent;

The "NOT IN" list varies per user, but here is an example:
NOT IN (77,75,76,25,26,37,63,64,66,67,67,1,25,26,37,70,28,75,76,78)

Phpbb With Mysql
Im going to uss phpbb as my forums but i dont have a clue where to get started. I know i have to create a database with mysql so it can connect, but i need help on how to start the database what should i put in it etc. I think i can use phpadmin, if i'm right. My host provides me with sql database and sql. Can any please help so i can get this working.

MySQL With PHPbb?
Is it enough to just install mySQL on the webbserver for the phpbb-forum to work? Or do I have to create my own database-files with predefined tables too?

Mysql Login Error For Phpbb.
what i am used to do, if i have to select more rows by their id's i write

"SELECT * FROM table1 WHERE id IN (1,2,3,4,5)"

how can i do this via Execution in adodb (http://phplens.com/adodb/) ?

if i pass array, adodb starts complaining, if i implode it, it adds quotes around the string... any help?

$ado -> Execute("select * from table1 where id IN (?)", array(array(1,2,3,4,5)) ) //this does not work:(

Help With MYSQL And PHPBB On Server 2003 Standard
Trying to get help with this situation. I have installed PHPBB, PHP (4X) and
MySQL 4.1.

This is how I started out.

1. Installed MYSQL - ran setup - did FULL install - and entered in new
password when requested. MYSQL gave the green light when computer rebooted.
Created new database with CREATE DATABASE XXX; Also installed ODBC from
MYSQL site and created a "SITE DSN" for the ODBC

2. Installed PHP and verfied working and accessible

3. Installed PHPBB per the instructions on the site. Did the permissions as
instructed on config.php and install.php

4. Came to the install screen. Entered the info and password that I did with
MYSQL installation (Root was the username)

NOW SAYS - CANNOT CONNECT TO THE DATABASE. I do not know what to do at this
point.

Linking Asp.net And Mysql
has anyone used both odbc and .net providers such as ByteFX and
MySQLDriverCS? Is there a great difference in speed?

Linking MySQL To MS SQL
I have a table in a Microsoft SQL Server database that I need to access from a MySQL database. Can I make a symbolic link between the two? I can't just import the data because it's something that gets regularly updated, but I need to work with it in MySQL.

Linking Access To MySQL
Is there a way to link my Access database on my home computer to the MySQL database on my remote website, so that when I change something in Access, it changes it on the remote MySQL database automatically?

Linking MYSQL Database
I'm trying to access mySQL db from a uni webserver using ASP. Uni have given a DSN and the user name and password but im unsure of the code that need to connect to it. Ive tried many times without joy and its getting very frustrating.

Linking Of HTML And Mysql
can u show me some example to link the HTML and the Mysql?

Linking MySQL Database With C++ 5.0
I recently downloaded MySQL ver4.1. I seem to be getting the hang of importing files into databases and all that stuff, but I'm having trouble when it comes to my C++ program. I'm currently using VBC++ 5.0.

What my main question is what extra programs or libraries do I need to incorporate MySQL into my C program. Do I need a C++ wrapper or something of that nature?

Linking MySQL Tables
I have a Providex database that has a ODBC driver and I can import tables or queries into excel fine. The problem is I have to MANUALLY refresh the excel file DAILY so that the end of day report items are updated from the database into the excel sheet.

What I would like to do is link the necessary tables in Providex to a MySQL table and then run the queries on the MySQL table. In doing so, I would need the MySQL table to constantly refresh with the Providex database or at least make it where I could refresh it periodically throughout the day.

I know that it is possible to link tables in Access to automatically update when the source is changed, is there some of the same functionality in MySQL? I really don't have any experience with MySQL but have some experience with SQL queries from Microsoft Query and ASP webpages. Any examples or webpages that may outline the process would be great as well.

Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with
this command:

linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl

But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and
try again, then I got the messages like

/tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc':
/usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress'

My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files
from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries
are installed at /usr/lib/mysql, and include files are at /usr/include/mysql.
Can anybody tell me how I can configure my system to make it work?

Linking Site To MySql Database
I have bought the PHP and Database book and have created a database [windows](saved under the default directory under Program FilesMySql...) and I have created a server. How do I link the website (localhost - same PC as one with MySQL) with the database or is it done automatically?

Linking Two MySql Members Tables To = One
I have set up a forum as well as user auth into the heart of my site - however - I am still new to creating systems such as I have been working on and did not consider a repetitive user authentication system - I have two login forms - one for the forum on one database (in its own table) and one for the site itself on another database (in its own table) - Is there a way I can link the main site's user auth - to that of the forum auth and use only one members login and registration database for the whole site - instead of having multiple logins through out the site???

Phpbb
I am trying to set up PHPbb on my website using MySql 4.1 for my forums and I can't figure out how to create a new database and connect the database to the actual site and also I need to locate my:

1 database name
2 username
3 password

Linking HTML To A Mysql Data Source
I have a question and perhaps one of the bright sparks here can guide our thoughts.

1. We have a mysql based application that we use in our daily business operations. Capture information and then it drags it through to the web (php pages)

we have started a linking programme with other sites, but its a banner at the mo that simply links back to the main site. I would like that banner to be dynamic - i.e. change as the content (info feed) on our site changes) problem is HTML does not speak to mysql (so I am told).

I have seen simmilar feeds using JSP (Java server pages) - obviously with the HTML only calling the JSP page. which has the dynamic content.

Any suggestions as to how to tacle this problem? We do have a great programmer on the team, but this is new to him.

Linking MySQL & Private Inventory Mgmt Software
I created my own MySQL database to manage my inventory, and am now hosting other organizations' inventory on my site as well.

Has anyone ever heard of someone linking up a private inventory management software package with an active MySQL database, such that changes in the private package can by uploaded into MySQL as well?

PHPBB Forums
I have MySQL 4.0 installed on my computer. I tried to install the PHPBB forums and set it to MYSQL 4.0, but i dont know a valid host name, or database name, database username, and password. How can i figure these things out.

How To Read Phpbb
php file is loaded as codes on windows, but when u upload it on web u get the codes showed as image and stuff, so my question is, when using local host (windows xp) what prog or how i can see the php files not as codes/source when opening but as image or table or whatever.

Phpbb And Firefox
I am developping a forum using phpbb 2.0.17 (the lastest version). My forum url is www.qnhl.com. The problem is the following:
When you make a new post in a specific forum, this forum should show the "new post" icon instead of the "no new post" one.

But it's not the case in Mozilla firefox. The "no new post" is always there. What's the problem? Anything related with cookies? Note that I don't have this problem with Internet Explorer.

Phpbb Forum
I'm experiencing some problems trying to get my phpbb forum to work with mysql. I'm running the newest version of apache, and php is installed and working, but I'm not quite sure about what I have to do with the MySQL database part to get it working. If anyone knows of any tutorials or anything I would be grateful
Just for reference: I'm a newb when it comes to both php, and MySQL.

Phpbb: Username Already Taken After Deleting
I tested to delete phpbb user where user_post = 0.
After deletion, the query exe as normal.
But when I start to register, the phpBB immediately shows

Sorry, but the username is already taken.

instead of showing registeration form.

PhpBB Slow Loading
my site runs quickly except when a user hits forum (allready signed in or logging in) to login to the forums it takes 10x as long to get to the forums as it does the rest of the site, once in the forums its ok and runs as normal,is there any settings in SQL that can speed this up? or is there another problem.

PHPBB Can't Connect To Database
So i'm running Apache, PHP, and MySQL 4.x/5.x (i've attempted both) on Win2k.
When i try to install phpBB2 it says it can't connect to the database

Connection to database
You have not established a connection to MySQL 4.x.
ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO)

Your database was not found.
ERROR: Access denied for user 'ODBC'@'localhost' (using password: NO)

Editing Not Working In PhpBB
After transfering my forum from one server to another, editing stopped working. You can go to phpBB's edit link, but when you try to edit the post nothing is changed. Topic titles can be edited, but nothing else can (including uploaded files with the attachment MOD).

If I edit it directly from phpMyAdmin it will work fine, but editing through the forum does nothing. On the last server it worked fine, although I'm pretty sure on my last server I was running on an older version of MySQL (3.x). On my new host (globat) I'm on MySQL 4.1.Nothing was changed in phpBB's scripts since the transfer, so nothing would have taken away the ability to edit post text. If anybody knows what is stopping these things I would greatly appreciate the help, since I've been looking for a solution for quite some time now.

Seprate Database For PHPBB
I have a databse for the main website that will contain ~15 tables.
Are there any advantages/disadvantages to merging and seprating and what is generally the best way to go?
I'm also interested to hear about (other) situations in wich you would choose for an additional database to increase my insight in the subject.

Tables Import PhpBB/phpNuke
My existing site is ok but limited and I'm now at the point where I would like to use a CMS, but I want to import all the old sites membership and comments into the new install.

I HAVE A SCRIPT THAT WILL DO THIS called. phpbb_nuke_conv.tar should anyone else ask.

but for this to happen the phpBB data must be in the same database where the nuke data resides, ie moving the phpBB tables over to the nuke SQL database. The prefixes are different so there no problems there, could someone please point set-by-step for this proceedure.

I'm sure it only a few buttons and it would save me an ENOURMOUS amount of time reading about a subject I would rather not.

A Seprate Database For PHPBB Or Merge The Tables With The Site?
I have a databse for the main website that will contain ~15 tables. Are there advantages/disadvantages to merging the phpBB tables with the one from the site or seprating the tables sets in 2 different databases?

Making Site Login Add Users To Phpbb Database Table
I have a login script for my site that I got off the net and was planning to use, but, I also wanted to make it so that when a user signed up thru the registration form it would also add them to the phpbb database's table. It wasn't discussed heavily from where i got the script but from what was mentioned the encryptions differ which results in a rejected login. Code:

Linking Stores With Products (was "MySQL Dificult Code")
I have a MySQL database dificult (for me anyway..).
I have a ecommerce site with a table of products.
Now I want to create a new table with a list of stores where clients can find near home those products. In a limit situation I can have a list of all products indexed in one store (and the products list is increasing everyday, the same with the list of store...). I want this feature to be capable of introdution of new products in a store that already as several products.
My idea is to develop 3 tables:

Products
+----+-----------+--------------+
| id | name | description |
+----+-----------+--------------+
| 1 | xxxxx | aasa... |
| 2 | vvvvvv | asasasasas... |
+----+-----------+--------------+

Stores
+----+-------------------+-----------+
| id | store | address |
+----+-------------------+----------+
| 1 | aaaaa | street1... |
| 2 | bbbbbb | street2... |
+----+-------------------+-----------+

Linking stores with products
+----+-------------------+-------------+
| id | store id | products id |
+----+-------------------+-------------+
| 1 | 1 | 1;2 |
| 2 | 2 | 2 |
+----+-------------------+-------------+

Can I implement this in MySQL? I mean how can (if I can) place several ids in a field? and how can I do the query in order to list the products inside a store?
Hope that I made my self clear. If not please do not hesitate to request further information.

Linking Tables
In my database, I have two tables. The main table has a field named 'category'. The second table has a field named 'webcategory'. The main table is the table I use for all my queries as it holds all of the stock details. However, the category field is not suitable for web use, so someone (not me!) has created the second table which takes all categories and provides a web category.

I need to somehow link the 'category' field to the 'webcategory' field so that when displayed on a web page the 'category' changes to display the relevant 'webcategory'.

Linking With SQLBase
As a company, we are currently looking inot replacing our current Paradox (Yes some people do still use it) with MySQL and a Visual Basic 6/NET front-end.

However, we also use a rather large database run on Gupta SQLBase. Does anyone know if it is relatively easy and pain free to link MySQL with SQLBase?

Linking Databases
is it possible to link databases within mysql? I have a access =
database that I need to import into mysql this db consists of 4 other =
dbs linked together sharing a common switchboard. Can I link the tables =
in one db to tables in another db?

Linking Three Tables Together
I have used MySQL to create a DB to keep track of baseball stats and player profiles. I have created one table to keep track of player details (name, age, ht. wt., etc.). I have created a 2nd table which holds stats for 2004 (ab, h, 2b, 3b, hr, etc.). I thought that I could link the tables together based on id which is the primary key.

I will have a 3rd table which will hold 2005 stats etc, etc, etc. Can I do this?? When I am making a query can I link the tables together? I am not sure how to do this. I have read a couple tutorials, but they are slightly different then the way I would like to use my data.

Linking To Other Databases
In Access i can link across multiple databases.

I can link to an Oracle database and run queries and local make tables.

Can I do this in MySQL?

Linking Databases
is it possible to link databases within mysql? I have a access = database that I need to import into mysql this db consists of 4 other = dbs linked together sharing a common switchboard. Can I link the tables = in one db to tables in another db?

Linking Tables?
I have a table which stores user information...

User:
User_ID
Name

and i have a table the stores Contest Results

Contest_Results:
User_ID
Contest_ID
Votes

i have done this query

SELECT * FROM Contest_Results WHERE Contest_ID = $Contest_ID ORDER BY $Votes Asc

Now i want to list all the users Names Who have entered the contest which i just queryed... How do i do this? Code:

Linking To Access
Is there a way to create a database which will link and stay linked to an Access database?

Linking Databases
is it possible to link databases within mysql? I have a access database
that I need to import into mysql this db consists of 4 other dbs linked
together sharing a common switchboard. Can I link the tables in one db to
tables in another db?

Linking Tables
i have two databases set up, one is called test and contains phpbb2 data from my forums. the other is called chat and contains data for voodoo chat. What i would like to do is link or synchronise the tables that contain user data.

There is one in test called phpbb_users, i have imported this to the chat database for testing purposes. there are around 4 fields that i want to link which are:

DB from: Table From: DB to: Table To:
test phpbb2_users chat voc_users

Fields to match:

test: chat:
user_id id
user_name nick
user_sig user_info
user_lastvisit last_visit
user_email registration_email

Linking Indexes
I have two tables...

tbl_one
id two_id info_a info_b
tbl_two
id info_c

And what I want to do is link `two_id`, an index to the `id` field in `tbl_two`. Then I basically want to be able to display data (specifically `info_c`) by referring to the `two_id` field. What would be the easiest way to achieve this?

Linking An Echo
i have this messaging script that i use on a site and i added on the front page when the user logs in a box that says the last message received was on and i got an echo date.is there a way to link that date in the echo tag to the message?

Linking Telecom
I would like to know what technology(s) would enable a user to dial a phone number, then dial an "extension" number that retrieves data from a database and speaks the data back to the caller. An example of what I am describing is when you call an airline, dial the flight number, and you get a real-time update of that plane's progress.

MySQL Query Linking OpenCrypt &amp; PhpBB

MySQL Query Linking OpenCrypt & PhpBB