• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[10.77][TFS 1.2] ORTS, a real map project

Wartio said:
Humm.. i pasted this code in phpmyadmin

Code: 
INSERT INTO `players` VALUES(0, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 0, 0, 0, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(1, 'Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(2, 'Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(3, 'Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);
INSERT INTO `players` VALUES(4, 'Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 32369, 32238, 7, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0);

I got some errors when i tried to insert this code, but i searched on google/otland for a solution, so good luck :)
Click to expand...


May i take a wild guess that it was something along the lines of this?

Code: 
SQL query:

INSERT INTO `players`
VALUES ( 0, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 0, 0, 0, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

I both googled and searched, no luck. Maybe if you have the patience and time you can describe how to fix it.. Thanks in any case, you got me further into the ACC than before.
 
Extrodus said:
Yeah, this is when error comes up. People try to do like real tibia hi > deposit all > yes and we get error in console ;\
Click to expand...
ill make it tomorrow. g2g now.
 
Who could compile me the engine under windows XP 32 bit? Error pops up that this application is not a valid win32 application I tried to do it myself, but I can not. I would be very grateful if someone did, and threw me a link to download.

Please and thank you in advance. Sorry for my english
 
if you have gotten gesior to work, have you created an account and went to your account page? show pic?
 
Rickolajten said:
May i take a wild guess that it was something along the lines of this?

Code: 
SQL query:

INSERT INTO `players`
VALUES ( 0, 'Rook Sample', 0, 1, 1, 1, 0, 185, 185, 0, 44, 44, 44, 44, 128, 0, 0, 35, 35, 0, 100, 1, 0, 0, 0, '', 420, 1, 0, 0, 1, 0, 0, 0, '', 0, 0, 0, 151200000, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1287582995, 1, '', 1, '', 0, 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

I both googled and searched, no luck. Maybe if you have the patience and time you can describe how to fix it.. Thanks in any case, you got me further into the ACC than before.
Click to expand...

Try to insert this code,

Code: 
INSERT INTO `players` (`name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`) VALUES
('Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Sorcerer Sample', 0, 1, 1, 8, 1, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Druid Sample', 0, 1, 1, 8, 2, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Paladin Sample', 0, 1, 1, 8, 3, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.'),
('Knight Sample', 0, 1, 1, 8, 4, 185, 185, 4200, 0, 0, 0, 0, 110, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 440, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, 'This player has no comment at this moment.');

let me know if you get any errors
 
If anyone figures out how to get guild wars working on Znote or Gesior please post your fixes!
 
Try to invite a guild to guild war, this is the feature I am looking for. I have znote working flawless except guild war.
 
Extrodus said:
Try to invite a guild to guild war, this is the feature I am looking for. I have znote working flawless except guild war.
Click to expand...

If you are talking about the guild war system with "green/red/blue" emblems then, no i have not that added, its easy to download and add it into the server , have you tried to do that?
 
TFS 1.0 already has the guild war system, we need a website application that can send and accept guild war invitations to use the systems though since they no longer use in-game commands. With this being said, I will repeat.. if anyone gets znote or gesior guild wars working for 1.0 please post your fixes to the files so we can use it too!
 
tytanek said:
Who could compile me the engine under windows XP 32 bit? Error pops up that this application is not a valid win32 application I tried to do it myself, but I can not. I would be very grateful if someone did, and threw me a link to download.

Please and thank you in advance. Sorry for my english
Click to expand...

Dude, please help ! I need this data.
Rep for helper !
 
Does anyone have a fix for the paladin distance skill going up insanely fast?
 
Hmm, seems to be fixed if I don't set skills above 30x; when set at 50x skills; distance on pally is super fast while all the other skills are normal for every other voc.
 
Exodus, we got a 6gb RAM, 4x3.2ghz server, how many people do you think that'll hold on a realmap server?
 
That will host the real map server, that doesn't determine how many players you can hold. Your Network Connection determines how many players you can hold. If you have a 100MBPS connection, you can probably host 100-200 players with no huge lag issues. If you have a 1GBPS connection you can easily handle 1000+ players.
 

Similar threads

J
Team [tfs 1.5 - orts]Need testers for a 8.6 global map
Replies
2
Views
813
cs007
cs007
Shiris undrin
[8.60] [TFS 1.2] -[Real Map full] with mount & market system
3 4 5
Replies
94
Views
10K
Zatjin
Zatjin
Back
Top