SA-MP Forums

Go Back   SA-MP Forums > Members List

Slice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 pointsSlice Reputation above 1000 points

Slice Slice is offline

High-roller

Visitor Messages

Showing Visitor Messages 1 to 10 of 552
  1. Glossy42O
    24/05/2015 07:35 AM
    Glossy42O
    Kak dela slice? pashol nahui ti yobaney syka <3
  2. Ahmad45123
    21/05/2015 08:56 PM
    Ahmad45123
    Why did you discontinue the boilerplate project ? :/
    Was looking forward to use it once its fully completed.

    If you can atleast update it for SAMP 0.3.7, Would be very appreciated.
  3. Kyla
    19/05/2015 12:56 PM
    Kyla
    slice make a century by adding me to friend list :P
  4. Patrick
    13/05/2015 05:44 PM
    Patrick
    Code:
    hook OnGameModeInit()
    {	
    	db_query(database, "CREATE TABLE IF NOT EXISTS "ACCOUNTS_TABLE" ("PLY_USERNAME" TEXT, "PLY_PASSWORD" TEXT, "PLY_KILLS" INT, "PLY_DEATHS" INT, "PLY_ADMINLVL" INT)");
    
    	stmt_account_exists = db_prepare(database, "SELECT "PLY_USERNAME" FROM "ACCOUNTS_TABLE" WHERE "PLY_USERNAME" =?");
    }
    
    CheckAccount(playerid)
    {
    	stmt_bind_result_field(stmt_account_exists, 0, DB::TYPE_PLAYER_NAME, playerid);
    
    	
    
    	if(stmt_execute(stmt_account_exists))
    	{
    		SendClientMessage(playerid, -1, "registered");
    	}
    	else
    	{
    		SendClientMessage(playerid, -1, "not registered");
    
    		/*Testing out*/
    		db_query(database, "INSERT INTO "ACCOUNTS_TABLE" ("PLY_USERNAME", "PLY_PASSWORD", "PLY_KILLS", "PLY_DEATHS", "PLY_ADMINLVL") VALUES ('pds2k12', 'asd123', 200, 0, 5)");
    	}
    	stmt_close(stmt_account_exists);
    
    }
  5. Patrick
    13/05/2015 05:12 PM
    Patrick
    The error comes from when I connect the server, which is from CheckAccount function that I'm trying to create.

    Code:
    [18:16:37] [join] pds2k12 has joined the server (0:192.168.1.4)
    [18:16:37] SQLitei Debug: (stmt_bind_result_field:0) Bound result field 0 (type 8) to variable 0x000C8854.
    [18:16:37] SQLitei Error: (stmt_execute) Uninitialized parameter in statement (0).
    [18:16:37] SQLitei Debug: (db_query) Running query: INSERT INTO accounts (Username, Password, Kills, Deaths, ALevel) VALUES ('pds2k12', 'mi2mwf22', 200, 0, 5)
    [18:16:37] SQLitei Debug: (db_autofree_result) Will autofree 0x01224118.
    [18:16:37] SQLitei Debug: (stmt_close:0) Closed statement.
    [18:16:37] SQLitei Debug: (db_drain_autofree_pool) Autofreeing 0x01224118
    [18:16:37] SQLitei Debug: (db_free_result) Freeing 0x01224118.
    [18:16:42] [part] pds2k12 has left the server (0:1)
  6. Patrick
    12/05/2015 09:49 PM
    Patrick
    Any solution to my problem by the way? I still can't think of any things that caused the problem. I can use db_query easily but I want to try to use prepared statement as its more handy.
  7. adri1
    09/05/2015 01:18 PM
    adri1
    ┐la gente esta muy loca?
  8. Ralfie
    02/05/2015 04:03 PM
    Ralfie
    Will you be updating SKY for the official 0.3.7?
  9. RaeF
    01/05/2015 11:03 PM
    RaeF
    Ok, thanks ..!
  10. dugi
    01/05/2015 10:35 AM
    dugi
    Yeah it seems to be only happening on CrazyBobs cnr no other server reported this, script issue it seems.

About Me

  • About Slice
    Location
    Sweden
  • Signature
    Do you want to script with me? High-end TDM server. Contact me.

Statistics

Total Posts
Visitor Messages
General Information
  • Last Activity: 25/05/2015 07:13 AM
  • Join Date: 08/03/2008

Friends

Showing Friends 1 to 10 of 99

All times are GMT. The time now is 01:19 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.