Raised This Month: $ Target: $400
 0% 

Hi i need help with MYSQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
kulers2010
Junior Member
Join Date: Oct 2011
Location: Latvia
Old 05-16-2012 , 16:04   Hi i need help with MYSQL
Reply With Quote #1

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.
kulers2010 is offline
Send a message via Skype™ to kulers2010
Liverwiz
Veteran Member
Join Date: Feb 2010
Location: Maryland
Old 05-16-2012 , 16:55   Re: Hi i need help with MYSQL
Reply With Quote #2

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.
Liverwiz is offline
kulers2010
Junior Member
Join Date: Oct 2011
Location: Latvia
Old 05-17-2012 , 06:47   Re: Hi i need help with MYSQL
Reply With Quote #3

Quote:
Originally Posted by Liverwiz View Post
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.
kulers2010 is offline
Send a message via Skype™ to kulers2010
Neeeeeeeeeel.-
Some Guy Yellin'
Join Date: Jul 2010
Location: Argentina
Old 05-16-2012 , 17:23   Re: Hi i need help with MYSQL
Reply With Quote #4

Maybe reading sqlx.inc you could learn.
__________________
Neeeeeeeeeel.- is offline
Send a message via Skype™ to Neeeeeeeeeel.-
Liverwiz
Veteran Member
Join Date: Feb 2010
Location: Maryland
Old 05-16-2012 , 17:32   Re: Hi i need help with MYSQL
Reply With Quote #5

Quote:
Originally Posted by Neeeeeeeeeel.- View Post
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?
Liverwiz is offline
mottzi
Veteran Member
Join Date: May 2010
Location: Switzerland
Old 05-16-2012 , 18:05   Re: Hi i need help with MYSQL
Reply With Quote #6

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.
__________________
Quote:
#define true ((rand() % 2)? true: false) //Happy debugging suckers
mottzi is offline
Send a message via MSN to mottzi
Liverwiz
Veteran Member
Join Date: Feb 2010
Location: Maryland
Old 05-16-2012 , 19:00   Re: Hi i need help with MYSQL
Reply With Quote #7

Quote:
Originally Posted by mottzi View Post
Sqlx is the newer one and supports threaded queries.
*headdesk* it says that in the documentation.
I'm an idiot.
Liverwiz is offline
TRUE RED
Senior Member
Join Date: Mar 2012
Location: Ukraine
Old 05-17-2012 , 07:27   Re: Hi i need help with MYSQL
Reply With Quote #8

check this out ->
http://forums.alliedmods.net/showthread.php?t=146849
TRUE RED is offline
Send a message via ICQ to TRUE RED Send a message via Skype™ to TRUE RED
hornet
AMX Mod X Plugin Approver
Join Date: Mar 2010
Location: Australia
Old 05-17-2012 , 07:41   Re: Hi i need help with MYSQL
Reply With Quote #9

This is good for learning SQLx

http://forums.alliedmods.net/showthread.php?t=46779
__________________
Quote:
vBulletin Tip #42: Not much would be accomplished by merging this item with itself.
hornet is offline
kulers2010
Junior Member
Join Date: Oct 2011
Location: Latvia
Old 05-17-2012 , 13:41   Re: Hi i need help with MYSQL
Reply With Quote #10

Can some one can make, othing more i dont need
kulers2010 is offline
Send a message via Skype™ to kulers2010
Reply



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

Forum Jump


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


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