SOLVED. - formulating a if sentence

[Vaupell]

still getting error
Parse error: parse error in D:\xampp\htdocs\forums\invitationcode.php on line 363

Gonna try it on a live server, if the code is correct maybe its the server
using php 5.2.8 / mysql 5.1.3 and latest apache release.

but it might be missing a module just running of the install, no special modifications made.

OMG..

now im gonna take a brake, now i just learned it DOSENT execute install query when installing

$db->hide_errors();
		$vbulletin->db->query_write(" 
			CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."vbinvitationcode` (
		    `codedbID` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
		    `InvitationCODE` VARCHAR(100) NOT NULL,
			`NewusergroupID` VARCHAR(100) NOT NULL,
	    ");
		$db->show_errors();

i have also made a drop for the uninstall, but that proberly wont work either.

where does it instruct me, on how to execute a query dureing install,
cant find it in the manual, so simply put it in the install code box.
refering to : http://www.vbulletin.com/docs/html/creating_a_product

off to a brake before i blow up.

[COLOR=""]--------------- Added [DATE]1233706418[/DATE] at [TIME]1233706418[/TIME] ---------------------------------------------[/COLOR]
#########################################EDIT UPDATE BELOW#########################
okay a little update here..

current if statement :

$vbulletin->input->clean_gpc('r', 'invitation', TYPE_NOHTML);

if ($vbulletin->GPC['invitation'])
{ 
$invitegroupid = $db->query_first_slave("SELECT NewusergroupID FROM " . TABLE_PREFIX . "vbinvitationcode WHERE '" .  $db->escape_string($vbulletin->GPC['invitation'] . "' = InvitaionCODE");
  $userdata->set('usergroupid', $invitedgroupid);  
}
else
{
  $userdata->set('usergroupid', $newusergroupid);
}

how can if ($vbulletin->GPC['invitation']) <-- do anything
shoundt there be a "if ($vbulletin->GPC['invitation'] = content )

cause if i enter "lol1" as invitation code on registration, then the it would say

if (lol1)
{}
else
{}

dosent it just skib the entire if ? since if will never be true, the SQL query just gets the data
but only if "if" is true.

reference of this : http://www.w3schools.com/php/php_if_else.asp
Im thinking maybe run the query :

$sql = select * InvitationCODE from vbinvitation
if $sql <>
{
set usergroup standard
}
else
{
$newgroupid = select newusergroupID from vbinvitation where $sql = invitation
set usergroupid newgruopid
}

i know its missing alot but its a draft



************************************************** ****SOLVED***************************************

Its not working, but it dosent promt with erros anymore :P

// 
if ($vbulletin->GPC['invitation'])
{ 
$invitegroupid = $db->query_read_slave("
        SELECT NewusergroupID
		FROM " . TABLE_PREFIX . "vbinvitationcode 
		WHERE InvitationCODE = '" . $db->escape_string($vbulletin->GPC['invitation']) . "'"
	);
  $userdata->set('usergroupid', $invitedgroupid);  
}
else
{
  $userdata->set('usergroupid', $newusergroupid);
}