Burgershot
  • Home
  • Members
  • Team
  • Help
  • Search
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Burgershot SA-MP Pawn Scripting [Pawn] Sending message to all owner of key (from SQL)

 
  • 0 Vote(s) - 0 Average
Pawn Sending message to all owner of key (from SQL)
Axitz
Offline

Burgershot Member
Posts: 24
Threads: 11
Joined: Apr 2021
Reputation: 0
Location: Malaysia
#1
2021-04-16, 10:46 PM
Hi,

How do I make something like sending message to all key's holder from sql function?

example like :

PHP Code:
mysql_format(sqldata, pQuery, sizeof pQuery, "SELECT doorkey FROM `bizkeys` WHERE bizid = %d;", bizid);
new 
Cache:result = mysql_query(sqldata, pQuery);

then 

sendclientmsg to all holder of 
"doorkey" from bizid = %d. 

or something.
Radical
Offline

Burgershot Member
Posts: 148
Threads: 21
Joined: Dec 2020
Reputation: 16
#2
2021-04-17, 09:46 AM (This post was last modified: 2021-04-17, 09:54 AM by Radical.)
Code:
mysql_format(sqldata, pQuery, sizeof pQuery, "SELECT holdername, doorkey FROM `bizkeys` WHERE bizid = %d;", bizid);
new Cache:result = mysql_query(sqldata, pQuery);
new rows = cache_num_rows();
if (rows) {
    new name[24];
    for (new i; i < rows; i++) {
        cache_get_value_name(i, "holdername", name);
        foreach(new p : Player) if (!strcmp(GetName(p), name, true)) {
            SendClientMessage(p, ...);
            break;
        }
    }
    cache_delete(result);
}
You have to save the player name in the holdername field.
« Next Oldest | Next Newest »



  • View a Printable Version
  • Subscribe to this thread
Forum Jump:

© Burgershot - Powered by our Community and MyBB Original Theme by Emerald

Linear Mode
Threaded Mode