Printable View
Everything is working fine, and other people can connect.
Also, it shows who is online, and when the server is online correctly, but when you try and create an account you get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479
[PHP]<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.
Original Creation by mirage666 for MaNGOS http://pomm.da.ru/
Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="****"; // PASS for Logonserver database
$dbr="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...
Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '
Well.. What do I fill in where the database is located when it is located on my comp?
Please help!!
~yupdead
[quote=Paco44;3094108][php]<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.
Original Creation by mirage666 for MaNGOS http://pomm.da.ru/
Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="****"; // PASS for Logonserver database
$dbr="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...
Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '
Thanks rr2739, im trying it now.
btw, did you get my PM? Any luck with that...
Ok, i have set it up on some free webhosting i have, and its not giving the error anymore, but now it says that creating the account was not possible.
Can you goto Raw Unleashed WoW Server - Provided by ziddy1232 is offline and check it
lol ok, i know that problem as well.. EXPERIENCE FTWQuote:
Originally Posted by ziddy1232
so this is what u do
open your SQ!lyog or Navicat..
click on USERS
and add another user with the following info:
where it says HOST: put %
where u see username: put same user name u use for your MYSQL
and same goes for password. Username and pass must match your root user name and password
in section where it ask for hostm u only should have %
so host: %
user: same as MYSQl
pass: Same as MYSQl
now it will work!
P>S make sure to grant all permissions for the user you created
Or not...Quote:
Originally Posted by rr2739
http://img170.imageshack.us/img170/4...9456xb6.th.jpg
Quote:
Originally Posted by ziddy1232
ok you doing something wrong
since you using SQlyog ill post a guide how to add % host
her eis how:
1. Click on TOOLS (on top of your screen in Sqlyog)
2. then scroll over USER MANAGER
3. Then Select ADD USER
you will see a little window pop up
a. you will see
username
host
password
retype password
so
username - same as your MYSQL root
host - %
password: same as u use for Mysql
then on the bottom you will see a button called SELECT ALL , click that
then press create
and you done.
I did that, got the same error...
I think its because i already have that user created, and it has all permissions.
BUT, i still cant create an account - get the same error as before.
New link: Raw Unleashed WoW Server - Provided by ziddy1232 is offline
which NCDB u using and do you have MUTED collumn in your accounts table?Quote:
Originally Posted by ziddy1232
btw, the site is hosted on an external web server now, NOT on my system using WAMP.
Im pritty sure "%" is for localhost
its actualy for external hosts.. so they can access ur dbQuote:
Originally Posted by ziddy1232
i want to find out if you using latest NCDB and do you have MUTED?
if so..i will reprogram something quick for ya. to see if it works
I do have the Muted collumn
And to be honest, im not sure which im using... How can i find out?
Quote:
Originally Posted by ziddy1232
ok since you using my website includes..
you should have a folder called INCLUDE. inside that folder there is a file called include.php
so here is my edited one that works with muted..
(delet eur original include file, and replace it with this one)
include.zip - 5.1 Kb
Nope, i replaced it and im still getting the same error...
Im pritty sure its something simple im doing wrong, but it doesnt seem to have a simple solution.
can you tell me the values of your account table plzQuote:
Originally Posted by ziddy1232
like maybe u can link your table. i need to see that variables in your table. i am now jinxed with this problem :)
example
muted int 30 NULL OR NOT
i am using the same php files as you have downloaded
http://www.cosanostragame.com
Heres a screenshot of my accounts table, as far as i know its fine...
http://img135.imageshack.us/img135/5...7408xe9.th.jpg
muHHAA sorryQuote:
Originally Posted by ziddy1232
i need to see what you have in YOUR OBJECTS TAB
so on the same screen as you ar enow, click 1 time on objects and link screenie
This is everything that was on the Objects tab:
PHP Code:/*Column Information For - character.accounts*/
-----------------------------------------------
Field Type Collation Null Key Default Extra Privileges Comment
------------- ------------------- --------------- ------ ------ ------------------- -------------- ------------------------------- -------
acct bigint(20) unsigned (NULL) NO PRI (NULL) auto_increment select,insert,update,references
login varchar(255) utf8_unicode_ci NO PRI select,insert,update,references
password varchar(28) utf8_unicode_ci NO select,insert,update,references
gm varchar(27) utf8_unicode_ci NO select,insert,update,references
banned int(1) unsigned (NULL) NO 0 select,insert,update,references
lastlogin timestamp (NULL) NO 0000-00-00 00:00:00 select,insert,update,references
lastip varchar(15) utf8_unicode_ci NO select,insert,update,references
email varchar(50) utf8_unicode_ci NO select,insert,update,references
flags int(11) unsigned (NULL) NO 0 select,insert,update,references
forceLanguage varchar(5) utf8_unicode_ci NO enGB select,insert,update,references
muted int(30) (NULL) NO 0 select,insert,update,references
/*Index Information For - character.accounts*/
----------------------------------------------
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
-------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ------- -------------
accounts 0 PRIMARY 1 acct A (NULL) (NULL) (NULL) BTREE
accounts 0 PRIMARY 2 login A 1 (NULL) (NULL) BTREE
accounts 0 acct 1 acct A 1 (NULL) (NULL) BTREE
/*DDL Information For - character.accounts*/
--------------------------------------------
Table Create Table
-------- -------------------------------------------------------------------------------
accounts CREATE TABLE `accounts` (
`acct` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(28) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`gm` varchar(27) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`banned` int(1) unsigned NOT NULL DEFAULT '0',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`flags` int(11) unsigned NOT NULL DEFAULT '0',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enGB',
`muted` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`acct`,`login`),
UNIQUE KEY `acct` (`acct`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
i have completely diff schematicsQuote:
Originally Posted by ziddy1232
try using my account table..
so delete yours and replace it with this one
accounts.zip - 0.7 Kb
argh!!!
Still getting the same error, even with your accounts table!
Quote:
Originally Posted by ziddy1232
GAH!! man i was hoping that would fix the problem.
ther eis somethign wrong with your account table i am sure of it.
can you please post a pic of variables in OBJECT again with my new table instaled?
This is the objects tab with your accounts table:
PHP Code:/*Column Information For - character.accounts*/
-----------------------------------------------
Field Type Collation Null Key Default Extra Privileges Comment
------------- ------------------- --------------- ------ ------ ------------------- -------------- ------------------------------- ----------------------
acct int(10) unsigned (NULL) NO PRI (NULL) auto_increment select,insert,update,references Unique ID
login varchar(32) utf8_unicode_ci NO UNI (NULL) select,insert,update,references Login username
password varchar(32) utf8_unicode_ci NO (NULL) select,insert,update,references Login password
gm varchar(32) utf8_unicode_ci NO select,insert,update,references Game permissions
banned tinyint(3) unsigned (NULL) NO 0 select,insert,update,references Account Standing
lastlogin timestamp (NULL) NO 0000-00-00 00:00:00 select,insert,update,references Last login timestamp
lastip varchar(16) utf8_unicode_ci NO select,insert,update,references Last remote address
email varchar(64) utf8_unicode_ci NO select,insert,update,references Contact e-mail address
flags tinyint(3) unsigned (NULL) NO 0 select,insert,update,references Client flags
forceLanguage varchar(5) utf8_unicode_ci NO enUS select,insert,update,references
muted int(30) (NULL) NO 0 select,insert,update,references
/*Index Information For - character.accounts*/
----------------------------------------------
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
-------- ---------- -------- ------------ ----------- --------- ----------- -------- ------ ------ ---------- ------- -------------
accounts 0 PRIMARY 1 acct A 0 (NULL) (NULL) BTREE
accounts 0 a 1 login A 0 (NULL) (NULL) BTREE
/*DDL Information For - character.accounts*/
--------------------------------------------
Table Create Table
-------- ------------------------------------------------------------------------------------------------------------------
accounts CREATE TABLE `accounts` (
`acct` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique ID',
`login` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login username',
`password` varchar(32) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Login password',
`gm` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Game permissions',
`banned` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Standing',
`lastlogin` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
`lastip` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Last remote address',
`email` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Contact e-mail address',
`flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Client flags',
`forceLanguage` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enUS',
`muted` int(30) NOT NULL DEFAULT '0',
PRIMARY KEY (`acct`),
UNIQUE KEY `a` (`login`)
) ENGINE=MyISAM AUTO_INCREMENT=672388 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information'
Quote:
Originally Posted by ziddy1232
ok i know why it doesnt work now.
i ran few test and got the same error msg
you must remove ALLOW NULL from LOGIN and PASSWORD under DEFAULT COLLUMN ONLY! Dont change anything else. Only under DEFAULT COLLUMN
the only (NULL) you must have is on ACCount