Search found 494 matches

by lozt
Tue Dec 07, 2010 1:50 am
Forum: phpBB Discussion
Topic: SQL Command help
Replies: 12
Views: 940

Re: SQL Command help

Code: Select all

UPDATE phpbb_topics SET topic_views = topic_views floor +(1 + (RAND() * 10)) WHERE topic_id >=100;
Like this?
by lozt
Mon Dec 06, 2010 10:43 am
Forum: phpBB Discussion
Topic: SQL Command help
Replies: 12
Views: 940

Re: SQL Command help

sleazy tactic? it's not like im doing anyone harm. at least im not going around spamming trying to get traffic. I found the answer from googling the term mysql random as you suggested. Thanks for that. Here the command if anyone else wants it: UPDATE phpbb_topics SET topic_views = topic_views +(1 + ...
by lozt
Mon Dec 06, 2010 6:03 am
Forum: phpBB Discussion
Topic: SQL Command help
Replies: 12
Views: 940

Re: SQL Command help

Code: Select all

UPDATE phpbb_topics SET topic_views = topic_views +900 WHERE topic_id >=100;
Hi guys, I was wondering if there was a way to change the set amount the views are increased to a random number range instead?

For example, instead of post view increase by 900, how about anywhere from 50-900? (randomly)
by lozt
Fri Jun 11, 2010 4:59 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: phpbb3.0.7 ProSilver - header div?
Replies: 13
Views: 1478

Re: phpbb3.0.7 ProSilver - header div?

Ok, now im confused what you are trying to do. I thought you was adding the ".header-bar " class to the CSS.
by lozt
Fri Jun 11, 2010 5:45 am
Forum: [3.0.x] Styles Support & Discussion
Topic: phpbb3.0.7 ProSilver - header div?
Replies: 13
Views: 1478

Re: phpbb3.0.7 ProSilver - header div?

I never tired adding it via ACP, but try changing it in the actual file instead.
by lozt
Wed Jun 09, 2010 8:29 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: phpbb3.0.7 ProSilver - header div?
Replies: 13
Views: 1478

Re: phpbb3.0.7 ProSilver - header div?

Did you login your ACP and under themes, clear your cache?
by lozt
Wed Mar 17, 2010 12:50 am
Forum: [3.0.x] Styles Support & Discussion
Topic: phpbb3.0.7 ProSilver - header div?
Replies: 13
Views: 1478

Re: phpbb3.0.7 ProSilver - header div?

Ahhh, i see what happened now. I should had knew better, thanks for clearing that up for me.
by lozt
Tue Mar 16, 2010 3:25 am
Forum: [3.0.x] Styles Support & Discussion
Topic: phpbb3.0.7 ProSilver - header div?
Replies: 13
Views: 1478

phpbb3.0.7 ProSilver - header div?

I been trying to figure out how to change the header height. I tired :

page-header
headerbar
navbar

I really can't find where to change this. Anyone able to lead the way?
by lozt
Fri Jul 17, 2009 5:39 pm
Forum: phpBB Discussion
Topic: Cronjob auto login?
Replies: 6
Views: 522

Re: Cronjob auto login?

but this will require manual update for the time to change, right?

Im not too good with databases or crons, do you have a sample script/command or whatever is required to do this?
by lozt
Fri Jul 17, 2009 4:30 pm
Forum: phpBB Discussion
Topic: Cronjob auto login?
Replies: 6
Views: 522

Re: Cronjob auto login?

im not trying to do anything special, just trying to make the forum look more active then it really is.
by lozt
Fri Jul 17, 2009 9:32 am
Forum: phpBB Discussion
Topic: Cronjob auto login?
Replies: 6
Views: 522

Cronjob auto login?

Is there a way to auto login the forum at a cretin time? I understand cronjob might be able to do this some how?
by lozt
Sat Jul 11, 2009 11:38 am
Forum: [3.0.x] Styles in Development
Topic: [Release] Warhammer [phpBB 3.0.4]
Replies: 33
Views: 7574

Re: [Release] Warhammer [phpBB 3.0.4]

LOL I'll try to get it done over the weekend, if not i'll update it no longer then next week. (maybe I'll do it at work today. i work on Saturdays :lol: ) Side Note: Next time phpBB comes out with a new version, be sure to request an updated version of this style. I won't update unless i'm sure some...
by lozt
Wed Jul 08, 2009 5:39 am
Forum: phpBB Discussion
Topic: Login MySQL with Navicat
Replies: 2
Views: 334

Re: Login MySQL with Navicat

Oh, never mind I finally figured it out.

The first tab is for your SQL login and the SSH tab is for the cpanel login.
by lozt
Wed Jul 08, 2009 5:34 am
Forum: phpBB Discussion
Topic: Login MySQL with Navicat
Replies: 2
Views: 334

Login MySQL with Navicat

Anyone has any idea how to login MySQL using Navicat?
I am not sure which login is required to gain access.
The cpanel login or the database login? I'm guessing it would require both, but I have no idea how to set this up.

http://navicat.com
by lozt
Tue Jul 07, 2009 3:36 pm
Forum: phpBB Discussion
Topic: Thank you, thank you, thank you!
Replies: 1919
Views: 791041

Re: Thank you, thank you, thank you!

I highly doubt anyone who had helped me will find their name here and I am not about to write a wall of text, so I am just going to thank "primedomain" for helping me when I first was introduced to phpBB (and php in general). I am loving this this software and highly appreciate the work this communi...

Go to advanced search