[NEW] ZeroN 9D - The Ultimate 9D Server

[[Arceus]]

Originally Posted by eyalmp

blablablablablabla blablablablablabla
now log zeron get items for free there is alot duped to collect ... bb

I'm not involved in any of the game servers nor do I play on any of them.

Just wanted to clearify that the infos madmerlin/mardu was sharing was false.

[--Lucas--]

Originally Posted by [Arceus]

I'm not involved in any of the game servers nor do I play on any of them.

Just wanted to clearify that the infos madmerlin/mardu was sharing was false.

Isnt it weird when we say that tho we still get accused of getting items from 9Dpk

[PeteSauce]

Originally Posted by R.E.X

Trust me insulting the staff with those kinds of cheap arguments and telling lies won't make any other player come over to 9dPK, where you clearly seem to be paid, otherwise you wouldn't come here and senselssly insult the staff and to spread lies.

ZeroN 9D has the cheapest IM by far. Is corrupt free and has the biggest population. In fact they have 10 times 9dpks population and 4 times its popluation in one single map. Here a post for those who missed it:



Oh and here some further SS I made to underline his statistics:







There are more stands in hefei @ ZeroN 9D than 9DPK and Elysium have players in their whole server. So I don't really see why anyone would come over to 9DPK / Elysium especially considering the admins there give free stuff to their friends. You keep trying spreading lies, but no matter what lies you tell I'll be here to prove you wrong, and to show what ZeroN 9D has to offer, while your servers are empty and corrupt.

Paid ? nah... lies ? not at all..Truth? yup ..Let me tell you something here lil man..first of all we saw that with almost every private server..you give Items like that and peoples will come to at least check it out..Do that mean your server is good ? Not AT ALL..I'm not hating hating take effort..i barely look epvp anymore..I'm stating my opinion that many peoples i know share the same..now you can waste your time to prove me i'm wrong but the truth is Zeron is a bad server

[R.E.X]

Originally Posted by PeteSauce

Paid ? nah... lies ? not at all..Truth? yup ..Let me tell you something here lil man..first of all we saw that with almost every private server..you give Items like that and peoples will come to at least check it out..Do that mean your server is good ? Not AT ALL..I'm not hating hating take effort..i barely look epvp anymore..I'm stating my opinion that many peoples i know share the same..now you can waste your time to prove me i'm wrong but the truth is Zeron is a bad server

One of your many lies was that ZeroN has an expensive item mall. There's no cheaper Item Mall in the 9D scene. They must be arround 80-90% cheaper than the officials, and cheaper than 9dpk in 90% of the items. And then you tell me you're not lying? There you see why your posts are not credible at all.
Truth is you're part of 9dpk and part of the troll group financed by 9dpk. If ZeroN is a bad server then point me to a better one. You can't because there is none. So instead of just trash talking the server why not bring constructive suggestions what to improve? You won't do that because 9dpk pays you for simply trash talking the server and not for bringing constructive critisism. That's pretty simple to recognize out of your posts.

[eddwood]

Originally Posted by --Lucas--

Isnt it weird when we say that tho we still get accused of getting items from 9Dpk

That means you won the argument, grats.

I do wonder how much REX gets paid for sounding like a used car salesman?

[madmerlin3009]

@

[eddwood]

Originally Posted by madmerlin3009

. rest assured i expect 2-3 kingpins now. lets see. R.E.X , Edwood and low and behold ARCEUS. These guys seem to get off at slamming people with opinions.

Don't be bringing me into your argument's, moron.

I'm surprised you can operate a computer from the way you type.

Only time I have ever critiqued you was based off information from the PA crew, who's ***** you are now trying to kiss, that and the fact I did't agree with your greedy little item mall.

In fact everything I have ever heard about you I have heard on these forums, mostly from the above mentioned.

If you think back, or check my chat history, you would find that I defended you from them, at that time, but that was before I realised you are, as people say you are, a actual ****.

So don't start trying to dirty my name, you greedy little rat.

P.S If you reply use a keyboard, not the TV remote.

[[Arceus]]

Originally Posted by madmerlin3009

...

Allright so I made me the effort to install SQL Server and restore the databases just to prove your wrong.

Here's a screenshot how the inventory tables are build:



As you can see at the unique_id the unique contraint is set, meaning that id can't exist twice in the same table. Except for the manual contraint you see at the end which passes a default value of 0. That's the only value that can exist twice because it's the default value.

So your SQL Query won't work and will either result 0 rows or it will only show unique_id's with default value 0.
That's why you nowhere show any results of your queries but only the code.
Because it simply doesn't work that way.

The reason I got angry was because you go to another servers topic who by the way has the most professional and skilled staff regarding the 9d scene and you try to prove a point with false information, basically saying " I have a solution , you don't" when in fact they already have fixed the issue but you still have it. And your queries don't even work. That's what I simply can't stand.

[R.E.X]

Originally Posted by madmerlin3009

@

Lol, now you removing your posts because Arceus proved you wrong.
This is getting more and more embarassing.

[madmerlin3009]

Originally Posted by R.E.X

Lol, now you removing your posts because Arceus proved you wrong.
This is getting more and more embarassing.

wrong wrong wrong.it was a total rant at users which i decided to remove.

Originally Posted by R.E.X

Lol, now you removing your posts because Arceus proved you wrong.
This is getting more and more embarassing.

Originally Posted by [Arceus]

Allright so I made me the effort to install SQL Server and restore the databases just to prove your wrong.

Here's a screenshot how the inventory tables are build:



As you can see at the unique_id the unique contraint is set, meaning that id can't exist twice in the same table. Except for the manual contraint you see at the end which passes a default value of 0. That's the only value that can exist twice because it's the default value.

