[Bapestar]

Do you know what causes the sit/lay error? is it my dcrs? or my db? if dcrs can you pls post a link
and thanks mate everything works perfectly other than that!

[NitroHabbz]

Quote: Originally Posted by Goodwill

V23 is shit i have V24 dcr this server is V24..

FYI. its V22/V23/V24

V25 and V26 Will come in the near future

[cecer1]

Quote: Originally Posted by Bapestar

Do you know what causes the sit/lay error? is it my dcrs? or my db? if dcrs can you pls post a link
and thanks mate everything works perfectly other than that!

It is the database but I do not know what causes it (It might be the server I started off with).

[Bapestar]

Right,
Well i'll wait for your next release or fix since i love this source is hella clean i also noticed that guides are disabled! Good luck mate, thumbs_up!

[NitroHabbz]

Quote: Originally Posted by Bapestar

Right,
Well i'll wait for your next release or fix since i love this source is hella clean i also noticed that guides are disabled! Good luck mate, thumbs_up!

Cecer1 and me discussed guide support not long ago and decided against it, Guide tool in a retro is useless unless you have hundreds of users online like open hotel and Holo Hotel

The next release should have a few more bugs fixed. The Goal is to stabilize each version up to the latest V27. if v27 can be done

[cecer1]

If you really want guides send me a PM explain why it is needed (I want a good reason not because it is cool) and I might code it

[vista4life]

the v27 can be done you need to host the sec.cct and the code in the DU packet if you need more info just pm and nice work:)^_^ i think this is the best source ever btw i add the landscape in in this source i will release the code soon but first the sit tags and select swimming outfit etc

(v26 stuff) the badge shizzle

sendData("Ft" + "SHJIACH_Graduate1" + Convert.ToChar(2) + "PAIACH_Login1" + Convert.ToChar(2) + "PAJACH_Login2" + Convert.ToChar(2) + "PAKACH_Login3" + Convert.ToChar(2) + "PAPAACH_Login4" + Convert.ToChar(2) + "PAQAACH_Login5" + Convert.ToChar(2) + "PBIACH_RoomEntry1" + Convert.ToChar(2) + "PBJACH_RoomEntry2" + Convert.ToChar(2) + "PBKACH_RoomEntry3" + Convert.ToChar(2) + "SBRAACH_RegistrationDuration6" + Convert.ToChar(2) + "SBSAACH_RegistrationDuration7" + Convert.ToChar(2) + "SBPBACH_RegistrationDuration8" + Convert.ToChar(2) + "SBQBACH_RegistrationDuration9" + Convert.ToChar(2) + "SBRBACH_RegistrationDuration10" + Convert.ToChar(2) + "RAIACH_AvatarLooks1" + Convert.ToChar(2) + "IJGLB" + Convert.ToChar(2) + "IKGLC" + Convert.ToChar(2) + "IPAGLD" + Convert.ToChar(2) + "IQAGLE" + Convert.ToChar(2) + "IRAGLF" + Convert.ToChar(2) + "ISAGLG" + Convert.ToChar(2) + "IPBGLH" + Convert.ToChar(2) + "IQBGLI" + Convert.ToChar(2) + "IRBGLJ" + Convert.ToChar(2) + "SAIACH_Student1" + Convert.ToChar(2) + "PCIHC1" + Convert.ToChar(2) + "PCJHC2" + Convert.ToChar(2) + "PCKHC3" + Convert.ToChar(2) + "PCPAHC4" + Convert.ToChar(2) + "PCQAHC5" + Convert.ToChar(2) + "QAIACH_GamePlayed1" + Convert.ToChar(2) + "QAJACH_GamePlayed2" + Convert.ToChar(2) + "QAKACH_GamePlayed3" + Convert.ToChar(2) + "QAPAACH_GamePlayed4" + Convert.ToChar(2) + "QAQAACH_GamePlayed5" + Convert.ToChar(2));
sendData("Dt" + "IH" + Convert.ToChar(1) + "FCH");

[goldboy77]

vista4life are you dutch?

[vista4life]

Quote: Originally Posted by cecer1

If you really want guides send me a PM explain why it is needed (I want a good reason not because it is cool) and I might code it

i just need it because i have more then 100+ users online and i like to work with ah good server:) if you don't make the guides why we started then? :P

Quote: Originally Posted by goldboy77

vista4life are you dutch?

Yes i'm from holland it's it my english i know it's crap but stay on the topic plz ^_^

a new code for you guys goodluck with it

