You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Query_sql to check if the players is online
- Thread starter tmav94
- Start date
Dastgir
Core Developer
- Messages
- 3,805
- Points
- 0
- Discord
- Dastgir#1460
- IRC Nickname
- Dastgir
- Github
- dastgirp
- Emulator
- Client Version
- 2019-02-28 RE
why use query_sql
you can use this method
you can use this method
Code:
.@acc_id = charid2rid(.@char_id);if (!.@acc_id){ debugmes "Char not online"; end;}//DO anything with .@char_id and .@acc_id here.(Character is Online)This method is new for me...
query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE `char`.online=1")
and:
if(isloggedin(getcharid(3)))
They do the samething?
Look this other two:why use query_sql
you can use this method
.@acc_id = charid2rid(.@char_id);if (!.@acc_id){ debugmes "Char not online"; end;}//DO anything with .@char_id and .@acc_id here.(Character is Online)
query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE `char`.online=1")
and:
if(isloggedin(getcharid(3)))
They do the samething?
Dastgir
Core Developer
- Messages
- 3,805
- Points
- 0
- Discord
- Dastgir#1460
- IRC Nickname
- Dastgir
- Github
- dastgirp
- Emulator
- Client Version
- 2019-02-28 RE
No.This method is new for me...
Look this other two:why use query_sql
you can use this method
.@acc_id = charid2rid(.@char_id);if (!.@acc_id){ debugmes "Char not online"; end;}//DO anything with .@char_id and .@acc_id here.(Character is Online)
query_sql("SELECT login.account_id FROM login LEFT JOIN `char` ON login.account_id=`char`.account_id WHERE `char`.online=1")
and:
if(isloggedin(getcharid(3)))
They do the samething?
getcharid(3)
Means character is attached.
you can do something like
query_sql "SELECT `account_id` FROM `char` WHERE `char_id`='"+ .@char_id +"' AND `online`=1",.@acc_id;if (!.@acc_id){//CHARACTER IS OFFLINEend;}//CHARACTER IS ONLINE
but I recommend you to use charid2rid, as its efficient as compared to executing Queries.