Topic: how to make pvpgn web registration ?
how to make pvpgn web registration ?
so if someone create account from website, it will integrate to the database ?
ex :
battle-id.net/register << PvPGN web registration system
1 21.11.2012 15:46 (edited by Jimmy_Aquarius 21.11.2012 15:50)
- HarpyWar
- Developer
- Offline
Re: how to make pvpgn web registration ?
https://github.com/pvpgn/phputils/tree/ … ebregister
Do not ask for support in PM.
Re: how to make pvpgn web registration ?
Where find a tutorial step by step.
I'm new and I do not understand much.
I have a server and hosting separately.
I appreciate the help.
Re: how to make pvpgn web registration ?
Error to import sql file!
SQL query:
CREATE TABLE awaiting_activation (
uid int(11) NOT NULL default '0',
acct_username varchar(32) default NULL,
acct_passhash1 varchar(128) default NULL,
acct_email varchar(128) default NULL,
webacct_creation_time int(11) default NULL,
webacct_activation_code varchar(32) default NULL,
webacct_lang char(2) default NULL,
PRIMARY KEY (uid)
) TYPE=MyISAM
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10
- HarpyWar
- Developer
- Offline
Re: how to make pvpgn web registration ?
Replace TYPE=MyISAM with ENGINE=MyISAM
Do not ask for support in PM.
Re: how to make pvpgn web registration ?
Thank you very much solved.
I have another problem:
MySQL Error: Could not connect to the database.
MySQL said: Access denied for user '' @ 'localhost' (using password: NO)
PvPGN Web Registration System v0.4 by U-238 and fixex byBeNBeN
- HarpyWar
- Developer
- Offline
Re: how to make pvpgn web registration ?
This is a common issue. Check your database connection settings in config.php
Do not ask for support in PM.
Re: how to make pvpgn web registration ?
The solution to connect with data base is :
$dbhost = "localhost"; // MySQL Database Hostname
Works Fine!
-
but i have other problem:
MySQL Error: Could not read data from the database.
MySQL said: Table 'nutrici_database.pvpgn_BNET' doesn't exist
-
$dbname = "nutrici_database"; // MySQL Database Name
i cant create database with name pvpgn, only with nutrici_, all data allowed in host.
Please help me 
- HarpyWar
- Developer
- Offline
Re: how to make pvpgn web registration ?
This webregister was designed to work with tables started with "pvpgn_" prefix. This prefix can be set up for pvpgn server in database connection settings of bnetd.conf.
Fastest solution is rename tables in your database with that prefix and update it in bnetd.conf.
But if you want, instead you can replace table names over all the code of webregister files.
For instance, one of many places where it should be replaced https://github.com/pvpgn/phputils/blob/ … te.php#L68
If your database contains a table 'nutrici_database.pvpgn_BNET' but the error still occurs, then it may mean that your database server is configured with case-sensitive table names, and table names in your database are in lower case. It can be fixed by setting in mysql.ini:
collation-server = utf8_general_ciDo not ask for support in PM.
Re: how to make pvpgn web registration ?
Manually add the table (pvpgn_BNET) works fine!
Error: MySQL said: Unknown column 'uid' in 'field list'
But I do not know the contents of the table
Can help me with an image, to add this manual.
- HarpyWar
- Developer
- Offline
Re: how to make pvpgn web registration ?
pvpgn can create new tables with a structure in empty a database on first start. But you have to remove that empty table that you created first.
For existing pvpgn server you just need to rename existing tables. This is not a place where I should explain such basic things how to work with mysql, withal most GUI mysql clients can rename tables.
Do not ask for support in PM.
- Dante
- member
- Offline
Re: how to make pvpgn web registration ?
HarpyWar wrote:
pvpgn can create new tables with a structure in empty a database on first start. But you have to remove that empty table that you created first.
For existing pvpgn server you just need to rename existing tables. This is not a place where I should explain such basic things how to work with mysql, withal most GUI mysql clients can rename tables.
help please in next error
regards
- HarpyWar
- Developer
- Offline
Re: how to make pvpgn web registration ?
This script was wrote for old PHP4 where such notifications were disabled by default.
You can fix the script by adding checking for exist variable on that lines:
45: if ( isset($_GET['lang']) ) {
...
if ( isset($_GET['adminmakeacct']) ) {or add at beginning of the script the following to supress warnings:
error_reporting(0);php.net/manual/ru/function.error-reporting.php
Do not ask for support in PM.
