Raised This Month: $ Target: $400
 0% 

How to get data from mysql?


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
jonatat
Senior Member
Join Date: Dec 2017
Old 07-08-2018 , 12:53   How to get data from mysql?
Reply With Quote #1

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!
jonatat is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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