help changing from SQL to y_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: help changing from SQL to y_ini (/showthread.php?tid=300208)
+- 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: help changing from SQL to y_ini (/showthread.php?tid=300208)
help changing from SQLite to y_ini (+Rep) - English-Conceptz - 29.11.2011
so this script currently uses sq and it isnt working and i dont no anything about that type of saving id prefer to use y_ini to save, ive tried myself but i got a bunch of indexing errors and more when i following ******'s and smits tutorials. how can i convert this so when i assign a VIP level to a player it saves on disconnect. so when they log back in a i dont have to re-assign it. id like it saved in a folder VIP/%.ini
will give rep for help!
code:
PHP код:
CMD:vsetvip( playerid, params[ ] )
{
new giveplayerid, level;
new string[ 128 ], Query[ 256 ], DBResult:Resultat;
if ( !IsPlayerAdmin( playerid ) ) return SendClientMessage( playerid, RED, "Only RCON Administrator can use this command!" );
if ( sscanf( params, "ud", giveplayerid, level ) ) return SendClientMessage( playerid, RED, "USAGE: {FFFF00}/setvip [playerid] [level]" );
if ( giveplayerid == INVALID_PLAYER_ID ) return SendClientMessage( playerid, RED, "Player Is Not Connected!" );
if ( level > 3 ) return SendClientMessage( playerid, RED, "Maximum V.I.P level is 3!" );
if ( level == 0 )
{
P_DATA[ giveplayerid ][ Vip ] = level;
format( Query, sizeof( Query ), "DELETE FROM `Vips` WHERE `Nume` = '%s'" , PlayerName2( giveplayerid ) );
db_free_result( db_query( Database, Query ) );
format( string, sizeof( string ), "Administrator %s has deleted you V.I.P account!", PlayerName2( playerid ) );
return SendClientMessage( giveplayerid, ABLUE, string );
}
format( Query, sizeof( Query ), "SELECT * FROM `Vips` WHERE `Nume` = '%s'", PlayerName2( playerid ) );
Resultat = db_query( Database, Query );
if ( !db_num_rows( Resultat ) )
{
P_DATA[ giveplayerid ][ Vip ] = level;
format( string, sizeof( string ), "Administrator %s has set your V.I.P level to %d!", PlayerName2( playerid ), level );
SendClientMessage( giveplayerid, ABLUE, string );
format( Query, sizeof( Query ), "INSERT INTO `Vips` VALUES('%s','%d','%d')", PlayerName2( giveplayerid ), level, -1 );
db_free_result( db_query( Database, Query ) );
} else {
P_DATA[ giveplayerid ][ Vip ] = level;
format( string, sizeof( string ), "Administrator %s has set update your V.I.P level to %d!", PlayerName2( playerid ), level );
SendClientMessage( giveplayerid, ABLUE, string );
format( Query, sizeof( Query ), "UPDATE `Vips` SET `VipLevel` = '%d' WHERE `Nume` = '%s'", level, PlayerName2( giveplayerid ) );
db_free_result( db_query( Database, Query ) );
}
return 1;
}
Re: help changing from SQL to y_ini - Scenario - 29.11.2011
You are mistaken. That script is using SQLite, not MySQL.
It really isn't worth changing unless you (for some odd reason) need to use a strictly file-based system.Just read up on using SQLite on the SA:MP Wikipedia and you'll find that it's mostly pretty simple.
Re: help changing from SQL to y_ini - English-Conceptz - 29.11.2011
Quote:
|
Originally Posted by RealCop228
 You are mistaken. That script is using SQLite, not MySQL.
|