• 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!

Windows Fucking bug , Rep++

SeRoN

SeRoN

Banned User
Joined
Feb 6, 2012
Messages
760
Reaction score
32
Location
when angels cry, when birds don't fly, When Blood
Guys !
i found this bug in my otserver !
this bug reload every 1,2 sec !
help guys rep +
20qxfut.jpg
 
Last edited:
Sort by date Sort by votes
Code: 
CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
Bam..
How to use: Go to your sql database, and execute this.
Precautions: Turn off the server first, then restart it when this is done.
Eg of sql database: If your on xampp, phpmyadmin, you get the drift, It can be accessed via local host.. 127.0.0.1/phpmyadmin
 
Upvote 0 Downvote
havoc still bugged

config
PHP: 
	sqlType = "sqlite"

errors in consle

PHP: 
[03/03/2012 12:04:10] >> Initializing game state modules and registering services...
[03/03/2012 12:04:11] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP ( SELECT houses.owner, houses.id as hid, houses.name as house_name ,players.name FROM houses
[03/03/2012 12:04:11]             LEFT JOIN players ON players.id=houses.owner
[03/03/2012 12:04:11]             LEFT JOIN accounts ON players.account_id=accounts.id
[03/03/2012 12:04:11]             WHERE players.lastlogin < (UNIX_TIMESTAMP() - 7*24*60*60)
[03/03/2012 12:04:11]                         AND	players.world_id =0)
[03/03/2012 12:04:11] > Global address: 127.0.0.1
[03/03/2012 12:04:11] > Local ports: 7171	7172	
[03/03/2012 12:04:11] >> All modules were loaded, server is starting up...
[03/03/2012 12:04:11] >>  server Online!

[03/03/2012 12:04:12] > Saving server...
[03/03/2012 12:04:13] > SAVE: Complete in 0.953 seconds using relational house storage.
[03/03/2012 12:04:13] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:35] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:46] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:05:08] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
 
Upvote 0 Downvote
Seron said:
havoc still bugged

config
PHP: 
	sqlType = "sqlite"

errors in consle

PHP: 
[03/03/2012 12:04:10] >> Initializing game state modules and registering services...
[03/03/2012 12:04:11] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such function: UNIX_TIMESTAMP ( SELECT houses.owner, houses.id as hid, houses.name as house_name ,players.name FROM houses
[03/03/2012 12:04:11]             LEFT JOIN players ON players.id=houses.owner
[03/03/2012 12:04:11]             LEFT JOIN accounts ON players.account_id=accounts.id
[03/03/2012 12:04:11]             WHERE players.lastlogin < (UNIX_TIMESTAMP() - 7*24*60*60)
[03/03/2012 12:04:11]                         AND	players.world_id =0)
[03/03/2012 12:04:11] > Global address: 127.0.0.1
[03/03/2012 12:04:11] > Local ports: 7171	7172	
[03/03/2012 12:04:11] >> All modules were loaded, server is starting up...
[03/03/2012 12:04:11] >>  server Online!

[03/03/2012 12:04:12] > Saving server...
[03/03/2012 12:04:13] > SAVE: Complete in 0.953 seconds using relational house storage.
[03/03/2012 12:04:13] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:35] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:46] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:04:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
[03/03/2012 12:05:08] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';)
Click to expand...
If you don't know the basics.. it aint my fault..
Make a database, make sure it's linked to the server,
change sqlite to "mysql"
 
Upvote 0 Downvote
Configurate your config.lua correctly.. with the MySQL password, database, user, and host.

Code: 
        sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "x"
	sqlDatabase = "x"
 
Upvote 0 Downvote
Seron said:
i change it to mysqle
i get this error when i open console
PHP: 
[03/03/2012 12:22:17] > ERROR: Couldn't estabilish connection to SQL database!
Click to expand...

Bro.. this isn't a bug, no offense but it's your own stupidity... you don't just download a server.. click one button and BAM!
check a guide on how to create a server.. I gave you the answer to your PROBLEM, now your going in to totally new problems that are so simple, you shouldn't ask them here but figure them out yourself
 
Upvote 0 Downvote
Download xampp.
uphold security, make a database, add tables, add what I said, put the pass you choose in there, and the name of the database in database name.. sqltype =mysql.. gz.
 
Upvote 0 Downvote
Havoc said:
Download xampp.
uphold security, make a database, add tables, add what I said, put the pass you choose in there, and the name of the database in database name.. sqltype =mysql.. gz.
Click to expand...

Xampp is not a php service, is only for testing, USe Uniserv.

You are new in this, there's a lot of tutos...
Use search function..
There's tutos for almost all things that you need for a server..
 
Upvote 0 Downvote
Seron said:
guys , i wanna make sqlType = "sqlite"
and fix table bugged !!
wanna help
Click to expand...

Are you stupid? You don't know nothing, and you whant a help, you don't need a help, you need some one to do it for you.

I'll make you a short tuto for help you a bit.

Download this, is a Sqlite Studio, it's for edit characters like putting acces = 6 a God.
SQLiteStudio

Download the source files from here.
http://otland.net/f18/8-60-otserv-0-6-3-r-6052-a-129322/

Download Stians repack and compile it, Look for a tuto "search function"
 
Upvote 0 Downvote
Back
Top