4images Forum & Community

Wow! Great led, I am going to have fun playing with this file!    Thanks cheribibi

-Jason

I am getting the following data base errors with my site which is integrated with vBulletin and is sharing the same data base.

errors:
DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_rating, i.image_votes, c.cat_name, u.user_name FROM actors_images i, actors_categories c, user u WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id AND i.user_id = u.user_id ORDER BY i.image_rating DESC, i.image_votes DESC LIMIT 20
Unknown column 'u.user_name' in 'field list'

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_rating, i.image_votes, c.cat_name, u.user_name FROM actors_images i, actors_categories c, user u WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id AND i.user_id = u.user_id ORDER BY i.image_votes DESC, i.image_name ASC LIMIT 20
Unknown column 'u.user_name' in 'field list'

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_hits, c.cat_name, u.user_name FROM actors_images i, actors_categories c, user u WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id AND i.user_id = u.user_id ORDER BY i.image_hits DESC, i.image_name ASC LIMIT 20
Unknown column 'u.user_name' in 'field list'

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_thumb_file, i.image_downloads, c.cat_name, u.user_name FROM actors_images i, actors_categories c, user u WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id AND i.user_id = u.user_id ORDER BY i.image_downloads DESC, i.image_name ASC LIMIT 20
Unknown column 'u.user_name' in 'field list'

DB Error: Bad SQL Query: SELECT i.image_id, i.user_id, i.cat_id, i.image_name, i.image_comments, i.image_rating, i.image_thumb_file, i.image_votes, c.cat_name, u.user_name FROM actors_images i, actors_categories c, user u WHERE i.image_active = 1 AND i.cat_id NOT IN (0) AND i.cat_id = c.cat_id AND i.user_id = u.user_id ORDER BY i.image_comments DESC, i.image_votes DESC LIMIT 20
Unknown column 'u.user_name' in 'field list'

Here is my site info:

I have successfully applied this mode:  "4images Gallery 1.7 + vB 3.0.x"  
http://www.vbulletin.org/forum/showthread.php?t=66335&page=1&pp=15&highlight=4images

Versions I am using:

4images 1.7.1
vBulletin Version 3.0.7


As part of the integration with vBulletin my 4images data base has a prefix of "actors_" and is in the same data base as vBulletin which has no prefix. So, my 4images is using vBulletin's user table. Which results in my users registering and signing in once to use the forum and picture gallery.

My data base:

"actors_categories"        <---4images
"actors_comments"       <---4images
"actors_groupaccess"     <---4images
adminhelp                    <---vBulletin (no prefix)
user                            <---vBulletin (no prefix)
useractivation               <---vBulletin (no prefix)
etc..

I am wondering if this could be fixed easily or has the integration with vBulletin made this mod unsalable?

thanks - Jason

Chris, Thank You! The help on this Forum board is second to none!   

Yes.  Just use this link format

Code: [Select]

http://www.example.com/4images/top.php?cat_id=xxxwhere xxx is the category number in question

Hi, as of now all image Categories show up in one "Top Images" page. Is it possible to have the option of having each Category have it's own Top Images Page?  Example: Lets say I have two Categories. Category one is apples and category two is orange's. Right now the Top Images page will include both apples and oranges sorted by rating,votes, hits and downloads.  As apposed to one page with the Top Apples and another page with the Top Oranges sorted by rating,votes, hits and downloads. Anyway, I think you get the idea. Any way to do this?

Thank you,
Jason

Vincent - No problem about the language, I just used the German to English Translation in my web Brower!

V@no – Wow! That’s Great!

Jason NY,NY USA

Hi, does anyone know how to do this? It seems like the standard rating should be "on a scale of 1 to 10" rather than "on a scale of 1 to 5". I was able to change the rating drop down choice to 1 to 10 in the “rate_form.html” template. But when selecting 6-10, it says "invalid rating". I am sure I have to change something in a php file, but I am new at this. Please help! 

Thank You,
Jason NY, NY USA

------------------------------------------------------------
The Original rate_form.html:

<form method="post" action="{self}">
  <table border="0" cellspacing="0" cellpadding="1">
    <tr>
      <td class="head1">
        <table border="0" cellspacing="0" cellpadding="3" class="row1">
          <tr>
            <td valign="bottom">
              <select name="rating" class="select">
                <option value="">--</option>
                <option value="5">5</option>
                <option value="4">4</option>
                <option value="3">3</option>
                <option value="2">2</option>
                <option value="1">1</option>
              </select>
            </td>
            <td>
              <input type="hidden" name="action" value="rateimage" />
              <input type="hidden" name="id" value="{image_id}" />
              <input type="submit" value="{rate}" class="button" name="submit" />
            </td>
          </tr>
        </table>
      </td>
    </tr>
  </table>
</form>

What I changed or added: I just added option values 6 though 10.

                <option value="">--</option>
                <option value="10">10</option>
                <option value="9">9</option>   
                <option value="9">9</option>
                <option value="8">8</option>
                <option value="7">7</option>
                <option value="6">6</option>
                <option value="5">5</option>
                <option value="4">4</option>
                <option value="3">3</option>
                <option value="2">2</option>
                <option value="1">1</option>