Chumpy's simple regpage and cash shop v1.5 beta

**chumpywumpy** · 07-06-10

To do this you would also need to alter the database to add a new field to save the email address in. I would probably add a whole new table which stores the UserNum or login name (as seen in the cabal_auth_table) and the email address rather than altering an existing table to make sure you don't break anything.

Once that is done look in reg.php (lines 20-27) for the html that creates the form where it asks for the login/pass and add an extra field for the email. Put the new field under the password2 box and before the submit button.

Next look at line 72 where cabal_tool_registerAccount. You need another line underneath to run a second query to insert the email address. Something like "insert into gamedb.dbo.playerEmails $uid,$mail".

It's an easy edit if you know php and sql, not so easy if not.

**detebart** · 07-06-10

not I'm a beginner in php.

could pose for me?

Thank you master

**chumpywumpy** · 08-06-10

I don't actually have the spare time at the moment, i barely have enough free time to visit at the moment (i have been missing for over a week). If you don't mind waitng until later this week i should be able to find a few minutes as i'm pretty much going to have to give you a new reg.php and an sql file.

EDIT: The new reg.php and the SQL for the new table can be download here: http://www.mediafire.com/download.php?mytqlzmnwkn

Run the sql query on the account database to create the cabal_auth_emails table and replace reg.php with the new one.

An email address is required to create an account and it will check that the email format is valid. It will not require email addresses to be unique and it will not do email validation (i.e. send them a mail to confirm the email is real).

Each email address is stored along with the UserNum which matches the UserNum in cabal_auth_table.

I should probably use a proper join for this but you can use the qery below to see UserNum, login name and email where matches are found:

Code:

select cabal_auth_table.UserNum,cabal_auth_table.ID,cabal_auth_emails.email
from cabal_auth_table,cabal_auth_emails
where cabal_auth_table.UserNum=cabal_auth_emails.UserNum

**Patr1ck2** · 29-06-10

thank you so much

**detebart** · 03-07-10

found a critical bug in CashSHop when you click buy, on-screen or not to be clicking again and again appears in purchasing several items, most are discounted only one of alz.

how to solve this?

Excuse my English.

**gpadmin** · 17-07-10

Sorry, someone can share table with items for webshop? i lose my one. Restore data alot of time, someone? Thank you :)

**gpadmin** · 18-07-10

Holyshi.. restore my file :) Someone have nice icons for this shop? share plz also.

**TanGzkie** · 18-07-10

gpadmin

you can do it on your own!..
common sense dude!..
and try to look at your client files!..
look for dds files!.. and convert it!..

**gpadmin** · 18-07-10

Originally Posted by TanGzkie

gpadmin

you can do it on your own!..
common sense dude!..
and try to look at your client files!..
look for dds files!.. and convert it!..

Tnx, got it. Convert files from ..\CABAL Online\Data\UI
but looks like not all icons here. Where i can find icons for bike like example? Its *.ebm format?

**Shadowfox** · 26-07-10

anything i should allready have before i do this? like a website or something

**trungnt88** · 27-07-10

This is already a website, everything you need :

+ Web hosting + domain (with PHP support) >> for online
+ XAMPP or IIS + PHP >> for offline

**kelalung** · 02-08-10

web cashshop has not log out complete yet. I try click symbol x and web log out , but i prevous it , it still do not log out, can you fix? English i speak bad, sorry..
Posted via Mobile Device

**nzamkdh** · 09-08-10

<?php

echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" >';
echo '<HTML><HEAD>';
echo '<title>CABAL Online - The Revolution of Action</title> ';
echo '<meta content="JavaScript" name="vs_defaultClientScript">';
echo '<link title="style" href="./shopstyle.css" type="text/css" rel="stylesheet">';
echo '</HEAD>';
echo '<body bgcolor="#000000;" onLoad="setTimeout(\'loaded()\',500)" id="default">';

if (ini_get('register_globals')!=0) {
echo 'The "register_globals" setting in your php.ini is on. This is a security problem and must be fixed.';
die;
}

include('config.php');

