[Tutorial] Making a MySQL system

[Tutorial] Making a MySQL system - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Tutorials (https://sampforum.blast.hk/forumdisplay.php?fid=70)
+---- Thread: [Tutorial] Making a MySQL system (/showthread.php?tid=159785)

Pages: 1 2 3 4

Re: Making a MySQL system - [HiC]TheKiller - 17.09.2010

Quote:

Originally Posted by Hiddos

Thanks for explaining, but what are mostly the advantages of SQL, when compared to fwrite, if I do NOT use it for anything but saving (No connection with anything different then the server to save player stats).

Thanks in advance ^^

Unless you actually wanted to use it for the online stuff, there isn't much difference. It's probably better than saving to multiple different files at once but if you have 1 file for player stats there isn't much difference.

Re: Making a MySQL system - Brian_Furious - 18.09.2010

This TUT got how to put the accounts into a WebSite CP for users?

Re: Making a MySQL system - [HiC]TheKiller - 21.09.2010

I've fixed all the security issues. I'll make a admin system for MySQL in addition to the first post. Hopefully there will be enough space

Re: Making a MySQL system - andruz99 - 21.09.2010

WoW nice work (Y) Keep on going

Re: Making a MySQL system - Luis- - 21.09.2010

My pawn register aint working?

Re: Making a MySQL system - [HiC]TheKiller - 21.09.2010

What isn't working? It works fine for me

Re: Making a MySQL system - Luis- - 21.09.2010

Quote:

Originally Posted by [HiC]TheKiller

What isn't working? It works fine for me

Well it wokred for me a while ago but now I add it and set my MySQL up to my Webhost and bam it don't work?

Re: Making a MySQL system - Hash [NL-RP] - 08.10.2010

GREAT! I needed to code one of these into my Gamemodes, it a lot easier now, thanks!

Re: Making a MySQL system - recik009 - 13.10.2010

I have a problem... namely when creating database the following error pops up "#1166 - Incorrect column name 'user ' "

Re: Making a MySQL system - recik009 - 13.10.2010

if I want to log in an error pops up:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.379/antystac/www/samp/Logged.php on line 24
That username does not existGo back

Re: Making a MySQL system - [HiC]TheKiller - 16.10.2010

Quote:

Originally Posted by recik009

if I want to log in an error pops up:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.379/antystac/www/samp/Logged.php on line 24
That username does not existGo back

It isn't connecting to the database.

Re: Making a MySQL system - Omecken - 21.02.2011

Works great for me, just some things I need to ask. Lets say I want to add "adminlevel" as a field in the table "playerinfo". Can someone explain to me how I add a this new like "adminlevel" line in the MySQL table "playerinfo"? And how can I configure this in the script easiest?

Re: Making a MySQL system - sijoga - 30.05.2011

Good afternoon, my friend I tried several times without success and this tutorial, I'm do not know if I'm riding the wrong parties, if I'm missing something, just know that does not create or bank account data or the error or any time compiling.
If you have this project in ai format Pawnees, put it, and if possible the files needed to run everything right.
Thanks in advance.

Re: Making a MySQL system - JordanMaddox - 29.07.2011

Thanks a lot, helped me much.

Re: Making a MySQL system - Ricop522 - 21.10.2011

Hi, Could anyone help-me ?
When I try to return to the profile page, I receive the error:

PHP Code:



echo "There was no values for username or password posted!";

The code to return to the page:

PHP Code:





echo "<br /><a href='profile.php'>Back to profile</a>"; //Goes onto

@edi

SOLVED

Re: Making a MySQL system - Storm203 - 21.10.2011

-snip-

I proved myself wrong. I must be slipping. Nothing to see here.

Re: Making a MySQL system - System64 - 22.10.2011

did you put stock MySQL_Login in you script?

Re: Making a MySQL system - Wesley221 - 22.10.2011

... duh
I didnt saw the part that was more down, i just tried to compile it, and thought it was a default function.. Haha
Thanks

Re: Making a MySQL system - JordanMaddox - 26.10.2011

You sat down and took the time to do this?

Re: Making a MySQL system - [HiC]TheKiller - 27.10.2011

Quote:

Originally Posted by JordanMaddox

You sat down and took the time to do this?

Yeah, it took about 5 hours to type up the PAWN part, test it and write the explanation and about 5 hours to do the PHP / HTML part.