MYSQL queries

[Amiroslo]

Hello
I want a querie where u add 3points for all players
I want a querie where it makes all players level 10 with hp and mana 100 and cap 1000
I want a querie where you make all players voc to 0
I want a querie where all players start at pos x, y, z

PS: can anyone make a script that makes max cap 10k, and you can gain more cap than 10k? with no source editing

rep++

 

[H4CK3R]

That's about player postions!

UPDATE `players` SET `posx` = 1000, `posy` = 1000, `posz` = 7;

Change the 1000-1000-7 to the postion you want!

 

[Dantarrix]

How you will use them? :// Cause if you will use them on LUA, they will have some writing, if you will use them on php or html, it has another writing and directly on database it has other writing...
So, if you can specify where you will use them and how, we can help ^^

 

[H4CK3R]

He will use them on database (MySQL) I think

 

[Dantarrix]

Well, if its like that:
1. For points:

UPDATE `players` SET `points` = `points` + 3;

I thought points is the name of the table, but you can change it where it says `points`, there are 2 entrance of this table on script....

2. For level, hp, mana and cap:

UPDATE `players` SET `level` = 10, `health` = 100, `healthmax` = 100, `mana` = 100, `manamax` = 100, `cap` = 1000;

3. For vocation:

UPDATE `players` SET `vocation` = 0;

4. For pos:

They already give it to you

5. Didnt understand the script you want...

 

[Amiroslo]

5.
In my ot u lvl up to 700k and u get over 100k cap, i want a script that makes max cap 10k, without editing source
maby a creaturescript or smth?

 

[Dantarrix]

I think you have only 2 ways....

1. Source editing (you dont want it)

2. Editing vocations.xml so when you get 700k level, you only got 10k cap... ^^

 

[Amiroslo]

well, as i said i dont want source editing, so if u can help me with the sec op. do it please