Is it possible to

[Delw]

take the links program and use it for both a links program and a color chart

crude example here
http://www.del-mart.com/htmlfolder/colorpage.html


I was wondering if there was a way to use it for both and just rewrite the phrases on one catagory for the colors like the above example?

I know I can rewrite(phrases) the links program to do colors only but I really wanted to use it for links as well is this possible?

How about adding another links program and changing the names so I have both a color program and a links program? Obviously there would be a bunch of changes if I had to do this.

I didnt even buy the links program for the colors and I was trying to figure out how I could make the colors work when I just happened to look at links program ;)

Delw

[Brian]

If you know a little about PHP then it shouldn't be *too* hard to set it to use some different phrases for one category. Otherwise it wouldn't be too hard to use a separate instance of the links directory (though keep in mind that would require 2 licenses) and just do a find/replace on all of the files for link/color and Link/Color, then run a fresh install.

[Delw]

Brain
on the second program. I played with that last last night figuring it couldnt be too hard.
it was a little difficult I ran into problems with the install file, seeing how it uses the words link and links as well for the installation process along with the program links/link. I was going to try to read the php code and see what links/link needed to be changed and which ones didnt.

also ran into one file on the In your /forum/admincp/usergroup.php: called $lperms Figuring I would have to change that to $cperms

I dont mind buying another licence.

one question about running a dual one, where would I find the new catagory templates ie
made a catagory called colors where would I find just those templates for that catagory that woudltn effect the rest of the catagories.
I have to run to work for a while but will check in from time to time.

Thanks
Delw

[Brian]

I've done something similar with the links directory on my personal site to make a music section with the links directory. As far as I remember, all I had to do was do the find/replace on links/files and Links/Files, then changed the $lperms variable in the usergroup.php file.

one question about running a dual one, where would I find the new catagory templates ie
made a catagory called colors where would I find just those templates for that catagory that woudltn effect the rest of the catagories.
I have to run to work for a while but will check in from time to time.
I'm not exactly sure what you're asking here... If you use the find/replace method then you would have a new set of templates all prefixed with 'adv_colors'. If you were trying to just change one category then you would be using the same templates and have to use some conditionals in the templates.

[Delw]

Sorry the last statement was if I used the links program and just wanted to add a catagory for colors ( not rewriting the whole program for a colors program)
If you know a little about PHP then it shouldn't be *too* hard to set it to use some different phrases for one category.

I would assume if I changed a phrase for one word in the color cat, then it would also change the same word in the links cats

Delw

[Delw]

Brian or anyone
any idea what I did wrong? Install went fine with no errors.



Database error in vBulletin 3.0.7:

Invalid SQL: SELECT colors.colorid, name, colors.description, url, colors.catid, username, colors.userid, views, open, dateline, title, votenum, votetotal , posts, lastpostdateline, lastpostuserid, lastpostusername , NOT ISNULL(subscribecolor.colorid) AS subid , NOT ISNULL(favorites.colorid) AS favid
FROM colors AS colors
LEFT JOIN colors_categories AS colors_categories ON (colors.catid = colors_categories.catid)
LEFT JOIN colors_subscribecolor AS subscribecolor ON (colors.colorid = subscribecolor.colorid AND 1 = subscribecolor.userid)
LEFT JOIN colors_favorites AS favorites ON (favorites.vid = colors.colorid AND favorites.userid = 1)
WHERE valid = 1 AND suspended = 0
ORDER BY dateline DESC
LIMIT 5
mysql error: Unknown column 'favorites.vid' in 'on clause'

mysql error number: 1054

Date: Wednesday 11th of May 2005 03:24:55 AM
Script: http://www.huntandlodge.com/colors/


'favorites.vid'
I am guessing I had a typo somehow with the above.

Thanks
Delw

[Brian]

Change 'favorites.vid' to 'favorites.colorid' in that query.

[Delw]

Thanks Brian.

I found that query under the link dir in the file index.php.

Now it also me to get into the program.
I changed the phrase's in the phrase manager to what I needed.

I want to take out or change the
URL
Please enter the URL to the website here.
box, or section

because its an html link( I assume is has some sort of code to decifer that) can I just comment it out or delete it or do I need to do something else?

I get this msg when I try to submit a color thats why I am asking
A required field was missing. Please be sure you entered a title, URL, and description for your color.


Delw

[Brian]

http://www.vbadvanced.com/forum/showthread.php?t=2779&highlight=remove+url ;)

[Delw]

Thanks Brian, I will try that out

Delw

[Delw]

The problem I am having now is that when I submit a color (click the submit button after filling in info)I get a blank screen, I went back and took out the edit in the above post you told me about and tried it again still get a blank screen.

I also get a blank screen when I click on the color and hit the view color info button in the drop down( which would be view link info before I edited it)

I resaved the phrases earlier today. thinking that might of helped .

I am thinking its in this part of showcolor.php
// ############################### View color details ###############################
if ($_REQUEST['do'] == 'showdetails')
{
globalize($_REQUEST, array('pagenumber' => INT, 'perpage' => INT, 'postid' => INT, 'goto' => STR, 'orderby' => STR, 'searchid' => INT));

if ($goto == 'lastpost')
{
$getlast = $DB_site->query_first("SELECT postid FROM " . TABLE_PREFIX . "colors_posts WHERE colorid = '$colorid' ORDER BY postid DESC");
exec_header_redirect("showcolor.php?$session[sessionurl_js]do=showdetails&l=$colorid&p=$getlast[postid]#post$getlast[postid]");
}

Delw

[Brian]

Can you post a link to where you're working on this?

[Delw]

www.huntandlodge.com/colors


BTW I think its had to to with do=showdetails&l=$colorid& I remembered I changed the $lperms to $cperms

I will change that file now and upload it

[Brian]

I'm not entirely sure why it would be doing that. If you'd like to submit a support ticket though I'll be glad to take a look.

[Delw]

Will do brian

when ever you have time no hurry

I did assume that $lperms needed to be changed to $cperms because I changed everything else from links to colors in the install files. before I installed the version

Delw