Register for your free account! | Forgot your password?

Go Back   elitepvpers › MMORPGs › Conquer Online 2 › CO2 Private Server › CO2 PServer Guides & Releases
[Release] World Conquer Source v2 [Release] World Conquer Source v2
You last visited: Today at 20:27

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

Advertisement


Advertise with us!

[Release] World Conquer Source v2

Discussion on [Release] World Conquer Source v2 within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.

Reply
Page 10 of 23 « First 89 10 111220 Last »
 
Old   #136
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2007
Posts: 10
Received Thanks: 1
Quote:
Originally Posted by pintinho12 View Post
You have two solutions which I'll not post the code for you.
1. You can enable the auto quote on table/column names, editing the Fluent Connection;
2. You can escpae the column name which is using a reserved name with "`" on the mapping.

Good luck.

Why do not you want help

All Problem
memo0077 is offline  
Old   #137
 
pintinho12's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2009
Posts: 953
Received Thanks: 419
But I helped. I just wont give you code.
It's 1 line of code which will fix those issues, and you better google or pray for somebody else to give you the code, because I aint doing.
Maybe I did fix it somewhere in the thread replies. But I'm also too lazy to search.
I gave you two solutions, just use less than 1% of your brain building a query on google.
pintinho12 is offline  
Old   #138
 
Spirited's Avatar
 
elite*gold: 12
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 8,310
Received Thanks: 4,205
He gave you the solutions... Change your configuration or change how the queries are created. If you have a question about the solutions he gave you, then say so. Don't say he isn't helping you though... so rude. And please remove the full stack trace or put it around a spoiler tag. That's annoyingly long...
Spirited is offline  
Old   #139
 
stormy547's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2010
Posts: 47
Received Thanks: 2
Legitimate question out of curiosity here:

What is the point of using the cq_action table for handling events? (I use the term event for lack of better term, but it essentially looks like an event handler to me)

I assume this is to keep consistency with the format exposed by the bins, but is there any particular benefit/reason for using the action table rather than writing handlers in class files?

Other than consistency, the only other potential benefit I see is to prevent it from being hard-coded and requiring a full rebuild of the binary to change the values, however personally I find the action table format to be unnecessarily convoluted.
stormy547 is offline  
Old   #140


 
KraHen's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 794
Quote:
Originally Posted by stormy547 View Post
Legitimate question out of curiosity here:

What is the point of using the cq_action table for handling events? (I use the term event for lack of better term, but it essentially looks like an event handler to me)

I assume this is to keep consistency with the format exposed by the bins, but is there any particular benefit/reason for using the action table rather than writing handlers in class files?

Other than consistency, the only other potential benefit I see is to prevent it from being hard-coded and requiring a full rebuild of the binary to change the values, however personally I find the action table format to be unnecessarily convoluted.
The values are from a leaked database from TQ itself, it basically more or less "guarantees" a correct emulation. Personally I was never a fan, I severely dislike TQs design - but I do admit it is really, really useful to have.
KraHen is offline  
Thanks
1 User
Old   #141
 
stormy547's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2010
Posts: 47
Received Thanks: 2
Quote:
Originally Posted by KraHen View Post
Personally I was never a fan, I severely dislike TQs design - but I do admit it is really, really useful to have.
I agree, I'm using this codebase as a base for my project (more or less just for fun at the moment), and I'm mildly tempted to rewrite how NPCs at the least are handled as I just don't like the action table, I find modifying database values in mass by hand to be a pain.

After giving it a bit of thought, the action table is actually a good thing for TQ since they have so many servers. Since all of their servers are identical, they can connect all of them to one action table to update and modify npcs, item functionality, whatever else goes into actions without recompiling & redistributing the binary to so many servers.

Though honestly, I'd be surprised if they don't have build scripts that automatically push updates to live for the next restart.

On a second note, it could also help them keep their code-base private to the dev team, allowing for non-developers to modify content in the action table. No clue how their team is set up, but I suppose this could be another reason.
stormy547 is offline  
Old   #142


 
KraHen's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2006
Posts: 2,216
Received Thanks: 794
You could always do some custom tooling to ease your workflow even with the current system in place, it's pretty manageable IMO.
KraHen is offline  
Old   #143
 
pintinho12's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2009
Posts: 953
Received Thanks: 419
I like the cq_action design because it makes it easier to create events, remove them or update. I don't need to create tons of classes and C# code to create events, makes my executable smaller (which is not an advantage at all) and I can easily follow the code even inside of the server (since I can print it while it executes with a PM character).
You can always call /reloadaction to reaload the server, /reloadtasks or even /reloadnpcs, /reloadgenerators and others to update your server, tho, I still think that updates must be done while server is shutdown so you can backup data and do things safely.
It's okay, depending on how you handle things (like I do on this version of the server) it can be slower, but if you do the correct changes you can make it so fast you wont feel the actions executing.
I don't need to write the same piece of code or thousand of times for every event, If an error is thrown I just need to change it in one place (if it's a code problem) or in the action itself. If you have an manager (like me), you can easily see your events and track problems.
Maybe an scripting language like Lua would be better? Okay, but to be fair, this model doesn't hurt at all. I have all checks in one place and I don't even need to write on cq_actions the requirements for executing something. I can write it on cq_task and it will avoid 5-6 actions of checking if a character is enabled to execute something.
Optmizing the event system on this server actually just depends on how much you know about it.
Since most of the database is from TQ, most of the actions don't care about cq_task, but you can check for money, item, marriage and a lot of other things in 1 row instead of a lot.
pintinho12 is offline  
Thanks
1 User
Old   #144
 
