[OFFER]Mysql Script Pays

[Pete1990]

Ok im needing a mysql script that will add cps into All accounts + there other cps if someone can make this script for me i will pay them for it.

[12tails]

first at all... what source?

add cps by the source with command?

and what more?

[Hybris]

A detail of the Account and/or Character database structure could be necessary to make the script.

The SQL Query of these tables creations are enough.

[zbest]

@Hybris
This is posible for LOTF?
Coz atm im creating a Game Panel and i wanna add this feature to it.
Game Panel
Thanks in advance Hybris.

[Pete1990]

its for bins and its in cq_user and cps is e_money

[Hybris]

A database is accessible with a connection and SQL Queries.
Then the server in itself, has a local memory an access to the database and some connections to manage.
So it's not as easy as just Querying the database (except for disconnected clients maybe).

[Korvacs]

    public static bool UpdatePlayerExp(uint CPS)
    {
        MySqlCommand Command = new MySqlCommand("UPDATE `cq_user` SET `e_money` = \"" + CPS + "\"", DatabaseConnection);
        Command.ExecuteNonQuery();
        return true;
    }

It would be similar to that, however ive never seen your database so you would need to replace "DatabaseConnection" with your SQL connection that you have.

This would update every character with the new value of cps, go ahead and modify it accordingly.

Edit: The fact its a bool is because i took it straight of an old source of mine, it can be whatever you want.

[Pete1990]

well thats why u do it when server is off -.-
well i dont have C# or anything on my pc lol i suck at coding thats why im offering to pay someone for a working one

[Hybris]

Originally Posted by Pete1990

well thats why u do it when server is off -.-
well i dont have C# or anything on my pc lol i suck at coding thats why im offering to pay someone for a working one

If you can code it in the Server in itself, it can be done on Active Clients too.
But the script can be a little more complex.

[Korvacs]

Originally Posted by Pete1990

well thats why u do it when server is off -.-
well i dont have C# or anything on my pc lol i suck at coding thats why im offering to pay someone for a working one

If you dont have C# then theres no point asking, since what your asking for is C# source code in order to update a database.

Unless you host the database on its own? In which case you can still modify what ive given you to use phpmyadmin to update all of your records, go and use google to learn how the SQL Update syntax works.

[raidenx123]

He's using binaries, which isnt C#

[Pete1990]

i have alrdy said that im using bins

[Hybris]

Well reverse conception exists
Without that, it'll be a little harder to handle an already existing connection and its encryption keys.

[Korvacs]

Originally Posted by raidenx123

He's using binaries, which isnt C#

In that case he can give up on it, no one here will atually write him a seperate program just to update the database, he can do it manually or use database management tools to perform an update.

Whatever happened to binary related posts being banned >_>

[raidenx123]

unfortunately people can post anything related to binaries except links to their download