[Phoenix] Superwired SQL question.

[Maestrom]

FIXED!

Thank you

[MentaL]

[SuklaaVene]

You can only run sql commands in sama database that emulator use. If you want do that just PM me and i do some code :)

[Maestrom]

You can only run sql commands in sama database that emulator use. If you want do that just PM me and i do some code :)

Wow, what an answer? If I add a new table to my current USERS table called Welcome, how am I able to get there a 1 when the wired is triggerd?

-Maestrom

[The General]

You can actually by using parameters.

Here this is the 'API':

---: Super Wired :---

All Super Wired commands are no longer case-sensitive
New Super Wired Variables (usable across all Super Wired items)
- #USERNAME# will show the targets username
- #USERID# will show the users ID (useful in conjunction with the SQL effect)
- #ROOMNAME# will show the current rooms name
- #ROOMID# will show the current rooms ID
- #ONLINECOUNT# will now display the current number of online players
- #ROOMSLOADED# will now display the current number of loaded rooms

wf_act_give_phx RANK command fixed (was previously ranking entire hotel, oops!)
wf_act_give_phx Maximum value of CREDITS given now 2,147,483,647
wf_act_give_phx Maximum value of PIXELS given now 2,147,483,647
wf_act_give_phx Maximum value of POINTS given now 2,147,483,647
wf_act_give_phx EFFECT now inserts the effect into the users inventory & activates it, if possible
wf_act_give_phx BADGE will now refresh the users badges instantly
wf_act_give_phx can now make a user dance (danceANCEID)
wf_act_give_phx can now give users Respect (respectSmile
wf_act_give_phx can now give a user handitems (handitem:ITEMID)
wf_act_give_phx can now send a user an alert (alert:MESSAGE)
wf_act_give_phx AWARD will now give you the next level of an achievement rather than only level 1


wf_cnd_phx can now check whether a user is in groupid (userisingroup:groupid)
wf_cnd_phx can now check whether a users favourite group is groupid (usergroupeq:groupid)
wf_cnd_phx can now check if a user is wearing a specific item, including colours (wearing:clothing)
wf_cnd_phx can now check if a user is not wearing a specific item, including colours (notwearing:clothing)
wf_cnd_phx can now check if a user is holding a specific handitem (carrying:handitem)
wf_cnd_phx can now check if a user is not holding a specific handitem (notcarrying:handitem)

---: Super Wired Variables API :---

#USERNAME# - will show the targets username
#USERID# - will show the users ID (useful in conjunction with the SQL effect)
#ROOMNAME# - will show the current rooms name
#ROOMID# - will show the current rooms ID
#ONLINECOUNT# - will now display the current number of online players
#ROOMSLOADED# - will now display the current number of loaded rooms

---: Super Wired Effects API :---

sql:QUERY
badge:BADGE
effect:EFFECTID
award:ACHIEVEMENTID
send:ROOMID
credits:AMOUNT
pixels:AMOUNT
points:AMOUNT
rank:RANKID
dance:DANCEID
respect:
handitem:ITEMID
alert:MESSAGE

---: Super Wired Conditions API :---

userhasachievement:ID
userhasntachievement:ID
userhasbadge:BADGE
userhasntbadge:BADGE
userhasvip:
userhasntvip:
userhaseffect:EFFECTID
userhasnteffect:EFFECTID
roomuserseq:COUNT
roomuserslt:COUNT
roomusersmt:COUNT
roomuserslte:COUNT
roomusersmte:COUNT
userrankeq:RANKID
userranklt:RANKID
userranklte:RANKID
userrankmt:RANKID
userrankmte:RANKID
usercreditseq:CREDITS
usercreditslt:CREDITS
usercreditslte:CREDITS
usercreditsmt:CREDITS
usercreditsmte:CREDITS
userpixelseq:PIXELS
userpixelslt:PIXELS
userpixelslte:PIXELS
userpixelsmt:PIXELS
userpixelsmte:PIXELS
userpointseq:POINTS
userpointslt:POINTS
userpointslte:POINTS
userpointsmt:POINTS
userpointsmte:POINTS
userisingroup:GROUPID
usergroupeq:GROUPID
wearing:CLOTHING
notwearing:CLOTHING
carrying:HANDITEM
notcarrying:HANDITEM

[Maestrom]

You can actually by using parameters.

Here this is the 'API':

Thank you General, but I already have this list.
I still have no idea what to put in, in the SuperWired are you able to write me the SQL To let it add a 1 in my database in some table if you please.

-Maestrom

[Tyrex]

sql:UPDATE users SET Welcome = 1 WHERE id = #USERID#

If it doesn't work,what is the type of the Welcome column (varchar, int ...) ?

[Maestrom]

sql:UPDATE users SET Welcome = 1 WHERE id = #USERID#

If it doesn't work,what is the type of the Welcome column (varchar, int ...) ?

Thank you I will check it out

[The General]

Above might cause a syntax error. Try this:

sql:UPDATE users SET Welcome = '1' WHERE id = #USERID#

[Maestrom]

sql:UPDATE users SET Welcome = 1 WHERE id = #USERID#

If it doesn't work,what is the type of the Welcome column (varchar, int ...) ?

Thank you, it works!
I will PM you for the donation.

-Maestrom

[The General]

Thank you, it works!
I will PM you for the donation.

-Maestrom

Lol what. You're wasting your money on such a small thing? Donate your money to a good cause instead please.