SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts > Includes

Reply
 
Thread Tools Display Modes
Old 11/01/2018, 01:55 AM   #81
ThePhenix
Gangsta
 
ThePhenix's Avatar
 
Join Date: May 2012
Posts: 823
Reputation: 157
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Try downloading the latest version.
ThePhenix is offline   Reply With Quote
Old 11/01/2018, 05:35 PM   #82
RowdyrideR
Huge Clucker
 
Join Date: Dec 2010
Posts: 206
Reputation: 11
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

R41-4 Plugin

Code:
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(7) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(21) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(25) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(28) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(30) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(36) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(38) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(40) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(42) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(45) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(47) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(52) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(58) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(63) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(66) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(69) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(71) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(73) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(76) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(78) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(80) : error 075: input line too long (after substitutions)
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(85) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(88) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(90) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(92) : error 010: invalid function or declaration
C:\Games\GTA San Andreas\Server\HTB\V3\pawno\include\easy-mysql.inc(95) : error 010: invalid function or declaration
__________________

Your Rep+'s appreciated.

Scripter, Just PM me.
-----

RowdyrideR is offline   Reply With Quote
Old 11/01/2018, 05:45 PM   #83
ThePhenix
Gangsta
 
ThePhenix's Avatar
 
Join Date: May 2012
Posts: 823
Reputation: 157
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Are you sure you're using the latest version? I mean the errors don't really make sense at all.

Code: https://github.com/ThreeKingz/easy-m...easy-mysql.inc

I don't get any errors when compiling, what code are you using, post it here...
ThePhenix is offline   Reply With Quote
Old 11/01/2018, 06:26 PM   #84
RowdyrideR
Huge Clucker
 
Join Date: Dec 2010
Posts: 206
Reputation: 11
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

im sorry it was a problem with the include itself, i was on my way to remove my comment

Thanks..
__________________

Your Rep+'s appreciated.

Scripter, Just PM me.
-----

RowdyrideR is offline   Reply With Quote
Old 12/05/2018, 06:08 PM   #85
JR_Junior
Huge Clucker
 
Join Date: Nov 2011
Location: Brazil
Posts: 228
Reputation: 54
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

How to make a rank of 10+ accounts with more money from the server with this include?
Thanks!


@EDIT
FOUND: http://forum.sa-mp.com/showpost.php?...3&postcount=57
Thanks!

Last edited by JR_Junior; 12/05/2018 at 06:52 PM.
JR_Junior is offline   Reply With Quote
Old 13/05/2018, 04:24 PM   #86
JR_Junior
Huge Clucker
 
Join Date: Nov 2011
Location: Brazil
Posts: 228
Reputation: 54
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

The following code is not working:
PHP Code:
    new string[128], names[24],money;
    new 
handle SQL::OpenEx(SQL::MREAD"Accounts""Money""""""", -110, -1"Money");
    
SQL::ReadRetrievedRows(handlei)
    {
        
SQL::ReadString(handle"AccountName"names24i);
        
SQL::ReadInt(handle"Money"moneyi);
        
format(stringsizeof(string), "Name %s | Money: %d"names,money);
        
SendClientMessage(playerid, -1string);
    }
    
SQL::Close(handle); 
Accounts in DB: 7

