Symbian website listings

Nice idea 😃
Looking good so far.
The voting system should use cookies, so cant vote more that once for
same link.

Ok, its done that way 😃 nice.

Yo brothers, i just install the phpBB in my server, i have some little problem in setting it up. It say i need to install it, DSN, database, password, bah bah... do you have any example of the setting config on windows platform? 😞

You need to input the name of your MySQL database, username and password

Database name will look something like this: symbian_world_1

Localhost will sometimes work too 😉

Here is mine 😃

$db_host = "localhost"; // Your mySQL server host address
$db_name = "symbian-world_com_1"; // The name of the database to use
$db_user = "[email protected]"; // Your mySQL username
$db_pass = "******"; // Your mySQL password

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL Server Host 'mofhq122/forum' (10110) in D:\wwwroot\phpBB2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in D:\wwwroot\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in D:\wwwroot\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

WTF????

Have u got a MySQL database installed in your server?

YES!!! version 4

Data directory is in d:\data\
Server runnining in c:\mysql\bin\

I really have no ideal what happen, in asp, i just need to connect via DSN connection with ODBC or a DSNless connection. This one i have problem coz i am new to php files....

Tell me about it! My MSc Final Project was "ASP vs PHP in respect to database connections". ASP is very easy but PHP is faster because it is more direct.

Anyways, how does your configuration file look like?

See Jordans example and show us yours!

I will post the script here when i get to office tomorrow... took a day off to settle my phone problem with my ventor

[quote="Edgedale"]Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL Server Host 'mofhq122/forum' (10110) in D:\wwwroot\phpBB2\db\mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in D:\wwwroot\phpBB2\db\mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in D:\wwwroot\phpBB2\db\mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

WTF????[/quote]

Are you sure that is the correct host?
Unless you have a nice DNS set up that sounds strange.
telnet to it dos command: telnet mofhq122/forum 10110
Maybe download a simple sql client to test....

<?php
/***************************************************************************
* mysql4.php
* -------------------
* begin : Saturday, Feb 13, 2001
* copyright : (C) 2001 The phpBB Group
* email : supportphpbb.com
*
* $Id: mysql4.php,v 1.5 2002/04/02 21:13:47 the_systech Exp $
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/

if(!defined("SQL_LAYER"😉)
{

define("SQL_LAYER","mysql4"😉;

class sql_db
{

var $db_connect_id;
var $query_result;
var $row = array();
var $rowset = array();
var $num_queries = 0;
var $in_transaction = 0;

//
// Constructor
//
function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)
{
$this->persistency = $persistency;
$this->user = $sqluser;
$this->password = $sqlpassword;
$this->server = $sqlserver;
$this->dbname = $database;

$this->db_connect_id = ($this->persistency) ? mysql_pconnect($this->server, $this->user, $this->password) : mysql_connect($this->server, $this->user, $this->password);

if( $this->db_connect_id )
{
if( $database != "" )
{
$this->dbname = $database;
$dbselect = mysql_select_db($this->dbname);

if( !$dbselect )
{
mysql_close($this->db_connect_id);
$this->db_connect_id = $dbselect;
}
}

return $this->db_connect_id;
}
else
{
return false;
}
}

//
// Other base methods
//
function sql_close()
{
if( $this->db_connect_id )
{
//
// Commit any remaining transactions
//
if( $this->in_transaction )
{
mysql_query("COMMIT", $this->db_connect_id);
}

return mysql_close($this->db_connect_id);
}
else
{
return false;
}
}

//
// Base query method
//
function sql_query($query = "", $transaction = FALSE)
{
//
// Remove any pre-existing queries
//
unset($this->query_result);

if( $query != "" )
{
$this->num_queries++;
if( $transaction == BEGIN_TRANSACTION && !$this->in_transaction )
{
$result = mysql_query("BEGIN", $this->db_connect_id);
if(!$result)
{
return false;
}
$this->in_transaction = TRUE;
}

$this->query_result = mysql_query($query, $this->db_connect_id);
}
else
{
if( $transaction == END_TRANSACTION && $this->in_transaction )
{
$result = mysql_query("COMMIT", $this->db_connect_id);
}
}

if( $this->query_result )
{
unset($this->row[$this->query_result]);
unset($this->rowset[$this->query_result]);

if( $transaction == END_TRANSACTION && $this->in_transaction )
{
$this->in_transaction = FALSE;

if ( !mysql_query("COMMIT", $this->db_connect_id) )
{
mysql_query("ROLLBACK", $this->db_connect_id);
return false;
}
}

return $this->query_result;
}
else
{
if( $this->in_transaction )
{
mysql_query("ROLLBACK", $this->db_connect_id);
$this->in_transaction = FALSE;
}
return false;
}
}

//
// Other query methods
//
function sql_numrows($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_num_rows($query_id) : false;
}

function sql_affectedrows()
{
return ( $this->db_connect_id ) ? mysql_affected_rows($this->db_connect_id) : false;
}

function sql_numfields($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_num_fields($query_id) : false;
}

function sql_fieldname($offset, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_field_name($query_id, $offset) : false;
}

function sql_fieldtype($offset, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_field_type($query_id, $offset) : false;
}

function sql_fetchrow($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if( $query_id )
{
$this->row[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC);
return $this->row[$query_id];
}
else
{
return false;
}
}

function sql_fetchrowset($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if( $query_id )
{
unset($this->rowset[$query_id]);
unset($this->row[$query_id]);

while($this->rowset[$query_id] = mysql_fetch_array($query_id, MYSQL_ASSOC))
{
$result[] = $this->rowset[$query_id];
}

return $result;
}
else
{
return false;
}
}

function sql_fetchfield($field, $rownum = -1, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if( $query_id )
{
if( $rownum > -1 )
{
$result = mysql_result($query_id, $rownum, $field);
}
else
{
if( empty($this->row[$query_id]) && empty($this->rowset[$query_id]) )
{
if( $this->sql_fetchrow() )
{
$result = $this->row[$query_id][$field];
}
}
else
{
if( $this->rowset[$query_id] )
{
$result = $this->rowset[$query_id][$field];
}
else if( $this->row[$query_id] )
{
$result = $this->row[$query_id][$field];
}
}
}

return $result;
}
else
{
return false;
}
}

function sql_rowseek($rownum, $query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

return ( $query_id ) ? mysql_data_seek($query_id, $rownum) : false;
}

function sql_nextid()
{
return ( $this->db_connect_id ) ? mysql_insert_id($this->db_connect_id) : false;
}

function sql_freeresult($query_id = 0)
{
if( !$query_id )
{
$query_id = $this->query_result;
}

if ( $query_id )
{
unset($this->row[$query_id]);
unset($this->rowset[$query_id]);

mysql_free_result($query_id);

return true;
}
else
{
return false;
}
}

function sql_error()
{
$result['message'] = mysql_error($this->db_connect_id);
$result['code'] = mysql_errno($this->db_connect_id);

return $result;
}

} // class sql_db

} // if ... define

?>

You don't need to change that file 😉