Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Conquer Online 2 > CO2 Private Server
You last visited: Today at 05:48

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

Advertisement



Questio: MySQL Duplicate Entrys

Discussion on Questio: MySQL Duplicate Entrys within the CO2 Private Server forum part of the Conquer Online 2 category.

Closed Thread
 
Old   #1
 
elite*gold: 20
Join Date: Jan 2008
Posts: 2,338
Received Thanks: 490
Questio: MySQL Duplicate Entrys

How would i prevent duplicates? How would i check it IN C#
~Yuki~ is offline  
Old 04/20/2010, 04:13   #2
 
LetterX's Avatar
 
elite*gold: 20
Join Date: May 2007
Posts: 1,125
Received Thanks: 332
Quote:
Originally Posted by ~Yuki~ View Post
How would i prevent duplicates? How would i check it IN C#
Duplicate entries of what?
LetterX is offline  
Old 04/20/2010, 04:36   #3
 
elite*gold: 0
Join Date: May 2006
Posts: 127
Received Thanks: 91
Quote:
Originally Posted by ~Yuki~ View Post
How would i prevent duplicates? How would i check it IN C#
duplicate entry's usually happen in an INSERT statement. therefore you need to put ifs before executing INSERT statement.

anyway, duplicate entry's can be avoided also if you had set a primary/unique key on the database table definition....

read the subject area from this site:
kamote is offline  
Old 04/20/2010, 06:12   #4
 
elite*gold: 20
Join Date: Jan 2008
Posts: 2,338
Received Thanks: 490
mkay fixed it inside the source wifout a pkay thanks too.

Can be closed
~Yuki~ is offline  
Old 04/20/2010, 06:39   #5
 
elite*gold: 21
Join Date: Jul 2005
Posts: 9,193
Received Thanks: 5,380
Yah, just do a simple bool for if a value already exists in the specified database. That way you can check if it already exists and if so return to the client that the required db function couldn't be completed, if not it will go ahead and complete the database function properly.
pro4never is offline  
Old 04/20/2010, 12:22   #6
 
elite*gold: 20
Join Date: Aug 2005
Posts: 1,734
Received Thanks: 1,001
#Closed
tanelipe is offline  
Closed Thread


Similar Threads Similar Threads
MySQL Navicat 1130-Host'5.xxx.xx.xxx' is not allowed to connect to the MySQL Server
08/07/2010 - Metin2 Private Server - 14 Replies
Hallo com, ich habe ein Problem mit Navicat. Undzwar habe ich diesen Fehler hier : "1130-Host'5.xxx.xx.xxx' is not allowed to connect to the MySQL Server" seid gestern. Ich dachte mir mal ich änder mein Navicat Passwort um... Als ich dies getan habe, und meinen Server rebootet habe und Navicat neugestartet habe, und ich mich wieder in Navicat einloggen wollte kam diese Fehlermeldung. Nun habe ich das Problem das ich mich nicht mehr mit Navicat connecten kann. Habe schon alles versucht...
Ring of luck +1 questio
07/03/2010 - Cabal Private Server - 7 Replies
Hey guys, i recently checked the drops of the Ring of Luck +1, some say from bugmander from Green despair, some say skeleton from Bloody ice, and some say Desert Screams mummy blader and mummy warrior. Can you guys please help me confirm this? i want to know exactly WHICH monster drops it, and by the way my character is level 54.. So was wondering if you can help Thank yoU!
A questio about cabal registration
03/28/2010 - Cabal Private Server - 0 Replies
Cabal Online - The Revolution of Action I have a question, after you sign in, your username what do u put for your ''first name and last name''? and is ID suppose to be our logging username when u open cabal.exe? and does the security questions have to be the same when we make cabal OPG?
Questio n
10/28/2008 - Lineage 2 - 1 Replies
Hi people! I need an English linguistic package for Lineage 2! Because I on Privately server am, however, the whole one play is on in Russian! For it I need the English linguistic package



All times are GMT +1. The time now is 05:51.


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.