vb.org Archive - Links and Downloads Manager

Page 21 of 247

« First

121

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Links and Downloads Manager (https://vborg.vbsupport.ru/showthread.php?t=91107)

AndrewD

10-02-2005 05:32 AM

Quote:

Originally Posted by Meltingfire

I have created a own module i call "ldm-hotcat.php" that is basicly a hot category.
Since i use the category as a filename, lets say "miranda" and then post a link for each version "miranda 1.0", "miranda 2.0" etc i want all hits to be collected together inside that category so i use the following code as SQL, other then that there is no changes made to the original "ldm-hot.php"

PHP Code:


		
			
        SELECT cat.catid AS linkid, cat.catname AS linkname, cat.catdesc AS linkdesc, 

            SUM(link.linkhits) AS linkhits, link.linkstatus AS linkstatus

        FROM ".THIS_TABLE."linksltoc AS ltoc         

        LEFT JOIN ".THIS_TABLE."linkslink AS link 

            ON ltoc.linkid = link.linkid 

        LEFT JOIN ".THIS_TABLE."linkscat as cat 

            ON ltoc.catid = cat.catid

        GROUP BY cat.catid



            $order

        LIMIT $linksee

The problem is that when i use the $filter i get a SQL error, cant see why...

if the filter is "WHERE link.linkmoderate = 0" it gives a error which it shouldnt, or am i just blind

Because the filter (WHERE) has to come before the GROUP BY

AndrewD

10-02-2005 08:56 AM

Quote:

Originally Posted by Meltingfire

Also, adding a phrase for "local_links.php" would be appreciated so you can translade it to for example "links.php", so i dont have to word-replace all urls in styles after a upgrade ;) even if that only takes 2 seconds.

Maybe not the best solution but would work and phrases wouldnt be changed after an upgrade as styles do.

In the next version, I will parameterise the script names using DEFINES in the local_links_init file. That way, there is one file to edit for configuration changes to code and database.

GrendelKhan{TSU

10-02-2005 10:06 AM

Quote:

Originally Posted by AndrewD

I think what was bugging me about the first try was 'too much line spacing' - I switched over to putting everything in one table row, with line breaks. I agree with you that the two-column style is better than the one column parenthesised version, but still wonder about the table length. What do you think?

yah I gotta agree with PtP. the 2 column look was better. Column spacing is not as big a deal as the overall is much better with the two column approach. The one table row looks like a beta version....ie: no styling.

definitely go with the 2 column. (imho)

MissKalunji

10-03-2005 04:24 PM

okay lets try this i installed it but n e one can help me make it look like this :

http://www.dancehallareaz.com/links/

Meltingfire

10-03-2005 05:10 PM

Quote:

Originally Posted by MissKalunji

okay lets try this i installed it but n e one can help me make it look like this :

http://www.dancehallareaz.com/links/

Edit the styles?

MissKalunji

10-03-2005 06:32 PM

Quote:

Originally Posted by Meltingfire

Edit the styles?

i suck at these things.......can n e one help me? if i gotta pay i dont mind....

lttcoder

10-03-2005 07:07 PM

Andrew, How can I change the category display order?
I know how to set links display order but I want to change category display order by date. The recent added categories should come first and old last.
Is there a way?

AndrewD

10-04-2005 04:23 AM

Quote:

Originally Posted by lttcoder

In the current version, you can only do this by manually editing the categories and changing the last field "Display Order" so that the numbers decrease in the order you created them.

Currently, there is no datestamp in the database showing when a category was created - only datestamps showing when links were created and when a link was last added to each category.

If this is a big deal, I'll add it to the 'to do' list.

Benj	10-04-2005 08:52 AM

Feature Request

dunno if this has been requested before but would it be possible to add a kind of chart for the most visited / downloaded items in the system

AndrewD

10-04-2005 11:29 AM

Quote:

Originally Posted by benj

Feature Request

dunno if this has been requested before but would it be possible to add a kind of chart for the most visited / downloaded items in the system

Chart rather than just a list?

All times are GMT. The time now is 12:44 PM.

Page 21 of 247

« First

121

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02952 seconds Memory Usage 1,754KB 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 (1)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (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
Messages: