Register for your free account! | Forgot your password?

You last visited: Today at 00:49

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

Advertisement



[Help]DataBase Issues

Discussion on [Help]DataBase Issues within the CO2 Private Server forum part of the Conquer Online 2 category.

Reply
 
Old   #1
 
DragonStar's Avatar
 
elite*gold: 0
Join Date: Jun 2007
Posts: 286
Received Thanks: 409
[Help]DataBase Issues

Ok im trying to save "x" amount of times some one uses a exp ball

What i have so far

In Character.cs
Quote:
public uint ExpBallCount = 0;
Quote:
ExpBallCount++
ok so far it all works i made a /expused command to see if it was even adding
up and it does add every time i use a expball

Next i have

In my DataBase
Quote:
Field=ExpBallCount
Type=INT
Attributes=UNSIGNED
Null=No
Default=0
Database.cs
Quote:
Charr.ExpBallCount = (uint)DR["ExpBallCount"];
Database.cs
Quote:
ExternalDatabase.DatabaseQueue.Enqueue(new MySqlCommand("UPDATE `Characters` SET `CharName` = '" + Charr.Name + "', `Level` = " + Charr.Level + ",`Exp` = " + Charr.Exp + ",`GuildDonation` = " + Charr.GuildDonation + ",`Strength` = " + Charr.Str + ",`Agility` = " + Charr.Agi + ",`Vitality` = " + Charr.Vit + ",`Spirit` = " + Charr.Spi + ",`Job` = " + Charr.Job + ",`Model` = " + Charr.RealModel + ",`Money` = " + Charr.Silvers + ",`CPs` = " + Charr.CPs + ",`CurrentHP` = " + Charr.CurHP + ",`StatPoints` = " + Charr.StatP + ",`MyGuild` = " + Charr.GuildID + ",`GuildPos` = " + Charr.GuildPosition + ",`LocationMap` = " + Charr.LocMap + ",`LocationX` = " + Charr.LocX + ",`LocationY` = " + Charr.LocY + ",`Hair` = " + Charr.Hair + ",`Equipment` = '" + Charr.PackedEquips + "',`Inventory` = '" + Charr.PackedInventory + "',`PKPoints` = " + Charr.PKPoints + ",`PrevMap` = " + Charr.PrevMap + ", `Skills` = '" + Charr.PackedSkills + "', `Profs` = '" + Charr.PackedProfs + "',`RBCount` = " + Charr.RBCount + ",`Avatar` = " + Charr.Avatar + ",`WHMoney` = " + Charr.WHSilvers + ",`VP` = " + Charr.VP + ",`Warehouses` = '" + Charr.PackedWHs + "',`Friends` = '" + Charr.PackedFriends + "',`Enemies` = '" + Charr.PackedEnemies + "',`QuestMob` = '" + Charr.QuestMob + "',`QuestKO` = " + Charr.QuestKO +"',`ExpBallCount` = " + Charr.ExpBallCount + " WHERE `Account` = '" + Charr.MyClient.Account + "'", ExternalDatabase.Connection));
Now once i add the "',`ExpBallCount` = " + Charr.ExpBallCount

It does not add it to the database and the game stops saving every thing
DragonStar is offline  
Old 09/10/2008, 13:11   #2
 
DragonStar's Avatar
 
elite*gold: 0
Join Date: Jun 2007
Posts: 286
Received Thanks: 409
No one knos? ><
DragonStar is offline  
Reply


Similar Threads Similar Threads
bot having issues
05/09/2008 - SRO Private Server - 8 Replies
bot doesnt work properly with no dc client any suggestions anyone
my issues
12/25/2007 - Conquer Online 2 - 0 Replies
X:in the lady luck room, the room with the prize boxes. I cant see any boxes, just the shadow of where the box should be. i push select and i can see the name of the boxes, but yet i cant open them.. after re-install all good with ladyluck.. 1: when i jump around holding the ctrl button i get d/c a lot, server is aquarius, like if i was using speedhack. bit im not, i un/re-installed twice... 2:when i star demonhunter quest, the cloudsaint's jar.. its stuck loading.... the target monster....
SV Issues
11/04/2007 - Conquer Online 2 - 5 Replies
I'm rather new at the hole cracking it myself, and i tried using the latest SV threads, but it doesnt seem to work for me. I have the new sv 1.17 and i have codes that i input, from another thread that i have found. But nothing seems to work for me, and ive been going at it for a good 4 hours now. Someone mind giving me a easy as hell to follow instructions? My CPU is currently broken so im stuck using a laptop and it seems a bot is the only way to go right now seeing as i cant PK and click...
Help with some issues with sv
02/27/2007 - Conquer Online 2 - 1 Replies
Im using a wireless internet and wen my i bot my char and he dies/gets pked. My internet shuts down and i hafta click on the repair network thing every single time. Anyone know whats wrong?
Anyone else having issues
12/19/2006 - Conquer Online 2 - 1 Replies
everytime co starts for some reason it changes the color to 16 bit, this just started happening recently. It makes my computer lag, and is causing errors. Anyone else having similar troubles or is it me only



All times are GMT +2. The time now is 00:49.


Powered by vBulletin®
Copyright ©2000 - 2024, 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 ©2024 elitepvpers All Rights Reserved.