SQL Script

[kubaa1]

Hey guys, so me and my friend an idea we would like to realise in our server.

If someone has any knowledge with SQL Coding and would be ableto help us out, I would be eternally grateful :D

What I want to do is to create a script that would automatically trigger itself every 7 days.

This script would add a certain number of W Coin P to every account, I guess it won't be too hard, since there is no special rules. Just a simple "Add Wcoin P to All Account every 7 days" script.

If anyone can give us a few tips, or even a ready script, it would be greatly appreciated! :)


Thanks guys

[MentaL]

[15351535]

jou can make it via sql job
replace table names and it is done ;)

UPDATE Character
SET Money = 2000000000

[kubaa1]

I worked it out, but thanks for your reply! :)

I had to download an external application that runs scripts every set intervals, since SQL Express doesn't come with SQL Agent.

[15351535]

dont know,i make it via sql jobs,there can you use (every min,every hour,every day or 1 day of week)
and it works automatic after

[kubaa1]

dont know,i make it via sql jobs,there can you use (every min,every hour,every day or 1 day of week)
and it works automatic after

You probably have a better version of SQL. Im using sql express.

[15351535]

i use sql 2008 r2
here is link for you

https://mega.co.nz/#!0UVyWbiC!yLfgJE...ivGV9q7ub7AAdc

[kubaa1]

Im currently using the Express version from the microsoft website. I was considering getting a ISO from piratebay, but since I found a workaround. I'll allow myself to avoid the trouble of reinstalling sql :D

Thanks for the link, maybe someone else will find it useful.