lockh problem.. didnt working

[Slark__]

can help me i create lockh but not working .. and also pickup.alpha not working. ;/

else if ( cmd == "lockh" )
   {
   if ( binfo[player.ID].registered==true )
   {
   if ( binfo[player.ID].logged==true )
   {
      if ( player.IsSpawned )
      {
      if ( text )
      {
      local q = QuerySQL( db, "SELECT Owner FROM Sethome WHERE ID LIKE '" + text + "'" );
      if ( GetSQLColumnData( q, 0 ) != player.Name ) MessagePlayer ( RED+"Error - You don't own this House.", player);
        else {
      local pickup = FindPickup(text);
      QuerySQL( db, "UPDATE Sethome SET nogoto = 'on' WHERE ID = '" + text + "'");
      pickup.Alpha = 50;
      MessagePlayer(LGREEN+"You have lock your House.",player);
      }
      }
      else MessagePlayer( "USAGE /"+cmd+"[HouseID].", player);
      }
      else MessagePlayer( "Error - You haven't spawned.", player);
      }
      else MessagePlayer( "Error - You are not logged in.", player);
      }
      else MessagePlayer ( "Error - You haven't registered your nickname.", player);
   }

anyone help me pls
   

[KAKAN]

Any debug info?( did you even try to debug it? )
Anyway, what if the binfo shit doesn't exist?
And too, tell us what's the problem. I think the problem is with the 2nd query. ID is an integer or a string?
Provide me with all the details and I can help you out

[Slark__]

Any debug info?( did you even try to debug it? )
Anyway, what if the binfo shit doesn't exist?
And too, tell us what's the problem. I think the problem is with the 2nd query. ID is an integer or a string?
Provide me with all the details and I can help you out

@KAKAN i'll pm u !

[KAKAN]

Any debug info?( did you even try to debug it? )
Anyway, what if the binfo shit doesn't exist?
And too, tell us what's the problem. I think the problem is with the 2nd query. ID is an integer or a string?
Provide me with all the details and I can help you out

@KAKAN i'll pm u !

You PM'ed me the wrong thing. I never wanted the commands and its horrible looking at it. You need to figure out what causes the problem. What makes it not to work. Try adding prints to else(if) statements and see where the problem occurs.

[Slark__]

Any debug info?( did you even try to debug it? )
Anyway, what if the binfo shit doesn't exist?
And too, tell us what's the problem. I think the problem is with the 2nd query. ID is an integer or a string?
Provide me with all the details and I can help you out

@KAKAN i'll pm u !

You PM'ed me the wrong thing. I never wanted the commands and its horrible looking at it. You need to figure out what causes the problem. What makes it not to work. Try adding prints to else(if) statements and see where the problem occurs.

Okay i will check then i will send you ss