PDA

View Full Version : Erro ao logar no painel do Musite



vinybronks
28/09/2017, 07:58 PM
Como resolvo esses erros ?

Warning: mssql_query() [function.mssql-query ([Only registered and activated users can see links])]: message: Nome de coluna 'points' inv�lido. (severity 16) in C:\AppServ\[Only registered and activated users can see links] ss.php on line 48

Warning: mssql_query() [function.mssql-query ([Only registered and activated users can see links])]: Query failed in C:\AppServ\[Only registered and activated users can see links] ss.php on line 48
LD_Error: Não foi possivel executar: SELECT points as amount FROM MuOnline.dbo.webCash WHERE username='vinytoso'
Warning: mssql_fetch_object(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\[Only registered and activated users can see links] .class.php on line 386

andredeco
28/09/2017, 08:02 PM
Como resolvo esses erros ?

Warning: mssql_query() [function.mssql-query ([Only registered and activated users can see links])]: message: Nome de coluna 'points' inv�lido. (severity 16) in C:\AppServ\[Only registered and activated users can see links] ss.php on line 48

Warning: mssql_query() [function.mssql-query ([Only registered and activated users can see links])]: Query failed in C:\AppServ\[Only registered and activated users can see links] ss.php on line 48
LD_Error: Não foi possivel executar: SELECT points as amount FROM MuOnline.dbo.webCash WHERE username='vinytoso'
Warning: mssql_fetch_object(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\[Only registered and activated users can see links] .class.php on line 386




Crie a coluna points na webCash.

vinybronks
28/09/2017, 08:20 PM
Obrigado resolveu o amigo no otro topico disse pra criar a coluna points na memb_info por isso não tava indo '-'

Tenho outra duvida como adiciono cash e vip pelo site ?


[Only registered and activated users can see links]
*/
$TABLES_CONFIGS['WEBVIPS'] = array("database" => DATABASE, //webSite || MuOnline
"table" => "webVips", //webVips || MEMB_INFO
"columnUsername" => "username", //username || memb___id
"columnType" => "type", //type || vip
"columnDateBegin" => "dateBegin",
"columnDateEnd" => "dateEnd",
"columnDateEndInteger" => "dateEndInteger");

$TABLES_CONFIGS['WEBCASH'] = array("database" => DATABASE, //webSite || MuOnline
"table" => "webCash", //webCash || MEMB_INFO
"columnUsername" => "username", //username || memb___id
"columnAmount" => "amount", //amount || gold
"columnAmount2" => "amount2", //amount2 || gold2
"columnPoints" => "points"); //points

andredeco
28/09/2017, 08:30 PM
Obrigado resolveu o amigo no otro topico disse pra criar a coluna points na memb_info por isso não tava indo '-'

Tenho outra duvida como adiciono cash e vip pelo site ?


[Only registered and activated users can see links]
*/
$TABLES_CONFIGS['WEBVIPS'] = array("database" => DATABASE, //webSite || MuOnline
"table" => "webVips", //webVips || MEMB_INFO
"columnUsername" => "username", //username || memb___id
"columnType" => "type", //type || vip
"columnDateBegin" => "dateBegin",
"columnDateEnd" => "dateEnd",
"columnDateEndInteger" => "dateEndInteger");

$TABLES_CONFIGS['WEBCASH'] = array("database" => DATABASE, //webSite || MuOnline
"table" => "webCash", //webCash || MEMB_INFO
"columnUsername" => "username", //username || memb___id
"columnAmount" => "amount", //amount || gold
"columnAmount2" => "amount2", //amount2 || gold2
"columnPoints" => "points"); //points

Para o Cash vc configura o arquivo settings.php com as tabelas do server que está usando, acredito que seja algum MuEmu. Para o Vip, se for MuEmu mesmo, vc terá de fazer um certo procedimento devido a incompatibilidade. Vou achar o tópico aqui e já edito este.

EDIT:
[Only registered and activated users can see links]

Siga este tópico acima para sincronizar corretamente o Vip com o site e assim poder adicionar os vips.

vinybronks
28/09/2017, 11:34 PM
Muito bom cara ajudou muito .. e sobre os cash , gold é mesma coisa ?

andredeco
28/09/2017, 11:49 PM
Muito bom cara ajudou muito .. e sobre os cash , gold é mesma coisa ?

Para as moedas é mais simples. Você vai apenas colocar o nome das tabelas e colunas no arquivo settings.php.