if (TESTMODE==true) echo 'User data='.$_SERVER['QUERY_STRING'].' ';
$v1=$_REQUEST['v1'];
$v2=$_REQUEST['v2'];
$ip=$_SERVER['REMOTE_ADDR'];
if (TESTMODE==true) echo 'v1='.$v1.' v2='.$v2.' IP address: '.$ip.' ';

if (!is_numeric($v1)) die('Hack attempt');
if (!ctype_alnum($v2)) die('Hack attempt');

$link = mssql_connect('MY IP???','My UserName yes?','PWD');
if (!$link) die('Could not connect to MSSQL database.');
$q="select * from ".DB_ACC.".dbo.cabal_auth_table where UserNum='".$v1."'and AuthKey='".$v2."'";
if (IPVALIDATION==true) $q=$q." and LastIp='".$ip."'";
$r=mssql_query($q);
if (mssql_num_rows($r)==1) {
if (TESTMODE==true) echo 'Found user ok ';
} else {
die('You are not a valid user');
}
$row = mssql_fetch_row($r);
$name=$row[1];
if (TESTMODE==true) echo 'Name='.$name.' ';

$r=mssql_query("exec ".DB_CSH.".dbo.getbankalz '".$v1."'");
if (mssql_num_rows($r)==0) {
die('Could not get Warehouse Alz');
} else {
if (TESTMODE==true) echo 'Found Alz ok ';
}
$row = mssql_fetch_row($r);
$alz=$row[1];
if (TESTMODE==true) echo 'Alz='.$alz.'';

if (isset($_REQUEST['tab'])) {
$tab=$_REQUEST['tab'];
if (!is_numeric($tab)) die('Hack attempt');
} else {
$tab='1';
}

$is_gm=false;
$r=mssql_query('select * from '.DB_GAM.'.dbo.cabal_character_table where CharacterIdx between '.$v1.' * 8 and '.$v1.' * 8 + 5 and nation=3');
if (mssql_num_rows($r)>0) $is_gm=true;
if (MAINTMODE==true and $is_gm==false) die ('Maintenance mode is active.');

echo '<div id="wrapper" style=display:none>';

echo '<form name="Default" method="post" action="webshop.php" id="Default">';

-----------------------------------
have other change?? please help

**emi** · 09-08-10

no,that's all.

**wesley2811** · 10-08-10

Originally Posted by trungnt88

This is already a website, everything you need :

+ Web hosting + domain (with PHP support) >> for online
+ XAMPP or IIS + PHP >> for offline

i gues your wrong i can host website with XAMPP other ppl can see it

---------- Post added at 06:36 AM ---------- Previous post was at 06:25 AM ----------

Originally Posted by chumpywumpy

I don't actually have the spare time at the moment, i barely have enough free time to visit at the moment (i have been missing for over a week). If you don't mind waitng until later this week i should be able to find a few minutes as i'm pretty much going to have to give you a new reg.php and an sql file.

EDIT: The new reg.php and the SQL for the new table can be download here: regpagemod.7z

Run the sql query on the account database to create the cabal_auth_emails table and replace reg.php with the new one.

An email address is required to create an account and it will check that the email format is valid. It will not require email addresses to be unique and it will not do email validation (i.e. send them a mail to confirm the email is real).

Each email address is stored along with the UserNum which matches the UserNum in cabal_auth_table.

I should probably use a proper join for this but you can use the qery below to see UserNum, login name and email where matches are found:

Code:

select cabal_auth_table.UserNum,cabal_auth_table.ID,cabal_auth_emails.email
from cabal_auth_table,cabal_auth_emails
where cabal_auth_table.UserNum=cabal_auth_emails.UserNum

Chumpy how do i set than can onlie do 1 account on 1 email adress
would be awsome so if 1 email got an account already thay need other email to register

**mophisto** · 02-09-10

hy.
i have problem.
I use this release but the xampp server show me:

Code:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.1.68 in C:\xampp\xampp\htdocs\index.php on line 26
Could not connect to MSSQL database

This is my php.ini file detail :

