Windows Need a database script

[Byllan]

Hello i need a script there i say all players to level 8 with 10 in all skills

give rep if you help me!

 

[bolero]

UPDATE players SET level=8;

UPDATE players SET experience=4200;

UPDATE player_skills SET count=10;

UPDATE player_skills SET value=10;

Execute this SQL query in your database.

 

[chojrak]

@UP:
count should be 0, it means "hits"

 

[Byllan]

Hmm about levels?

 

[bolero]

Ops Error, Check the post, up!... I fix. Rep++

 

[Fallen]

UPDATE players SET level=8;

UPDATE players SET experience=4200;

UPDATE player_skills SET count=10;

UPDATE player_skills SET value=10;

Execute this SQL query in your database.

UPDATE players, player_skills SET players.experience = 4200, players.level = 8, player_skills.count = 10, player_skills.value = 10

not tested

 

[Byllan]

Thankz for the help!