You shuld try this tutorial
http://www.freewebmasterhelp.com/tutorials/phpmysql/1
With help of this, I learned how to use MySQL. 
PS: I hope you know php.
1 2007-08-01 21:12
Re: baseball /mySQL (10 replies, posted in Programming)
2 2007-07-14 19:44
Re: How to get logged in users avatar picture name? (2 replies, posted in PunBB 1.2 modifications, plugins and integrations)
<?php
if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$pun_user['id'].'.gif'))
$user_avatar = '<img src="'.$pun_config['o_avatars_dir'].'/'.$pun_user['id'].'.gif" '.$img_size[3].' alt="" />';
else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$pun_user['id'].'.jpg'))
$user_avatar = '<img src="'.$pun_config['o_avatars_dir'].'/'.$pun_user['id'].'.jpg" '.$img_size[3].' alt="" />';
else if ($img_size = @getimagesize($pun_config['o_avatars_dir'].'/'.$pun_user['id'].'.png'))
$user_avatar = '<img src="'.$pun_config['o_avatars_dir'].'/'.$pun_user['id'].'.png" '.$img_size[3].' alt="" />';
echo"$user_avatar" ?>
Ok I found out.
3 2007-07-14 15:47
Re: How to get logged in users avatar picture name? (2 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Ok I see, they are related to users id somehow.
4 2007-07-14 15:32
Topic: How to get logged in users avatar picture name? (2 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Hi, my question is in subject. Thanks for help.
5 2007-07-13 11:39
Re: LOVE Punbb, but...got a question on signups (17 replies, posted in General discussion)
Anyway, I don't think you shuld be worried if he don't spam in your forum.
6 2007-07-13 11:35
Re: LOVE Punbb, but...got a question on signups (17 replies, posted in General discussion)
Well "Bpfzwpzp" doesn't look like a human user name. You can ban his ip adress for creating multiple accounts. If he has the same ip adress as all those accounts you are talking about.
7 2007-07-13 11:31
Re: LOVE Punbb, but...got a question on signups (17 replies, posted in General discussion)
Did he ever posted something?
8 2007-07-13 11:29
Re: LOVE Punbb, but...got a question on signups (17 replies, posted in General discussion)
Are you sure he is not a bot?
9 2007-07-13 09:11
Re: Get user information (5 replies, posted in PunBB 1.2 modifications, plugins and integrations)
I'm not sure if these are the best examples:
if($pun_user['g_delete_topics'] == '1'){echo"You are admin or moderator ";} You check with this if a user have premissions to delete topics what usually have only admins and moderators.
if($pun_user['username']! == "Guest"){echo"You are logged in as a user"} Use this to check if a user is a member.
10 2007-07-08 18:55
Re: [Solved] Switching from SQLite to MySQL (9 replies, posted in PunBB 1.2 troubleshooting)
Ok, I made some mistakes, now it's working. Thank you pedrotuga for your help. 
11 2007-07-08 18:08
Re: [Solved] Switching from SQLite to MySQL (9 replies, posted in PunBB 1.2 troubleshooting)
Well, I was able to copy users, PM-s and other stuff but but I had no luck with forums and posts. I recrerated them in mysql but nothing shows up on forum index. 
12 2007-07-08 00:24
Re: [Solved] Switching from SQLite to MySQL (9 replies, posted in PunBB 1.2 troubleshooting)
I will do what you said, but I would rather copy the create table statements from install.php. I find it easier but actually it isn't
13 2007-07-07 23:41
Re: [Solved] Switching from SQLite to MySQL (9 replies, posted in PunBB 1.2 troubleshooting)
pedrotuga wrote:
It's not so difficult, but yes, it's a bit tricky due to sqlite being typeless. Punbb database schema is the exact same if you use sqlite or mysql, it couldn't be other way anyway.
So, this is what i suggest for unexperienced users:
1. Create a fresh installation of punbb with a mysql database.
2. Using a mysql management tool like pypmyadmin, sqlyog, whatever, generate a SQL file containing the 'create table' statements. Save that file.
3. using a sqlite management tool create a sql file with the insert statements and save it too.
4.create a new empty database on your mysqlserver.
5.Populate your database, use the first sql file to create the tables and the last one to insert the data on them.
6.delete the instalation and database created on point 1
Well, that sounds damn complicated. I came up with an idea, that I could modify my config.php, and covert the sqlite database to mysql with a program or php script or something. What you think?
14 2007-07-07 19:26
Re: [Solved] Switching from SQLite to MySQL (9 replies, posted in PunBB 1.2 troubleshooting)
Rich Pedley wrote:
unless you have written some specific sqlite queries it should just be a matter of transferring the data from the sqlite database to the mysql one.
No, but I have no idea how could I do that, I was searching for some software but i didn't find anything.
15 2007-07-07 16:50
Topic: [Solved] Switching from SQLite to MySQL (9 replies, posted in PunBB 1.2 troubleshooting)
Hi, I would like to take my web page to another web hosting company, but they don't have SQLite support. Do you know any way how could I convert my heavily modified SQLite forum/page to MySQL? Thanks
16 2007-02-02 14:44
Re: Error installing new mod. (4 replies, posted in PunBB 1.2 troubleshooting)
Smartys wrote:
Moved to Modifications
I assume the create table statement doesn't work with SQLite, only with MySQL
So is there any way how to install a modification on phpBB forum running on SQLite database?
17 2007-02-02 12:36
Topic: Error installing new mod. (4 replies, posted in PunBB 1.2 troubleshooting)
I get this error whenever I try to install new mod. I really don't know what to do. Any help would be appreciated. I'm using Database SQLite 2.8.14.
File: /share/HDA_DATA/Qweb/install_mod.php
Line: 33
PunBB reported: Unable to create table foo_chatbox_msg.
Database reported: SQL logic error or missing database (Errno: 1)