SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 08/02/2017, 04:28 PM   #1
Barnwell
Banned
 
Join Date: May 2014
Location: England
Posts: 551
Reputation: 40
Default MySQL Problem ( switching from the old version to the new version R-39)

MySQL Problem ( switching from the old version to the new version R-39)
I made register system in 2013 so its very old
The problem
I dont want to use MySQL R5 i want to use MySQL R-39

pawn Code:
//Native functions

#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
#define mysql_next_row() mysql_retrieve_row()
#define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)

native mysql_affected_rows(connectionHandle = 1);
native mysql_close(connectionHandle = 1);
native mysql_connect(const host[],const user[],const database[],const password[]);
native mysql_debug(enable = 1);
native mysql_errno(connectionHandle = 1);
native mysql_fetch_int(connectionHandle = 1);
native mysql_fetch_field(number,dest[],connectionHandle = 1);
native mysql_fetch_field_row(string[],const fieldname[],connectionHandle = 1);
native mysql_fetch_float(&Float:result,connectionHandle = 1);
native mysql_fetch_row_format(string[],const delimiter[] = "|",connectionHandle = 1);
native mysql_field_count(connectionHandle = 1);
native mysql_free_result(connectionHandle = 1);
native mysql_get_charset(destination[],connectionHandle = 1);
native mysql_insert_id(connectionHandle = 1);
native mysql_num_rows(connectionHandle = 1);
native mysql_num_fields(connectionHandle = 1);
native mysql_ping(connectionHandle = 1);
native mysql_query(query[],resultid = (-1),extraid = (-1),connectionHandle = 1);
native mysql_query_callback(index,query[],callback[],extraid = (-1),connectionHandle = 1);
native mysql_real_escape_string(const source[],destination[],connectionHandle = 1);
native mysql_reconnect(connectionHandle = 1);
native mysql_reload(connectionHandle = 1);
native mysql_retrieve_row(connectionHandle = 1);
native mysql_set_charset(charset[],connectionHandle = 1);
native mysql_stat(const destination[],connectionHandle = 1);
native mysql_store_result(connectionHandle = 1);
native mysql_warning_count(connectionHandle = 1);
I need someone to replace this function from R5 to R39
+ REP
Barnwell is offline   Reply With Quote
Old 08/02/2017, 05:18 PM   #2
Barnwell
Banned
 
Join Date: May 2014
Location: England
Posts: 551
Reputation: 40
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

pawn Code:
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(138) : error 017: undefined symbol "mysql_store_result"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(139) : error 017: undefined symbol "mysql_fetch_row_format"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(141) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(145) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(147) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(148) : error 006: must be assigned to an array
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(149) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(152) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(154) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(156) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(158) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(160) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(162) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(164) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(166) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(168) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(170) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(172) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(174) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(176) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(179) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(181) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(182) : error 006: must be assigned to an array
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(183) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(185) : error 017: undefined symbol "mysql_fetch_field_row"
C:\Users\rehab\Desktop\True Roleplay\TRP.pwn(186) : error 017: undefined symbol "pPayday"

Compilation aborted.Pawn compiler 3.2.3664          Copyright (c) 1997-2006, ITB CompuPhase


26 Errors.

Im using MySQL R39
Barnwell is offline   Reply With Quote
Old 08/02/2017, 05:23 PM   #3
princejeet1510
Big Clucker
 
princejeet1510's Avatar
 
Join Date: Mar 2016
Location: Trying to figure it out.
Posts: 115
Reputation: 4
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

Are you using correct version??
PS: try to recompile it and maybe Download that version.
__________________
princejeet1510 is offline   Reply With Quote
Old 08/02/2017, 06:10 PM   #4
Barnwell
Banned
 
Join Date: May 2014
Location: England
Posts: 551
Reputation: 40
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

I need to switch from R5 to R-39
like replace the functions.
Barnwell is offline   Reply With Quote
Old 08/02/2017, 06:55 PM   #5
Barnwell
Banned
 
Join Date: May 2014
Location: England
Posts: 551
Reputation: 40
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

ANYONE HELP!
Barnwell is offline   Reply With Quote
Old 08/02/2017, 07:00 PM   #6
Sew_Sumi
Banned
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 6,268
Reputation: 525
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

You made this, and yet you need help to "fix" it?

You obviously need to update your code to cope with the newer methods...
Sew_Sumi is offline   Reply With Quote
Old 08/02/2017, 07:01 PM   #7
Barnwell
Banned
 
Join Date: May 2014
Location: England
Posts: 551
Reputation: 40
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

Anyone reply here I need to replace functions from R5- R39
mysql_fetch_field_row What is the change of this row on MySQL R39?
Barnwell is offline   Reply With Quote
Old 08/02/2017, 07:37 PM   #8
Barnwell
Banned
 
Join Date: May 2014
Location: England
Posts: 551
Reputation: 40
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

anyone help?
Barnwell is offline   Reply With Quote
Old 08/02/2017, 07:41 PM   #9
Sew_Sumi
Banned
 
Join Date: Jun 2008
Location: Azerbaijan
Posts: 6,268
Reputation: 525
Default Re: MySQL Problem ( switching from the old version to the new version R-39)

Stop bumping your topic... 24 hour bumps only.

If you made it, then you should be able to update it to the latest functions, as that's your issue.
Sew_Sumi is offline   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
[GameMode] [GM] - [RnD] Street Racers `N Drifters (New Version - latest version) Johny_Rocker Gamemode Scripts 23 10/12/2015 10:53 AM
mysql_num_rows problem with mysql 2.1.1 version FasTLinE Scripting Help 2 13/04/2015 12:57 PM
Problem mysql for Las Venturas Cops and Robbers version emtec Server Support 2 21/08/2011 12:53 AM


All times are GMT. The time now is 10:42 AM.


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