Nesaugo SQL

[PWN]

Sveiki, forumiečiai norėčiau paklausti kas blogai galėtu buti šitam kur sukuriau, sukuriu saugojima kaip ir pawno suvedžiu tačiau nesaugo nieko.

 

CREATE TABLE IF NOT EXISTS `rangai` (
  `darbas` varchar(50) NOT NULL,
  `rangas` varchar(70) CHARACTER SET utf8 NOT NULL,
  `rangas1` varchar(70) CHARACTER SET utf8 NOT NULL,
  `rangas2` varchar(70) CHARACTER SET utf8 NOT NULL,
  `rangas3` varchar(70) CHARACTER SET utf8 NOT NULL,
  `isvaizda` int(3) NOT NULL,
  `isvaizda1` int(3) NOT NULL,
  `isvaizda2` int(3) NOT NULL,
  `isvaizda3` int(3) NOT NULL,
  `alga` int(11) NOT NULL,
  `alga1` int(11) NOT NULL,
  `alga2` int(11) NOT NULL,
  `alga3` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

18:47:27] CMySQLHandler::Query(SELECT * FROM `rangai` WHERE `darbas` = 'Policija') - An error has occured. (Error ID: 1146, Table 'awdawd.rangai' doesn't exist)

[miša.]

11 minutes prieš, EzTexas parašė:

Table 'awdawd.rangai' doesn't exist

Pazek ar ta db baze pajunges esi

[PWN]

[18:47:27] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "awdawd" | Username: "root" ...
[18:47:27] CMySQLHandler::Connect() - Connection was successful.

[miša.]

4 minutes prieš, EzTexas parašė:

[18:47:27] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "awdawd" | Username: "root" ...
[18:47:27] CMySQLHandler::Connect() - Connection was successful.

Parodyk pwne kaip atrodo sql_host ir tt

Parodyk server_log

Redaguota Spalio 8, 2018, nario L0cal

[PWN]

Dabar, L0cal parašė:

Parodyk pwne kaip atrodo sql_host ir tt

#define MySQL_HOST              "localhost"
#define MySQL_USER              "root"
#define MySQL_DATA              "awdawd"
#define MySQL_PASS              "*****"

[miša.]

1 minute prieš, EzTexas parašė:

#define MySQL_HOST              "localhost"
#define MySQL_USER              "root"
#define MySQL_DATA              "awdawd"
#define MySQL_PASS              "*****"

Leisk spet. Urpg gm?

[PWN]

Dabar, L0cal parašė:

Leisk spet. Urpg gm?

Nėra skirtumo koks gm, prašiau pagalbos su sql lentele 

[14:57:15] CMySQLHandler::Query(UPDATE `rangai` SET `rangas` = 'testing' WHERE `darbas` = 'Policija') - Successfully executed.
[14:57:20] >> mysql_query( Connection handle: 1 )
[14:57:20] CMySQLHandler::Query(UPDATE `rangai` SET `isvaizda` = '11' WHERE `darbas` = 'Policija') - Successfully executed.
[14:57:27] >> mysql_query( Connection handle: 1 )
[14:57:27] CMySQLHandler::Query(UPDATE `rangai` SET `alga` = '1' WHERE `darbas` = 'Policija') - Successfully executed.

dabar meta viskas gerai, bet mysqle rangai neišsaugo

Rakinkit tema susitvarkiau