|
You last visited: Today at 12:33
Advertisement
VIP Subscription System
Discussion on VIP Subscription System within the CO2 PServer Guides & Releases forum part of the CO2 Private Server category.
09/17/2013, 06:59
|
#16
|
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 946
|
Also you don't need to call both Close() and Dispose() since Dispose() is already calling Close().
Also take a look at this:
|
|
|
09/17/2013, 11:21
|
#17
|
elite*gold: 0
Join Date: Jun 2007
Posts: 96
Received Thanks: 12
|
this is not the best way to do it,
you can just add one more column in entities table called VIPEndTime and do a small check in player login if the VIPEndTime grater than the actual time add the viplevel else reset the VIPLevel column to zero.
|
|
|
09/17/2013, 13:35
|
#18
|
elite*gold: 1142
Join Date: Aug 2006
Posts: 2,464
Received Thanks: 1,161
|
Quote:
Originally Posted by atef201080
this is not the best way to do it,
you can just add one more column in entities table called VIPEndTime and do a small check in player login if the VIPEndTime grater than the actual time add the viplevel else reset the VIPLevel column to zero.
|
No..
Have a seperate table, that's correct. A good way to do it would be
id - user - type - end
Where 'type' is the VIP type, if you want to add different levels of it. To grab the VIP, simply do
Quote:
SELECT type, end FROM VIP WHERE user={The_Entity_UID}
|
To clear VIP field, perhaps once a day
Quote:
DELETE FROM VIP WHERE end > CURDATE()
|
To extend VIP time
Quote:
UPDATE VIP SET end = DATE_ADD(`end` , INTERVAL 30 DAY) WHERE user={The_Entity_UID}
|
|
|
|
09/17/2013, 13:48
|
#19
|
elite*gold: 0
Join Date: Jul 2008
Posts: 874
Received Thanks: 239
|
Quote:
Originally Posted by atef201080
this is not the best way to do it,
you can just add one more column in entities table called VIPEndTime and do a small check in player login if the VIPEndTime grater than the actual time add the viplevel else reset the VIPLevel column to zero.
|
why to add where there r codes could do the job
PHP Code:
if (DateTime.Now > client.VIPInformation.SuscribtionDate.AddDays(client.VIPInformation.Days)) { client.Send(new Conquer_Online_Server.Network.GamePackets.Message("Your VIP Suscribtion Has Expired", System.Drawing.Color.Red, Message.TopLeft)); // client.SendMessage("Your VIP Suscribtion Has Expired", Message.TopLeft); Database.VipTable.Delete(client.Entity.Name); }
|
|
|
09/19/2013, 04:22
|
#20
|
elite*gold: 0
Join Date: Aug 2013
Posts: 7
Received Thanks: 0
|
TY Bro. Nice One
|
|
|
09/19/2013, 04:58
|
#21
|
elite*gold: 12
Join Date: Jul 2011
Posts: 8,211
Received Thanks: 4,114
|
I've fixed the spelling error in the title of your thread.
"VIP Suscribtion System" -> "VIP Subscription System"
|
|
|
09/19/2013, 05:09
|
#22
|
elite*gold: 0
Join Date: Aug 2007
Posts: 1,525
Received Thanks: 230
|
Thx Fang for doing that ... anyways ill Improve the Upper codes and update the Thread ASAP .. but after i Finish Learning MYSQL .. i never throught its thats fun and very easy to learn
|
|
|
09/19/2013, 05:18
|
#23
|
elite*gold: 12
Join Date: Jul 2011
Posts: 8,211
Received Thanks: 4,114
|
Quote:
Originally Posted by shadowman123
Thx Fang for doing that ... anyways ill Improve the Upper codes and update the Thread ASAP .. but after i Finish Learning MYSQL .. i never throught its thats fun and very easy to learn
|
MySQL is a very useful language to know in game programming and the software industry. If you're thinking about programming as a living (web, client, or server programming), you're on the right track. You should work on some programming language to go with it though. Maybe next you could work on improving your PHP or another high level programming language. If you go with C#, you could get some advice from the community (if they brighten up a bit).
|
|
|
09/19/2013, 05:32
|
#24
|
elite*gold: 0
Join Date: Aug 2007
Posts: 1,525
Received Thanks: 230
|
my goal ATM is Creating the server .. but my Real Life Goal is :-
- Become Professional in C# (im good at C# basics , Studied Sockets for while but havent gone Deep) ..
- Becoming Very Good in using MYSQL , NHiberate Databases (maybe subsonic but i didnt and i wont ever like it)
- Become Very Good At Reverse Engineering (Ollydb as Example)
Once i do those ..ill be Happiest Person in The world
Note : i studied PHP long while ago but havent liked it ... and what i studied was too basic beside that Creating Web Requires More than 1 Language PHP , CSS , HTML5 , Java Scripts , JQuery or w.e which is too much to learn .
|
|
|
09/19/2013, 08:18
|
#25
|
elite*gold: 1142
Join Date: Aug 2006
Posts: 2,464
Received Thanks: 1,161
|
Quote:
Originally Posted by shadowman123
Once i do those ..ill be Happiest Person in The world
Note : i studied PHP long while ago but havent liked it ... and what i studied was too basic beside that Creating Web Requires More than 1 Language PHP , CSS , HTML5 , Java Scripts , JQuery or w.e which is too much to learn .
|
That is why you always team up with someone who does to front-end, and you focus on backend
|
|
|
09/19/2013, 12:14
|
#26
|
elite*gold: 28
Join Date: Jun 2010
Posts: 2,223
Received Thanks: 867
|
Quote:
Originally Posted by shadowman123
my goal ATM is Creating the server .. but my Real Life Goal is :-
- Become Professional in C# (im good at C# basics , Studied Sockets for while but havent gone Deep) ..
- Becoming Very Good in using MYSQL , NHiberate Databases (maybe subsonic but i didnt and i wont ever like it)
- Become Very Good At Reverse Engineering (Ollydb as Example)
Once i do those ..ill be Happiest Person in The world
Note : i studied PHP long while ago but havent liked it ... and what i studied was too basic beside that Creating Web Requires More than 1 Language PHP , CSS , HTML5 , Java Scripts , JQuery or w.e which is too much to learn .
|
Once you have learned your goals it will be years and years, but I admire your courage, it pays off.
|
|
|
09/19/2013, 12:24
|
#27
|
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 946
|
Quote:
Originally Posted by 'Emil
That is why you always team up with someone who does to front-end, and you focus on backend
|
Not necessary. You can do it alone. I've done sites alone many times, it takes 1-3 weeks depending on the type of site. This is for less complex sites tho such as webshops, business websites etc.
|
|
|
09/19/2013, 17:22
|
#28
|
elite*gold: 1142
Join Date: Aug 2006
Posts: 2,464
Received Thanks: 1,161
|
Quote:
Originally Posted by Super Aids
Not necessary. You can do it alone. I've done sites alone many times, it takes 1-3 weeks depending on the type of site. This is for less complex sites tho such as webshops, business websites etc.
|
I've never, ever, met a real good programmer or developer in general that has produced something good when it comes to both design and functionality. There are designers who know how to code, sure, but the end result is not near as good as a real back-end programmer, same goes for the opposite.
When talking front-end, I generally mean everything the user will see, which include design, properly strucured html and valid CSS, responsive and of course SEO-friendly.
And I sure as hell hope you don't mean like setting up a WordPress theme with some lame web shop plugin or w/e it's called. I'm talking proper projects, not 1-3 weeks lol.
|
|
|
09/19/2013, 20:16
|
#29
|
elite*gold: 28
Join Date: Jun 2010
Posts: 2,223
Received Thanks: 867
|
Everybody has their speciality, you cannot be exactly equal, you prefer and/or are better at one or another.
|
|
|
09/19/2013, 20:38
|
#30
|
elite*gold: 0
Join Date: Dec 2012
Posts: 1,761
Received Thanks: 946
|
Quote:
Originally Posted by 'Emil
I've never, ever, met a real good programmer or developer in general that has produced something good when it comes to both design and functionality. There are designers who know how to code, sure, but the end result is not near as good as a real back-end programmer, same goes for the opposite.
When talking front-end, I generally mean everything the user will see, which include design, properly strucured html and valid CSS, responsive and of course SEO-friendly.
And I sure as hell hope you don't mean like setting up a WordPress theme with some lame web shop plugin or w/e it's called. I'm talking proper projects, not 1-3 weeks lol.
|
LOL No. I've never used wordpress. I don't even use such thing, nor do I use PHP anyways. I'm using Ruby on rails, Python + Django and ASP.NET for web only, but anyways this is off topic talk. Stop assuming so much tho, just because you're not capable of doing both. You come off kinda like an *** with an attitude "I'm the best and only webdeveloperin this community."
|
|
|
|
|
Similar Threads
|
Twitch.tv subscription
06/16/2013 - Twitch Trading - 1 Replies
Hi,
da die subscribe Funktion via Paypal in Deutschland nicht funktioniert suche ich nach einem freundlichen User mit Kreditkarte der diese auf meinem twitch.tv Account durchführen könnte für den Channel twitch.tv/sivhd.
Wer auch immer sich bereit erklärt soll natürlich nicht unbelohnt bleiben und kriegt das Geld+einen gewissen Aufschlag überwiesen.
Kontakt:
Skype: malteman3007
|
Best Non-subscription bot
05/27/2013 - Guild Wars 2 - 6 Replies
As the title says I'm looking for a bot that is a one time purchase and not a subscription based bot.
For example:
not GW2 Minion
not Firy
not GW2 ViperBot
not gw2mimic
not MacroGoblin
Thank you for your suggestions
|
[WTS] 60 Day Subscription Card
11/14/2012 - Star Wars: The Old Republic Trading - 0 Replies
I have two for sale. I'm willing to trade for a GW2 account or 16 euros per card.
Let me know if you're interested. I accept paypal.
|
[WTS] Retail acc (EU), still have subscription
05/05/2012 - World of Warcraft Trading - 3 Replies
>.<
|
All times are GMT +2. The time now is 12:33.
|
|