Links Page 1.2 (Page 1 of 2)

elbekko · 2006-03-12 21:34:39

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

##
##
##        Mod title:  Links Page
##
##      Mod version:  1.2
##   Works on PunBB:  1.2.*
##     Release date:  2006-04-06
##           Author:  El Bekko (elbekko@gmail.com)
##
##      Description:  Adds the possibility to have users
##              post links and moderate them from 
##              the admin CP.
##
##   Difference with  
## previous version:  Possibility to have alphabetical Indexing
##              for the links and some small bug fixes.
##
##   Affected files:  Only included files
##                    
##       Affects DB:  Yes (Creates table and adds a value to config)
##
##            Notes:  None
##
##       DISCLAIMER:  Please note that "mods" are not officially supported by
##                    PunBB. Installation of this modification is done at your
##                    own risk. Backup your forum database and any and all
##                    applicable files before proceeding.
##
##

Download

Last edited by elbekko (2006-04-06 15:39:56)

Dr.Jeckyl · 2006-03-12 22:16:35

Dr.Jeckyl
PunBB Donor
Offline

From: -8 GMT
Registered: 2004-05-04
Posts: 1,396

Re:

nice! thanks for the share.

~James
FluxBB - Less is more

Zeke · 2006-03-13 02:53:51

Zeke
Member
Offline

From: Ithaca, NY
Registered: 2005-03-17
Posts: 31

Re:

HMM. Any chance of the links being categorized and sorted by subject?

black robe and swill
I believe Anita Hill
judge will rot in hell
it's the song I hate, it's the song I hate

dss · 2006-03-13 11:29:59

dss
Senior Member
Offline

Registered: 2005-01-09
Posts: 119

Re:

Installed! Pretty nifty, thank you.

I agree that having the links automatically alphabetized would be waay helpful.

elbekko · 2006-03-13 15:37:27

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

I thought I ordered them by name... I'll check

EDIT: They are indeed ordered by name, but I guess you guys mens something like this:

A
? link
? link
? link
? link
? link
B
? link
? link
? link

I'll do it

Last edited by elbekko (2006-03-13 15:59:15)

elbekko · 2006-03-13 16:19:38

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

I'll fully release it in a future version, with the option to disable it, but this'll do for now:

