MySQL VS INI? - Printable Version

MySQL VS INI? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL VS INI? (/showthread.php?tid=419372)

MySQL VS INI? - Nathan_Taylor - 28.02.2013

So, I am expierenced in web development, PHP, MySQL, CSS, JS, all that. The question I had was if MySQL just uses normal comammands like "mysql_connect();" and "mysql_fetch_assoc" blah blah...

In php, I would do the following (after connected to DB)

PHP Code:



<?php

 $info = mysql_query("SELECT * FROM users WHERE username = '$username'");

 $row = mysql_fetch_assoc($info);

 $money = $row['money'];

 $loc = $row['loc'];

?>

ETC. and then just set those variables to the player, but obviously it is different in PAWN. Is it a lot different or kinda similar? Cause I would love to use that instead cause then I could write my own UCP.

Re: MySQL VS INI? - Vince - 28.02.2013

It's similar, but you can't use mysql_fetch_assoc in Pawn, for Pawn doesn't support dynamic array sizes, or named keys for that matter (enums being disregarded). Either you use the cache functions or you fetch the entire row and split it with something like sscanf.

Re: MySQL VS INI? - Nathan_Taylor - 28.02.2013

Quote:

Originally Posted by Vince

It's similar, but you can't use mysql_fetch_assoc in Pawn, for Pawn doesn't support dynamic array sizes, or named keys for that matter (enums being disregarded). Either you use the cache functions or you fetch the entire row and split it with something like sscanf.

Can you just write a small code that fetches, say, the amount of money in the %username%'s row and displaying it? Then I can use that as a refrence. Assuming that MySQL is already connected, and the table name is players

Re: MySQL VS INI? - Vince - 28.02.2013

This is for BlueG's plugin, R7 and above:

pawn Code:

// Somewhere
new
    mysqlquery[80];

format(mysqlquery, sizeof(mysqlquery), "SELECT id, money FROM players WHERE name = '%s'", playername);
mysql_function_query(1, mysqlquery, true, "OnPlayerDataLoad", "d", playerid);

// Somewhere else
forward OnPlayerDataLoad(playerid);
public OnPlayerDataLoad(playerid)
{
    new
        rows,
        fields;

    cache_get_data(1, rows, fields);

    if(rows)
    {
        new temp[12];
        cache_get_row(0, 0, temp); PlayerInfo[playerid][pSQLID] = strval(temp);
        cache_get_row(0, 1, temp); PlayerInfo[playerid][pMoney] = strval(temp);
    }
    return;
}

Re: MySQL VS INI? - Nathan_Taylor - 28.02.2013

[[delete]]

Re: MySQL VS INI? - Nathan_Taylor - 28.02.2013

Quote:

Originally Posted by Vince

This is for BlueG's plugin, R7 and above:

pawn Code:

// Somewhere
new
    mysqlquery[80];

format(mysqlquery, sizeof(mysqlquery), "SELECT id, money FROM players WHERE name = '%s'", playername);
mysql_function_query(1, mysqlquery, true, "OnPlayerDataLoad", "d", playerid);

// Somewhere else
forward OnPlayerDataLoad(playerid);
public OnPlayerDataLoad(playerid)
{
    new
        rows,
        fields;

    cache_get_data(1, rows, fields);

    if(rows)
    {
        new temp[12];
        cache_get_row(0, 0, temp); PlayerInfo[playerid][pSQLID] = strval(temp);
        cache_get_row(0, 1, temp); PlayerInfo[playerid][pMoney] = strval(temp);
    }
    return;
}

And how do I connect? I have the following in OnGameModeInit()

pawn Code:

mysql_debug(ENABLE_DEBUGGING);
g_ConnectionHandle = mysql_connect("host", "user", "database", "password"); //with my real info of course

and the sample gamemode shows them using "g_ConnectionHandle" infront of every query, EX: (from sample GM)

pawn Code:

new szPlayerIP[16], iNumIP, szQuery[128];
GetPlayerIp(playerid, szPlayerIP, sizeof(szPlayerIP));
iNumIP = IpToInteger(szPlayerIP);
mysql_format(g_ConnectionHandle, szQuery, "SELECT `country_code`, `country_name` FROM `ip2c` WHERE \"%d\" BETWEEN `begin_ip_num` AND `end_ip_num` LIMIT 1", iNumIP);
mysql_function_query(g_ConnectionHandle, szQuery, true, "onCountryDetect", "ds", playerid, szPlayerIP);

See how they use "g_ConnectionHandle" infront of the queries? Is that just the "mysqlquery" you used?

Re: MySQL VS INI? - Yves - 28.02.2013

i think sql is just shit all together plus BlueGs messed my script up -_-

Re: MySQL VS INI? - Djole1337 - 28.02.2013

Quote:

Originally Posted by Yves

i think sql is just shit all together plus BlueGs messed my script up -_-

No, I think you don't use it properly.

Re: MySQL VS INI? - Nathan_Taylor - 28.02.2013

Quote:

Originally Posted by Mr_DjolE

No, I think you don't use it properly.

How do you connect to the DB using his script? I can't find it out.

Re: MySQL VS INI? - Djole1337 - 28.02.2013

Quote:

Originally Posted by Nathan_Taylor

How do you connect to the DB using his script? I can't find it out.

pawn Code:

new
    connection;

Under ongamemodeinit()

connection = mysql_connect("localhost", "root", "samp", "");