sql

Hello, I had some depots in certain towns linked wrong and now a player has different items in different depots at the same city. Is there a SQL Query that would allow me to send all the items my players have from one depot to another? Example: I have 30 itens in the depot of town 1 and 50 in...

I am having a lot of trouble getting the server [7.72] OTHire 0.0.3 to work. All I need is for it to run locally with only my machine connected. I cant get the SQL to work and this is such a jungle to me. I have no previous experience in SQL however I do have some basic knowledge in...

Filme COD (int, pk) nome(varchar 20, not null) nascimento(datetime, not null) obs(tinybit, not null) obs2(int, fk, not null) I thought of something of the type create table filme ( COD int PRIMARY KEY AUTO_INCREMENT, nome varchar(200) NOT NULL, nascimento datetime NOT NULL, obs tinyint NOT...

Hi, well the title says pretty much what I need, I just downloaded a server in polish, and I want to change it to english, so everyone world wide can play easily, also im looking for some help with sql servers pretty basic stuffs.

Hello, I am searching for someone that can update my 8.4 server database to 10.98 server database. I have payed for several services already, JoeRod and Raggaer being the ones I worked together the most. Thanks for the atention, PM me if interested.

Hi, im looking for someone capable or interested in helping creating a 7.6 tf server, like the one Becks had many years ago, of course we want the server to be sql or so, or even the xml type, the only problem with the xml servers we have is that they have an automatic afk check system that we...

Hi, im looking for someone capable or interested in helping creating a 7.6 tf server, like the one Becks had many years ago, of course we want the server to be sql or so, or even the xml type, the only problem with the xml servers we have is that they have an automatic afk check system that we...

Hi, im looking for someone capable or interested in helping creating a 7.6 tf server, like the one Becks had many years ago, of course we want the server to be sql or so, or even the xml type, the only problem with the xml servers we have is that they have an automatic afk check system that we...

Hi OTLanders, I've got problem with making query that returns items count for backpacks of id what i need is getting pid of container, itemCount and correct itemtype I've used SELECT pid, COUNT(*) FROM player_items GROUP BY pid HAVING pid in (SELECT DISTINCT pid FROM player_items WHERE...

Hi, sorry for the dumb question, but I just cant get the number of rows returned by a select. I tried using while result.next(data) and it loops just two times, executing the same code in sql returns 4 rows. The following code prints "false". Does anyone know how to get that COUNT(*) ?? Any...

If you are testing a server locally and just looking to create a new account without having to setup an AAC, these 2 sql queries will do that for you. This is just to help you speed up your work flow :) The username and password is 1/1. 1st thing you want to do is create the account, go into...

Hi guys, Im looing for people who would join to our Project of Tibia Server. We offer you: - ~5€ for every finished job, - joining to our management, - great and funny team of 4 men with you, - stable job if u'll do what u have to :) - ur private ts3 Server, - mooooney $$$ =) How to? Step...

Hey. How I can add houses to the ZnoteACC? I tried adding house in RME but as I predicted, didnt work :P

Witam. Z Acc Makerem zostały mi już chyba tylko 2 małe problemy Pierwszy- spore opóźnienie w statusie postaci. Po włączeniu serwera i zalogowaniu się na konto trzeba było odczekać 10 min (może dlużej) żeby pojawił się status Online a po wyłączeniu serwera status Online zostaje w nieskończoność...

I am starting a server and i'm at the point where I need to make a character and log on. I am able to make the account but not the character. This message comes up every time I go to make the character. If used the account manager this same error comes up. please someone help me out or guide me...