[Tutorial] Making a MySQL system
#21

Quote:
Originally Posted by Hiddos
View Post
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.
Reply
#22

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

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 .
Reply
#24

WoW nice work (Y) Keep on going
Reply
#25

My pawn register aint working?
Reply
#26

What isn't working? It works fine for me .
Reply
#27

Quote:
Originally Posted by [HiC]TheKiller
View Post
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?
Reply
#28

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

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

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
Reply
#31

Quote:
Originally Posted by recik009
View Post
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.
Reply
#32

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?
Reply
#33

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.
Reply
#34

Thanks a lot, helped me much.
Reply
#35

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
Reply
#36

-snip-

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

did you put stock MySQL_Login in you script?
Reply
#38

... 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
Reply
#39

You sat down and took the time to do this?
Reply
#40

Quote:
Originally Posted by JordanMaddox
View Post
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.
Reply


Forum Jump:


Users browsing this thread: 5 Guest(s)