So your SQL Query won't work and will either result 0 rows or it will only show unique_id's with default value 0.
That's why you nowhere show any results of your queries but only the code.
Because it simply doesn't work that way.

The reason I got angry was because you go to another servers topic who by the way has the most professional and skilled staff regarding the 9d scene and you try to prove a point with false information, basically saying " I have a solution , you don't" when in fact they already have fixed the issue but you still have it. And your queries don't even work. That's what I simply can't stand.

look again you muppet.


there were no primary keys set on these tables.

that script you created by right clicking table.>=script table as => create table . Then you altered the code to put a unique constraint in the script.



the above link shows exectly how the table is created. Also the constaints are added below. You manually edited that script you muppet.

Also you muppet the returned query at the lower part of the screen 3 records were returned



I apologize zeron about this.Arceus is doing my head in. But i had to get this point across to this idiot.

You failed to pull the wool over peoples eyes trying to create a script to create a table then manually entering data into the script. Hahaha.

What a failure. i hope everybody sees your pathetic attempt to make me look stupid

[Adek]

Too lazy to even make local server just to try it out and make proof. Any other gonna volunteer on that?

[madmerlin3009]

Originally Posted by adek1994

Too lazy to even make local server just to try it out and make proof. Any other gonna volunteer on that?

adek the queries work. look i used the gui qery builder to check for items

here is the query


here is the gui query builder. its that simple


i really dont know what this guys issue is. reporting on items duped. it was a known case when the maps were wrongly shut down for maintenance. there was a 10 second notice sent from gm tools to ndserver.us.exe "0-23" .If one char was multi logged using vmware. Just before the char gets dc'd he would trade with another char the item. i caught zozohun doing this method .Low and behold. Look at to two cuid numbers 89593 and 89594. pretty obvious dont you think. if i check the login [ ip] address i bet we also have the same ip address

[Adek]

Originally Posted by madmerlin3009

adek the queries work. look i used the gui qery builder to check for items

here is the query


here is the gui query builder. its that simple


i really dont know what this guys issue is. reporting on items duped. it was a known case when the maps were wrongly shut down for maintenance. there was a 10 second notice sent from gm tools to ndserver.us.exe "0-23" .If one char was multi logged using vmware. Just before the char gets dc'd he would trade with another char the item. i caught zozohun doing this method .Low and behold. Look at to two cuid numbers 89593 and 89594. pretty obvious dont you think. if i check the login [ ip] address i bet we also have the same ip address

I really don't need GUI query builder, trust me. It's just strange that developers ignored such a "feature" as making values unique on... keys? Doesn't it sound strange? Fix would be quite easy then, since adding constraint shouldn't crash clients or the way they're working. Unless they really are adding items with non-unique IDs, but I guess some easy trigger should do its job as well.

CUID numbers are actually 89593 and 89584, so +9, not just consequent value. It doesn't matter, though. If that really is the issue, it's quite easy to even run some query like:

delete from TABLE where unique_id IN( select unique_id from TABLE group by unique_id having cout(*)>1 )

That's just sql pseudocode, but still should work, if the things you told about are true.

*why just don't we get all the developers to truly make 'good' 9D server, let's make 9Dragons great again - with permabanned Tenge*

[madmerlin3009]

Originally Posted by adek1994

I really don't need GUI query builder, trust me. It's just strange that developers ignored such a "feature" as making values unique on... keys? Doesn't it sound strange? Fix would be quite easy then, since adding constraint shouldn't crash clients or the way they're working. Unless they really are adding items with non-unique IDs, but I guess some easy trigger should do its job as well.

CUID numbers are actually 89593 and 89584, so +9, not just consequent value. It doesn't matter, though. If that really is the issue, it's quite easy to even run some query like:

delete from TABLE where unique_id IN( select unique_id from TABLE group by unique_id having cout(*)>1 )

That's just sql pseudocode, but still should work, if the things you told about are true.

*why just don't we get all the developers to truly make 'good' 9D server, let's make 9Dragons great again - with permabanned Tenge*

Adek i was just pointing out how easy it was to use the gui query builder. Arceus was saying my scripting was incorrect. When all i demonstrated how easy it was to have the script built for you . The gui interface does not lie unless you integrate the internal function expressions incorrectly with might return ambiguous results which the query will fail.

reguarding the delete query you posted. Ok duping is a known fact. What you can do from nd_log_0 is take the itemlog_id and check fields type1 and type2. if that item has been duplicated and transferred to another char the itemlog_id will have inserted another record on trade. what i do think is required is altering the stored procedure with inserts new records into the database. There is no date stamp When maintenance occurs on a particular day you can check all items using the date stamp on the nd_log_0.

You can then check against the day of maintenance and any items created on that day with a unique item id which has the same value as an existing id.Remembering that item unique id will be passed to another character under the different inventory table number if they are using vmware to multi log.


the database never lies. if you compare table 1 against table 2. the nested sql to compare all will take hours to return the result. compare 1-2,1-3,1-4,1-5,1-6,1-7,1-8, 2-3,2-4,2-5,2-6 etc. obviously the main item types are cloth 1,weapons 19, relics 9. what you can possibly do to filter the list of users logged when you actually shut the server down for any reason. So then we have the cuid of that user logged at that particular time. With the reporting faclities they gave us when developing the database i am positive every dupe possible can be highlighted

[[Arceus]]

Originally Posted by madmerlin3009

..

I already proved my point with screenshots already and you deleted your post after that because you figured out you were wrong. So what are you trying to do now?

There's no point for wasting more time here. I posted my prove and I showed that your method doesn't work and that you were spreading false information. So my job is done here. Good luck.