[Jake Canfield]

Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get.

Код:

[11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist
[11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist

Please help me.

[Eazy_Efolife]

Quote:

Originally Posted by Jake Canfield Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get. Код: [11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist [11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist Please help me.

You didnt create your tables. In the database

[Jake Canfield]

Quote:

Originally Posted by Compton's Eazy E Quote: Originally Posted by Jake Canfield Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get. Код: [11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist [11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist Please help me. You didnt create your tables. In the database

On the xampp.com thing?

[Eazy_Efolife]

Quote:

Originally Posted by Jake Canfield Quote: Originally Posted by Compton's Eazy E Quote: Originally Posted by Jake Canfield Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get. Код: [11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist [11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist Please help me. You didnt create your tables. In the database On the xampp.com thing?

I use Wamp so I don't know much about xampp. You should create the tables in the Phpmyadmin

[Jake Canfield]

Quote:

Originally Posted by Compton's Eazy E Quote: Originally Posted by Jake Canfield Quote: Originally Posted by Compton's Eazy E Quote: Originally Posted by Jake Canfield Hello there I have just recently changed my [GM] to QBase with MySQL and when I run my server and I join the server shuts down and close's. And when I go into the server.log this is what I get. Код: [11:04:18] Error in mysql_query: Table 'samp.players' doesn't exist [11:04:18] Error in mysql_store_result: Table 'samp.players' doesn't exist Please help me. You didnt create your tables. In the database On the xampp.com thing? I use Wamp so I don't know much about xampp. You should create the tables in the Phpmyadmin

So in my database samp i create a table mysql_query and mysql_store_result then add samp.players in there?

[Eazy_Efolife]

No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...

[Jake Canfield]

Quote:

Originally Posted by Compton's Eazy E No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc...

Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad

[Eazy_Efolife]

Quote:

Originally Posted by Jake Canfield Quote: Originally Posted by Compton's Eazy E No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc... Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad

lol so much angry faces :P. Look through a mysql database and learn from the code, like I did.

[Jake Canfield]

Quote:

Originally Posted by Compton's Eazy E Quote: Originally Posted by Jake Canfield Quote: Originally Posted by Compton's Eazy E No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc... Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad lol so much angry faces :P. Look through a mysql database and learn from the code, like I did.

Alright man thanks for the help!

[Eazy_Efolife]

Quote:

Originally Posted by Jake Canfield Quote: Originally Posted by Compton's Eazy E Quote: Originally Posted by Jake Canfield Quote: Originally Posted by Compton's Eazy E No you need to learn how to code MYSQL, ex: Makeing Tables and making player files etc... Ermm how exactly can I do that to figure out how to? This is very complicated for me. It's making me mad lol so much angry faces :P. Look through a mysql database and learn from the code, like I did. Alright man thanks for the help!

Here learn from this code I made for my old DM server.

Код:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;# MySQL returned an empty result set (i.e. zero rows).
/*!40103 SET TIME_ZONE='+00:00' */;# MySQL returned an empty result set (i.e. zero rows).
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;# MySQL returned an empty result set (i.e. zero rows).
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;# MySQL returned an empty result set (i.e. zero rows).
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;# MySQL returned an empty result set (i.e. zero rows).
DROP TABLE IF EXISTS `players`;# MySQL returned an empty result set (i.e. zero rows).

SET @saved_cs_client   = @@character_set_client;# MySQL returned an empty result set (i.e. zero rows).

SET character_set_client = utf8;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE `players` (
 `id` int(11) NOT NULL auto_increment,
 `Name` varchar(50) collate latin1_general_ci NOT NULL,
 `Password` varchar(50) character set latin1 collate latin1_bin NOT NULL,
 `Level` int(11) NOT NULL default '1',
 `AdminLevel` int(11) NOT NULL default '0',
 `Moderator` int(11) NOT NULL default '0',
 `Cash` bigint(20) NOT NULL default '5000',
 `Muted` int(11) NOT NULL default '0',
 `VIP` int(11) NOT NULL default '0',
`Exp` int(11) NOT NULL default '0',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;# MySQL returned an empty result set (i.e. zero rows).

SET character_set_client = @saved_cs_client;# MySQL returned an empty result set (i.e. zero rows).


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;# MySQL returned an empty result set (i.e. zero rows).


/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;# MySQL returned an empty result set (i.e. zero rows).

Lol it looks like a bunch a letters I know but just try your best to learn from that like I did :P