mysql_real_escape_string

[jamesfrost]

I'm pretty sure it is. However, I've always done a global find/replace across all PHP files in the directory just to be sure. Most decent editors should have this functionality - I personally use Visual...

[jamesfrost]

stop coming up with problems and suggest the solution then!

OK - added a check to remove deleted posts:

SELECT post.username FROM post
left join deletionlog ON(deletionlog.primaryid...

[jamesfrost]

thanks - have edited the SQL above. Hard deletes were already taken care of - have added visable=1 to take care of soft deletes....

[jamesfrost]

Just use MySQL's limit function to return the 100,000th poster. The record number starts at 0, so for the 100,000th post you need to get the post number 99,999 in the list :

select username...

[jamesfrost]

I've got the similar issue:

I can see IP addresses in my mods and admins forum.
I can't see IP addresses anywhere else.

I'm a full admin of the forum. Any ideas?

[jamesfrost]

I've been trying to incorporate a text cleaning function which used mysql_real_escape_string to escape special characters before updating my DB. However, I notice in the db_mysql.php that there is a similar...

[jamesfrost]

This seems to be the same question (albeit from a slightly different angle) as I was asking here :

http://www.vbulletin.com/forum/showthread.php?t=113669

At the moment you...

[jamesfrost]

great - thanks

[jamesfrost]

can I do a global replace on the license number then, or is there a has somewhere that would prevent this? Or can I get VB's permission to install two copies of the same forum if I buy two licenses....

[jamesfrost]

is there an answer then? Ideally I'd just like to buy a second VB licence, and use the same source code for both forums.

[jamesfrost]

I'm about to expand the number of VB sites I run, from 1 to several. Ideally I want to use the same code base for all the sites to keep things simple from a development / upgrade point of view. However,...

[jamesfrost]

looks fantastic. Will be installing along with vb3.02 - pretty soon if the top right of this web page is anything to go by!

[jamesfrost]

you can also add '& # 160;' (remove spaces and comments to allow multiple spaces)

like     this!

[jamesfrost]

is this it?

http://www.securityfocus.com/archive...8/2004-02-14/0...

[jamesfrost]

Steve

thanks for the (incredibly! ) quick reply. Any idea what the virus is, so I can warn users about it?

James Frost

[jamesfrost]

We have had a few members recently who have had their homepage set to a porn site without them doing this themselves(and I believe them on this, as they have been members for a while). Don't know if it...

[jamesfrost]

Have found the issue here - feel free to delete or move this post.

Ensure that in the config-inc.php in photopost you enter the vbulletin license number (in the members page) instead of...

[jamesfrost]

I've shed some light on the photopost / vb integration issues - The cookie for bbpassword seems to be encoded differenly for VB and photopost. I've created a user with password 'test'. When logged into...

[jamesfrost]

Steve,

understand you can't really support this, but thanks for coming back to us anyway. I've tried setting cookie prefixes as the same, and as different entities, but with no joy. Have...

[jamesfrost]

I have photopost (4.6.6) and vb (3 RC4)set to the same cookie prefix and it is forcing me to login to both separatly as well. Have cleared cookies etc etc. No joy