AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Hi i need help with MYSQL (https://forums.alliedmods.net/showthread.php?t=185391)

kulers2010 05-16-2012 16:04

Hi i need help with MYSQL
 
Hi, don't know how to make amxx plugin with mysql connection

Firstly i need only in plugin
amx_givexp
amx_takexp
say /xp (and then shows player xp who is connected)

xp save in datubase(mysql)

on disconect(save xp)
on player spawn(save xp)

Nothing more i dont need.

Tnx who ll make. Sorry if my lang is bad.

Liverwiz 05-16-2012 16:55

Re: Hi i need help with MYSQL
 
http://www.1keydata.com/sql/sqlcreate.html
http://www.w3schools.com/sql/sql_insert.asp

The victories are won by yourself. That page got me through -most- of my SQL classes. Go forth, learn.

Neeeeeeeeeel.- 05-16-2012 17:23

Re: Hi i need help with MYSQL
 
Maybe reading sqlx.inc you could learn.

Liverwiz 05-16-2012 17:32

Re: Hi i need help with MYSQL
 
Quote:

Originally Posted by Neeeeeeeeeel.- (Post 1710241)
Maybe reading sqlx.inc you could learn.

in reguards to sqlx.....I'm writing a plugin that stores data. I went with nVault simply because it was retard easy. But i also looked at SQL and SQLx. What's the functional difference?

mottzi 05-16-2012 18:05

Re: Hi i need help with MYSQL
 
Sqlx is the newer one and supports threaded queries.
Quote:

The differences between DBI and SQLX:
Queries are "prepared" before being run.
Connection info is cached in a block called a "tuple."
Result iteration is more intuitive than dbi_nextrow.
You can optionally thread queries.

Liverwiz 05-16-2012 19:00

Re: Hi i need help with MYSQL
 
Quote:

Originally Posted by mottzi (Post 1710274)
Sqlx is the newer one and supports threaded queries.

*headdesk* it says that in the documentation.
I'm an idiot.

kulers2010 05-17-2012 06:47

Re: Hi i need help with MYSQL
 
Quote:

Originally Posted by Liverwiz (Post 1710210)
http://www.1keydata.com/sql/sqlcreate.html
http://www.w3schools.com/sql/sql_insert.asp

The victories are won by yourself. That page got me through -most- of my SQL classes. Go forth, learn.

I mean mysql in plugin not in web, mysql commands i know becouse i programm php websites.

TRUE RED 05-17-2012 07:27

Re: Hi i need help with MYSQL
 
check this out ->
http://forums.alliedmods.net/showthread.php?t=146849

hornet 05-17-2012 07:41

Re: Hi i need help with MYSQL
 
This is good for learning SQLx

http://forums.alliedmods.net/showthread.php?t=46779

kulers2010 05-17-2012 13:41

Re: Hi i need help with MYSQL
 
Can some one can make, othing more i dont need


All times are GMT -4. The time now is 00:23.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.