PHP Code:

                        case "D":
                            {
                                try
                                {
                                    virtualUser Target = userManager.getUser(DB.Stripslash(currentPacket.Substring(4)));
                                    if (Target._Rank > 3)
                                        return;
                                    DB.runQuery("INSERT INTO user_ignores(userid,targetid) VALUES ('" + userID + "','" + Target.userID + "')");
                                    ignoreList.Add(Target.userID);
                                    sendData("FcI");
                                }
                                catch { }
                                break;
                            }

                        case "EB":
                            {
                                try
                                {
                                    virtualUser Target = userManager.getUser(DB.Stripslash(currentPacket.Substring(4)));
                                    if (Target._Rank > 3)
                                        return;
                                    DB.runQuery("DELETE FROM user_ignores WHERE userid = '" + userID + "' AND targetid = '" + Target.userID + "'");
                                    ignoreList.Remove(Target.userID);
                                    sendData("FcK");
                                }
                                catch { }
                                break;
                            } 


[goldboy77]

ik ook maar mag ik je wat vragen

[vista4life]

Quote: Originally Posted by goldboy77

ik ook maar mag ik je wat vragen

yes sure but don't spam this topic pm me :)

[NitroHabbz]

Quote: Originally Posted by vista4life

yes sure but don't spam this topic pm me :)

Release the MYSQL Table for those codes you posted?

[MYCHEMICALSELF]

Quote: Originally Posted by VashMaster

@ cecer1: Yes, the CMS is running even faster than before ;)

@ mychemicalself: Yeah, the server is sometimes running fine for 3 minutes without one message, and sometimes even 1 minute full of those messages.. Maybe it gas something to do with the amount of users online? Nillus also wtf'ed at this one..

Quick sugestion up your maximum MySQL connections by 100 or so
then increse the buffer in size and see if that changes it for the effects to happen the mysql server will need to be restarted :P

[Goodwill]

Does anyone have a good catalogue for this? My catalogue is crap ;l

[cecer1]

PATCH

This will fix a possible DB connection leak.

In virtualUser.cs replace:

PHP Code:

                        case "@f": // Messenger - decline friendrequests
                            {
                                if (Messenger != null)
                                {
                                    int Amount = Encoding.decodeVL64(currentPacket.Substring(3));
                                    currentPacket = currentPacket.Substring(Encoding.encodeVL64(Amount).Length + 3);

                                    Database dbClient = new Database(true, false, 144);
                                    //if(Amount == 1)
                                    //    dbClient.runQuery("DELETE FROM messenger_friendrequests WHERE userid_to = '" + this.userID + "' AND requestid = '" + requestID + "' LIMIT 1");
                                    for (int i = 0; i < Amount; i++)
                                    {
                                        if (currentPacket == "")
                                            return;

                                        int requestID = Encoding.decodeVL64(currentPacket);
                                        dbClient.runQuery("DELETE FROM messenger_friendrequests WHERE userid_to = '" + this.userID + "' AND requestid = '" + requestID + "' LIMIT 1");
                                        currentPacket = currentPacket.Substring(Encoding.encodeVL64(requestID).Length);
                                    }
                                    dbClient.Close();
                                }
                                break;
                            } 


With this

PHP Code:

                        case "@f": // Messenger - decline friendrequests
                            {
                                if (Messenger != null)
                                {
                                    int Amount = Encoding.decodeVL64(currentPacket.Substring(3));
                                    currentPacket = currentPacket.Substring(Encoding.encodeVL64(Amount).Length + 3);

                                    Database dbClient = new Database(true, false, 144);
                                    for (int i = 0; i < Amount; i++)
                                    {
                                        if (currentPacket == "")
                                        {
                                            dbClient.Close();
                                            return;
                                        }
                                        int requestID = Encoding.decodeVL64(currentPacket);
                                        dbClient.runQuery("DELETE FROM messenger_friendrequests WHERE userid_to = '" + this.userID + "' AND requestid = '" + requestID + "' LIMIT 1");
                                        currentPacket = currentPacket.Substring(Encoding.encodeVL64(requestID).Length);
                                    }
                                    dbClient.Close();
                                }
                                break;
                            } 


And recompile

[allard100]

Tank you! The fix works

EDIT:
I have this error:

[Goodwill]

Banning with the MOD tool = disconnect.

