SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 09/01/2018, 07:58 PM   #31
MrCesar
Huge Clucker
 
MrCesar's Avatar
 
Join Date: Sep 2016
Location: Russia
Posts: 290
Reputation: 1
Default Re: MySQL [R41-2] Registration System

[22:54:09] plugin.mysql: Unloading plugin...
[22:54:09] plugin.mysql: Plugin unloaded.

I get this on the logs once I try to run the server, any idea what's causing it?
MrCesar is offline   Reply With Quote
Old 29/01/2018, 08:42 PM   #32
Flamehaze7
Big Clucker
 
Flamehaze7's Avatar
 
Join Date: Feb 2016
Posts: 132
Reputation: 10
Default Re: MySQL [R41-2] Registration System

does MySQL plugins work on ubuntu too?
Flamehaze7 is offline   Reply With Quote
Old 29/01/2018, 08:59 PM   #33
OptimusBloodHunter
Little Clucker
 
Join Date: Apr 2015
Posts: 18
Reputation: 3
Default Re: MySQL [R41-2] Registration System

Quote:
Originally Posted by Flamehaze7 View Post
does MySQL plugins work on ubuntu too?
Yep, I use plugin for Debian on ubuntu
OptimusBloodHunter is offline   Reply With Quote
Old 13/02/2018, 06:43 PM   #34
RxErT
Huge Clucker
 
Join Date: May 2016
Location: SA:MP Lemon
Posts: 243
Reputation: 12
Default Re: MySQL [R41-2] Registration System

Great and useful tutorial, it definitely helped me out!
RxErT is offline   Reply With Quote
Old 18/02/2018, 09:16 PM   #35
JnniorDoug
Little Clucker
 
Join Date: Mar 2017
Posts: 10
Reputation: 0
Default Re: MySQL [R41-2] Registration System

Something's wrong going on ...
Whenever I make a new registration and I'll log in I do not win the cash, I need to close my game and open it again to earn cash
JnniorDoug is offline   Reply With Quote
Old 21/02/2018, 07:14 PM   #36
insus100
Big Clucker
 
insus100's Avatar
 
Join Date: Jun 2017
Location: Pa k kieres saber eso jaja salud2
Posts: 98
Reputation: 3
Default Re: MySQL [R41-2] Registration System

Quote:
Something's wrong going on ...
Whenever I make a new registration and I'll log in I do not win the cash, I need to close my game and open it again to earn cash
Same happens to me, also when I try to register with another username (ID 2), data will be saved into ID 1, so it's not working properly...

EDIT:
This can be fixed by adding below OnPlayerRegister this:
PHP Code:
forward OnPlayerRegister(playerid);
public 
OnPlayerRegister(playerid)
{
    
// retrieves the ID generated for an AUTO_INCREMENT column by the sent query
    
Player[playerid][ID] = cache_insert_id(); 
__________________

Join Discord!

insus100 is offline   Reply With Quote
Old 07/01/2020, 07:17 PM   #37
Nawickaz
Little Clucker
 
Join Date: Apr 2019
Posts: 23
Reputation: 0
Default Re: MySQL [R41-2] Registration System

Can someone please tell me how to make this system to save player position? BTW very nice tutorial, but somehow this code doesn't save my cash or score when i exit the game.
Nawickaz is offline   Reply With Quote
Old 28/04/2020, 08:27 AM   #38
Opyx
Little Clucker
 
Join Date: Apr 2020
Posts: 6
Reputation: 0
Default Re: MySQL [R41-2] Registration System

Quote:
Originally Posted by insus100 View Post
Same happens to me, also when I try to register with another username (ID 2), data will be saved into ID 1, so it's not working properly...

EDIT:
This can be fixed by adding below OnPlayerRegister this:
PHP Code:
forward OnPlayerRegister(playerid);
public 
OnPlayerRegister(playerid)
{
    
// retrieves the ID generated for an AUTO_INCREMENT column by the sent query
    
Player[playerid][ID] = cache_insert_id(); 
I used it but still same problem happens, I added adminlevel, skin, score, money, kill and deaths to my mode. Skin, score and money should set to 299, 100 and 1000 but doesn't do that, players have to relogin. (I redirect to Login dialog after register, so they must login after register dialog but still same.)

Code:
[11:33:21] [ERROR] cache_set_active: invalid cache id '0'
[11:33:23] [ERROR] cache_set_active: invalid cache id '0'
[11:33:23] [ERROR] cache_get_value_name_int: no active cache
[11:33:23] [ERROR] cache_get_value_name_int: no active cache
[11:33:23] [ERROR] cache_get_value_name_int: no active cache
[11:33:23] [ERROR] cache_get_value_name_int: no active cache
[11:33:23] [ERROR] cache_get_value_name_int: no active cache
[11:33:23] [ERROR] cache_get_value_name_int: no active cache
[11:33:23] [ERROR] cache_delete: invalid cache id '0'
As you can see, cache doesn't be active, i don't know why.
Opyx is offline   Reply With Quote
Old 12/05/2020, 09:05 AM   #39
JasonTheMan
Big Clucker
 
JasonTheMan's Avatar
 
Join Date: Apr 2020
Posts: 55
Reputation: 2
Default Re: MySQL [R41-2] Registration System

Nice tutorial
__________________
Owner/Founder - DesignUX
New Project - RedWood High
JasonTheMan is offline   Reply With Quote
Old 09/06/2020, 05:01 PM   #40
TheOliver
Big Clucker
 
Join Date: Apr 2020
Posts: 88
Reputation: 0
Default Re: MySQL [R41-2] Registration System

and where I download the mysql.dll because I only get the .so
TheOliver 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
Simple MySQL registration system ? sampkinq Scripting Help 2 01/07/2016 07:40 PM
[HELP] Problem with MySQL Registration system dudu.r.oliveira Scripting Help 6 14/06/2015 05:05 AM
[Tutorial] [VIDEO] MySQL ORM r38: How to pair GM with MySQL & creation of registration/connection system cArnasLT Tutorials 3 19/05/2014 02:08 PM
[FilterScript] Advanced registration system (MySQL) iRaiDeN Filterscripts 19 05/05/2014 10:46 AM
[MySQL] Advanced Registration System Carlton Filterscripts 52 11/04/2014 07:23 AM


All times are GMT. The time now is 05:45 PM.


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