Register for your free account! | Forgot your password?

You last visited: Today at 22:40

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[RELEASE]MySQL TableEditor

Discussion on [RELEASE]MySQL TableEditor within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.

Reply
 
Old   #1
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
[RELEASE]MySQL TableEditor

Hello e*pvper's!

Here is my first C# tool.
I have made this lite tool for people's who dont know how to use NativCat (or ther program's like this)

For the initial release this tool have the next feature's:
Connect To MySQL Server via IP,User and Password.*
View and Edit table's.
Alter Table's.
Open Close DataBase's (DB's)


Hope this tool with help atleast 10 person's.

Download Link:
FileBeam

MegaUpLoad

Version History:
Version 2:
Added Tool Menu
Added Help/About/Exit Button
REMOTE Connection!

Version 1:
Initial Release.



NoobGuide:
Step 1
Download this tool extract the arhive with WinRar.
Step 2
Go where you extracted the tool (for example C:\TableEdite\) and open TableEdite.exe



Step 3
After the tool is loaded you will see this:
Now enter your MySQL Info and you are connected.



Step 4
Now if you click on DataBase's you will see all your DB from MySQL Server.
To select a table click on Table's and edit wht you need




Did you link this Tool?Please Hit Thank's and Leave A Comment.
Did you found a bug?Let me know.
Remember, this program si scripted by my and is not a OpenProject.
L1nk1n*P4rK is offline  
Thanks
6 Users
Old 06/05/2009, 12:26   #2
 
Rulzan's Avatar
 
elite*gold: 0
Join Date: Apr 2009
Posts: 220
Received Thanks: 29
Thanks for the release
off: love LP music
Rulzan is offline  
Thanks
1 User
Old 06/05/2009, 13:05   #3
 
elite*gold: 0
Join Date: Jun 2007
Posts: 323
Received Thanks: 30
It's alright. It's like the same thing like navicat &+ mySQL Administratior.
Zanzibar is offline  
Old 06/05/2009, 13:41   #4
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
LP rulez xD
I the next hour's I will add Version 2! Stay Tune
L1nk1n*P4rK is offline  
Old 06/05/2009, 15:50   #5
 
m4l4ria's Avatar
 
elite*gold: 0
Join Date: Jan 2009
Posts: 45
Received Thanks: 8
Nice Good Release!
m4l4ria is offline  
Thanks
1 User
Old 06/05/2009, 16:00   #6
 
elite*gold: 0
Join Date: Jan 2009
Posts: 425
Received Thanks: 424
Nice Release Work Fine
BrokeN^WinG is offline  
Thanks
1 User
Old 06/05/2009, 16:51   #7
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
Quote:
Originally Posted by BrokeN^WinG View Post
Nice Release Work Fine
Quote:
Originally Posted by m4l4ria View Post
Nice Good Release!

Thank's.I really wanna know if you guy'ss wanna this project to be UpDated as much is posible.


Version 2 Will Be Relesed in Next 2-3 Hour's.


V 2.0 Review:Tool Bar With:
-Exit
-Help
-About
-Credit's

-REMOTE Connection/Control.
L1nk1n*P4rK is offline  
Old 06/05/2009, 16:54   #8
 
elite*gold: 0
Join Date: Jan 2009
Posts: 425
Received Thanks: 424
Quote:
Originally Posted by L1nk1n*P4rK View Post
Thank's.I really wanna know if you guy'ss wanna this project to be UpDated as much is posible.


Version 2 Will Be Relesed in Next 2-3 Hour's.


V 2.0 Review:Tool Bar With:
-Exit
-Help
-About
-Credit's

-REMOTE Connection/Control.
o.O We Wait Your New Project ZuZu

ty
BrokeN^WinG is offline  
Old 06/05/2009, 17:18   #9
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
Quote:
Originally Posted by BrokeN^WinG View Post
o.O We Wait Your New Project ZuZu

ty

New Version....but is okay if you call it "Project"
L1nk1n*P4rK is offline  
Old 06/05/2009, 18:36   #10
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
Version 2 Just Got Released!
Ver 2.0 Feature's
REMOTE Connection/Control
Help/About/Exit Button Added
Tool's BropDown Menu.




Thank's for all the support.
I will try my best with this project.


Tools Bar:




Buttons:




Download Link:


Please Post any error here, and I will try to fix it.Will be better if you do a ScreenShot.
L1nk1n*P4rK is offline  
Old 06/05/2009, 18:46   #11
 
nTL3fTy's Avatar
 
