• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Help, Player spawn

R

Rafaelbode

New Member
Joined
Jul 23, 2012
Messages
6
Reaction score
0
I'm brazilian, I'll try to explain in english...

The script "config.lua" return the position of my char when I create it... :

" -- Account manager
accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 1591
newPlayerSpawnPosY = 613
newPlayerSpawnPosZ = 7
newPlayerTownId = 11
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = false"


BUT... How/Where can I change the place that I'll go when my char die??

Thanks...
 
Sort by date Sort by votes
SQLITE:
open SQLITE Studio; open tables search POS x y z and edit positions player..

Yes you use SQL need enter Phpmyadmin goto SQL and use this query:
SQL: 
UPDATE players SET posx = 1591, posy = 613, posz = 7;
Don't works are town bad.. try use this you need HAVE OFFLINE your ot for execute query:
SQL: 
UPDATE players SET town_id =  1;
or 2, 3, etc.. go see in your RME - Map editor, what town are you and need edit config.php where town create character..
 
Upvote 0 Downvote
@up
read.. i updated

SQLITE:
open SQLITE Studio; open tables search POS x y z and edit positions player..
posx = 1591, posy = 613, posz = 7
 
Upvote 0 Downvote
Cronox said:
SQLITE:
open SQLITE Studio; open tables search POS x y z and edit positions player..

Yes you use SQL need enter Phpmyadmin goto SQL and use this query:
SQL: 
UPDATE players SET posx = 1591, posy = 613, posz = 7;
Don't works are town bad.. try use this you need HAVE OFFLINE your ot for execute query:
SQL: 
UPDATE players SET town_id =  1;
or 2, 3, etc.. go see in your RME - Map editor, what town are you and need edit config.php where town create character..
Click to expand...

I found Pos X Y and Z in tables.. =)

But what did you mean sayng those things about SQL Code??
WHere can I saw it on my computer?

Thanks a lot
 
Upvote 0 Downvote
You only need
open SQLITE Studio - Open - Select your database..
open tables, now go table players - search account manager goto -->
and are 3..
pos x pos y and po z
need edit positions each and works.. need offline your ot for edit
 
Upvote 0 Downvote
I changed... but now when I run the "forgotten server" appears this:

[23/07/2012 18:31:46] >> Running Database Manager
[23/07/2012 18:31:46] > Trigger: oncreate_players does not exist, creating it...
[23/07/2012 18:31:46] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "INSERTON": syntax error (CREATE TRIGGER "oncreate_players"AFTER INSERTON "players"BEGIN INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 0, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 1, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 2, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 3, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 4, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 5, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 6, 10);END;)
[23/07/2012 18:31:46] > Trigger: ondelete_players does not exist, creating it...
[23/07/2012 18:31:46] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "DELETEON": syntax error (CREATE TRIGGER "ondelete_players"BEFORE DELETEON "players"FOR EACH ROWBEGIN SELECT RAISE(ROLLBACK, 'DELETE on table `players` violates foreign: `ownerid` from table `guilds`') WHERE (SELECT "id" FROM "guilds" WHERE "ownerid" = OLD."id") IS NOT NULL; DELETE FROM "account_viplist" WHERE "player_id" = OLD."id"; DELETE FROM "player_viplist" WHERE "player_id" = OLD."id" OR "vip_id" = OLD."id"; DELETE FROM "player_storage" WHERE "player_id" = OLD."id"; DELETE FROM "player_skills" WHERE "player_id" = OLD."id"; DELETE FROM "player_items" WHERE "player_id" = OLD."id"; DELETE FROM "player_depotitems" WHERE "player_id" = OLD."id"; DELETE FROM "player_spells" WHERE "player_id" = OLD."id"; DELETE FROM "player_killers" WHERE "player_id" = OLD."id"; DELETE FROM "player_deaths" WHERE "player_id" = OLD."id"; DELETE FROM "guild_invites" WHERE "player_id" = OLD."id"; DELETE FROM "bans" WHERE "type" IN (2, 5) AND "value" = OLD."id"; UPDATE "houses" SET "owner" = 0 WHERE "owner" = OLD."id";END;)
[23/07/2012 18:31:46] > Trigger: oninsert_players does not exist, creating it...
[23/07/2012 18:31:46] > Trigger: onupdate_players does not exist, creating it...
 
Upvote 0 Downvote
Goto distributions otservers in downloads, and download otserv same version changed theforgottenserver.s3db
its database for SQlite
 
Upvote 0 Downvote
When you run the command in php 'UPDATE players SET town_id = 1;" all players and even VIPs will be sent to the main town of the same? Ex.: 1945 641 9 ? (main)
 
Upvote 0 Downvote
Back
Top