In the Mysql log:
PHP Code:
[13:42:36] [DEBUGmysql_query(1"SELECT * FROM `Accounts` WHERE `Money`='' ORDER BY `Money` DESC LIMIT 10 "1)
[
13:42:36] [DEBUGCHandle::Execute(this=0x4f8c170type=3query=0x6705fd0)
[
13:42:36] [DEBUGCConnection::Execute(query=0x6705fd0this=0x674f80connection=0x4fa5968)
[
13:42:36] [DEBUGCQuery::Execute(this=0x6705fd0connection=0x4fa5968)
[
13:42:36] [INFOquery "SELECT * FROM `Accounts` WHERE `Money`='' ORDER BY `Money` DESC LIMIT 10 " successfully executed within 0.616 milliseconds
[13:42:36] [DEBUGCResultSet::Create(connection=0x4fa5968query_str='SELECT * FROM `Accounts` WHERE `Money`='' ORDER BY `Money` DESC LIMIT 10 ')
[
13:42:36] [DEBUGcreated new resultset '0x6710788'
[13:42:36] [DEBUGfetched MySQL result '0x66f8990'
[13:42:36] [DEBUGallocated 0 bytes for PAWN result
[13:42:36] [DEBUGCHandle::Execute - return valuetrue
[13:42:36] [DEBUGmysql_query: return value'1'
[13:42:36] [DEBUGcache_is_valid(1)
[
13:42:36] [DEBUGcache_is_valid: return value'true'
[13:42:36] [DEBUGcache_get_row_count(0x05FFF1E0)
[
13:42:36] [DEBUGcache_get_row_count: return value'1'
[13:42:36] [DEBUGcache_get_row_count(0x05FFF1D8)
[
13:42:36] [DEBUGcache_get_row_count: return value'1'
[13:42:36] [DEBUGcache_is_valid(1)
[
13:42:36] [DEBUGcache_is_valid: return value'true'
[13:42:36] [DEBUGcache_delete(1)
[
13:42:36] [DEBUGcache_delete: return value'1' 
Tried too: new handle = SQL::Open(SQL::MREAD, "Accounts", "Money", -1, "", -1, "", -1, -1, "Money");

But no data in chat!

Last edited by JR_Junior; 13/05/2018 at 05:20 PM.
JR_Junior is offline   Reply With Quote
Old 13/05/2018, 08:58 PM   #87
Private200
High-roller
 
Private200's Avatar
 
Join Date: May 2012
Posts: 1,225
Reputation: 205
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Even if old, I believe my MySQL include is easier to be understood and used: http://forum.sa-mp.com/showthread.php?t=609990
__________________
Mood: Young, dumb and broke
Young, wild and free

Will return to the SAMP scene soon with the development of a new Trucking gamemode for my own server (which will also be new).
Looking for mappers to help me; PM if interested.
Private200 is offline   Reply With Quote
Old 13/05/2018, 09:00 PM   #88
Max_Andolini
Huge Clucker
 
Max_Andolini's Avatar
 
Join Date: Oct 2013
Posts: 327
Reputation: 37
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Quote:
Originally Posted by Private200 View Post
Even if old, I believe my MySQL include is easier to be understood and used: http://forum.sa-mp.com/showthread.php?t=609990
Go to ur post this include easier all of them.
Max_Andolini is offline   Reply With Quote
Old 13/05/2018, 09:08 PM   #89
Private200
High-roller
 
Private200's Avatar
 
Join Date: May 2012
Posts: 1,225
Reputation: 205
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Quote:
Originally Posted by Max_Andolini View Post
Go to ur post this include easier all of them.
You still got that toxic attitude after years. I am not advertising nor trying to get people to my include; I had totally forgotten I had released it. Try to appreciate other's work if you want yours to get appreciated.. what a mentality.
__________________
Mood: Young, dumb and broke
Young, wild and free

Will return to the SAMP scene soon with the development of a new Trucking gamemode for my own server (which will also be new).
Looking for mappers to help me; PM if interested.
Private200 is offline   Reply With Quote
Old 13/05/2018, 09:36 PM   #90
JR_Junior
Huge Clucker
 
Join Date: Nov 2011
Location: Brazil
Posts: 228
Reputation: 54
Default Re: Easy MySQL - Simplifying the usage of MySQL queries!

Quote:
Originally Posted by Private200 View Post
Even if old, I believe my MySQL include is easier to be understood and used: http://forum.sa-mp.com/showthread.php?t=609990
No offense, but your include is a bit far from being better and easier than that.
JR_Junior 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
[Include] Easy SQLite: Simplyfing the usage of SQLite queries! ThePhenix Includes 7 14/07/2018 10:12 AM
[Include] Easy MySQL 1.0 - Simplifying the usage of MySQL queries! ThePhenix Includes 93 08/01/2017 04:04 AM
[Tutorial] MySQL-queries iRaiDeN Tutorials 2 21/03/2014 03:20 PM
Help with MySQL queries LiamM Scripting Help 4 20/03/2013 10:37 AM


All times are GMT. The time now is 03:30 PM.


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