[RP][James,]First Command Release! Crack/Drinking Command![RP]

[Al-Santoro]

Information:
Well, just to inform you, I'm new to C# and I've decided to try out the commands and such, and I've been learning a bit.. And these are the first two commands I made. ;] Hopefully everyone would like it..

Drinking Command!

#region :drinking
                    case "drinking":
                       {
                           using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
                            {
                             
                                dbClient.runQuery("UPDATE users SET health = health - '20' WHERE name = '" + _Username + "'");
                                dbClient.runQuery("UPDATE users SET credits = credits - '0' WHERE name = '" + _Username + "'");
                                Room.sendSaying(roomUser, "*Opens a can of beer, and starts talking randomly, being drunk*");
                                Room.sendSaying(roomUser, "*I... *Hic* I'm in the ultimate flying form!!*");
                                Room.sendSaying(roomUser, "Heyyyyy!! *Hic* I... like..... beerrrrrrrrr!!");
                                Room.sendSaying(roomUser, "*Stops drinking their beer, and still feels cautious*");
                                _Mission = "[Drunk] Be Cautious of this User!";
                                refreshAppearance(false, true, true);
                                sendData("BK" + "You are now drunk!");
                            }
                        }
                        break;
                    #endregion

Crack Command

 #region :crack
                    case "crack":
                        {
                            using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
                            {
                                dbClient.runQuery("UPDATE users SET health = health = - '25' WHERE name = '" + _Username + "'");
                                dbClient.runQuery("UPDATE users SET credits = credits = - '0' WHERE name = '" + _Username + "'");
                                Room.sendSaying(roomUser, "*Pulls out their cigar and puts their crack in it*");
                                Room.sendSaying(roomUser, "*Starts lighting up their cigar and starts smoking*");
                                Room.sendSaying(roomUser, "*Starts getting high from smoking and loses 25 HP!*");
                                sendData("BK" + "Aye Mr. Al Capone, you just lost 25 HP and you're high!");
                                _Mission = "[High]This user is high, but be careful, it's worse than you know!";
                                refreshAppearance(false, true, true);
                            }
                        }
                        break;
                    #endregion

C# Code Release Command: v0.1 -- Small Release; Coded from scratch! ;D

More Information:
And I would recommend adding a cooldown to this, otherwise they'll spam the whole room and such.. And tbh, I never worked on making a cooldown for this, since I'm not that advanced to erm, you know... add it in and such.. >_>

Credits:
Al-Santoro - For making both commands.
Live-Jam - For fixing my Drinking command. (Made a slight error).

[mod] Thread moved to Habbo Releases - Ki. [/mod]

 

[X1M!]

Nice! I like them, but I'd recommend altering the drinking command to only work when they are holding a drink. So gonna use this idea..

 

[Kieren]

Nice release! a little to easy to be coded thanks for sharing! hope to see more from you!

 

[Al-Santoro]

Thanks for the comments, and yeh, I'll still continuing my coding journey and such, Lolz. ;D

 

[Dayron1234]

Just to fix up your coding here.....

#region :drinking
case "drinking":
{
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{

dbClient.runQuery("UPDATE users SET health = health - '20' WHERE name = '" + _Username + "'");
dbClient.runQuery("UPDATE users SET credits = credits - '0' WHERE name = '" + _Username + "'");
Room.sendSaying(roomUser, "*Opens a can of beer, and starts talking randomly, being drunk*");
Room.sendSaying(roomUser, "*I... *Hic* I'm in the ultimate flying form!!*");
Room.sendSaying(roomUser, "Heyyyyy!! *Hic* I... like..... beerrrrrrrrr!!");
Room.sendSaying(roomUser, "*Stops drinking their beer, and still feels cautious*");
_Mission = "[Drunk] Be Cautious of this User!";
refreshAppearance(false, true, true);
sendData("BK" + "You are now drunk!");
}
}
break;
#endregion

region :crack
case "crack":
{
using (DatabaseClient dbClient = Eucalypt.dbManager.GetClient())
{
dbClient.runQuery("UPDATE users SET health = health - '25' WHERE name = '" + _Username + "'");
dbClient.runQuery("UPDATE users SET credits = credits - '0' WHERE name = '" + _Username + "'");
Room.sendSaying(roomUser, "*Pulls out their cigar and puts their crack in it*");
Room.sendSaying(roomUser, "*Starts lighting up their cigar and starts smoking*");
Room.sendSaying(roomUser, "*Starts getting high from smoking and loses 25 HP!*");
sendData("BK" + "Aye Mr. Al Capone, you just lost 25 HP and you're high!");
_Mission = "[High]This user is high, but be careful, it's worse than you know!";
refreshAppearance(false, true, true);
}
}
break;
#endregion

I saw that you had mission where the credits where suppose to be at for example

dbClient.runQuery("UPDATE users SET mission = credits = - '0' WHERE name = '" + _Username + "'");

Is suppose to be this

dbClient.runQuery("UPDATE users SET credits = credits - '0' WHERE name = '" + _Username + "'");

Other then that good job for someone that is learning C# and did this from scratch

 

[Al-Santoro]

Thanks. ;] I'll still continue to work on more commands. Hopefully my C# skills will improve. ;]

 

[Dayron1234]

Np glad to see someone want's to learn C#

 

[Al-Santoro]

Yeh, I find C# very interesting tbh. ;] That's why I decided to learn it, and plus, it could make RPs become more exciting.

 

[Kyle-Santoro]

Nice i guess ill release mine aswell

#region :die
case "die"
{
using (DatabaseClient dbClient=Eucalypt.db.Manager.GetClient () )
{
dbclient.runQuery ("UPDATE user SET health = health - '100' WHERE name = ''' + username + '''''') ;
Room.sendSaying (roomUser, ''*takes a knife out and slits their throat!*");
Room.sendSaying (roomUser, "*falls to the floor in a pile of their blood*");
Room.sendSaying (roomUser, "*is now dead*");
sendData("BK" + "You have now committed suicide you crazy fool!");
_Mission = [Suicide] Dead
refreshAppearance (false, true, true) ;
}
}
break;

Credits:
Kyle-Santoro for making the command
Al-Santoro for helping me figure a few things out & teaching me the basics.

 

[Al-Santoro]

#region :die
case "die": //Edited by James. [Al-Santoro].
{
using (DatabaseClient dbClient = Eucalypt.db.Manager.GetClient())
{
dbclient.runQuery ("UPDATE user SET health = health - '100' WHERE name = '''  + _username + "'") ;
Room.sendSaying (roomUser, ''*takes a knife out and slits their throat!*");
Room.sendSaying (roomUser, "*falls to the floor in a pile of their blood*");
Room.sendSaying (roomUser, "*is now dead*");
sendData("BK" + "You have now committed suicide you crazy fool!");
_Mission = "[Suicide] Dead";
refreshAppearance (false, true, true) ;
}
}
break;

You made some errors on the command. I'll fix it for you. ;D Also, I didn't check the whole command, so I suggest you use C# to find them for you. ;]

 

[Kyle-Santoro]

U might have made it but this is my version coded myself and ty for the error fixes.

 

[Sledmore]

You err, Should add some sleeps, So it doesn't come out all at the same time instantly.. Such as..

EXAMPLE;
this.Room.sendSaying(roomUser, "lolol testing");
this.Sleep(1000);
this.Room.sendSaying(roomUser, "lolol testing again");

I may of made errors, But I did this quick and fast at school + No longer code. . - Nice release.

 

[Al-Santoro]

Thanks for the comment and the update Craig. ;] And I will update the code. ;D