Okay, to do it, open Links.php and find this line:

        if($link_num > 0)
            {

ADD AFTER

            // Prevent errors
            $last_a = "";

FIND

            while($link_row = $db->fetch_assoc($link_result))
                {

ADD AFTER

                // START INDEXING
                $firstletter = substr($link_row['LinkName'],0,1);
                
                if($firstletter != $last_a)
                    {
                    echo "</ul>";
                    echo "<b style=\"margin-left:10px\">" . strtoupper($firstletter) . "</b>";
                    echo '<ul style="margin-left:25px">';
                    }
                $last_a = $firstletter;
                // END INDEXING

This should do it just fine Have fun

elbekko · 2006-03-13 21:26:38

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

Updated to 1.1, includes the indexing feature with an on/off switch

dss · 2006-03-14 05:46:25

dss
Senior Member
Offline

Registered: 2005-01-09
Posts: 119

Re:

Sick!

Thank you!!

dss · 2006-03-14 07:02:25

dss
Senior Member
Offline

Registered: 2005-01-09
Posts: 119

Re:

The setting in the moderation plugin seems to default to off for indexing, and selecting yes, and saving returns "no" results and can't seem to be changed.

any idea what gives?

elbekko · 2006-03-14 16:27:56

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

On installation, the default is off. But the changing should work, as I tested it plenty of times locally...

Zeke · 2006-03-15 19:21:13

Zeke
Member
Offline

From: Ithaca, NY
Registered: 2005-03-17
Posts: 31

Re:

That's nicer, great thx!

black robe and swill
I believe Anita Hill
judge will rot in hell
it's the song I hate, it's the song I hate

Zeke · 2006-04-03 20:24:06

Zeke
Member
Offline

From: Ithaca, NY
Registered: 2005-03-17
Posts: 31

Re:

Changing the indexing to on does not seem to turn it on, since I just re-uploaded the whole plug-in.

But, before when I was using indexing (by just adding the code you posted above), there was a bug ? whether or not the first letter was capitalized affected the indexing.

For example:

A
abc

A
ABC

black robe and swill
I believe Anita Hill
judge will rot in hell
it's the song I hate, it's the song I hate

elbekko · 2006-04-03 20:26:17

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

Ah, I'll fix that in 1.2

And I really don't get why the indexing switch isn't working...

I'll also get full language file support ^^ Just noticed that alot of things still aren't in it

Last edited by elbekko (2006-04-03 20:55:31)

elbekko · 2006-04-06 15:40:30

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

1.2 released. It had something to do with me not reloading the config cache =/ Ah well, fixed now.

FreAkErZ · 2006-04-22 17:57:22

FreAkErZ
Member
Offline

From: Quebec
Registered: 2006-04-22
Posts: 10

Re:

1.2 seems to return an error when using the indexing switch.

In the source code, to fix this issue, I uncommented "Old Query" and commented the "New Query".

It works now.

elbekko · 2006-04-22 18:17:03

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

What error exactly?

FreAkErZ · 2006-04-22 19:34:12

FreAkErZ
Member
Offline

From: Quebec
Registered: 2006-04-22
Posts: 10

Re:

// $db->query("UPDATE `".$db->prefix."config` SET `conf_value` = '" . $indexing . "' WHERE CONVERT( `conf_name` USING utf8 ) = 'o_links_indexing' LIMIT 1") or error("Links Code error2: ".$indexing,__FILE__, __LINE__, $db->error());

I could find the line only by putting 1..2. etc on the error: .. it returned error2: ..

It would only output:

Links Code error2: .

No line or file returned.. so I guessed and comment that only, and uncommented:

$db->query("UPDATE ".$db->prefix."config SET conf_value='" . $indexing . "' WHERE conf_name='o_links_indexing' LIMIT 1") or error("Links Code error1: ",__FILE__, __LINE__, $db->error());

And now it works!

elbekko · 2006-04-22 20:17:03

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

Maybe due to the UTF8 conversion...

FreAkErZ · 2006-04-22 20:50:41

FreAkErZ
Member
Offline

From: Quebec
Registered: 2006-04-22
Posts: 10

Re:

ah.. should try it again and do a mysql_error()..

a suggestion.. maybe have a "if guest, remove the "Submit a new link""

thsi is the rror..

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING utf8 ) = 'o_links_indexing' LIMIT 1' at line 1

Last edited by FreAkErZ (2006-04-22 21:08:07)

iatbm · 2006-06-03 16:57:58

iatbm
Senior Member
Offline

Registered: 2006-03-19
Posts: 256

Re:

a guset submitting a link is probably problematic .... elbekko help hehe

WidgetBucks pays better than Adsense! | Sustainable Agriculture | Submit your forum to DigiDagi Web Directory

elbekko · 2006-06-03 17:10:08

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

I think the solution to that is somewhere on PunRes

minis · 2006-06-04 07:29:50

minis
Member
Offline

Registered: 2006-01-21
Posts: 62

Re:

So we how to dsable geust of posting links and how to make indexing without errors:

An error was encountered
Error: Links Code error: .

elbekko · 2006-06-04 11:16:18

elbekko
Senior Member
Offline

From: Leuven, Belgium
Registered: 2005-06-14
Posts: 2,653

Re:

minis: enable debug mode, so I can see the error

minis · 2006-06-04 14:09:46

minis
Member
Offline

Registered: 2006-01-21
Posts: 62

Re:

What debug mode? ;/

Smartys · 2006-06-04 14:22:20

Smartys
Former PunBB Developer
Offline

Registered: 2004-04-30
Posts: 7,844

Re:

http://punbb.org/forums/viewtopic.php?id=2658

http://fluxbb.org

Free PunBB Hosting - lots of mods, easy to customize

Links Page 1.2 (Page 1 of 2)

Posts [ 1 to 25 of 44 ]

1 Reply by elbekko 2006-03-12 21:34:39

Re:

2 Reply by Dr.Jeckyl 2006-03-12 22:16:35

Re:

3 Reply by Zeke 2006-03-13 02:53:51

Re:

4 Reply by dss 2006-03-13 11:29:59

Re:

5 Reply by elbekko 2006-03-13 15:37:27

Re:

6 Reply by elbekko 2006-03-13 16:19:38

Re:

7 Reply by elbekko 2006-03-13 21:26:38

Re:

8 Reply by dss 2006-03-14 05:46:25

Re:

9 Reply by dss 2006-03-14 07:02:25

Re:

10 Reply by elbekko 2006-03-14 16:27:56

Re:

11 Reply by Zeke 2006-03-15 19:21:13

Re:

12 Reply by Zeke 2006-04-03 20:24:06

Re:

13 Reply by elbekko 2006-04-03 20:26:17

Re:

14 Reply by elbekko 2006-04-06 15:40:30

Re:

15 Reply by FreAkErZ 2006-04-22 17:57:22

Re:

16 Reply by elbekko 2006-04-22 18:17:03

Re:

17 Reply by FreAkErZ 2006-04-22 19:34:12

Re:

18 Reply by elbekko 2006-04-22 20:17:03

Re:

19 Reply by FreAkErZ 2006-04-22 20:50:41

Re:

20 Reply by iatbm 2006-06-03 16:57:58

Re:

21 Reply by elbekko 2006-06-03 17:10:08

Re:

22 Reply by minis 2006-06-04 07:29:50

Re:

23 Reply by elbekko 2006-06-04 11:16:18

Re:

24 Reply by minis 2006-06-04 14:09:46

Re:

25 Reply by Smartys 2006-06-04 14:22:20

Re:

Posts [ 1 to 25 of 44 ]