Ozzymandias
02-02-2009, 09:14 AM
Hello,
I currently have a small PHP script that was written for PHPBB and I'm wondering if there's a way that I can have it translated to work on VBB. I'm sure its just a matter of changing the variables and what not, but I'm not a coder so I don't quite know what exactly needs to be changed.
<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/constants.' . $phpEx);
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
global $table_prefix;
define('GEAR_TABLE', $table_prefix . 'gear');
# going with no auth for a min
print("gear_updated=".time().";\r\n");
//
$sql = 'SELECT ge.item, us.username, ge.gear_id FROM ' . GEAR_TABLE . ' as ge LEFT JOIN ' . USERS_TABLE . ' as us USING (user_id) ORDER BY ge.gear_id';
global $db;
if ( !($item_result = $db->sql_query($sql)) )
{
message_die('Could not obtain item information', '', __FILE__, __LINE__, $sql);
}
$items = array();
$users = array();
while ( $row = $db->sql_fetchrow($item_result) )
{
if (!$items[$row['item']]) {
$items[$row['item']] = array();
}
if (!$users[$row['username']]) {
$users[$row['username']] = array();
}
array_push($items[$row['item']],array($row['item'],$row['username'],$row['gear_id']));#,$row['item_date']));
array_push($users[$row['username']],array($row['item'],$row['username'],$row['gear_id']));#,$row['item_date']));
}
$db->sql_freeresult($item_result);
print("gear_items = {\r\n");
foreach (array_keys($items) as $item) {
echo "[\"",strtolower($item),"\"] = { \r\n";
foreach (array_values($items[$item]) as $entry) {
echo "{[\"name\"]=\"", $entry[0] , "\",[\"member\"]=\"", $entry[1], "\",[\"value\"]=\"", $entry[2],"\"},\r\n";
}
echo "},\r\n";
}
print("}\r\n");
print("gear_users = {\r\n");
foreach (array_keys($users) as $user) {
echo "[\"",strtolower($user),"\"] = { \r\n";
foreach (array_values($users[$user]) as $entry) {
echo "{[\"name\"]=\"", $entry[0] , "\",[\"member\"]=\"", $entry[1], "\",[\"value\"]=\"", $entry[2],"\"},\r\n";
}
echo "},\r\n";
}
print("}\r\n");
?>
I currently have a small PHP script that was written for PHPBB and I'm wondering if there's a way that I can have it translated to work on VBB. I'm sure its just a matter of changing the variables and what not, but I'm not a coder so I don't quite know what exactly needs to be changed.
<?php
define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
include($phpbb_root_path . 'includes/constants.' . $phpEx);
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
global $table_prefix;
define('GEAR_TABLE', $table_prefix . 'gear');
# going with no auth for a min
print("gear_updated=".time().";\r\n");
//
$sql = 'SELECT ge.item, us.username, ge.gear_id FROM ' . GEAR_TABLE . ' as ge LEFT JOIN ' . USERS_TABLE . ' as us USING (user_id) ORDER BY ge.gear_id';
global $db;
if ( !($item_result = $db->sql_query($sql)) )
{
message_die('Could not obtain item information', '', __FILE__, __LINE__, $sql);
}
$items = array();
$users = array();
while ( $row = $db->sql_fetchrow($item_result) )
{
if (!$items[$row['item']]) {
$items[$row['item']] = array();
}
if (!$users[$row['username']]) {
$users[$row['username']] = array();
}
array_push($items[$row['item']],array($row['item'],$row['username'],$row['gear_id']));#,$row['item_date']));
array_push($users[$row['username']],array($row['item'],$row['username'],$row['gear_id']));#,$row['item_date']));
}
$db->sql_freeresult($item_result);
print("gear_items = {\r\n");
foreach (array_keys($items) as $item) {
echo "[\"",strtolower($item),"\"] = { \r\n";
foreach (array_values($items[$item]) as $entry) {
echo "{[\"name\"]=\"", $entry[0] , "\",[\"member\"]=\"", $entry[1], "\",[\"value\"]=\"", $entry[2],"\"},\r\n";
}
echo "},\r\n";
}
print("}\r\n");
print("gear_users = {\r\n");
foreach (array_keys($users) as $user) {
echo "[\"",strtolower($user),"\"] = { \r\n";
foreach (array_values($users[$user]) as $entry) {
echo "{[\"name\"]=\"", $entry[0] , "\",[\"member\"]=\"", $entry[1], "\",[\"value\"]=\"", $entry[2],"\"},\r\n";
}
echo "},\r\n";
}
print("}\r\n");
?>