12tails's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2009
Posts: 782
Received Thanks: 459
Quote:
Originally Posted by pintinho12 View Post
I like the cq_action design because it makes it easier to create events, remove them or update. I don't need to create tons of classes and C# code to create events, makes my executable smaller (which is not an advantage at all) and I can easily follow the code even inside of the server (since I can print it while it executes with a PM character).
You can always call /reloadaction to reaload the server, /reloadtasks or even /reloadnpcs, /reloadgenerators and others to update your server, tho, I still think that updates must be done while server is shutdown so you can backup data and do things safely.
It's okay, depending on how you handle things (like I do on this version of the server) it can be slower, but if you do the correct changes you can make it so fast you wont feel the actions executing.
I don't need to write the same piece of code or thousand of times for every event, If an error is thrown I just need to change it in one place (if it's a code problem) or in the action itself. If you have an manager (like me), you can easily see your events and track problems.
Maybe an scripting language like Lua would be better? Okay, but to be fair, this model doesn't hurt at all. I have all checks in one place and I don't even need to write on cq_actions the requirements for executing something. I can write it on cq_task and it will avoid 5-6 actions of checking if a character is enabled to execute something.
Optmizing the event system on this server actually just depends on how much you know about it.
Since most of the database is from TQ, most of the actions don't care about cq_task, but you can check for money, item, marriage and a lot of other things in 1 row instead of a lot.
Agreed with you, Ganoderma & Titan, Guild War, DisCity, everything easily controlled by the action table. Also, you have all default npcs just ready to be used.

You can create an event that enables or disables checking the time, setting up using the data 0 to 3 or datastr values. what would take 30 minutes to do by codes, you can do in some 2 or 5 minutes, also like he said above, you need to change just a few lines when you do some change or bug correction.
12tails is offline  
Thanks
1 User
Old   #145
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2018
Posts: 21
Received Thanks: 0
Guys I'am using this source rightnow and about the vip when i create new account it automatically becomes VIP 6 while in the DB is VIP 1..

BTW! nice release source!
Gii0 is offline  
Old   #146
 
pintinho12's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2009
Posts: 953
Received Thanks: 419
Quote:
Originally Posted by Gii0 View Post
Guys I'am using this source rightnow and about the vip when i create new account it automatically becomes VIP 6 while in the DB is VIP 1..

BTW! nice release source!
Take a look on packet 1052, it's setting manually the VIP level.
pintinho12 is offline  
Thanks
1 User
Old   #147
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2018
Posts: 21
Received Thanks: 0
Quote:
Originally Posted by pintinho12 View Post
Take a look on packet 1052, it's setting manually the VIP level.
Thank you for the quick response sir and one last question sir! about this item stack sir it seems like its not working cause when i use 7Star Ointment the item stack number stay the same. no deduction happens also the speedarrows

I love your work sir thank you for this released source
Gii0 is offline  
Old   #148
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Apr 2019
Posts: 23
Received Thanks: 1
thank you for the source. i been using this for a month now. i learned alot of it. i fixed some bugs too. man im glad i used this instead of 5165 haha. thank you again
32212019 is offline  
Old   #149
 
pintinho12's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2009
Posts: 953
Received Thanks: 419
Quote:
Originally Posted by Gii0 View Post
Thank you for the quick response sir and one last question sir! about this item stack sir it seems like its not working cause when i use 7Star Ointment the item stack number stay the same. no deduction happens also the speedarrows

I love your work sir thank you for this released source
You'll need to take a look on the equipment class, because the algorithm I created at that time really sucks, I had to do several changes when adaptating to my newest source.
pintinho12 is offline  
Thanks
1 User
Old   #150
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 3
Received Thanks: 0
Does this source running on the latest client? 6968?

Off-Topic: Is this the latest release in this community ?
memomomo11 is offline  
Reply
Page 10 of 23 « First 89 10 111220 Last »

« [Releases]Source Veterans 5165 Classic ! | [Release] Conquer Online Patch 7561 - Dragon's Ascension (Standalone / No-VM + GM Too »

Similar Threads Similar Threads
[RELEASE]Conquer Emulator Source 5165
11/22/2010 - CO2 PServer Guides & Releases - 29 Replies
Latest Version: v1.0.0 Last Updated: 07:37AM 29/07 2010 This is a small project in NewestCOServer. Why this? To make a better NewestCOServer source. Ive deleted alot things so far and started building things up. I will work on this time after time, untill it will be good :) Hope you find this useful
[RELEASE] Conquer v5065 Source
10/20/2009 - CO2 PServer Guides & Releases - 2 Replies
Edited
[Release] Conquer Source
08/23/2009 - CO2 PServer Guides & Releases - 1 Replies
Heya. Since wrong people got ahold of this (immature kids, ofcourse) I decided to release it. It's a source which base was made by Tanel, and was rewritten and continued by me. I will not say that the coding in this source is great, because it's sure not. I stopped developing somewhere in 2008, so it's poorly coded in some places, but it has the basic stuffs + some more. Here's a little list to give you a little information:



All times are GMT +2. The time now is 20:30.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

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