AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   How to get data from mysql? (https://forums.alliedmods.net/showthread.php?t=308942)

jonatat 07-08-2018 12:53

How to get data from mysql?
 
I got menu like that:

PHP Code:

public cmdMenu(this)
{
showMenu1(this);
}

showMenu1(thisiPage 0)
{
new 
rgPlayers[32], szPlayerName[32], szPlayerId[3], iPlayersCountpevPlayer;

new 
hMenu menu_create("Players in server stats""menu1");

get_players(rgPlayersiPlayersCount"ch");

for (new 
0iPlayersCounti++)
{
pevPlayer rgPlayers[i];

get_user_name(pevPlayerszPlayerNamecharsmax(szPlayerName));
num_to_str(pevPlayerszPlayerIdcharsmax(szPlayerId));

menu_additem(hMenuszPlayerNameszPlayerId);
}

if (!
menu_items(hMenu))
{
return;
}

menu_display(thishMenuiPage);
}

public 
menu1(thishMenuiItem)
{
if (
iItem == MENU_EXIT)
{
menu_destroy(hMenu);
return 
PLUGIN_HANDLED;
}

new 
bitsAccessiCallbackszPlayerId[3];

menu_item_getinfo(hMenuiItembitsAccessszPlayerIdcharsmax(szPlayerId), __iCallback);
menu_destroy(hMenu);

new 
pevPlayer str_to_num(szPlayerId);

if (!
is_user_connected(pevPlayer))
{
showMenu1(thisiItem 7);
return 
PLUGIN_HANDLED;
}

showMenu2(thispevPlayer);
return 
PLUGIN_HANDLED;
}

showMenu2(thispevPlayer)
{

new 
szBuffer[64], szPlayerName[32], szPlayerSteamid[32], PlayerSteamID[32], Username[32];

get_user_name(pevPlayerszPlayerNamecharsmax(szPlayerName));
get_user_authid(pevPlayerszPlayerSteamidcharsmax(szPlayerSteamid));

formatex(szBuffercharsmax(szBuffer), "Player %s stats"szPlayerName);

formatex(PlayerSteamIDcharsmax(PlayerSteamID), "STEAMID: %s"szPlayerSteamid);
formatex(Usernamecharsmax(Username), "Username: %s"Username);

new 
hMenu menu_create(szBuffer"menu2");

menu_addtext2(hMenuPlayerSteamID);
menu_addtext2(hMenuUsername);

menu_display(thishMenu0);

}

public 
menu2(thishMenuiItem)
{
menu_destroy(hMenu);
return 
PLUGIN_HANDLED;


Can somebody make this menu to take from mysql some data? Example: I got users table mysql, and users table have username table row. I need to take out username. Example:

STEAM ID: STEAM_0:0:546
Username: <Username from mysql>

Thanks for all!

fysiks 07-08-2018 15:02

Re: How to get data from mysql?
 
Check out the tutorials for SQL. Try to do it on your own and if you have issues, post your new code.


All times are GMT -4. The time now is 12:20.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.