Go Back   Novahq.net Forum > phphq.Net > phphq.Net Forums

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-21-2007, 03:54 PM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,919

phphq.Net Forums

The phphq.Net forums are back up... I'll be able to answer questions and monitor the posts alot better now they on hooked to these forums since I am here every day.

Post away
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq

Last edited by Scott; 06-22-2007 at 02:51 AM.
Reply With Quote
  #2  
Old 06-21-2007, 04:03 PM
EDGE is offline EDGE
EDGE's Avatar

Join Date: Feb 2003
Location: North Carolina
Posts: 7,184

Send a message via ICQ to EDGE Send a message via AIM to EDGE Send a message via Yahoo to EDGE
wtf? the forum is all red and matches the forum on phphq....I've really gotta figure out how the hell you managed to do this lol, thats awesome.
__________________
Quote:
Voltaire
It is forbidden to kill; therefore all murderers are punished unless they kill in large numbers and to the sound of trumpets.
Reply With Quote
  #3  
Old 06-21-2007, 04:31 PM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,919

I'm stubborn
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq
Reply With Quote
  #4  
Old 06-21-2007, 04:43 PM
Steve is offline Steve
Steve's Avatar
Administrator

Join Date: Sep 2001
Location: 2077
Posts: 21,552

Send a message via ICQ to Steve
it would be nice if every section had a specific theme

sry for off topic looks nice btw
Reply With Quote
  #5  
Old 06-21-2007, 05:05 PM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,919

Thanks


Now how to transfer the posts here
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq
Reply With Quote
  #6  
Old 06-21-2007, 05:23 PM
EDGE is offline EDGE
EDGE's Avatar

Join Date: Feb 2003
Location: North Carolina
Posts: 7,184

Send a message via ICQ to EDGE Send a message via AIM to EDGE Send a message via Yahoo to EDGE
Quote:
Originally posted by Steve
it would be nice if every section had a specific theme

sry for off topic looks nice btw
Good idea, but the question is.....Would it be too much work on him? And who would we get to make more themes!?!?!? Hey, speaking of that, I should design a new one.

Quote:
Originally posted by Scott
Now how to transfer the posts here
Copy and paste?

Also, might I add that you post a FAQ in this forum. It would help with some of the smaller problems that users run into.
__________________
Quote:
Voltaire
It is forbidden to kill; therefore all murderers are punished unless they kill in large numbers and to the sound of trumpets.
Reply With Quote
  #7  
Old 06-21-2007, 05:58 PM
ShArP is offline ShArP
ShArP's Avatar

Join Date: Dec 2003
Location: Pennsylvania, USA
Posts: 6,790

Send a message via ICQ to ShArP Send a message via AIM to ShArP Send a message via MSN to ShArP
looks good, is this gonna be the new type of NOVAHQ forums or something??
__________________
Steam Username = BMY61

Reply With Quote
  #8  
Old 06-22-2007, 02:37 AM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,919

Quote:
Originally posted by EDGE
Copy and paste?
I have a much better way

PHP Code:
<?
ini_set
('error_reporting'E_ALL);
ini_set('display_errors''On');
ini_set('display_startup_errors''On');

include(
"./phpbb_db.php");

//Function taken from phpBB
function decode_ip($int_ip) {
    
$hexipbang explode('.'chunk_split($int_ip2'.'));
    return 
hexdec($hexipbang[0]). '.' hexdec($hexipbang[1]) . '.' hexdec($hexipbang[2]) . '.' hexdec($hexipbang[3]);
}

//;;;;;;;;;;;;;;;;;;;;;;;;;;
// Copy topics and posts from phpbb to vbulletin by Scott L.
//;;;;;;;;;;;;;;;;;;;;;;;;;;

$phpbb_db="phpbb";
$phpbb_forum_id="2";
$vb_db="vb";
$vb_forum_id="280";


//;;;;;;;;;;;;;;;;;;;;;;;;;;
echo "<pre>";

$sql="
    SELECT 
        topic_id,
        topic_title,
        topic_poster,
        topic_time,
        topic_views,
        topic_replies,
        topic_type,
        topic_first_post_id,
        topic_last_post_id,
        forums_users.username
    FROM forums_topics
    LEFT JOIN forums_users ON forums_users.user_id = topic_poster
    WHERE forum_id='"
.$phpbb_forum_id."'
"
;

