vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   PHPAuction Info on Forumhome (https://vborg.vbsupport.ru/showthread.php?t=43182)

FASherman 09-04-2002 10:00 PM
PHPAuction Info on Forumhome
 
This is far from integrating the two products, but at least it makes your auctions visible on forumhome.

Sample can be seen at http://www.fasherman.com/forums

Simply, the auction table gives a link to the auctions, tells how many are active and what the newest auction is. The lightbulb is turned on if there are active auctions.

You'll need to edit index.php and create a new template. The instructions are below. Follow them exactly since you will be momentarily switching from your vBulletin database to your phpauction database and then back again.

in index.php, find:

PHP Code:
require('./global.php'); 
Above it add:

PHP Code:
    $phpauction_host="your-db-host";
    $phpauction_user="your-db-user";
    $phpauction_passwd="your-db-password";
    $phpauction_db="your-phpauction-db"; 
still in index.php, find:

PHP Code:
eval("dooutput(\"".gettemplate('forumhome')."\");"); 
Above it, add:

PHP Code:
//PHPAUCTION HACK
    $link = mysql_connect($phpauction_host,$phpauction_user,$phpauction_passwd);
    mysql_select_db($phpauction_db);

    /* Performing SQL query */
    $query = "SELECT * FROM PHPAUCTION_auctions where closed=0";
    $result = mysql_query($query);
    $num_auctions=mysql_num_rows($result);
    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
            $newest=stripslashes($row[2]);
            $num_category=$row[6];
    }
    $query = "SELECT * FROM PHPAUCTION_categories where cat_id=$num_category";
    $result = mysql_query($query);
    while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
            $category=$row[2];
    }
if ($num_auctions !=0) {
  $auctiononoff="on.gif";
} else {
  $auctiononoff="off.gif";
}

mysql_select_db($dbname);
eval("\$auctiondisplay = \"".gettemplate('auctiondisplay')."\";");

//PHPAUCTION HACK END 
Now, add a template called auctiondisplay:
<table cellSpacing="0" cellPadding="0" width="100%" align="center" bgColor="#1D6AA0" border="0">
<tr>
<td>
<table cellSpacing="1" cellPadding="4" width="100%" border="0">
<tr id="cat">
<td bgColor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colSpan="2">
<b>Web Auction</b></td>
</tr>
<tr align="middle">
<td vAlign="top" bgColor="#1C5780" width="15">
<img alt src="images/$auctiononoff" border="0" width="15" height="15"></td>
<td align="left" bgColor="#13486D">
<normalfont>
<img alt src="images/forum-icons/gavel.gif" border="0" width="32" height="32"><b>
<a style="color: #000020" href="../phpauction">Forum Web Auction</a> - </b>
<smallfont>lets you buy or sell items in an auction format<br>
<b>Number of active auctions</b>: $num_auctions<br>
<b>Newest Auction</b>: $category: $newest</td>
</tr>
</table>
</td>
</tr>
</table>
<br>

Thats it.

mewgood 09-05-2002 04:53 AM
you need to fix the auction link
It has a extra "."

FASherman 09-05-2002 04:56 AM
No, thats correct. Dot relative addressing works like this:

. - current address
.. - parent address.

The phpauction directory is at the same level as forums with a common parent. Therefore, the dot relative addressing of a file in phpauction from the forum directory is ../file-name

FFMania 09-05-2002 11:58 AM
I got 404 error when clicking on the auction thing....the dot is...extra? ;)

FlyingDutchman 09-05-2002 02:49 PM
the dot(s) is used like this:

./phpauction.php (the file phpauction.php in the current dir)
../phpauction.php (the file phpauction.php in the parent dir)

DO NOT put it AFTER the filename/dirname!, d0h :D

FASherman 09-05-2002 07:49 PM
Quote:
Originally posted by mewgood
you need to fix the auction link
It has a extra "."
I was wrong and you were right. I didn't see that you were referencing the ending dot. Missed it entirely and looked like a fool.

To answer the other question...

<a style="color: #000020" href="../phpauction">Forum Web Auction</a> - </b>

Is a link to your auction directory. Edit the path accordingly. If you want to be even more formal about it, make it a link to index.php in your phpauction directory.

Mea Culpa

Limpkinw 09-06-2002 03:48 PM
Nice hack..made a booboo on install

FASherman 09-06-2002 08:52 PM
You have got tp be kidding, right?

Limpkinw 09-06-2002 09:51 PM
obviously i "skipped" a step and didnt put in my database info (Dumb me) Fixed now. lol

FASherman 09-06-2002 10:30 PM
Check out my newest phpauction hack. I think you'll like it even better.


All times are GMT. The time now is 09:08 PM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01304 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete