Search found 38 matches

by OBeer-WAN-Kenobi
Thu Aug 21, 2008 2:03 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Transparent Forum Lists + Background Image?
Replies: 9
Views: 3207

Re: Transparent Forum Lists + Background Image?

Thanks, I actually want the image to be smaller though, not larger. I'd like the image to be around 600 pixels wide so that the rounded corners on my portal and board (bg_list.gif) are on background and not on background image. Does that make sense? Would I still need to create a new div or could I ...
by OBeer-WAN-Kenobi
Sat Aug 16, 2008 6:34 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Transparent Forum Lists + Background Image?
Replies: 9
Views: 3207

Re: Transparent Forum Lists + Background Image?

as for opacity settings... /* for IE */ filter:alpha(opacity=80); /* CSS3 standard */ opacity:0.8; /* for FF */ -moz-opacity: 0.8; If you have any problems, feel free to ask... Where would I change the above code or add it? Thanks very much for your help! I used the code you gave me and it put the ...
by OBeer-WAN-Kenobi
Sat Aug 16, 2008 3:43 am
Forum: [3.0.x] Styles Support & Discussion
Topic: Transparent Forum Lists + Background Image?
Replies: 9
Views: 3207

Re: Transparent Forum Lists + Background Image?

OK, I've gotten pretty far but I can't get everything to scroll past with the background image staying in the center..... It just stays at the top and then when I scroll down I get past it onto the normal background color. How do I fix this? The link above is still correct. Also I haven't figured ou...
by OBeer-WAN-Kenobi
Sat Aug 16, 2008 3:05 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

Thanks again drathbun, I had a little trouble but got it working with your code: This: $sql = 'SELECT topic_title, forum_id, topic_id FROM ' . TOPICS_TABLE . ' WHERE topic_approved = 1 AND forum_id = 1 AND topic_moved_id = 0 AND ucase(substring(topic_title,1,1)) NOT BETWEEN "A" AND "Z" ' . $sql_wher...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 11:12 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: New Styles not displaying in ACP
Replies: 2
Views: 128

Re: New Styles not displaying in ACP

Hmmm...... It must be something silly...... those are always the ones that get me too. :D Are you absolutely sure you have the whole folder ie. "acidtech" uploaded to the "yourdomain.com/phpBB3/styles" folder so that when you click on the styles folder you see another folder named "acidtech". Inside...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 10:56 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

Whoa... wait a sec... What about this? $sql = 'SELECT topic_title, forum_id, topic_id FROM ' . TOPICS_TABLE . ' WHERE topic_approved = 1 AND forum_id = 1 AND topic_moved_id = 0 AND topic_title NOT BETWEEN "A" AND "Z" ' . $sql_where . ' ORDER BY topic_title ASC'; $result = $db->sql_query($sql); I jus...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 8:45 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

Ok, just to be clear........ Will this work? $sql = 'SELECT topic_title, forum_id, topic_id FROM ' . TOPICS_TABLE . ' WHERE topic_approved = 1 AND forum_id = 1 AND topic_moved_id = 0 AND topic_title ucase(substring(topic_title,1,1)) NOT BETWEEN 'A' AND 'Z' ' . $sql_where . ' ORDER BY topic_title ASC...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 6:42 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Rotating Banners Showing Up on Macs but not PCs
Replies: 18
Views: 1435

Re: Rotating Banners Showing Up on Macs but not PCs

Sorry man, still no dice with IE. It's gotta be something stupid we just aren't seeing. :oops: I like the looks of it better above the navbar though... a guy doesn't have to go above the add to get around that way. JMHO of course. Here is the script I'm using: http://www.ledscripts.com/free/php/phpl...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 6:37 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

SQL uses the single-quote apostophes around strings, not double-quotes. The NOT LIKE '{a-c]%' seems to work fine on MSSQL. The "!" for NOT does not. Wierd........ I tried it with single quotes and it gives me a syntax error. It was frustrating the heck out of me until I finally tried the double quo...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 5:49 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

Did you try NOT LIKE '[A-Z]%' I think so, but I don't remember. in any case, it wouldnt work with ' I always had to use ". I will give it a try tonight as I can't ftp from work. or LIKE '[!A-Z]%' I don't think I tried this one. I'll give it a try tonight also. Thanks very much for your help!
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 5:38 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

Try one with a title like: "A something" OK, IC. With the title (A something) it also goes into the "# list" instead of just showing up under the "A" list. So I should try something like this from what drathbun posted? $sql = 'SELECT topic_title, forum_id, topic_id FROM ' . TOPICS_TABLE . ' WHERE t...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 5:08 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query to search for "non letter"
Replies: 19
Views: 1532

Re: SQL Query to search for "non letter"

This AND topic_title NOT BETWEEN "A%" AND "Z%" ... is not doing what you think it is, and in fact, it's broken. :) The wildcard % only works with the operator LIKE and NOT LIKE. When you use it with other operators like BETWEEN it is treated as a literal. That's why I did a substring an then a betw...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 5:02 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Rotating Banners Showing Up on Macs but not PCs
Replies: 18
Views: 1435

Re: Rotating Banners Showing Up on Macs but not PCs

No it's still not working. I am currently running rotating banner adds on my forum but with a different script. Either way the thing that jumps out at me is that I have them added to overall_header.html Maybe you can give that a try? Get rid of them out of where you have it now and open overall_head...
by OBeer-WAN-Kenobi
Fri Aug 15, 2008 4:41 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Transparent Forum Lists + Background Image?
Replies: 9
Views: 3207

Re: Transparent Forum Lists + Background Image?

Basically I want a large logo to be static behind the forumlists like the guitar is in the link above. I want the forums to be transparent but a little opaque so you at least notice when you are scrolling down. On mouse-over I want them to have the look of glass. Like they have a glass lid on top of...
by OBeer-WAN-Kenobi
Thu Aug 14, 2008 8:06 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Transparent Forum Lists + Background Image?
Replies: 9
Views: 3207

Re: Transparent Forum Lists + Background Image?

Anybody? Maybe I didn't explain it very well. What I want to do is something like this: http://demo.phpbb3styles.net/axeattack The guitar in the above example stays in one place and the forum lists are transparent. As you scroll down you can see the guitar behind them. How do I go about getting this...

Go to advanced search