$query=$ph->query($sql);
while(
$topic=$ph->fetch_array($query)) {

    
$sql="
        SELECT 
            post_time,
            poster_id,
            forums_users.username
        FROM forums_posts
        LEFT JOIN forums_users ON forums_users.user_id = poster_id
        WHERE post_id='"
.$topic['topic_last_post_id']."'
    "
;
        
    
$last_post=$ph->result($sql);
    
    If(
$last_post['username']=="" OR $last_post['username']=="Anonymous") {
        
$last_post['username']="Guest";
    }
    
    If(
$topic['username']=="" OR $topic['username']=="Anonymous") {
        
$topic['username']="Guest";
    }
        
    
$sql="
        INSERT INTO "
.$vb_db.".thread
        (
            title,
            lastpost,
            forumid,
            pollid,
            open,
            replycount,
            postusername,
            postuserid,
            lastposter,
            dateline,
            views,
            iconid,
            notes,
            visible,
            sticky,
            votenum,
            votetotal,
            attach
        )
        VALUES 
        (
            '"
.addslashes($topic['topic_title'])."',
            '"
.$last_post['post_time']."',
            '"
.$vb_forum_id."',
            '0',
            '1',
            '"
.$topic['topic_replies']."',
            '"
.addslashes($topic['username'])."',
            '0',
            '"
.addslashes($last_post['username'])."',
            '"
.$topic['topic_time']."',
            '"
.$topic['topic_views']."',
            '0',
            '',
            '1',
            '"
.$topic['topic_type']."',
            '0',
            '0',
            '0'
        )
    "
;

    echo(
$sql);
    
$ph->query($sql);
    
$last_id=$ph->last_id();
        
    
$sql="
        SELECT 
            topic_id,
            post_time,
            poster_ip,
            poster_id, 
            post_username,
            forums_posts_text.post_id,
            forums_posts_text.post_subject,
            forums_posts_text.post_text
        FROM forums_posts
        LEFT JOIN forums_posts_text ON forums_posts_text.post_id = forums_posts.post_id
        WHERE topic_id='"
.$topic['topic_id']."'
    "
;
    
    
$query2=$ph->query($sql);
    
    while(
$posts=$ph->fetch_array($query2)) {
        
        If(
$posts['post_username']=="") {
            
            
$sql="
                SELECT 
                    username 
                FROM forums_users 
                WHERE user_id='"
.$posts['poster_id']."' 
                LIMIT 1
            "
;

            
$temp=$ph->result($sql);
            
$posts['post_username']=$temp['username'];
        }
        
        If(
$posts['post_username']=="Anonymous") {
            
$posts['post_username']="Guest";
        }
        
        
$sql="
        INSERT INTO "
.$vb_db.".post
        (
            threadid,
            username,
            userid,
            title,
            dateline,
            attachmentid,
            pagetext,
            allowsmilie,
            showsignature,
            ipaddress,
            iconid,
            visible,
            edituserid,
            editdate
        )
        VALUES 
        (
            '"
.$last_id."',
            '"
.addslashes($posts['post_username'])."',
            '0',
            '"
.addslashes($posts['post_subject'])."',
            '"
.$posts['post_time']."',
            '0',
            '"
.addslashes($posts['post_text'])."',
            '1',
            '1',
            '"
.decode_ip($posts['poster_ip'])."',
            '0',
            '1',
            '0',
            '0'
        )
        "
;
        
        echo(
$sql);
        
$ph->query($sql);
    
    } 
// posts
    
// topics

?>
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq

Last edited by Scott; 06-22-2007 at 02:46 AM.
Reply With Quote
  #9  
Old 06-22-2007, 02:40 AM
Scott is offline Scott
Scott's Avatar
AKA. Panther

Join Date: Sep 2001
Location: Minneapolis, MN
Posts: 10,919

Quote:
Originally posted by ShArP
looks good, is this gonna be the new type of NOVAHQ forums or something??
No, this really has nothing to do with novahq.
__________________

04' Dodge SRT-4, Mopar Stage 3, 406whp/436wtq
Reply With Quote
  #10  
Old 06-22-2007, 02:42 AM
EDGE is offline EDGE
EDGE's Avatar

Join Date: Feb 2003
Location: North Carolina
Posts: 7,184

Send a message via ICQ to EDGE Send a message via AIM to EDGE Send a message via Yahoo to EDGE
you cheated!
__________________
Quote:
Voltaire
It is forbidden to kill; therefore all murderers are punished unless they kill in large numbers and to the sound of trumpets.
Reply With Quote
  #11  
Old 06-22-2007, 09:32 AM
katana*GFR* is offline katana*GFR*

Join Date: May 2002
Location: North Sea
Posts: 2,421

Send a message via ICQ to katana*GFR* Send a message via MSN to katana*GFR*
w00t Finally there back!!! Thank's Scott.. If i can help let me know.
__________________
<- Sponsored by Chris



Found on Youtube:
Quote:
And if Newton Faulkner's voice can be described as "R&B" then Kurt Cobain must be a member of Boyz II Men.
Link here
Reply With Quote
  #12  
Old 06-22-2007, 11:46 AM
SilentTrigger is offline SilentTrigger
-1PARA-

Join Date: Sep 2002
Location: Sweden
Posts: 3,972

Interesting, was a bit confused as to what this was the first time i pressed it (I just saw the new post icon so i clicked it without reading what it said) and came to a red layout hehe. I did check what it said this time around!
__________________
-1PARA-AlexKall

My photography website



Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
New Forums .DareDevil. Web design and Programming 0 04-26-2006 04:31 PM
About this Forums Webviper2006 Feedback / Novahq.net Support 4 12-15-2005 09:33 PM
Forums KadukuSindalu Web design and Programming 6 09-16-2004 08:20 AM
New Forums katana*GFR* News 7 10-04-2002 01:49 PM


All times are GMT -5. The time now is 11:34 PM.




Powered by vBulletin®