Code:

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
extension=php_dblib.dll
extension=php_mbstring.dll
extension=php_exif.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
extension=php_imap.dll
;extension=php_interbase_firebird.dll
;extension=php_interbase_interbase.dll
;extension=php_intl.dll
;extension=php_ldap.dll
extension=php_mcrypt.dll
;extension=php_mssql.dll
;extension=php_mysql_mysqlnd.dll
extension=php_mysql_libmysql.dll
;extension=php_mysqli_mysqlnd.dll
extension=php_mysqli_libmysql.dll
;extension=php_oci8.dll
extension=php_pdo.dll
;extension=php_pdo_dblib.dll
;extension=php_pdo_firebird_firebird.dll
;extension=php_pdo_firebird_interbase.dll
;extension=php_pdo_mssql.dll
;extension=php_pdo_mysql_mysqlnd.dll
extension=php_pdo_mysql_libmysql.dll
extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
;extension=php_pdo_sqlite_external.dll
;extension=php_pgsql.dll
;extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
extension=php_soap.dll
extension=php_sockets.dll
extension=php_sqlite.dll
extension=php_sqlite3.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_zip.dll
extension=php_mssql.dll
extension=php_msql.dll

previously been done and now I do not understand why it does not work

**Lindy28** · 19-10-10

Hello,
everything works great, but i have one Problem .
I set a wrong idea for a bike in Cash Shop and i bought it. And now its in my cash inventory but i cant recieve it because of the idx which i set 0.
Which 31 it works but how can i make the cash inventory empty?-

sorry for bad english :D

**chumpywumpy** · 19-10-10

Check my sig for my gm tools (either 0.6x or 2.0 alpha) as both have a way of clearing bugged items from the cabalcash inventory ;)

**shockbaby** · 20-10-10

Im using hamachi to let my friends connect to my server

// MSSQL server connection details
// Database server
define('DB_ADDR','XXX???');
// Database login
define('DB_USER','sample');
// Database password
define('DB_PASS','sample');

That mssql database login id is sa and password is the password that I key in on installation progress right?
But how about database server DB_ADDR??
Its localhost or 192.168.1.1 or 192.168.1.7 ( CentOS ) or Hamachi ip ??

Erm...is there any way to make account manually?
Like edit from mssql??

**chumpywumpy** · 20-10-10

If the webserver is on the same machine as mssql then you should either the windows IP x.x.1.1 so it connects directly rather than going through hamachi. The user/pass would be your "sa" lgin unless you have another set up in sql.

To create accounts you can use my gm tools, the regpage that comes with the cash shop or run the cabal_tool_registerAccount stored proc in SQL directly (account db):

exec cabal_tool_registerAccount 'username','password'

**aerolite** · 30-01-11

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 205.185.113.57 in /home/serverfa/public_html/serverfactor.net/cabal/index.php on line 26
Could not connect to MSSQL database.

I have my Cabal Online and Client working. But the my website shows this error http://serverfactor.net/cabal/

**Jaynno** · 30-01-11

Originally Posted by aerolite

I have my Cabal Online and Client working. But the my website shows this error http://serverfactor.net/cabal/

probably a problem in your php.

**aerolite** · 30-01-11

The files I change was

// MSSQL server connection details
// Database server
define('DB_ADDR','myssqlIP');
// Database login
define('DB_USER','myssqlUser(sa)');
// Database password
define('DB_PASS','myssqlPassword');

I use the same information in my cabal_config, and my Cabal is running fine. Are there any more files i have to edit? in able for this to work?

Also, I'm using the GM Tool Kit and it's working fine. but this panel won't work... any ideas please?

**emi** · 30-01-11

Are you sure you did everything good in config sql?Also make sure there is no firewall which blocks the port 1433.It's worth double checking the login.

**aerolite** · 30-01-11

Originally Posted by emi

Are you sure you did everything good in config sql?Also make sure there is no firewall which blocks the port 1433.It's worth double checking the login.

I turn of the firewall for the test purpose so I belive that that isn't the problem. I'm sure 100% that I use the same login and password for my cabal and this website. I'm thinking of the website might blocking my cabal?

Chumpy's simple regpage and cash shop v1.5 beta

Thread Tools

Search Thread

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Re: Chumpy's simple regpage and cash shop v1.5 beta

Advertisement