SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 29/06/2020, 10:21 AM   #1
makemoneynotfriends
Big Clucker
 
Join Date: Jan 2020
Location: Egypt
Posts: 103
Reputation: 3
Default mysql not saving

PHP Code:
[12:16:24] [DEBUGmysql_format(10xF193281C250"SELECT `Password` FROM `Users` WHERE `Username` = '%e' LIMIT 1")
[
12:16:24] [DEBUGCHandle::EscapeString(this=0x82fbf28src='Trevor')
[
12:16:24] [DEBUGCConnection::EscapeString(src='Trevor'this=0x82ffeb0connection=0x84d1970)
[
12:16:24] [DEBUGCHandle::EscapeString - return valuetrueescaped string'Trevor'
[12:16:24] [DEBUGmysql_format: return value'66'
[12:16:24] [DEBUGmysql_tquery(1"SELECT `Password` FROM `Users` WHERE `Username` = 'Trevor' LIMIT 1""OnAccountCheck""i")
[
12:16:24] [DEBUGCCallback::Create(amx=0x82bf610name='OnAccountCheck'format='i'params=0xf1932744param_offset=5)
[
12:16:24] [DEBUGCCallback::Create callback index for 'OnAccountCheck'12
[12:16:24] [DEBUGprocessing specifier 'i' with parameter index 0
[12:16:24] [DEBUGretrieved and pushed value '0'
[12:16:24] [INFOCallback 'OnAccountCheck' set up for delayed execution.
[
12:16:24] [DEBUGcreated delayed callback with 1 parameter
[12:16:24] [DEBUGCHandle::Execute(this=0x82fbf28type=1query=0x84a49a4)
[
12:16:24] [DEBUGCHandle::Execute - return valuetrue
[12:16:24] [DEBUGmysql_tquery: return value'1'
[12:16:24] [DEBUGmysql_tquery(1"SELECT `Password` FROM `Users` WHERE `Username` = 'Trevor' LIMIT 1""OnBanCheck""i")
[
12:16:24] [DEBUGCConnection::Execute(query=0x84a49a4this=0xf0c57008connection=0x84e9ee0)
[
12:16:24] [DEBUGCCallback::Create(amx=0x82bf610name='OnBanCheck'format='i'params=0xf1932744param_offset=5)
[
12:16:24] [DEBUGCQuery::Execute(this=0x84a49a4connection=0x84e9ee0)
[
12:16:24] [DEBUGCCallback::Create callback index for 'OnBanCheck': -10004
[12:16:24] [DEBUGprocessing specifier 'i' with parameter index 0
[12:16:24] [DEBUGretrieved and pushed value '0'
[12:16:24] [INFOCallback 'OnBanCheck' set up for delayed execution.
[
12:16:24] [DEBUGcreated delayed callback with 1 parameter
[12:16:24] [DEBUGCHandle::Execute(this=0x82fbf28type=1query=0x84a50cc)
[
12:16:24] [DEBUGCHandle::Execute - return valuetrue
[12:16:24] [DEBUGmysql_tquery: return value'1'
[12:16:24] [INFOquery "SELECT `Password` FROM `Users` WHERE `Username` = 'Trevor' LIMIT 1" successfully executed within 0.456 milliseconds
[12:16:24] [DEBUGCResultSet::Create(connection=0x84e9ee0query_str='SELECT `Password` FROM `Users` WHERE `Username` = 'Trevor' LIMIT 1')
[
12:16:24] [DEBUGcreated new resultset '0xf02005e0'
[12:16:24] [DEBUGfetched MySQL result '0xf0200790'
[12:16:24] [DEBUGallocated 0 bytes for PAWN result
[12:16:24] [DEBUGCConnection::Execute(query=0x84a50ccthis=0xf0c57008connection=0x84e9ee0)
[
12:16:24] [DEBUGCQuery::Execute(this=0x84a50ccconnection=0x84e9ee0)
[
12:16:24] [INFOquery "SELECT `Password` FROM `Users` WHERE `Username` = 'Trevor' LIMIT 1" successfully executed within 1.14 milliseconds
[12:16:24] [DEBUGCResultSet::Create(connection=0x84e9ee0query_str='SELECT `Password` FROM `Users` WHERE `Username` = 'Trevor' LIMIT 1')
[
12:16:24] [DEBUGcreated new resultset '0xf0200620'
[12:16:24] [DEBUGfetched MySQL result '0xf0200cc8'
[12:16:24] [DEBUGallocated 0 bytes for PAWN result
[12:16:24] [DEBUGCCallback::Execute(amx=0x82bf610index=12num_params=1)
[
12:16:24] [INFOExecuting callback 'OnAccountCheck' with 1 parameter...
[
12:16:24] [DEBUGprocessing internal specifier 'c'
[12:16:24] [DEBUGpushed value '0' onto AMX stack
[12:16:24] [DEBUGexecuting AMX callback with index '12'
[12:16:24] [DEBUGcache_get_row_count(0xF1932ED4)
[
12:16:24] [DEBUGcache_get_row_count: return value'1'
[12:16:24] [DEBUGAMX callback executed with error '0'
[12:16:24] [INFOCallback successfully executed.
[
12:16:24] [DEBUGCCallback::Execute(amx=0x82bf610index=-10004num_params=1)
[
12:16:24] [INFOExecuting callback '@5' with 1 parameter...
[
12:16:24] [DEBUGprocessing internal specifier 'c'
[12:16:24] [DEBUGpushed value '0' onto AMX stack
[12:16:24] [DEBUGexecuting AMX callback with index '-10004'
[12:16:24] [DEBUGAMX callback executed with error '0'
[12:16:24] [INFOCallback successfully executed.
[
12:16:31] [DEBUGmysql_format(10xF1932AD0250"INSERT INTO `Users` (Username, Password) VALUES ('%e', '%e')")
[
12:16:31] [DEBUGCHandle::EscapeString(this=0x82fbf28src='Trevor')
[
12:16:31] [DEBUGCConnection::EscapeString(src='Trevor'this=0x82ffeb0connection=0x84d1970)
[
12:16:31] [DEBUGCHandle::EscapeString - return valuetrueescaped string'Trevor'
[12:16:31] [DEBUGCHandle::EscapeString(this=0x82fbf28src='test123')
[
12:16:31] [DEBUGCConnection::EscapeString(src='test123'this=0x82ffeb0connection=0x84d1970)
[
12:16:31] [DEBUGCHandle::EscapeString - return valuetrueescaped string'test123'
[12:16:31] [DEBUGmysql_format: return value'70'
[12:16:31] [DEBUGmysql_tquery(1"INSERT INTO `Users` (Username, Password) VALUES ('Trevor', 'test123')""OnAccountRegister""i")
[
12:16:31] [DEBUGCCallback::Create(amx=0x82bf610name='OnAccountRegister'format='i'params=0xf1932ab8param_offset=5)
[
12:16:31] [DEBUGCCallback::Create callback index for 'OnAccountRegister'14
[12:16:31] [DEBUGprocessing specifier 'i' with parameter index 0
[12:16:31] [DEBUGretrieved and pushed value '0'
[12:16:31] [INFOCallback 'OnAccountRegister' set up for delayed execution.
[
12:16:31] [DEBUGcreated delayed callback with 1 parameter
[12:16:31] [DEBUGCHandle::Execute(this=0x82fbf28type=1query=0x84a4bb4)
[
12:16:31] [DEBUGCHandle::Execute - return valuetrue
[12:16:31] [DEBUGmysql_tquery: return value'1'
[12:16:31] [DEBUGCConnection::Execute(query=0x84a4bb4this=0xf0c57008connection=0x84e9ee0)
[
12:16:31] [DEBUGCQuery::Execute(this=0x84a4bb4connection=0x84e9ee0)
[
12:16:31] [INFOquery "INSERT INTO `Users` (Username, Password) VALUES ('Trevor', 'ziadziad')" successfully executed within 27.73 milliseconds
[12:16:31] [DEBUGCResultSet::Create(connection=0x84e9ee0query_str='INSERT INTO `Users` (Username, Password) VALUES ('Trevor', 'test')')
[
12:16:31] [DEBUGcreated new resultset '0xf02005e0'
[12:16:31] [DEBUGfetched MySQL result '0x0'
[12:16:31] [DEBUGCCallback::Execute(amx=0x82bf610index=14num_params=1)
[
12:16:31] [INFOExecuting callback 'OnAccountRegister' with 1 parameter...
[
12:16:31] [DEBUGprocessing internal specifier 'c'
[12:16:31] [DEBUGpushed value '0' onto AMX stack
[12:16:31] [DEBUGexecuting AMX callback with index '14'
[12:16:31] [DEBUGAMX callback executed with error '0'
[12:16:31] [INFOCallback successfully executed.
[
12:17:03] [DEBUGmysql_format(10xF1931BF01026"UPDATE `Users` SET `pWeap1` = '%i', `pAmmo1` = '%i', `pWeap2` = '%i', `pAmmo2` = '%i', `pWeap3` = '%i', `pAmmo3` = '%i', `pWeap4` = '%i', `pAmmo4` = '%i', `pWeap5` = '%i', `pAmmo5` = '%i', `pWeap6` = '%i', `pAmmo6` = '%i', `pWeap7` = '%i', `pAmmo7` = '%i', `pWeap8` = '%i', `pAmmo8` = '%i', `pWeap9` = '%i', `pAmmo9` = '%i', `playerUsd` = '%d', `Weed` = '%d', `Cocain` = '%d', `Mines` = '%d', `Teargas` = '%d', `Rp` = '%d', `Money` = '%i', `playerHelper` = '%d', `MentalState` = '%d', `playerPremium` = '%d', `playerAdmin` = '%d', `playerKills` = '%d', `playerDeaths` = '%d', `x` = '%f', `y` = '%f', `z` = '%f' WHERE `Username` = '%e'")
[
12:17:03] [DEBUGCHandle::EscapeString(this=0x82fbf28src='A*UĂ')
[
12:17:03] [DEBUGCConnection::EscapeString(src='A*UĂ'this=0x82ffeb0connection=0x84d1970)
[
12:17:03] [DEBUGCHandle::EscapeString - return valuetrueescaped string'A*UĂ'
[12:17:03] [DEBUGmysql_format: return value'634'
[12:17:03] [DEBUGmysql_tquery(1"UPDATE `Users` SET `pWeap1` = '0', `pAmmo1` = '0', `pWeap2` = '0', `pAmmo2` = '0', `pWeap3` = '0', `pAmmo3` = '0', `pWeap4` = '0', `pAmmo4` = '0', `pWeap5` = '0', `pAmmo5` = '0', `pWeap6` = '0', `pAmmo6` = '0', `pWeap7` = '0', `pAmmo7` = '0', `pWeap8` = '0', `pAmmo8` = '0', `pWeap9` = '0', `pAmmo9` = '0', `playerUsd` = '0', `Weed` = '0', `Cocain` = '0', `Mines` = '0', `Teargas` = '0', `Rp` = '0', `Money` = '0', `playerHelper` = '10000', `MentalState` = '0', `playerPremium` = '0', `playerAdmin` = '0', `playerKills` = '0', `playerDeaths` = '0', `x` = '0.000000', `y` = '2032.947021', `z` = '-1432.192139' WHERE `Username` = 'A*UĂ'""""")
[
12:17:03] [DEBUGCCallback::Create(amx=0x82bf610name=''format=''params=0xf1931bdcparam_offset=5)
[
12:17:03] [DEBUGCHandle::Execute(this=0x82fbf28type=1query=0x84a49bc)
[
12:17:03] [DEBUGCHandle::Execute - return valuetrue
[12:17:03] [DEBUGmysql_tquery: return value'1'
[12:17:03] [DEBUGCConnection::Execute(query=0x84a49bcthis=0xf0c57008connection=0x84e9ee0)
[
12:17:03] [DEBUGCQuery::Execute(this=0x84a49bcconnection=0x84e9ee0)
[
12:17:03] [INFOquery "UPDATE `Users` SET `pWeap1` = '0', `pAmmo1` = '0', `pWeap2` = '0', `pAmmo2` = '0', `pWeap3` = '0', `pAmmo3` = '0', `pWeap4` = '0', `pAmmo4` = '0', `pWeap5` = '0', `pAmmo5` = '0', `pWeap6` = '0', `pAmmo6` = '0', `pWeap7` = '0', `pAmmo7` = '0', `pWeap8` = '0', `pAmmo8` = '0', `pWeap9` = '0', `pAmmo9` = '0', `playerUsd` = '0', `Weed` = '0', `Cocain` = '0', `Mines` = '0', `Teargas` = '0', `Rp` = '0', `Money` = '0', `playerHelper` = '10000', `MentalState` = '0', `playerPremium` = '0', `playerAdmin` = '0', `playerKills` = '0', `playerDeaths` = '0', `x` = '0.000000', `y` = '2032.947021', `z` = '-1432.192139' WHERE `Username` = 'A*UĂ'" successfully executed within 0.438 milliseconds
[12:17:03] [DEBUGCResultSet::Create(connection=0x84e9ee0query_str='UPDATE `Users` SET `pWeap1` = '0', `pAmmo1` = '0', `pWeap2` = '0', `pAmmo2` = '0', `pWeap3` = '0', `pAmmo3` = '0', `pWeap4` = '0', `pAmmo4` = '0', `pWeap5` = '0', `pAmmo5` = '0', `pWeap6` = '0', `pAmmo6` = '0', `pWeap7` = '0', `pAmmo7` = '0', `pWeap8` = '0', `pAmmo8` = '0', `pWeap9` = '0', `pAmmo9` = '0', `playerUsd` = '0', `Weed` = '0', `Cocain` = '0', `Mines` = '0', `Teargas` = '0', `Rp` = '0', `Money` = '0', `playerHelper` = '10000', `MentalState` = '0', `playerPremium` = '0', `playerAdmin` = '0', `playerKills` = '0', `playerDeaths` = '0', `x` = '0.000000', `y` = '2032.947021', `z` = '-1432.192139' WHERE `Username` = 'A*'')
[
12:17:03] [DEBUGcreated new resultset '0xf02010d0'
[12:17:03] [DEBUGfetched MySQL result '0x0' 
thats what i found in the mysql.log mysql is fine tablet creating, saving accounts password+name
makemoneynotfriends is online now   Reply With Quote
Old 29/06/2020, 10:53 AM   #2
xRadical3
Gangsta
 
xRadical3's Avatar
 
Join Date: May 2017
Location: Iran
Posts: 565
Reputation: 20
Default Re: mysql not saving

Explain more about your problem.
xRadical3 is offline   Reply With Quote
Old 29/06/2020, 11:13 AM   #3
Banditul18
Huge Clucker
 
Join Date: Nov 2014
Location: Brasov,Romania
Posts: 405
Reputation: 32
Default Re: mysql not saving

That looks like you have the option to log everything for the mysql. Nothing wrong there
Banditul18 is offline   Reply With Quote
Old 29/06/2020, 02:29 PM   #4
makemoneynotfriends
Big Clucker
 
Join Date: Jan 2020
Location: Egypt
Posts: 103
Reputation: 3
Default Re: mysql not saving

stats dont save just account saving with password
makemoneynotfriends is online now   Reply With Quote
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
[MYSQL]-HARDCODING - Loading , Saving The player name from mysql PURG3D Scripting Help 8 06/09/2016 08:12 AM
Converting MYSQL Saving Codes into .INI Saving System codes ???? PURG3D Scripting Help 6 14/04/2015 10:49 PM
MySQL saving system to DJSON saving system TonyNames Scripting Help 4 21/01/2014 06:27 PM
saving system mysql(not mysql problem) martoivanov Scripting Help 0 29/08/2013 03:37 PM
MYSQL Saving Jstylezzz Scripting Help 3 15/04/2012 06:25 PM


All times are GMT. The time now is 04:22 AM.


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