Raised This Month: $ Target: $400
 0% 

MySQL Problem [Again]


Post New Thread Reply   
 
Thread Tools Display Modes
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 08-26-2014 , 14:41   Re: MySQL Problem [Again]
Reply With Quote #11

You will use this plugin, simple. Only add events needed to increase the player exp.
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 08-26-2014 , 14:51   Re: MySQL Problem [Again]
Reply With Quote #12

I want to save points in one table and exp in another table, can you edit your plugin please?

And by the way, thanks!
__________________

Last edited by skz; 08-26-2014 at 14:51.
skz is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 08-26-2014 , 19:03   Re: MySQL Problem [Again]
Reply With Quote #13

Quote:
Originally Posted by skz View Post
I want to save points in one table and exp in another table, can you edit your plugin please?

And by the way, thanks!
why you need this? i not see a valid reason :X
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 08-26-2014 , 22:09   Re: MySQL Problem [Again]
Reply With Quote #14

Quote:
Originally Posted by ^SmileY View Post
why you need this? i not see a valid reason :X
Because Points is for all servers, like you win 10 points on surf you can use it on Jailbreak, but xp is only for Surf
__________________
skz is offline
^SmileY
Veteran Member
Join Date: Jan 2010
Location: Brazil [<o>]
Old 08-26-2014 , 22:12   Re: MySQL Problem [Again]
Reply With Quote #15

Quote:
Originally Posted by skz View Post
Because Points is for all servers, like you win 10 points on surf you can use it on Jailbreak, but xp is only for Surf
You can use more than one field in table called exp

LOL
__________________
Projects:

- See my Git Hub: https://github.com/SmileYzn
PHP Code:
set_pcvar_num(pCvar, !get_pcvar_num(pCvar)); 
^SmileY is offline
Send a message via MSN to ^SmileY Send a message via Skype™ to ^SmileY
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 08-27-2014 , 02:30   Re: MySQL Problem [Again]
Reply With Quote #16

I know, but for example on my JailBreak server i will only save points, so I think this could reset xp (I repeat: Im noob on mysql)
__________________
skz is offline
skz
Senior Member
Join Date: Jul 2014
Location: Portugal
Old 08-27-2014 , 07:56   Re: MySQL Problem [Again]
Reply With Quote #17

I want to create 2 tables, one that saves XP and Level and another that saves points, can someone do that please?
__________________
skz is offline
claudiuhks
Yam Inside®™℠
Join Date: Jan 2010
Location: Living Randomly
Old 08-27-2014 , 17:00   Re: MySQL Problem [Again]
Reply With Quote #18

There are a lot of tutorials on Stackoverflow and a lot of other communities. Even on AlliedMods.
You are just lazy to try and learn by yourself. We are here to help with broken code not teaching people how to start coding.
I don't say I don't really have time to code pages for you but they need testing and I'm not really in the mood for that.
It doesn't matter whether or not you add ' and ` characters or set a default column. That should be enough.

PHP Code:
create table if not exists my_table (name textkills numeric)
insert into my_table ('Hattrick'0)
select name from my_table
update my_table set kills 
1 where name 'Hattrick' 
My suggestion is to check all my posts or subjects related to SQL and try on your own.
Click on someone's name, Statistics and View all Threads. claudiuhks' Threads.
__________________

Last edited by claudiuhks; 08-27-2014 at 17:04.
claudiuhks is offline
Send a message via MSN to claudiuhks Send a message via Yahoo to claudiuhks Send a message via Skype™ to claudiuhks
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 12:35.


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