View Full Version : SELECT c.id, in search box on vbulletin search
May 8th, 2008, 12:41 PM
running vbulletin 3.69 and photo post pro 6.1.
in the advanced search of vbulletin, the search box is automatically populated by:
i asked and looked around on vbulletin and was told it was from photopost. that was when i was running an older version of photopost and i upgraded yesterday and it's still there.
any ideas? thanks!
May 8th, 2008, 12:48 PM
Our code should never be displaying in vbulletin in any manner since we never touch any of their files. Do you have any hacks installed?
May 8th, 2008, 11:35 PM
IE showed more than FireFox (above). here's what it's telling me..
SELECT c.id, c.catname, c.description, c.catorder, c.parent, c.thumbs, c.children, c.photos, c.posts, p.id, p.user, p.userid, p.date, p.title, com.username, com.id, com.date, com.photo FROM pp_categories c LEFT JOIN pp_photos p ON c.lastphoto=p.id LEFT JOIN pp_comments com ON com.id=c.lastpost ORDER BY c.catorder ASC
that's what's in the search box on the search page.
i disabled the hook function in vbulletin but it still showed up. but the stuff above is photopost stuff isn't it?
May 9th, 2008, 09:34 AM
What I am saying is this though why would Photopost stuff show up on your vbulletin? vbulletin does not even know Photopost is installed. You sure you dont have any hard coded hacks in your vb files not just plugins disabled?
We dont touch their code in any manner ever so vb should not know Photopost is there
May 10th, 2008, 08:06 PM
If you have time to take a look...(i havent' really hacked vb in awhile..maybe way back in the days but not anytime recently (like in the last 5 years) so it's never showed up before until this new update. i'll update to 3.7 tonight probably so maybe it'll go away.
the source code displays this in the input box to put in the search words.
<input type="text" class="bginput" name="query" size="35" value="SELECT c.id,
FROM pp_categories c
LEFT JOIN pp_photos p ON c.lastphoto=p.id
LEFT JOIN pp_comments com ON com.id=c.lastpost
ORDER BY c.catorder ASC" style="width:250px" />
May 10th, 2008, 08:34 PM
I would think there has to be some sort of hack involved here. as stated vbulletins default code has no idea photopost is installed so this has to be coming from a hack. I have viewed many searchs from vb on sites that use our software and do not see this issue. I myself run a vb site with photopost
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.