EDIT:
Some times is the database connection crashing:
12:29:59:728] [gameSocketServer.freeConnection] » Flagged connection [31] as free.
[12:29:59:753] [userManager.removeUser] » User [260] disconnected.
[12:29:59:756] [gameSocketServer.freeConnection] » Flagged connection [7] as free.
[12:30:09:375] [gameSocketServer.connectionRequest] » Accepted connection [7] from ***
[12:30:09:647] [virtualRoom.cycleStatuses] » De objectverwijzing is niet op een exemplaar van een object ingesteld.
[DATABASE ERROR] => Connection unexpectedly terminated.
[DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
[12:30:14:198] [Database.getTable] » Database connection not active
[DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
[12:30:14:204] [Database.getTable] » Database connection not active
[DATABASE ERROR] => Connection unexpectedly terminated.
[DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
[12:30:17:196] [[12:30:17:198] [Database.getTableDatabase.getString] » ] » Database connection not active
Database connection not active
[12:30:17:200] [Database.runQuery] » Database connection not active
[DATABASE ERROR] => [DATABASE ERROR] => [DATABASE ERROR] => [DATABASE ERROR] => [DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Conne
ction unexpectedly terminated.
FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
Connection unexpectedly terminated.
FAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
[12:30:22:486] [[12:30:22:488] [[12:30:22:487] [Database.getStringDatabase.runQuery[12:30:22:492] [Database.findsResult] » Database.run
Query] » ] » ] » Database connection not active
Database connection not active
Database connection not active
[12:30:22:499] [[DATABASE ERROR] => Database connection not active
Database.runQueryFAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
[12:30:22:504] [[12:30:22:503] [Database.runQuery] » Database connection not active
roomManager.removeRoom] » Database connection not active
] » Room [4748, publicroom: false] destroyed.
[12:30:22:559] [virtualRoom.Finalize] » .
[DATABASE ERROR] => Connection unexpectedly terminated.
[DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
[12:30:23:198] [Database.findsResult] » Database connection not active
[DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
[12:30:23:204] [Database.getTable] » Database connection not active
[DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
[DATABASE ERROR] => [DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
[12:30:23:213] [FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
[DATABASE ERROR] => Database.getRow[DATABASE ERROR] => [DATABASE ERROR] => ] » FAILED TO SAVE ERROR TO FILE: Connection unexpectedly te
rminated.
[12:30:23:216] [FAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
[12:30:23:215] [Database.getTable[12:30:23:221] [userManager.removeUser] » ] » Database connection not active
Database connection not active
[DATABASE ERROR] => [DATABASE ERROR] => [DATABASE ERROR] => [DATABASE ERROR] => FAILED TO SAVE ERROR TO FILE: Connection unexpectedly t
erminated.
FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
FAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
Database.runQuery[DATABASE ERROR] => ] » FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
FAILED TO SAVE ERROR TO FILE: Reading from the stream has failed.
FAILED TO SAVE ERROR TO FILE: Connection unexpectedly terminated.
User [52] disconnected.
[12:30:23:234] [[12:30:23:235] [Database connection not active
[12:30:23:239] [[12:30:23:243] [Database.runQueryDatabase.getTableDatabase.getTabl eDatabase.getTable] » [12:30:23:244] [] » [12:30:23:2
44] [] » ] » Database.findsResultDatabase connection not active
Database connection not active
gameSocketServer.freeConnection] » Database connection not active
Database connection not active
Database connection not active
] » Flagged connection [91] as free.
[12:30:23:331] [Database.runQuery] » Database connection not active

And with like 5seconds is the connection back.

- Goodwill

[cecer1]

Quote: Originally Posted by allard100

Tank you! The fix works

EDIT:
I have this error:

I will look into it after I fix this possible security hole.

EDIT 2:
Did you empty your furniture table but not your furniture_moodlight table?
If so then that could be the problem... I can't see any other cause as it only runs that query when you buy a moodlight.




EDIT 1:
Ok here is the new code.
URGENT UPDATE
I recommend doing this ASAP as it has now been released and may be exploited.

Replace:

PHP Code:

                        case "C~": // Sound machine - burn song to disk
                            {
                                if (_isOwner && Room != null && Room.floorItemManager.soundMachineID > 0)
                                {
                                    int songID = Encoding.decodeVL64(currentPacket.Substring(2));
                                    Database dbClient = new Database(true, false, 123);
                                    if (_Credits > 0 && dbClient.findsResult("SELECT id FROM soundmachine_songs WHERE id = '" + songID + "' AND userid = '" + userID + "' AND machineid = '" + Room.floorItemManager.soundMachineID + "'"))
                                    {
                                        DataRow dRow = dbClient.getRow("SELECT title, length FROM soundmachine_songs WHERE id = '" + songID + "'");
                                        string Status = Encoding.encodeVL64(songID) + _Username + "\n" + DateTime.Today.