SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 10/03/2017, 12:46 PM   #21
Eoussama
High-roller
 
Eoussama's Avatar
 
Join Date: Jul 2016
Location: Kingdom of Morocco // Tangier
Posts: 1,121
Reputation: 153
Default Re: MySQL [R41-2] Registration System

Thanks, I had quite the fun reading this, useful, brief and knowledge-expanding, +REP for your hard work,
__________________
Eoussama is online now   Reply With Quote
Old 10/03/2017, 05:57 PM   #22
Variable™
Gangsta
 
Join Date: Jul 2015
Location: Fort Carson
Posts: 643
Reputation: 109
Default Re: MySQL [R41-2] Registration System

Thanks for your opinion.
Variable™ is offline   Reply With Quote
Old 13/07/2017, 02:26 AM   #23
SteSte
Big Clucker
 
SteSte's Avatar
 
Join Date: Aug 2015
Location: United States
Posts: 190
Reputation: 20
Default Re: MySQL [R41-2] Registration System

*BUMP

I've been looking for a R42-3 tutorial, the last tutorial I followed gave me errors, is this compatible with 42-3?
__________________
Interested in scripting creative and unique scripts? PM me here.
SKYPE: Heroleo911003
Discord: Ste-Ste#7377
I prefer Discord at the moment, skype works to.
I'm currently working on a survival script where players have real scripted powers.
SteSte is offline   Reply With Quote
Old 26/07/2017, 07:18 PM   #24
valerastar
Little Clucker
 
valerastar's Avatar
 
Join Date: Aug 2015
Location: Moldova, Republic of
Posts: 34
Reputation: 0
Default Re: MySQL [R41-2] Registration System

Help please :c
It can't connect so MySQL Server. IDK what to do.
MySQL plugin version R41-3
Log by Log-plugin v0.4
Quote:
[21:04:18] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[21:04:19] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[21:04:20] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
[21:04:21] [ERROR] CConnection::CConnection - establishing connection to MySQL database failed: #2013 'Lost connection to MySQL server at 'reading authorization packet', system error: 10060'
EDIT: Anyway...found some1 with same problem on the forum. Only suggestion was - downgrade on version MySQL R41-2. Now works.

Last edited by valerastar; 26/07/2017 at 08:15 PM.
valerastar is offline   Reply With Quote
Old 02/12/2017, 04:48 PM   #25
Uberanwar
Gangsta
 
Join Date: May 2012
Location: Malaysia
Posts: 774
Reputation: 59
Default Re: MySQL [R41-2] Registration System

Hi guys, I have some issues on this.

In my script, I make new tables for a database. It seems that I get this error, ** [MySQL]: Unknown column 'fDivision' in 'field list'. If I were to fix that, I'd just delete my existing database, and start up the server, and all the tables that were newly added in the script will be created by itself. But what if I have my players account in that database? How can I make that it would create by itself in the existing database (the newly added tables) upon server execution?
Uberanwar is offline   Reply With Quote
Old 02/12/2017, 04:53 PM   #26
AjaxM
Big Clucker
 
AjaxM's Avatar
 
Join Date: May 2016
Posts: 142
Reputation: 16
Default Re: MySQL [R41-2] Registration System

Quote:
Originally Posted by Uberanwar View Post
Hi guys, I have some issues on this.

In my script, I make new tables for a database. It seems that I get this error, ** [MySQL]: Unknown column 'fDivision' in 'field list'. If I were to fix that, I'd just delete my existing database, and start up the server, and all the tables that were newly added in the script will be created by itself. But what if I have my players account in that database? How can I make that it would create by itself in the existing database (the newly added tables) upon server execution?
Just add another field from your phpMyadmin.
__________________

CALL OF DUTY: GHOSTS - Website | Forum
AjaxM is offline   Reply With Quote
Old 02/12/2017, 05:06 PM   #27
Uberanwar
Gangsta
 
Join Date: May 2012
Location: Malaysia
Posts: 774
Reputation: 59
Default Re: MySQL [R41-2] Registration System

Quote:
Originally Posted by AjaxM View Post
Just add another field from your phpMyadmin.
What if there are a lot of tables added in the script in many different structures? It would be an headache to do that manually I think. If it's not a lot then it would be alright for me to do that manually otherwise
Uberanwar is offline   Reply With Quote
Old 02/12/2017, 06:00 PM   #28
AjaxM
Big Clucker
 
AjaxM's Avatar
 
Join Date: May 2016
Posts: 142
Reputation: 16
Default Re: MySQL [R41-2] Registration System

Quote:
Originally Posted by Uberanwar View Post
What if there are a lot of tables added in the script in many different structures? It would be an headache to do that manually I think. If it's not a lot then it would be alright for me to do that manually otherwise
Both is not a headache. It is easy to add a field to an existing table or to add a new table.
__________________

CALL OF DUTY: GHOSTS - Website | Forum
AjaxM is offline   Reply With Quote
Old 02/12/2017, 08:41 PM   #29
maddinat0r
Gangsta
 
maddinat0r's Avatar
 
Join Date: Jun 2010
Location: Germany
Posts: 883
Reputation: 460
Default Re: MySQL [R41-2] Registration System

So I was bored and looked through the code, and somehow thought that I already saw that code somewhere. Then I remembered: this looks a lot like the example login script from the plugin repository! (https://github.com/pBlueG/SA-MP-MySQ...stem-cache.pwn)
After quickly comparing those scripts: this IS the same code from the example script, with the difference of different variable names and reformulated code comments.
Konstantinos originally wrote this (and an ORM counterpart) script on 26. August 2016.
maddinat0r 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 08:40 PM
[HELP] Problem with MySQL Registration system dudu.r.oliveira Scripting Help 6 14/06/2015 06:05 AM
[Tutorial] [VIDEO] MySQL ORM r38: How to pair GM with MySQL & creation of registration/connection system cArnasLT Tutorials 3 19/05/2014 03:08 PM
[FilterScript] Advanced registration system (MySQL) iRaiDeN Filterscripts 19 05/05/2014 11:46 AM
[MySQL] Advanced Registration System Carlton Filterscripts 52 11/04/2014 08:23 AM


All times are GMT. The time now is 07:58 PM.


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