[jluerken]

Hi author,

I found a bug in the request award section.

I am using table prefixes in my installation and request_award is not taking care about this.

Everytime a user requests an award I get this db error:

PHP Code:

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'88856','CFN|LordSoth Award Request Form','CFN|LordSoth','4','1117187527','[b]Award Request Form - CFN|LordSoth[/b]

------------------
[color=blue][b]Sender Information[/b][/color]

UserID: [url=http://www.clanforums.com/forum/member.php?u=4]4[/url]
Username: CFN|LordSoth
Fullname: CFN|LordSoth

-----------------------------
[color=red][b]Request Information:[/b][/color]
Award ID: [b][url=http://www.clanforums.com/forum/awards.php#award3]3[/url][/b]
Award Name: [b]Donationaward[/b]
Award Description: [b]Thanks for your donation[/b]
[url=http://www.clanforums.com/forum/awards.php#award3][img]https://vborg.vbsupport.ru/[/img][/url]

Recipient username : [b][url=http://www.clanforums.com/forum/member.php?username=Toky] Toky [/url] [/b]

-----------------------------------------------------
Please explain why the listed recipient should receive the award.

Sponsoring
-----------------------------------------------------
','1','1','0','0','1')
mysql error: Table 'usr_web1_3.post' doesn't exist

mysql error number: 1146 


The table name is not usr_web1_3.post, its usr_web1_3.vb3_post where vb3_ is the prefix


The error is in request_award.php around line 40
And line 41 has the same error. It should be:

PHP Code:

UPDATE " . TABLE_PREFIX . "thread SET