Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → 3d Party Tools → how to make pvpgn web registration ?

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 11

1 (edited by Jimmy_Aquarius 21.11.2012 15:50)

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

2

Re: how to make pvpgn web registration ?

https://github.com/pvpgn/phputils/tree/ … ebregister

Do not ask for support in PM.

3

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.

4

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

5

Re: how to make pvpgn web registration ?

Replace TYPE=MyISAM with ENGINE=MyISAM

Do not ask for support in PM.

6

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

7

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.

8

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 hmm

9

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_ci
Do not ask for support in PM.

10

Re: how to make pvpgn web registration ?

Manually add the table (pvpgn_BNET) works fine!

Error: MySQL said: Unknown column 'uid' in 'field list'

PunBB bbcode test

But I do not know the contents of the table

Can help me with an image, to add this manual.

11

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.

Posts: 11

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 0 guests, 0 registered users

forums.pvpgn.pro → 3d Party Tools → how to make pvpgn web registration ?



Generated in 0.082 seconds (80% PHP - 20% DB) with 22 queries