[OFFER]Mysql Script Pays

Page 1 of 2 1 2
11/01/2009 15:34 Pete1990#1
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.
11/01/2009 15:38 12tails#2
first at all... what source?

add cps by the source with command?

and what more?
11/01/2009 15:49 Hybris#3
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.
11/01/2009 15:59 zbest#4
@Hybris
This is posible for LOTF?
Coz atm im creating a Game Panel and i wanna add this feature to it.
Game Panel [Only registered and activated users can see links. Click Here To Register...]
Thanks in advance Hybris.
11/01/2009 16:08 Pete1990#5
its for bins and its in cq_user and cps is e_money
11/01/2009 16:11 Hybris#6
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).
11/01/2009 16:19 Korvacs#7
Code:
    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.
11/01/2009 16:19 Pete1990#8
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:D
11/01/2009 16:25 Hybris#9
Quote:
Originally Posted by Pete1990 View Post
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:D
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.
11/01/2009 16:26 Korvacs#10
Quote:
Originally Posted by Pete1990 View Post
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:D
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.
11/01/2009 16:29 raidenx123#11
He's using binaries, which isnt C#
11/01/2009 16:34 Pete1990#12
i have alrdy said that im using bins
11/01/2009 16:34 Hybris#13
Well reverse conception exists ;)
Without that, it'll be a little harder to handle an already existing connection and its encryption keys.
11/01/2009 16:35 Korvacs#14
Quote:
Originally Posted by raidenx123 View Post
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 >_>
11/01/2009 16:37 raidenx123#15
unfortunately people can post anything related to binaries except links to their download
Page 1 of 2 1 2