elite*gold: 0
Join Date: Jun 2005
Posts: 692
Received Thanks: 353
Just a note:
When you run this select query on a table with thousands upon thousands of rows, it will hang the program (and the MySQL daemon) until it retrieves all the columns of data from all of the rows. Best way to solve this is by limiting the amount of rows returned per query, such as appending the limit clause to your query:
Code:
LIMIT index,count
  • index is the index from which you start the resultset
  • count is the amount of rows returned in the resultset

For example, to return the first ten rows you would append:
Code:
LIMIT 10
But, if you want the next ten rows:
Code:
LIMIT 10,10
You can think of it as pages, (page_number - 1) * rows_returned_per_page.
Code:
page_number = 10
rows_returned_per_page = 7
(10 - 1) * 7 = index
9 * 7 = 63 = index
SELECT * FROM `tbl` LIMIT 63,7;
MySQL reference site:
(this is the version that comes with the binaries)

nTL3fTy is offline  
Thanks
1 User
Old 06/05/2009, 18:47   #12
 
elite*gold: 0
Join Date: Apr 2008
Posts: 20
Received Thanks: 0
thank you very much but can you uplode it on another upload site?
like rapidshare or megaupload
masr222 is offline  
Old 06/05/2009, 18:49   #13
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
Thank's very much for this tip.
I try do add it on V 3.0 and sure you will get your credit's

Masr222: Sure No Problem.
L1nk1n*P4rK is offline  
Old 06/05/2009, 19:37   #14
 
elite*gold: 0
Join Date: Apr 2008
Posts: 20
Received Thanks: 0
thank you very much but can i ask you for more one help?
1-please i need sql file for cp admin which exchange dbs and db scrolls for cps and money for cps and cps for money?
2-how can i change the limited of entering lottery
3-finally ! with the programe that translate the npcs . sample:- when i write the ip of tccaptian 1 mssg only appears but there are alot of mssg i need to translate like he says some thing to who can take quest from him and say another thing to who have to go to another npc to take the quest and say another thing to lvl 120+ chars.
please help me with that.
masr222 is offline  
Old 06/05/2009, 20:13   #15
 
L1nk1n*P4rK's Avatar
 
elite*gold: 0
Join Date: Mar 2008
Posts: 303
Received Thanks: 39
Quote:
Originally Posted by masr222 View Post
thank you very much but can i ask you for more one help?
1-please i need sql file for cp admin which exchange dbs and db scrolls for cps and money for cps and cps for money?
2-how can i change the limited of entering lottery
3-finally ! with the programe that translate the npcs . sample:- when i write the ip of tccaptian 1 mssg only appears but there are alot of mssg i need to translate like he says some thing to who can take quest from him and say another thing to who have to go to another npc to take the quest and say another thing to lvl 120+ chars.
please help me with that.

I cant answer at this question becouse I dont use TQBynari's
L1nk1n*P4rK is offline  
Reply


Similar Threads Similar Threads
[Release] Mysql - Server has gone away -> Problem lösen ;)
08/04/2010 - Metin2 PServer Guides & Strategies - 8 Replies
Moin, Ist es bei euch auch manchmal so das wen mitten im Game der Server abstürzt Und in der Syserr etc. nur steht Mysql Server has gone away ? Das bedeutet eig. nur das er zugroße Packete nicht senden konnte das löst ihr Indem ihr in den verzeichnis
[Release] MySQL Insert system
07/18/2010 - CO2 PServer Guides & Releases - 18 Replies
Ello! First of all, this is NOT sourcedependent, which means you can use this on any source without modifying the code. This is an replacement for all of you who still uses normal MySQL queries. Use this code to clean up, make it easier and more orginazed. Here's how it looks: Example: (Original (LOTF for example))
[Release]MySql Databse 5165
04/22/2010 - CO2 PServer Guides & Releases - 7 Replies
New Source NewestCoSource Using MySql Database You Can Use it Free ! Sql Tabels : accounts characters config items skills cq_flowers
[RELEASE]Auto Mysql Backup!
03/01/2010 - EO PServer Hosting - 3 Replies
That's right!, I've found a program that allows you to set times to save your mysql databases automatically! It is an attachment at the end of this post! Don't offer serials in PMs - KA ~Pictures~ http://i50.tinypic.com/mkhiqr.png
[Release] MySql Converter (Items & Mobs)
07/30/2009 - CO2 PServer Guides & Releases - 10 Replies
Items -> MySqlConvert.rar -------------------------------- This will convert the itemdata file to a MySql table Its a bit old but thought i would release it. Might come in handy, just a basic tool. If you want the source just pm me or decompile the exe. Also got one for monsters. Database connection -> Config.ini Drag the itemtype.dat from client folder/ini onto the exe to begin initialization



All times are GMT +1. The time now is 22:43.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.