Raised This Month: $32 Target: $400
 8% 

[Tut] MySql - Save/Load/Usefull Things (Xp Mod)


Post New Thread Reply   
 
Thread Tools Display Modes
Kia
AlliedModders Donor
Join Date: Apr 2010
Location: In a world of madness
Old 05-12-2011 , 10:08   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #71

I tried to connect with a External Database Checker, it says it works.
And no there isn't any table.
Kia is offline
grimvh2
Veteran Member
Join Date: Nov 2007
Location: Fishdot Nation
Old 05-17-2011 , 14:10   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #72

ddo amx_modules to see if all ur modules are running correctly
__________________
I am out of order!
grimvh2 is offline
EpicMonkey
buttmonkey
Join Date: Feb 2012
Old 06-05-2012 , 04:07   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #73

whats with the szname
PHP Code:
public Save_MySql(id)
{
    new 
szSteamId[32], szName[32], szTemp[512]
    
get_user_authid(idszSteamIdcharsmax(szSteamId))
    
    
// Here we will update the user hes information in the database where the steamid matches.
    
format(szTemp,charsmax(szTemp),"UPDATE `tutorial` SET `exp` = '%i' WHERE `tutorial`.`steamid` = '%s';",iExp[id], szSteamId)
    
SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp)

your not using it...
EpicMonkey is offline
quark
Veteran Member
Join Date: Oct 2011
Location: Your mind.
Old 06-11-2012 , 17:05   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #74

This is supposed to be to save playername in-game. But he doesn't used it :]
__________________

Check out My Plugins:
qServerInfo ; ASKTAG
quark is offline
EpicMonkey
buttmonkey
Join Date: Feb 2012
Old 06-12-2012 , 02:12   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #75

Quote:
Originally Posted by quark View Post
This is supposed to be to save playername in-game. But he doesn't used it :]
thats exactly what am pointing out
EpicMonkey is offline
yamin
BANNED
Join Date: Jan 2012
Location: Sharjah
Old 06-16-2012 , 08:03   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #76

good job
yamin is offline
V I R U S
Senior Member
Join Date: Jul 2004
Location: Russia / Germany
Old 09-18-2012 , 20:12   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #77

Thanks for the great tut, but there is still a leak in whole AMXX SQL system.

For a day, i've noticed my website fallig down with an error "TOO MANY CONNECTIONS". No problem to raise up the number of connections for MySQL server, but i've noticed that every one CStrike + AMXX gameservers, makes over 8 SQL connections.

Somehow, that suxx. Mby there is some way to create only one connection to database and use that one for every plugin?
__________________
V I R U S is offline
Send a message via ICQ to V I R U S
Alka
AMX Mod X Plugin Approver
Join Date: Dec 2006
Location: malloc(null)
Old 09-19-2012 , 07:50   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #78

Quote:
Originally Posted by V I R U S View Post
Thanks for the great tut, but there is still a leak in whole AMXX SQL system.

For a day, i've noticed my website fallig down with an error "TOO MANY CONNECTIONS". No problem to raise up the number of connections for MySQL server, but i've noticed that every one CStrike + AMXX gameservers, makes over 8 SQL connections.

Somehow, that suxx. Mby there is some way to create only one connection to database and use that one for every plugin?
The only thing that i can think now, it's to register a native and call it every time when you want to insert/retrieve some data into/from a DB. If a connection it's already active, wait to finish then close it and reopen a new one.
__________________
Still...lovin' . Connor noob! Hello

Last edited by Alka; 09-19-2012 at 07:51.
Alka is offline
4444leozinho
Member
Join Date: May 2012
Old 09-24-2012 , 16:00   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #79

I was wondering how do to put a function for admin to load the information from the steam that he enter.
4444leozinho is offline
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 07-29-2014 , 13:00   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #80

forget it
__________________

Last edited by skz; 07-29-2014 at 13:26.
skz is offline
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

Forum Jump


All times are GMT -4. The time now is 04:48.


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