[RedTyger]

Originally Posted by BrettMo

I am getting this error occasionally. Any ideas?

PHP Code:

Database error in vBulletin 3.6.5: Invalid SQL:
SELECT post.userid, userfield.field5, userfield.field6, user.usergroupid                        FROM XXpost AS post, XXuserfield AS userfield, XXuser AS user                            WHERE threadid =                             AND 
userfield.userid = post.userid                    AND 
user.userid = post.userid                    
ORDER BY post.dateline DESC                
LIMIT 1; 

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND userfield.userid = post.userid        AND user.userid 

Error Number : 1064
Date         : Thursday, March 29th 2007 @ 06:25:12 PM
Script       : http://www.russophile.com/russia_blog/25-russian_web_sites_more_dangerous-post32.html
Referrer     : http://by126w.bay126.mail.live.com/mail/ApplicationMain_11.10.0000.0095.aspx?culture=en-US&hash=4055484223IP Address   : XX.XX.XX.XX
Username     : Unregistered
Classname    : vb_database 


By the way, I could not find any reference to how much you consider a reasonable donation to remove the copyright notice. Could you give some guidance? I sent you a little cash for that last night, but did not hear back from you. I appreciate your efforts. :up:

Thanks!

Thanks, I'll check into that. Would I be right in guessing that the error appears when you view a post individually and not as part of a thread? I could do with the details of when it happens please.

Originally Posted by brihan

Hi RedTyger,

I was one that you just returned money to. I was hoping to get a copyright free edition for obvious reasons (you do great work and I don't want my competition to know) but I would like to donate to you anyway.

I put in a ton of time on this computer thing and the work you do saves me even more time (Actualy, I couldn't do it) as it does everyone else who uses your programs.

Copyright free would have been nice but I still want you to accept my money in appreciation for the work and time you have put in to this project.

I think everyone should show their appreciation (for every mod they use). If you got paid by everyone I'm sure you would have the incentive (and money) to create more excellent mods.

That's just my opinion.

Brian

Thank you very much indeed, that's very kind of you. I am sorry to have had to stop doing brand-free because I know some people will just go elsewhere and I liked giving the option. But it was a small amount of money even for brand free and I would guess at least half the people who wanted brand-free paid the wrong amount, gave me the wrong contact details, didn't provide the required information, didn't read the instructions...basically it was just wasn't working and the money didn't cover the hassle.

Anyway, thank you. Don't hesitate to ask if you need help with something.

Originally Posted by KipLarson

Is there any support for an advertising page where advertisers can see various rates for stuff on the site, and in turn pay for the ads? The admin can then either approve or decline the ad?

Also, I want to set up premium memberships on my site, how will this hack fit in?

There is no support for advertisement submission at this time. It will fit in easily with Usergroups, you have full control over who can see them and in the case of adsharing, who can use them as well.

Originally Posted by MelH

Thats ok I figured it out...

Good good. Don't forget to click install, don't want people missing out on updates.