Raised This Month: $ Target: $400
 0% 

How to get data from mysql?


Post New Thread Reply   
 
Thread Tools Display Modes
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
fysiks
Veteran Member
Join Date: Sep 2007
Location: Flatland, USA
Old 07-08-2018 , 15:02   Re: How to get data from mysql?
Reply With Quote #2

Check out the tutorials for SQL. Try to do it on your own and if you have issues, post your new code.
__________________

Last edited by fysiks; 07-08-2018 at 15:02.
fysiks is offline
Reply


Thread Tools
Display Modes

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