Show all posts by user

Re: Fulltext searching - 18 years ago

Ah man, that's such an elegant solution! Thanks, really clever!

by optimal - Phorum Hack/Mod Requests

Fulltext searching - 18 years ago

Hello everyone After watching/listening to the Phorum seminar "MySQL tricks" I really wanted to look into guts of the FULLTEXT searching on your awesome code. I've tried making FULLTEXT tables before for searching on other projects but have never been able to make anything workable so it's of interest to me! First things first, why do you have a seperate table for search

by optimal - Phorum Hack/Mod Requests

Re: Interesting "CTRL+C" functionality for BBCode. Interested? - 18 years ago

QuotemauriceIt's a cool idea! I'd rather see it as a separate module than to have it embodied in the bbcode module. Agreed, it'd look good sat alongside BBCode in the Phorum Modules section. Just a simple toggle (active/inactive). I may run into problems if/when people create custom tags and smileys, but with some study of your BBCode backend I might be able to figure out some so

by optimal - Phorum Development

Interesting "CTRL+C" functionality for BBCode. Interested? - 18 years ago

Hey Maurice, Brian and Phorum users! Last month I wrote some code that intercepts CTRL+C on a webpage, and sneakily formats the selection with DCode (or BBCode) markup so that you actually copy the markup written to create the HTML! I'm interested to know if you guys think it would be a good feature for Phorum (as a bundled mod or an extension to the BBCode mod)? Here's the latest

by optimal - Phorum Development

Re: Why use MEDIUMTEXT over MEDIUMBLOB? - 18 years ago

Awesome! Well I think I've got a BLOB and TEXT table (cloned) and because of the lack of base64 shenanigans I think I prefer BLOB at the moment, but I can't truly tell until someone says they've got an error or corrupt file etc! Cheers for the info guys!

by optimal - Phorum Hack/Mod Requests

Re: Why use MEDIUMTEXT over MEDIUMBLOB? - 18 years ago

Gotta love those benchmarks! See, I would have went for this song instead ;)

by optimal - Phorum Hack/Mod Requests

Re: Why use MEDIUMTEXT over MEDIUMBLOB? - 18 years ago

Aha! I think I may clone my files table (so I have TEXT and BLOB) and compare the differences in storage and speed at a later date when I have more rows! Cheers Maurice, you're an inspiration!

by optimal - Phorum Hack/Mod Requests

Re: Why use MEDIUMTEXT over MEDIUMBLOB? - 18 years ago

Good point Maurice. I guess it's just that I FTP all my Images, Zips and so forth in Binary mode, and thus BLOB makes sense (if only that it is the Binary Large OBject) and that I've never seen file storage in TEXT mode, always BLOB. I believe flickr uses MySQL in the same manner, but would love to know if they have any tricks...

by optimal - Phorum Hack/Mod Requests

Why use MEDIUMTEXT over MEDIUMBLOB? - 18 years ago

Not a hack or anything like that, I'm just curious as to why you have chose to use MEDIUMTEXT rather than MEDIUMBLOB for the storage of files?

by optimal - Phorum Hack/Mod Requests

Re: Module: Pass Default Values (via url) - 18 years ago

Cheers Maurice!

by optimal - v5/v6 Modules/Add-Ons

Module: Pass Default Values (via url) - 18 years ago

This module allows you to pass default values to a "New thread", specifying subject and message body by appending variables to /posting.php. The readme has further details. You can pass variables with urls like these yourforum.com/posting.php?62,subject=your%20subject yourforum.com/posting.php?62,body=your%20message yourforum.com/posting.php?62,subject=your%20subject,body=your%

by optimal - v5/v6 Modules/Add-Ons

Re: Automatically fill the title / subject from GET variables of new topics - 18 years ago

HAHA! Yes! Thanks Maurice and Thomas! You're total legends (as ever). Should I make this a "proper" module for your guys? I've created a module thread

by optimal - Phorum Hack/Mod Requests

Re: Automatically fill the title / subject from GET variables of new topics - 18 years ago

