Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] Linkos MU Online Website 2.0

Junior Spellweaver
Joined
Oct 22, 2007
Messages
109
Reaction score
4
First of all - Love the guide!

Second... Having some problem.

SQL:
"Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'Resets' in table 'character' is specified more than once."
One of few errors I get when trying to insert them in SQL "MuOnline".

I've inserted them one by one as you mentioned.
What have I done wrong?

Webpage:
"Notice: Undefined variable: shopy in C:\xampp\htdocs\index.php on line 96" (one of all)
and
"Fatal error: Call to undefined function mssql_result() in C:\xampp\htdocs\index.php on line 109"

I run the zteam season 8 ep2 server and xampp v3.2.2.
Windows 10 x64

SQL mean that you have them , and for other error look at post #10
 
Experienced Elementalist
Joined
Mar 18, 2012
Messages
255
Reaction score
20
I have this problem
Deprecated: Function eregi() is deprecated in C:\xampp\htdocs\_modules_\register.php on line 43

Your account has been successfully created on 2015-11-17 20:57:38.
When i register i got that message
 
Junior Spellweaver
Joined
Oct 22, 2007
Messages
109
Reaction score
4
Don't follow, what do you mean with post #10 ?
I've have properly edit the config, at least think so.

But the error about undefined variable means that index.php don't include the shopy.config.php?

In post 10 for that " Please make sure you edit properly the config file shopy.config.php." and "The PHP version required is the one enclosed within XAMPP 1.7.1 or above. MSSQL version required: 2000 or above."
 
Newbie Spellweaver
Joined
Nov 17, 2015
Messages
5
Reaction score
0
In post 10 for that " Please make sure you edit properly the config file shopy.config.php." and "The PHP version required is the one enclosed within XAMPP 1.7.1 or above. MSSQL version required: 2000 or above."

Yeah, I read that one. I use a higher version of both. Xampp 3.2.2 and MSSQL 2008.
And the config ser should be right, tried different ports and ip. But still the same error..

Ip I tried: 127.0.0.1, 192.168.0.104
Port: 50530, 1443

I run the server local only.
I saw that the SQL add query went wrong somewhere, couldn't open webshop tables, fixed now!
 
Junior Spellweaver
Joined
Oct 22, 2007
Messages
109
Reaction score
4
Yeah, I read that one. I use a higher version of both. Xampp 3.2.2 and MSSQL 2008.
And the config ser should be right, tried different ports and ip. But still the same error..

Ip I tried: 127.0.0.1, 192.168.0.104
Port: 50530, 1443

I run the server local only.
I saw that the SQL add query went wrong somewhere, couldn't open webshop tables, fixed now!

well try with xampp 1.7.1 and local ip with computer name
 
Newbie Spellweaver
Joined
Nov 17, 2015
Messages
5
Reaction score
0
well try with xampp 1.7.1 and local ip with computer name

How would that look?
192.168.0.104 is THIS computer
Or ju mean localhost PC-NAME ?



Well, I installed 1.7.1 and now I get this "A conntection with the server cannot be established!"


Haha!

Used query in mssql to see what ip:port the server used. Got 192.168.0.104:1433!
Still get the same error.
 
Junior Spellweaver
Joined
Oct 22, 2007
Messages
109
Reaction score
4
How would that look?
192.168.0.104 is THIS computer
Or ju mean localhost PC-NAME ?



Well, I installed 1.7.1 and now I get this "A conntection with the server cannot be established!"


Haha!

Used query in mssql to see what ip:port the server used. Got 192.168.0.104:1433!
Still get the same error.

yes, but only PC-NAME
 
Junior Spellweaver
Joined
Oct 22, 2007
Messages
109
Reaction score
4
Here is WORKING site
linkos - [Release] Linkos MU Online Website 2.0 - RaGEZONE Forums


well, need some more modules, but it`s Working!!!
P.S. I installed this web only for test to see if really work, now i`ll delete it, so if you are wonder how to make it work, follow step by steb guide from Linkos, and that is all!!!
 
Experienced Elementalist
Joined
Mar 18, 2012
Messages
255
Reaction score
20
Bro how did u solved the webshop ? i have warehouse problem when ever i purchase anything from webshop it say u dont have a warehose :/
 
Banned
Banned
Joined
Nov 9, 2015
Messages
307
Reaction score
40
Bro how did u solved the webshop ? i have warehouse problem when ever i purchase anything from webshop it say u dont have a warehose :/
If you created a New character, you have to go in game and open warehouse once.
Or check configuration of Database
 
Experienced Elementalist
Joined
Mar 18, 2012
Messages
255
Reaction score
20
If you created a New character, you have to go in game and open warehouse once.
Or check configuration of Database
thanks bro and when i install db

with some of them im getting error like this
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'WebShop_UI' in the database.
Msg 1779, Level 16, State 0, Line 1
Table 'WebShop_UI' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 1
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'cansellitem' in table 'WebShop' is specified more than once.
 
Junior Spellweaver
Joined
Jan 21, 2010
Messages
101
Reaction score
9
Please no body will help me ?

Here's Linkos MU Vote Reward System: View attachment Linkos MU Vote Reward.rar

Installation is simple:

1. Edit your SQL server login and password in config.php
2. Execute queries from the installation text file;
3. Open your "MuOnline" database with "SQL Enterprise Manager";
4. Open the tables tree (click on "Tables");
5. Scroll down until you find the table called "Votes";
6. Right click on "Votes" then click on "Return all rows";
7. Guide on how to fill in the rows to add a vote button in the vote reward system:
7.1 id - Number of the banner (1,2,3,4 .. etc.);
7.2 link - Insert your vote link;
7.3 banner - Insert your link for the banner image;
7.4 credits - Insert the number of credits you would like your users to get from voting (5, 10, 20 .. etc.);
7.5 vote_time - Time until user can vote again in seconds. For 12 hours the value is 43200;
7.6 show - Value to show or hide the banner you entered (1 = show banner in vote system; 0 = hide banner from the vote system);

I hope that helps.
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Apr 30, 2017
Messages
6
Reaction score
0
Here's Linkos MU Vote Reward System: View attachment 156719

Installation is simple:

1. Edit your SQL server login and password in config.php
2. Execute queries from the installation text file;
3. Open your "MuOnline" database with "SQL Enterprise Manager";
4. Open the tables tree (click on "Tables");
5. Scroll down until you find the table called "Votes";
6. Right click on "Votes" then click on "Return all rows";
7. Guide on how to fill in the rows to add a vote button in the vote reward system:
7.1 id - Number of the banner (1,2,3,4 .. etc.);
7.2 link - Insert your vote link;
7.3 banner - Insert your link for the banner image;
7.4 credits - Insert the number of credits you would like your users to get from voting (5, 10, 20 .. etc.);
7.5 vote_time - Time until user can vote again in seconds. For 12 hours the value is 43200;
7.6 show - Value to show or hide the banner you entered (1 = show banner in vote system; 0 = hide banner from the vote system);

I hope that helps.

Linkos prodrias help with your guide I understood well but I stayed in 7.1 to 7.5 could deepen and let me tell you that you have done an excellent job in very good in this
 
Back
Top