Search found 16 matches

by DejanPP
Sat Mar 31, 2007 9:04 pm
Forum: 2.0.x Support Forum
Topic: Visual confirmation for guest
Replies: 3
Views: 448

Re: Visual confirmation for guest

Now I have installed aditionaly this mod
http://www.phpbb.com/community/viewtopic.php?t=495004
I hope this will help.
by DejanPP
Sat Mar 31, 2007 11:47 am
Forum: 2.0.x Support Forum
Topic: Visual confirmation for guest
Replies: 3
Views: 448

Re: Visual confirmation for guest

Well, I have enabled visual confirmation, same as for registering and today had two new link to porno which open troyan horse setup.exe.

That bot probably can analize image and get code, is there any better maner to block that ? Anyone is interesed to share blocked IP list ?
by DejanPP
Thu Mar 29, 2007 11:00 pm
Forum: 2.0.x Support Forum
Topic: Visual confirmation for guest
Replies: 3
Views: 448

Visual confirmation for guest

Hi, In one only forum unregistered users can post and I would like to keep this forum open and public. Is there any mod or standard option which enable visual confirmation (or some other method) when unregistered user want to post in forum (because of stupid porno posts). version 2.0.22 tnx in advan...
by DejanPP
Tue Mar 06, 2007 3:05 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Grabbing the first post of each topic in a forum
Replies: 11
Views: 510

I am wondering why you tried to answer the question then? I don't mean to be rude, I really don't. But if you don't know the database structure then how can you presume to offer advice? Because none answer, actually, he need to understeand sql and then can do anything, that is better to help someon...
by DejanPP
Tue Mar 06, 2007 2:45 am
Forum: [2.0.x] MOD Writers Discussion
Topic: database structure
Replies: 4
Views: 3053

Warning I don't need to update code in previous post before I finish all, if someone using that there is potential security problem : not on all strings is applyed "str_replace(...", in theory on main site someone can put malicious email or password and to apply sql injection. My site validating th...
by DejanPP
Tue Mar 06, 2007 2:35 am
Forum: [2.0.x] MOD Writers Discussion
Topic: Grabbing the first post of each topic in a forum
Replies: 11
Views: 510

Honestly : I didn't tryed even to understeand his query because I don't know phpbb database structure. That is not problem for me to understeand some database model, I just have to much other work to do and I am here only last few days till finish my modification :) I suposed he know what he doing a...
by DejanPP
Mon Mar 05, 2007 11:15 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Using phpBB with another login system
Replies: 43
Views: 32975

if you doing that on same server this is easy, what I were doing are two servers, another one is windows and asp.
by DejanPP
Mon Mar 05, 2007 11:03 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Grabbing the first post of each topic in a forum
Replies: 11
Views: 510

Well, I said that I don't have access to database with some real data and don't want to mess my forum because making some modifications in this moment but basicly, he need to understeand agregating functions and group by. Suposing that table phpbb_posts had many records related so, he have duplicate...
by DejanPP
Mon Mar 05, 2007 7:58 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Grabbing the first post of each topic in a forum
Replies: 11
Views: 510

I couldn't simply use Last Reply Time as there will be replies to each topic I grab the first post from, and I would like to get the specific time in which the topic was originally posted (in other words, the post time of the first post of the topic) and not simply the time in which the last reply ...
by DejanPP
Mon Mar 05, 2007 7:43 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Using phpBB with another login system
Replies: 43
Views: 32975

Post code here, I will need this soon (have no time to implement that right now, too buzy with other details). You may be interesed in something compatible with that what I did yesterday, user creation and update from another site : http://www.phpbb.com/phpBB/viewtopic.php?t=524408 Anyway, what you ...
by DejanPP
Mon Mar 05, 2007 7:13 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Grabbing the first post of each topic in a forum
Replies: 11
Views: 510

Hey all, I'm currently running an installation of phpBB, and I need to grab the first post of each topic in a specific forum so that I can echo the data later on in the script. I have all my functions and includes setup so that I can use phpBB's BBcode and such, but I used a MYSQL query I had found...
by DejanPP
Mon Mar 05, 2007 5:28 am
Forum: [2.0.x] MOD Writers Discussion
Topic: Help with Cherry-Picking an SQL Query--SOLVED
Replies: 5
Views: 296

I didn't look in database what for is this table and didn't checked database structure but ... when something is slow

check index's, on used fields
by DejanPP
Mon Mar 05, 2007 5:09 am
Forum: [2.0.x] MOD Writers Discussion
Topic: database structure
Replies: 4
Views: 3053

Almost done ...

Khm ... sometime I can't stop before finish something :) Well, if you thin this is usefull I can post all details and upload that as MOD, for a moment critical part is here, if someone see any bug welcome ... : Short resume : I want forum users to register on main web site and automaticaly to create...
by DejanPP
Mon Mar 05, 2007 1:23 am
Forum: [2.0.x] MOD Writers Discussion
Topic: database structure
Replies: 4
Views: 3053

quite fast answer, tnx a lot, I can today finish .php page and to continue on .asp tomorow :)

Resume :
All 3 inserts are needed and because user_active is already "1" no more actions is needed.

Aditionaly I need to repeat insert No 3 in order to add user to predefined group.
by DejanPP
Mon Mar 05, 2007 12:41 am
Forum: [2.0.x] MOD Writers Discussion
Topic: Why submit your MODs to the MOD Database?
Replies: 93
Views: 129332

I am first time here, 2 days ago first time downloaded PHPBB2 and now doing some modifications. I am experienced programmer and but not experienced with .php and .mysql. Who care ... all of that is same, sql is sql and .php is not problem (because I am very good with .asp and html standard). My modi...

Go to advanced search