[DarkMythHunter]

Quote:

Originally Posted by serqq Okay, I'm assuming that you are using newest version of MySQL plugin and you have created connection to your database. To start off, let's define our dialog id: Код: #define DIALOG_ID_REFERRAL_CHECK 2137 Then we need to put our dialog into OnPlayerConnect(or anywhere where you want it). Код: public OnPlayerConnect(playerid) { ShowPlayerDialog(playerid, DIALOG_ID_REFERRAL_CHECK, DIALOG_STYLE_INPUT,"Referral system", "If someone invited you to this server, input his name below", "OK", "Cancel"); //your code here } Next, let's handle the dialog response. Код: public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { switch(dialogid) { case DIALOG_ID_REFERRAL_CHECK: { if(!response) { //here you can put code that will execute when player clicks "Cancel" - the right button; return 1; } else { //you can add if's checking if user input is empty etc. new Query[128]; mysql_format(YOUR_MYSQL_HANDLE, Query, sizeof Query,"SELECT * FROM `table_name` WHERE `Username` = '%e'", inputtext); mysql_tquery(YOUR_MYSQL_HANDLE, Query, "OnReferralNameCheck", playerid, inputtext); } } } } Don't forget to replace YOUR_MYSQL_HANDLE with handle that you're using to connect to your database and `table_name` with your table name! And to end this simple script, create function that checks if that name is valid, and if it is add 1 to `Referrals` column. Код: forward OnReferralNameCheck(playerid, const name[]); public OnReferralNameCheck(playerid, const name[]) { if(cache_num_rows()) { //user has put right name new Query[128]; mysql_format(YOUR_MYSQL_HANDLE, Query, sizeof Query,"UPDATE `table_name` SET `Referrals` = `Referrals` + 1 WHERE `Username` = '%e'", name); mysql_tquery(YOUR_MYSQL_HANDLE, Query); } else { //user has put wrong name SendClientMessage(playerid, -1, "This user doesn't exist!"); ShowPlayerDialog(playerid, DIALOG_ID_REFERRAL_CHECK, DIALOG_STYLE_INPUT,"Referral system", "If someone invited you here, input his name below", "OK", "Cancel"); } cache_unset_active(); }

Edited some stuffs to match my gamemode, thanks a lot, it works fine!