Sorting Hat

**something else** · 02.10.15, 21:34

SQL:

Code:

ALTER TABLE `ibwf_users` ADD `house` VARCHAR( 25 ) NOT NULL DEFAULT 'Muggle';

php:

PHP Code:


mysql_query("UPDATE ibwf_users SET house='".$house."'");

Profile:

PHP Code:


$house = mysql_fetch_array(mysql_query("SELECT house FROM ibwf_users WHERE id='".$who."'"));
echo $house[0].'<br/>';

**sky2kv** · 03.10.15, 14:39

Thanks Bro,it works well

How do i make it so that when a member uses the magic hat and is selected as Hufflepuff ,now when he enters magic hat to play again,he must be told,"You Are A Hufflepuff Member"....and he mustnt be able to play a second time and anytime after he is selected the first time...
Many Thanks For You Help

**something else** · 04.10.15, 21:32

PHP Code:


$house = mysql_fetch_array(mysql_query("SELECT house FROM ibwf_users WHERE id='".$uid."'"));
if($house[0]!='Muggle')
{
echo 'You Are A ' $house[0].' Member'<br/>';  
}
else
{
//Do normal stuff here
}

**sky2kv** · 05.10.15, 07:19

Originally posted by something else View Post

PHP Code:


$house = mysql_fetch_array(mysql_query(&quot;SELECT house FROM ibwf_users WHERE id='&quot;.$uid.&quot;'&quot;));
if($house[0]!='Muggle')
{
echo 'You Are A ' $house[0].' Member'<br/>';  
}
else
{
//Do normal stuff here
}

Thanks bro,will try this out

**sky2kv** · 05.10.15, 15:16

Originally posted by sky2kv View Post

Thanks bro,will try this out

The problem im facing now,is that whenever any member plays the hat and whatever they are Named,shows in all other members profiles...like if im a Hufflepuff already and a member plays and he turns out to be a Raven,then automatically im also changed to Raven...

**something else** · 06.10.15, 15:37

oops sorry - i messed up in my first post..... it should be:

PHP Code:


mysql_query("UPDATE ibwf_users SET house='".$house."' WHERE id='".$uid."'");

**sky2kv** · 07.10.15, 16:21

Originally posted by something else View Post

oops sorry - i messed up in my first post..... it should be:

PHP Code:


mysql_query("UPDATE ibwf_users SET house='".$house."' WHERE id='".$uid."'");

Awsome Bro,now it works

Sorting Hat

how to Sorting Hat

Comment

Comment

Comment

Comment

Comment

Comment

Comment