MMA News Forums » Website Forums » Site Suggestions/Feedback

[Dan0]

Originally Posted by The Sundance Kid

I think it would be cool but I'm not doing the work.

I'll do the work if yall will allow me to, but you have to tell me how to do it.

I'm retired, with no job, and 100% disabled, so I gots da time.

[Clint]

Like I said I'm pretty sure we don't have deep enough access to be able to do it.

[Malice]

Clint if you can upload a PHP page and you know the Database username and password you can do this.

The Database schema for PHPBB (Nuke whetever) is pretty intutive.

PHP Code:

<?
/*includes/connect.php*/ 
/*--------- DATABASE CONNECTION INFO---------*/ 
$hostname="localhost"; 
$mysql_login="myusername"; 
$mysql_password="mypassword"; 
$database="mydatabase"; 

// connect to the database server 
if (!($db = mysql_pconnect($hostname, $mysql_login , $mysql_password))){ 
  die("Can't connect to database server.");     
}else{ 
  // select a database 
    if (!(mysql_select_db("$database",$db))){ 
      die("Can't connect to database."); 
    } 
} 
?>

PHP Code:

<? 
include("includes/connect.php"); 
// now you are connected and can query the database 
// CLINT WRITE YOUR QUERY HERE
$request = mysql_query("select field1,field2 from table"); 

// loop through the results with mysql_fetch_array() 
while($row = mysql_fetch_array($result)){ 
  echo $row[0]." / ".$row[1]."<br>\n"; 
} 

// don't forget to close the mysql connection 
mysql_close(); 
?>

[Clint]

Originally Posted by Rockx

Clint if you can upload a PHP page and you know the Database username and password you can do this.

The Database schema for PHPBB (Nuke whetever) is pretty intutive.

PHP Code:

<?
/*includes/connect.php*/ 
/*--------- DATABASE CONNECTION INFO---------*/ 
$hostname="localhost"; 
$mysql_login="myusername"; 
$mysql_password="mypassword"; 
$database="mydatabase"; 

// connect to the database server 
if (!($db = mysql_pconnect($hostname, $mysql_login , $mysql_password))){ 
  die("Can't connect to database server.");     
}else{ 
  // select a database 
    if (!(mysql_select_db("$database",$db))){ 
      die("Can't connect to database."); 
    } 
} 
?>

PHP Code:

<? 
include("includes/connect.php"); 
// now you are connected and can query the database 
// CLINT WRITE YOUR QUERY HERE
$request = mysql_query("select field1,field2 from table"); 

// loop through the results with mysql_fetch_array() 
while($row = mysql_fetch_array($result)){ 
  echo $row[0]." / ".$row[1]."<br>\n"; 
} 

// don't forget to close the mysql connection 
mysql_close(); 
?>

I don't have access to upload any webpages or to any of the sql tables. I have no server level access at all. Just the interface that the forum provides.

[strife]

I know on other forums every month or two we have the lowest 5 people rep-wise (generally all negative rep) and we vote (through a poll) on who to kick out of the forum. At least they used to.

[Clint]

The top 5 and bottom 5 rep is easy enough since that can be grabbed through the member's list page (just sort by rep) but things like who gave/received the most is a different story.

[Dork8503]

Originally Posted by strife

I know on other forums every month or two we have the lowest 5 people rep-wise (generally all negative rep) and we vote (through a poll) on who to kick out of the forum. At least they used to.

sounds like a cool idea

[Highlander]

Originally Posted by dork8503

sounds like a cool idea

You really want to ban someone don't you?

[Dork8503]

Originally Posted by God

You really want to ban someone don't you?

lol no, im always nice when it comes to banning people. I give more then 1 chance. People might think im a dick head but i have only banned 2 people.