Right, I'm almost there! The after_login hook isn't working for me, I have added the hook to info.txt, and the function to the pass_default_values.php file as so: function phorum_mod_pass_default_values_after_login() { // If there is a cookie, use it! if ($_COOKIE['pass_default_values_redirect_url']) { return $_COOKIE['pass_default_values_redir

by optimal - Phorum Hack/Mod Requests

Re: How can I truncate message subjects? - 18 years ago

If it's a design thing, maybe you could just do it with CSS? Example: <h3>Really long title here that breaks the page</h3> <style type="text/css"> h3 {overflow: hidden; width: 250px; font-size: 20px; line-height: 30px; height: 30px;} </style>

by optimal - Phorum Hack/Mod Requests

Re: Automatically fill the title / subject from GET variables of new topics - 18 years ago

I'm still confused as to how to change the link paths and login redirects. I've uploaded my mod so far. I've tried loads of different mod-hooks, php code and template changes but I don't know how to keep the extra URL info on these spots: "Click here to login" link "Not Registered? Click here to register now." link Login form redirect Register form re

by optimal - Phorum Hack/Mod Requests

Re: Automatically fill the title / subject from GET variables of new topics - 18 years ago

Thanks for the reply Thomas. Sorry to be a fool, but I am kinda lost in the code, I'm checking: login.php posting.php redirect.php But can't find (or understand) where to check. Is this a hook, php or tpl hack?

by optimal - Phorum Hack/Mod Requests

Re: Automatically fill the title / subject from GET variables of new topics - 18 years ago

Okay, looking good so far, I have the module working in a sense. When it's sorted (pretty quickly knowing you Maurice) I'll add it to the mods forum. If you see this screengrab (excuse the "pointer" I had to draw it on!), the link points to just the id of the forum, and excludes the extra data as seen in the URL. I'm not sure where / how to modify this link, is

by optimal - Phorum Hack/Mod Requests

Automatically fill the title / subject from GET variables of new topics - 18 years ago

Most of the question is in the title. How would I go about modding phorum so that I can pass variables to "posting.php" and have them written to the page. Normally this would be a simple hack, but for some reason I get thrown off a page when sending GET variables. IE: posting.php?1 - works posting.php?1&subject - works posting.php?1&subject=value - fails, and throws me o

by optimal - Phorum Hack/Mod Requests

Re: How does the templating actually work? - 18 years ago

Oh, OK, I think I'm confusing myself again! Sorry if I'm throwing non-sequiters about the place :-S

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Hey guys, I've just found something on the PHP site about eval and errors: Quotehttp://php.net/eval Return Values eval() returns NULL unless return is called in the evaluated code, in which case the value passed to return is returned. If there is a parse error in the evaluated code, eval() returns FALSE and execution of the following code continues normally. It is not possible to ca

by optimal - v5/v6 Templates

Re: Tidy Template, whitespace issues with inline CSS - 18 years ago

Ah yes, I've modified my example so it makes more sense!!

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

A lot of that is over my head, so am I right in thinking: When a template loads, it actually loads up a "stub" that then further includes the rendered file. Your suggestion is to modify these stubs to simply swap in some MySQL / eval code?

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Legend!

by optimal - v5/v6 Templates

Re: Tidy Template, whitespace issues with inline CSS - 18 years ago

Er no, in this file: /include/templates.php ~ line 225 (reads // Strip whitespace after tags that we can safely ignore.) The templating engine will rid all whitespace after a block level element, however the list of block elements surely depends upon your stylesheet and doctype. Wouldn't it be best to leave a single space character, just in case the element is rendered as inline?

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Yes, I am pretty happy with the results, I might get the chance to make this my first plugin unless one of you folks get there first!

by optimal - v5/v6 Templates

Tidy Template, whitespace issues with inline CSS - 18 years ago

Hey guys, just a heads up about a possible issue with Tidy templates; Because all whitespace is stripped after "block" elements when $do_tidy >= 2 it means that if these elements are modified to be inline elements using CSS then the usually renderable whitespace is missing. For example: <div>Hello</div> (and other whitespace) <span>World</span>

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Test 3 completed with "faux MySQL" connection added to the include script, now I think we have a reasonably accurate set of results!! You guys are right, the MySQL / eval version is marginally* slower than the straight-up include. Either way I think I may opt to use the eval version in my system as I'm going to be serving hundreds of different sites as aliases with one centr

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Hey guys, just ran test 2 that has a MySQL request with the eval script. Although, I may have to do a third test whereby the include script opens and closes a MySQL pipe as there will be a connection, but no SELECT statement run in a real world scenario...

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Yes, very true! I'm unsure how that would work in Phorum per se, but in my current setup, either method would have extremely similar database calls so I am putting that down to experience! Edit: If I assume that Phorum has a DB connection in both cases already, I'll create a test 2 and test 3 with further benchmarking, give me a little while to get started on this, I've already

by optimal - v5/v6 Templates

Re: How does the templating actually work? - 18 years ago

Nope, there's no opcode cache on that subdomain, it's a standard PHP5 install

by optimal - v5/v6 Templates