Raised This Month: $344 Target: $400
 86%   Almost there!

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


Post New Thread Reply   
 
Thread Tools Display Modes
Jhob94
AMX Mod X Donor
Join Date: Jul 2012
Location: Portugal
Old 02-11-2015 , 05:24   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #111

Quote:
Originally Posted by frOOgy View Post
Can you fix the code and make to show hours and minuts online, not just minutes ?

And can you say me for what we need this part of the code:

PHP Code:
new Host[]     = "hostname" 
new User[]    = "username" 
new Pass[]     = "password" 
new Db[]     = "database" 
thxx for replay bro
Are you sure that you want a sql and not nvault/fvault plugin?


Anyway, i need help about two thing. How do i get a string?
Also, lets say that i have in db the same steam id 2 times, but different values. How do i get those variables?
__________________
Jhob94 is offline
frOOgy
Senior Member
Join Date: Jul 2014
Old 02-11-2015 , 11:53   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #112

Because MySQL is most popular vault system and I want to learn how to use it
__________________
Help me in other requests

Change Map System [PLUGIN]

GaG System [PLUGIN] [PLUGIN]
frOOgy is offline
Send a message via Skype™ to frOOgy
Jhob94
AMX Mod X Donor
Join Date: Jul 2012
Location: Portugal
Old 02-11-2015 , 11:56   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #113

Quote:
Originally Posted by frOOgy View Post
Because MySQL is most popular vault system and I want to learn how to use it
Then, first get a database before request the plugin...
__________________
Jhob94 is offline
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 02-11-2015 , 13:23   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #114

Quote:
Originally Posted by Jhob94 View Post
Anyway, i need help about two thing. How do i get a string?
Also, lets say that i have in db the same steam id 2 times, but different values. How do i get those variables?
Which string?
Why would you have the same steam id twice on your database?
__________________
skz is offline
frOOgy
Senior Member
Join Date: Jul 2014
Old 02-12-2015 , 14:57   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #115

nevermind. did I need this part of the code:

[php]new Host[] = "hostname"
new User[] = "username"
new Pass[] = "password"
new Db[] = "database" [/pph]
__________________
Help me in other requests

Change Map System [PLUGIN]

GaG System [PLUGIN] [PLUGIN]
frOOgy is offline
Send a message via Skype™ to frOOgy
Jhob94
AMX Mod X Donor
Join Date: Jul 2012
Location: Portugal
Old 02-12-2015 , 15:19   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #116

Quote:
Originally Posted by frOOgy View Post
nevermind. did I need this part of the code:

[php]new Host[] = "hostname"
new User[] = "username"
new Pass[] = "password"
new Db[] = "database" [/pph]
yes you need it. you need a database and put the information about database.
Anyway, sql isnt the best. It has advantages but also has disadvantages. The biggest advantage is that you will be able to make php scripts and show saved stuff in a website. If you dont need that, go use nvault or fvault because they are better.
__________________
Jhob94 is offline
frOOgy
Senior Member
Join Date: Jul 2014
Old 02-12-2015 , 17:37   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #117

ok, thxx for help...

t/c
__________________
Help me in other requests

Change Map System [PLUGIN]

GaG System [PLUGIN] [PLUGIN]
frOOgy is offline
Send a message via Skype™ to frOOgy
Old 09-17-2017, 05:16
BaD CopY
This message has been deleted by BaD CopY.
Ant1Lamer
Senior Member
Join Date: Jul 2009
Old 05-31-2022 , 13:56   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #118

Can you tell me how to save kills in sql and how to load this kills ? and how to remove after a given period of time.

P.S: This plugin i cant to use "#include <csstats>" just to need to make "x" kills and after make this "x" kills they remove a given period of time
Attached Files
File Type: sma Get Plugin or Get Source (vip_test.sma - 40 views - 7.8 KB)

Last edited by Ant1Lamer; 05-31-2022 at 14:11.
Ant1Lamer is offline
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 06-17-2022 , 11:07   Re: [Tut] MySql - Save/Load/Usefull Things (Xp Mod)
Reply With Quote #119

Do you just need the SQL or are you asking for code? For something simple like this, you could always use nVault, which includes the prune function to delete stuff after X time.
__________________

Last edited by Bugsy; 06-17-2022 at 11:07.
Bugsy 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 20:42.


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